musiccaps
2 rows where aspect_list contains "live concert" and audioset_ids contains "/m/04szw"
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 |
---|---|---|---|---|---|---|---|---|---|---|
cQX-WgT0ACQ | A guitarist is tuning his guitar making string noises, peg sounds and fretboard noises. The audio is very bad with a boomy low end. The conversation is engaging and keeps the crowds occupied as the guitarist gets ready for the next song. | ["guitarist talks", "tuning notes", "tuning pegs", "guitar master class", "guitar solo", "live concert", "live audience", "soloist", "random notes", "laughing", "bad audio quality", "engaging crowds", "performer", "famous guitarist", "tuning legs", "fretboard sounds", "no fixed tempo", "bad audio quality", "ambient crowd noises"] | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 1 | 20 | 30 | 0 | 0 | ["/m/01glhc", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] | |
qsFfUzErXqw | The song is instrumental. The tempo is medium with sitars and other stringed instruments playing in unison, tabla percussions and a harmonium playing the lead. The song is a classic hindustaani instrumental. | ["instrumental music", "harmonium solo", "traditional indian instruments", "indian classical music", "tabla playing percussively", "sitar accompaniment", "y traditional indian instruments", "groovy rhythm", "exciting", "instruments in unison", "dance rhythm", "ancient traditional music", "passionate", "live concert", "live audience", "medium tempo", "hindustaani music"] | ["Tabla", "Music of Asia", "Music", "Musical instrument", "Sitar", "Bowed string instrument"] | 1 | 140 | 150 | 1 | 1 | ["/m/01p970", "/m/028sqc", "/m/04rlf", "/m/04szw", "/m/0jtg0", "/m/0l14_3"] |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );