facetable

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

1 row where _neighborhood = "Dogpatch" sorted by state

✎ View and edit SQL

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

Suggested facets: created (date), tags (array)

_neighborhood 1 ✖

  • Dogpatch · 1 ✖
pk created planet_int on_earth state ▼ _city_id _neighborhood tags complex_array distinct_some_null n
2 2019-01-14 08:00:00 1 1 CA San Francisco 1 Dogpatch ["tag1", "tag3"] [] two n2

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": 47.0169710170012,
  "sum_trace_duration_ms": 27.892423910088837,
  "num_traces": 66,
  "traces": [
    {
      "type": "sql",
      "start": 182132.677904204,
      "end": 182132.678257592,
      "duration_ms": 0.3533879935275763,
      "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": 182132.678473702,
      "end": 182132.678714552,
      "duration_ms": 0.2408500004094094,
      "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": 182132.678867411,
      "end": 182132.679032758,
      "duration_ms": 0.1653469807934016,
      "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": 182132.679158793,
      "end": 182132.679313535,
      "duration_ms": 0.1547419815324247,
      "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": 182132.679436523,
      "end": 182132.679723891,
      "duration_ms": 0.2873679914046079,
      "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": 182132.679893043,
      "end": 182132.680321613,
      "duration_ms": 0.42856999789364636,
      "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": 182132.680474602,
      "end": 182132.680671508,
      "duration_ms": 0.1969059812836349,
      "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": 182132.680870972,
      "end": 182132.681271335,
      "duration_ms": 0.4003630019724369,
      "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": 182132.681497263,
      "end": 182132.681687729,
      "duration_ms": 0.1904660020954907,
      "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": 182132.681887251,
      "end": 182132.682037248,
      "duration_ms": 0.14999700943008065,
      "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": 182132.68220294,
      "end": 182132.6823572,
      "duration_ms": 0.15426002210006118,
      "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": 182132.682539391,
      "end": 182132.682698767,
      "duration_ms": 0.1593759807292372,
      "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": 182132.682863655,
      "end": 182132.683031728,
      "duration_ms": 0.16807299107313156,
      "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": 182132.683190182,
      "end": 182132.683327623,
      "duration_ms": 0.13744100579060614,
      "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": 182132.68490527,
      "end": 182132.685227744,
      "duration_ms": 0.32247399212792516,
      "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 \"_neighborhood\" = :p0 order by state limit 101",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.686314747,
      "end": 182132.686514986,
      "duration_ms": 0.20023901015520096,
      "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": 182132.686723295,
      "end": 182132.686887901,
      "duration_ms": 0.16460602637380362,
      "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": 182132.687066449,
      "end": 182132.687223322,
      "duration_ms": 0.1568729931022972,
      "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": 182132.68740499,
      "end": 182132.687604738,
      "duration_ms": 0.1997479994315654,
      "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": 182132.687813493,
      "end": 182132.687987123,
      "duration_ms": 0.17363001825287938,
      "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": 182132.688159561,
      "end": 182132.688314815,
      "duration_ms": 0.15525400522165,
      "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": 182132.688801221,
      "end": 182132.689003004,
      "duration_ms": 0.20178299746476114,
      "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": [
        1
      ]
    },
    {
      "type": "sql",
      "start": 182132.690742261,
      "end": 182132.691492912,
      "duration_ms": 0.7506510009989142,
      "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 \"_neighborhood\" = :p0",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.69079421,
      "end": 182132.691761525,
      "duration_ms": 0.9673149907030165,
      "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": 182132.692828766,
      "end": 182132.694015235,
      "duration_ms": 1.186468987725675,
      "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 _neighborhood 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 \"_neighborhood\" = :p0 \n                )\n                where _neighborhood is not null\n                group by _neighborhood order by count desc, value limit 31",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.690886462,
      "end": 182132.694418329,
      "duration_ms": 3.5318669979460537,
      "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": 182132.69296382,
      "end": 182132.694894313,
      "duration_ms": 1.9304929883219302,
      "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 \"_neighborhood\" = :p0 ) limit 0",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.695184308,
      "end": 182132.696215913,
      "duration_ms": 1.0316050029359758,
      "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 \"_neighborhood\" = :p0 ) limit 0",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.694834177,
      "end": 182132.697072477,
      "duration_ms": 2.2382999886758626,
      "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": 182132.69656793,
      "end": 182132.698163341,
      "duration_ms": 1.5954110131133348,
      "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 \"_neighborhood\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.698341667,
      "end": 182132.698658251,
      "duration_ms": 0.31658398802392185,
      "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 \"_neighborhood\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.698808441,
      "end": 182132.699097823,
      "duration_ms": 0.2893820055760443,
      "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 \"_neighborhood\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.699262731,
      "end": 182132.699554587,
      "duration_ms": 0.29185597668401897,
      "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 \"_neighborhood\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.699710756,
      "end": 182132.700003804,
      "duration_ms": 0.29304801137186587,
      "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 \"_neighborhood\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.700202648,
      "end": 182132.700511766,
      "duration_ms": 0.30911798239685595,
      "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 _city_id 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 \"_neighborhood\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.700667971,
      "end": 182132.70095012,
      "duration_ms": 0.28214900521561503,
      "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 \"_neighborhood\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.701086071,
      "end": 182132.701293652,
      "duration_ms": 0.2075810043606907,
      "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 \"_neighborhood\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.701462667,
      "end": 182132.701796467,
      "duration_ms": 0.3338000096846372,
      "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 \"_neighborhood\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.701959191,
      "end": 182132.702213515,
      "duration_ms": 0.2543239970691502,
      "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 \"_neighborhood\" = :p0 \n                ) where value is not null\n                group by value\n                limit 31",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.702395617,
      "end": 182132.702663538,
      "duration_ms": 0.26792098651640117,
      "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 \"_neighborhood\" = :p0 ) limit 0",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.702837625,
      "end": 182132.703082874,
      "duration_ms": 0.24524901527911425,
      "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 \"_neighborhood\" = :p0 \n                ) where pk glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.703240565,
      "end": 182132.703484,
      "duration_ms": 0.2434350026305765,
      "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 \"_neighborhood\" = :p0 \n                ) where created glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.703919708,
      "end": 182132.704224202,
      "duration_ms": 0.30449399491772056,
      "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 \"_neighborhood\" = :p0 \n                ) where planet_int glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.704490949,
      "end": 182132.704907068,
      "duration_ms": 0.41611900087445974,
      "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 \"_neighborhood\" = :p0 \n                ) where on_earth glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.705086199,
      "end": 182132.705348678,
      "duration_ms": 0.26247897767461836,
      "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 \"_neighborhood\" = :p0 \n                ) where state glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.705504744,
      "end": 182132.705773739,
      "duration_ms": 0.268995005171746,
      "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 \"_neighborhood\" = :p0 \n                ) where _city_id glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.705931537,
      "end": 182132.706230806,
      "duration_ms": 0.2992690133396536,
      "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 \"_neighborhood\" = :p0 \n                ) where _neighborhood glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.706449097,
      "end": 182132.706733528,
      "duration_ms": 0.28443100745789707,
      "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 \"_neighborhood\" = :p0 \n                ) where tags glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.706888964,
      "end": 182132.707177649,
      "duration_ms": 0.288684997940436,
      "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 \"_neighborhood\" = :p0 \n                ) where complex_array glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.707380875,
      "end": 182132.707656821,
      "duration_ms": 0.27594598941504955,
      "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 \"_neighborhood\" = :p0 \n                ) where distinct_some_null glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.707814484,
      "end": 182132.708079,
      "duration_ms": 0.26451601297594607,
      "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 \"_neighborhood\" = :p0 \n                ) where n glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.708234961,
      "end": 182132.708506277,
      "duration_ms": 0.27131600654684007,
      "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 \"_neighborhood\" = :p0 ) limit 0",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.708676505,
      "end": 182132.70894533,
      "duration_ms": 0.26882500969804823,
      "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 \"_neighborhood\" = :p0 )\n                where pk is not null and pk != ''",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.709507616,
      "end": 182132.70976921,
      "duration_ms": 0.26159398839809,
      "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 \"_neighborhood\" = :p0 )\n                where planet_int is not null and planet_int != ''",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.709935121,
      "end": 182132.710220823,
      "duration_ms": 0.2857020008377731,
      "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 \"_neighborhood\" = :p0 )\n                where on_earth is not null and on_earth != ''",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.710725137,
      "end": 182132.711038195,
      "duration_ms": 0.31305800075642765,
      "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 \"_neighborhood\" = :p0 )\n                where _city_id is not null and _city_id != ''",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.711579875,
      "end": 182132.711892774,
      "duration_ms": 0.3128990065306425,
      "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 \"_neighborhood\" = :p0 )\n                where tags is not null and tags != ''",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.712056582,
      "end": 182132.712320472,
      "duration_ms": 0.2638899895828217,
      "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 \"_neighborhood\" = :p0 ) where tags is not null and tags != '' and json_array_length(tags) > 0 limit 100",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.712809126,
      "end": 182132.713118021,
      "duration_ms": 0.30889498884789646,
      "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 \"_neighborhood\" = :p0 )\n                where complex_array is not null and complex_array != ''",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.713286868,
      "end": 182132.713614574,
      "duration_ms": 0.3277059877291322,
      "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 \"_neighborhood\" = :p0 ) where complex_array is not null and complex_array != '' and json_array_length(complex_array) > 0 limit 100",
      "params": {
        "p0": "Dogpatch"
      }
    },
    {
      "type": "sql",
      "start": 182132.715128673,
      "end": 182132.71534051,
      "duration_ms": 0.21183700300753117,
      "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": 182132.715609862,
      "end": 182132.715799664,
      "duration_ms": 0.18980199820362031,
      "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": 182132.716080665,
      "end": 182132.716296899,
      "duration_ms": 0.21623398060910404,
      "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": 182132.717320163,
      "end": 182132.7175931,
      "duration_ms": 0.27293700259178877,
      "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": 182132.717852938,
      "end": 182132.718053241,
      "duration_ms": 0.20030300947837532,
      "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": 182132.718493468,
      "end": 182132.718687648,
      "duration_ms": 0.1941800001077354,
      "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
    }
  ]
}