musiccaps
1 row where aspect_list contains "boomy" and aspect_list contains "children’s song"
This data as json, CSV (advanced)
aspect_list (array) 19 ✖
- acoustic guitar 1
- alternative pop 1
- alternative rock 1
- amateur recording 1
- animated 1
- boomy · 1 ✖
- children’s song · 1 ✖
- educational 1
- funny song 1
- home video 1
- informative 1
- learning 1
- male vocalist 1
- medium tempo 1
- minimal instruments 1
- monotone singing 1
- simple lyrics 1
- simple melody 1
- sound of static 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
lIBsL97sUmY | A male vocalist sings this soft pop. The tempo is medium with an acoustic guitar accompaniment and sound of static in the background. The song has simple lyrics and melody . It is informative and educational. This song is a Children’s song/Alternative Pop. | ["male vocalist", "medium tempo", "acoustic guitar", "boomy", "simple melody", "simple lyrics", "informative", "educational", "learning", "monotone singing", "home video", "amateur recording", "sound of static", "simple melody", "funny song", "children’s song", "alternative pop", "alternative rock", "animated", "simple melody", "minimal instruments"] | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum"] | 7 | 30 | 40 | 0 | 1 | ["/m/042v_gx", "/m/04rlf", "/m/06w87", "/m/07s0s5r"] |
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 );