facetable

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

4 rows where _city_id = 3 sorted by distinct_some_null

✎ 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": 71.69470295775682,
  "sum_trace_duration_ms": 38.39117183815688,
  "num_traces": 75,
  "traces": [
    {
      "type": "sql",
      "start": 530080.618577447,
      "end": 530080.619180944,
      "duration_ms": 0.6034970283508301,
      "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": 530080.619439214,
      "end": 530080.619653357,
      "duration_ms": 0.2141429577022791,
      "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": 530080.61980348,
      "end": 530080.620054566,
      "duration_ms": 0.25108596310019493,
      "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": 530080.620298682,
      "end": 530080.620787575,
      "duration_ms": 0.48889301251620054,
      "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": 530080.621030083,
      "end": 530080.621294354,
      "duration_ms": 0.2642709296196699,
      "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": 530080.621454386,
      "end": 530080.621623956,
      "duration_ms": 0.16956997569650412,
      "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": 530080.62178453,
      "end": 530080.622036587,
      "duration_ms": 0.2520569832995534,
      "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": 530080.622308019,
      "end": 530080.622544049,
      "duration_ms": 0.23603008594363928,
      "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": 530080.622777335,
      "end": 530080.622958965,
      "duration_ms": 0.18163002096116543,
      "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": 530080.62320535,
      "end": 530080.623380835,
      "duration_ms": 0.17548503819853067,
      "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": 530080.623568161,
      "end": 530080.62374191,
      "duration_ms": 0.1737489365041256,
      "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": 530080.623935301,
      "end": 530080.624113565,
      "duration_ms": 0.17826398834586143,
      "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": 530080.624301772,
      "end": 530080.624566727,
      "duration_ms": 0.264954986050725,
      "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": 530080.624878455,
      "end": 530080.625284059,
      "duration_ms": 0.4056040197610855,
      "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": 530080.627633038,
      "end": 530080.628000789,
      "duration_ms": 0.3677509957924485,
      "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 distinct_some_null limit 101",
      "params": {
        "p0": "3"
      }
    },
    {
      "type": "sql",
      "start": 530080.629206903,
      "end": 530080.629473899,
      "duration_ms": 0.2669959794729948,
      "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": 530080.629724865,
      "end": 530080.629958786,
      "duration_ms": 0.2339209895581007,
      "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": 530080.630222398,
      "end": 530080.630470515,
      "duration_ms": 0.2481170231476426,
      "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": 530080.630671571,
      "end": 530080.630841582,
      "duration_ms": 0.17001095693558455,
      "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": 530080.631011334,
      "end": 530080.631254477,
      "duration_ms": 0.24314294569194317,
      "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": 530080.631467016,
      "end": 530080.631644681,
      "duration_ms": 0.17766503151506186,
      "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": 530080.632031747,
      "end": 530080.63229812,
      "duration_ms": 0.26637292467057705,
      "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": 530080.635171432,
      "end": 530080.636665242,
      "duration_ms": 1.4938099775463343,
      "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": 530080.635817797,
      "end": 530080.637153295,
      "duration_ms": 1.3354979455471039,
      "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": 530080.635363055,
      "end": 530080.637950846,
      "duration_ms": 2.587790950201452,
      "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": 530080.637088988,
      "end": 530080.638234614,
      "duration_ms": 1.145626069046557,
      "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": 530080.639008852,
      "end": 530080.640649859,
      "duration_ms": 1.6410070238634944,
      "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": 530080.63919907,
      "end": 530080.641576264,
      "duration_ms": 2.377194003202021,
      "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": 530080.640860452,
      "end": 530080.641965035,
      "duration_ms": 1.1045830324292183,
      "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": 530080.642716446,
      "end": 530080.643158446,
      "duration_ms": 0.4419999895617366,
      "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": 530080.642275283,
      "end": 530080.643618117,
      "duration_ms": 1.34283397346735,
      "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": 530080.643485512,
      "end": 530080.644317384,
      "duration_ms": 0.8318719919770956,
      "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": 530080.643934956,
      "end": 530080.644661495,
      "duration_ms": 0.7265389431267977,
      "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": 530080.64456174,
      "end": 530080.645471295,
      "duration_ms": 0.9095550049096346,
      "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": 530080.645721737,
      "end": 530080.645961505,
      "duration_ms": 0.23976806551218033,
      "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": 530080.645290182,
      "end": 530080.646247736,
      "duration_ms": 0.9575539734214544,
      "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": 530080.646172449,
      "end": 530080.646648746,
      "duration_ms": 0.476296991109848,
      "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": 530080.646397185,
      "end": 530080.647157521,
      "duration_ms": 0.7603359408676624,
      "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": 530080.646872629,
      "end": 530080.647371797,
      "duration_ms": 0.49916806165128946,
      "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": 530080.647323084,
      "end": 530080.648153733,
      "duration_ms": 0.8306490490213037,
      "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": 530080.647865145,
      "end": 530080.648587029,
      "duration_ms": 0.7218839600682259,
      "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": 530080.648452371,
      "end": 530080.649610833,
      "duration_ms": 1.1584620224311948,
      "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": 530080.649790749,
      "end": 530080.650086696,
      "duration_ms": 0.29594707302749157,
      "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": 530080.65029131,
      "end": 530080.650780686,
      "duration_ms": 0.48937590327113867,
      "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": 530080.650955969,
      "end": 530080.651269396,
      "duration_ms": 0.31342695001512766,
      "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": 530080.658586172,
      "end": 530080.659078891,
      "duration_ms": 0.49271900206804276,
      "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": 530080.659295809,
      "end": 530080.659586731,
      "duration_ms": 0.29092200566083193,
      "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": 530080.659834605,
      "end": 530080.660160672,
      "duration_ms": 0.3260670928284526,
      "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": 530080.660347362,
      "end": 530080.660682752,
      "duration_ms": 0.335389981046319,
      "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": 530080.661206435,
      "end": 530080.661544068,
      "duration_ms": 0.3376330714672804,
      "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": 530080.661723867,
      "end": 530080.662039133,
      "duration_ms": 0.3152660792693496,
      "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": 530080.66221025,
      "end": 530080.662617669,
      "duration_ms": 0.4074189346283674,
      "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": 530080.66279463,
      "end": 530080.663070843,
      "duration_ms": 0.2762129297479987,
      "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": 530080.663407658,
      "end": 530080.663770466,
      "duration_ms": 0.36280800122767687,
      "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": 530080.663952234,
      "end": 530080.664254056,
      "duration_ms": 0.30182208865880966,
      "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": 530080.664411669,
      "end": 530080.664690917,
      "duration_ms": 0.27924799360334873,
      "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": 530080.664904983,
      "end": 530080.665222954,
      "duration_ms": 0.3179709892719984,
      "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": 530080.665392701,
      "end": 530080.665666605,
      "duration_ms": 0.2739039482548833,
      "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": 530080.665810579,
      "end": 530080.666089542,
      "duration_ms": 0.2789630088955164,
      "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": 530080.666295975,
      "end": 530080.666653044,
      "duration_ms": 0.35706907510757446,
      "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": 530080.667224015,
      "end": 530080.667587088,
      "duration_ms": 0.36307296250015497,
      "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": 530080.667762565,
      "end": 530080.668078135,
      "duration_ms": 0.3155700396746397,
      "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": 530080.668604948,
      "end": 530080.668948644,
      "duration_ms": 0.34369598142802715,
      "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": 530080.669497393,
      "end": 530080.669819679,
      "duration_ms": 0.32228603959083557,
      "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": 530080.669991077,
      "end": 530080.670430723,
      "duration_ms": 0.43964595533907413,
      "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": 530080.670775378,
      "end": 530080.67136146,
      "duration_ms": 0.5860819946974516,
      "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": 530080.671540899,
      "end": 530080.671841575,
      "duration_ms": 0.3006759798154235,
      "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": 530080.672035349,
      "end": 530080.672374207,
      "duration_ms": 0.3388579934835434,
      "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": 530080.672536012,
      "end": 530080.672808377,
      "duration_ms": 0.2723649377003312,
      "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": 530080.673724595,
      "end": 530080.673956982,
      "duration_ms": 0.23238698486238718,
      "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": 530080.674293332,
      "end": 530080.674583736,
      "duration_ms": 0.29040395747870207,
      "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": 530080.674912101,
      "end": 530080.675160866,
      "duration_ms": 0.24876499082893133,
      "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": 530080.676485402,
      "end": 530080.676857635,
      "duration_ms": 0.3722329856827855,
      "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": 530080.677240192,
      "end": 530080.677503527,
      "duration_ms": 0.2633350668475032,
      "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": 530080.677872413,
      "end": 530080.678106407,
      "duration_ms": 0.23399409838020802,
      "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
    }
  ]
}