ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

844 rows where fips = 53061 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

date (date) >3 ✖

state 1

fips 1

  • 53061 · 844 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502673 2502673 2022-05-13 Snohomish Washington 53061 159246 1145
2499415 2499415 2022-05-12 Snohomish Washington 53061 158407 1145

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);
{
  "request_duration_ms": 75.6431790014176,
  "sum_trace_duration_ms": 165.8740719922207,
  "num_traces": 33,
  "traces": [
    {
      "type": "sql",
      "start": 9424.323050783,
      "end": 9424.323857601,
      "duration_ms": 0.8068180013651727,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 364, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 374, in _refresh_schemas\n    for row in await internal_db.execute(\n"
      ],
      "database": "_internal",
      "sql": "select database_name, schema_version from databases",
      "params": null
    },
    {
      "type": "sql",
      "start": 9424.324601312,
      "end": 9424.325188159,
      "duration_ms": 0.5868469997949433,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 364, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 379, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "_internal",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 9424.325389036,
      "end": 9424.325648438,
      "duration_ms": 0.25940200066543184,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 364, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 379, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "covid",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 9424.325805084,
      "end": 9424.326140047,
      "duration_ms": 0.33496300056867767,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 364, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 379, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "la-times",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 9424.326864719,
      "end": 9424.327413863,
      "duration_ms": 0.5491440006153425,
      "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/datasette/database.py\", line 476, 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 456, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "covid",
      "sql": "select sql from sqlite_master where name = :n and type=:t",
      "params": {
        "n": "ny_times_us_counties",
        "t": "view"
      }
    },
    {
      "type": "sql",
      "start": 9424.326960066,
      "end": 9424.327622492,
      "duration_ms": 0.6624259985983372,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/base_events.py\", line 1909, in _run_once\n    handle._run()\n",
        "  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/datasette/database.py\", line 336, in table_exists\n    results = await self.execute(\n"
      ],
      "database": "covid",
      "sql": "select 1 from sqlite_master where type='table' and name=?",
      "params": [
        "ny_times_us_counties"
      ]
    },
    {
      "type": "sql",
      "start": 9424.32970252,
      "end": 9424.334738149,
      "duration_ms": 5.035628999394248,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 361, in get\n    response_or_template_contexts = await self.data(request, **data_kwargs)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 158, in data\n    return await self._data_traced(request, default_labels, _next, _size)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 479, in _data_traced\n    results = await db.execute(sql, params, truncate=True, **extra_args)\n"
      ],
      "database": "covid",
      "sql": "select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 order by date desc limit 3",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.334961421,
      "end": 9424.335398249,
      "duration_ms": 0.43682800060196314,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 361, in get\n    response_or_template_contexts = await self.data(request, **data_kwargs)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 158, in data\n    return await self._data_traced(request, default_labels, _next, _size)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 499, in _data_traced\n    count_rows = list(await db.execute(count_sql, from_sql_params))\n"
      ],
      "database": "covid",
      "sql": "select count(*) from ny_times_us_counties where \"fips\" = :p0",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.336085719,
      "end": 9424.342213936,
      "duration_ms": 6.128216999059077,
      "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/datasette/facets.py\", line 231, in facet_results\n    facet_rows_results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select state as value, count(*) as count from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                )\n                where state is not null\n                group by state order by count desc, value limit 4",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.336349437,
      "end": 9424.342568982,
      "duration_ms": 6.219544999112259,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 460, 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 139, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select * from (select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 ) limit 0",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.33637906,
      "end": 9424.342807447,
      "duration_ms": 6.4283869996870635,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 304, 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 139, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select * from (select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 ) limit 0",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.336317662,
      "end": 9424.343157571,
      "duration_ms": 6.839908999609179,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 161, 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 139, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select * from (select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 ) limit 0",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.34277053,
      "end": 9424.344232216,
      "duration_ms": 1.461686000766349,
      "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/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select date(rowid) from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                ) where rowid glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.343683974,
      "end": 9424.351031244,
      "duration_ms": 7.34726999871782,
      "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/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select rowid as value, count(*) as n from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                ) where value is not null\n                group by value\n                limit 4",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.343096683,
      "end": 9424.351497555,
      "duration_ms": 8.40087200049311,
      "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/datasette/facets.py\", line 319, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select distinct json_type(rowid)\n                from (select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 )\n                where rowid is not null and rowid != ''",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.344501585,
      "end": 9424.351805984,
      "duration_ms": 7.3043990014411975,
      "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/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select date(county) from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                ) where county glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.336222538,
      "end": 9424.352936411,
      "duration_ms": 16.713872999389423,
      "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/datasette/facets.py\", line 523, in facet_results\n    facet_rows_results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select date(date) as value, count(*) as count from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                )\n                where date(date) is not null\n                group by date(date) order by count desc, value limit 4",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.345188555,
      "end": 9424.354171893,
      "duration_ms": 8.983337998870411,
      "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/datasette/facets.py\", line 231, in facet_results\n    facet_rows_results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select county as value, count(*) as count from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                )\n                where county is not null\n                group by county order by count desc, value limit 4",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.355480453,
      "end": 9424.356420748,
      "duration_ms": 0.9402949999639532,
      "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/datasette/facets.py\", line 231, in facet_results\n    facet_rows_results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select fips as value, count(*) as count from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                )\n                where fips is not null\n                group by fips order by count desc, value limit 4",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.355546852,
      "end": 9424.360323088,
      "duration_ms": 4.776235999088385,
      "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/datasette/facets.py\", line 319, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select distinct json_type(fips)\n                from (select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 )\n                where fips is not null and fips != ''",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.351948441,
      "end": 9424.360650554,
      "duration_ms": 8.702112998435041,
      "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/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select date(state) from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                ) where state glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.351415397,
      "end": 9424.364300545,
      "duration_ms": 12.885147998531465,
      "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/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select date as value, count(*) as n from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                ) where value is not null\n                group by value\n                limit 4",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.360785677,
      "end": 9424.365524142,
      "duration_ms": 4.738465000627912,
      "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/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select date(fips) from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                ) where fips glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.36052473,
      "end": 9424.367932452,
      "duration_ms": 7.407721999697969,
      "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/datasette/facets.py\", line 319, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select distinct json_type(cases)\n                from (select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 )\n                where cases is not null and cases != ''",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.365779657,
      "end": 9424.371047406,
      "duration_ms": 5.267749000267941,
      "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/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select date(cases) from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                ) where cases glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.371330776,
      "end": 9424.376420686,
      "duration_ms": 5.089909998787334,
      "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/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select date(deaths) from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                ) where deaths glob \"????-??-*\" limit 100;",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.368146444,
      "end": 9424.377027831,
      "duration_ms": 8.881387000656105,
      "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/datasette/facets.py\", line 319, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select distinct json_type(deaths)\n                from (select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 )\n                where deaths is not null and deaths != ''",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.364535692,
      "end": 9424.381448252,
      "duration_ms": 16.912559998672805,
      "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/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select cases as value, count(*) as n from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                ) where value is not null\n                group by value\n                limit 4",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.381694302,
      "end": 9424.386337479,
      "duration_ms": 4.643177000616561,
      "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/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 775, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "covid",
      "sql": "select deaths as value, count(*) as n from (\n                    select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties where \"fips\" = :p0 \n                ) where value is not null\n                group by value\n                limit 4",
      "params": {
        "p0": "53061"
      }
    },
    {
      "type": "sql",
      "start": 9424.389471578,
      "end": 9424.389774126,
      "duration_ms": 0.3025480000360403,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 779, in extra_template\n    \"view_definition\": await db.get_view_definition(table_name),\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 476, 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 456, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "covid",
      "sql": "select sql from sqlite_master where name = :n and type=:t",
      "params": {
        "n": "ny_times_us_counties",
        "t": "view"
      }
    },
    {
      "type": "sql",
      "start": 9424.38997871,
      "end": 9424.390280781,
      "duration_ms": 0.3020709991687909,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 463, in get\n    extras = await extras\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 780, in extra_template\n    \"table_definition\": await db.get_table_definition(table_name),\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 456, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "covid",
      "sql": "select sql from sqlite_master where name = :n and type=:t",
      "params": {
        "n": "ny_times_us_counties",
        "t": "table"
      }
    },
    {
      "type": "sql",
      "start": 9424.390478369,
      "end": 9424.390782206,
      "duration_ms": 0.30383699959202204,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 463, in get\n    extras = await extras\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 780, in extra_template\n    \"table_definition\": await db.get_table_definition(table_name),\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 466, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "covid",
      "sql": "select sql from sqlite_master where tbl_name = :n and type='index' and sql is not null",
      "params": {
        "n": "ny_times_us_counties"
      }
    },
    {
      "type": "sql",
      "start": 9424.392828718,
      "end": 9424.393050019,
      "duration_ms": 0.22130099932837766,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette_graphql/__init__.py\", line 214, in inner\n    db_schema = await schema_for_database_via_cache(datasette, database=database)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette_graphql/utils.py\", line 78, in schema_for_database_via_cache\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "covid",
      "sql": "PRAGMA schema_version",
      "params": null
    }
  ]
}