musiccaps

3 rows where aspect_list contains "people dancing" and audioset_ids contains "/m/01hgjl"

✎ View and edit SQL

This data as json, CSV (advanced)

ytid ▼ url caption aspect_list audioset_names author_id start_s end_s is_balanced_subset is_audioset_eval audioset_ids
2uvHgwAljPA The song is an instrumental. The song is medium tempo with a groovy drum rhythm, vinyl disc scratching tones and a percussive bass line. The song is energetic and groovy. The audio quality is very poor with a lot of hissing noise. ["dj", "practice session", "vinyl disc", "youtube music video", "disc scratching tones", "home music video", "freestyle disc scratching", "groovy", "dance rhythm", "poor audio quality", "ambient room noises", "instrumental music", "people dancing", "techno dance rhythm", "hissing tones", "medium tempo"] ["Scratching (performance technique)", "Music", "Scratch", "Drum machine"] 1 30 40 0 1 ["/m/01hgjl", "/m/04rlf", "/m/07qb_dv", "/m/0cfdd"]
HH3ryAEP308 The song is an instrumental. The tempo is medium fast with a groovy bass line, massive bass drops, various percussion hits, chirping tones, keyboard accompaniment and syncopated rhythms. The song is a modern electronic techno dance tune produced in a home studio. ["massive bass drops", "instrumental music", "whooshing tones", "energetic", "youthful", "pulsating", "adrenaline rush", "techno dance music", "beeping tones", "chirping tones", "electronic dance music", "various percussion hits", "quick fingers", "home studio", "medium fast tempo", "groovy rhythm", "people dancing", "party all night", "techno dance hits", "drumming", "scratching tones"] ["Scratching (performance technique)", "Sampler", "Music", "Drum machine"] 1 30 40 0 0 ["/m/01hgjl", "/m/01v1d8", "/m/04rlf", "/m/0cfdd"]
J0t4VMnXDNM A DJ plays a cool groove with some female vocals. The song is medium tempo with a steady drumming rhythm, scratch disc percussions, and percussive bass line. The song is exciting and groovy. The audio quality is average. ["dj", "female singer", "repeated vocal phrases", "techno dance music", "average audio quality", "groovy music", "dj turntable", "spinning discs", "scratching disc", "energetic", "groovy rhythm", "strong bass line", "steady rhythm", "medium tempo", "people dancing", "retro electronica", "electronic dance music", "dance floor"] ["Scratching (performance technique)", "Music", "Speech", "Hip hop music"] 1 0 10 0 0 ["/m/01hgjl", "/m/04rlf", "/m/09x0r", "/m/0glt670"]

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [musiccaps] (
   [ytid] TEXT PRIMARY KEY,
   [url] TEXT,
   [caption] TEXT,
   [aspect_list] TEXT,
   [audioset_names] TEXT,
   [author_id] TEXT,
   [start_s] TEXT,
   [end_s] TEXT,
   [is_balanced_subset] INTEGER,
   [is_audioset_eval] INTEGER,
   [audioset_ids] TEXT
);