musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium tempo" and "youtube_published" is on date 2009-08-18
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- medium tempo · 2 ✖
- acoustic guitar 1
- alternative/indi 1
- amateur recording 1
- ambient street noises 1
- animated show 1
- average quality audio 1
- cartoony vocals 1
- chattering 1
- cheerful 1
- children’s show 1
- congas 1
- distorted vocals 1
- ducky quack sounds 1
- flutes playing 1
- funny 1
- happy 1
- idyllic music 1
- keyboard 1
- male backing vocals 1
- male higher voice singing 1
- movie soundtrack 1
- orchestra playing 1
- organ accompaniment 1
- people 1
- show tune 1
- tambourine 1
- tv show 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 | |
Portugal The Man "People Say" live at Twist & Shout, Denver, CO | Someone is strumming chords on an acoustic guitar singing along with a male voice in the higher register. male backing vocalists are supporting the singer. A piano is playing supportive chords along with congas and a tambourine. This is an amateur recording but of decent quality. This song may be playing live. | 2009-08-18T20:18:15Z | Suburbanhome | 8.14.09 live at Twist and Shout records in Denver, CO | ["Singing", "Country", "Music", "Tambourine"] | ["alternative/indi", "keyboard", "tambourine", "congas", "acoustic guitar", "male higher voice singing", "male backing vocals", "medium tempo", "amateur recording"] | 6 | gXOyw8a4_Xs | 4037 |
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;