home / fixtures

Menu

fixtures

Query actions Query actions
  • Explain this query Runs a SQLite explain
Test tables description

Custom SQL query returning 4 rows (hide)

Parameters

Export data

fixtures

Query results from this SQL query with p0 = "1", p1 = "2019-01-14 08:00:00"

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
  • testall All 4 rows
    View Download
  • testnone All 4 rows
    View Download
  • testresponse All 4 rows
    View Download

pkcreatedplanet_inton_earthstate_city_id_neighborhoodtagscomplex_arraydistinct_some_nulln
1 2019-01-14 08:00:00 1 1 CA 1 Mission ["tag1", "tag2"] [{"foo": "bar"}] one n1
2 2019-01-14 08:00:00 1 1 CA 1 Dogpatch ["tag1", "tag3"] [] two n2
3 2019-01-14 08:00:00 1 1 CA 1 SOMA [] []    
4 2019-01-14 08:00:00 1 1 CA 1 Tenderloin [] []    
Powered by Datasette