testToSQLite

Custom SQL query returning 1 row (hide)

select rowid, X_ccid_id, Initiative_Name, Main_climate_policy_focus, Y_Thematic_area, View_initiative_on_UNFCCC_Global_Climate_Action_portal, View_initiative_on_UNEP_DTU_Climate_Initiatives_Platform, Website, Launch_year, Description, Y_SDG1, Y_SDG2, Y_SDG3, Y_SDG4, Y_SDG5, Y_SDG6, Y_SDG7, Y_SDG8, Y_SDG9, Y_SDG10, Y_SDG11, Y_SDG12, Y_SDG13, Y_SDG14, Y_SDG15, Y_SDG16, Y_SDG17, Targets_Emissions_reduction, Targets_Energy_efficiency, Targets_Renewable_energy, Targets_Number_people_number_countries, Targets_Number_organizations_newly_engaged, Targets_Areas_protected_improved_or_restored, Targets_in_market_shares_sales_scale, Targets_Funds_to_be_mobilized, Targets_Other, Y_Apply_10_to_Targets_Print_Targets, Y_display_country_names, Countries_where_activity_is_planned_or_ongoing, Y_Print_ActorName_only_Funders, Y_Print_ActorName_only_Lead_partners, Y_Print_ActorName_by_ActorType_Participants, Y_Participants1, Y_Participants2, Y_Participants3, Y_Participants4, Y_Participants5, Y_Participants6, Y_Participants7, Y_Participants8, ParticipantNames_National_governments, ParticipantNames_Subnational_and_regional_governments, ParticipantNames_Businesses, ParticipantNames_Investors, ParticipantNames_Domestic_NGOs, ParticipantNames_International_NGOs, ParticipantNames_Academic_educational_institutions, ParticipantNames_International_organizations, ParticipantNames_Other_organizations from stake where "Targets_Energy_efficiency" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	X_ccid_id	Initiative_Name	Main_climate_policy_focus	Y_Thematic_area	View_initiative_on_UNFCCC_Global_Climate_Action_portal	View_initiative_on_UNEP_DTU_Climate_Initiatives_Platform	Website	Launch_year	Description	Y_SDG1	Y_SDG2	Y_SDG3	Y_SDG4	Y_SDG5	Y_SDG6	Y_SDG7	Y_SDG8	Y_SDG9	Y_SDG10	Y_SDG11	Y_SDG12	Y_SDG13	Y_SDG14	Y_SDG15	Y_SDG16	Y_SDG17	Targets_Emissions_reduction	Targets_Energy_efficiency	Targets_Renewable_energy	Targets_Number_people_number_countries	Targets_Number_organizations_newly_engaged	Targets_Areas_protected_improved_or_restored	Targets_in_market_shares_sales_scale	Targets_Funds_to_be_mobilized	Targets_Other	Y_Apply_10_to_Targets_Print_Targets	Y_display_country_names	Countries_where_activity_is_planned_or_ongoing	Y_Print_ActorName_only_Funders	Y_Print_ActorName_only_Lead_partners	Y_Print_ActorName_by_ActorType_Participants	Y_Participants1	Y_Participants2	Y_Participants3	Y_Participants4	Y_Participants5	Y_Participants6	Y_Participants7	Y_Participants8	ParticipantNames_National_governments	ParticipantNames_Subnational_and_regional_governments	ParticipantNames_Businesses	ParticipantNames_Investors	ParticipantNames_Domestic_NGOs	ParticipantNames_International_NGOs	ParticipantNames_Academic_educational_institutions	ParticipantNames_International_organizations	ParticipantNames_Other_organizations
210	ccid_0286	Mission Possible Platform	mainly mitigation	transport, energy, industry			https://www.weforum.org/mission-possible	2019	The Mission Possible Platform is a coalition of businesses and expert organizations (and governments) committed to reducing heavy industry greenhouse gas (GHG) emissions by creating and delivering technology, policy, and financing solutions.													SDG explicitly mentioned						[Reaching net-zero CO2 emission by mid-century at a total cost of well less than 0.5% of global GDP]									["United Kingdom of Great Britain and Northern Ireland (the)", "France", "Switzerland", "Denmark", "Germany", "United States of America (the)", "Netherlands (the)", "India", "Sweden"]		[""]	[World Economic Forum]_ior_int,[Energy Transition Commission]_edu_gbr	{"bus": ["Airbus", "Air Transport Action Group (ATAG)", "A.P. Moller-Maersk", "BASF", "Boeing", "Cargill", "Covestro", "easyJet Airline Co", "Heathrow Airport", "LeasePlan", "Lloyds Register", "Mountain Philanthropies", "Royal DSM", "Royal Dutch Shell", "Royal Schiphol Group", "Scania", "SkyNRG", "SpiceJet", "Trafigura Group", "Volvo Car Corporation"], "inv": ["Citi"]}