global-power-plants: global-power-plants: where country

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

where country_long = "Libya"

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	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
17144	17144	LBY	Libya	Al Khums	WRI1023832	1000.0	32.6204	14.3312	Gas	Oil			1995.0	General Electricity Company of Libya	Arab Union of Electricity	http://www.auptde.org/PublicationsFile.aspx?lang=en&CID=855	WRI	1109733														3989.57	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	CAPACITY-FACTOR-V1
17145	17145	LBY	Libya	Az Zawiyah	WRI1023835	1440.0	32.7882	12.674	Gas	Oil			2003.0	General Electricity Company of Libya	Arab Union of Electricity	http://www.auptde.org/PublicationsFile.aspx?lang=en&CID=855	WRI															5744.99	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": 1023.5684900001161, "sum_trace_duration_ms": 1919.6280949975062, "num_traces": 110, "traces": [ { "type": "sql", "start": 1753.379490179, "end": 1753.431079609, "duration_ms": 51.58943000014915, "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": 1753.431547399, "end": 1753.432312679, "duration_ms": 0.7652799999959825, "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": 1753.43269795, "end": 1753.434622348, "duration_ms": 1.9243980000283045, "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": 1753.435620447, "end": 1753.458442405, "duration_ms": 22.82195799989495, "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": 1753.435724568, "end": 1753.458747621, "duration_ms": 23.023052999860738, "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": 1753.551262938, "end": 1753.55491446, "duration_ms": 3.651521999927354, "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 \"country_long\" = :p0 order by rowid limit 3", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.556176535, "end": 1753.580088728, "duration_ms": 23.91219299988734, "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 \"country_long\" = :p0 \n )\n where country_long is not null\n group by country_long order by count desc, value limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.556782144, "end": 1753.580620339, "duration_ms": 23.83819500005302, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 145, in suggest\n row_count = await self.get_row_count()\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 132, in get_row_count\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 count(*) 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 \"country_long\" = :p0 )", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.556838532, "end": 1753.583213003, "duration_ms": 26.374471000053745, "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 \"country_long\" = :p0 ) limit 0", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.55687686, "end": 1753.600709593, "duration_ms": 43.83273299981738, "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 \"country_long\" = :p0 ) limit 0", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.58310993, "end": 1753.631423178, "duration_ms": 48.31324799988579, "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 \"country_long\" = :p0 ) limit 0", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.583557788, "end": 1753.631943513, "duration_ms": 48.385724999889135, "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 \"country_long\" = :p0 \n ) where rowid glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.601059757, "end": 1753.632772221, "duration_ms": 31.712464000065665, "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 \"country_long\" = :p0 )\n where rowid is not null and rowid != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.631164109, "end": 1753.63432584, "duration_ms": 3.161730999863721, "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 \"country_long\" = :p0 \n )\n where owner is not null\n group by owner order by count desc, value limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.632223588, "end": 1753.635556083, "duration_ms": 3.332494999995106, "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 \"country_long\" = :p0 \n ) where country glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.631792101, "end": 1753.636617224, "duration_ms": 4.8251230000460055, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.636265366, "end": 1753.661583152, "duration_ms": 25.317785999959597, "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 \"country_long\" = :p0 \n ) where country_long glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.636830334, "end": 1753.662191584, "duration_ms": 25.361250000059954, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.6615285, "end": 1753.6674604, "duration_ms": 5.931899999950474, "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 \"country_long\" = :p0 \n )\n where primary_fuel is not null\n group by primary_fuel order by count desc, value limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.662106509, "end": 1753.668018973, "duration_ms": 5.912463999948159, "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 \"country_long\" = :p0 \n ) where name glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.662413885, "end": 1753.668482303, "duration_ms": 6.068418000040765, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.668387792, "end": 1753.735541223, "duration_ms": 67.15343099995152, "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 \"country_long\" = :p0 \n ) where gppd_idnr glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.673892834, "end": 1753.736074766, "duration_ms": 62.181931999930384, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.736279259, "end": 1753.740979639, "duration_ms": 4.700380000031146, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.736398874, "end": 1753.741739204, "duration_ms": 5.340329999853566, "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 \"country_long\" = :p0 )\n where capacity_mw is not null and capacity_mw != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.735986177, "end": 1753.748432298, "duration_ms": 12.446120999811683, "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 \"country_long\" = :p0 \n ) where capacity_mw glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.741657231, "end": 1753.761075975, "duration_ms": 19.418743999949584, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.748100488, "end": 1753.761580703, "duration_ms": 13.480214999844975, "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 \"country_long\" = :p0 )\n where latitude is not null and latitude != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.748723765, "end": 1753.774685622, "duration_ms": 25.96185700008391, "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 \"country_long\" = :p0 \n ) where latitude glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.761415529, "end": 1753.776871783, "duration_ms": 15.456253999900582, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.774559571, "end": 1753.781585367, "duration_ms": 7.025795999879847, "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 \"country_long\" = :p0 )\n where longitude is not null and longitude != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.774912892, "end": 1753.781977234, "duration_ms": 7.064341999921453, "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 \"country_long\" = :p0 \n ) where longitude glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.781083299, "end": 1753.782791648, "duration_ms": 1.7083489999549784, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.782166737, "end": 1753.834128731, "duration_ms": 51.961994000066625, "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 \"country_long\" = :p0 \n ) where primary_fuel glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.833783977, "end": 1753.858826404, "duration_ms": 25.042427000016687, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.834342424, "end": 1753.864439129, "duration_ms": 30.096705000005386, "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 \"country_long\" = :p0 \n ) where other_fuel1 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.841457254, "end": 1753.864888498, "duration_ms": 23.431243999993967, "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 \"country_long\" = :p0 )\n where other_fuel2 is not null and other_fuel2 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.859370374, "end": 1753.865459663, "duration_ms": 6.089288999874043, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.864707383, "end": 1753.866439829, "duration_ms": 1.7324460000054387, "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 \"country_long\" = :p0 \n ) where other_fuel2 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.865298797, "end": 1753.871685272, "duration_ms": 6.386474999999336, "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 \"country_long\" = :p0 )\n where other_fuel3 is not null and other_fuel3 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.866006692, "end": 1753.871964424, "duration_ms": 5.957732000069882, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.871401737, "end": 1753.880089201, "duration_ms": 8.687463999876854, "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 \"country_long\" = :p0 \n ) where other_fuel3 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.871910722, "end": 1753.880694231, "duration_ms": 8.78350900006808, "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 \"country_long\" = :p0 )\n where commissioning_year is not null and commissioning_year != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.872527076, "end": 1753.930509254, "duration_ms": 57.98217799997474, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.880601446, "end": 1753.933913889, "duration_ms": 53.3124430000953, "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 \"country_long\" = :p0 \n ) where commissioning_year glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.93228382, "end": 1753.934548246, "duration_ms": 2.264426000010644, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.934472081, "end": 1753.956011857, "duration_ms": 21.53977600005419, "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 \"country_long\" = :p0 \n ) where owner glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.944976505, "end": 1753.957509378, "duration_ms": 12.532872999827305, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.957303305, "end": 1753.966957363, "duration_ms": 9.65405799979635, "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 \"country_long\" = :p0 \n ) where source glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.958410702, "end": 1754.03024729, "duration_ms": 71.83658799999648, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1753.970190171, "end": 1754.031461242, "duration_ms": 61.27107099996465, "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 \"country_long\" = :p0 \n ) where url glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.030635366, "end": 1754.032685194, "duration_ms": 2.049827999826448, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.031924445, "end": 1754.033669966, "duration_ms": 1.7455209999752697, "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 \"country_long\" = :p0 )\n where wepp_id is not null and wepp_id != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.03176538, "end": 1754.044824672, "duration_ms": 13.059291999979905, "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 \"country_long\" = :p0 \n ) where geolocation_source glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.032919119, "end": 1754.060247567, "duration_ms": 27.328447999934724, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.033934182, "end": 1754.060671894, "duration_ms": 26.73771200011288, "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 \"country_long\" = :p0 )\n where year_of_capacity_data is not null and year_of_capacity_data != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.045504859, "end": 1754.060944653, "duration_ms": 15.439794000030815, "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 \"country_long\" = :p0 \n ) where wepp_id glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.060891038, "end": 1754.076405329, "duration_ms": 15.514291000044977, "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 \"country_long\" = :p0 )\n where generation_gwh_2013 is not null and generation_gwh_2013 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.061287009, "end": 1754.077095426, "duration_ms": 15.808417000016561, "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 \"country_long\" = :p0 \n ) where year_of_capacity_data glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.060589814, "end": 1754.133026579, "duration_ms": 72.43676500002039, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.076997019, "end": 1754.13486472, "duration_ms": 57.86770100007743, "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 \"country_long\" = :p0 )\n where generation_gwh_2014 is not null and generation_gwh_2014 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.1311812, "end": 1754.135127251, "duration_ms": 3.946051000184525, "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 \"country_long\" = :p0 \n ) where generation_gwh_2013 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.133476588, "end": 1754.135376768, "duration_ms": 1.9001800001205993, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.13508235, "end": 1754.143037021, "duration_ms": 7.954671000106828, "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 \"country_long\" = :p0 )\n where generation_gwh_2015 is not null and generation_gwh_2015 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.135315479, "end": 1754.143705191, "duration_ms": 8.389712000052896, "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 \"country_long\" = :p0 \n ) where generation_gwh_2014 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.135549224, "end": 1754.147648924, "duration_ms": 12.099699999907898, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.143511226, "end": 1754.148206063, "duration_ms": 4.694836999988183, "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 \"country_long\" = :p0 )\n where generation_gwh_2016 is not null and generation_gwh_2016 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.14753705, "end": 1754.15904549, "duration_ms": 11.50843999994322, "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 \"country_long\" = :p0 \n ) where generation_gwh_2015 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.147862262, "end": 1754.159676976, "duration_ms": 11.814713999910964, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.148683631, "end": 1754.160306964, "duration_ms": 11.623332999988634, "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 \"country_long\" = :p0 )\n where generation_gwh_2017 is not null and generation_gwh_2017 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.159583302, "end": 1754.177054374, "duration_ms": 17.471071999807464, "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 \"country_long\" = :p0 \n ) where generation_gwh_2016 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.159981409, "end": 1754.177964692, "duration_ms": 17.983282999921357, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.160585736, "end": 1754.17854596, "duration_ms": 17.96022400003494, "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 \"country_long\" = :p0 )\n where generation_gwh_2018 is not null and generation_gwh_2018 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.177619071, "end": 1754.229623318, "duration_ms": 52.00424700001349, "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 \"country_long\" = :p0 \n ) where generation_gwh_2017 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.178387573, "end": 1754.230981154, "duration_ms": 52.59358099988276, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.230885613, "end": 1754.23205824, "duration_ms": 1.1726269999599026, "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 \"country_long\" = :p0 \n ) where generation_gwh_2018 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.178725783, "end": 1754.235352182, "duration_ms": 56.62639900015165, "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 \"country_long\" = :p0 )\n where generation_gwh_2019 is not null and generation_gwh_2019 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.231671771, "end": 1754.23583187, "duration_ms": 4.1600990000461024, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.232262291, "end": 1754.236618456, "duration_ms": 4.356164999990142, "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 \"country_long\" = :p0 \n ) where generation_gwh_2019 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.2356169, "end": 1754.2376642, "duration_ms": 2.0472999999583408, "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 \"country_long\" = :p0 )\n where generation_data_source is not null and generation_data_source != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.236551726, "end": 1754.246675479, "duration_ms": 10.123753000016222, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.237258757, "end": 1754.247595749, "duration_ms": 10.336992000020473, "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 \"country_long\" = :p0 \n ) where generation_data_source glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.246541123, "end": 1754.250943623, "duration_ms": 4.402499999969223, "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 \"country_long\" = :p0 )\n where estimated_generation_gwh_2013 is not null and estimated_generation_gwh_2013 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.247275784, "end": 1754.251379758, "duration_ms": 4.103973999917798, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.247949278, "end": 1754.251754332, "duration_ms": 3.8050539999403554, "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 \"country_long\" = :p0 \n ) where estimated_generation_gwh_2013 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.251270256, "end": 1754.253506106, "duration_ms": 2.235850000033679, "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 \"country_long\" = :p0 )\n where estimated_generation_gwh_2014 is not null and estimated_generation_gwh_2014 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.251681299, "end": 1754.253863983, "duration_ms": 2.1826839999903314, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.252109382, "end": 1754.254313951, "duration_ms": 2.2045690000140894, "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 \"country_long\" = :p0 \n ) where estimated_generation_gwh_2014 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.253771203, "end": 1754.255741886, "duration_ms": 1.9706829998540343, "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 \"country_long\" = :p0 )\n where estimated_generation_gwh_2015 is not null and estimated_generation_gwh_2015 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.254237529, "end": 1754.256163992, "duration_ms": 1.926463000017975, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.254572258, "end": 1754.256800601, "duration_ms": 2.2283429998424253, "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 \"country_long\" = :p0 \n ) where estimated_generation_gwh_2015 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.256068095, "end": 1754.262646423, "duration_ms": 6.5783279999322986, "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 \"country_long\" = :p0 )\n where estimated_generation_gwh_2016 is not null and estimated_generation_gwh_2016 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.256726345, "end": 1754.262968354, "duration_ms": 6.24200899983407, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.256999999, "end": 1754.263652456, "duration_ms": 6.6524569999728556, "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 \"country_long\" = :p0 \n ) where estimated_generation_gwh_2016 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.262903809, "end": 1754.266525308, "duration_ms": 3.6214990000189573, "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 \"country_long\" = :p0 )\n where estimated_generation_gwh_2017 is not null and estimated_generation_gwh_2017 != ''", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.263588859, "end": 1754.266854427, "duration_ms": 3.2655679999606946, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.263848747, "end": 1754.267160469, "duration_ms": 3.3117219998075598, "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 \"country_long\" = :p0 \n ) where estimated_generation_gwh_2017 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.26742344, "end": 1754.269034039, "duration_ms": 1.6105990000596648, "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 \"country_long\" = :p0 \n ) where estimated_generation_note_2013 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.267092874, "end": 1754.269945162, "duration_ms": 2.852288000212866, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.269306823, "end": 1754.329648025, "duration_ms": 60.3412020000178, "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 \"country_long\" = :p0 \n ) where estimated_generation_note_2014 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.270225793, "end": 1754.335743605, "duration_ms": 65.5178120000528, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.335623343, "end": 1754.337682262, "duration_ms": 2.058919000091919, "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 \"country_long\" = :p0 \n ) where estimated_generation_note_2015 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.335930052, "end": 1754.338174561, "duration_ms": 2.244508999865502, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.337934826, "end": 1754.339080098, "duration_ms": 1.1452720000306726, "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 \"country_long\" = :p0 \n ) where estimated_generation_note_2016 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.338344913, "end": 1754.339388075, "duration_ms": 1.04316200008725, "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 \"country_long\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.339292094, "end": 1754.366176762, "duration_ms": 26.884667999865997, "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 \"country_long\" = :p0 \n ) where estimated_generation_note_2017 glob \"????-??-*\" limit 100;", "params": { "p0": "Libya" } }, { "type": "sql", "start": 1754.380988216, "end": 1754.381435727, "duration_ms": 0.4475109999475535, "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": 1754.381694222, "end": 1754.382288835, "duration_ms": 0.5946129999756522, "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": 1754.382500121, "end": 1754.382843161, "duration_ms": 0.34303999996154744, "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": 1754.385822599, "end": 1754.386323961, "duration_ms": 0.5013620000227093, "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 } ] }