home / fixtures2 / roadside_attractions

Menu

roadside_attractions

4 rows

View and edit SQL

Export data

roadside_attractions

All rows in this table

TSV All 4 rows
Tab-separated values, for pasting into Excel or Google Sheets
CSV All 4 rows
Comma-separated values, for spreadsheets and other tools
  • JSON All 4 rows
    Rows inside an object, with extra details
    View Download
  • JSON array All 4 rows
    Just the rows, as an array of objects
    View Download
  • Newline-delimited JSON All 4 rows
    One JSON object per line
    View Download
  • JSON object All 4 rows
    Rows keyed by their primary key
    View Download
  • testall All 4 rows
    View Download
  • testnone All 4 rows
    View Download
  • testresponse All 4 rows
    View Download

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
Table schema
CREATE TABLE roadside_attractions (
    pk integer primary key,
    name text,
    address text,
    url text,
    latitude real,
    longitude real
);
Powered by Datasette · Queries took 22.964ms