musiccaps
2 rows where aspect_list contains "pop rock" and audioset_ids contains "/m/07s8j8t"
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 |
---|---|---|---|---|---|---|---|---|---|---|
1ZaxqZMs21M | A male vocalist sings this spirited rock and rock song. The tempo is fast with bright drumming, intense electric guitar feedback, keyboard harmony and rhythmic acoustic guitar with vocal backup. The song is upbeat, spirited, enthusiastic, vibrant, vivacious, buoyant and youthful with a dance groove. The sound quality is inferior making it difficult to understand the lyrics or the finer elements of this Rock and Roll song. | ["male vocalist", "fast tempo", "intense electric guitar", "punchy drumming", "keyboard harmony", "vocal backup", "rhythmic acoustic guitar", "groovy bass line", "loud", "jarring", "inferior audio quality", "people cheering", "people talking", "energetic", "enthusiastic", "vigorous vivacious", "bright", "enthusiastic", "dance music", "pop", "pop rock", "rock", "rock and roll"] | ["Singing", "Music", "Musical instrument", "Rock music", "Roll", "Inside, large room or hall"] | 7 | 220 | 230 | 0 | 1 | ["/m/015lz1", "/m/04rlf", "/m/04szw", "/m/06by7", "/m/07s8j8t", "/t/dd00126"] | |
eJFZuX0WHgk | This is a pop rock music piece being performed in the studio. There is a male vocalist singing melodically in the lead. The electric guitar is playing a simple tune with the bass guitar in the background. The acoustic drums are playing an upbeat rhythm with off-beat hi-hat strokes. The atmosphere is energetic. This piece could be used as the opening theme of a Korean teenage drama TV series. | ["pop rock", "studio performance", "male vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drum", "upbeat", "energetic", "lively"] | ["Drum kit", "Music", "Musical instrument", "Ska", "Roll"] | 9 | 70 | 80 | 0 | 0 | ["/m/02hnl", "/m/04rlf", "/m/04szw", "/m/06rqw", "/m/07s8j8t"] |
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 );