home / fixtures

Menu

Search neighborhoods

Query actions Query actions
  • Explain this query Runs a SQLite explain
Demonstrating simple like search

Custom SQL query returning 6 rows (show)

Parameters

Edit SQL

Export data

neighborhood_search

Query results from the neighborhood_search query with text = "town"

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

_neighborhoodnamestate
Corktown Detroit MI
Downtown Los Angeles CA
Downtown Detroit MI
Greektown Detroit MI
Koreatown Los Angeles CA
Mexicantown Detroit MI
Powered by Datasette