musiccaps
2 rows where aspect_list contains "boisterous" 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 |
---|---|---|---|---|---|---|---|---|---|---|
7TmKzUgWiRU | This is a multi track audio. There are several things happening. There’s an energetic song in the background with enthusiastic vocals, drumming and trumpets. There’s a loud whirring of an engine, like a chain saw, beeps and a phone dial tone. The audio is loud, confusing, chaotic, boisterous,unrelated , noisy, loud, dissonant and unpleasant. | ["instrumental", "fast tempo", "engine", "vigorous", "dissonant", "unpleasant", "superimposed tracks", "distorted sounds", "dissonant unrelated", "boisterous", "noisy", "chain saw", "music", "beep", "telephone busy signal", "running", "multiple tracks playing", "trumpets", "noisy", "chaotic", "boisterous unrelated", "deafening", "unpleasant"] | ["Chainsaw", "Music", "Roll"] | 7 | 0 | 10 | 0 | 1 | ["/m/01j4z9", "/m/04rlf", "/m/07s8j8t"] | |
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 );