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
230 ccid_0306 The Ocean Cleanup Marine pollution oceans and coastal zones     https://theoceancleanup.com/ 2013 The Ocean Cleanup is designing and developing cleanup systems to clean up what is already polluting our oceans and to intercept plastic on its way to the ocean via rivers. A significant percentage of the plastic that enters the oceans from rivers and other sources during a transfer that can take many years, drifts into large systems of circulating ocean currents, also known as gyres. Once trapped in a gyre, the plastic will slowly break down into microplastics and become increasingly easier to mistake for food by sea life.                                             [Reach a 90% reduction of floating ocean plastic by the year 2040; tackle plastic in 1000 rivers by 2025]         ["Indonesia", "Malaysia"]   ["Maersk", "Latham and Watkins", "Deloitte", "Boskalis", "De Brauw Blackstone Westbroek", "The Netherlands", "Macquarie", "AkzoNobel"] [The Ocean Cleanup]_oth_nld {"bus": ["Salesforce", "iridium", "Seiche Water Technology Group", "Data Iku", "Microsoft", "Brabantia", "CFF", "DSM", "Agru", "Solidworks", "APL", "BCG", "Ecocast", "Gard", "EgonZehnder", "Globus", "We Ship Yachts", "Orcina", "VBAT", "KLM", "Mocean", "Acta Marine", "Alphatron Marine", "Applus+", "Aram Group", "Aspect Consulting", "BIND film", "Buckaroo", "C-Job", "Calumet Photo", "CSA Ocean Sciences", "Coosto", "CoreTeka", "Danone", "Deltares", "Deugro", "DJI", "Dropbox", "Euromonitor", "Falck Safety Services", "Frans Executive Search", "Geometius", "Global Maritime", "GOM", "GoPro", "Grayling", "Greenhost", "GRRR", "GSS Marine Services", "Heerema Marine Contractors", "HKV Lijn in Water", "in60seconds", "Intel", "INVENT Umwelt- und Verfahrenstechnik AG", "Jardine Lloyd Thompson", "Jurlights", "Key Code Media", "Kiwa", "Kreber", "Lankhorst Ropes", "LiveU", "Lloyd\u2019s Register", "Marine Instruments", "Maskell Pipe and Supply", "Maxar Technologies", "Metrixlab", "Musto", "Netherland-America Foundation", "Panasonic LUMIX", "Progressive Recruitment", "Port Health Centre", "Readme", "Riff Online", "RISKID", "Rise Marketing Group", "Royal Haskoning DHV", "Seatools", "South Pole", "SPECIFIC", "Stichting De Verre Bergen", "SurfSARA", "TK Maxx and Homesense", " Nobels and Ten Veen", "Vis Staalbouw", "VO Patents and Trademarks", "Webslice", "Websols", "Westmarine", "Xflow", "Xomnia", "yPlus"], "ing": ["The Bennink Foundation"], "edu": ["TU Delft ", "Universit\u00e4t Wien", "Wageningen University", "University of Miami", "Universiteit Utrecht", "Carl von Assietzky Universit\u00e4t", "University of Zurich", "University of the Aegean", "Can Tho University", "Ho Chi Minh City University ", "University of Hawaii", "Royal Netherlands Insitute for Sea Research", "Smithsonian Environmental Research Center", "MARIN", "Netherlands Institute for the Law of the Sea (NILOS)"]}