musiccaps
2 rows where aspect_list contains "cheerful" and audioset_ids contains "/t/dd00035"
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 |
---|---|---|---|---|---|---|---|---|---|---|
GFGwPa9d9XQ | This is a country folk song with a generally positive, cheerful and joyful vibe to it. The singer is a man with an elderly voice that has a quality that sounds like a gurgle. His style of singing and the content of lyrics and melody are similar to hearing a story being told. There aren't really any rhyming lyrics - it's more like he is telling a story in song form. There are licks being played on an electric guitar, as well as certain motifs on the violin in between particular phrases by the singer. | ["country folk music", "electric guitar licks", "violin lick", "elderly raspy male country vocal", "intricate bassline", "country", "southern", "vibrant piano playing", "cheerful", "storytelling style singing", "joyful"] | ["Country", "Music", "Pop music", "Middle Eastern music", "Bluegrass", "Exciting music"] | 3 | 30 | 40 | 0 | 0 | ["/m/01lyv", "/m/04rlf", "/m/064t9", "/m/06j64v", "/m/0gg8l", "/t/dd00035"] | |
hhohfEC82JI | A male singer sings this animated melody . The song is medium tempo with a groovy bass , keyboard accompaniment and steady drumming rhythm. The song is cheerful and animated and designed as educational material for little children. | ["medium tempo", "male singer", "groovy bass line", "preschool teaching", "educational material", "learning", "schools", "toddlers", "positive", "cheerful", "spirited", "fun learning", "children dancing", "animated video", "nursery rhymes", "zoo", "animals", "steady drumming rhythm", "piano accompaniment", "children’s song", "animated singing"] | ["Funk", "Music", "Exciting music"] | 1 | 30 | 40 | 0 | 0 | ["/m/02x8m", "/m/04rlf", "/t/dd00035"] |
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 );