home

fixtures

Custom SQL query

123_starts_with_digits

content

0 rows

Table With Space In Name

pk, content

0 rows

complex_foreign_keys

pk, f1, f2, f3

1 row

compound_primary_key

pk1, pk2, content

1 row

compound_three_primary_keys

pk1, pk2, pk3, content

1,001 rows

custom_foreign_key_label

pk, foreign_key_with_custom_label

1 row

facet_cities

id, name

4 rows

facetable

pk, planet_int, state, city_id, neighborhood

15 rows

foreign_key_references

pk, foreign_key_with_label, foreign_key_with_no_label

1 row

no_primary_key

content, a, b, c

201 rows

primary_key_multiple_columns

id, content, content2

1 row

primary_key_multiple_columns_explicit_label

id, content, content2

1 row

searchable

pk, text1, text2, name with . and spaces

2 rows

select

group, having, and

1 row

simple_primary_key

id, content

3 rows

sortable

pk1, pk2, content, sortable, sortable_with_nulls, sortable_with_nulls_2, text

201 rows

table/with/slashes.csv

pk, content

1 row

units

pk, distance, frequency

3 rows

... and 4 hidden tables

Views

Download SQLite DB: fixtures.db

Powered by Datasette · Query took 0.049ms