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 "Main_climate_policy_focus" = :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
286	ccid_0403	Increasing Capacities to develop National Species Checklists in the Latin America and the Caribbean Region	Nature-based Solutions	land use			https://www.gbif.org/project/1tM8FmqzlyGMmUiIMaaSsI/increasing-capacities-to-develop-national-species-checklists-in-the-latin-america-and-the-caribbean-region	2018	This project will build on the experiences from the GBIF nodes of Argentina, Colombia, Mexico, Chile and Brazil, with the associations CyTeD and Andino NET, to conduct a regional project defining consensus procedures for the development of national species checklists. A focus will be placed on achieving compatibility of databases with existing ones. Aiming a for a broad coverage of users, outcomes will be published in Spanish, Portuguese and English. Through a programme to “train the trainers”, knowledge gained from capacity dissemination events can be replicated to national and specific contexts. Additionally, a pilot checklist dataset per country will be published in the GBIF data network. (Note: Initiative ended in 2019)													SDG explicitly mentioned								[Conduct a regional project in Latin America and the Caribbean to define consensus procedures for the development of national species checklists]					[Establish valid nomenclatural data to build and improve regional biodiversity information systems]		["Colombia", "Argentina", "Mexico", "Chile", "Guatemala", "Peru", "Brazil", "Ecuador", "Uruguay", "Venezuela (Bolivarian Republic of)"]		["Global Biodiversity Information Facility (GBIF)"]	[GBIF Argentina]_ing_arg	{"ing": ["GBIF Argentina", "SiB Colombia", "GBIF Chile", "Programa Iberoamericano de ciencia y technologia para el desarrollo (CYTED)", "GBIF Ecuador", "GBIF Peru", "GBIF Uruguay"], "dng": ["CONABIO Mexico", "Sistema Nacional de Informacion sobre Diversidad Biologica de Guatemala (SNIDB)", "Sistema de Informacao Sobre A Biodiversidade Brasileira (SiBBr)"], "bus": ["AndinoNet"]}