home

hth

Custom SQL query

Queries

  • gigs_per_venue
  • gigs_per_year
  • release_aggregates

Tables

music_press

id, publish, publish_on, title, date, source_url, quote, release_id, body

127 rows

music_release

id, slug, publish, publish_on, title, date, description, credits, cover_url, player_code, priority

11 rows

music_song

id, slug, publish, publish_on, title, description, credits, lyrics, track, release_id, player_code

100 rows

music_video

id, slug, publish, publish_on, title, source_url, embed_code, description, credits, release_id, preview_url, priority

44 rows

news_post

id, slug, publish, publish_on, title, body

57 rows

shows_gig

id, publish, publish_on, date, venue_id, description, details

317 rows

shows_venue

id, name, city, website, address, latitude, longitude

192 rows

... and 1 hidden table

Views

  • us_venues
  • published_gigs
  • published_releases
  • published_songs
  • published_videos
  • published_press
  • published_posts

Download SQLite DB: hth.db 504.0 KB

Powered by Datasette · Queries took 5.681ms