Datasette Fixtures

An example SQLite database demonstrating Datasette. Sign in as root user

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

6 databases49 tables11 views4 queries

Queries

All 4 queries →

𝐜𝐢𝐭𝐢𝐞𝐬 select id, name from facet_cities order by id limit 1;
pragma_cache_size PRAGMA cache_size;
magic_parameters select :_header_user_agent as user_agent, :_now_datetime_utc as datetime · inputs: _header_user_agent, _now_datetime_utc
Search neighborhoods select _neighborhood, facet_cities.name, state from facetable join facet_cities on facetable._city_id =... · inputs: text

Tables and views

foreign_key_references links to 3 tables

pkforeign_key_with_labelforeign_key_with_blank_labelforeign_key_with_no_labelforeign_key_compound_pk1foreign_key_compound_pk2

2 rows
roadside_attraction_characteristics links to 2 tables

attraction_idcharacteristic_id

5 rows
searchable_tags links to 2 tables

searchable_idtag

2 rows
This <em>HTML</em> is escaped links to 2 tables

idcontent

simple_primary_key5 rows
facetable links to 1 table

pkcreatedplanet_inton_earthstate_city_id_neighborhoodtags+3 more

15 rows
roadside_attractions links to 1 table

pknameaddressurllatitudelongitude

4 rows
complex_foreign_keys links to 1 table

pkf1f2f3

1 row
searchable links to 1 table

pktext1text2name with . and spaces

2 rowsfull-text search
compound_primary_key links to 1 table

pk1pk2content

3 rows
primary_key_multiple_columns links to 1 table

idcontentcontent2

1 row
primary_key_multiple_columns_explicit_label links to 1 table

idcontentcontent2

1 row
attraction_characteristic links to 1 table

pkname

2 rows
custom_foreign_key_label links to 1 table

pkforeign_key_with_custom_label

1 row
facet_cities links to 1 table

idname

4 rows
tags links to 1 table

tag

2 rows
sortable

pk1pk2contentsortablesortable_with_nullssortable_with_nulls_2text

201 rows
compound_three_primary_keys

pk1pk2pk3content

1,001 rows
select

grouphavingandjson

1 row
Table With Space In Name

pkcontent

0 rows
table/with/slashes.csv

pkcontent

1 row
123_starts_with_digits

content

0 rows
binary_data

data

3 rows
infinity

value

3 rows
binary_data_view view

data

3 rows
paginated_view view

contentcontent_extra
searchable_view view

pktext1text2name with . and spaces

2 rows
searchable_view_configured_by_metadata view

pktext1text2name with . and spaces

2 rows
simple_view view

contentupper_content

5 rows

Recently visited

Queries

Tables and views