home

musiccaps

Custom SQL query

Tables

musiccaps

ytid, url, caption, aspect_list, audioset_names, author_id, start_s, end_s, is_balanced_subset, is_audioset_eval, audioset_ids

5,521 rows

videos

id, publishedAt, channelId, title, description, thumbnails, channelTitle, tags, categoryId, liveBroadcastContent, localized, viewCount, likeCount, favoriteCount, commentCount, defaultAudioLanguage, defaultLanguage

5,503 rows

musiccaps_fts (hidden)

caption, musiccaps_fts, rank

5,521 rows

musiccaps_fts_config (hidden)

k, v

1 row

musiccaps_fts_data (hidden)

id, block

188 rows

musiccaps_fts_docsize (hidden)

id, sz

5,521 rows

musiccaps_fts_idx (hidden)

segid, term, pgno

143 rows

Views

  • musiccaps_details

Download SQLite DB: musiccaps.db 16.0 MB

Powered by Datasette · Queries took 7.009ms · About: simonw/musiccaps-datasette