{
  "request_duration_ms": 240.48788900108775,
  "sum_trace_duration_ms": 167.59470498072915,
  "num_traces": 74,
  "traces": [
    {
      "type": "sql",
      "start": 62054.037552196,
      "end": 62054.038166914,
      "duration_ms": 0.6147179956315085,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 751, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 516, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 526, in _refresh_schemas\n    for row in await internal_db.execute(\n"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select database_name, schema_version from catalog_databases",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.038422302,
      "end": 62054.039181889,
      "duration_ms": 0.7595869974466041,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 751, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 516, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 531, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "error": null,
      "database": "_memory",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.039376883,
      "end": 62054.041177587,
      "duration_ms": 1.8007039980147965,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 751, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 516, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 531, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.041365732,
      "end": 62054.043720065,
      "duration_ms": 2.35433299530996,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 751, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 516, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 531, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "error": null,
      "database": "fixtures2",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.044311588,
      "end": 62054.045368727,
      "duration_ms": 1.0571390012046322,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 751, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 516, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 531, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "error": null,
      "database": "extra_database",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.045738516,
      "end": 62054.046879043,
      "duration_ms": 1.140527005190961,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 751, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 516, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 531, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "error": null,
      "database": "counters",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.047080051,
      "end": 62054.054101742,
      "duration_ms": 7.021690995316021,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 751, in table_view\n    await datasette.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 516, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 531, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "error": null,
      "database": "ephemeral",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.054397849,
      "end": 62054.055981835,
      "duration_ms": 1.5839859988773242,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 782, in table_view_traced\n    resolved = await datasette.resolve_table(request)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1657, 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 414, in table_exists\n    results = await self.execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select 1 from sqlite_master where type='table' and name=?",
      "params": [
        "facetable"
      ]
    },
    {
      "type": "sql",
      "start": 62054.056325705,
      "end": 62054.057499667,
      "duration_ms": 1.1739619949366897,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.057781707,
      "end": 62054.059029559,
      "duration_ms": 1.2478520002332516,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.059361966,
      "end": 62054.059765378,
      "duration_ms": 0.4034119992866181,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.060136345,
      "end": 62054.060682557,
      "duration_ms": 0.5462120025185868,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.061119788,
      "end": 62054.062199606,
      "duration_ms": 1.0798180010169744,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.062466811,
      "end": 62054.063368147,
      "duration_ms": 0.9013359958771616,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.066159422,
      "end": 62054.067507912,
      "duration_ms": 1.3484899973263964,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 753, 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 806, 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 1191, in table_view_data\n    results = await db.execute(sql, params, truncate=True, **extra_args)\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable order by pk limit 101",
      "params": {}
    },
    {
      "type": "sql",
      "start": 62054.074157078,
      "end": 62054.075563267,
      "duration_ms": 1.4061889960430562,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.076408821,
      "end": 62054.077987036,
      "duration_ms": 1.5782150003360584,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.078290688,
      "end": 62054.079831025,
      "duration_ms": 1.5403370052808896,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.080490784,
      "end": 62054.081699788,
      "duration_ms": 1.2090040036127903,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.082216524,
      "end": 62054.084079995,
      "duration_ms": 1.8634709995239973,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.084587546,
      "end": 62054.085190232,
      "duration_ms": 0.6026859991834499,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.087132085,
      "end": 62054.088162438,
      "duration_ms": 1.0303529998054728,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1235, in table_view_data\n    await datasette.expand_foreign_keys(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1155, 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 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select id, name\n            from facet_cities\n            where id in (?, ?, ?, ?)",
      "params": [
        1,
        2,
        3,
        4
      ]
    },
    {
      "type": "sql",
      "start": 62054.090488973,
      "end": 62054.092372316,
      "duration_ms": 1.883343000372406,
      "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 1549, 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 626, in get_table_definition\n    await self.execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select sql from sqlite_master where name = :n and type=:t",
      "params": {
        "n": "facetable",
        "t": "table"
      }
    },
    {
      "type": "sql",
      "start": 62054.09055229,
      "end": 62054.093278723,
      "duration_ms": 2.726432998315431,
      "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 1493, in extra_metadata\n    tablemetadata = await datasette.get_resource_metadata(database_name, table_name)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 719, in get_resource_metadata\n    rows = await self.get_internal_database().execute(\n"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "SELECT\n                key,\n                value\n              FROM metadata_resources\n              WHERE database_name = ?\n                AND resource_name = ?",
      "params": [
        "fixtures",
        "facetable"
      ]
    },
    {
      "type": "sql",
      "start": 62054.090585937,
      "end": 62054.093552085,
      "duration_ms": 2.9661480002687313,
      "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 1462, in run_display_columns_and_rows\n    display_columns, display_rows = await display_columns_and_rows(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 151, in display_columns_and_rows\n    await datasette.get_internal_database().execute(\n"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "SELECT\n            column_name,\n            value\n          FROM metadata_columns\n          WHERE database_name = ?\n            AND resource_name = ?\n            AND key = 'description'",
      "params": [
        "fixtures",
        "facetable"
      ]
    },
    {
      "type": "sql",
      "start": 62054.090679252,
      "end": 62054.093682944,
      "duration_ms": 3.0036919997655787,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1552, 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 646, 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 626, in get_table_definition\n    await self.execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select sql from sqlite_master where name = :n and type=:t",
      "params": {
        "n": "facetable",
        "t": "view"
      }
    },
    {
      "type": "sql",
      "start": 62054.091799795,
      "end": 62054.094457892,
      "duration_ms": 2.6580970006762072,
      "traceback": [
        "  File \"plugins/my_plugin.py\", line 170, 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 145, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "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 ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.093038689,
      "end": 62054.094827788,
      "duration_ms": 1.7890989984152839,
      "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 1549, 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 636, in get_table_definition\n    await self.execute(\n"
      ],
      "error": null,
      "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": 62054.093515894,
      "end": 62054.095027437,
      "duration_ms": 1.511542999651283,
      "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 1495, in extra_metadata\n    rows = await datasette.get_internal_database().execute(\n"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "SELECT\n                column_name,\n                value\n              FROM metadata_columns\n              WHERE database_name = ?\n                AND resource_name = ?\n                AND key = 'description'",
      "params": [
        "fixtures",
        "facetable"
      ]
    },
    {
      "type": "sql",
      "start": 62054.094710108,
      "end": 62054.09681456,
      "duration_ms": 2.1044519962742925,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 156, 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 145, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "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 ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.097204249,
      "end": 62054.132802142,
      "duration_ms": 35.5978929947014,
      "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 177, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select pk as value, count(*) as n from limited\n                where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.133212242,
      "end": 62054.136388356,
      "duration_ms": 3.176113998051733,
      "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 177, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select created as value, count(*) as n from limited\n                where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.137097245,
      "end": 62054.138538504,
      "duration_ms": 1.4412589953280985,
      "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 177, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select planet_int as value, count(*) as n from limited\n                where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.139373799,
      "end": 62054.142515141,
      "duration_ms": 3.1413420001626946,
      "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 177, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select on_earth as value, count(*) as n from limited\n                where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.143076993,
      "end": 62054.146134619,
      "duration_ms": 3.0576259960071184,
      "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 177, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select state as value, count(*) as n from limited\n                where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.147244905,
      "end": 62054.15248739,
      "duration_ms": 5.242485000053421,
      "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 177, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select _city_id as value, count(*) as n from limited\n                where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.154604639,
      "end": 62054.156186532,
      "duration_ms": 1.5818930041859858,
      "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 177, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select _neighborhood as value, count(*) as n from limited\n                where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.156854823,
      "end": 62054.15781779,
      "duration_ms": 0.96296700212406,
      "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 177, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select tags as value, count(*) as n from limited\n                where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.159084597,
      "end": 62054.159717303,
      "duration_ms": 0.6327060036710463,
      "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 177, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select complex_array as value, count(*) as n from limited\n                where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.160965054,
      "end": 62054.161963134,
      "duration_ms": 0.998080002318602,
      "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 177, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select distinct_some_null as value, count(*) as n from limited\n                where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.162164681,
      "end": 62054.162671439,
      "duration_ms": 0.5067579986643977,
      "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 177, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select n as value, count(*) as n from limited\n                where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.162825633,
      "end": 62054.163589807,
      "duration_ms": 0.7641740012331866,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, 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 145, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "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 ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.163896795,
      "end": 62054.164504362,
      "duration_ms": 0.6075670025893487,
      "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 489, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select date(pk) from (\n                    select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 100\n                ) where pk glob \"????-??-*\"",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.164715607,
      "end": 62054.165699799,
      "duration_ms": 0.9841919963946566,
      "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 489, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select date(created) from (\n                    select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 100\n                ) where created glob \"????-??-*\"",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.16644732,
      "end": 62054.168453296,
      "duration_ms": 2.005975999054499,
      "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 489, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select date(planet_int) from (\n                    select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 100\n                ) where planet_int glob \"????-??-*\"",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.168797119,
      "end": 62054.169577477,
      "duration_ms": 0.7803580010659061,
      "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 489, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select date(on_earth) from (\n                    select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 100\n                ) where on_earth glob \"????-??-*\"",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.16982394,
      "end": 62054.173615595,
      "duration_ms": 3.7916549990768544,
      "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 489, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select date(state) from (\n                    select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 100\n                ) where state glob \"????-??-*\"",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.174151211,
      "end": 62054.175792197,
      "duration_ms": 1.6409859963459894,
      "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 489, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select date(_city_id) from (\n                    select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 100\n                ) where _city_id glob \"????-??-*\"",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.175989608,
      "end": 62054.17766124,
      "duration_ms": 1.6716320023988374,
      "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 489, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select date(_neighborhood) from (\n                    select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 100\n                ) where _neighborhood glob \"????-??-*\"",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.177936956,
      "end": 62054.180552806,
      "duration_ms": 2.6158499968005344,
      "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 489, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select date(tags) from (\n                    select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 100\n                ) where tags glob \"????-??-*\"",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.181194453,
      "end": 62054.190668585,
      "duration_ms": 9.47413199901348,
      "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 489, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select date(complex_array) from (\n                    select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 100\n                ) where complex_array glob \"????-??-*\"",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.190906888,
      "end": 62054.19154024,
      "duration_ms": 0.6333519995678216,
      "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 489, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select date(distinct_some_null) from (\n                    select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 100\n                ) where distinct_some_null glob \"????-??-*\"",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.191683731,
      "end": 62054.192230893,
      "duration_ms": 0.5471620024763979,
      "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 489, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "select date(n) from (\n                    select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 100\n                ) where n glob \"????-??-*\"",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.192469361,
      "end": 62054.192661064,
      "duration_ms": 0.19170300220139325,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 313, 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 145, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "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 ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.192813437,
      "end": 62054.193178924,
      "duration_ms": 0.365486994269304,
      "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    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select distinct json_type(pk)\n                from limited\n                where pk is not null and pk != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.193332495,
      "end": 62054.193787714,
      "duration_ms": 0.45521900028688833,
      "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    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": "malformed JSON",
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select distinct json_type(created)\n                from limited\n                where created is not null and created != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.193972109,
      "end": 62054.194319652,
      "duration_ms": 0.34754299849737436,
      "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    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select distinct json_type(planet_int)\n                from limited\n                where planet_int is not null and planet_int != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.19449081,
      "end": 62054.19481247,
      "duration_ms": 0.321660001645796,
      "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    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select distinct json_type(on_earth)\n                from limited\n                where on_earth is not null and on_earth != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.194939192,
      "end": 62054.195319473,
      "duration_ms": 0.38028100243536755,
      "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    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": "malformed JSON",
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select distinct json_type(state)\n                from limited\n                where state is not null and state != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.1954985,
      "end": 62054.195910094,
      "duration_ms": 0.4115940027986653,
      "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    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select distinct json_type(_city_id)\n                from limited\n                where _city_id is not null and _city_id != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.196133733,
      "end": 62054.196467869,
      "duration_ms": 0.33413599885534495,
      "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    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": "malformed JSON",
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select distinct json_type(_neighborhood)\n                from limited\n                where _neighborhood is not null and _neighborhood != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.196628384,
      "end": 62054.197018118,
      "duration_ms": 0.3897339993272908,
      "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    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select distinct json_type(tags)\n                from limited\n                where tags is not null and tags != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.197368179,
      "end": 62054.197781551,
      "duration_ms": 0.4133720067329705,
      "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 344, in suggest\n    for v in await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "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 tags is not null and tags != '' and json_array_length(tags) > 0 limit 100",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.19838081,
      "end": 62054.198840974,
      "duration_ms": 0.4601640030159615,
      "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    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select distinct json_type(complex_array)\n                from limited\n                where complex_array is not null and complex_array != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.199000013,
      "end": 62054.199413044,
      "duration_ms": 0.4130309971515089,
      "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 344, in suggest\n    for v in await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": null,
      "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 complex_array is not null and complex_array != '' and json_array_length(complex_array) > 0 limit 100",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.19961271,
      "end": 62054.199946003,
      "duration_ms": 0.33329299913020805,
      "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    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": "malformed JSON",
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select distinct json_type(distinct_some_null)\n                from limited\n                where distinct_some_null is not null and distinct_some_null != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.200073582,
      "end": 62054.200553194,
      "duration_ms": 0.47961200471036136,
      "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    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1104, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "error": "malformed JSON",
      "database": "fixtures",
      "sql": "with limited as (select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable ) limit 1000)\n                select distinct json_type(n)\n                from limited\n                where n is not null and n != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 62054.2014567,
      "end": 62054.201866697,
      "duration_ms": 0.4099970028619282,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.202214778,
      "end": 62054.202390496,
      "duration_ms": 0.1757179998094216,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1361, 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 93, in inner\n    await datasette.get_database().execute(\"select 3 * 5\")\n"
      ],
      "error": null,
      "database": "_memory",
      "sql": "select 3 * 5",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.202647236,
      "end": 62054.230192183,
      "duration_ms": 27.544946999114472,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1460, 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 50, in inner\n    await datasette.get_database().execute(\"select 3 * 5\")\n"
      ],
      "error": null,
      "database": "_memory",
      "sql": "select 3 * 5",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.232740874,
      "end": 62054.233358476,
      "duration_ms": 0.6176019960548729,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.233609863,
      "end": 62054.23377083,
      "duration_ms": 0.16096699982881546,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.233921107,
      "end": 62054.234281757,
      "duration_ms": 0.36065000313101336,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 62054.23477527,
      "end": 62054.235040277,
      "duration_ms": 0.2650070018717088,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1001, 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"
      ],
      "error": null,
      "database": "__INTERNAL__",
      "sql": "select 1 + 1",
      "params": null
    }
  ]
}