home / fixtures

Menu

fixtures

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

Custom SQL query returning 10 rows (hide)

Export data

fixtures

Query results from this SQL query

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

idcontent
  null, first
  null, second
  null, third
1 integer 1
1.5 float 1.5
  empty string
$null text $null
1 text 1
i:1 text i:1
<Binary: 2 bytes> binary 0102
Powered by Datasette