facetable

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

4 rows where _city_id = 2 sorted by planet_int

✎ View and edit SQL

This data as json, testall, testnone, testresponse, CSV (advanced)

Suggested facets: created, created (date)

_city_id 1 ✖

  • Los Angeles · 4 ✖
pk created planet_int ▼ on_earth state _city_id _neighborhood tags complex_array distinct_some_null n
7 2019-01-15 08:00:00 1 1 CA Los Angeles 2 Hollywood [] []    
8 2019-01-15 08:00:00 1 1 CA Los Angeles 2 Downtown [] []    
9 2019-01-16 08:00:00 1 1 CA Los Angeles 2 Los Feliz [] []    
10 2019-01-16 08:00:00 1 1 CA Los Angeles 2 Koreatown [] []    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE facetable (
    pk integer primary key,
    created text,
    planet_int integer,
    on_earth integer,
    state text,
    _city_id integer,
    _neighborhood text,
    tags text,
    complex_array text,
    distinct_some_null,
    n text,
    FOREIGN KEY ("_city_id") REFERENCES [facet_cities](id)
);
{
  "request_duration_ms": 77.22480900702067,
  "sum_trace_duration_ms": 47.52180402283557,
  "num_traces": 75,
  "traces": [
    {
      "type": "sql",
      "start": 253820.832520546,
      "end": 253820.832859142,
      "duration_ms": 0.3385960008017719,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 482, in _refresh_schemas\n    for row in await internal_db.execute(\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select database_name, schema_version from catalog_databases",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.833093621,
      "end": 253820.83327866,
      "duration_ms": 0.1850389817263931,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.833446478,
      "end": 253820.834604644,
      "duration_ms": 1.1581660073716193,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "fixtures",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.835378558,
      "end": 253820.835787418,
      "duration_ms": 0.4088600107934326,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "fixtures2",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.836059537,
      "end": 253820.836929279,
      "duration_ms": 0.8697420125827193,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "extra_database",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.837192692,
      "end": 253820.837455226,
      "duration_ms": 0.2625339839141816,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "counters",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.837625083,
      "end": 253820.837918331,
      "duration_ms": 0.29324801289476454,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "ephemeral",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.83850938,
      "end": 253820.838842081,
      "duration_ms": 0.33270099083893,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 776, in table_view_traced\n    resolved = await datasette.resolve_table(request)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1564, in resolve_table\n    table_exists = await db.table_exists(table_name)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 405, in table_exists\n    results = await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select 1 from sqlite_master where type='table' and name=?",
      "params": [
        "facetable"
      ]
    },
    {
      "type": "sql",
      "start": 253820.839093578,
      "end": 253820.839290917,
      "duration_ms": 0.19733901717700064,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.839525458,
      "end": 253820.839708709,
      "duration_ms": 0.18325101700611413,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.839893159,
      "end": 253820.841199891,
      "duration_ms": 1.3067320105619729,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.841445229,
      "end": 253820.841631359,
      "duration_ms": 0.18613002612255514,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.841820213,
      "end": 253820.84204213,
      "duration_ms": 0.22191699827089906,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.842229099,
      "end": 253820.843648171,
      "duration_ms": 1.4190719812177122,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.846676604,
      "end": 253820.847180467,
      "duration_ms": 0.5038630042690784,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 747, in table_view\n    response = await table_view_traced(datasette, request)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 800, in table_view_traced\n    view_data = await table_view_data(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1185, in table_view_data\n    results = await db.execute(sql, params, truncate=True, **extra_args)\n"
      ],
      "database": "fixtures",
      "sql": "select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 order by planet_int limit 101",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.848565126,
      "end": 253820.849537195,
      "duration_ms": 0.9720689849928021,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.849797236,
      "end": 253820.850056774,
      "duration_ms": 0.25953800650313497,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.850310771,
      "end": 253820.850510278,
      "duration_ms": 0.1995069906115532,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.850704637,
      "end": 253820.850951924,
      "duration_ms": 0.24728698190301657,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.851261794,
      "end": 253820.851524395,
      "duration_ms": 0.262600980931893,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.851801689,
      "end": 253820.852014181,
      "duration_ms": 0.21249201381579041,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.85251119,
      "end": 253820.852689103,
      "duration_ms": 0.17791299615055323,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1229, in table_view_data\n    await datasette.expand_foreign_keys(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1068, in expand_foreign_keys\n    results = await self.execute(database, sql, list(set(values)))\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select id, name\n            from facet_cities\n            where id in (?)",
      "params": [
        2
      ]
    },
    {
      "type": "sql",
      "start": 253820.854235739,
      "end": 253820.855528451,
      "duration_ms": 1.2927119969390333,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/asyncinject/__init__.py\", line 132, in worker\n    res = await self._get_awaitable(name, results)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1529, in extra_table_definition\n    return await db.get_table_definition(table_name)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 530, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select sql from sqlite_master where name = :n and type=:t",
      "params": {
        "n": "facetable",
        "t": "table"
      }
    },
    {
      "type": "sql",
      "start": 253820.854403174,
      "end": 253820.855788113,
      "duration_ms": 1.3849390088580549,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/asyncinject/__init__.py\", line 132, in worker\n    res = await self._get_awaitable(name, results)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1298, in extra_count\n    count_rows = list(await db.execute(count_sql, from_sql_params))\n"
      ],
      "database": "fixtures",
      "sql": "select count(*) from facetable where \"_city_id\" = :p0",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.85469764,
      "end": 253820.856645736,
      "duration_ms": 1.9480960036162287,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1532, in extra_view_definition\n    return await db.get_view_definition(table_name)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 550, in get_view_definition\n    return await self.get_table_definition(view, \"view\")\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 530, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select sql from sqlite_master where name = :n and type=:t",
      "params": {
        "n": "facetable",
        "t": "view"
      }
    },
    {
      "type": "sql",
      "start": 253820.855701627,
      "end": 253820.857838436,
      "duration_ms": 2.136808994691819,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/asyncinject/__init__.py\", line 132, in worker\n    res = await self._get_awaitable(name, results)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1529, in extra_table_definition\n    return await db.get_table_definition(table_name)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 540, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select sql from sqlite_master where tbl_name = :n and type='index' and sql is not null",
      "params": {
        "n": "facetable"
      }
    },
    {
      "type": "sql",
      "start": 253820.85804233,
      "end": 253820.859505055,
      "duration_ms": 1.4627250202465802,
      "traceback": [
        "  File \"plugins/my_plugin.py\", line 167, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 138, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 ) limit 0",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.858540457,
      "end": 253820.861847067,
      "duration_ms": 3.306609985884279,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 230, in facet_results\n    facet_rows_results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select _city_id as value, count(*) as count from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                )\n                where _city_id is not null\n                group by _city_id order by count desc, value limit 31",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.859927275,
      "end": 253820.862905162,
      "duration_ms": 2.9778869939036667,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 160, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 138, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 ) limit 0",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.863265841,
      "end": 253820.863540648,
      "duration_ms": 0.2748069819062948,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.863162963,
      "end": 253820.864059655,
      "duration_ms": 0.896691984962672,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select pk as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.863926406,
      "end": 253820.86453199,
      "duration_ms": 0.6055840058252215,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.864719398,
      "end": 253820.86501909,
      "duration_ms": 0.2996920084115118,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.864408555,
      "end": 253820.865435911,
      "duration_ms": 1.027355989208445,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select created as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.865333418,
      "end": 253820.866348362,
      "duration_ms": 1.0149439913220704,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.865884872,
      "end": 253820.866633822,
      "duration_ms": 0.74894999852404,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select planet_int as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.866558352,
      "end": 253820.867165339,
      "duration_ms": 0.6069870141800493,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.867461867,
      "end": 253820.867742231,
      "duration_ms": 0.28036400908604264,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.866927334,
      "end": 253820.868233193,
      "duration_ms": 1.3058590120635927,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select on_earth as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.868432564,
      "end": 253820.868840325,
      "duration_ms": 0.40776102105155587,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select state as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.868994272,
      "end": 253820.869429983,
      "duration_ms": 0.4357110010460019,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select _neighborhood as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.868800708,
      "end": 253820.869937656,
      "duration_ms": 1.13694800529629,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 254, in facet_results\n    expanded = await self.ds.expand_foreign_keys(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1068, in expand_foreign_keys\n    results = await self.execute(database, sql, list(set(values)))\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select id, name\n            from facet_cities\n            where id in (?)",
      "params": [
        2
      ]
    },
    {
      "type": "sql",
      "start": 253820.869635811,
      "end": 253820.870961462,
      "duration_ms": 1.3256510137580335,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select tags as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.871138882,
      "end": 253820.871501836,
      "duration_ms": 0.36295398604124784,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select complex_array as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.871687183,
      "end": 253820.872025221,
      "duration_ms": 0.3380379930604249,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct_some_null as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.872189245,
      "end": 253820.872665714,
      "duration_ms": 0.4764689947478473,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select n as value, count(*) as n from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.872847042,
      "end": 253820.873427923,
      "duration_ms": 0.5808810237795115,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 459, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 138, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 ) limit 0",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.873796423,
      "end": 253820.874274556,
      "duration_ms": 0.47813300625421107,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(pk) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where pk glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.874439373,
      "end": 253820.874969118,
      "duration_ms": 0.5297450115904212,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(created) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where created glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.876954613,
      "end": 253820.87746844,
      "duration_ms": 0.5138270207680762,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(planet_int) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where planet_int glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.877699863,
      "end": 253820.878030967,
      "duration_ms": 0.3311040054541081,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(on_earth) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where on_earth glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.878286592,
      "end": 253820.878616776,
      "duration_ms": 0.3301840042695403,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(state) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where state glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.878808785,
      "end": 253820.879152608,
      "duration_ms": 0.34382299054414034,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(_city_id) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where _city_id glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.880037304,
      "end": 253820.880739349,
      "duration_ms": 0.7020449847914279,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(_neighborhood) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where _neighborhood glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.88091805,
      "end": 253820.881199338,
      "duration_ms": 0.281287997495383,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(tags) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where tags glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.881369056,
      "end": 253820.881613093,
      "duration_ms": 0.24403698625974357,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(complex_array) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where complex_array glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.881757113,
      "end": 253820.882050223,
      "duration_ms": 0.2931100025307387,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(distinct_some_null) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where distinct_some_null glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.882233894,
      "end": 253820.882671245,
      "duration_ms": 0.43735100189223886,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(n) from (\n                    select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n                ) where n glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.882895602,
      "end": 253820.883262257,
      "duration_ms": 0.36665500374510884,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 303, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 138, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 ) limit 0",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.883484168,
      "end": 253820.883921317,
      "duration_ms": 0.43714899220503867,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(pk)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n                where pk is not null and pk != ''",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.884492073,
      "end": 253820.884804051,
      "duration_ms": 0.3119779867120087,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(planet_int)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n                where planet_int is not null and planet_int != ''",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.884959652,
      "end": 253820.885432039,
      "duration_ms": 0.4723870079033077,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(on_earth)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n                where on_earth is not null and on_earth != ''",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.885963197,
      "end": 253820.886339863,
      "duration_ms": 0.3766659938264638,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(_city_id)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n                where _city_id is not null and _city_id != ''",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.886862729,
      "end": 253820.887230551,
      "duration_ms": 0.3678219800349325,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(tags)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n                where tags is not null and tags != ''",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.887403859,
      "end": 253820.88783575,
      "duration_ms": 0.4318910068832338,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 331, in suggest\n    for v in await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select tags from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 ) where tags is not null and tags != '' and json_array_length(tags) > 0 limit 100",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.888040495,
      "end": 253820.888358086,
      "duration_ms": 0.3175910096615553,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(complex_array)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n                where complex_array is not null and complex_array != ''",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.888513507,
      "end": 253820.888783154,
      "duration_ms": 0.26964698918163776,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 331, in suggest\n    for v in await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select complex_array from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 ) where complex_array is not null and complex_array != '' and json_array_length(complex_array) > 0 limit 100",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.888949445,
      "end": 253820.890062947,
      "duration_ms": 1.1135019885841757,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(distinct_some_null)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n                where distinct_some_null is not null and distinct_some_null != ''",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.890351426,
      "end": 253820.890807983,
      "duration_ms": 0.45655699796043336,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n    results.append(await fn)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(n)\n                from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n                where n is not null and n != ''",
      "params": {
        "p0": "2"
      }
    },
    {
      "type": "sql",
      "start": 253820.891799224,
      "end": 253820.892012117,
      "duration_ms": 0.2128930063918233,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.892289399,
      "end": 253820.892464512,
      "duration_ms": 0.17511300393380225,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1280, in render_template\n    extra_script = await await_me_maybe(extra_script)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin.py\", line 90, in inner\n    await datasette.get_database().execute(\"select 3 * 5\")\n"
      ],
      "database": "_memory",
      "sql": "select 3 * 5",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.892746775,
      "end": 253820.892968322,
      "duration_ms": 0.2215470012743026,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1367, in _asset_urls\n    hook = await await_me_maybe(hook)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin.py\", line 47, in inner\n    await datasette.get_database().execute(\"select 3 * 5\")\n"
      ],
      "database": "_memory",
      "sql": "select 3 * 5",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.89444084,
      "end": 253820.894702528,
      "duration_ms": 0.26168799377046525,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.894946444,
      "end": 253820.89514931,
      "duration_ms": 0.2028660092037171,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 253820.895492792,
      "end": 253820.895699974,
      "duration_ms": 0.2071819908451289,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 123, in inner\n    await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
      ],
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    }
  ]
}