musiccaps
2 rows where audioset_ids = "["/m/03lty", "/m/04rlf", "/m/05r6t", "/m/05w3f", "/m/06by7", "/m/0dl5d"]", audioset_ids contains "/m/05r6t" and audioset_ids contains "/m/06by7"
This data as json, CSV (advanced)
Suggested facets: aspect_list (array), audioset_names (array), audioset_ids (array)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
dO3VsX4rKNc | This heavy metal song features distortion guitars. One guitar plays power chords. Another guitar is playing a repetitive riff using palm muted arpeggiated notes. The keyboard plays chords in the background. The bass plays the root notes of the chords. The percussion plays a simple beat in common time. It starts off playing the kick and crash followed by three beats on the kick and ride. After four bars, a rock drum roll is played. This song can be played in a superhero movie. | ["heavy metal", "no voices", "distortion guitars", "palm muted arpeggios", "powerful percussion", "keyboards"] | ["Heavy metal", "Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock"] | 0 | 30 | 40 | 0 | 1 | ["/m/03lty", "/m/04rlf", "/m/05r6t", "/m/05w3f", "/m/06by7", "/m/0dl5d"] | |
pyumNmhV4_s | This is a punk rock piece. There is a male vocal singing with a nasal singing technique. There is a distorted electric guitar playing the main theme. The bass guitar is playing a simple, repetitive bass line. The acoustic drums are playing a fast-paced skank beat. There is a defiant, rebellious feel to the piece. It could be used in the soundtrack of a high school drama movie or a TV series. | ["punk rock", "male vocal", "nasal singing", "electric guitar", "bass guitar", "acoustic drums", "rebellious", "defiant", "fast-paced"] | ["Heavy metal", "Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock"] | 9 | 30 | 40 | 1 | 1 | ["/m/03lty", "/m/04rlf", "/m/05r6t", "/m/05w3f", "/m/06by7", "/m/0dl5d"] |
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 );