musiccaps
2 rows where aspect_list contains "rock hits" and audioset_ids contains "/m/07sr1lc"
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 |
---|---|---|---|---|---|---|---|---|---|---|
-7B9tPuIP-w | A male voice narrates a monologue to the rhythm of a song in the background. The song is fast tempo with enthusiastic drumming, groovy bass lines,cymbal ride, keyboard accompaniment ,electric guitar and animated vocals. The song plays softly in the background as the narrator speaks and burgeons when he stops. The song is a classic Rock and Roll and the narration is a Documentary. | ["male vocalist", "medium fast tempo", "monologue", "background music", "hit songs", "retro", "narrator", "narration", "documentary", "animated singing", "enthusiastic drumming", "cymbal ride", "electric guitar", "groovy bass lines", "rock and rock", "classic rock and rock", "muffled", "blues", "rock hits", "vocalisation"] | ["Blues", "Music", "Yell"] | 7 | 450 | 460 | 0 | 1 | ["/m/0155w", "/m/04rlf", "/m/07sr1lc"] | |
M_s-49rNCdw | A male vocalist sings this spirited song. The song is medium tempo with energetic electric guitar lead, enthusiastic electric bass guitar , hard hitting drums and keyboard harmony. The vocals are passionate, youthful,energetic, vociferous, powerful and loud . This song is Hard Rock/Metal. | ["male vocalist", "fast tempo", "hard rock", "rock hits", "rock concert", "live performance", "spirited", "boisterous", "metal", "hard hitting drums", "energetic electric guitar lead", "electric bass guitar", "enthusiastic", "sonic power", "amplified instruments", "vigorous", "passionate", "intense", "vociferous", "a keyboard harmony"] | ["Singing", "Music", "Roll", "Yell"] | 7 | 50 | 60 | 0 | 1 | ["/m/015lz1", "/m/04rlf", "/m/07s8j8t", "/m/07sr1lc"] |
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 );