global-power-plants

Table actions

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

where primary_fuel = "Hydro" sorted by other_fuel3

✎ View and edit SQL

This data as json, CSV (advanced)

country_long >3

primary_fuel 1

  • Hydro · 7,156 ✖
Link rowid country country_long name gppd_idnr capacity_mw latitude longitude primary_fuel other_fuel1 other_fuel2 other_fuel3 ▼ commissioning_year owner source url geolocation_source wepp_id year_of_capacity_data generation_gwh_2013 generation_gwh_2014 generation_gwh_2015 generation_gwh_2016 generation_gwh_2017 generation_gwh_2018 generation_gwh_2019 generation_data_source estimated_generation_gwh_2013 estimated_generation_gwh_2014 estimated_generation_gwh_2015 estimated_generation_gwh_2016 estimated_generation_gwh_2017 estimated_generation_note_2013 estimated_generation_note_2014 estimated_generation_note_2015 estimated_generation_note_2016 estimated_generation_note_2017
1 1 AFG Afghanistan Kajaki Hydroelectric Power Plant Afghanistan GEODB0040538 33.0 32.322 65.119 Hydro           GEODB http://globalenergyobservatory.org GEODB 1009793 2017                 123.77 162.9 97.39 137.76 119.5 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
4 4 AFG Afghanistan Mahipar Hydroelectric Power Plant Afghanistan GEODB0040541 66.0 34.556 69.4787 Hydro           GEODB http://globalenergyobservatory.org GEODB 1009795 2017                 225.06 203.55 146.9 230.18 174.91 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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": 2633.3575129992823,
  "sum_trace_duration_ms": 1478.214011000091,
  "num_traces": 34,
  "traces": [
    {
      "type": "sql",
      "start": 4711.397651379,
      "end": 4711.398040265,
      "duration_ms": 0.38888600010977825,
      "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": 4711.398309503,
      "end": 4711.398580576,
      "duration_ms": 0.27107300047646277,
      "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": 4711.398736281,
      "end": 4711.398928689,
      "duration_ms": 0.19240799974795664,
      "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": 4711.399338325,
      "end": 4711.399654988,
      "duration_ms": 0.31666300037613837,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/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": 4711.399391131,
      "end": 4711.399807619,
      "duration_ms": 0.41648800015536835,
      "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": 4711.402626871,
      "end": 4711.437981931,
      "duration_ms": 35.35505999934685,
      "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 \"primary_fuel\" = :p0 order by other_fuel3 limit 3",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4711.43927251,
      "end": 4711.44024132,
      "duration_ms": 0.9688099999038968,
      "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 \"primary_fuel\" = :p0 ) limit 0",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4711.439317424,
      "end": 4711.46134727,
      "duration_ms": 22.02984599989577,
      "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 \"primary_fuel\" = :p0 ) limit 0",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4711.439219663,
      "end": 4711.519990168,
      "duration_ms": 80.77050500014593,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 145, in suggest\n    row_count = await self.get_row_count()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 132, in get_row_count\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select count(*) from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 )",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4711.527989507,
      "end": 4711.529049262,
      "duration_ms": 1.0597549999147304,
      "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 \"primary_fuel\" = :p0 ) limit 0",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4711.438906452,
      "end": 4711.55337078,
      "duration_ms": 114.46432799948525,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                )\n                where country_long is not null\n                group by country_long order by count desc, value limit 4",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4711.529489491,
      "end": 4711.553836535,
      "duration_ms": 24.347044000023743,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 4",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4711.556234686,
      "end": 4711.744098044,
      "duration_ms": 187.86335799995868,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                )\n                where owner is not null\n                group by owner order by count desc, value limit 4",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4711.769633413,
      "end": 4711.837254407,
      "duration_ms": 67.62099400020816,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                )\n                where primary_fuel is not null\n                group by primary_fuel order by count desc, value limit 4",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4711.90675284,
      "end": 4711.949542336,
      "duration_ms": 42.78949600029591,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where gppd_idnr glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4712.305718497,
      "end": 4712.350374335,
      "duration_ms": 44.65583799992601,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 4",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4712.405863567,
      "end": 4712.447277363,
      "duration_ms": 41.41379599968786,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where other_fuel3 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4712.505519101,
      "end": 4712.608086629,
      "duration_ms": 102.5675280006908,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where owner glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4712.711796496,
      "end": 4712.756867542,
      "duration_ms": 45.07104599997547,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where geolocation_source glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4712.712954754,
      "end": 4712.806088205,
      "duration_ms": 93.13345100053994,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 4",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4712.912692758,
      "end": 4712.958663052,
      "duration_ms": 45.97029399974417,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 4",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4713.010286226,
      "end": 4713.058252108,
      "duration_ms": 47.96588199951657,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where generation_gwh_2015 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4713.058626206,
      "end": 4713.164950113,
      "duration_ms": 106.32390699993266,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where generation_gwh_2016 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4713.30909126,
      "end": 4713.406433375,
      "duration_ms": 97.34211500017409,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 4",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4713.407697637,
      "end": 4713.454582456,
      "duration_ms": 46.884819000297284,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where generation_data_source glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4713.407539132,
      "end": 4713.456804801,
      "duration_ms": 49.26566899939644,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 4",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4713.508527035,
      "end": 4713.55428592,
      "duration_ms": 45.75888500039582,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where estimated_generation_gwh_2014 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4713.606834074,
      "end": 4713.654724707,
      "duration_ms": 47.89063299995178,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where estimated_generation_gwh_2016 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4713.706743837,
      "end": 4713.752305479,
      "duration_ms": 45.56164199948398,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where estimated_generation_note_2013 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4713.960222187,
      "end": 4713.996581514,
      "duration_ms": 36.359327000354824,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where estimated_generation_note_2017 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Hydro"
      }
    },
    {
      "type": "sql",
      "start": 4714.002386757,
      "end": 4714.002854832,
      "duration_ms": 0.46807499984424794,
      "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": 4714.003203759,
      "end": 4714.003615234,
      "duration_ms": 0.41147499996441184,
      "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": 4714.006963827,
      "end": 4714.008895391,
      "duration_ms": 1.931564000187791,
      "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": 4714.012045137,
      "end": 4714.012428488,
      "duration_ms": 0.38335099998221267,
      "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
    }
  ]
}