global-power-plants

Table actions

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

where owner = "Placer County Water Agency"

✎ View and edit SQL

This data as json, CSV (advanced)

primary_fuel 1

owner 1

  • Placer County Water Agency · 4 ✖

country_long 1

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
27861 27861 USA United States of America French Meadows USA0000424 15.3 39.078 -120.4061 Hydro       1966.0 Placer County Water Agency U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30258 2019 26.863 21.28 9.245 54.456 106.178 38.058 84.621 U.S. Energy Information Administration 43.84 46.45 38.72 54.3 49.29 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
30206 30206 USA United States of America Middle Fork USA0000425 122.4 39.0248 -120.5964 Hydro       1966.0 Placer County Water Agency U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30260 2019 327.117 270.448 159.653 531.9780000000001 860.201 451.504 788.857 U.S. Energy Information Administration 309.34 309.34 278.5 310.18 257.31 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": 2951.4198410000176,
  "sum_trace_duration_ms": 5445.31933399992,
  "num_traces": 107,
  "traces": [
    {
      "type": "sql",
      "start": 417.440486834,
      "end": 417.473893068,
      "duration_ms": 33.406233999983215,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/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": 417.440541794,
      "end": 417.484515031,
      "duration_ms": 43.973236999988785,
      "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": 417.603061996,
      "end": 417.771373372,
      "duration_ms": 168.31137600001966,
      "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 3",
      "params": {
        "p0": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.780929372,
      "end": 417.791465928,
      "duration_ms": 10.536555999976827,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.781145593,
      "end": 417.798541496,
      "duration_ms": 17.395902999965074,
      "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 \"owner\" = :p0 )",
      "params": {
        "p0": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.781187187,
      "end": 417.798785726,
      "duration_ms": 17.598539000005076,
      "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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.781224184,
      "end": 417.799054242,
      "duration_ms": 17.83005800001547,
      "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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.798734891,
      "end": 417.876299098,
      "duration_ms": 77.56420700002309,
      "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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.799262832,
      "end": 417.877805573,
      "duration_ms": 78.54274099997838,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.799003639,
      "end": 417.879009609,
      "duration_ms": 80.00597000000198,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.877751391,
      "end": 417.88575308,
      "duration_ms": 8.001688999968337,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.8772639,
      "end": 417.886554844,
      "duration_ms": 9.290943999985757,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.879282973,
      "end": 417.88789005,
      "duration_ms": 8.607077000021945,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.886797001,
      "end": 417.897331852,
      "duration_ms": 10.534850999988521,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.888130974,
      "end": 417.897780633,
      "duration_ms": 9.649659000046995,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.895367314,
      "end": 417.909267163,
      "duration_ms": 13.899848999983533,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.897661081,
      "end": 417.91265453,
      "duration_ms": 14.99344899997368,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.898215103,
      "end": 417.914063471,
      "duration_ms": 15.848368000035862,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.914251676,
      "end": 418.059459694,
      "duration_ms": 145.20801800000527,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 417.913994534,
      "end": 418.059851856,
      "duration_ms": 145.8573220000403,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.059336036,
      "end": 418.070036664,
      "duration_ms": 10.70062799999505,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.05979215,
      "end": 418.070475858,
      "duration_ms": 10.683707999987746,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.060282684,
      "end": 418.071026752,
      "duration_ms": 10.744068000008156,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.070338438,
      "end": 418.081728546,
      "duration_ms": 11.39010800000051,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.070961145,
      "end": 418.082928467,
      "duration_ms": 11.967321999975411,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.07123286,
      "end": 418.086007431,
      "duration_ms": 14.774570999975367,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.081999889,
      "end": 418.092939387,
      "duration_ms": 10.93949800002747,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.08339,
      "end": 418.096061206,
      "duration_ms": 12.671205999993163,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.087613056,
      "end": 418.10044414,
      "duration_ms": 12.831083999969906,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.096415724,
      "end": 418.107007765,
      "duration_ms": 10.592040999995334,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.100754595,
      "end": 418.109623718,
      "duration_ms": 8.869123000010859,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.106025441,
      "end": 418.116621358,
      "duration_ms": 10.595916999989186,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.107895109,
      "end": 418.121123295,
      "duration_ms": 13.228185999992093,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.110668756,
      "end": 418.126036249,
      "duration_ms": 15.367492999985188,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.11700337,
      "end": 418.140147719,
      "duration_ms": 23.14434900000606,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.12171916,
      "end": 418.140768373,
      "duration_ms": 19.049213000016607,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.138982366,
      "end": 418.145571586,
      "duration_ms": 6.589220000023488,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.141096674,
      "end": 418.172523701,
      "duration_ms": 31.427027000006547,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.140508935,
      "end": 418.17339315,
      "duration_ms": 32.8842149999673,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.145832705,
      "end": 418.174695028,
      "duration_ms": 28.86232299999847,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.173039902,
      "end": 418.180556314,
      "duration_ms": 7.516411999972661,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.174232823,
      "end": 418.182125876,
      "duration_ms": 7.893052999975225,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.17497823,
      "end": 418.192788053,
      "duration_ms": 17.80982299999323,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.180938861,
      "end": 418.193863573,
      "duration_ms": 12.924711999971805,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.193672694,
      "end": 418.236606579,
      "duration_ms": 42.93388500002493,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.194183613,
      "end": 418.237026381,
      "duration_ms": 42.842768000014075,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.236875909,
      "end": 418.240041352,
      "duration_ms": 3.165443000000323,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.237192289,
      "end": 418.240920168,
      "duration_ms": 3.727878999995937,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.240694418,
      "end": 418.25062016,
      "duration_ms": 9.925742000007176,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.241443543,
      "end": 418.251703981,
      "duration_ms": 10.26043799998888,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.251629128,
      "end": 418.274278827,
      "duration_ms": 22.64969899999869,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.251878656,
      "end": 418.276158168,
      "duration_ms": 24.279512000020986,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.268738986,
      "end": 418.284417609,
      "duration_ms": 15.678622999985237,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.274751208,
      "end": 418.286308406,
      "duration_ms": 11.557197999991331,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.280343033,
      "end": 418.287308055,
      "duration_ms": 6.965021999974397,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.284711394,
      "end": 418.291429636,
      "duration_ms": 6.718241999976726,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.287235805,
      "end": 418.353324217,
      "duration_ms": 66.08841199999915,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.287892469,
      "end": 418.353640075,
      "duration_ms": 65.74760600000218,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.292904032,
      "end": 418.354448384,
      "duration_ms": 61.544351999998526,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.353823816,
      "end": 418.376303086,
      "duration_ms": 22.47927000001937,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.3535868,
      "end": 418.377227777,
      "duration_ms": 23.64097699995682,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.354616326,
      "end": 418.380308173,
      "duration_ms": 25.691847000018697,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.377003657,
      "end": 418.413460264,
      "duration_ms": 36.45660699999098,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.378308451,
      "end": 418.432605103,
      "duration_ms": 54.296652000005,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.381138631,
      "end": 418.435754396,
      "duration_ms": 54.6157649999941,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.413752362,
      "end": 418.439311946,
      "duration_ms": 25.559583999950064,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.433070057,
      "end": 418.440151651,
      "duration_ms": 7.081593999998859,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.435986044,
      "end": 418.489389511,
      "duration_ms": 53.40346700000964,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.439588977,
      "end": 418.742542526,
      "duration_ms": 302.9535489999944,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.440338508,
      "end": 418.747415627,
      "duration_ms": 307.0771189999846,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.489671527,
      "end": 418.750752868,
      "duration_ms": 261.0813410000219,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.742927947,
      "end": 418.759650618,
      "duration_ms": 16.722671000025002,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.747911692,
      "end": 418.794964415,
      "duration_ms": 47.05272299997887,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.751077155,
      "end": 418.815356763,
      "duration_ms": 64.27960799999255,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.760050861,
      "end": 418.878629245,
      "duration_ms": 118.57838399998855,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.795225756,
      "end": 418.880830369,
      "duration_ms": 85.60461300004363,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.815755761,
      "end": 418.892873986,
      "duration_ms": 77.11822499999244,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.880363982,
      "end": 418.930643192,
      "duration_ms": 50.27920999998514,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.881126673,
      "end": 418.973214703,
      "duration_ms": 92.08803000001353,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.972564808,
      "end": 418.99725272,
      "duration_ms": 24.68791199999032,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.975830937,
      "end": 418.997698821,
      "duration_ms": 21.86788399995976,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.980741083,
      "end": 419.02202863,
      "duration_ms": 41.28754700002446,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 418.997519134,
      "end": 419.097510756,
      "duration_ms": 99.99162200000455,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.010652532,
      "end": 419.173120536,
      "duration_ms": 162.46800400000438,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.022278266,
      "end": 419.175670372,
      "duration_ms": 153.39210600001252,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.098001786,
      "end": 419.181761799,
      "duration_ms": 83.7600130000169,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.17351266,
      "end": 419.186148032,
      "duration_ms": 12.63537200003384,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.17609455,
      "end": 419.202467407,
      "duration_ms": 26.37285699995573,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.182274632,
      "end": 419.234917338,
      "duration_ms": 52.64270600002874,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.186533225,
      "end": 419.303901858,
      "duration_ms": 117.36863300001232,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.202826475,
      "end": 419.309266194,
      "duration_ms": 106.4397189999795,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.235163211,
      "end": 419.377727557,
      "duration_ms": 142.56434600002876,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.304272606,
      "end": 419.379966151,
      "duration_ms": 75.69354500003556,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.311911906,
      "end": 419.40765946,
      "duration_ms": 95.74755400001322,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.378122181,
      "end": 419.428358046,
      "duration_ms": 50.2358650000474,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.380342233,
      "end": 419.470792701,
      "duration_ms": 90.4504679999718,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.428754102,
      "end": 419.485397796,
      "duration_ms": 56.643693999944844,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.471078073,
      "end": 419.486624195,
      "duration_ms": 15.546121999989282,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.48564035,
      "end": 419.595040317,
      "duration_ms": 109.39996700000165,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.488978508,
      "end": 419.599199584,
      "duration_ms": 110.22107600001618,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.595334358,
      "end": 419.621639035,
      "duration_ms": 26.304676999984622,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.599439113,
      "end": 419.623594098,
      "duration_ms": 24.154984999995577,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 419.62206523,
      "end": 419.713916354,
      "duration_ms": 91.85112400001572,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": "Placer County Water Agency"
      }
    },
    {
      "type": "sql",
      "start": 420.07068395,
      "end": 420.103865047,
      "duration_ms": 33.181097000010595,
      "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": 420.104244075,
      "end": 420.214742311,
      "duration_ms": 110.49823600001218,
      "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": 420.215015976,
      "end": 420.311552563,
      "duration_ms": 96.53658700000278,
      "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": 420.315024952,
      "end": 420.327743164,
      "duration_ms": 12.71821200003842,
      "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
    }
  ]
}