testToSQLite

Custom SQL query returning 33 rows (show)

Query parameters

This data as json, CSV

rowidrowidini_idini_namepol_climatesdg1sdg2sdg3sdg4sdg5sdg6sdg7sdg8sdg9sdg10sdg11sdg12sdg13sdg14sdg15sdg16sdg17
3 3 CIP_20_01 Navigating a Changing Climate equally adaptation & mitigation 0 0 1 0 0 0 1 0 1 0 1 0 1 1 0 0 0
4 4 CIP_20_02 Transformative Actions Program equally adaptation & mitigation 0 0 0 0 0 1 1 0 1 0 1 1 1 0 0 0 1
6 6 NAZCA_18_68 RE100 mainly mitigation 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 0
7 7 NAZCA_18_3 Africa Renewable Energy Initiative mainly mitigation 0 0 0 0 0 0 1 1 0 0 0 0 1 0 0 0 0
10 10 NAZCA_18_75 SE4All: United for Efficiency mainly mitigation 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 1
12 12 NAZCA_18_10 International Zero-Emission Vehicle Alliance mainly mitigation 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 1
13 13 NAZCA_18_74 Under2 Coalition mainly mitigation 0 0 1 0 0 1 1 0 1 0 1 0 1 0 0 0 1
14 14 NAZCA_OPS_13 Powering Past Coal Alliance mainly mitigation 0 0 0 0 0 0 1 0 0 0 0 0 1 0 1 0 1
17 17 NAZCA_TOM_3 Zero Routine Flaring by 2030 mainly mitigation 0 0 1 0 0 0 1 0 1 0 0 0 1 0 0 0 1
18 18 NAZCA_TOM_2 Super-efficient Equipment and Appliance Deployment Initiative mainly mitigation 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 1
19 19 NAZCA_18_81 Global Covenant of Mayors for Climate & Energy mainly adaptation 0 0 1 0 0 0 1 0 1 0 1 1 1 0 0 0 1
21 21 NCI_07 Responsible Care mainly mitigation 0 1 0 0 0 0 1 0 1 0 1 1 1 0 1 0 1
23 23 NAZCA_TOM_4 European Technology and Innovation Platform on Wind Energy mainly mitigation 0 0 0 0 0 0 1 0 0 0 1 1 1 0 0 0 1
24 24 NAZCA_TOM_5 European Technology and Innovation Platform for Photovoltaics mainly mitigation 0 0 0 0 0 1 1 0 1 0 1 1 1 0 0 0 1
25 25 NAZCA_TOM_6 SunShot Initiative mainly mitigation 0 0 0 0 0 0 1 0 1 0 0 1 1 0 0 0 0
27 27 NAZCA_TOM_7 Wind Vision mainly mitigation 0 0 0 0 0 0 1 1 1 0 0 0 1 0 0 0 0
28 28 NCI_02 The 2030 Challenge mainly mitigation 0 0 0 0 0 0 1 0 1 0 1 1 1 0 0 0 0
29 29 NAZCA_18_52 Global Fuel Economy Initiative mainly mitigation 0 0 1 0 0 0 1 0 1 0 1 1 1 0 0 0 0
33 33 NAZCA_18_53 Global Geothermal Alliance mainly mitigation 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 1
34 34 CAS19_31 Global Alliance to Significantly Reduce Methane Emissions in the Oil and Gas Sector by 2030 mainly mitigation 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 1
35 35 CS18_14 C40 Green & Healthy Streets mainly mitigation 0 0 1 0 0 0 1 0 0 0 1 0 1 0 0 0 0
39 39 NAZCA_18_21 "Paris Pact on water and adaptation to climate change in the basins of rivers lakes and aquifers" 0 1 1 1 0 0 1 0 1 0 0 1 0 1 1 0 1
40 40 NAZCA_18_24 Global Resilience Partnership mainly adaptation 0 1 0 0 0 1 1 0 0 1 1 0 1 0 1 0 1
48 48 NAZCA_OPS_14 Transport Decarbonisation Alliance mainly mitigation 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 1
50 50 SIDS_2 The World Team Project: Sustainable Solutions Oceans Opportunities & Small Island States mainly adaptation 0 0 0 1 0 1 1 1 1 1 1 1 1 1 1 1 1
57 57 NY14_AG_03 North American Climate Smart Agriculture Alliance mainly adaptation 0 1 1 0 0 1 1 1 0 0 1 1 1 0 1 0 0
63 63 OPS_UPT_6 AfroChampions Initiative mainly adaptation 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 1
79 79 OPS_UPT_5 Support for coal- and carbon-intensive regions in transition equally adaptation & mitigation 0 0 0 0 0 0 1 1 1 0 1 0 1 0 0 0 0
87 87 YRB_UPT_16 Alliances for Climate Action equally adaptation & mitigation 0 0 0 0 0 0 1 0 1 0 0 1 1 0 0 0 1
8 8 NCI_04 C40 Cities Climate Leadership Group equally adaptation & mitigation 0 1 1 0 1 1 1 0 1 1 1 1 1 0 0 1 1
54 54 NY14_AG_11 Coffee & Climate mainly adaptation 1 1 0 0 1 1 1 0 0 0 0 0 1 0 1 0 1
67 67 NAZCA_CAPP_3 Climate change and health in small island developing states mainly adaptation 0 0 1 0 1 0 1 0 0 1 0 0 1 0 0 0 0
80 80 SIDS_9 ICT4SIDS Partnerships: Rapid Implementation of SDGs Through Latest Digital Innovations equally adaptation & mitigation 1 1 1 1 1 1 1 1 0 0 1 0 1 1 1 0 1