musiccaps
2 rows where aspect_list contains "classic rock" and audioset_ids contains "/m/05w3f"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ap7xvCBtljs | A e-guitar is playing a melody along with the e-bass. The acoustic drums are playing with a loud 8th note rhythm on the ride cymbal. Another e-guitar is playing a high pitched melody on top. This song may be playing at a festival. | ["classic rock", "e-guitars", "e-bass", "acoustic drums", "medium to uptempo"] | ["Music", "Independent music", "Psychedelic rock", "Rock music", "Progressive rock"] | 6 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/05rwpb", "/m/05w3f", "/m/06by7", "/m/0dl5d"] | |
yesyhQkYrQM | A male vocalist sings this spirited Rock song. The tempo is fast with hard hitting drumming, punchy bass lines, electric guitar lead and keyboard harmony. The song is a vibrant, energetic, enthusiastic, engaging, catchy and upbeat Classic Rock. | ["male vocalist", "fast tempo", "funky bass line", "retro", "rock", "rock hits", "poor audio quality", "boomy sound", "distorted sound", "intense drumming", "bright electric guitar", "keyboard harmony", "classic rock", "electric", "energetic", "enthusiastic", "vivacious", "vibrant"] | ["Music", "Psychedelic rock"] | 7 | 180 | 190 | 1 | 1 | ["/m/04rlf", "/m/05w3f"] |
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 );