global-power-plants: global-power-plants: 7 rows where owner = "GLOW Group"

Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette

7 rows where owner = "GLOW Group"

Search:

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid ▼	country	country_long	name	gppd_idnr	capacity_mw	latitude	longitude	primary_fuel	commissioning_year	owner	source	url	geolocation_source	wepp_id	estimated_generation_gwh_2017	estimated_generation_note_2013	estimated_generation_note_2014	estimated_generation_note_2015	estimated_generation_note_2016	estimated_generation_note_2017
21488	21488	THA	Thailand	GSPP 11	WRI1019462	272.0	13.0013	101.1361	Gas		GLOW Group	Glow Group	http://www.glow.co.th/index.php?op=product_business_line_plants-detail&cid=1&id=11	WRI		1189.47	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	CAPACITY-FACTOR-V1
21489	21489	THA	Thailand	Gheco One power station	WRI1019478	660.0	12.6779	101.1356	Coal	2012.0	GLOW Group	Glow Group	http://www.glow.co.th/index.php?op=product_business_line_plants-detail&cid=2&id=4	WRI	1077767	4100.41	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	CAPACITY-FACTOR-V1
21490	21490	THA	Thailand	Glow Demin	WRI1019461	124.0	12.6971	101.1191	Gas	1998.0	GLOW Group	Glow Group	http://www.glow.co.th/index.php?op=product_business_line_plants-detail&cid=1&id=9	WRI		542.26	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	CAPACITY-FACTOR-V1
21491	21491	THA	Thailand	Glow Energy Phase 2 Power Plant	WRI1019479	258.0	12.694	101.1452	Gas		GLOW Group	Glow Group	http://www.glow.co.th/index.php?op=product_business_line_plants-detail&cid=1&id=6	WRI		1128.25	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	CAPACITY-FACTOR-V1
21492	21492	THA	Thailand	Glow Energy Phase 5 Power Plant	WRI1019460	412.0	12.6779	101.1356	Gas	2011.0	GLOW Group	Glow Group	http://www.glow.co.th/index.php?op=product_business_line_plants-detail&cid=1&id=8	WRI		1801.71	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	CAPACITY-FACTOR-V1
21493	21493	THA	Thailand	Glow Energy power complex	WRI1019457	526.0	12.6779	101.1356	Coal	2001.0	GLOW Group	Glow Group	http://www.glow.co.th/index.php?op=product_business_line_plants-detail&cid=1&id=15	WRI	1012951	3267.9	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	CAPACITY-FACTOR-V1
21494	21494	THA	Thailand	Glow IPP	WRI1019459	713.0	13.0536	101.0857	Gas	2003.0	GLOW Group	Glow Group	http://www.glow.co.th/index.php?op=product_business_line_plants-detail&cid=2&id=3	WRI	1012951	3118.01	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	CAPACITY-FACTOR-V1

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "global-power-plants" (
"country" TEXT,
  "country_long" TEXT,
  "name" TEXT,
  "gppd_idnr" TEXT,
  "capacity_mw" REAL,
  "latitude" REAL,
  "longitude" REAL,
  "primary_fuel" TEXT,
  "other_fuel1" TEXT,
  "other_fuel2" TEXT,
  "other_fuel3" TEXT,
  "commissioning_year" REAL,
  "owner" TEXT,
  "source" TEXT,
  "url" TEXT,
  "geolocation_source" TEXT,
  "wepp_id" TEXT,
  "year_of_capacity_data" INTEGER,
  "generation_gwh_2013" REAL,
  "generation_gwh_2014" REAL,
  "generation_gwh_2015" REAL,
  "generation_gwh_2016" REAL,
  "generation_gwh_2017" REAL,
  "generation_gwh_2018" REAL,
  "generation_gwh_2019" REAL,
  "generation_data_source" TEXT,
  "estimated_generation_gwh_2013" REAL,
  "estimated_generation_gwh_2014" REAL,
  "estimated_generation_gwh_2015" REAL,
  "estimated_generation_gwh_2016" REAL,
  "estimated_generation_gwh_2017" REAL,
  "estimated_generation_note_2013" TEXT,
  "estimated_generation_note_2014" TEXT,
  "estimated_generation_note_2015" TEXT,
  "estimated_generation_note_2016" TEXT,
  "estimated_generation_note_2017" TEXT
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");

{ "request_duration_ms": 176.35469399829162, "sum_trace_duration_ms": 238.99457398874802, "num_traces": 111, "traces": [ { "type": "sql", "start": 21127.281720348, "end": 21127.282637524, "duration_ms": 0.917175999347819, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n await self.ds.refresh_schemas()\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 351, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 361, in _refresh_schemas\n for row in await internal_db.execute(\n" ], "database": "_internal", "sql": "select database_name, schema_version from databases", "params": null }, { "type": "sql", "start": 21127.283640414, "end": 21127.284440595, "duration_ms": 0.8001810019777622, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n await self.ds.refresh_schemas()\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 351, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 366, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "_internal", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 21127.284646756, "end": 21127.285004168, "duration_ms": 0.35741199826588854, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n await self.ds.refresh_schemas()\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 351, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 366, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "global-power-plants", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 21127.285492588, "end": 21127.285970844, "duration_ms": 0.47825600267970003, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 431, in get_view_definition\n return await self.get_table_definition(view, \"view\")\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 411, in get_table_definition\n await self.execute(\n" ], "database": "global-power-plants", "sql": "select sql from sqlite_master where name = :n and type=:t", "params": { "n": "global-power-plants", "t": "view" } }, { "type": "sql", "start": 21127.285560959, "end": 21127.286153626, "duration_ms": 0.5926669982727617, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/base_events.py\", line 1859, in _run_once\n handle._run()\n", " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 291, in table_exists\n results = await self.execute(\n" ], "database": "global-power-plants", "sql": "select 1 from sqlite_master where type='table' and name=?", "params": [ "global-power-plants" ] }, { "type": "sql", "start": 21127.288863718, "end": 21127.289485273, "duration_ms": 0.6215549983608071, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 361, in get\n response_or_template_contexts = await self.data(request, **data_kwargs)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 157, in data\n return await self._data_traced(request, default_labels, _next, _size)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 478, in _data_traced\n results = await db.execute(sql, params, truncate=True, **extra_args)\n" ], "database": "global-power-plants", "sql": "select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 order by rowid limit 101", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.28966919, "end": 21127.289880419, "duration_ms": 0.21122900216141716, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 361, in get\n response_or_template_contexts = await self.data(request, **data_kwargs)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 157, in data\n return await self._data_traced(request, default_labels, _next, _size)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 498, in _data_traced\n count_rows = list(await db.execute(count_sql, from_sql_params))\n" ], "database": "global-power-plants", "sql": "select count(*) from [global-power-plants] where \"owner\" = :p0", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.290492382, "end": 21127.291832398, "duration_ms": 1.3400160023593344, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 216, in facet_results\n facet_rows_results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select country_long as value, count(*) as count from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n )\n where country_long is not null\n group by country_long order by count desc, value limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.290679091, "end": 21127.29220067, "duration_ms": 1.5215790008369368, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 146, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 124, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select * from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 ) limit 0", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.290725163, "end": 21127.292946533, "duration_ms": 2.221370003098855, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 445, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 124, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select * from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 ) limit 0", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.290763494, "end": 21127.293383693, "duration_ms": 2.620199000375578, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 289, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 124, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select * from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 ) limit 0", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.293316846, "end": 21127.295636018, "duration_ms": 2.319171999261016, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(rowid) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where rowid glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.294023972, "end": 21127.297032204, "duration_ms": 3.0082319972279947, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 216, in facet_results\n facet_rows_results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select owner as value, count(*) as count from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n )\n where owner is not null\n group by owner order by count desc, value limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.29619259, "end": 21127.2976545, "duration_ms": 1.4619099965784699, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(country) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where country glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.292742239, "end": 21127.297946729, "duration_ms": 5.204490000323858, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select rowid as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.293592041, "end": 21127.299881654, "duration_ms": 6.2896130002627615, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(rowid)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where rowid is not null and rowid != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.297840796, "end": 21127.309993606, "duration_ms": 12.152809998951852, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(country_long) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where country_long glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.301121414, "end": 21127.310667885, "duration_ms": 9.546471002977341, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 216, in facet_results\n facet_rows_results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select primary_fuel as value, count(*) as count from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n )\n where primary_fuel is not null\n group by primary_fuel order by count desc, value limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.29893528, "end": 21127.318110953, "duration_ms": 19.175673001882387, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select country as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.31042223, "end": 21127.321684268, "duration_ms": 11.262038002314512, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(name) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where name glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.322825143, "end": 21127.323790623, "duration_ms": 0.9654799978306983, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(gppd_idnr) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where gppd_idnr glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.320968884, "end": 21127.324816821, "duration_ms": 3.8479370014101733, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select name as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.324574554, "end": 21127.325484701, "duration_ms": 0.9101469986489974, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(capacity_mw) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where capacity_mw glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.326072642, "end": 21127.326800253, "duration_ms": 0.7276109972735867, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(capacity_mw)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where capacity_mw is not null and capacity_mw != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.32589079, "end": 21127.327568772, "duration_ms": 1.677981999819167, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(latitude) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where latitude glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.325008221, "end": 21127.327871637, "duration_ms": 2.8634160007641185, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select gppd_idnr as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.327801523, "end": 21127.328838272, "duration_ms": 1.036748999467818, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(longitude) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where longitude glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.328469854, "end": 21127.330149488, "duration_ms": 1.6796339987195097, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select capacity_mw as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.329726092, "end": 21127.33097307, "duration_ms": 1.2469779976527207, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(primary_fuel) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where primary_fuel glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.330380847, "end": 21127.331790511, "duration_ms": 1.4096640006755479, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select latitude as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.32723558, "end": 21127.333975211, "duration_ms": 6.739631000527879, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(latitude)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where latitude is not null and latitude != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.331691465, "end": 21127.335539014, "duration_ms": 3.8475490000564605, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(other_fuel1) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where other_fuel1 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.335237821, "end": 21127.337457902, "duration_ms": 2.220080998085905, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(longitude)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where longitude is not null and longitude != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.337001898, "end": 21127.338234392, "duration_ms": 1.2324939998507034, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(other_fuel2) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where other_fuel2 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.333409309, "end": 21127.338519574, "duration_ms": 5.110264999530045, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select longitude as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.338416779, "end": 21127.340127986, "duration_ms": 1.7112070017901715, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(other_fuel3) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where other_fuel3 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.339655181, "end": 21127.340530338, "duration_ms": 0.8751569985179231, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(other_fuel1)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where other_fuel1 is not null and other_fuel1 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.33917742, "end": 21127.341316946, "duration_ms": 2.1395260009740014, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select other_fuel1 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.340458612, "end": 21127.341691814, "duration_ms": 1.233201997820288, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(commissioning_year) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where commissioning_year glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.340694235, "end": 21127.341958961, "duration_ms": 1.2647259973164182, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(other_fuel2)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where other_fuel2 is not null and other_fuel2 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.341615857, "end": 21127.342742485, "duration_ms": 1.1266280016570818, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select other_fuel2 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.341905711, "end": 21127.342985521, "duration_ms": 1.0798100011015777, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(owner) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where owner glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.342111916, "end": 21127.343179513, "duration_ms": 1.067597000655951, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(other_fuel3)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where other_fuel3 is not null and other_fuel3 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.342933432, "end": 21127.344059557, "duration_ms": 1.126125000155298, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select other_fuel3 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.343138205, "end": 21127.344313467, "duration_ms": 1.1752620011975523, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(source) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where source glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.343319879, "end": 21127.345490135, "duration_ms": 2.1702560006815474, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(commissioning_year)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where commissioning_year is not null and commissioning_year != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.344253423, "end": 21127.345815969, "duration_ms": 1.5625460000592284, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select commissioning_year as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.344789187, "end": 21127.346307498, "duration_ms": 1.5183110008365475, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(url) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where url glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.346187485, "end": 21127.347539208, "duration_ms": 1.3517229999706615, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select source as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.346478576, "end": 21127.348092093, "duration_ms": 1.6135170008055866, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(geolocation_source) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where geolocation_source glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.348270262, "end": 21127.349394223, "duration_ms": 1.1239610030315816, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(wepp_id) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where wepp_id glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.349578136, "end": 21127.35051275, "duration_ms": 0.9346139995614067, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(year_of_capacity_data) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where year_of_capacity_data glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.347851181, "end": 21127.35076341, "duration_ms": 2.9122289997758344, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select url as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.350702156, "end": 21127.351704788, "duration_ms": 1.0026320014731027, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2013) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2013 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.350124125, "end": 21127.352018137, "duration_ms": 1.8940119989565574, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(wepp_id)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where wepp_id is not null and wepp_id != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.351429281, "end": 21127.352806863, "duration_ms": 1.3775820007140283, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select geolocation_source as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.351967692, "end": 21127.353592972, "duration_ms": 1.6252799978246912, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2014) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2014 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.352344695, "end": 21127.355245859, "duration_ms": 2.9011639999225736, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(year_of_capacity_data)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where year_of_capacity_data is not null and year_of_capacity_data != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.353306909, "end": 21127.355589388, "duration_ms": 2.2824789994047023, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select wepp_id as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.355448643, "end": 21127.35770159, "duration_ms": 2.252947000670247, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2013)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2013 is not null and generation_gwh_2013 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.355023016, "end": 21127.357984818, "duration_ms": 2.961802001664182, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2015) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2015 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.357931045, "end": 21127.359198543, "duration_ms": 1.2674979989242274, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2014)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2014 is not null and generation_gwh_2014 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.358160214, "end": 21127.359433952, "duration_ms": 1.2737379984173458, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2016) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2016 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.359381093, "end": 21127.360004593, "duration_ms": 0.623500000074273, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2015)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2015 is not null and generation_gwh_2015 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.359582205, "end": 21127.360217122, "duration_ms": 0.6349169998429716, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2017) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2017 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.360170247, "end": 21127.362229298, "duration_ms": 2.059050999378087, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2016)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2016 is not null and generation_gwh_2016 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.360379873, "end": 21127.362873376, "duration_ms": 2.49350300146034, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2018) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2018 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.357255349, "end": 21127.363652025, "duration_ms": 6.396675998985302, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select year_of_capacity_data as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.362807242, "end": 21127.364075826, "duration_ms": 1.2685840010817628, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2017)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2017 is not null and generation_gwh_2017 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.363354727, "end": 21127.364547671, "duration_ms": 1.1929440006497316, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2019) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2019 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.364011277, "end": 21127.365240355, "duration_ms": 1.229077999596484, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2013 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.364898576, "end": 21127.365834016, "duration_ms": 0.935439999011578, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_data_source) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_data_source glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.364381124, "end": 21127.366117858, "duration_ms": 1.736734000587603, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2018)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2018 is not null and generation_gwh_2018 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.365431351, "end": 21127.366603294, "duration_ms": 1.1719429967342876, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2014 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.366058013, "end": 21127.367293112, "duration_ms": 1.235099000041373, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_gwh_2013) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_gwh_2013 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.366790712, "end": 21127.367774708, "duration_ms": 0.9839960002864245, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2015 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.366451577, "end": 21127.368333322, "duration_ms": 1.881744999991497, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2019)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2019 is not null and generation_gwh_2019 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.367980569, "end": 21127.368803504, "duration_ms": 0.8229349987232126, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2016 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.36762221, "end": 21127.369401266, "duration_ms": 1.779056001396384, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_gwh_2014) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_gwh_2014 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.368636693, "end": 21127.369908799, "duration_ms": 1.2721059974865057, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_data_source)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_data_source is not null and generation_data_source != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.3689813, "end": 21127.370496702, "duration_ms": 1.5154020002228208, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2017 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.369604823, "end": 21127.370718722, "duration_ms": 1.1138989975734148, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_gwh_2015) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_gwh_2015 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.370075201, "end": 21127.371205815, "duration_ms": 1.1306140004307963, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(estimated_generation_gwh_2013)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where estimated_generation_gwh_2013 is not null and estimated_generation_gwh_2013 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.37086215, "end": 21127.371835508, "duration_ms": 0.9733579972817097, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_gwh_2016) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_gwh_2016 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.370669541, "end": 21127.372151325, "duration_ms": 1.4817839983152226, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2018 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.371404649, "end": 21127.372814857, "duration_ms": 1.4102080021984875, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(estimated_generation_gwh_2014)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where estimated_generation_gwh_2014 is not null and estimated_generation_gwh_2014 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.372086499, "end": 21127.373093505, "duration_ms": 1.00700600160053, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_gwh_2017) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_gwh_2017 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.372310326, "end": 21127.373572147, "duration_ms": 1.2618209984793793, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2019 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.373268343, "end": 21127.374128481, "duration_ms": 0.8601379995525349, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_note_2013) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_note_2013 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.373785694, "end": 21127.374861823, "duration_ms": 1.0761289995571133, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_data_source as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.373026625, "end": 21127.375691377, "duration_ms": 2.6647520026017446, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(estimated_generation_gwh_2015)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where estimated_generation_gwh_2015 is not null and estimated_generation_gwh_2015 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.375351158, "end": 21127.378890132, "duration_ms": 3.538974000548478, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_gwh_2013 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.374451084, "end": 21127.379122712, "duration_ms": 4.671627997595351, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_note_2014) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_note_2014 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.379059669, "end": 21127.380520292, "duration_ms": 1.4606229997298215, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_gwh_2014 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.378689402, "end": 21127.380960012, "duration_ms": 2.2706099989591166, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(estimated_generation_gwh_2016)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where estimated_generation_gwh_2016 is not null and estimated_generation_gwh_2016 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.379280785, "end": 21127.381225106, "duration_ms": 1.9443210003373679, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_note_2015) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_note_2015 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.380802025, "end": 21127.383100555, "duration_ms": 2.2985299983702134, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_gwh_2015 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.381910816, "end": 21127.383840754, "duration_ms": 1.929938000102993, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_note_2016) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_note_2016 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.381157027, "end": 21127.384211623, "duration_ms": 3.0545959998562466, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(estimated_generation_gwh_2017)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where estimated_generation_gwh_2017 is not null and estimated_generation_gwh_2017 != ''", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.38365744, "end": 21127.384715739, "duration_ms": 1.0582989998511039, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_gwh_2016 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.384138662, "end": 21127.386687472, "duration_ms": 2.5488100000075065, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_note_2017) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_note_2017 glob \"????-??-*\" limit 100;", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.385422176, "end": 21127.387702571, "duration_ms": 2.280394997796975, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_gwh_2017 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.388098863, "end": 21127.389435061, "duration_ms": 1.3361979981709737, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_note_2013 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.389622888, "end": 21127.391003434, "duration_ms": 1.3805460002913605, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_note_2014 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.391257509, "end": 21127.392611951, "duration_ms": 1.3544419998652302, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_note_2015 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.396643844, "end": 21127.397439661, "duration_ms": 0.7958169990160968, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_note_2016 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.39789298, "end": 21127.398481632, "duration_ms": 0.5886520011699758, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_note_2017 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "GLOW Group" } }, { "type": "sql", "start": 21127.407426788, "end": 21127.407790656, "duration_ms": 0.363868002750678, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 758, in extra_template\n \"view_definition\": await db.get_view_definition(table_name),\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 431, in get_view_definition\n return await self.get_table_definition(view, \"view\")\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 411, in get_table_definition\n await self.execute(\n" ], "database": "global-power-plants", "sql": "select sql from sqlite_master where name = :n and type=:t", "params": { "n": "global-power-plants", "t": "view" } }, { "type": "sql", "start": 21127.408061974, "end": 21127.408724935, "duration_ms": 0.6629609997617081, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 454, in get\n extras = await extras\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 759, in extra_template\n \"table_definition\": await db.get_table_definition(table_name),\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 411, in get_table_definition\n await self.execute(\n" ], "database": "global-power-plants", "sql": "select sql from sqlite_master where name = :n and type=:t", "params": { "n": "global-power-plants", "t": "table" } }, { "type": "sql", "start": 21127.410561919, "end": 21127.410948719, "duration_ms": 0.3867999985232018, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 454, in get\n extras = await extras\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 759, in extra_template\n \"table_definition\": await db.get_table_definition(table_name),\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 421, in get_table_definition\n await self.execute(\n" ], "database": "global-power-plants", "sql": "select sql from sqlite_master where tbl_name = :n and type='index' and sql is not null", "params": { "n": "global-power-plants" } }, { "type": "sql", "start": 21127.43157466, "end": 21127.43198761, "duration_ms": 0.41295000119134784, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n value = await value\n", " File \"/usr/local/lib/python3.8/site-packages/datasette_graphql/__init__.py\", line 212, in inner\n db_schema = await schema_for_database_via_cache(datasette, database=database)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette_graphql/utils.py\", line 76, in schema_for_database_via_cache\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "global-power-plants", "sql": "PRAGMA schema_version", "params": null } ] }