global-power-plants: global-power-plants: 8 rows where country

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

8 rows where country_long = "Armenia"

Search:

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid ▼	country	country_long	name	gppd_idnr	capacity_mw	latitude	longitude	primary_fuel	commissioning_year	owner	source	url	geolocation_source	wepp_id	estimated_generation_gwh_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
329	329	ARM	Armenia	Armenian-2	WRI1019028	375.0	40.1805	44.1498	Nuclear	1980.0	Armenian Nuclear Power Company	IAEA	https://www.iaea.org/PRIS/CountryStatistics/ReactorDetails.aspx?current=2	GEODB	1010334					2411.04	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	CAPACITY-FACTOR-V1
330	330	ARM	Armenia	Hrazadan	WRI1019027	1110.0	40.564	44.7479	Gas		Hrazdan Energy Company	Armenia Ministry of Energy and Natural Resources	http://www.minenergy.am/en/page/532	GEODB	1010329					6712.82	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	CAPACITY-FACTOR-V1
331	331	ARM	Armenia	New Yerevan	WRI1019026	271.0	40.1152	44.4973	Gas	2010.0	Yerevan TPP	Armenia Ministry of Energy and Natural Resources	http://www.minenergy.am/en/page/531	WRI						1638.89	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	CAPACITY-FACTOR-V1
332	332	ARM	Armenia	Sevan-Hrazdan Cascade	WRI1003805	561.0	40.5078	44.7606	Hydro		RusHydro	Armenia Ministry of Energy and Natural Resources	http://www.minenergy.am/en/page/534	GEODB		847.52	854.95	838.63	846.61	853.67	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
333	333	ARM	Armenia	Shamb	WRI1019030	170.0	39.4743	46.1306	Hydro	1978.0	Ministry of Energy an Natural Resources	Armenia Ministry of Energy and Natural Resources	http://www.minenergy.am/en/page/533	GEODB		254.59	248.21	225.18	234.89	226.04	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
334	334	ARM	Armenia	Spandaryan	WRI1019031	76.0	39.6494	45.85	Hydro	1989.0	Ministry of Energy an Natural Resources	Armenia Ministry of Energy and Natural Resources	http://www.minenergy.am/en/page/533	GEODB		91.89	59.65	134.22	106.8	91.89	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
335	335	ARM	Armenia	Tatev	WRI1019029	158.0	39.3956	46.2578	Hydro	1970.0	Ministry of Energy an Natural Resources	Armenia Ministry of Energy and Natural Resources	http://www.minenergy.am/en/page/533	WRI	1010339	218.42	218.42	218.37	219.59	263.44	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
336	336	ARM	Armenia	Yerevan	WRI1019025	550.0	40.1138	44.5038	Gas		Yerevan TPP	Armenia Ministry of Energy and Natural Resources	http://www.minenergy.am/en/page/531	WRI						3326.17	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": 110.93641999832471, "sum_trace_duration_ms": 153.12785101559712, "num_traces": 111, "traces": [ { "type": "sql", "start": 24879.235763744, "end": 24879.236257615, "duration_ms": 0.4938710007991176, "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": 24879.236503213, "end": 24879.236820906, "duration_ms": 0.3176930003974121, "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": 24879.237034143, "end": 24879.237317227, "duration_ms": 0.2830840021488257, "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": 24879.237774464, "end": 24879.238334626, "duration_ms": 0.5601619996014051, "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": 24879.237837592, "end": 24879.238503972, "duration_ms": 0.6663799977104645, "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": 24879.241473617, "end": 24879.242106103, "duration_ms": 0.6324860005406663, "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 101", "params": { "p0": "Armenia" } }, { "type": "sql", "start": 24879.242283108, "end": 24879.242620437, "duration_ms": 0.33732899828464724, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 361, in get\n response_or_template_contexts = await self.data(request, **data_kwargs)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 157, in data\n return await self._data_traced(request, default_labels, _next, _size)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 498, in _data_traced\n count_rows = list(await db.execute(count_sql, from_sql_params))\n" ], "database": "global-power-plants", "sql": "select count(*) from [global-power-plants] where \"country_long\" = :p0", "params": { "p0": "Armenia" } }, { "type": "sql", "start": 24879.243454817, "end": 24879.244028778, "duration_ms": 0.5739610023738351, "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": "Armenia" } }, { "type": "sql", "start": 24879.243497423, "end": 24879.244471846, "duration_ms": 0.9744230010255706, "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": "Armenia" } }, { "type": "sql", "start": 24879.243535599, "end": 24879.244806796, "duration_ms": 1.2711970011878293, "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": "Armenia" } }, { "type": "sql", "start": 24879.244410131, "end": 24879.245856761, "duration_ms": 1.4466300017375033, "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": "Armenia" } }, { "type": "sql", "start": 24879.244665478, "end": 24879.24641983, "duration_ms": 1.754352000716608, "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": "Armenia" } }, { "type": "sql", "start": 24879.243251129, "end": 24879.24685248, "duration_ms": 3.6013509998156223, "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": "Armenia" } }, { "type": "sql", "start": 24879.244996342, "end": 24879.247203159, "duration_ms": 2.2068170001148246, "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": "Armenia" } }, { "type": "sql", "start": 24879.246681021, "end": 24879.24796967, "duration_ms": 1.2886490003438666, "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": "Armenia" } }, { "type": "sql", "start": 24879.246341041, "end": 24879.248339328, "duration_ms": 1.9982870035164524, "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": "Armenia" } }, { "type": "sql", "start": 24879.248188339, "end": 24879.249806241, "duration_ms": 1.6179020021809265, "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": "Armenia" } }, { "type": "sql", "start": 24879.249108922, "end": 24879.250489519, "duration_ms": 1.3805970011162572, "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": "Armenia" } }, { "type": "sql", "start": 24879.250067514, "end": 24879.251385293, "duration_ms": 1.3177789987821598, "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": "Armenia" } }, { "type": "sql", "start": 24879.248679423, "end": 24879.252177727, "duration_ms": 3.4983040022780187, "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": "Armenia" } }, { "type": "sql", "start": 24879.251890949, "end": 24879.2546186, "duration_ms": 2.727651000896003, "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": "Armenia" } }, { "type": "sql", "start": 24879.252400496, "end": 24879.255763355, "duration_ms": 3.362858999025775, "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": "Armenia" } }, { "type": "sql", "start": 24879.254818244, "end": 24879.256112374, "duration_ms": 1.2941300010425039, "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": "Armenia" } }, { "type": "sql", "start": 24879.254162702, "end": 24879.257164509, "duration_ms": 3.001806999236578, "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": "Armenia" } }, { "type": "sql", "start": 24879.256042224, "end": 24879.257559094, "duration_ms": 1.5168700010690372, "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": "Armenia" } }, { "type": "sql", "start": 24879.256352455, "end": 24879.257772409, "duration_ms": 1.419954001903534, "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": "Armenia" } }, { "type": "sql", "start": 24879.256431828, "end": 24879.25834388, "duration_ms": 1.9120520009892061, "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": "Armenia" } }, { "type": "sql", "start": 24879.257729635, "end": 24879.260319996, "duration_ms": 2.5903610003297217, "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": "Armenia" } }, { "type": "sql", "start": 24879.258222279, "end": 24879.261048421, "duration_ms": 2.826142001140397, "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": "Armenia" } }, { "type": "sql", "start": 24879.258510984, "end": 24879.261290483, "duration_ms": 2.7794989982794505, "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": "Armenia" } }, { "type": "sql", "start": 24879.260519268, "end": 24879.261865227, "duration_ms": 1.3459590009006206, "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": "Armenia" } }, { "type": "sql", "start": 24879.261451638, "end": 24879.262424222, "duration_ms": 0.9725839991006069, "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": "Armenia" } }, { "type": "sql", "start": 24879.261235376, "end": 24879.263116455, "duration_ms": 1.8810789988492616, "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": "Armenia" } }, { "type": "sql", "start": 24879.262250307, "end": 24879.263396426, "duration_ms": 1.1461189969850238, "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": "Armenia" } }, { "type": "sql", "start": 24879.263558263, "end": 24879.264519588, "duration_ms": 0.9613250003894791, "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": "Armenia" } }, { "type": "sql", "start": 24879.263341503, "end": 24879.265026514, "duration_ms": 1.6850110005179886, "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": "Armenia" } }, { "type": "sql", "start": 24879.263902569, "end": 24879.265893299, "duration_ms": 1.9907300011254847, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(other_fuel1)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"country_long\" = :p0 )\n where other_fuel1 is not null and other_fuel1 != ''", "params": { "p0": "Armenia" } }, { "type": "sql", "start": 24879.264735241, "end": 24879.266367068, "duration_ms": 1.6318270027113613, "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": "Armenia" } }, { "type": "sql", "start": 24879.265330298, "end": 24879.266736679, "duration_ms": 1.406381001288537, "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": "Armenia" } }, { "type": "sql", "start": 24879.266160289, "end": 24879.266995925, "duration_ms": 0.8356360012840014, "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": "Armenia" } }, { "type": "sql", "start": 24879.266652364, "end": 24879.267700874, "duration_ms": 1.0485099992365576, "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": "Armenia" } }, { "type": "sql", "start": 24879.266896026, "end": 24879.268034902, "duration_ms": 1.1388759994588327, "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": "Armenia" } }, { "type": "sql", "start": 24879.267206414, "end": 24879.268412724, "duration_ms": 1.206310000270605, "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": "Armenia" } }, { "type": "sql", "start": 24879.268262519, "end": 24879.269334853, "duration_ms": 1.0723340019467287, "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": "Armenia" } }, { "type": "sql", "start": 24879.267974742, "end": 24879.26958427, "duration_ms": 1.6095280006993562, "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": "Armenia" } }, { "type": "sql", "start": 24879.268580317, "end": 24879.270121087, "duration_ms": 1.5407700011564884, "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": "Armenia" } }, { "type": "sql", "start": 24879.269524127, "end": 24879.270827543, "duration_ms": 1.3034160001552664, "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": "Armenia" } }, { "type": "sql", "start": 24879.270072878, "end": 24879.271590193, "duration_ms": 1.5173149986367207, "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": "Armenia" } }, { "type": "sql", "start": 24879.27105742, "end": 24879.272252125, "duration_ms": 1.1947050006710924, "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": "Armenia" } }, { "type": "sql", "start": 24879.272563322, "end": 24879.273208094, "duration_ms": 0.6447720006690361, "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": "Armenia" } }, { "type": "sql", "start": 24879.272123644, "end": 24879.273504428, "duration_ms": 1.3807840005028993, "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": "Armenia" } }, { "type": "sql", "start": 24879.273382657, "end": 24879.274821039, "duration_ms": 1.4383819980139378, "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": "Armenia" } }, { "type": "sql", "start": 24879.273975631, "end": 24879.275359921, "duration_ms": 1.3842900007148273, "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": "Armenia" } }, { "type": "sql", "start": 24879.275203061, "end": 24879.276083295, "duration_ms": 0.8802340016700327, "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": "Armenia" } }, { "type": "sql", "start": 24879.275849356, "end": 24879.276754088, "duration_ms": 0.9047320017998572, "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": "Armenia" } }, { "type": "sql", "start": 24879.276368424, "end": 24879.277282501, "duration_ms": 0.9140769980149344, "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": "Armenia" } }, { "type": "sql", "start": 24879.277531649, "end": 24879.279142161, "duration_ms": 1.6105120012070984, "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": "Armenia" } }, { "type": "sql", "start": 24879.278380893, "end": 24879.279439555, "duration_ms": 1.0586620010144543, "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": "Armenia" } }, { "type": "sql", "start": 24879.276933595, "end": 24879.279723349, "duration_ms": 2.7897539985133335, "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": "Armenia" } }, { "type": "sql", "start": 24879.279372505, "end": 24879.280535354, "duration_ms": 1.162848999229027, "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": "Armenia" } }, { "type": "sql", "start": 24879.279609749, "end": 24879.280997493, "duration_ms": 1.3877439996576868, "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": "Armenia" } }, { "type": "sql", "start": 24879.279876623, "end": 24879.281571031, "duration_ms": 1.6944079980021343, "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": "Armenia" } }, { "type": "sql", "start": 24879.280825889, "end": 24879.28218218, "duration_ms": 1.3562909989559557, "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": "Armenia" } }, { "type": "sql", "start": 24879.281366766, "end": 24879.282683866, "duration_ms": 1.3170999991416465, "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": "Armenia" } }, { "type": "sql", "start": 24879.281834209, "end": 24879.283322583, "duration_ms": 1.4883740004734136, "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": "Armenia" } }, { "type": "sql", "start": 24879.282441414, "end": 24879.283571046, "duration_ms": 1.1296319971734192, "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": "Armenia" } }, { "type": "sql", "start": 24879.282850405, "end": 24879.283835153, "duration_ms": 0.9847479996096808, "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": "Armenia" } }, { "type": "sql", "start": 24879.283510955, "end": 24879.284693034, "duration_ms": 1.1820789986813907, "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": "Armenia" } }, { "type": "sql", "start": 24879.283992926, "end": 24879.285176102, "duration_ms": 1.18317599844886, "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": "Armenia" } }, { "type": "sql", "start": 24879.283725247, "end": 24879.285483907, "duration_ms": 1.7586599969945382, "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": "Armenia" } }, { "type": "sql", "start": 24879.285021272, "end": 24879.28610425, "duration_ms": 1.0829780003405176, "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": "Armenia" } }, { "type": "sql", "start": 24879.285647541, "end": 24879.286683835, "duration_ms": 1.036293997458415, "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": "Armenia" } }, { "type": "sql", "start": 24879.285421809, "end": 24879.287215461, "duration_ms": 1.7936520016519353, "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": "Armenia" } }, { "type": "sql", "start": 24879.286340142, "end": 24879.287485553, "duration_ms": 1.1454109990154393, "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": "Armenia" } }, { "type": "sql", "start": 24879.287423602, "end": 24879.288240013, "duration_ms": 0.8164110004145186, "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": "Armenia" } }, { "type": "sql", "start": 24879.287004701, "end": 24879.288496052, "duration_ms": 1.4913509985490236, "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": "Armenia" } }, { "type": "sql", "start": 24879.287782421, "end": 24879.288842453, "duration_ms": 1.0600319983495865, "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": "Armenia" } }, { "type": "sql", "start": 24879.288405837, "end": 24879.289500434, "duration_ms": 1.09459699888248, "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": "Armenia" } }, { "type": "sql", "start": 24879.289048806, "end": 24879.290010185, "duration_ms": 0.9613789989089128, "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": "Armenia" } }, { "type": "sql", "start": 24879.288651127, "end": 24879.290286664, "duration_ms": 1.6355369989469182, "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": "Armenia" } }, { "type": "sql", "start": 24879.28986116, "end": 24879.290822298, "duration_ms": 0.961138001002837, "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": "Armenia" } }, { "type": "sql", "start": 24879.290666948, "end": 24879.291569209, "duration_ms": 0.9022609992825892, "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": "Armenia" } }, { "type": "sql", "start": 24879.290237216, "end": 24879.291981878, "duration_ms": 1.7446620004193392, "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": "Armenia" } }, { "type": "sql", "start": 24879.291045844, "end": 24879.29247767, "duration_ms": 1.4318260000436567, "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": "Armenia" } }, { "type": "sql", "start": 24879.292318167, "end": 24879.293073874, "duration_ms": 0.7557069984613918, "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": "Armenia" } }, { "type": "sql", "start": 24879.29190523, "end": 24879.29382765, "duration_ms": 1.9224200004828162, "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": "Armenia" } }, { "type": "sql", "start": 24879.29272807, "end": 24879.294198638, "duration_ms": 1.4705680005135946, "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": "Armenia" } }, { "type": "sql", "start": 24879.293307902, "end": 24879.294476203, "duration_ms": 1.168300997960614, "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": "Armenia" } }, { "type": "sql", "start": 24879.29434744, "end": 24879.295210068, "duration_ms": 0.8626279995951336, "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": "Armenia" } }, { "type": "sql", "start": 24879.294143129, "end": 24879.295566672, "duration_ms": 1.4235430026019458, "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": "Armenia" } }, { "type": "sql", "start": 24879.294742322, "end": 24879.296208572, "duration_ms": 1.4662499997939449, "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": "Armenia" } }, { "type": "sql", "start": 24879.295802535, "end": 24879.296668252, "duration_ms": 0.8657169964862987, "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": "Armenia" } }, { "type": "sql", "start": 24879.295415175, "end": 24879.296942763, "duration_ms": 1.52758800322772, "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": "Armenia" } }, { "type": "sql", "start": 24879.29651101, "end": 24879.297619868, "duration_ms": 1.108857999497559, "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": "Armenia" } }, { "type": "sql", "start": 24879.296895482, "end": 24879.298064307, "duration_ms": 1.168825001514051, "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": "Armenia" } }, { "type": "sql", "start": 24879.297231589, "end": 24879.2989335, "duration_ms": 1.7019109982356895, "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": "Armenia" } }, { "type": "sql", "start": 24879.297935108, "end": 24879.299162952, "duration_ms": 1.2278440008230973, "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": "Armenia" } }, { "type": "sql", "start": 24879.298221627, "end": 24879.300030768, "duration_ms": 1.809141002013348, "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": "Armenia" } }, { "type": "sql", "start": 24879.299109668, "end": 24879.300958148, "duration_ms": 1.8484799984435085, "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": "Armenia" } }, { "type": "sql", "start": 24879.3007384, "end": 24879.301688848, "duration_ms": 0.9504480003670324, "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": "Armenia" } }, { "type": "sql", "start": 24879.299671934, "end": 24879.301924033, "duration_ms": 2.25209899872425, "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": "Armenia" } }, { "type": "sql", "start": 24879.301868028, "end": 24879.303446016, "duration_ms": 1.5779880013724323, "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": "Armenia" } }, { "type": "sql", "start": 24879.302741941, "end": 24879.304339594, "duration_ms": 1.5976530012267176, "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": "Armenia" } }, { "type": "sql", "start": 24879.303744111, "end": 24879.305649642, "duration_ms": 1.9055310003750492, "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": "Armenia" } }, { "type": "sql", "start": 24879.305904457, "end": 24879.306451175, "duration_ms": 0.5467180017149076, "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": "Armenia" } }, { "type": "sql", "start": 24879.304895469, "end": 24879.306894607, "duration_ms": 1.999138003156986, "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": "Armenia" } }, { "type": "sql", "start": 24879.307394116, "end": 24879.307976068, "duration_ms": 0.5819520010845736, "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": "Armenia" } }, { "type": "sql", "start": 24879.320763263, "end": 24879.321195172, "duration_ms": 0.43190900032641366, "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": 24879.321385661, "end": 24879.32173576, "duration_ms": 0.3500990023894701, "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": 24879.321919897, "end": 24879.32227083, "duration_ms": 0.3509330017550383, "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": 24879.325435651, "end": 24879.32574147, "duration_ms": 0.30581899773096666, "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 } ] }