API Explorer

Use this tool to try out the Datasette API.

API endpoints

• Database: counters
• counters
  • /counters/counters.json - Get rows for counters
• Database: fixtures
• simple_primary_key
  • /fixtures/simple_primary_key.json - Get rows for simple_primary_key
• primary_key_multiple_columns
  • /fixtures/primary_key_multiple_columns.json - Get rows for primary_key_multiple_columns
• primary_key_multiple_columns_explicit_label
  • /fixtures/primary_key_multiple_columns_explicit_label.json - Get rows for primary_key_multiple_columns_explicit_label
• compound_primary_key
  • /fixtures/compound_primary_key.json - Get rows for compound_primary_key
• compound_three_primary_keys
  • /fixtures/compound_three_primary_keys.json - Get rows for compound_three_primary_keys
• foreign_key_references
  • /fixtures/foreign_key_references.json - Get rows for foreign_key_references
• sortable
  • /fixtures/sortable.json - Get rows for sortable
• no_primary_key
  • /fixtures/no_primary_key.json - Get rows for no_primary_key
• 123_starts_with_digits
  • /fixtures/123_starts_with_digits.json - Get rows for 123_starts_with_digits
• Table With Space In Name
  • /fixtures/Table+With+Space+In+Name.json - Get rows for Table With Space In Name
• table/with/slashes.csv
  • /fixtures/table~2Fwith~2Fslashes~2Ecsv.json - Get rows for table/with/slashes.csv
• complex_foreign_keys
  • /fixtures/complex_foreign_keys.json - Get rows for complex_foreign_keys
• custom_foreign_key_label
  • /fixtures/custom_foreign_key_label.json - Get rows for custom_foreign_key_label
• tags
  • /fixtures/tags.json - Get rows for tags
• searchable
  • /fixtures/searchable.json - Get rows for searchable
• searchable_tags
  • /fixtures/searchable_tags.json - Get rows for searchable_tags
• searchable_fts
  • /fixtures/searchable_fts.json - Get rows for searchable_fts
• searchable_fts_segments
  • /fixtures/searchable_fts_segments.json - Get rows for searchable_fts_segments
• searchable_fts_segdir
  • /fixtures/searchable_fts_segdir.json - Get rows for searchable_fts_segdir
• searchable_fts_docsize
  • /fixtures/searchable_fts_docsize.json - Get rows for searchable_fts_docsize
• searchable_fts_stat
  • /fixtures/searchable_fts_stat.json - Get rows for searchable_fts_stat
• select
  • /fixtures/select.json - Get rows for select
• infinity
  • /fixtures/infinity.json - Get rows for infinity
• facet_cities
  • /fixtures/facet_cities.json - Get rows for facet_cities
• facetable
  • /fixtures/facetable.json - Get rows for facetable
• binary_data
  • /fixtures/binary_data.json - Get rows for binary_data
• roadside_attractions
  • /fixtures/roadside_attractions.json - Get rows for roadside_attractions
• attraction_characteristic
  • /fixtures/attraction_characteristic.json - Get rows for attraction_characteristic
• roadside_attraction_characteristics
  • /fixtures/roadside_attraction_characteristics.json - Get rows for roadside_attraction_characteristics
• Database: fixtures2
• simple_primary_key
  • /alternative-route/simple_primary_key.json - Get rows for simple_primary_key
• primary_key_multiple_columns
  • /alternative-route/primary_key_multiple_columns.json - Get rows for primary_key_multiple_columns
• primary_key_multiple_columns_explicit_label
  • /alternative-route/primary_key_multiple_columns_explicit_label.json - Get rows for primary_key_multiple_columns_explicit_label
• compound_primary_key
  • /alternative-route/compound_primary_key.json - Get rows for compound_primary_key
• compound_three_primary_keys
  • /alternative-route/compound_three_primary_keys.json - Get rows for compound_three_primary_keys
• foreign_key_references
  • /alternative-route/foreign_key_references.json - Get rows for foreign_key_references
• sortable
  • /alternative-route/sortable.json - Get rows for sortable
• no_primary_key
  • /alternative-route/no_primary_key.json - Get rows for no_primary_key
• 123_starts_with_digits
  • /alternative-route/123_starts_with_digits.json - Get rows for 123_starts_with_digits
• Table With Space In Name
  • /alternative-route/Table+With+Space+In+Name.json - Get rows for Table With Space In Name
• table/with/slashes.csv
  • /alternative-route/table~2Fwith~2Fslashes~2Ecsv.json - Get rows for table/with/slashes.csv
• complex_foreign_keys
  • /alternative-route/complex_foreign_keys.json - Get rows for complex_foreign_keys
• custom_foreign_key_label
  • /alternative-route/custom_foreign_key_label.json - Get rows for custom_foreign_key_label
• tags
  • /alternative-route/tags.json - Get rows for tags
• searchable
  • /alternative-route/searchable.json - Get rows for searchable
• searchable_tags
  • /alternative-route/searchable_tags.json - Get rows for searchable_tags
• searchable_fts
  • /alternative-route/searchable_fts.json - Get rows for searchable_fts
• searchable_fts_segments
  • /alternative-route/searchable_fts_segments.json - Get rows for searchable_fts_segments
• searchable_fts_segdir
  • /alternative-route/searchable_fts_segdir.json - Get rows for searchable_fts_segdir
• searchable_fts_docsize
  • /alternative-route/searchable_fts_docsize.json - Get rows for searchable_fts_docsize
• searchable_fts_stat
  • /alternative-route/searchable_fts_stat.json - Get rows for searchable_fts_stat
• select
  • /alternative-route/select.json - Get rows for select
• infinity
  • /alternative-route/infinity.json - Get rows for infinity
• facet_cities
  • /alternative-route/facet_cities.json - Get rows for facet_cities
• facetable
  • /alternative-route/facetable.json - Get rows for facetable
• binary_data
  • /alternative-route/binary_data.json - Get rows for binary_data
• roadside_attractions
  • /alternative-route/roadside_attractions.json - Get rows for roadside_attractions
• attraction_characteristic
  • /alternative-route/attraction_characteristic.json - Get rows for attraction_characteristic
• roadside_attraction_characteristics
  • /alternative-route/roadside_attraction_characteristics.json - Get rows for roadside_attraction_characteristics
• Database: extra_database
• searchable
  • /extra_database/searchable.json - Get rows for searchable
• searchable_fts
  • /extra_database/searchable_fts.json - Get rows for searchable_fts
• searchable_fts_content
  • /extra_database/searchable_fts_content.json - Get rows for searchable_fts_content
• searchable_fts_segments
  • /extra_database/searchable_fts_segments.json - Get rows for searchable_fts_segments
• searchable_fts_segdir
  • /extra_database/searchable_fts_segdir.json - Get rows for searchable_fts_segdir