testToSQLite

Custom SQL query returning 30 rows (show)

Query parameters

This data as json, CSV

rowidrowidini_idini_namepol_climatesdg1sdg2sdg3sdg4sdg5sdg6sdg7sdg8sdg9sdg10sdg11sdg12sdg13sdg14sdg15sdg16sdg17
74 74 NY14_AG_18 GFAR: Empowering Farmers Organisations on Climate Change Through Better Foresight "0" 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
89 89 SDG14_4 Blue Forests Project "mainly mitigation 0 1 0 0 0 1 0 0 0 0 0 0 0 1 1 0 0
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
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
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
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
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
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
26 26 NCI_06 Lean and Green mainly mitigation 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 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
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
51 51 SIDS_3 Pacific plastic pollution: A system for regional grassrots mainly adaptation 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 0 0
53 53 OPS_UPT_2 DeSIRA - Financing for agricultural research to help low-income farmers adapt to climate change mainly adaptation 1 1 0 1 0 0 0 1 0 0 0 0 1 0 1 0 0
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
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
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
60 60 OPS_UPT_3 Helping Farmers Cope with Climate Change mainly adaptation 1 1 1 0 0 0 0 0 0 0 0 0 1 0 1 0 0
65 65 SDG14_5 Reducing ship strikes to vulnerable Whales Wildlife conservancy 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0
66 66 SDG14_10 MedFish4ever nature-based solutions 0 1 0 0 0 0 0 0 0 0 0 1 1 1 1 0 0
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
72 72 SDG14_1 Goal 14 implementation for the protection of Mediterranean Sea's whales and dolphins mainly adaptation 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0
73 73 NY14_AG_09 National Agricultural Resilience Framework mainly adaptation 1 1 1 0 0 0 0 1 0 0 1 0 1 0 1 1 0
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
81 81 YRB_UPT_1 Earth For Life Initiative equally adaptation & mitigation 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0
90 90 SDG14_3 Raise Awareness about the Ocean and Take Action equally adaptation & mitigation 1 0 0 1 1 1 0 0 0 0 0 1 1 1 0 1 0