testToSQLite

Custom SQL query returning 63 rows (show)

Query parameters

This data as json, CSV

rowidrowidini_idini_namepol_climatesdg1sdg2sdg3sdg4sdg5sdg6sdg7sdg8sdg9sdg10sdg11sdg12sdg13sdg14sdg15sdg16sdg17
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
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
11 11 NAZCA_18_73 The New York Declaration on Forests mainly mitigation 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 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
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
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
16 16 NAZCA_18_32 Bonn Challenge mainly mitigation 0 0 0 0 0 0 0 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
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
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
30 30 NCI_05 Governors' Climate and Forests Task Force mainly mitigation 0 0 0 0 1 0 0 0 0 1 0 0 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
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
36 36 CAS19_04 Africa Adaptation Initiative mainly adaptation 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 1 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
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
46 46 CAS19_13 LDC Initiative for Effective Adaptation and Resilience mainly adaptation 1 0 0 0 0 0 0 1 0 1 0 0 1 0 0 1 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
49 49 NAZCA_OPS_6 African Women in Agricultural Research and Development - One Planet Fellowship mainly adaptation 0 1 0 1 1 0 0 0 0 0 0 1 1 0 1 0 1
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
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
55 55 SIDS_7 Coconut Industry Development for the Caribbean mainly adaptation 0 1 0 0 0 0 0 0 0 0 0 1 1 0 1 0 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
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
61 61 NAZCA_18_19 The 1 in 100 initiative mainly adaptation 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1
62 62 NAZCA_18_22 Food Security Climate Resilience Facility mainly adaptation 1 1 0 0 0 1 0 0 0 0 0 0 1 0 0 0 1
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
64 64 CAS19_11 Early Warning Early Action mainly adaptation 1 1 1 0 0 0 0 0 0 1 0 0 1 0 0 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
68 68 NAZCA_CAPP_4 Fiji Water Resilience mainly adaptation 0 0 0 0 0 1 0 0 0 0 0 1 1 0 0 0 1
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
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
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
85 85 OPS_UPT_1 "Pacific Initiative on Biodiversity Resilience and Climate Change " 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 1
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
38 38 CS18_09 International Alliance to Combat Ocean Acidification mainly adaptation 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 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
45 45 NAZCA_COP23ANN_1 The Ocean Pathway equally adaptation & mitigation 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1
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
52 52 SIDS_6 Enhancing global ocean acidification monitoring and research mainly adaptation 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1
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
69 69 SDG14_12 Asian Seafood Improvement Collaborative nature-based solutions 1 1 0 0 1 0 0 1 0 1 0 1 1 1 0 0 1
71 71 SDG14_13 Partnership with African Coastal States to Eradicate IUU Fishing in their Sovereign Waters by 2020 nature-based solutions 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1
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
75 75 SIDS_4 Norway-Pacific Joint Chair of Oceans and Climate Change equally adaptation & mitigation 0 0 0 1 0 0 0 0 0 0 0 0 1 1 0 1 1
77 77 SIDS_5 Small Island States (SIDS) Blue Guardians: Partnership to Protecting Oceans and Climate-resilient Bl equally adaptation & mitigation 0 0 0 0 1 0 0 0 0 0 0 0 1 1 0 1 1
78 78 SIDS_8 The 10x20 Initiative Nature-based solutions 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 1
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
82 82 SIDS_10 Oceania 21 Nature-based solutions 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1
83 83 SIDS_11 Waste Management and Sanitation Improvement (WMI) Programme equally adaptation & mitigation 0 0 0 0 0 1 0 0 0 0 0 1 1 1 0 0 1
84 84 SIDS_12 Caribbean Challenge Initiative Nature-Based Solutions 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 1
86 86 YRB_UPT_3 Blue Carbon Initiaitive equally adaptation & mitigation 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 1
88 88 SDG14_2 International Waste Platform equally adaptation & mitigation 0 0 1 0 0 1 0 0 0 0 0 1 0 1 1 0 1
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
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
92 92 SDG14_16 The Ocean Cleanup Marine pollution 0 0 0 0 0 1 0 0 0 0 0 1 1 1 0 0 1