musiccaps
1 row where aspect_list contains "children’s favourites" and aspect_list contains "male singer"
This data as json, CSV (advanced)
aspect_list (array) 21 ✖
- accordion accompaniment 1
- animated vocals 1
- cartoon show music theme 1
- cheerful 1
- children’s education program 1
- children’s favourites · 1 ✖
- cymbals crashing 1
- dance rhythm 1
- funny 1
- groovy bass line 1
- inspiring 1
- male singer · 1 ✖
- medium tempo 1
- motivational 1
- movie soundtrack 1
- percussion bells 1
- quacking vocals 1
- retro pop songs 1
- steady marching rhythm 1
- stylish singing voice 1
- various percussion hits 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
C0sSgrr5xrQ | A male singer sings this cool retro melody with duck quacking sounds. The song is medium tempo with a steady drumming rhythm with various funny percussion hits, accordion accompaniment and a groovy bass line. The song is inspiring and nostalgic. The song has an average audio quality. | ["male singer", "stylish singing voice", "groovy bass line", "quacking vocals", "medium tempo", "cymbals crashing", "percussion bells", "various percussion hits", "funny", "cheerful", "animated vocals", "dance rhythm", "accordion accompaniment", "cartoon show music theme", "inspiring", "motivational", "children’s education program", "movie soundtrack", "retro pop songs", "children’s favourites", "steady marching rhythm"] | ["Music", "Quack", "Duck"] | 1 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07qdb04", "/m/09ddx"] |
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 );