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
38 ccid_0041 Collaborative Climate Action Across the Air Transport World mainly mitigation transport https://climateaction.unfccc.int/views/cooperative-initiative-details.html?id=21   https://www.icao.int/newsroom/pages/collaborative-aviation-climate-action-takes-flight.aspx 2014 Improve air transport fuel efficiency and stabilize the sector's net CO2 emissions from 2020                         SDG explicitly mentioned         stabilize the sector’s net CO2 emissions from 2020 halve net CO2 emissions by 2050 compared to 2005 levels. Up to a 10% fuel efficiency gain for each new type of developed from 2020, relative to the average of current production aircraft types.         Around 40% of current production aeroplane type designs need to improve to meet the standard.       ["Albania", "Armenia", "Australia", "Austria", "Azerbaijan", "Belgium", "Bosnia and Herzegovina", "Botswana", "Bulgaria", "Burkina Faso", "Canada", "China", "Costa Rica", "Croatia", "Cyprus", "Czechia", "Denmark", "El Salvador", "Estonia", "Finland", "France", "Gabon", "Georgia", "Germany", "Greece", "Guatemala", "Hungary", "Iceland", "Indonesia", "Ireland", "Israel", "Italy", "Jamaica", "Japan", "Kenya", "Latvia", "Lithuania", "Luxembourg", "Malaysia", "Malta", "Marshall Islands (the)", "Mexico", "Monaco", "Montenegro", "Namibia", "Netherlands (the)", "New Zealand", "Nigeria", "Norway", "Papua New Guinea", "Poland", "Portugal", "Qatar", "Korea (the Republic of)", "Moldova (the Republic of)", "Romania", "San Marino", "Saudi Arabia", "Serbia", "Singapore", "Slovakia", "Spain", "Slovenia", "Sweden", "Switzerland", "Thailand", "Republic of North Macedonia", "Turkey", "Ukraine", "United Arab Emirates (the)", "United Kingdom of Great Britain and Northern Ireland (the)", "United States of America (the)", "None"]   ["International Civil Aviation Organization (ICAO)", "Air Transport Action Group (ATAG)"] [International Civil Aviation Organization (ICAO)]_ior_int,[Air Transport Action Group (ATAG)_bus_int {"ior": ["International Civil Aviation Organization (ICAO)"], "bus": ["Air Transport Action Group (ATAG)"]}