global-power-plants

Table actions

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

9 rows where owner = "General Electricity Company of Libya" and primary_fuel = "Gas"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: commissioning_year, geolocation_source

primary_fuel 1

owner 1

  • General Electricity Company of Libya · 9 ✖

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
17144 17144 LBY Libya Al Khums WRI1023832 1000.0 32.6204 14.3312 Gas Oil     1995.0 General Electricity Company of Libya Arab Union of Electricity http://www.auptde.org/PublicationsFile.aspx?lang=en&CID=855 WRI 1109733                           3989.57 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
17145 17145 LBY Libya Az Zawiyah WRI1023835 1440.0 32.7882 12.674 Gas Oil     2003.0 General Electricity Company of Libya Arab Union of Electricity http://www.auptde.org/PublicationsFile.aspx?lang=en&CID=855 WRI                             5744.99 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
17147 17147 LBY Libya Double Corner Power Station 1 WRI1023822 480.0 32.7899 12.6703 Gas Oil     2000.0 General Electricity Company of Libya Arab Union of Electricity http://www.auptde.org/PublicationsFile.aspx?lang=en&CID=855 WRI                             1914.99 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
17148 17148 LBY Libya Gulf of Sirte WRI1023831 350.0 31.2174 16.347 Gas Oil     2016.0 General Electricity Company of Libya Arab Union of Electricity http://www.auptde.org/PublicationsFile.aspx?lang=en&CID=855 WRI                             1396.35 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
17149 17149 LBY Libya Misrata WRI1023823 500.0 32.3326 15.2319 Gas Oil     2010.0 General Electricity Company of Libya Arab Union of Electricity http://www.auptde.org/PublicationsFile.aspx?lang=en&CID=855 GEODB                             1994.78 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
17150 17150 LBY Libya North Benghazi Station 1 WRI1023821 1040.0 32.2027 20.133 Gas Oil     1979.0 General Electricity Company of Libya Arab Union of Electricity http://www.auptde.org/PublicationsFile.aspx?lang=en&CID=855 GEODB 1015259                           4149.16 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
17151 17151 LBY Libya South Tripoli WRI1023824 147.0 32.776 13.0983 Gas Oil     1994.0 General Electricity Company of Libya Arab Union of Electricity http://www.auptde.org/PublicationsFile.aspx?lang=en&CID=855 GEODB 1015279                           586.46 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
17154 17154 LBY Libya Western Mountain Station- Ruwais WRI1023827 624.0 31.9559 11.1447 Gas Oil     2005.0 General Electricity Company of Libya Arab Union of Electricity http://www.auptde.org/PublicationsFile.aspx?lang=en&CID=855 GEODB 1059725                           2489.49 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
17155 17155 LBY Libya Zuenita WRI1023826 335.0 30.9564 20.1164 Gas Oil     1994.0 General Electricity Company of Libya Arab Union of Electricity http://www.auptde.org/PublicationsFile.aspx?lang=en&CID=855 WRI                             1336.5 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1

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": 118.44255799951497,
  "sum_trace_duration_ms": 193.01677202020073,
  "num_traces": 110,
  "traces": [
    {
      "type": "sql",
      "start": 30565.866892337,
      "end": 30565.86721969,
      "duration_ms": 0.3273530019214377,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 351, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 361, in _refresh_schemas\n    for row in await internal_db.execute(\n"
      ],
      "database": "_internal",
      "sql": "select database_name, schema_version from databases",
      "params": null
    },
    {
      "type": "sql",
      "start": 30565.867431522,
      "end": 30565.86763129,
      "duration_ms": 0.199767997401068,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 351, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 366, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "_internal",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 30565.867785859,
      "end": 30565.867962167,
      "duration_ms": 0.17630799993639812,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 351, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 366, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "global-power-plants",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 30565.868318177,
      "end": 30565.868604594,
      "duration_ms": 0.2864170019165613,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/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": 30565.868367042,
      "end": 30565.868751231,
      "duration_ms": 0.38418899930547923,
      "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": 30565.871207876,
      "end": 30565.87176127,
      "duration_ms": 0.5533939984161407,
      "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 and \"primary_fuel\" = :p1 order by rowid limit 101",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.871925848,
      "end": 30565.872272419,
      "duration_ms": 0.3465709996817168,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 361, in get\n    response_or_template_contexts = await self.data(request, **data_kwargs)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 157, in data\n    return await self._data_traced(request, default_labels, _next, _size)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 498, in _data_traced\n    count_rows = list(await db.execute(count_sql, from_sql_params))\n"
      ],
      "database": "global-power-plants",
      "sql": "select count(*) from [global-power-plants] where \"owner\" = :p0 and \"primary_fuel\" = :p1",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.873119085,
      "end": 30565.873873066,
      "duration_ms": 0.753980999434134,
      "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 and \"primary_fuel\" = :p1 ) limit 0",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.873163924,
      "end": 30565.874226166,
      "duration_ms": 1.0622420013532974,
      "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 and \"primary_fuel\" = :p1 ) limit 0",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.873204096,
      "end": 30565.874463871,
      "duration_ms": 1.2597750028362498,
      "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 and \"primary_fuel\" = :p1 ) limit 0",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.872911853,
      "end": 30565.87511191,
      "duration_ms": 2.200057002482936,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                )\n                where country_long is not null\n                group by country_long order by count desc, value limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.874420598,
      "end": 30565.875818295,
      "duration_ms": 1.3976970003568567,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where rowid glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.87463813,
      "end": 30565.877354085,
      "duration_ms": 2.71595500089461,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where rowid is not null and rowid != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.876146847,
      "end": 30565.877597764,
      "duration_ms": 1.450916999601759,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where country glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.874169682,
      "end": 30565.878222885,
      "duration_ms": 4.053202999784844,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.876797392,
      "end": 30565.879156614,
      "duration_ms": 2.3592219986312557,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                )\n                where owner is not null\n                group by owner order by count desc, value limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.878042016,
      "end": 30565.879881552,
      "duration_ms": 1.839535998442443,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where country_long glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.878643418,
      "end": 30565.880499804,
      "duration_ms": 1.8563859994173981,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.880343171,
      "end": 30565.881666261,
      "duration_ms": 1.3230900003691204,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where name glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.880685572,
      "end": 30565.882842052,
      "duration_ms": 2.1564800008491147,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.881947756,
      "end": 30565.883275119,
      "duration_ms": 1.3273629992909264,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where gppd_idnr glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.881068109,
      "end": 30565.883959447,
      "duration_ms": 2.891338001063559,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                )\n                where primary_fuel is not null\n                group by primary_fuel order by count desc, value limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.88381745,
      "end": 30565.885140442,
      "duration_ms": 1.3229919968580361,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where capacity_mw glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.883175776,
      "end": 30565.886155404,
      "duration_ms": 2.9796279995935038,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.885380929,
      "end": 30565.886642419,
      "duration_ms": 1.261489996977616,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where latitude glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.884665992,
      "end": 30565.887383716,
      "duration_ms": 2.7177240008313674,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where capacity_mw is not null and capacity_mw != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.886926508,
      "end": 30565.887708473,
      "duration_ms": 0.781965001806384,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where longitude glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.886486225,
      "end": 30565.888574563,
      "duration_ms": 2.088337998429779,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.887573816,
      "end": 30565.888815509,
      "duration_ms": 1.2416930003382731,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where latitude is not null and latitude != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.887950244,
      "end": 30565.889009523,
      "duration_ms": 1.059279002220137,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where primary_fuel glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.888755656,
      "end": 30565.889869799,
      "duration_ms": 1.1141430004499853,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.889270573,
      "end": 30565.890361035,
      "duration_ms": 1.0904619994107634,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where other_fuel1 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.8889705,
      "end": 30565.891001666,
      "duration_ms": 2.0311660009610932,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where longitude is not null and longitude != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.890186002,
      "end": 30565.891616365,
      "duration_ms": 1.4303629977803212,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.890547837,
      "end": 30565.89207126,
      "duration_ms": 1.5234230013447814,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where other_fuel2 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.891960864,
      "end": 30565.893009807,
      "duration_ms": 1.048943002388114,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.892410519,
      "end": 30565.893487437,
      "duration_ms": 1.0769179971248377,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where other_fuel3 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.893652931,
      "end": 30565.894396147,
      "duration_ms": 0.7432159982272424,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where commissioning_year glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.89405151,
      "end": 30565.895055781,
      "duration_ms": 1.004270998237189,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where other_fuel2 is not null and other_fuel2 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.89332899,
      "end": 30565.895307302,
      "duration_ms": 1.9783119969360996,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.894665605,
      "end": 30565.895822475,
      "duration_ms": 1.1568699992494658,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where owner glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.895251497,
      "end": 30565.896434053,
      "duration_ms": 1.18255599954864,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where other_fuel3 is not null and other_fuel3 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.89615179,
      "end": 30565.897122867,
      "duration_ms": 0.9710770027595572,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where source glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.895627971,
      "end": 30565.897491726,
      "duration_ms": 1.863754998339573,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.896649295,
      "end": 30565.898197649,
      "duration_ms": 1.5483540009881835,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where commissioning_year is not null and commissioning_year != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.897418366,
      "end": 30565.898648543,
      "duration_ms": 1.2301770002522971,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where url glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.897724098,
      "end": 30565.898899774,
      "duration_ms": 1.1756760031857993,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.898813742,
      "end": 30565.900518071,
      "duration_ms": 1.7043290026776958,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where geolocation_source glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.899423934,
      "end": 30565.900803911,
      "duration_ms": 1.3799770022160374,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.900747227,
      "end": 30565.90154964,
      "duration_ms": 0.8024130002013408,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where wepp_id glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.900967592,
      "end": 30565.902183417,
      "duration_ms": 1.2158250028733164,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.901913253,
      "end": 30565.902881462,
      "duration_ms": 0.9682089985290077,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where year_of_capacity_data glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.90239824,
      "end": 30565.903713359,
      "duration_ms": 1.3151189996278845,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.903117811,
      "end": 30565.904423163,
      "duration_ms": 1.3053519978711847,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where generation_gwh_2013 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.904343963,
      "end": 30565.905426902,
      "duration_ms": 1.0829390012077056,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.904713813,
      "end": 30565.90591361,
      "duration_ms": 1.199796999571845,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where generation_gwh_2014 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.904893853,
      "end": 30565.906562037,
      "duration_ms": 1.668183998845052,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where wepp_id is not null and wepp_id != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.905641731,
      "end": 30565.907008369,
      "duration_ms": 1.3666380000358913,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.90610741,
      "end": 30565.907311866,
      "duration_ms": 1.2044560025969986,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where generation_gwh_2015 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.906885188,
      "end": 30565.908277482,
      "duration_ms": 1.3922940015618224,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where year_of_capacity_data is not null and year_of_capacity_data != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.907224885,
      "end": 30565.908512621,
      "duration_ms": 1.2877360022685025,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.907506979,
      "end": 30565.909210174,
      "duration_ms": 1.7031949973898008,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where generation_gwh_2016 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.908681885,
      "end": 30565.909785646,
      "duration_ms": 1.1037609983759467,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.908459337,
      "end": 30565.910068007,
      "duration_ms": 1.6086700015875977,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where generation_gwh_2013 is not null and generation_gwh_2013 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.909569511,
      "end": 30565.910579821,
      "duration_ms": 1.0103099994012155,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where generation_gwh_2017 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.910231662,
      "end": 30565.91103985,
      "duration_ms": 0.8081880005192943,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where generation_gwh_2014 is not null and generation_gwh_2014 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.910884914,
      "end": 30565.911732803,
      "duration_ms": 0.847889001306612,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where generation_gwh_2018 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.910010652,
      "end": 30565.912066198,
      "duration_ms": 2.055545999610331,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.911530702,
      "end": 30565.912785694,
      "duration_ms": 1.2549919993034564,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where generation_gwh_2015 is not null and generation_gwh_2015 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.9124546,
      "end": 30565.913398501,
      "duration_ms": 0.9439010027563199,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.912002495,
      "end": 30565.913770845,
      "duration_ms": 1.768350000929786,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where generation_gwh_2019 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.91302526,
      "end": 30565.914068892,
      "duration_ms": 1.0436320008011535,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where generation_gwh_2016 is not null and generation_gwh_2016 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.913708046,
      "end": 30565.9145867,
      "duration_ms": 0.8786540020082612,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.913940679,
      "end": 30565.915065601,
      "duration_ms": 1.1249220005993266,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where generation_data_source glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.914904691,
      "end": 30565.915862357,
      "duration_ms": 0.95766600134084,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.915229462,
      "end": 30565.916106926,
      "duration_ms": 0.8774640009505674,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where estimated_generation_gwh_2013 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.914287576,
      "end": 30565.916308172,
      "duration_ms": 2.0205959990562405,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where generation_gwh_2017 is not null and generation_gwh_2017 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.916050189,
      "end": 30565.917134168,
      "duration_ms": 1.0839790011232253,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.916267933,
      "end": 30565.917397172,
      "duration_ms": 1.1292390008748043,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where estimated_generation_gwh_2014 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.91664823,
      "end": 30565.917908731,
      "duration_ms": 1.2605010015249718,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where generation_gwh_2018 is not null and generation_gwh_2018 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.917552289,
      "end": 30565.918408022,
      "duration_ms": 0.8557330002076924,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where estimated_generation_gwh_2015 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.918247258,
      "end": 30565.919153142,
      "duration_ms": 0.9058840005309321,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where generation_gwh_2019 is not null and generation_gwh_2019 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.917339745,
      "end": 30565.919710034,
      "duration_ms": 2.3702889993728604,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.918574632,
      "end": 30565.919999542,
      "duration_ms": 1.4249099986045621,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where estimated_generation_gwh_2016 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.919510141,
      "end": 30565.920510886,
      "duration_ms": 1.0007450000557583,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 304, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select distinct json_type(generation_data_source)\n                from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"owner\" = :p0 and \"primary_fuel\" = :p1 )\n                where generation_data_source is not null and generation_data_source != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.919950254,
      "end": 30565.921132482,
      "duration_ms": 1.1822279993793927,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.92015456,
      "end": 30565.921356346,
      "duration_ms": 1.2017859990010038,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where estimated_generation_gwh_2017 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.920728423,
      "end": 30565.921867021,
      "duration_ms": 1.13859799967031,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where estimated_generation_gwh_2013 is not null and estimated_generation_gwh_2013 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.921305022,
      "end": 30565.922417484,
      "duration_ms": 1.1124619995825924,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.922075437,
      "end": 30565.923089695,
      "duration_ms": 1.01425799948629,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where estimated_generation_gwh_2014 is not null and estimated_generation_gwh_2014 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.92150583,
      "end": 30565.923449053,
      "duration_ms": 1.9432230001257267,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where estimated_generation_note_2013 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.922928181,
      "end": 30565.924049368,
      "duration_ms": 1.1211870005354285,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.923379324,
      "end": 30565.924699782,
      "duration_ms": 1.3204580027377233,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where estimated_generation_gwh_2015 is not null and estimated_generation_gwh_2015 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.923693183,
      "end": 30565.925500269,
      "duration_ms": 1.807086002372671,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where estimated_generation_note_2014 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.924956375,
      "end": 30565.925874806,
      "duration_ms": 0.9184309965348803,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where estimated_generation_gwh_2016 is not null and estimated_generation_gwh_2016 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.924520488,
      "end": 30565.926082845,
      "duration_ms": 1.5623569997842424,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.926231372,
      "end": 30565.927046064,
      "duration_ms": 0.8146920008584857,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.925735238,
      "end": 30565.927990087,
      "duration_ms": 2.254848997836234,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where estimated_generation_note_2015 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.927268645,
      "end": 30565.928214572,
      "duration_ms": 0.9459270004299469,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.928165858,
      "end": 30565.945064367,
      "duration_ms": 16.898508998565376,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where estimated_generation_note_2016 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.926040836,
      "end": 30565.945403679,
      "duration_ms": 19.36284300245461,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 )\n                where estimated_generation_gwh_2017 is not null and estimated_generation_gwh_2017 != ''",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.945326123,
      "end": 30565.946517527,
      "duration_ms": 1.191404000564944,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where estimated_generation_note_2017 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.928356375,
      "end": 30565.94730016,
      "duration_ms": 18.94378500219318,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.947517743,
      "end": 30565.948329639,
      "duration_ms": 0.8118959995044861,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.948540174,
      "end": 30565.949214967,
      "duration_ms": 0.6747930019628257,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.94940692,
      "end": 30565.95026939,
      "duration_ms": 0.8624699985375628,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 and \"primary_fuel\" = :p1 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "General Electricity Company of Libya",
        "p1": "Gas"
      }
    },
    {
      "type": "sql",
      "start": 30565.958546276,
      "end": 30565.958995195,
      "duration_ms": 0.4489189996093046,
      "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": 30565.959234432,
      "end": 30565.959540494,
      "duration_ms": 0.30606200016336516,
      "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": 30565.959739087,
      "end": 30565.960088208,
      "duration_ms": 0.34912100090878084,
      "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": 30565.963158606,
      "end": 30565.963511717,
      "duration_ms": 0.35311100145918317,
      "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
    }
  ]
}