fixtures

Data source: github.com/simon/datasette-psutil · About: /-/psutil demo

123_starts_with_digits

content

0 rows

Table With Space In Name

pk, content

0 rows

attraction_characteristic

pk, name

2 rows

binary_data

data

1 row

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, created, planet_int, on_earth, state, city_id, neighborhood, tags, complex_array...

15 rows

foreign_key_references

pk, foreign_key_with_label, foreign_key_with_no_label

2 rows

infinity

value

3 rows

my_table

mycol

0 rows

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

roadside_attraction_characteristics

attraction_id, characteristic_id

5 rows

roadside_attractions

pk, name, address, latitude, longitude

4 rows

searchable

pk, text1, text2, name with . and spaces

2 rows

searchable_tags

searchable_id, tag

2 rows

select

group, having, and, json

1 row

simple_primary_key

id, content

4 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 256.0 KB

fixtures

Custom SQL query

Views