musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "bass guitar" and musiccaps_names contains "Ukulele"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- acoustic guitar · 2 ✖
- bass guitar · 2 ✖
- instrumental 2
- easy listening 1
- electric guitar 1
- generic 1
- guitar solo 1
- happy mood 1
- harp 1
- jazz song 1
- joyful 1
- moderate tempo 1
- no singer 1
- no voices 1
- percussion 1
- pop-rock 1
- positive 1
- ukulele 1
youtube_published (date) 2 ✖
- 2013-03-28 1
- 2014-10-14 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
❤ My Morning Routine ❤ | This is an instrumental pop-rock piece. There is a harp playing the main melody while a ukulele is strumming chords. An electric guitar and a bass guitar join the melodic background later on. A simple acoustic drum beat is in the rhythmic background. It has a joyful aura, but the sounds used are very generic. The best use for this piece could be the background of a tutorial/instructive type of video. | 2013-03-28T02:56:49Z | Ashley Love | My morning routine is finally up! Enjoy :) Thanks for watching. Subscribe to make my day. Instagram: Ashley_Tan13 Twitter: AshleyLovesx My previous video: http://www.youtube.com/watch?v=IlYuPAAD7AI Ask me questions here: http://www.spillit.me/ashleylovesx Subscribe to my friend(Mark O'dea), he is an amazing singer!! Check him out :) http://www.youtube.com/user/markodea/videos?view=0 Love, Ashley | ["Music", "Ukulele"] | ["pop-rock", "no singer", "instrumental", "ukulele", "harp", "electric guitar", "bass guitar", "acoustic guitar", "generic", "joyful", "positive"] | 9 | Mwy5Y0S5jfM | 2311 | |
10 Footballers Who Didn't Fulfil Their Potential | This jazz song features a guitar solo. This is accompanied by percussion playing a simple beat. An acoustic guitar strums chords on each count of the bar. The bass plays the root notes of the chords. There are no voices in this song. The song has a happy mood. This song can be played in a coffee shop. | 2014-10-14T16:41:19Z | talkSPORT | Every Tuesday we bring you a sporting top 10. Disagree with our list? Get stuck in with a comment! Check out http://talksport.com for more sport entertainment SUBSCRIBE to get more funny videos delivered right to your subscription feed: http://bit.ly/Hu3sIN FOLLOW us on Twitter and tell us what else you want to watch on talkSPORT's YouTube channel: http://bit.ly/IiA1t2 LIKE us on Facebook to join the world's best sporting debates: http://on.fb.me/HAm7Gn | ["Music", "Ukulele"] | ["jazz song", "acoustic guitar", "guitar solo", "bass guitar", "instrumental", "no voices", "percussion", "moderate tempo", "easy listening", "happy mood"] | 0 | iBH5X5SKirU | 4164 |
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;