{
"request_duration_ms": 2362.382566992892,
"sum_trace_duration_ms": 2446.129105926957,
"num_traces": 16,
"traces": [
{
"type": "sql",
"start": 132329.766686707,
"end": 132329.767053995,
"duration_ms": 0.36728798295371234,
"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": 132329.767314622,
"end": 132329.767548783,
"duration_ms": 0.23416100884787738,
"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": 132329.767696078,
"end": 132329.767866719,
"duration_ms": 0.17064099665731192,
"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": 132329.767997041,
"end": 132329.768157599,
"duration_ms": 0.16055800369940698,
"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": 132329.768491549,
"end": 132329.769303652,
"duration_ms": 0.8121029823087156,
"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": 132329.768540076,
"end": 132329.769460358,
"duration_ms": 0.9202819783240557,
"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": 132329.771731801,
"end": 132329.772131391,
"duration_ms": 0.3995899751316756,
"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": 132329.77292443,
"end": 132329.77370963,
"duration_ms": 0.7852000126149505,
"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": 132329.77295589,
"end": 132329.77439908,
"duration_ms": 1.4431900053750724,
"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": 132329.77298592,
"end": 132329.774742595,
"duration_ms": 1.7566750175319612,
"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": 132329.774018705,
"end": 132329.797704772,
"duration_ms": 23.686066997470334,
"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": 132329.849428279,
"end": 132329.857514646,
"duration_ms": 8.086366986390203,
"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": 132329.798354667,
"end": 132329.859452385,
"duration_ms": 61.09771798946895,
"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": 132329.772764026,
"end": 132330.864063524,
"duration_ms": 1091.299497988075,
"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": 132330.865603174,
"end": 132331.57037056,
"duration_ms": 704.7673859924544,
"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": 132331.572125238,
"end": 132332.12226762,
"duration_ms": 550.1423820096534,
"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": []
}
]
}