global-power-plants

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

Custom SQL query returning 14 rows (hide)

This data as json, CSV

_facetfacet_namefacet_countrowidcountrycountry_longnameownerprimary_fuel
      1 AFG Afghanistan Kajaki Hydroelectric Power Plant Afghanistan   Hydro
      2 AFG Afghanistan Kandahar DOG   Solar
      3 AFG Afghanistan Kandahar JOL   Solar
      4 AFG Afghanistan Mahipar Hydroelectric Power Plant Afghanistan   Hydro
country_long United States of America 9833            
country_long China 4235            
country_long United Kingdom 2751            
owner   14068            
owner Cypress Creek Renewables 185            
owner Lightsource Renewable Energy 121            
primary_fuel Solar 10665            
primary_fuel Hydro 7156            
primary_fuel Wind 5344            
COUNT   34936             
{
  "request_duration_ms": 109.66462298529223,
  "sum_trace_duration_ms": 84.22641502693295,
  "num_traces": 5,
  "traces": [
    {
      "type": "sql",
      "start": 276993.235262124,
      "end": 276993.235730284,
      "duration_ms": 0.4681600257754326,
      "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": 276993.235968986,
      "end": 276993.236370843,
      "duration_ms": 0.4018570180051029,
      "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": 276993.236751178,
      "end": 276993.237143997,
      "duration_ms": 0.39281899807974696,
      "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": 276993.238958209,
      "end": 276993.241179582,
      "duration_ms": 2.2213730262592435,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/database.py\", line 55, in data\n    return await QueryView(self.ds).data(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/database.py\", line 237, in data\n    named_parameters = named_parameters or await derive_named_parameters(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 1096, in derive_named_parameters\n    results = await db.execute(explain, {p: None for p in possible_params})\n"
      ],
      "database": "global-power-plants",
      "sql": "explain with cte as (\r\n  select rowid, country, country_long, name, owner, primary_fuel\r\n  from [global-power-plants]\r\n),\r\ntruncated as (\r\n  select null as _facet, null as facet_name, null as facet_count, rowid, country, country_long, name, owner, primary_fuel\r\n  from cte order by rowid limit 4\r\n),\r\ncountry_long_facet as (\r\n  select 'country_long' as _facet, country_long as facet_name, count(*) as facet_count,\r\n  null, null, null, null, null, null\r\n  from cte group by facet_name order by facet_count desc limit 3\r\n),\r\nowner_facet as (\r\n  select 'owner' as _facet, owner as facet_name, count(*) as facet_count,\r\n  null, null, null, null, null, null\r\n  from cte group by facet_name order by facet_count desc limit 3\r\n),\r\nprimary_fuel_facet as (\r\n  select 'primary_fuel' as _facet, primary_fuel as facet_name, count(*) as facet_count,\r\n  null, null, null, null, null, null\r\n  from cte group by facet_name order by facet_count desc limit 3\r\n),\r\ntotal_count as (\r\n  select 'COUNT' as _facet, '' as facet_name, count(*) as facet_count,\r\n  null, null, null, null, null, null\r\n  from cte\r\n)\r\nselect * from truncated\r\nunion all select * from country_long_facet\r\nunion all select * from owner_facet\r\nunion all select * from primary_fuel_facet\r\nunion all select * from total_count",
      "params": {}
    },
    {
      "type": "sql",
      "start": 276993.253479032,
      "end": 276993.334221238,
      "duration_ms": 80.74220595881343,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/database.py\", line 55, in data\n    return await QueryView(self.ds).data(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/database.py\", line 348, in data\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": "with cte as (\r\n  select rowid, country, country_long, name, owner, primary_fuel\r\n  from [global-power-plants]\r\n),\r\ntruncated as (\r\n  select null as _facet, null as facet_name, null as facet_count, rowid, country, country_long, name, owner, primary_fuel\r\n  from cte order by rowid limit 4\r\n),\r\ncountry_long_facet as (\r\n  select 'country_long' as _facet, country_long as facet_name, count(*) as facet_count,\r\n  null, null, null, null, null, null\r\n  from cte group by facet_name order by facet_count desc limit 3\r\n),\r\nowner_facet as (\r\n  select 'owner' as _facet, owner as facet_name, count(*) as facet_count,\r\n  null, null, null, null, null, null\r\n  from cte group by facet_name order by facet_count desc limit 3\r\n),\r\nprimary_fuel_facet as (\r\n  select 'primary_fuel' as _facet, primary_fuel as facet_name, count(*) as facet_count,\r\n  null, null, null, null, null, null\r\n  from cte group by facet_name order by facet_count desc limit 3\r\n),\r\ntotal_count as (\r\n  select 'COUNT' as _facet, '' as facet_name, count(*) as facet_count,\r\n  null, null, null, null, null, null\r\n  from cte\r\n)\r\nselect * from truncated\r\nunion all select * from country_long_facet\r\nunion all select * from owner_facet\r\nunion all select * from primary_fuel_facet\r\nunion all select * from total_count",
      "params": {
        "_trace": "1"
      }
    }
  ]
}