testToSQLite

Custom SQL query returning 1 row (show)

Query parameters

rowidX_ccid_idInitiative_NameMain_climate_policy_focusY_Thematic_areaView_initiative_on_UNFCCC_Global_Climate_Action_portalView_initiative_on_UNEP_DTU_Climate_Initiatives_PlatformWebsiteLaunch_yearDescriptionY_SDG1Y_SDG2Y_SDG3Y_SDG4Y_SDG5Y_SDG6Y_SDG7Y_SDG8Y_SDG9Y_SDG10Y_SDG11Y_SDG12Y_SDG13Y_SDG14Y_SDG15Y_SDG16Y_SDG17Targets_Emissions_reductionTargets_Energy_efficiencyTargets_Renewable_energyTargets_Number_people_number_countriesTargets_Number_organizations_newly_engagedTargets_Areas_protected_improved_or_restoredTargets_in_market_shares_sales_scaleTargets_Funds_to_be_mobilizedTargets_OtherY_Apply_10_to_Targets_Print_TargetsY_display_country_namesCountries_where_activity_is_planned_or_ongoingY_Print_ActorName_only_FundersY_Print_ActorName_only_Lead_partnersY_Print_ActorName_by_ActorType_ParticipantsY_Participants1Y_Participants2Y_Participants3Y_Participants4Y_Participants5Y_Participants6Y_Participants7Y_Participants8ParticipantNames_National_governmentsParticipantNames_Subnational_and_regional_governmentsParticipantNames_BusinessesParticipantNames_InvestorsParticipantNames_Domestic_NGOsParticipantNames_International_NGOsParticipantNames_Academic_educational_institutionsParticipantNames_International_organizationsParticipantNames_Other_organizations
11 ccid_0011 Conference of Peripheral Maritime Regions equally adaptation & mitigation oceans and coastal zones, transport, energy https://climateaction.unfccc.int/views/cooperative-initiative-details.html?id=23 http://climateinitiativesplatform.org/index.php/Conference_of_Peripheral_Maritime_Regions https://cpmr.org/ 1973 Representing about 200 million people, the CPMR campaigns in favour of a more balanced development of the European territory. It operates both as a think tank and as a lobby for Regions. Through its extensive network of contacts within the EU institutions and national governments the CPMR has, since its creation in 1973, been targeting its action towards ensuring that the needs and interests of its Member Regions are taken into account in policies with a high territorial impact. It focuses mainly on social, economic and territorial cohesion, maritime policies and blue growth, and accessibility. European governance, energy and climate change, neighbourhood and development also represent important areas of activity for the association.                           SDG explicitly mentioned                           ["Albania", "Belgium", "Bulgaria", "Denmark", "Finland", "France", "Germany", "Greece", "Ireland", "Italy", "Malta", "Moldova (the Republic of)", "Morocco", "Norway", "Poland", "Romania", "Spain", "Sweden", "Netherlands (the)", "Tunisia", "Turkey", "Ukraine", "United Kingdom of Great Britain and Northern Ireland (the)"]   [""] [CPMR]_oth_bel {"sgv": ["Shkoder", "Tirana", "West Vlaanderen", "Burgas", "Varna", "Bornholm", "Midtjylland", "Nordjylland", "Syddanmark", "Helsinki Uusiaa", "Kyemenlaakso", "Ostrobothnia", "Oulu", "Paijat-Hame", "Satakunta", "Southwest Finland", "Bretagne", "Corse France", "Guadeloupe", "Guyane", "Hauts de France", "La Reunion", "Martinique", "Mayotte", "Normandie", "Nouvelle Aquitaine", "Occitanie", "Pays de la Loire", "Polynesie Fran\u00e7aise", "Sud Provence Alpes Cote D Azur", "Saint Martin", "Bremen", "Mecklenburg Vorpommern", "Niedersachsen", "Schleswig Holstein", "Anatolki Makedonia Kai Thraki", "Attiki", "Dytiki Ellada", "Iona Nisia", "Crete", "South Aegean", "Thessaly", "Peloponnese", "Central Greece", "North Aegean", "Donegal", "Arbuzzo", "Calabria", "Campania", "Emilia Romagna", "Lazio", "Liguara", "Marche", "Molise", "Puglia", "Sardegna", "Sicilia", "Toscana", "Umbria", "Veneto", "Gozo", "Anenii Noi", "Basarabeasca", "Briceni", "Cantemir", "Cimisilia", "Criuleni", "Drochia", "Falesti", "Floresti", "Gagauzia", "Glodeni", "Ialoveni", "Leova", "Nisporeni", "Ohrei", "Rezina", "Riscani", "Singerei", "Soldanesti", "Stefan Voda", "Straseni", "Telenesti", "Dakhla Oued Ed Dahab", "Laayoune Sakia El Hamra", "L Oriental", "Marrakech Safi", "Rabat Sale Kenitra", "Tanger Tetouan Al Hoceika", "Aust Agder", "Buskerud", "Hordaland", "More Og Romsdal", "Ostfold", "Rogaland", "Sogn Og Fjordane", "Telemark ", "Trondelag", "Vest Agder", "Vestfold", "Podlaskie", "Acores", "CCDR Do Alentejo", "CCDR Do Centro", "CCDR Do Lissboa e Vale Do Tejo", "CCDR Do Norte", "Madeira", "Calarasi", "Galati", "Tulcea", "Valcea", "Baleares", "Generalitat de Catalunya", "Generalitat Valenciana", "Gobierno de Aragon", "Gobierno De Canarias", "Gobierno De Cantabria", "Gobiernio de Navarra", "Gobierno Vasco", "Junta de Andaluc\u00eda", "Mellila", "Murcia", "Principado de Asturias", "Xunta de Galicia", "Blekinge", "Gavleborg ", "Gotland", "Halland", "Norbrotten", "Orebro", "Skane", "Stockholm", "Varmland", "Vastebrotten", "Vastra Gotaland", "Flevoland", "Noord Holland", "Noord Nederland", "Zeeland", "Zuid Holland", "Monastir", "Sousse", "Samsun", "Sinop", "Tekirdag", "Trabzon", "Odesa", "Aberdeen City", "Aberdeenshire", "Cornwall", "Fife", "Highland", "Southend on Sea", "Welsh Government", "Western Isles"]}