facetable

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

4 rows where _city_id = 3 sorted by n

✎ View and edit SQL

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

Suggested facets: created, created (date)

_city_id 1 ✖

  • Detroit · 4 ✖
pk created planet_int on_earth state _city_id _neighborhood tags complex_array distinct_some_null n ▼
11 2019-01-16 08:00:00 1 1 MI Detroit 3 Downtown [] []    
12 2019-01-17 08:00:00 1 1 MI Detroit 3 Greektown [] []    
13 2019-01-17 08:00:00 1 1 MI Detroit 3 Corktown [] []    
14 2019-01-17 08:00:00 1 1 MI Detroit 3 Mexicantown [] []    

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": 51.91723699681461,
  "sum_trace_duration_ms": 34.93570891441777,
  "num_traces": 75,
  "traces": [
    {
      "type": "sql",
      "start": 478129.393929543,
      "end": 478129.394565437,
      "duration_ms": 0.6358940154314041,
      "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": 478129.394795276,
      "end": 478129.395050747,
      "duration_ms": 0.255471037235111,
      "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": 478129.395219649,
      "end": 478129.395387207,
      "duration_ms": 0.1675579696893692,
      "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": 478129.395515219,
      "end": 478129.395672945,
      "duration_ms": 0.1577259972691536,
      "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": 478129.395793865,
      "end": 478129.395953727,
      "duration_ms": 0.1598619855940342,
      "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": 478129.396077688,
      "end": 478129.396335115,
      "duration_ms": 0.25742698926478624,
      "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": 478129.39652213,
      "end": 478129.396731727,
      "duration_ms": 0.2095969975925982,
      "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": 478129.396954728,
      "end": 478129.397193065,
      "duration_ms": 0.23833697196096182,
      "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": 478129.397422056,
      "end": 478129.39765415,
      "duration_ms": 0.23209396749734879,
      "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": 478129.397892232,
      "end": 478129.398107375,
      "duration_ms": 0.21514302352443337,
      "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": 478129.398332162,
      "end": 478129.398540852,
      "duration_ms": 0.20869000582024455,
      "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": 478129.39878823,
      "end": 478129.399032045,
      "duration_ms": 0.24381495313718915,
      "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": 478129.399230274,
      "end": 478129.399423181,
      "duration_ms": 0.19290699856355786,
      "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": 478129.399628568,
      "end": 478129.3998325,
      "duration_ms": 0.2039320534095168,
      "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": 478129.401774896,
      "end": 478129.402200182,
      "duration_ms": 0.4252860089763999,
      "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 n limit 101",
      "params": {
        "p0": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.403301088,
      "end": 478129.403442041,
      "duration_ms": 0.14095299411565065,
      "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": 478129.403666,
      "end": 478129.403885115,
      "duration_ms": 0.21911499788984656,
      "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": 478129.40412278,
      "end": 478129.404322197,
      "duration_ms": 0.19941700156778097,
      "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": 478129.404531036,
      "end": 478129.404792956,
      "duration_ms": 0.2619200386106968,
      "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": 478129.405043248,
      "end": 478129.405232324,
      "duration_ms": 0.18907594494521618,
      "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": 478129.40540967,
      "end": 478129.405570159,
      "duration_ms": 0.16048899851739407,
      "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": 478129.406086259,
      "end": 478129.406292686,
      "duration_ms": 0.20642700837925076,
      "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": [
        3
      ]
    },
    {
      "type": "sql",
      "start": 478129.407765825,
      "end": 478129.408976077,
      "duration_ms": 1.2102519976906478,
      "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": 478129.408182467,
      "end": 478129.409525029,
      "duration_ms": 1.3425620272755623,
      "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": 478129.407919319,
      "end": 478129.409885098,
      "duration_ms": 1.9657789962366223,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.409301014,
      "end": 478129.410774998,
      "duration_ms": 1.4739840407855809,
      "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": 478129.411036733,
      "end": 478129.412042814,
      "duration_ms": 1.0060810018330812,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.411222564,
      "end": 478129.413652887,
      "duration_ms": 2.4303229874931276,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.412358267,
      "end": 478129.414409,
      "duration_ms": 2.050733019132167,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.414773258,
      "end": 478129.415320394,
      "duration_ms": 0.5471360054798424,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.415246256,
      "end": 478129.415835096,
      "duration_ms": 0.5888399900868535,
      "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": 478129.415502547,
      "end": 478129.41646236,
      "duration_ms": 0.9598130127415061,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.416208363,
      "end": 478129.417067155,
      "duration_ms": 0.8587919874116778,
      "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": 478129.416957795,
      "end": 478129.417585911,
      "duration_ms": 0.628116016741842,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.417299136,
      "end": 478129.417796803,
      "duration_ms": 0.49766700249165297,
      "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": 478129.417747813,
      "end": 478129.418524581,
      "duration_ms": 0.7767680217511952,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.418042292,
      "end": 478129.419091182,
      "duration_ms": 1.0488900006748736,
      "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": 478129.419332157,
      "end": 478129.419518152,
      "duration_ms": 0.18599501345306635,
      "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": 478129.419028209,
      "end": 478129.41999149,
      "duration_ms": 0.9632810251787305,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.419705342,
      "end": 478129.420186846,
      "duration_ms": 0.48150401562452316,
      "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": 478129.420149624,
      "end": 478129.42078501,
      "duration_ms": 0.6353859789669514,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.420741337,
      "end": 478129.421197025,
      "duration_ms": 0.45568798668682575,
      "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": [
        3
      ]
    },
    {
      "type": "sql",
      "start": 478129.420947744,
      "end": 478129.422080894,
      "duration_ms": 1.133150013629347,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.422239943,
      "end": 478129.422559364,
      "duration_ms": 0.3194210003130138,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.422746317,
      "end": 478129.423061545,
      "duration_ms": 0.31522801145911217,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.423215177,
      "end": 478129.423494219,
      "duration_ms": 0.27904199669137597,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.423653986,
      "end": 478129.423915343,
      "duration_ms": 0.2613569959066808,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.424115433,
      "end": 478129.424392323,
      "duration_ms": 0.27689000125974417,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.424532687,
      "end": 478129.424808818,
      "duration_ms": 0.27613097336143255,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.425276684,
      "end": 478129.425559872,
      "duration_ms": 0.2831880119629204,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.425722635,
      "end": 478129.426009671,
      "duration_ms": 0.28703600401058793,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.426165067,
      "end": 478129.426442537,
      "duration_ms": 0.27746998239308596,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.426602989,
      "end": 478129.426886354,
      "duration_ms": 0.28336496325209737,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.427081263,
      "end": 478129.427363822,
      "duration_ms": 0.2825590199790895,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.427518195,
      "end": 478129.42777611,
      "duration_ms": 0.25791500229388475,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.427926062,
      "end": 478129.42820581,
      "duration_ms": 0.2797479974105954,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.428347022,
      "end": 478129.428610383,
      "duration_ms": 0.2633610274642706,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.428785804,
      "end": 478129.429058026,
      "duration_ms": 0.27222197968512774,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.429204803,
      "end": 478129.429386477,
      "duration_ms": 0.1816739677451551,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.429558647,
      "end": 478129.429862829,
      "duration_ms": 0.30418200185522437,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.430392587,
      "end": 478129.43067113,
      "duration_ms": 0.27854304062202573,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.430841454,
      "end": 478129.431154827,
      "duration_ms": 0.3133729915134609,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.431679916,
      "end": 478129.431934932,
      "duration_ms": 0.2550160279497504,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.432440669,
      "end": 478129.432728824,
      "duration_ms": 0.28815498808398843,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.432887754,
      "end": 478129.433201578,
      "duration_ms": 0.3138239844702184,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.433375384,
      "end": 478129.433655849,
      "duration_ms": 0.2804649993777275,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.433807374,
      "end": 478129.434118343,
      "duration_ms": 0.31096901511773467,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.434278512,
      "end": 478129.434557617,
      "duration_ms": 0.27910497738048434,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.434734543,
      "end": 478129.435010663,
      "duration_ms": 0.2761199721135199,
      "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": "3"
      }
    },
    {
      "type": "sql",
      "start": 478129.435904607,
      "end": 478129.436123863,
      "duration_ms": 0.21925597684457898,
      "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": 478129.436379278,
      "end": 478129.436548994,
      "duration_ms": 0.1697159605100751,
      "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": 478129.436833988,
      "end": 478129.43701571,
      "duration_ms": 0.1817219890654087,
      "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": 478129.437941496,
      "end": 478129.438143741,
      "duration_ms": 0.20224496256560087,
      "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": 478129.43836395,
      "end": 478129.438613247,
      "duration_ms": 0.24929700884968042,
      "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": 478129.439003681,
      "end": 478129.439198919,
      "duration_ms": 0.19523798255249858,
      "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
    }
  ]
}