musiccaps
1 row where aspect_list contains "documentary soundtrack" and aspect_list contains "marching drumming rhythm"
This data as json, CSV (advanced)
aspect_list (array) 19 ✖
- adrenaline rush 1
- army band music 1
- brass band 1
- cymbal crashes 1
- documentary soundtrack · 1 ✖
- excitement 1
- glory and honour 1
- instrumenatl music 1
- marching drumming rhythm · 1 ✖
- patriotic fervour 1
- patriotic music 1
- pomp and glory 1
- poor audio quality 1
- showcasing air power 1
- snare plays percussively 1
- spirited 1
- trombones 1
- trumpets blaring harmony 1
- tubas playing 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
tKawN2sxhYc | The song is an instrumental. The tempo is medium with a marching band rhythm, snares playing percussively , cymbals crashing, brass band harmony, trumpets blaring, trombones and tubas playing long notes. The song has a patriotic fervour and inspires. The overall sound quality is poor. | ["instrumenatl music", "army band music", "patriotic fervour", "patriotic music", "spirited", "excitement", "pomp and glory", "adrenaline rush", "glory and honour", "marching drumming rhythm", "brass band", "trumpets blaring harmony", "trombones", "tubas playing", "snare plays percussively", "cymbal crashes", "poor audio quality", "showcasing air power", "documentary soundtrack", "poor audio quality"] | ["Theme music", "Music", "Soundtrack music", "Tender music"] | 1 | 30 | 40 | 1 | 1 | ["/m/02cjck", "/m/04rlf", "/m/0l14gg", "/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 );