musiccaps_details (view)
1 row where musiccaps_aspects contains "funk jazz hits" and musiccaps_aspects contains "slick drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- emotional 1
- energising 1
- funk jazz hits · 1 ✖
- funky jazz music 1
- funny pranks 1
- funny tones 1
- funny video soundtrack 1
- groove 1
- groovy bass line 1
- guitar strumming 1
- instrumental music 1
- just for laughs 1
- keyboard accompaniment 1
- medium tempo 1
- slick drumming rhythm · 1 ✖
- spirited 1
- trimmer tones 1
- youtube funny videos 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sleeping Haircut PRANK | OmarGoshTV | The song is an instrumental. The song has ambient room noises like hair trimming tones and funny tones. The song has slick drumming rhythm, groovy bass line, guitar rhythm and keyboard accompaniment. The song is groovy and funny. The song is a soundtrack for a funny prank video. | 2014-09-20T00:12:04Z | OmarGoshTV | I went to my uncle's new barber shop and set up one of his barbers to cut my hair. He has never met me and in for a real treat. This idea was inspired by people falling asleep in my chair while I did their hair. New videos every WED & SAT! SUBSCRIBE to OmarGoshTV ⇩ http://bit.ly/Sub2OmarGoshTV FOLLOW my other channel for DAILY videos ⇩ http://youtube.com/c/theomargosh CONNECT WITH ME ON SOCIAL MEDIA ⇩ http://Instagram.com/omargoshtv http://Twitter.com/omargoshtv Snapchat: @theomargosh SEND US SOME FAM MAIL ⇩ P.O. Box 11098 Spring Hill, FL 34610 CREDITS & SHOUTOUTS: Film by: OmarGoshTV All Rights Reserved and protected against unauthorized use. About OmarGoshTV: I go to some of the scariest places at NIGHT that most people wouldn't dare to GO during the day. Join me on a HAUNTED SCARY ADVENTURE! New videos every WED & SATURDAY at 4PM. Sleeping Haircut PRANK | OmarGoshTV https://www.youtube.com/watch?v=qm8sJxsZ5VY OmarGoshTV https://www.youtube.com/OmarGoshTV | ["Electric shaver, electric razor", "Music", "Inside, small room"] | ["funky jazz music", "instrumental music", "medium tempo", "funny pranks", "medium tempo", "youtube funny videos", "just for laughs", "funny video soundtrack", "funny tones", "guitar strumming", "funk jazz hits", "energising", "emotional", "spirited", "groove", "trimmer tones", "groovy bass line", "keyboard accompaniment", "slick drumming rhythm"] | 1 | qm8sJxsZ5VY | 4818 |
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;