musiccaps_details (view)
2 rows where musiccaps_aspects contains "children’s show" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- children’s show · 2 ✖
- medium tempo · 2 ✖
- ambient street noises 1
- animated show 1
- animated vocals 1
- arpeggiated sounds 1
- average audio quality 1
- average quality audio 1
- cartoony vocals 1
- chattering 1
- cheerful 1
- comedy show 1
- dance rhythm 1
- distorted vocals 1
- ducky quack sounds 1
- flutes playing 1
- funny 1
- funny show 1
- groovy rhythm 1
- happy 1
- idyllic music 1
- keyboard accompaniment 1
- liens adventure 1
- morals 1
- movie soundtrack 1
- orchestra playing 1
- organ accompaniment 1
- people 1
- percussive bass line 1
- retro pop songs 1
- show tune 1
- small adventures 1
- sounds 1
- sunday tv shows 1
- tv show 1
- tv show soundtrack 1
- tv show tune 1
musiccaps_names (array) 4 ✖
- Music 2
- Quack 1
- Rock and roll 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Donald Duck: Straigt Shooters 1947 | The song is background audio of an animated tv show. The song is idyllic and performed by an orchestra with organ playing lead, flutes and rhythm section. The song is of average audio quality. The audio track is animated and cartoon-like. | 2009-08-18T08:18:37Z | donaldduckforever | Part of The Chronological Donald Volume 3 1947-1950 Made by: Disney I wish to share my child hood memory's with every one! I grew up with this cartoon, and wish for every one else to watch them to! Please sit down and watch my child hood cartoon :D Enjoy | ["Music", "Quack"] | ["ducky quack sounds", "animated show", "distorted vocals", "funny", "animated show", "children’s show", "average quality audio", "people", "chattering", "ambient street noises", "tv show", "cartoony vocals", "happy", "cheerful", "orchestra playing", "organ accompaniment", "flutes playing", "medium tempo", "idyllic music", "show tune", "movie soundtrack"] | 1 | d352jaSSiFw | 3760 | |
Chipmunks & Chipettes Girls of Rock and Roll | Female singers sing in funny animated vocals. The song is medium tempo with a groovy bass line, keyboard accompaniment, arpeggiated harmony tones and steady drumming rhythm. The song is cheerful and energetic. The audio quality is average. | 2010-02-14T04:29:48Z | Stuart Danaher | A remake of the 1987 classic A Chipmunk Adventure. Summer 2009, Pioneer Museum Colorado Springs, CO. You could have done this.....but you didn't. Danielle, Sarah, E-mile-I, Justin, Taggart, Abel and Becca, thanks for making a boy's dream turn into an amazing reality. Crazy potatoes! | ["Music", "Roll", "Rock and roll"] | ["animated vocals", "medium tempo", "small adventures", "morals", "average audio quality", "tv show soundtrack", "comedy show", "tv show tune", "keyboard accompaniment", "percussive bass line", "arpeggiated sounds", "dance rhythm", "groovy rhythm", "funny show", "retro pop songs", "liens adventure", "sunday tv shows", "sounds", "children’s show"] | 1 | dEc7tV30KJo | 3771 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;