global-power-plants: global-power-plants: 13 rows where owner = "PLN

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

13 rows where owner = "PLN - Java Bali Generation Unit / PT. PJB"

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	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
15658	15658	IDN	Indonesia	CirataI & II	WRI1000748	1008.0	-6.7004	107.3671	Hydro	PLN - Java Bali Generation Unit / PT. PJB	Indonesia Power Generation	https://repit.wordpress.com/	WRI	1026056	3426.09	2354.32	3099.69	3272.44	3205.36	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
15662	15662	IDN	Indonesia	Giringan - Pamekasan	WRI1000755	3.2	-7.7201	111.6715	Hydro	PLN - Java Bali Generation Unit / PT. PJB	Indonesia Power Generation	https://repit.wordpress.com/	CARMA	1026067	6.65	6.55	7.17	7.1	7.08	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
15663	15663	IDN	Indonesia	Golang - Pamekasan	WRI1000756	2.7	-8.1408	111.1317	Hydro	PLN - Java Bali Generation Unit / PT. PJB	Indonesia Power Generation	https://repit.wordpress.com/	CARMA	1026068	9.34	6.6	8.09	9.68	9.64	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
15685	15685	IDN	Indonesia	Lodoyo - Brantas	WRI1000783	4.5	-8.1613	112.2173	Hydro	PLN - Java Bali Generation Unit / PT. PJB	Indonesia Power Generation	https://repit.wordpress.com/	CARMA	1026092	17.16	12.97	15.44	18.26	17.08	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
15688	15688	IDN	Indonesia	Mendalan - Brantas	WRI1000788	23.0	-7.854	112.3316	Hydro	PLN - Java Bali Generation Unit / PT. PJB	Indonesia Power Generation	https://repit.wordpress.com/	CARMA	1026099	89.18	64.91	69.64	87.87	83.64	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
15692	15692	IDN	Indonesia	Ngebel - Pamekasan	WRI1000793	2.2	-7.7891	111.6167	Hydro	PLN - Java Bali Generation Unit / PT. PJB	Indonesia Power Generation	https://repit.wordpress.com/	CARMA	1026106	7.89	7.12	8.26	8.38	7.91	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
15747	15747	IDN	Indonesia	PLTU Gresik	WRI1000929	600.0	-7.1633	112.6615	Coal	PLN - Java Bali Generation Unit / PT. PJB	Indonesia Power Generation	https://repit.wordpress.com/	WRI	1026070					3265.18	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	CAPACITY-FACTOR-V1
15758	15758	IDN	Indonesia	PLTU Muara Karang	WRI1000954	400.0	-6.1069	106.7882	Coal	PLN - Java Bali Generation Unit / PT. PJB	Indonesia Power Generation	https://repit.wordpress.com/	WRI	1026102					2176.79	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	NO-ESTIMATION	CAPACITY-FACTOR-V1
15798	15798	IDN	Indonesia	Sengguruh - Brantas	WRI1001010	29.0	-8.1764	112.551	Hydro	PLN - Java Bali Generation Unit / PT. PJB	Indonesia Power Generation	https://repit.wordpress.com/	CARMA	1026143	99.96	68.14	80.5	104.17	99.98	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
15806	15806	IDN	Indonesia	Sutami / Karangkates - Brantas	WRI1001021	105.0	-8.1606	112.4443	Hydro	PLN - Java Bali Generation Unit / PT. PJB	Indonesia Power Generation	https://repit.wordpress.com/	WRI	1026154	371.79	266.78	301.33	387.04	371.86	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
15814	15814	IDN	Indonesia	Tulungagung - Brantas	WRI1001038	36.0	-8.0657	111.9025	Hydro	PLN - Java Bali Generation Unit / PT. PJB	Indonesia Power Generation	https://repit.wordpress.com/	CARMA	1026172	125.46	98.39	106.37	124.04	132.82	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
15818	15818	IDN	Indonesia	Wlingi - Brantas	WRI1001045	54.0	-8.0776	112.3311	Hydro	PLN - Java Bali Generation Unit / PT. PJB	Indonesia Power Generation	https://repit.wordpress.com/	CARMA	1026178	158.18	138.62	149.71	161.31	165.44	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1
15819	15819	IDN	Indonesia	Wonorejo - Pamekasan	WRI1001046	6.3	-8.1136	112.2869	Hydro	PLN - Java Bali Generation Unit / PT. PJB	Indonesia Power Generation	https://repit.wordpress.com/	CARMA	1055424	24.89	17.37	21.45	26.43	24.77	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-V1	HYDRO-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": 127.61810300071375, "sum_trace_duration_ms": 156.8673829715408, "num_traces": 111, "traces": [ { "type": "sql", "start": 24709.829062099, "end": 24709.829418414, "duration_ms": 0.3563149984984193, "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": 24709.829634166, "end": 24709.82996127, "duration_ms": 0.3271040004619863, "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": 24709.830149142, "end": 24709.830403233, "duration_ms": 0.25409100271645, "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": 24709.830841776, "end": 24709.831265891, "duration_ms": 0.4241149981680792, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/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": 24709.830903592, "end": 24709.831664406, "duration_ms": 0.7608140003867447, "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": 24709.834601816, "end": 24709.83540844, "duration_ms": 0.8066240006883163, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 361, in get\n response_or_template_contexts = await self.data(request, **data_kwargs)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 157, in data\n return await self._data_traced(request, default_labels, _next, _size)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 478, in _data_traced\n results = await db.execute(sql, params, truncate=True, **extra_args)\n" ], "database": "global-power-plants", "sql": "select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 order by rowid limit 101", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.835608921, "end": 24709.835942743, "duration_ms": 0.33382200126652606, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 361, in get\n response_or_template_contexts = await self.data(request, **data_kwargs)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 157, in data\n return await self._data_traced(request, default_labels, _next, _size)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 498, in _data_traced\n count_rows = list(await db.execute(count_sql, from_sql_params))\n" ], "database": "global-power-plants", "sql": "select count(*) from [global-power-plants] where \"owner\" = :p0", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.836844992, "end": 24709.837986269, "duration_ms": 1.1412769999878947, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 146, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 124, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select * from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 ) limit 0", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.836890613, "end": 24709.838319535, "duration_ms": 1.428921998012811, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 445, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 124, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select * from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 ) limit 0", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.837202198, "end": 24709.83866635, "duration_ms": 1.464151999243768, "traceback": [ " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 289, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 124, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select * from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 ) limit 0", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.836597602, "end": 24709.838904635, "duration_ms": 2.3070329989423044, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 216, in facet_results\n facet_rows_results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select country_long as value, count(*) as count from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n )\n where country_long is not null\n group by country_long order by count desc, value limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.838264913, "end": 24709.83964999, "duration_ms": 1.3850770010321867, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select rowid as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.83886113, "end": 24709.842067771, "duration_ms": 3.206640998541843, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(rowid)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where rowid is not null and rowid != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.838589827, "end": 24709.842382431, "duration_ms": 3.7926040022284724, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(rowid) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where rowid glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.83991617, "end": 24709.842901619, "duration_ms": 2.985448998515494, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select country as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.840389906, "end": 24709.843244533, "duration_ms": 2.854627000488108, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 216, in facet_results\n facet_rows_results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select owner as value, count(*) as count from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n )\n where owner is not null\n group by owner order by count desc, value limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.842835443, "end": 24709.845129997, "duration_ms": 2.2945540004002396, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(country) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where country glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.845342504, "end": 24709.846830699, "duration_ms": 1.4881950010021683, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(country_long) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where country_long glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.843073328, "end": 24709.84717531, "duration_ms": 4.101981998246629, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select name as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.845894702, "end": 24709.847850885, "duration_ms": 1.95618299767375, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 216, in facet_results\n facet_rows_results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select primary_fuel as value, count(*) as count from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n )\n where primary_fuel is not null\n group by primary_fuel order by count desc, value limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.847034912, "end": 24709.848846011, "duration_ms": 1.8110989985871129, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(name) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where name glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.849365958, "end": 24709.851151335, "duration_ms": 1.7853769968496636, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(gppd_idnr) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where gppd_idnr glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.847685896, "end": 24709.851495407, "duration_ms": 3.809511003055377, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select gppd_idnr as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.850391614, "end": 24709.852368582, "duration_ms": 1.9769680002355017, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(capacity_mw)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where capacity_mw is not null and capacity_mw != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.851357708, "end": 24709.852721524, "duration_ms": 1.3638159980473574, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(capacity_mw) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where capacity_mw glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.852666963, "end": 24709.853486403, "duration_ms": 0.8194399997591972, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(latitude)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where latitude is not null and latitude != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.852923101, "end": 24709.853816707, "duration_ms": 0.8936060003179591, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(latitude) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where latitude glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.852102577, "end": 24709.854103212, "duration_ms": 2.000635002332274, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select capacity_mw as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.853670264, "end": 24709.854923194, "duration_ms": 1.2529300001915544, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(longitude)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where longitude is not null and longitude != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.854053462, "end": 24709.855145768, "duration_ms": 1.092305999918608, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(longitude) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where longitude glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.854390506, "end": 24709.855827316, "duration_ms": 1.4368100019055419, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select latitude as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.855424958, "end": 24709.856329329, "duration_ms": 0.9043709978868719, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(primary_fuel) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where primary_fuel glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.856161315, "end": 24709.857392259, "duration_ms": 1.230943998962175, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select longitude as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.856635723, "end": 24709.857757286, "duration_ms": 1.1215630001970567, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(other_fuel1) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where other_fuel1 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.857681864, "end": 24709.858556047, "duration_ms": 0.8741829988139216, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select other_fuel1 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.856957793, "end": 24709.859150011, "duration_ms": 2.1922180021647364, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(other_fuel1)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where other_fuel1 is not null and other_fuel1 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.858094507, "end": 24709.859528558, "duration_ms": 1.4340510024339892, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(other_fuel2) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where other_fuel2 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.858946011, "end": 24709.860177763, "duration_ms": 1.231751997693209, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select other_fuel2 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.859464226, "end": 24709.860818021, "duration_ms": 1.3537949998863041, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(other_fuel2)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where other_fuel2 is not null and other_fuel2 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.859824313, "end": 24709.861059138, "duration_ms": 1.2348249983915593, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(other_fuel3) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where other_fuel3 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.860368508, "end": 24709.861490613, "duration_ms": 1.1221049971936736, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select other_fuel3 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.86100364, "end": 24709.86215461, "duration_ms": 1.1509700016176794, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(other_fuel3)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where other_fuel3 is not null and other_fuel3 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.861217072, "end": 24709.862499766, "duration_ms": 1.2826940001104958, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(commissioning_year) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where commissioning_year glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.861922495, "end": 24709.862933252, "duration_ms": 1.0107569978572428, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select commissioning_year as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.86276487, "end": 24709.863645463, "duration_ms": 0.8805930010566954, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(owner) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where owner glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.862446204, "end": 24709.86390033, "duration_ms": 1.4541260024998337, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(commissioning_year)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where commissioning_year is not null and commissioning_year != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.863423872, "end": 24709.86498897, "duration_ms": 1.5650979985366575, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select source as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.86384607, "end": 24709.865620219, "duration_ms": 1.7741490009939298, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(source) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where source glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.865166705, "end": 24709.86611756, "duration_ms": 0.9508549992460757, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select url as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.865790136, "end": 24709.866837814, "duration_ms": 1.0476780007593334, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(url) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where url glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.867014499, "end": 24709.867591833, "duration_ms": 0.5773340017185546, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(geolocation_source) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where geolocation_source glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.866315048, "end": 24709.86783488, "duration_ms": 1.5198319997580256, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select geolocation_source as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.86779107, "end": 24709.869427738, "duration_ms": 1.6366679992643185, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(wepp_id) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where wepp_id glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.868362264, "end": 24709.870180074, "duration_ms": 1.8178099999204278, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select wepp_id as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.869361355, "end": 24709.870424219, "duration_ms": 1.062864001141861, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(wepp_id)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where wepp_id is not null and wepp_id != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.869704142, "end": 24709.871033448, "duration_ms": 1.3293060001160484, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(year_of_capacity_data) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where year_of_capacity_data glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.87036599, "end": 24709.871254472, "duration_ms": 0.8884820017556194, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select year_of_capacity_data as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.870629092, "end": 24709.871853924, "duration_ms": 1.2248319981154054, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(year_of_capacity_data)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where year_of_capacity_data is not null and year_of_capacity_data != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.871207334, "end": 24709.872081014, "duration_ms": 0.8736800009501167, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2013) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2013 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.871408203, "end": 24709.872579093, "duration_ms": 1.170890001958469, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2013 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.872416408, "end": 24709.873227917, "duration_ms": 0.8115089985949453, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2014) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2014 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.872028381, "end": 24709.873430357, "duration_ms": 1.4019760019436944, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2013)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2013 is not null and generation_gwh_2013 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.873389079, "end": 24709.873988228, "duration_ms": 0.5991489997541066, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2015) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2015 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.873077699, "end": 24709.874501015, "duration_ms": 1.4233160000003409, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2014 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.873780722, "end": 24709.875074161, "duration_ms": 1.293438999709906, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2014)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2014 is not null and generation_gwh_2014 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.874350818, "end": 24709.875742849, "duration_ms": 1.3920309975219425, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2016) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2016 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.874691075, "end": 24709.876391274, "duration_ms": 1.7001989981508814, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2015 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.875292534, "end": 24709.876778445, "duration_ms": 1.4859109978715423, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2015)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2015 is not null and generation_gwh_2015 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.876106684, "end": 24709.877608643, "duration_ms": 1.5019589991425164, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2017) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2017 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.876686911, "end": 24709.878165176, "duration_ms": 1.4782649996050168, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2016 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.87778454, "end": 24709.878864131, "duration_ms": 1.0795909984153695, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2018) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2018 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.877101015, "end": 24709.879121708, "duration_ms": 2.020692998485174, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2016)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2016 is not null and generation_gwh_2016 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.878372384, "end": 24709.88023831, "duration_ms": 1.8659260022104718, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2017 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.879063724, "end": 24709.880476298, "duration_ms": 1.4125739980954677, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_gwh_2019) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_gwh_2019 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.87928095, "end": 24709.880893815, "duration_ms": 1.6128649986058008, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2017)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2017 is not null and generation_gwh_2017 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.880416357, "end": 24709.881934944, "duration_ms": 1.5185869997367263, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2018 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.881059559, "end": 24709.882356737, "duration_ms": 1.297177997912513, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2018)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2018 is not null and generation_gwh_2018 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.880756938, "end": 24709.882574189, "duration_ms": 1.8172509990108665, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(generation_data_source) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where generation_data_source glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.882107782, "end": 24709.883277343, "duration_ms": 1.1695610010065138, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_gwh_2019 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.882844824, "end": 24709.883995117, "duration_ms": 1.15029300286551, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_gwh_2013) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_gwh_2013 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.882527504, "end": 24709.884213317, "duration_ms": 1.6858130002219696, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_gwh_2019)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_gwh_2019 is not null and generation_gwh_2019 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.883744505, "end": 24709.884982283, "duration_ms": 1.2377780003589578, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select generation_data_source as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.884167908, "end": 24709.885714297, "duration_ms": 1.546389001305215, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_gwh_2014) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_gwh_2014 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.884476099, "end": 24709.886086513, "duration_ms": 1.610414001333993, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(generation_data_source)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where generation_data_source is not null and generation_data_source != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.885949184, "end": 24709.886762716, "duration_ms": 0.8135319985740352, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_gwh_2015) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_gwh_2015 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.886327793, "end": 24709.887266208, "duration_ms": 0.938414999836823, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(estimated_generation_gwh_2013)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where estimated_generation_gwh_2013 is not null and estimated_generation_gwh_2013 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.88530446, "end": 24709.887823987, "duration_ms": 2.5195269990945235, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_gwh_2013 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.887104466, "end": 24709.888646112, "duration_ms": 1.5416459973494057, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_gwh_2016) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_gwh_2016 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.887648561, "end": 24709.889089777, "duration_ms": 1.4412159980565775, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(estimated_generation_gwh_2014)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where estimated_generation_gwh_2014 is not null and estimated_generation_gwh_2014 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.888066826, "end": 24709.889948047, "duration_ms": 1.8812210000760388, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_gwh_2014 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.889034441, "end": 24709.890227865, "duration_ms": 1.193423999211518, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_gwh_2017) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_gwh_2017 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.889256211, "end": 24709.890871293, "duration_ms": 1.6150819974427577, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(estimated_generation_gwh_2015)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where estimated_generation_gwh_2015 is not null and estimated_generation_gwh_2015 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.890168777, "end": 24709.891143372, "duration_ms": 0.9745949973876122, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_gwh_2015 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.89105827, "end": 24709.892279054, "duration_ms": 1.2207839972688816, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(estimated_generation_gwh_2016)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where estimated_generation_gwh_2016 is not null and estimated_generation_gwh_2016 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.890383095, "end": 24709.89251856, "duration_ms": 2.135464997991221, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_note_2013) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_note_2013 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.891564419, "end": 24709.893069618, "duration_ms": 1.5051990012580063, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_gwh_2016 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.89267914, "end": 24709.89358119, "duration_ms": 0.9020500001497567, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_note_2014) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_note_2014 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.893250063, "end": 24709.894447576, "duration_ms": 1.1975130000791978, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_gwh_2017 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.892462332, "end": 24709.89468959, "duration_ms": 2.2272579990385566, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select distinct json_type(estimated_generation_gwh_2017)\n from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 )\n where estimated_generation_gwh_2017 is not null and estimated_generation_gwh_2017 != ''", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.89374974, "end": 24709.894900172, "duration_ms": 1.1504319991217926, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_note_2015) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_note_2015 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.894630462, "end": 24709.895913385, "duration_ms": 1.2829229999624658, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_note_2013 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.895187107, "end": 24709.897434141, "duration_ms": 2.247034000902204, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_note_2016) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_note_2016 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.896551293, "end": 24709.898781277, "duration_ms": 2.22998399840435, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_note_2014 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.897896429, "end": 24709.8998152, "duration_ms": 1.918770998599939, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select date(estimated_generation_note_2017) from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where estimated_generation_note_2017 glob \"????-??-*\" limit 100;", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.899628266, "end": 24709.900490093, "duration_ms": 0.8618270003353246, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_note_2015 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.901172922, "end": 24709.901942014, "duration_ms": 0.7690919992455747, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_note_2016 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.902740839, "end": 24709.903358231, "duration_ms": 0.6173920010041911, "traceback": [ " File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n return await self.databases[db_name].execute(\n" ], "database": "global-power-plants", "sql": "select estimated_generation_note_2017 as value, count(*) as n from (\n select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 \n ) where value is not null\n group by value\n limit 1001", "params": { "p0": "PLN - Java Bali Generation Unit / PT. PJB" } }, { "type": "sql", "start": 24709.922585547, "end": 24709.923137928, "duration_ms": 0.5523809995793272, "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": 24709.923342928, "end": 24709.92370229, "duration_ms": 0.3593620022002142, "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": 24709.923931783, "end": 24709.9242482, "duration_ms": 0.31641700115869753, "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": 24709.92964194, "end": 24709.93015361, "duration_ms": 0.511669997649733, "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 } ] }