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_Number_organizations_newly_engaged" = :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
46	ccid_0054	Global Green Freight Action Plan	mainly mitigation	transport			http://www.globalgreenfreight.org	2014	Trade in goods and materials drives global economic growth and development, linking nations and markets through an increasingly interdependent supply chain. The Global Green Freight Project was initiated by the Climate and Clean Air Coalition as part of a large-scale effort to reduce the climate and health impacts and improve the energy and economic efficiency of transporting those goods and materials													SDG explicitly mentioned									[By 2025: Top 100 global shippers in carriers are members of all major programs (from global green freight)]						["Bangladesh", "Benin", "Burundi", "Central African Republic (the)", "C\u00f4te d'Ivoire", "Congo (the Democratic Republic of the)", "France", "Ireland", "Japan", "Kenya", "Liberia", "Mexico", "Morocco", "None", "Nigeria", "Norway", "Peru", "Philippines (the)", "Poland", "Russian Federation (the)", "Rwanda", "South Sudan", "Sweden", "Switzerland", "Togo", "Uganda", "United States of America (the)"]		[""]	[Climate and Clean Air Coalition to Reduce Short Lived Climate Pollutants (CCAC)]_oth_int	{"oth": ["Climate and Clean Air Coalition to Reduce Short Lived Climate Pollutants (CCAC)"], "dng": ["Smart Freight Centre (SFC)", "California Air Resources Board", "Centre for Clean Air Policy", "CEID Colombia", "Centro de Derechos Humanos y Ambiente", "Centro Mario Molina Chile", "Centro de Investigacion en Mecatronica Automotriz of Tecnologico de Monterrey", "Clean Air Asia", "Clean Cargo Working Group", "CNT Brasil", "ECO Stars Fleet Recognition Scheme", "FIA Foundation", "Green Freight Europe", "Institute for Governance and Sustainable Development", "International Council on Clean Transportation", "Institute for Global Environmental Strategies IGES", "International Solid Waste Association", "Lean and Green", "Molina Center for Strategic Studies in Energy and the Environment", "Natural Resources Defense Council", "Northern Corridor Transit and Transport Coordination Authority NCTTCA", "Partnership on Sustainable Low Carbon Transport", "Smart Freight Centre", "Swiss Foundation for Technical Cooperation"], "ngv": ["SmartWay Transport Partnership", "SmartWay Transport Partnership", "ADEME (French Environment and Energy Management Agency)", "Clean Air Asia", "Bangladesh", "Benin", "Canada", "Central African Republic", "Chile", "Cote d Ivoire", "France", "Ireland", "Japan", "Liberia", "Mexico", "Morocco", "Netherlands", "Nigeria", "Norway", "Peru", "Philippines", "Poland", "Russian Federation", "Sweden", "Switzerland", "Togo", "United States of America", "Vietnam"], "ing": ["The International Council on Clean Transportation", "Business for Social Responsibility"], "bus": ["AUTF (French Shippers Council)", "Deutsche Post DHL", "Hewlett Packard", "IKEA", "Volvo", "BSR", "French Shippers Council", "Global Food Cold Chain Council"], "sgv": ["California Air Resources Board (ARB)"]}