testToSQLite

Custom SQL query returning 1 row (hide)

select rowid, X_ccid_id, Initiative_Name, Main_climate_policy_focus, Y_Thematic_area, View_initiative_on_UNFCCC_Global_Climate_Action_portal, View_initiative_on_UNEP_DTU_Climate_Initiatives_Platform, Website, Launch_year, Description, Y_SDG1, Y_SDG2, Y_SDG3, Y_SDG4, Y_SDG5, Y_SDG6, Y_SDG7, Y_SDG8, Y_SDG9, Y_SDG10, Y_SDG11, Y_SDG12, Y_SDG13, Y_SDG14, Y_SDG15, Y_SDG16, Y_SDG17, Targets_Emissions_reduction, Targets_Energy_efficiency, Targets_Renewable_energy, Targets_Number_people_number_countries, Targets_Number_organizations_newly_engaged, Targets_Areas_protected_improved_or_restored, Targets_in_market_shares_sales_scale, Targets_Funds_to_be_mobilized, Targets_Other, Y_Apply_10_to_Targets_Print_Targets, Y_display_country_names, Countries_where_activity_is_planned_or_ongoing, Y_Print_ActorName_only_Funders, Y_Print_ActorName_only_Lead_partners, Y_Print_ActorName_by_ActorType_Participants, Y_Participants1, Y_Participants2, Y_Participants3, Y_Participants4, Y_Participants5, Y_Participants6, Y_Participants7, Y_Participants8, ParticipantNames_National_governments, ParticipantNames_Subnational_and_regional_governments, ParticipantNames_Businesses, ParticipantNames_Investors, ParticipantNames_Domestic_NGOs, ParticipantNames_International_NGOs, ParticipantNames_Academic_educational_institutions, ParticipantNames_International_organizations, ParticipantNames_Other_organizations from stake where "Targets_Renewable_energy" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	X_ccid_id	Initiative_Name	Main_climate_policy_focus	Y_Thematic_area	View_initiative_on_UNFCCC_Global_Climate_Action_portal	View_initiative_on_UNEP_DTU_Climate_Initiatives_Platform	Website	Launch_year	Description	Y_SDG1	Y_SDG2	Y_SDG3	Y_SDG4	Y_SDG5	Y_SDG6	Y_SDG7	Y_SDG8	Y_SDG9	Y_SDG10	Y_SDG11	Y_SDG12	Y_SDG13	Y_SDG14	Y_SDG15	Y_SDG16	Y_SDG17	Targets_Emissions_reduction	Targets_Energy_efficiency	Targets_Renewable_energy	Targets_Number_people_number_countries	Targets_Number_organizations_newly_engaged	Targets_Areas_protected_improved_or_restored	Targets_in_market_shares_sales_scale	Targets_Funds_to_be_mobilized	Targets_Other	Y_Apply_10_to_Targets_Print_Targets	Y_display_country_names	Countries_where_activity_is_planned_or_ongoing	Y_Print_ActorName_only_Funders	Y_Print_ActorName_only_Lead_partners	Y_Print_ActorName_by_ActorType_Participants	Y_Participants1	Y_Participants2	Y_Participants3	Y_Participants4	Y_Participants5	Y_Participants6	Y_Participants7	Y_Participants8	ParticipantNames_National_governments	ParticipantNames_Subnational_and_regional_governments	ParticipantNames_Businesses	ParticipantNames_Investors	ParticipantNames_Domestic_NGOs	ParticipantNames_International_NGOs	ParticipantNames_Academic_educational_institutions	ParticipantNames_International_organizations	ParticipantNames_Other_organizations
101	ccid_0125	European Technology and Innovation Platform on Wind Energy	mainly mitigation	energy		http://climateinitiativesplatform.org/index.php/European_Technology_and_Innovation_Platform_for_Wind_(ETIPwind)	https://etipwind.eu	2016	ETIP Wind activities combine two prior initiatives: the European Wind Energy Technology Platform (TPWind) and the European Wind Industry Initiative. The ambition is to define and agree on concrete research and innovation (R&I) priorities and communicate these to the European institutions and other decision making bodies in order to support the EU’s ambition of a decarbonised economy by 2050.The current ETIPWind platform informs Research & Innovation policy at European and national level to deliver on the EU’s Climate and Energy objectives and maintain Europe’s competitive edge in wind energy. ETIPWind interacts with the European Commission and European Parliament, the SET Plan Steering Group, other ETIPs and Member States representatives to ensure a coherent advisory framework.							SDG explicitly mentioned						SDG explicitly mentioned							The timely implementation of the EWI will lead to high wind energy penetration levels, reaching 20% in 2020, 33% in 2030 and 50% in 20502. (EWEAs targets today are 15.7% in 2020. 28.5% in 2030 and 50% in 2050)						make onshore wind the most competitive energy source by 2020, with offshore following by 2030; achieve a 20% share of wind energy in EU total electricity consumption by 2020; create 250,000 new skilled jobs in the EU by 2020; Develop 15-20MW turbine prototypes from 2017 until 2020; Implementing 5 additional testing facilities from 2015 to 2020.		["Austria", "Belgium", "Bulgaria", "Croatia", "Cyprus", "Czechia", "Denmark", "Estonia", "Finland", "France", "Germany", "Greece", "Hungary", "Ireland", "Italy", "Latvia", "Lithuania", "Luxembourg", "Malta", "Netherlands (the)", "Poland", "Portugal", "Romania", "Slovakia", "Slovenia", "Spain", "Sweden", "United Kingdom of Great Britain and Northern Ireland (the)"]		["European Comission"]	[Hitachi ABB Power Grids]_bus_che	{"bus": ["Hitachi ABB Power Grids", "Acciona", "DNV GL", "E.ON Climate & Renewables", "EDF Energies Nouvelles", "ENEL Green Power", "GE Renewable Energy", "EDP Renewables", "ERG", "LM Wind Power", "MHI Vestas Offshore Wind", "ORE Catapult", "Equinor", "Vattenfall", "Nordex", "Iberdrola Renovables Energ\u00eda", "\u00d8rsted", "Renewable Energy Systems", "Sentient Science", "Senvion", "Siemens Gamesa Renewable Energy", "Sintef", "Vestas", "ZF Wind Power", "Enercon", "ABB"], "edu": ["CENER", "EERA JP Wind", "Fraunhofer IWES ", "EAWE", "TNO"]}