fixtures: roadside_attractions: 4 rows sorted by longitude

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 sorted by longitude

descending

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

pk	name	address	url	latitude	longitude ▼
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
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

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": 71.42027698864695, "sum_trace_duration_ms": 16.93905398133211, "num_traces": 43, "traces": [ { "type": "sql", "start": 90966.449622313, "end": 90966.450036209, "duration_ms": 0.41389600664842874, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 482, 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": 90966.450264699, "end": 90966.450482791, "duration_ms": 0.21809199824929237, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 90966.450635385, "end": 90966.450855229, "duration_ms": 0.21984400518704206, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 90966.451004274, "end": 90966.451245538, "duration_ms": 0.24126400239765644, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 90966.451421843, "end": 90966.451609713, "duration_ms": 0.18786999862641096, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 90966.45181302, "end": 90966.45203405, "duration_ms": 0.22103000083006918, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 90966.452179561, "end": 90966.452435017, "duration_ms": 0.25545599055476487, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 90966.452661631, "end": 90966.452969804, "duration_ms": 0.30817299557384104, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 776, in table_view_traced\n resolved = await datasette.resolve_table(request)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1564, 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 405, 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": 90966.453184919, "end": 90966.453400825, "duration_ms": 0.2159060095436871, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, 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": 90966.453670611, "end": 90966.453958902, "duration_ms": 0.288291004835628, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, 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": 90966.454181308, "end": 90966.45439097, "duration_ms": 0.20966200099792331, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, 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": 90966.454577511, "end": 90966.454753287, "duration_ms": 0.17577600374352187, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, 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": 90966.454925409, "end": 90966.455092875, "duration_ms": 0.16746600158512592, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, 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": 90966.455263417, "end": 90966.455413331, "duration_ms": 0.14991400530561805, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, 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": 90966.457145896, "end": 90966.457433363, "duration_ms": 0.2874670026358217, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 747, 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 800, 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 1185, 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 longitude limit 101", "params": {} }, { "type": "sql", "start": 90966.45925649, "end": 90966.460547653, "duration_ms": 1.2911630037706345, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1532, 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 550, 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 530, 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": 90966.459178894, "end": 90966.460792856, "duration_ms": 1.61396199837327, "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 1529, 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 530, 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": 90966.460438958, "end": 90966.461642961, "duration_ms": 1.2040029978379607, "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 138, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.460929382, "end": 90966.462197899, "duration_ms": 1.2685170077020302, "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 1529, 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 540, 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": 90966.46206877, "end": 90966.462957199, "duration_ms": 0.8884290000423789, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 160, 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 138, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.463190858, "end": 90966.464395232, "duration_ms": 1.204373998916708, "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 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.464581531, "end": 90966.46493152, "duration_ms": 0.34998898627236485, "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 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.465137284, "end": 90966.465417627, "duration_ms": 0.2803429961204529, "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 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.465561879, "end": 90966.465855263, "duration_ms": 0.29338400054257363, "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 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.466002435, "end": 90966.466253238, "duration_ms": 0.25080300110857934, "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 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.46639946, "end": 90966.466639861, "duration_ms": 0.24040100106503814, "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 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.466950604, "end": 90966.467237683, "duration_ms": 0.28707900492008775, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 459, 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 138, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.467429971, "end": 90966.467680615, "duration_ms": 0.250643992330879, "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 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.467880713, "end": 90966.468181191, "duration_ms": 0.30047800100874156, "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 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.468363261, "end": 90966.468653362, "duration_ms": 0.2901010011555627, "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 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.468848866, "end": 90966.469089553, "duration_ms": 0.24068698985502124, "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 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.469253939, "end": 90966.469529406, "duration_ms": 0.27546699857339263, "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 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.469713386, "end": 90966.469945675, "duration_ms": 0.23228899226523936, "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 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.470108521, "end": 90966.470316924, "duration_ms": 0.20840299839619547, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 303, 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 138, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.470501139, "end": 90966.470858519, "duration_ms": 0.35737999132834375, "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 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.472103969, "end": 90966.472426639, "duration_ms": 0.32266999187413603, "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 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.472609897, "end": 90966.472925156, "duration_ms": 0.3152590070385486, "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 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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": 90966.473787705, "end": 90966.474042665, "duration_ms": 0.254959988524206, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, 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": 90966.474350514, "end": 90966.474595768, "duration_ms": 0.24525399203412235, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1280, 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": 90966.474958258, "end": 90966.475184726, "duration_ms": 0.2264680078951642, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1367, 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": 90966.476146725, "end": 90966.476356785, "duration_ms": 0.21005999587941915, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, 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": 90966.476583257, "end": 90966.476860879, "duration_ms": 0.2776220062514767, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, 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": 90966.477477583, "end": 90966.477676341, "duration_ms": 0.19875800353474915, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, 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 } ] }