testToSQLite

Custom SQL query returning 1 row (show)

Query parameters

This data as json, CSV

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
45 ccid_0053 Global Geothermal Alliance mainly mitigation energy https://climateaction.unfccc.int/views/cooperative-initiative-details.html?id=32 http://climateinitiativesplatform.org/index.php/Global_Geothermal_Alliance http://www.globalgeothermalalliance.org/ 2015 Achieve five-fold growth in the global installed capacity for geothermal power generation and two-fold growth for geothermal heating by 2030             SDG explicitly mentioned           SDG explicitly mentioned             Five-fold growth in the global installed capacity for geothermal power generation and two-fold growth for geothermal heating by 2030.               ["Argentina", "Bolivia (Plurinational State of)", "Chile", "Colombia", "Comoros (the)", "Costa Rica", "Djibouti", "Egypt", "El Salvador", "Ethiopia", "Fiji", "France", "Germany", "Guatemala", "Honduras", "Iceland", "India", "Indonesia", "Italy", "Japan", "Kenya", "Netherlands (the)", "Malaysia", "Mexico", "Nicaragua", "New Zealand", "Pakistan", "Papua New Guinea", "Peru", "Poland", "Portugal", "Romania", "Saint Vincent and the Grenadines", "Switzerland", "Philippines (the)", "Tanzania, United Republic of", "Solomon Islands", "United States of America (the)", "Tonga", "Turkey", "Uganda", "Vanuatu", "Zambia", "Zimbabwe"]   ["AFDB", "IDB", "Islamic Development Bank", "Nordic Development Fund", "World Bank", "AIDB"] [IRENA]_ior_int {"ngv": ["Argentina", "Bolivia", "Chile", "Colombia", "Comoros", "Costa Rica", "Djibouti", "Egypt", "El Salvador", "Ethiopia", "Fiji", "France", "Germany", "Guatemala", "Honduras", "Iceland", "India", "Indonesia", "Italy", "Japan", "Kenya", "Netherlands", "Malaysia", "Mexico", "Nicaragua", "New Zealand", "Pakistan", "Papua New Guinea", "Peru", "Poland", "Portugal", "Romania", "Saint Vincent & The Grenadines", "Switzerland", "Philipines", "United Republic of Tanzania", "Solomon Islands", "USA", "Tonga", "Turkey", "Uganda", "Vanuatu", "Zambia", "Zimbabwe", "Iceland Geosurvey National Energy Authority"], "ior": ["African Union Commission", "Organization of American States", "Organisation of Eastern Caribbean States", "Regional Center for Renewable Energy and Energy Efficiency", "Pacific Community", "UNEP", "UNIDO"], "bus": ["Association GeoEnergy Celle e.V.", "Canadian Geothermal Energy Association", "CARILEC", "CREIA", "European Geothermal Energy Council", "Geothermal Canada", "GEODEEP", "Geothermal Resources Council", "Geothermal Power Plants Investors Association", "Iceland Geothermal Cluster Initiative", "International Geothermal Association", "Macedonian Geothermal Association"], "edu": ["AGH University of Science and Technology", "Andean Geothermal Center of Excellence", "CeMIEGeo", "Energy Institute Hrvoje Po\u017ear", "Serbian Geological Society", "UNU GTP"]}