musiccaps_details (view)
2 rows where musiccaps_aspects contains "emotional" and "youtube_published" is on date 2011-02-21
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- emotional · 2 ✖
- average audio quality 1
- celtic music 1
- country music 1
- exciting 1
- fiddler 1
- french horns 1
- groovy music 1
- guitar strumming 1
- home music video 1
- instrumental music 1
- medium tempo 1
- mome music video 1
- orchestral piece 1
- playful 1
- relaxing 1
- slow tempo 1
- spirited 1
- traditional folk music 1
- traditional percussion instruments 1
- violin 1
- violins playing 1
- warm 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
8 Year Old Jonny Mizzone - Flint Hill Special - Sleepy Man Banjo Boys | The song is an instrumental. The song is slow tempo with a fiddler plays a rhythmic melody accompanied by a guitar accompaniment and other percussive instruments. The song is spirited and energetic. The song has country or Celtic influences. The song has average quality audio. | 2011-02-21T02:57:35Z | Sleepy Man | Our new single "Rain" https://www.youtube.com/watch?v=ZcoOKXrJqY0 http://sleepyman.com **From 2011** Another bedroom practice of Earl Scruggs's Flint Hill Special. Brothers Jonny Mizzone age 8 on banjo, Robbie Mizzone age 12 on fiddle, and Tommy Mizzone age 13 on guitar. http://www.sleepymanbanjo.com http://facebook.com/sleepymanbanjo | ["Banjo", "Music"] | ["fiddler", "instrumental music", "celtic music", "spirited", "home music video", "exciting", "traditional folk music", "violin", "average audio quality", "mome music video", "groovy music", "traditional folk music", "guitar strumming", "traditional percussion instruments", "emotional", "playful", "exciting", "country music", "violins playing", "medium tempo"] | 1 | I3qbB4Kq3Y0 | 1869 | |
은혜 삼일 POP 2집 | This sounds like the ending of a big orchestral piece, with the brass section sustaining a harmony at the end. The piece feels warm, relaxing and emotional. | 2011-02-21T15:57:51Z | PraiseGodHere | 은혜로다 주의 은혜 삼일 POP 2집 | ["Music", "Sad music"] | ["french horns", "orchestral piece", "warm", "relaxing", "emotional", "slow tempo"] | 3 | Z6q5doznOcI | 3341 |
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;