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"

✎ View and edit SQL

This data as json, CSV (advanced)

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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": 3333.8989060139284,
  "sum_trace_duration_ms": 2004.1275178664364,
  "num_traces": 31,
  "traces": [
    {
      "type": "sql",
      "start": 275577.483807879,
      "end": 275577.484464304,
      "duration_ms": 0.6564250215888023,
      "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": 275577.484706287,
      "end": 275577.485081094,
      "duration_ms": 0.37480704486370087,
      "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": 275577.485305141,
      "end": 275577.485767804,
      "duration_ms": 0.46266301069408655,
      "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": 275577.486294604,
      "end": 275577.48671804,
      "duration_ms": 0.42343599488958716,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/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": 275577.486372863,
      "end": 275577.487039098,
      "duration_ms": 0.6662349915131927,
      "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": 275577.49064977,
      "end": 275577.531695304,
      "duration_ms": 41.04553395882249,
      "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 rowid limit 101",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 275577.531947956,
      "end": 275577.57490904,
      "duration_ms": 42.961083992850035,
      "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": 275577.57618474,
      "end": 275577.57699001,
      "duration_ms": 0.8052699849940836,
      "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": 275577.576244278,
      "end": 275577.577404028,
      "duration_ms": 1.159749983344227,
      "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": 275577.576292733,
      "end": 275577.577680964,
      "duration_ms": 1.388231001328677,
      "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": 275577.575903839,
      "end": 275577.772141766,
      "duration_ms": 196.2379269534722,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": 275577.794457319,
      "end": 275578.37068328,
      "duration_ms": 576.2259609764442,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": 275578.172378735,
      "end": 275578.371296277,
      "duration_ms": 198.91754200216383,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where latitude glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 275578.399252044,
      "end": 275578.52418088,
      "duration_ms": 124.92883601225913,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": 275578.57538708,
      "end": 275578.622757739,
      "duration_ms": 47.37065895460546,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where other_fuel1 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 275578.77262261,
      "end": 275578.872621913,
      "duration_ms": 99.99930299818516,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": 275579.078272566,
      "end": 275579.125465336,
      "duration_ms": 47.192769998218864,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where url glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 275579.472215006,
      "end": 275579.517756301,
      "duration_ms": 45.54129496682435,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 )\n                where generation_gwh_2016 is not null and generation_gwh_2016 != ''",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 275579.572841845,
      "end": 275579.618430868,
      "duration_ms": 45.58902303688228,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 )\n                where generation_gwh_2018 is not null and generation_gwh_2018 != ''",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 275579.674975406,
      "end": 275579.720247966,
      "duration_ms": 45.27256003348157,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where generation_gwh_2017 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 275579.870774842,
      "end": 275579.971684276,
      "duration_ms": 100.90943402610719,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where generation_gwh_2019 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 275579.872045615,
      "end": 275579.972336155,
      "duration_ms": 100.29054002370685,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": 275580.071315004,
      "end": 275580.173165098,
      "duration_ms": 101.8500939826481,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": 275580.27136552,
      "end": 275580.321149615,
      "duration_ms": 49.784094968345016,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where estimated_generation_gwh_2015 glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 275580.477200663,
      "end": 275580.520973989,
      "duration_ms": 43.77332597505301,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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 \"primary_fuel\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Cogeneration"
      }
    },
    {
      "type": "sql",
      "start": 275580.571588529,
      "end": 275580.617065218,
      "duration_ms": 45.476689003407955,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": 275580.672579088,
      "end": 275580.715497751,
      "duration_ms": 42.91866300627589,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/asyncio/events.py\", line 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": 275580.740775397,
      "end": 275580.741315979,
      "duration_ms": 0.5405819974839687,
      "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": 275580.741697903,
      "end": 275580.742305911,
      "duration_ms": 0.6080079474486411,
      "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": 275580.742480691,
      "end": 275580.742951173,
      "duration_ms": 0.4704819875769317,
      "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": 275580.746499452,
      "end": 275580.746785746,
      "duration_ms": 0.28629403095692396,
      "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
    }
  ]
}