musiccaps
2 rows where aspect_list contains "ballad" and audioset_ids contains "/m/0fx80y"
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 |
---|---|---|---|---|---|---|---|---|---|---|
-8cgbhIR_pw | The low quality recording features a cover of a ballad song that consists of passionate, muddy male vocal singing over arpeggiated acoustic guitar melody. It sounds noisy, muddy and messy, as the frequencies are clashing, but it is also emotional and raw. | ["low quality", "passionate muddy male vocal", "arpeggiated acoustic guitar melody", "noisy", "muddy", "cover", "emotional", "ballad", "raw", "messy"] | ["Acoustic guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Strum", "Plucked string instrument", "Tender music"] | 4 | 30 | 40 | 0 | 1 | ["/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/06w87", "/m/07s0s5r", "/m/0fx80y", "/t/dd00034"] | |
4M0njWKFsME | Here we have a powerful rock ballad instrumental in a minor key. The guitar is grungy and overdriven, and the piano is clean and plays the same chords as the guitar at the same time. | ["rock music", "piano", "electric guitar strumming", "minor key", "rock power ballad", "ballad", "grungy electric guitar strumming", "overdrive"] | ["Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | 3 | 30 | 40 | 0 | 0 | ["/m/02sgy", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07s0s5r", "/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 );