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_in_market_shares_sales_scale" = :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
71	ccid_0086	EP100	mainly mitigation	energy, industry		http://climateinitiativesplatform.org/index.php/EP100	https://www.theclimategroup.org/project/ep100	2016	EP100 brings together a growing group of energy-smart companies improving their energy productivity to lower their emissions and improve their competitiveness. EP100 is led by the Climate Group in partnership with the Alliance to Save Energy. Our mission is to lower global energy demand and accelerate the clean energy transition. The International Energy Agency estimates that over 40% of the emissions cuts needed to reach global climate goals can be achieved through energy efficiency. In making smarter use of energy, EP100 members are leading the way.							SDG explicitly mentioned						SDG explicitly mentioned						[Member companies commit to doubling its economic output from every unit of energy it consumes globally within 25 years, with a baseline year of 2005 at the earliest; Member companies commit to implementing an energy management system (EnMS) in each of its facilities within 10 years and commits to an energy productivity target]			[100 companies]		[Member companies commit to owning, occupying and developing buildings that operate at net zero carbon emissions by 2030]				["United States of America (the)", "Italy", "United Arab Emirates (the)", "Hong Kong", "Australia", "United Kingdom of Great Britain and Northern Ireland (the)", "Philippines (the)", "Canada", "Mexico", "Sri Lanka", "China", "Finland", "Germany", "Japan", "India", "Denmark", "Ireland", "None", "South Africa", "Singapore", "Switzerland", "Taiwan (Province of China)", "Thailand", "Netherlands (the)", "United States of America (the)"]		[""]	[The Climate Group]_ing_gbr,[Alliance to Save Energy]_bus_usa,[World Green Building Council (WGBC)]_oth_int	{"bus": ["AECOM", "Aeroporti Di Roma", "AESG", "Airport Authority Hong Kong", "Argent Services", "Armstrong Fluid Technology", "Arthaland Corporation", "Assura", "AstraZeneca", "Atelier Ten", "Avison Young", "Bennetts Associates", "Berkeley Group", "Bioconstruction y energia alternativa", "Brandix Apparel Solution Limited", "Brunswick Property Partners", "Bruntwood", "BuroHappold Engineering", "Cbus Property", "Changzou New Wide Knitting and Dyeing Co Ltd", "Citycon", "Covestro", "Cree", "Cundall", "Daito Trust Construction Co Ltd", "Daiwa House Industry", "Dalmia Cement", "Danfoss", "Deerns", "Derwent fm", "Dexus", "DLL", "EMR", "Excool Group", "Foster Partners", "Frasers Property Australia", "Godrej Industries", "GPT Wholesale Office Fund", "Grainger plc", "Grimshaw Architects", "Grosvenor", "H and M", "Hilton", "Hoare Lea", "Hudson Pacific Properties", "Integral Group", "IPUT", "Jinko Solar", "JLL", "John Sisk and Son", "Johnson Controls", "Joseph Homes", "KEVA", "Kingspan", "Lemay", "Lendlease Australian Prime Property Fund (APPF) Commercial", "Lendlease Australian Prime Property Fund (APPF) Industrial", "Lendlease Europe", "Lendlease International Towers Sydney Trust", "Lendlease One International Towers Sydney Trust", "LONGi Group", "Mahindra and Mahindra", "Mahindra Heavy Engines Limited", "Mahindra Holidays and Resorts India Ltd", "Mahindra Vehicle Manufacturers Limited", "Majid Al Futtaim", "Max Fordham", "Mitie", "Mott MacDonald", "Multiplex", "Newsec Finland", "Nightingale Housing", "Nippon Telegraph and Telephone Corporation (NTT)", "Ovo", "QIC Global Real Estate", "Salesforce", "Sasol", "Schneider Electric", "Shaw Contract", "Skidmore Ownings and Merrill", "SSE plc", "Surbana Jurong", "Swaraj Engines ltd", "TCI Co Ltd", "Trane Technologies", "TRIDL", "Tritax Big Box", "UltraTech Cement", "United Metal Coating", "Varma", "Wereldhave", "Willmott Dixon", "Woolworths Holdings", "Yanbu Cement Company", "YLVA"], "inv": ["AMP Capital Wholesale Office Fund", "Commonwealth Bank of Australia", "Goldman Sachs", "Kilroy Realty Corporation", "Landsec", "Lloyds Banking Group", "Local Government Super", "RBS", "Stockland", "Swiss Re", "Thai Union", "Vornado Realty Trust"]}