global-power-plants

Table actions

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

41 rows where primary_fuel = "Cogeneration" sorted by generation_gwh_2018

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: commissioning_year, generation_gwh_2013, generation_gwh_2018

primary_fuel 1

  • Cogeneration · 41 ✖
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
22841 22841 GBR United Kingdom Fellside CHP GBR1000317 180.0 54.4184 -3.4883 Cogeneration         Px Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1016955                             NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
22986 22986 GBR United Kingdom Grain CHP GBR1000495 1404.0 51.4444 0.7114 Cogeneration         Uniper UK Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1025719                             NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
23630 23630 GBR United Kingdom Markinch CHP GBR0000155 65.0 56.2012 -3.1623 Cogeneration         RWE UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                               NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
24111 24111 GBR United Kingdom SELCHP ERF GBR0004928 32.0 51.4846 -0.0454 Cogeneration         Veolia (SELCHP) UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                               NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
24226 24226 GBR United Kingdom Slough GBR1000439 35.0 51.5095 -0.5954 Cogeneration         Scottish and Southern: Thermal Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes CARMA 1029010                             NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
24302 24302 GBR United Kingdom Steven's Croft GBR0000196 50.0 55.1524 -3.3809 Cogeneration         E.ON (formerly Powergen). Agent Environmental Planning and Management UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1056880                             NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
24512 24512 GBR United Kingdom VPI Immingham GBR1000517 1240.0 53.6366 -0.2395 Cogeneration         VPI Immingham LLP Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes CARMA 1052905                             NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
27126 27126 USA United States of America District 70 Transco Gas Pipe Line USA0054744 1.6 31.2479 -90.1991 Cogeneration       1951.0 Transcontinental Gas PL Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 0.0             U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
32917 32917 USA United States of America St. Mary Clean Energy Center USA0060610 58.2 29.6846 -91.4706 Cogeneration       2019.0 Cleco Power LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019             84.729 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
30436 30436 USA United States of America Mosaic Phosphates Uncle Sam USA0010198 26.0 30.0386 -90.8283 Cogeneration Gas     1995.692307692308 Mosaic Phosphates Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 74.92571000000001 85.61414 0.0 112.09805 8.245370000000001 -3.888500000000001 -35.815430000000006 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
24773 24773 USA United States of America ADA Carbon Solutions Red River USA0057938 20.8 32.0039 -93.3911 Cogeneration       2011.0 ADA Carbon Solutions (Red River) LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 68060 2019 25.53137 42.43459 58.22425 0.0 0.0 0.0 57.07 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
26012 26012 USA United States of America CII Carbon LLC USA0054677 46.0 29.9327 -89.9782 Cogeneration       1951.0 CII Carbon LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 0.0 0.0 0.0 0.0 0.0 0.0 61.139 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
27144 27144 USA United States of America Dominguez Plant USA0052064 5.0 33.8431 -118.2347 Cogeneration Gas     1976.0 Eco Services Corp. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 3.568 0.228 0.0 0.0 0.0 0.0 12.074 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
28150 28150 USA United States of America Goodsprings Waste Heat Recovery USA0057684 7.5 35.8094 -115.4114 Cogeneration       2010.0 Nevada Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 33.493 0.0 0.0 0.0 0.0 0.0 21.519 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
28737 28737 USA United States of America Houston Plant USA0052065 7.5 29.7198 -95.2706 Cogeneration       1975.6 Eco Services Corp. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 0.0 0.0 0.0 0.0 0.0 0.0 65.214 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
29454 29454 USA United States of America Lake Charles Plant USA0058310 36.4 30.1489 -93.3356 Cogeneration       2013.0 Rain CII Carbon LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 132.899 151.821 0.0 0.0 0.0 0.0 195.359 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
30023 30023 USA United States of America Martinez Sulfuric Acid Regeneration Plt USA0052063 4.0 38.0314 -122.1139 Cogeneration Gas     1978.0 Eco Services Corp. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 1.034 0.81 0.0 0.0 0.0 0.0 13.113 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
30434 30434 USA United States of America Mosaic Co Tampa Facility USA0010204 72.4 27.8605 -82.3903 Cogeneration       1993.256906077348 Mosaic Company U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 0.0 0.0 0.0 0.0 0.0 0.0 268.02 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
31127 31127 USA United States of America PCS Nitrogen Fertilizer LP USA0050341 14.0 30.227 -91.0551 Cogeneration Oil     2007.7142857142856 PCS Nitrogen LP U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019       0.0 0.0 0.0 0.0 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
32603 32603 USA United States of America Simplot Leasing Don Plant USA0050274 15.9 42.9084 -112.5294 Cogeneration       1986.0 Simplot Leasing Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 0.0 0.0 0.0 0.0 0.0 0.0 65.655 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
33325 33325 USA United States of America Tesoro Wilmington Calciner USA0010601 34.0 33.777 -118.2282 Cogeneration       1983.0 Tesoro Refining & Marketing Company LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 13451 2019 0.0 0.0 0.0 0.0 0.0 0.0 191.101 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
34327 34327 USA United States of America Williams Ignacio Natural Gas Plant USA0050205 6.1 37.1456 -107.7847 Cogeneration       1985.0 Harvest Midstream Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 0.0 0.0 39.877 41.961 0.0 0.0 43.454 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
34346 34346 USA United States of America Wilmington Hydrogen Plant USA0055557 31.9 33.7803 -118.24 Cogeneration       1996.0 Air Products & Chemicals Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 193.67117 203.58457 145.02179 0.0 0.0 0.0 195.629 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
27302 27302 USA United States of America East Kansas Agri-Energy LLC USA0059383 2.0 38.2725 -95.2403 Cogeneration       2005.0 East Kansas Agri-Energy LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019   0.0009699999999999 0.0 0.001 4.732 5.01 4.996 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
29018 29018 USA United States of America J.R. Simplot Company USA0058216 4.0 37.8069 -121.2775 Cogeneration       1993.0 J.R. Simplot Company U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019   15.94 16.73 10.759 8.530809999999999 11.37131 11.62351 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
30890 30890 USA United States of America OREG 4 Peetz USA0057134 4.5 40.9925 -102.8531 Cogeneration       2009.0 Ormat Nevada Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 7.784 4.488 12.447 11.427 15.167 17.674 18.104 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
25399 25399 USA United States of America Bayway Refinery USA0056294 11.2 40.6376 -74.2212 Cogeneration       1968.0 Phillips 66 U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 63861 2019 93.344 102.631 67.132 67.682 66.921 24.634 59.634 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
30889 30889 USA United States of America OREG 3 Inc USA0057281 5.0 43.76 -94.7514 Cogeneration       2010.0 Ormat Nevada Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 41.238 38.997 43.986 46.902 44.415 41.772 38.286 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
28111 28111 USA United States of America Glen Ullin Station 6 USA0057172 5.3 46.8214 -101.7564 Cogeneration       2009.0 Montana-Dakota Utilities Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 60141 2019 38.053 31.44 38.248 39.384 45.535 44.913 42.254 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
33798 33798 USA United States of America Veyo Heat Recovery Project USA0060421 9.5 37.348 -113.765 Cogeneration       2016.0 Utah Associated Mun Power Sys U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019       36.108 52.917 53.104 48.865 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
25274 25274 USA United States of America BP Chemicals Green Lake Plant USA0050404 38.8 28.5707 -96.8333 Cogeneration       1993.9072164948457 INEOS Nitriles Greenlake U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 2.259 15.404 18.018 74.363 37.74627 54.528 40.51992 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
31891 31891 USA United States of America Rentech Nitrogen Pasadena Cogeneration USA0058870 15.4 29.7394 -95.1947 Cogeneration       2015.0 PCI Nitrogen LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 66842 2019     87.60167 91.721 74.49553 82.154 95.606 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
30888 30888 USA United States of America OREG 2 Inc USA0056880 30.0 48.2142 -104.3975 Cogeneration       2009.25 Ormat Nevada Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 159.239 133.241 150.739 173.836 165.785 140.331 130.683 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
30887 30887 USA United States of America OREG 1 Inc USA0056833 30.0 48.2139 -104.3975 Cogeneration       2006.0 Ormat Nevada Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 173.221 131.573 152.03300000000002 153.032 166.049 164.341 156.477 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
29262 29262 USA United States of America Kennecott Power Plant USA0056163 38.2 40.7119 -112.1225 Cogeneration Gas     1997.680628272251 Kennecott Utah Copper U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 680.057996 596.6130019999999 549.428004 650.0790440000001 426.982 193.008 167.199 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
33436 33436 USA United States of America Torrance Refining Company LLC USA0050624 49.3 33.8534 -118.33 Cogeneration Gas     1987.239350912779 Torrance Refining Company LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 215.687067 195.78500000000005 0.0 0.0 0.0 222.961 181.055 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
31128 31128 USA United States of America PCS Phosphate USA0050509 54.0 35.3763 -76.7799 Cogeneration       1985.0 PCS Phosphate U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 338.00600000000003 317.875 298.957 291.599 293.577 233.417 212.862 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
30437 30437 USA United States of America Mosaic South Pierce Operations USA0010004 45.5 27.7652 -81.9388 Cogeneration       1989.692307692308 Mosaic Fertilizer LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 207.942 238.284 242.41 204.757 220.911 247.545 254.544 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
28542 28542 USA United States of America Heat Recovery Coke Facility USA0055066 94.6 41.6789 -87.42 Cogeneration       1998.0 Cokenergy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 327.1 342.38100000000003 400.169 343.628 286.645 299.504 309.625 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
30433 30433 USA United States of America Mosaic Co Bartow Facility USA0050633 81.9 27.908 -81.9185 Cogeneration Other     1989.296703296703 Mosaic Company U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 46692 2019 401.376 0.0 310.611 353.523 298.192 351.762 408.022 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
30435 30435 USA United States of America Mosaic New Wales Operations USA0010434 135.5 27.8336 -82.0519 Cogeneration       1991.7232472324724 Mosaic Fertilizer LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 23279 2019 443.487 522.59016 555.368 605.27 564.213 522.004 469.525 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION

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": 3041.702376998728,
  "sum_trace_duration_ms": 2487.897302977217,
  "num_traces": 43,
  "traces": [
    {
      "type": "sql",
      "start": 37346.893332164,
      "end": 37346.893784915,
      "duration_ms": 0.4527510027401149,
      "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": 37346.894007176,
      "end": 37346.894409199,
      "duration_ms": 0.4020229971501976,
      "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": 37346.894631047,
      "end": 37346.894874816,
      "duration_ms": 0.24376899818889797,
      "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": 37346.895358568,
      "end": 37346.895781645,
      "duration_ms": 0.42307699914090335,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/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": 37346.895417487,
      "end": 37346.895929761,
      "duration_ms": 0.5122739967191592,
      "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": 37346.898655228,
      "end": 37346.931744897,
      "duration_ms": 33.08966900658561,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 361, in get\n    response_or_template_contexts = await self.data(request, **data_kwargs)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 157, in data\n    return await self._data_traced(request, default_labels, _next, _size)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 478, in _data_traced\n    results = await db.execute(sql, params, truncate=True, **extra_args)\n"
      ],
      "database": "global-power-plants",
      "sql": "select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 order by generation_gwh_2018 limit 101",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37346.931969834,
      "end": 37346.963453514,
      "duration_ms": 31.48368000256596,
      "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 \"primary_fuel\" = :p0",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37346.964433458,
      "end": 37346.965168869,
      "duration_ms": 0.7354109984589741,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 146, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 124, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select * from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 ) limit 0",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37346.964485646,
      "end": 37346.965627957,
      "duration_ms": 1.1423109972383827,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 445, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 124, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select * from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 ) limit 0",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37346.964524542,
      "end": 37346.975889968,
      "duration_ms": 11.36542599851964,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 289, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 124, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select * from (select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 ) limit 0",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37346.964220069,
      "end": 37347.11658388,
      "duration_ms": 152.3638110011234,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 216, in facet_results\n    facet_rows_results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select country_long as value, count(*) as count from (\n                    select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 \n                )\n                where country_long is not null\n                group by country_long order by count desc, value limit 31",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37347.116340673,
      "end": 37347.157070934,
      "duration_ms": 40.730261003773194,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where country glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37347.117179734,
      "end": 37347.215770308,
      "duration_ms": 98.59057400171878,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37347.118321455,
      "end": 37347.55551627,
      "duration_ms": 437.1948150001117,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 216, in facet_results\n    facet_rows_results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select owner as value, count(*) as count from (\n                    select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 \n                )\n                where owner is not null\n                group by owner order by count desc, value limit 31",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37347.516472176,
      "end": 37347.560458318,
      "duration_ms": 43.98614200181328,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 )\n                where capacity_mw is not null and capacity_mw != ''",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37347.625070024,
      "end": 37347.816745758,
      "duration_ms": 191.67573400045512,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 216, in facet_results\n    facet_rows_results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select primary_fuel as value, count(*) as count from (\n                    select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 \n                )\n                where primary_fuel is not null\n                group by primary_fuel order by count desc, value limit 31",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37347.626110361,
      "end": 37347.817365065,
      "duration_ms": 191.25470399740152,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 )\n                where longitude is not null and longitude != ''",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37347.916472761,
      "end": 37347.966545984,
      "duration_ms": 50.07322300662054,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 )\n                where other_fuel2 is not null and other_fuel2 != ''",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37347.931118612,
      "end": 37348.016239613,
      "duration_ms": 85.12100100051612,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 164, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select commissioning_year as value, count(*) as n from (\n                    select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37348.116626693,
      "end": 37348.154126113,
      "duration_ms": 37.499419995583594,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 )\n                where commissioning_year is not null and commissioning_year != ''",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37348.217185747,
      "end": 37348.259917497,
      "duration_ms": 42.73174999980256,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where source glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37348.323017365,
      "end": 37348.371492838,
      "duration_ms": 48.47547299868893,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select date(geolocation_source) from (\n                    select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 \n                ) where geolocation_source glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37348.416335012,
      "end": 37348.455076777,
      "duration_ms": 38.74176499812165,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37348.422562995,
      "end": 37348.474567228,
      "duration_ms": 52.0042329953867,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where year_of_capacity_data glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37348.516484614,
      "end": 37348.553742198,
      "duration_ms": 37.2575839937781,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 )\n                where generation_gwh_2013 is not null and generation_gwh_2013 != ''",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37348.716058457,
      "end": 37348.816918238,
      "duration_ms": 100.85978099959902,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select date(generation_gwh_2016) from (\n                    select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 \n                ) where generation_gwh_2016 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37348.81767348,
      "end": 37348.853235427,
      "duration_ms": 35.56194699922344,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37348.916787502,
      "end": 37348.966977789,
      "duration_ms": 50.19028700189665,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where generation_gwh_2018 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37349.017003064,
      "end": 37349.116043283,
      "duration_ms": 99.0402190000168,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37349.117500118,
      "end": 37349.216168579,
      "duration_ms": 98.66846099612303,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where estimated_generation_gwh_2013 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37349.216760537,
      "end": 37349.248300893,
      "duration_ms": 31.540356001642067,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 )\n                where estimated_generation_gwh_2014 is not null and estimated_generation_gwh_2014 != ''",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37349.216632662,
      "end": 37349.31640386,
      "duration_ms": 99.77119800169021,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select date(estimated_generation_gwh_2014) from (\n                    select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 \n                ) where estimated_generation_gwh_2014 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37349.317187201,
      "end": 37349.352574792,
      "duration_ms": 35.38759100047173,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 )\n                where estimated_generation_gwh_2016 is not null and estimated_generation_gwh_2016 != ''",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37349.31694904,
      "end": 37349.358106461,
      "duration_ms": 41.15742099384079,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37349.358368914,
      "end": 37349.462865792,
      "duration_ms": 104.49687799700769,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37349.617094089,
      "end": 37349.656062073,
      "duration_ms": 38.96798400091939,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select date(estimated_generation_note_2013) from (\n                    select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 \n                ) where estimated_generation_note_2013 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37349.716198217,
      "end": 37349.759598267,
      "duration_ms": 43.40005000267411,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37349.716714362,
      "end": 37349.764228182,
      "duration_ms": 47.5138199981302,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where estimated_generation_note_2015 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37349.816274578,
      "end": 37349.848775403,
      "duration_ms": 32.50082500017015,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 81, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 460, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 696, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "global-power-plants",
      "sql": "select date(estimated_generation_note_2017) from (\n                    select rowid, country, country_long, name, gppd_idnr, capacity_mw, latitude, longitude, primary_fuel, other_fuel1, other_fuel2, other_fuel3, commissioning_year, owner, source, url, geolocation_source, wepp_id, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018, generation_gwh_2019, generation_data_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017 from [global-power-plants] where \"primary_fuel\" = :p0 \n                ) where estimated_generation_note_2017 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 37349.869583892,
      "end": 37349.870022504,
      "duration_ms": 0.438611998106353,
      "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": 37349.870244598,
      "end": 37349.870538911,
      "duration_ms": 0.29431299481075257,
      "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": 37349.870709452,
      "end": 37349.870969749,
      "duration_ms": 0.2602969980216585,
      "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": 37349.874172081,
      "end": 37349.874468463,
      "duration_ms": 0.296382000669837,
      "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
    }
  ]
}