musiccaps
2 rows where aspect_list contains "amateur recording", aspect_list contains "loud" and aspect_list contains "sharp"
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 |
---|---|---|---|---|---|---|---|---|---|---|
LH3mAtCou6g | This is an amateur music video of a male musician playing a mellow harmony on the banjo with another amateur musician accompanying him on the acoustic guitar. This song has a simple melody but the recording is loud and sharp. | ["instrumental", "banjo", "acoustic guitar", "sharp", "amateur recording", "amateur musicians", "loud", "home video", "mellow tune", "amateur recording"] | ["Country", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | 7 | 30 | 40 | 0 | 1 | ["/m/01lyv", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/m/0gg8l"] | |
bqvl7IbPteU | This music is an electric guitar instrumental. The tempo is medium with a loud and energetic riff . The audio quality is inferior as it is a Home recording ,which is why the music is boomy and there are sounds of people talking in the background and some static. | ["acoustic guitar", "instrumental", "medium tempo", "static", "abrupt end", "string instrument", "chords", "chord progression", "vibrations", "sonic power", "loud feedback", "boomy", "people talking", "electric guitar", "amplified guitar", "amateur", "melodic", "of static", "loud", "sharp", "amateur recording", "home video"] | ["Effects unit", "Electric guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | 7 | 30 | 40 | 0 | 1 | ["/m/02rr_", "/m/02sgy", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/07s0s5r", "/m/0fx80y", "/m/0g12c5"] |
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 );