{
"request_duration_ms": 2236.1202770000546,
"sum_trace_duration_ms": 2259.794410000268,
"num_traces": 16,
"traces": [
{
"type": "sql",
"start": 652.228109467,
"end": 652.228531939,
"duration_ms": 0.42247200008205255,
"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": 652.252725041,
"end": 652.253138023,
"duration_ms": 0.41298200005712715,
"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": 652.253350645,
"end": 652.253702324,
"duration_ms": 0.3516790000048786,
"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": 652.253966787,
"end": 652.254201736,
"duration_ms": 0.2349490000597143,
"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": 652.254593172,
"end": 652.254965142,
"duration_ms": 0.3719699999464865,
"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": 652.254644235,
"end": 652.257081531,
"duration_ms": 2.4372960000391686,
"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": 652.266245938,
"end": 652.266577607,
"duration_ms": 0.33166900004744093,
"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 date desc limit 3",
"params": {}
},
{
"type": "sql",
"start": 652.273742468,
"end": 652.274459244,
"duration_ms": 0.7167759999902046,
"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": 652.273813431,
"end": 652.279315593,
"duration_ms": 5.502161999970667,
"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": 652.273778793,
"end": 652.27972871,
"duration_ms": 5.94991699995262,
"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": 652.27923396,
"end": 652.281454925,
"duration_ms": 2.2209649999922476,
"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": 652.281734174,
"end": 652.337674562,
"duration_ms": 55.9403879999536,
"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": 652.338391649,
"end": 652.34515908,
"duration_ms": 6.767431000071156,
"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": 652.273558518,
"end": 653.295361628,
"duration_ms": 1021.8031100000644,
"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": 653.297867427,
"end": 653.898247037,
"duration_ms": 600.3796100000045,
"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": 653.899637225,
"end": 654.455588259,
"duration_ms": 555.9510340000315,
"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": []
}
]
}