{
"request_duration_ms": 2211.1594649995823,
"sum_trace_duration_ms": 2317.801631000293,
"num_traces": 16,
"traces": [
{
"type": "sql",
"start": 5120.574776995,
"end": 5120.576459091,
"duration_ms": 1.6820959999677143,
"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": 5120.576701832,
"end": 5120.576976257,
"duration_ms": 0.2744249995885184,
"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": 5120.57717582,
"end": 5120.577387996,
"duration_ms": 0.2121759998772177,
"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": 5120.577546611,
"end": 5120.577705499,
"duration_ms": 0.15888800044194795,
"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": 5120.578076523,
"end": 5120.578353387,
"duration_ms": 0.2768639997157152,
"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": 5120.578031639,
"end": 5120.578631417,
"duration_ms": 0.5997779999233899,
"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": 5120.580727977,
"end": 5120.581140264,
"duration_ms": 0.4122870004721335,
"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 order by county limit 3",
"params": {}
},
{
"type": "sql",
"start": 5120.582284015,
"end": 5120.58294106,
"duration_ms": 0.657044999570644,
"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 ) limit 0",
"params": []
},
{
"type": "sql",
"start": 5120.582395038,
"end": 5120.583333192,
"duration_ms": 0.9381540003232658,
"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 ) limit 0",
"params": []
},
{
"type": "sql",
"start": 5120.582357446,
"end": 5120.583570165,
"duration_ms": 1.2127190002502175,
"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 ) limit 0",
"params": []
},
{
"type": "sql",
"start": 5120.583276448,
"end": 5120.59450384,
"duration_ms": 11.227391999454994,
"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 \n ) where value is not null\n group by value\n limit 4",
"params": []
},
{
"type": "sql",
"start": 5120.594884563,
"end": 5120.649361935,
"duration_ms": 54.477372000292235,
"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 \n ) where value is not null\n group by value\n limit 4",
"params": []
},
{
"type": "sql",
"start": 5120.645385463,
"end": 5120.697617896,
"duration_ms": 52.23243300042668,
"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(date) from (\n select rowid, date, county, state, fips, cases, deaths from ny_times_us_counties \n ) where date glob \"????-??-*\" limit 100;",
"params": []
},
{
"type": "sql",
"start": 5120.58198312,
"end": 5121.658566938,
"duration_ms": 1076.583818000472,
"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 \n )\n where state is not null\n group by state order by count desc, value limit 4",
"params": []
},
{
"type": "sql",
"start": 5121.659830588,
"end": 5122.264143846,
"duration_ms": 604.31325799982,
"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 \n )\n where county is not null\n group by county order by count desc, value limit 4",
"params": []
},
{
"type": "sql",
"start": 5122.265667188,
"end": 5122.778210114,
"duration_ms": 512.5429259996963,
"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 \n )\n where fips is not null\n group by fips order by count desc, value limit 4",
"params": []
}
]
}