fixtures: roadside_attractions: 4 rows

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

name: The name of the attraction
address: The street address for 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": 52.333208004711196, "sum_trace_duration_ms": 19.353938012500294, "num_traces": 43, "traces": [ { "type": "sql", "start": 119440.740545864, "end": 119440.741044785, "duration_ms": 0.49892099923454225, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 671, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 452, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 461, 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": 119440.74126272, "end": 119440.741485344, "duration_ms": 0.22262400307226926, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 671, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 452, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 466, 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": 119440.741662363, "end": 119440.741893624, "duration_ms": 0.23126100131776184, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 671, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 452, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 466, 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": 119440.74206646, "end": 119440.742316155, "duration_ms": 0.24969498917926103, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 671, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 452, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 466, 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": 119440.742485862, "end": 119440.742674257, "duration_ms": 0.18839498807210475, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 671, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 452, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 466, 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": 119440.742819878, "end": 119440.743090303, "duration_ms": 0.2704250073293224, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 671, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 452, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 466, 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": 119440.743266204, "end": 119440.743448045, "duration_ms": 0.18184100918006152, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 671, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 452, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 466, 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": 119440.74367395, "end": 119440.744023497, "duration_ms": 0.34954700095113367, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 702, in table_view_traced\n resolved = await datasette.resolve_table(request)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1512, 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 353, 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": 119440.744292879, "end": 119440.744470494, "duration_ms": 0.17761500203050673, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 874, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, 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": 119440.74467875, "end": 119440.744980244, "duration_ms": 0.3014940011780709, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 874, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, 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": 119440.745225247, "end": 119440.745453346, "duration_ms": 0.22809900110587478, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 874, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, 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": 119440.745683593, "end": 119440.745906445, "duration_ms": 0.22285198792815208, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 874, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, 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": 119440.746172796, "end": 119440.746358349, "duration_ms": 0.1855529990280047, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 874, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, 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": 119440.746548693, "end": 119440.74672234, "duration_ms": 0.17364700033795089, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 874, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, 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": 119440.748689958, "end": 119440.749025958, "duration_ms": 0.33599999733269215, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 673, 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 726, 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 1101, 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": 119440.75087663, "end": 119440.752183678, "duration_ms": 1.3070480054011568, "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 1439, 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 479, 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": 119440.750917392, "end": 119440.75263307, "duration_ms": 1.7156780086224899, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1442, 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 499, 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 479, 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": 119440.752549171, "end": 119440.75369739, "duration_ms": 1.1482190020615235, "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 1439, 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 489, 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": 119440.751445169, "end": 119440.753887133, "duration_ms": 2.441964010358788, "traceback": [ " File \"plugins/my_plugin.py\", line 166, 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 967, 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": 119440.754073621, "end": 119440.75485288, "duration_ms": 0.7792589894961566, "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 967, 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": 119440.755113293, "end": 119440.756225205, "duration_ms": 1.1119120026705787, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\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 967, 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": 119440.756425849, "end": 119440.757447839, "duration_ms": 1.0219899995718151, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\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 967, 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": 119440.757782834, "end": 119440.758151783, "duration_ms": 0.36894899676553905, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\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 967, 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": 119440.758319687, "end": 119440.758636711, "duration_ms": 0.3170240088365972, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\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 967, 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": 119440.758847322, "end": 119440.759439582, "duration_ms": 0.5922600103076547, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\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 967, 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": 119440.759606697, "end": 119440.759902167, "duration_ms": 0.2954700030386448, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\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 967, 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": 119440.760062699, "end": 119440.760356446, "duration_ms": 0.29374699806794524, "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 967, 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": 119440.760575747, "end": 119440.760862095, "duration_ms": 0.286348004010506, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\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 967, 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": 119440.761030158, "end": 119440.761302004, "duration_ms": 0.2718460018513724, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\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 967, 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": 119440.761470052, "end": 119440.761789375, "duration_ms": 0.31932299316395074, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\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 967, 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": 119440.761981396, "end": 119440.7622762, "duration_ms": 0.2948039909824729, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\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 967, 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": 119440.76248668, "end": 119440.762782346, "duration_ms": 0.29566600278485566, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\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 967, 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": 119440.762998511, "end": 119440.763270421, "duration_ms": 0.2719100011745468, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\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 967, 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": 119440.763421662, "end": 119440.763614335, "duration_ms": 0.1926729892147705, "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 967, 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": 119440.763780423, "end": 119440.76411351, "duration_ms": 0.33308699494227767, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 319, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 967, 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": 119440.76934279, "end": 119440.769717216, "duration_ms": 0.3744260029634461, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 319, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 967, 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": 119440.76994772, "end": 119440.770354203, "duration_ms": 0.4064830136485398, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 83, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 319, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 967, 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": 119440.771315748, "end": 119440.771548542, "duration_ms": 0.2327940019313246, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 874, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, 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": 119440.771798321, "end": 119440.771960814, "duration_ms": 0.16249300097115338, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1229, 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 111, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin.py\", line 89, in inner\n await datasette.get_database().execute(\"select 3 * 5\")\n" ], "database": "_memory", "sql": "select 3 * 5", "params": null }, { "type": "sql", "start": 119440.77234646, "end": 119440.772523585, "duration_ms": 0.17712499538902193, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1316, in _asset_urls\n hook = await await_me_maybe(hook)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin.py\", line 46, in inner\n await datasette.get_database().execute(\"select 3 * 5\")\n" ], "database": "_memory", "sql": "select 3 * 5", "params": null }, { "type": "sql", "start": 119440.773734868, "end": 119440.773925177, "duration_ms": 0.19030900148209184, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 874, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, 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": 119440.774161168, "end": 119440.774328683, "duration_ms": 0.16751499788369983, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 874, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, 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": 119440.774698785, "end": 119440.774864432, "duration_ms": 0.16564699762966484, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 874, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, 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 } ] }