fixtures: roadside_attractions: 4 rows

address: The street address for the attraction
name: The name of the attraction

4 rows

descending

This data as json, testall, testnone, testresponse, CSV (advanced)

pk ▼	name	address	url	latitude	longitude
1	The Mystery Spot	465 Mystery Spot Road, Santa Cruz, CA 95065	https://www.mysteryspot.com/	37.0167	-122.0024
2	Winchester Mystery House	525 South Winchester Boulevard, San Jose, CA 95128	https://winchestermysteryhouse.com/	37.3184	-121.9511
3	Burlingame Museum of PEZ Memorabilia	214 California Drive, Burlingame, CA 94010		37.5793	-122.3442
4	Bigfoot Discovery Museum	5497 Highway 9, Felton, CA 95018	https://www.bigfootdiscoveryproject.com/	37.0414	-122.0725

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE roadside_attractions (
    pk integer primary key,
    name text,
    address text,
    url text,
    latitude real,
    longitude real
);

{ "request_duration_ms": 67.05098500242457, "sum_trace_duration_ms": 58.70477401185781, "num_traces": 50, "traces": [ { "type": "sql", "start": 252176.002144761, "end": 252176.002891952, "duration_ms": 0.7471909921150655, "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 518, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 528, 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": 252176.003179202, "end": 252176.003871787, "duration_ms": 0.6925849884282798, "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 518, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 533, 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": 252176.004161814, "end": 252176.004607677, "duration_ms": 0.44586299918591976, "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 518, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 533, 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": 252176.004735215, "end": 252176.00550214, "duration_ms": 0.766924989875406, "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 518, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 533, 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": 252176.005648083, "end": 252176.005958145, "duration_ms": 0.31006199424155056, "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 518, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 533, 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": 252176.006117297, "end": 252176.006422782, "duration_ms": 0.3054850094486028, "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 518, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 533, 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": 252176.006568416, "end": 252176.00695053, "duration_ms": 0.3821139980573207, "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 518, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 533, 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": 252176.007165377, "end": 252176.007874439, "duration_ms": 0.7090620056260377, "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 1660, 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": [ "roadside_attractions" ] }, { "type": "sql", "start": 252176.008119722, "end": 252176.00854724, "duration_ms": 0.4275179817341268, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1004, 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": 252176.008856072, "end": 252176.00923259, "duration_ms": 0.3765180008485913, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1004, 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": 252176.00939587, "end": 252176.009958469, "duration_ms": 0.5625989870168269, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1004, 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": 252176.010125045, "end": 252176.010986875, "duration_ms": 0.861829990753904, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1004, 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": 252176.011174175, "end": 252176.011534845, "duration_ms": 0.36067000473849475, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1004, 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": 252176.011971706, "end": 252176.012494347, "duration_ms": 0.5226409994065762, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1004, 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": 252176.015580873, "end": 252176.016102235, "duration_ms": 0.5213620024733245, "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, name, address, url, latitude, longitude from roadside_attractions order by pk limit 101", "params": {} }, { "type": "sql", "start": 252176.018758227, "end": 252176.021215727, "duration_ms": 2.4574999988544732, "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 638, 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": "roadside_attractions", "t": "table" } }, { "type": "sql", "start": 252176.018867189, "end": 252176.021553037, "duration_ms": 2.6858479832299054, "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", "roadside_attractions" ] }, { "type": "sql", "start": 252176.018938682, "end": 252176.022881562, "duration_ms": 3.9428799937013537, "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 721, 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", "roadside_attractions" ] }, { "type": "sql", "start": 252176.019026082, "end": 252176.023565294, "duration_ms": 4.539211979135871, "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 658, 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 638, 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": "roadside_attractions", "t": "view" } }, { "type": "sql", "start": 252176.021468175, "end": 252176.024616342, "duration_ms": 3.148167015751824, "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 648, 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": "roadside_attractions" } }, { "type": "sql", "start": 252176.020856365, "end": 252176.02483117, "duration_ms": 3.974805003963411, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 0", "params": [] }, { "type": "sql", "start": 252176.023489375, "end": 252176.025808027, "duration_ms": 2.318652026588097, "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", "roadside_attractions" ] }, { "type": "sql", "start": 252176.025723185, "end": 252176.030607251, "duration_ms": 4.8840660019777715, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 0", "params": [] }, { "type": "sql", "start": 252176.031086707, "end": 252176.03330359, "duration_ms": 2.2168830037117004, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "with limited as (select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) 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": 252176.033755688, "end": 252176.034861272, "duration_ms": 1.1055840004701167, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "with limited as (select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 1000)\n select name as value, count(*) as n from limited\n where value is not null\n group by value\n limit 31", "params": [] }, { "type": "sql", "start": 252176.035122173, "end": 252176.036331184, "duration_ms": 1.2090110103599727, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "with limited as (select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 1000)\n select address as value, count(*) as n from limited\n where value is not null\n group by value\n limit 31", "params": [] }, { "type": "sql", "start": 252176.036651727, "end": 252176.037998468, "duration_ms": 1.3467410171870142, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "with limited as (select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 1000)\n select url as value, count(*) as n from limited\n where value is not null\n group by value\n limit 31", "params": [] }, { "type": "sql", "start": 252176.038430251, "end": 252176.040219887, "duration_ms": 1.7896360077429563, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "with limited as (select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 1000)\n select latitude as value, count(*) as n from limited\n where value is not null\n group by value\n limit 31", "params": [] }, { "type": "sql", "start": 252176.040696375, "end": 252176.043926747, "duration_ms": 3.230371978133917, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "with limited as (select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 1000)\n select longitude as value, count(*) as n from limited\n where value is not null\n group by value\n limit 31", "params": [] }, { "type": "sql", "start": 252176.044072889, "end": 252176.044653294, "duration_ms": 0.5804050015285611, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 0", "params": [] }, { "type": "sql", "start": 252176.044817623, "end": 252176.04536976, "duration_ms": 0.5521369748748839, "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 1107, 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, name, address, url, latitude, longitude from roadside_attractions ) limit 100\n ) where pk glob \"????-??-*\"", "params": [] }, { "type": "sql", "start": 252176.045549796, "end": 252176.046388064, "duration_ms": 0.8382679952774197, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "select date(name) from (\n select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 100\n ) where name glob \"????-??-*\"", "params": [] }, { "type": "sql", "start": 252176.046699535, "end": 252176.047209796, "duration_ms": 0.5102609866298735, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "select date(address) from (\n select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 100\n ) where address glob \"????-??-*\"", "params": [] }, { "type": "sql", "start": 252176.047959455, "end": 252176.048747833, "duration_ms": 0.7883780053816736, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "select date(url) from (\n select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 100\n ) where url glob \"????-??-*\"", "params": [] }, { "type": "sql", "start": 252176.04930054, "end": 252176.049929406, "duration_ms": 0.6288659933488816, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "select date(latitude) from (\n select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 100\n ) where latitude glob \"????-??-*\"", "params": [] }, { "type": "sql", "start": 252176.050143385, "end": 252176.050738887, "duration_ms": 0.5955020023975521, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "select date(longitude) from (\n select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 100\n ) where longitude glob \"????-??-*\"", "params": [] }, { "type": "sql", "start": 252176.050896551, "end": 252176.051186739, "duration_ms": 0.2901880070567131, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 0", "params": [] }, { "type": "sql", "start": 252176.051363826, "end": 252176.052041224, "duration_ms": 0.6773979985155165, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "with limited as (select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 1000)\n select distinct json_type(pk)\n from limited\n where pk is not null and pk != ''", "params": [] }, { "type": "sql", "start": 252176.052264355, "end": 252176.052792661, "duration_ms": 0.5283060017973185, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": "malformed JSON", "database": "fixtures", "sql": "with limited as (select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 1000)\n select distinct json_type(name)\n from limited\n where name is not null and name != ''", "params": [] }, { "type": "sql", "start": 252176.052978472, "end": 252176.053507089, "duration_ms": 0.5286170053295791, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": "malformed JSON", "database": "fixtures", "sql": "with limited as (select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 1000)\n select distinct json_type(address)\n from limited\n where address is not null and address != ''", "params": [] }, { "type": "sql", "start": 252176.05366771, "end": 252176.054402442, "duration_ms": 0.7347320206463337, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": "malformed JSON", "database": "fixtures", "sql": "with limited as (select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 1000)\n select distinct json_type(url)\n from limited\n where url is not null and url != ''", "params": [] }, { "type": "sql", "start": 252176.054563912, "end": 252176.055448483, "duration_ms": 0.8845709962770343, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "with limited as (select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 1000)\n select distinct json_type(latitude)\n from limited\n where latitude is not null and latitude != ''", "params": [] }, { "type": "sql", "start": 252176.055598863, "end": 252176.05612612, "duration_ms": 0.5272570124361664, "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 1107, in execute\n return await self.databases[db_name].execute(\n" ], "error": null, "database": "fixtures", "sql": "with limited as (select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 1000)\n select distinct json_type(longitude)\n from limited\n where longitude is not null and longitude != ''", "params": [] }, { "type": "sql", "start": 252176.057039898, "end": 252176.057587259, "duration_ms": 0.5473610071931034, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1004, 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": 252176.057854605, "end": 252176.058341874, "duration_ms": 0.4872690187767148, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1364, 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": 252176.058649188, "end": 252176.058940605, "duration_ms": 0.29141700360924006, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1463, 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": 252176.059818221, "end": 252176.060366292, "duration_ms": 0.5480709951370955, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1004, 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": 252176.060567411, "end": 252176.061086994, "duration_ms": 0.5195830017328262, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1004, 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": 252176.061313213, "end": 252176.061602541, "duration_ms": 0.2893280179705471, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1004, 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": 252176.062117519, "end": 252176.062632596, "duration_ms": 0.5150770011823624, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1004, 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 } ] }