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": 30.07361300115008, "sum_trace_duration_ms": 21.648279016517336, "num_traces": 46, "traces": [ { "type": "sql", "start": 23722.01051002, "end": 23722.0108816, "duration_ms": 0.371579997590743, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 759, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 504, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 514, in _refresh_schemas\n for row in await internal_db.execute(\n" ], "database": "__INTERNAL__", "sql": "select database_name, schema_version from catalog_databases", "params": null }, { "type": "sql", "start": 23722.011113021, "end": 23722.011402861, "duration_ms": 0.2898400016420055, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 759, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 504, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 519, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "_memory", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 23722.01159831, "end": 23722.011793337, "duration_ms": 0.1950269979715813, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 759, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 504, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 519, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "fixtures", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 23722.01204677, "end": 23722.012218448, "duration_ms": 0.1716779988782946, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 759, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 504, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 519, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "fixtures2", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 23722.012344305, "end": 23722.012594115, "duration_ms": 0.24981000024126843, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 759, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 504, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 519, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "extra_database", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 23722.012738545, "end": 23722.012900772, "duration_ms": 0.16222699923673645, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 759, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 504, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 519, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "counters", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 23722.01301594, "end": 23722.013218291, "duration_ms": 0.20235099873389117, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 759, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 504, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 519, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "ephemeral", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 23722.013423955, "end": 23722.01364182, "duration_ms": 0.21786500292364508, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 790, in table_view_traced\n resolved = await datasette.resolve_table(request)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1631, 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 406, in table_exists\n results = await self.execute(\n" ], "database": "fixtures", "sql": "select 1 from sqlite_master where type='table' and name=?", "params": [ "roadside_attractions" ] }, { "type": "sql", "start": 23722.013907384, "end": 23722.014121871, "duration_ms": 0.21448700135806575, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 988, 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" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 23722.014334189, "end": 23722.014578931, "duration_ms": 0.2447420010867063, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 988, 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" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 23722.014769656, "end": 23722.01501091, "duration_ms": 0.24125399795593694, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 988, 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" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 23722.015214065, "end": 23722.015399245, "duration_ms": 0.1851800006988924, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 988, 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" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 23722.015571243, "end": 23722.015749574, "duration_ms": 0.17833099991548806, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 988, 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" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 23722.015913724, "end": 23722.01611498, "duration_ms": 0.20125599985476583, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 988, 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" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 23722.01767271, "end": 23722.017959377, "duration_ms": 0.2866670001822058, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 761, 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 814, 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 1199, in table_view_data\n results = await db.execute(sql, params, truncate=True, **extra_args)\n" ], "database": "fixtures", "sql": "select pk, name, address, url, latitude, longitude from roadside_attractions order by pk limit 101", "params": {} }, { "type": "sql", "start": 23722.019292895, "end": 23722.020811059, "duration_ms": 1.5181640010268893, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1554, 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 551, 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 531, in get_table_definition\n await self.execute(\n" ], "database": "fixtures", "sql": "select sql from sqlite_master where name = :n and type=:t", "params": { "n": "roadside_attractions", "t": "view" } }, { "type": "sql", "start": 23722.019852316, "end": 23722.020988997, "duration_ms": 1.1366809994797222, "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 1464, 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" ], "database": "__INTERNAL__", "sql": "SELECT\n column_name,\n value\n FROM datasette_metadata_column_entries\n WHERE database_name = ?\n AND resource_name = ?\n AND key = 'description'", "params": [ "fixtures", "roadside_attractions" ] }, { "type": "sql", "start": 23722.019231345, "end": 23722.021919586, "duration_ms": 2.6882410020334646, "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 1551, 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 531, in get_table_definition\n await self.execute(\n" ], "database": "fixtures", "sql": "select sql from sqlite_master where name = :n and type=:t", "params": { "n": "roadside_attractions", "t": "table" } }, { "type": "sql", "start": 23722.019956948, "end": 23722.022185899, "duration_ms": 2.228951001598034, "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 1495, 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 706, in get_resource_metadata\n rows = await self.get_internal_database().execute(\n" ], "database": "__INTERNAL__", "sql": "SELECT\n key,\n value\n FROM datasette_metadata_resource_entries\n WHERE database_name = ?\n AND resource_name = ?", "params": [ "fixtures", "roadside_attractions" ] }, { "type": "sql", "start": 23722.020710988, "end": 23722.0223749, "duration_ms": 1.663912000367418, "traceback": [ " File \"plugins/my_plugin.py\", line 167, 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 143, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 0", "params": [] }, { "type": "sql", "start": 23722.022129119, "end": 23722.022923631, "duration_ms": 0.7945120014483109, "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 1551, 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 541, in get_table_definition\n await self.execute(\n" ], "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": 23722.022315357, "end": 23722.023107315, "duration_ms": 0.791957998444559, "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 1497, in extra_metadata\n rows = await datasette.get_internal_database().execute(\n" ], "database": "__INTERNAL__", "sql": "SELECT\n column_name,\n value\n FROM datasette_metadata_column_entries\n WHERE database_name = ?\n AND resource_name = ?\n AND key = 'description'", "params": [ "fixtures", "roadside_attractions" ] }, { "type": "sql", "start": 23722.022513382, "end": 23722.023230236, "duration_ms": 0.7168539996200707, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 165, 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 143, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 0", "params": [] }, { "type": "sql", "start": 23722.023392644, "end": 23722.023961664, "duration_ms": 0.5690199977834709, "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 183, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select pk as value, count(*) as n from (\n select pk, name, address, url, latitude, longitude from roadside_attractions \n ) where value is not null\n group by value\n limit 31", "params": [] }, { "type": "sql", "start": 23722.024165373, "end": 23722.025323212, "duration_ms": 1.1578390003705863, "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 183, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select name as value, count(*) as n from (\n select pk, name, address, url, latitude, longitude from roadside_attractions \n ) where value is not null\n group by value\n limit 31", "params": [] }, { "type": "sql", "start": 23722.025495488, "end": 23722.025796761, "duration_ms": 0.3012730012414977, "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 183, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select address as value, count(*) as n from (\n select pk, name, address, url, latitude, longitude from roadside_attractions \n ) where value is not null\n group by value\n limit 31", "params": [] }, { "type": "sql", "start": 23722.025964308, "end": 23722.026237229, "duration_ms": 0.2729210027609952, "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 183, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select url as value, count(*) as n from (\n select pk, name, address, url, latitude, longitude from roadside_attractions \n ) where value is not null\n group by value\n limit 31", "params": [] }, { "type": "sql", "start": 23722.026391973, "end": 23722.02666922, "duration_ms": 0.2772469997580629, "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 183, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select latitude as value, count(*) as n from (\n select pk, name, address, url, latitude, longitude from roadside_attractions \n ) where value is not null\n group by value\n limit 31", "params": [] }, { "type": "sql", "start": 23722.026823431, "end": 23722.027103521, "duration_ms": 0.2800900001602713, "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 183, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select longitude as value, count(*) as n from (\n select pk, name, address, url, latitude, longitude from roadside_attractions \n ) where value is not null\n group by value\n limit 31", "params": [] }, { "type": "sql", "start": 23722.027226655, "end": 23722.02746787, "duration_ms": 0.24121500246110372, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 464, 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 143, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 0", "params": [] }, { "type": "sql", "start": 23722.027664364, "end": 23722.027922973, "duration_ms": 0.2586090013210196, "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 479, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(pk) from (\n select pk, name, address, url, latitude, longitude from roadside_attractions \n ) where pk glob \"????-??-*\" limit 100;", "params": [] }, { "type": "sql", "start": 23722.028071692, "end": 23722.028299026, "duration_ms": 0.22733399964636192, "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 479, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(name) from (\n select pk, name, address, url, latitude, longitude from roadside_attractions \n ) where name glob \"????-??-*\" limit 100;", "params": [] }, { "type": "sql", "start": 23722.028486469, "end": 23722.028713329, "duration_ms": 0.22686000011162832, "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 479, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(address) from (\n select pk, name, address, url, latitude, longitude from roadside_attractions \n ) where address glob \"????-??-*\" limit 100;", "params": [] }, { "type": "sql", "start": 23722.02886023, "end": 23722.029099814, "duration_ms": 0.23958400197443552, "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 479, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(url) from (\n select pk, name, address, url, latitude, longitude from roadside_attractions \n ) where url glob \"????-??-*\" limit 100;", "params": [] }, { "type": "sql", "start": 23722.029254299, "end": 23722.02948302, "duration_ms": 0.22872100089443848, "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 479, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(latitude) from (\n select pk, name, address, url, latitude, longitude from roadside_attractions \n ) where latitude glob \"????-??-*\" limit 100;", "params": [] }, { "type": "sql", "start": 23722.029622523, "end": 23722.029867432, "duration_ms": 0.24490899886586703, "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 479, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(longitude) from (\n select pk, name, address, url, latitude, longitude from roadside_attractions \n ) where longitude glob \"????-??-*\" limit 100;", "params": [] }, { "type": "sql", "start": 23722.030012453, "end": 23722.030234041, "duration_ms": 0.22158800129545853, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 308, 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 143, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 0", "params": [] }, { "type": "sql", "start": 23722.030426796, "end": 23722.030695325, "duration_ms": 0.2685290019144304, "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 323, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct json_type(pk)\n from (select pk, name, address, url, latitude, longitude from roadside_attractions )\n where pk is not null and pk != ''", "params": [] }, { "type": "sql", "start": 23722.031891261, "end": 23722.032181066, "duration_ms": 0.2898050006479025, "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 323, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct json_type(latitude)\n from (select pk, name, address, url, latitude, longitude from roadside_attractions )\n where latitude is not null and latitude != ''", "params": [] }, { "type": "sql", "start": 23722.032346689, "end": 23722.032652821, "duration_ms": 0.3061319985135924, "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 323, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1091, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct json_type(longitude)\n from (select pk, name, address, url, latitude, longitude from roadside_attractions )\n where longitude is not null and longitude != ''", "params": [] }, { "type": "sql", "start": 23722.033573398, "end": 23722.03377419, "duration_ms": 0.20079200112377293, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 988, 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" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 23722.034051395, "end": 23722.034211044, "duration_ms": 0.159649000124773, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1349, 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 90, in inner\n await datasette.get_database().execute(\"select 3 * 5\")\n" ], "database": "_memory", "sql": "select 3 * 5", "params": null }, { "type": "sql", "start": 23722.034517426, "end": 23722.034721994, "duration_ms": 0.2045680012088269, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1436, 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 47, in inner\n await datasette.get_database().execute(\"select 3 * 5\")\n" ], "database": "_memory", "sql": "select 3 * 5", "params": null }, { "type": "sql", "start": 23722.035598333, "end": 23722.035784635, "duration_ms": 0.18630200065672398, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 988, 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" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 23722.036006691, "end": 23722.036167435, "duration_ms": 0.16074399900389835, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 988, 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" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 23722.036486725, "end": 23722.036659705, "duration_ms": 0.17298000238952227, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 988, 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" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null } ] }