musiccaps
2 rows where aspect_list contains "electric bass guitar" and audioset_ids contains "/m/015lz1"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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"] | |
too9MtXBwts | A sweet, melancholy sounding soft rock song with a male singer accompanied by acoustic guitar strumming, a cello counter melody, piano, simple electric bass, and a slow rock drum beat. | ["soft rock", "cello counter melody", "male singer", "melancholy", "acoustic guitar strumming", "piano accompaniment", "sweet", "slow rock drum beat", "simple bass", "electric bass guitar"] | ["Singing", "Music", "Tender music"] | 8 | 100 | 110 | 0 | 0 | ["/m/015lz1", "/m/04rlf", "/t/dd00034"] |
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 );