musiccaps_details (view)
2 rows where musiccaps_aspects contains "funny" and musiccaps_aspects contains "show tune"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- funny · 2 ✖
- show tune · 2 ✖
- adrenaline rush 1
- amateur musician 1
- ambient room noises 1
- ambient street noises 1
- animated show 1
- average quality audio 1
- cartoony vocals 1
- chattering 1
- cheerful 1
- children’s show 1
- crowds cheering 1
- distorted vocals 1
- ducky quack sounds 1
- entertaining 1
- fast tempo 1
- fats tempo 1
- flutes playing 1
- funny video 1
- guitar accompaniment 1
- happy 1
- idyllic music 1
- joyful cheerful 1
- keyboard accompaniment 1
- live performance 1
- male singer 1
- medium tempo 1
- movie soundtrack 1
- orchestra playing 1
- organ accompaniment 1
- people 1
- people screaming 1
- poor audio quality 1
- positive 1
- strong drumming rhythm 1
- tambourine man 1
- tambourine percussions 1
- tv show 1
musiccaps_names (array) 3 ✖
- Music 2
- Quack 1
- Tambourine 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 | |
Tambourine Master Transforms Into Super Gonzo! | Asia’s Got Talent Semis 1 | The song is an instrumental track for a live performance act. The song is medium tempo with a male singer singing to a strong drumming rhythm, groovy bass line, keyboard accompaniment along with an amateur playing tambourine percussion. The song has poor audio quality. | 2015-04-16T13:52:34Z | Asia's Got Talent | It’s a bird, it’s a plane….no, no, it’s: SUPER GONZO! Watch the tambourine master transform and shake his tambourine for world peace! | ["Music", "Tambourine"] | ["live performance", "tambourine man", "fast tempo", "poor audio quality", "funny video", "crowds cheering", "ambient room noises", "people screaming", "amateur musician", "joyful cheerful", "positive", "funny", "entertaining", "adrenaline rush", "male singer", "fats tempo", "strong drumming rhythm", "guitar accompaniment", "keyboard accompaniment", "show tune", "tambourine percussions"] | 1 | fer_4HvG3aY | 3967 |
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;