musiccaps
2 rows where aspect_list contains "instrumental music" and audioset_ids = "["/m/01sm1g", "/m/0l14md"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
NcsYdCbKgcc | The song is an instrumental. The song is medium fast tempo with percussionists playing a groovy rhythm on three clap boxes. The sound quality is poor with a lot of ambient crowd noise. | ["clap box rhythm", "percussionist", "medium fast tempo", "live performance", "exciting", "energetic", "passionate", "drum demonstration", "youtube music video", "instrumental music", "ambient crowd noise", "groovy rhythm", "people talking", "bad audio quality", "percussion demonstration"] | ["Wood block", "Percussion"] | 1 | 90 | 100 | 0 | 0 | ["/m/01sm1g", "/m/0l14md"] | |
UR3k09hOxI4 | The song is an instrumental. The song is in medium tempo with various Latin percussions playing syncopated rhythms and an organ playing accompaniment. The song is a Latin Jazz tune with a definite dance rhythm. The audio quality is mediocre. | ["latin dance rhythm", "latin percussions", "mediocre audio quality", "latin dancers", "emotional", "passionate", "energetic", "organ accompaniment", "instrumental music", "latin percussion instruments", "syncopated rhythms", "groovy dance music", "groovy bass line", "latin jazz music", "medium tempo"] | ["Wood block", "Percussion"] | 1 | 30 | 40 | 0 | 0 | ["/m/01sm1g", "/m/0l14md"] |
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 );