home / fixtures

fixtures

Query actions Query actions
  • Explain this query

    Runs a SQLite explain

Test tables description

Custom SQL query returning 105 rows (hide)

This data as json, testall, testnone, testresponse, CSV

tableNamecolumnName
123_starts_with_digits content
Table With Space In Name content
Table With Space In Name pk
attraction_characteristic name
attraction_characteristic pk
binary_data data
complex_foreign_keys f1
complex_foreign_keys f2
complex_foreign_keys f3
complex_foreign_keys pk
compound_primary_key content
compound_primary_key pk1
compound_primary_key pk2
compound_three_primary_keys content
compound_three_primary_keys pk1
compound_three_primary_keys pk2
compound_three_primary_keys pk3
custom_foreign_key_label foreign_key_with_custom_label
custom_foreign_key_label pk
facet_cities id
facet_cities name
facetable _city_id
facetable _neighborhood
facetable complex_array
facetable created
facetable distinct_some_null
facetable n
facetable on_earth
facetable pk
facetable planet_int
facetable state
facetable tags
foreign_key_references foreign_key_compound_pk1
foreign_key_references foreign_key_compound_pk2
foreign_key_references foreign_key_with_blank_label
foreign_key_references foreign_key_with_label
foreign_key_references foreign_key_with_no_label
foreign_key_references pk
infinity value
no_primary_key a
no_primary_key b
no_primary_key c
no_primary_key content
paginated_view content
paginated_view content_extra
primary_key_multiple_columns content
primary_key_multiple_columns content2
primary_key_multiple_columns id
primary_key_multiple_columns_explicit_label content
primary_key_multiple_columns_explicit_label content2
primary_key_multiple_columns_explicit_label id
roadside_attraction_characteristics attraction_id
roadside_attraction_characteristics characteristic_id
roadside_attractions address
roadside_attractions latitude
roadside_attractions longitude
roadside_attractions name
roadside_attractions pk
roadside_attractions url
searchable name with . and spaces
searchable pk
searchable text1
searchable text2
searchable_fts name with . and spaces
searchable_fts text1
searchable_fts text2
searchable_fts_docsize docid
searchable_fts_docsize size
searchable_fts_segdir end_block
searchable_fts_segdir idx
searchable_fts_segdir leaves_end_block
searchable_fts_segdir level
searchable_fts_segdir root
searchable_fts_segdir start_block
searchable_fts_segments block
searchable_fts_segments blockid
searchable_fts_stat id
searchable_fts_stat value
searchable_tags searchable_id
searchable_tags tag
searchable_view name with . and spaces
searchable_view pk
searchable_view text1
searchable_view text2
searchable_view_configured_by_metadata name with . and spaces
searchable_view_configured_by_metadata pk
searchable_view_configured_by_metadata text1
searchable_view_configured_by_metadata text2
select and
select group
select having
select json
simple_primary_key content
simple_primary_key id
simple_view content
simple_view upper_content
sortable content
sortable pk1
sortable pk2
sortable sortable_with_nulls
sortable sortable_with_nulls_2
sortable text
table/with/slashes.csv content
table/with/slashes.csv pk
tags tag
Powered by Datasette