testToSQLite

Custom SQL query returning 1 row (show)

Query parameters

rowidX_ccid_idInitiative_NameMain_climate_policy_focusY_Thematic_areaView_initiative_on_UNFCCC_Global_Climate_Action_portalView_initiative_on_UNEP_DTU_Climate_Initiatives_PlatformWebsiteLaunch_yearDescriptionY_SDG1Y_SDG2Y_SDG3Y_SDG4Y_SDG5Y_SDG6Y_SDG7Y_SDG8Y_SDG9Y_SDG10Y_SDG11Y_SDG12Y_SDG13Y_SDG14Y_SDG15Y_SDG16Y_SDG17Targets_Emissions_reductionTargets_Energy_efficiencyTargets_Renewable_energyTargets_Number_people_number_countriesTargets_Number_organizations_newly_engagedTargets_Areas_protected_improved_or_restoredTargets_in_market_shares_sales_scaleTargets_Funds_to_be_mobilizedTargets_OtherY_Apply_10_to_Targets_Print_TargetsY_display_country_namesCountries_where_activity_is_planned_or_ongoingY_Print_ActorName_only_FundersY_Print_ActorName_only_Lead_partnersY_Print_ActorName_by_ActorType_ParticipantsY_Participants1Y_Participants2Y_Participants3Y_Participants4Y_Participants5Y_Participants6Y_Participants7Y_Participants8ParticipantNames_National_governmentsParticipantNames_Subnational_and_regional_governmentsParticipantNames_BusinessesParticipantNames_InvestorsParticipantNames_Domestic_NGOsParticipantNames_International_NGOsParticipantNames_Academic_educational_institutionsParticipantNames_International_organizationsParticipantNames_Other_organizations
287 ccid_0405 Global Partnership for Plant Conservation Nature-based solutions land use, oceans and coastal zones, water     https://www.cbd.int/gbo5/plant-conservation-report-2020 2002 The Convention on Biological Diversity (CBD) entered into force on 29 December 1993. It has 3 main objectives: (1) The conservation of biological diversity (2) The sustainable use of the components of biological diversity (3) The fair and equitable sharing of the benefits arising out of the utilization of genetic resources   SDG explicitly mentioned       SDG explicitly mentioned             SDG explicitly mentioned SDG explicitly mentioned SDG explicitly mentioned   SDG explicitly mentioned           [Complete a global assessment of the conservation status of all known plant species by 2020; Secure and restore 15 per cent of each ecological region or vegetation type by 2020; Protect at least 75 per cent of the most important areas for plant diversity of each ecological region protected by 2020; Achieve effective management of at least 75 per cent of production land in each sector by 2020; Conserve at least 75 per cent of known threatened plant species in situ by 2020; Collect samples of at least 75 per cent of threatened plant species from each country for recovery and restoration programs by 2020; Conserve 70 per cent of genetic diversity of crops and other socioeconomically valuable plant species by 2020; Develop effective management plans to prevent new biological invasions by 2020; End the endangerment of wild flora in international trade by 2020]     [Create an online flora of all known plants by 2020; Develop a global level methodology towards the full implementation of the strategy; Sustainably source all wild harvested plant products; Facilitate Indigenous and local knowledge innovations and practice associated with plant resources; Develop a public education and communication strategy to advocate for the importance of plant conservation; Establish training programs and facilities for people at the national level; Strengthen institutions, networks, or partnerships at the national, regional, and international levels to achieve Strategy targets]   ["Argentina", "Australia", "Austria", "Bahamas (the)", "Bangladesh", "Belgium", "Belize", "Benin", "Bhutan", "Bolivia (Plurinational State of)", "Bosnia and Herzegovina", "Botswana", "Brazil", "Bulgaria", "Cambodia", "Cameroon", "Canada", "Central African Republic (the)", "Chile", "China", "Colombia", "Comoros (the)", "Costa Rica", "Croatia", "Cuba", "Cyprus", "Denmark", "Dominican Republic (the)", "Ecuador", "Egypt", "Equatorial Guinea", "Estonia", "Ethiopia", "Finland", "France", "France", "Germany", "Ghana", "Guatemala", "Guinea", "Guinea-Bissau", "Haiti", "Honduras", "India", "Indonesia", "Iran (Islamic Republic of)", "Ireland", "Italy", "Japan", "Kuwait", "Latvia", "None", "Lithuania", "Madagascar", "Maldives", "Malta", "Mauritania", "Mexico", "Mongolia", "Montenegro", "Morocco", "Mozambique", "Myanmar", "Namibia", "New Zealand", "Nigeria", "Republic of North Macedonia", "Norway", "Oman", "Pakistan", "Panama", "Philippines (the)", "Poland", "Korea (the Republic of)", "Moldova (the Republic of)", "Russian Federation (the)", "Saint Lucia", "Saudi Arabia", "Senegal", "Serbia", "Seychelles", "Singapore", "Slovakia", "Slovenia", "Somalia", "South Africa", "South Sudan", "Spain", "Sri Lanka", "Suriname", "None", "Thailand", "Togo", "Tonga", "Trinidad and Tobago", "Tunisia", "Turkey", "United Kingdom of Great Britain and Northern Ireland (the)", "Venezuela (Bolivarian Republic of)", "Viet Nam", "Zambia", "Zimbabwe"]   ["Convention on Biological Diversity"] [Convention on Biological Diversity]_ior_int {"ngv": ["Ministerio de Ambiente y Desarollo Sustenable", "Federal Ministry for Climate Action", "Ministry of the Environment and Housing", " Forest and Climate Change", " and Sustainable Development", "National Environment Commission", "Ministerio de Medio Ambiente y Agua", "Department of Forestry and Range Resources", "Ministry of Environment", "Ministere de l Environnement et du Developpement durable", "Ministerio del Medio Ambiente", "Ministry of Ecology and Environment", "Ministerio de Ambiente y Desarrollo Sostenible", "Ministere de l Agriculture de la Peche et de l Environnement", "Ministerio de Ambiente y Energia", "State Institute for Nature Protection", " and Environment", " and Environment", "Ministry of Environment and Food", "Ministerio Medio Ambiente y Recursos Naturales", "Ministerio del Ambiente y Agua", "Egyptian Environmental Affairs Agency (EEAA)", "Delegacion Regional de Bata", "Ministere de la Transition ecologique", "Federal Agency for Nature Conservation", "Ministere de l Environnement", " Forest and Climate Change", "Ministry of Environment and Forestry", "Ministry of the Environment", "Environment Public Authority", "Ministry of Environment", "Ministere de l Environnement de l Ecologie et des Forests", "Ministry of Environment", "Environment and Resources Authority", "Ministere de l Environnement et du Developpement Durable", "Ministry of Spatial Planning and Environment", "Ministry of Agriculture and Food Safety", "Ministry of Natural Resources and Environmental Conservation", " and Forestry", "Department of Conservation Te Apa Atawhai", "Ministere du Developpement Agricole", "Federal Ministry of Environment", "Norwegian Environment Agency", "Ministry of Environment and Climate Change", "Ministry of Climate Change", "Ministerio de Ambiente", "Ninoy Aquino Parks and Wildlife Center", "Ministry of Climate and Environment", "Rural Development Administration", "Ministry of Environment", "Department of Forestry", "Ministere de l Environnement et du Developpement durable", "Institute for Nature Protection of Vojvodina Province", "Seychelles National Parks Authority", "National Parks Board", "State Nature Conservancy", "Ministry of the Environment and Spatial Planning", "Directorate of Environment and Climate Change", " Forestry and Fisheries", "Ministry of Environment and Forestry", "Ministerio para la Transicion Ecologica y el Reto Demografico", "Ministry of Environment", "Ministry of Local Administration and Environment", "Office of Natural Resources and Environmental Policy Planning", " Climate Change and Communications (MEIDECC)", "Ministry of Planning and Development", "Ministere de l Environment", "Ministry of Agriculture and Forestry", "Department for Environment Food and Rural Affairs", "Joint Nature Conservation Committee (JNCC"], "edu": ["Australian National Botanic Gardens", "National Botanic Garden of Belgium", "Laboratoire de Botanique et Ecologie Vegetale", "University of Sarajevo", "Rio de Janeiro Botanical Garden", "Institute of Biodiversity and Ecosystem Research at Bulgarian Academy of Science", "Royal Botanic Gardens", "State Institute for Nature Protection", "Estonian University of Life Sciences", "Ethiopian Biodiversity Institute", "Finnish Museum of Natural History", "Museum National d Histoire Naturelle", "Council for Scientific and Industrial Research", "Institut de Recherche Agronomique de Guinee (IRAG)", "Lancetilla Botanical Garden", "Indonesia Institute of Sciences", "Research Institute for Forests and Rangelands (RIFR)", "National Botanic Gardens", "Italian Institute for Environmental Protection and Research", "Latvian Society for Botanists", "University of Liberia", "National University of Mongolia", "Nature Historical Museum", "Institut Scientifique", "Korea National Arboretum", "Environmental Research Complex", " Regional Development and Environment (MoARDE)", "Russian Academy of Sciences", "King Saud University", "South African National Biodiversity Institute", "Anton de Kom University of Suriname (AdeKUS)", "Professor of Forestry", "Agricultural Research Centre", "Dr Bucar Indjai", "Missouri Botanical Garden", "Botanical Garden of Tver State University", "Botanischer Garten und Botanisches Museum", "Cadereyta Regional Botanical Garden (CRBG)", "Centre for Plant Conservation", "Chicago Botanic Gardens", "Council of the Heads of Australian Botanic Gardens", "Conservatoire et Jardin botaniques", "Denver Botanic Gardens", "The Earthwatch Institute", "Indonesian Institute of Sciences", "Instituto de Pesquisas Jardim Botanico do Rio de Janeiro", "Jardin Botanico Medellin", "Jardi Botanic de la Universitat de Valencia", "Kings Park and Botanic Gardens", "Museum National d Histoire Naturelle", "National Botanic Gardens Ireland", "New York Botanical Garden", "Nezahat Gokyigit Botanic Garden", "The University of Oxford Botanic Garden", "Plant Conservation and Research Foundation Bangladesh", "University of Costa Rica", "Rede Brasileira de Jardins Botanicos (RBJB)", "Red Nacional de Jardines Botanicos (RBJB)", "Royal Botanical Gardens", "Royal Botanic Gardens Edinburgh", "Royal Botanic Gardens Kew", "Royal Botanic Gardens Victoria", "Smithsonian Institution Natural History Museum", "Society for Economic Botany", "The Morton Arboretum", "United States Botanic Garden", "Whitney R Harris World Ecology Center", "Wuhan Botanic Garden Botanical Institute"], "dng": ["Comision Nacional para el Conocimiento y Uso de Biodiversidad (CONABIO)", "Mexican Association of Botanic Gardens (MABG)", "South African National Biodiversity Institute South Africa (SANBI)"], "unk": ["Joseph Kongatoua Ngbozongo"], "ing": ["Botanic Gardens International (BGCI)", "Asociacion Latinoamericana y del Caribe de Jardines Botanicos", "Australian Seed Bank Partnership", "Biodiversity International", "Canadian Botanical Conservation Network", "Global Biodiversity Foundation", "Global Biodviersity Information Facility (GBIF)", "National Tropical Botanical Garden", "New Zealand Plant Conservation Network", "People and Plants International (PPI)", "Plantlife International and Planta Europa", "Red Latinamericana de Botanica", "Society for Ecological Restoration", "TRAFFIC the Wildlife Monitoring Network", "World Agroforestry Center (ICRAF)", "World Flora Online Consortium", "World Wildlife Fund International (WWF)"], "ior": ["Fauna and Flora International (FFI)", "Food and Agriculture Organization of the United Nations (FAO)", "International Union for the Conservation of Nature (IUCN)", "UNEP World Conservation Monitoring Centre (UNEP WCMC)"], " edu": ["Species 2000"]}