musiccaps
1 row where aspect_list contains "children’s song" and aspect_list contains "excited"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- animated male vocals 1
- animated yodelling 1
- bad quality audio 1
- brass band 1
- cheerful 1
- children dancing 1
- children’s song · 1 ✖
- comical 1
- dance music 1
- deteriorated music 1
- excited · 1 ✖
- funny 1
- groovy bas slime 1
- guitars strumming rhythm 1
- medium fast tempo 1
- poor audio recording 1
- steady marching drum rhythm 1
- story telling 1
- trumpets play percussively 1
- yodelling song 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
mOn13E68Td0 | A male singer sings in an animated manner. The song is medium fast tempo with a steady drumming rhythm, brass band accompaniment, groovy bass line and guitar strumming rhythm. The song is exciting and cheerful. The song is an animated children’s show tune, but a poor recording of the actual show. | ["animated male vocals", "yodelling song", "comical", "poor audio recording", "bad quality audio", "deteriorated music", "children’s song", "excited", "trumpets play percussively", "brass band", "steady marching drum rhythm", "groovy bas slime", "guitars strumming rhythm", "story telling", "dance music", "animated yodelling", "funny", "excited", "children dancing", "cheerful", "medium fast tempo"] | ["Yodeling", "Music"] | 1 | 30 | 40 | 1 | 1 | ["/m/01swy6", "/m/04rlf"] |
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 );