testToSQLite

Custom SQL query returning 39 rows (show)

Query parameters

This data as json, CSV

rowidrowidini_idini_namepol_climatesdg1sdg2sdg3sdg4sdg5sdg6sdg7sdg8sdg9sdg10sdg11sdg12sdg13sdg14sdg15sdg16sdg17
1 1 NCI_20_03 Sustainable Building and Climate Initiative mainly mitigation 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 0
2 2 NAZCA_20_Adhoc14 Ocean Risk and Resilience Action Alliance mainly adaptation 1 0 0 0 1 0 0 0 1 0 1 0 1 1 0 0 1
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
5 5 NCI_20_01 CO2­ Performance Ladder mainly mitigation 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0
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
9 9 NAZCA_18_41 Collaborative Climate Action Across the Air Transport World mainly mitigation 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 1
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
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
20 20 NCI_20_02 Green Building Initiative mainly mitigation 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 0
22 22 NAZCA_18_71 Science-based Targets mainly mitigation 0 0 0 0 0 0 0 0 1 0 0 1 1 0 0 0 0
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
37 37 CAS19_16 Coalition for Climate Resilient Investment mainly adaptation 0 0 0 0 0 0 0 1 1 0 1 0 1 0 0 0 1
43 43 NAZCA_18_23 InsuResilience Global Partnership mainly adaptation 1 0 0 0 1 0 0 1 1 0 0 0 1 0 0 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
56 56 NAZCA_18_27 Smart Risk Investing mainly adaptation 0 0 0 0 0 0 0 0 1 0 0 1 1 0 0 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
76 76 OPS_UPT_4 Make Our Planet Great Again equally adaptation & mitigation 1 0 0 1 0 0 0 0 1 0 0 0 1 0 0 0 0
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
15 15 NAZCA_18_16 Save Food Initiative mainly mitigation 1 1 0 0 0 0 0 0 1 1 0 1 1 0 1 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
32 32 NCI_01 Clean Climate & Air Coalition mainly mitigation 0 1 1 0 0 0 0 0 1 0 0 1 1 0 1 0 1
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
44 44 NAZCA_18_25 R4 Rural Resilience Initiative mainly adaptation 1 1 0 0 1 1 0 0 1 0 0 0 1 0 0 0 1
59 59 LPA_RE_05 Global Facility for Disaster Reduction and Recovery mainly adaptation 1 1 1 1 1 0 0 0 1 0 1 0 1 1 1 0 0
70 70 CAS19_18 Supporting smallholder farmers mainly adaptation 1 1 0 0 0 0 0 1 1 0 0 0 1 0 1 0 1