musiccaps
3 rows where aspect_list contains "medium to uptempo" and audioset_ids contains "/m/02sgy"
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 |
---|---|---|---|---|---|---|---|---|---|---|
CodqNx1ukOc | Someone is playing a melody on the e-guitar with a lot of reverb and a little bit of delay. This song may be playing guitar at home. | ["amateur recording", "e-guitar", "medium to uptempo"] | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | 6 | 30 | 40 | 0 | 1 | ["/m/01glhc", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/m/0g12c5"] | |
Ts3ZcUaELzA | Someone is playing a distorted e-guitar melody in the lower mid-range. This song may be playing at home practicing guitar. | ["amateur recording", "e-guitar", "medium to uptempo", "aggresive sounding"] | ["Electric guitar", "Music", "Harmonic"] | 6 | 30 | 40 | 0 | 1 | ["/m/02sgy", "/m/04rlf", "/m/0b9m1"] | |
clefr8E-iZQ | Someone is playing an e-guitar with different effects over an acoustic drumgroove. Some of the sounds are panned to the right and left side of the speakers. This song may be playing at home practicing guitar. | ["amateur recording", "e-guitar", "acoustic drums", "shaker", "medium to uptempo"] | ["Blues", "Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | 6 | 30 | 40 | 1 | 1 | ["/m/0155w", "/m/01jnbd", "/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y"] |
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 );