musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "harp" and musiccaps_aspects contains "instrumental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- harp · 2 ✖
- instrumental · 2 ✖
- acoustic guitar 1
- ambient 1
- bass guitar 1
- bass lines 1
- bongos 1
- congas 1
- electric guitar 1
- folk pop 1
- generic 1
- hawaiian guitar 1
- joyful 1
- keyboard accompaniment 1
- mellow 1
- muffled music 1
- no singer 1
- people talking 1
- pleasant melody 1
- pop-rock 1
- positive 1
- regional pop 1
- soft 1
- steady bass lines 1
- string instrument harmony 1
- ukele 1
- ukulele 1
musiccaps_names (array) 4 ✖
- Music 2
- Musical instrument 1
- Steelpan 1
- Ukulele 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 | |
Jamaica Farewell / Island In The Sun | This song is an instrumental. The tempo is slow with a keyboard harmony, steady bass lines, congas and bongo rhythm and sound of an instrument like a harp and string instrument like a ukelele or Hawaiian guitar.The music is soft, mellow, pleasant and simple with the sound of people talking in the background. This is a Regional/Folk Pop instrumental. | 2008-02-17T15:07:09Z | Steel Drum Music | Now on iTunes → click the little tab button for the link and info → → → Caribbean classics played on steel drums from Trinidad. This song is featured on the 'Steel Drum Gold' album. You can get it at: iTunes - http://bit.ly/aE3djW Amazon - http://bit.ly/cgT7rA or directly from Bob Lyons' web site: http://www.SteelDrumMusic.net Steel drums at dinner party, Stranahan House, Fort Lauderdale, 2-13-08 | ["Music", "Musical instrument", "Steelpan"] | ["instrumental", "keyboard accompaniment", "congas", "string instrument harmony", "hawaiian guitar", "ukele", "steady bass lines", "regional pop", "folk pop", "pleasant melody", "bongos", "bass lines", "harp", "people talking", "soft", "mellow", "ambient", "muffled music"] | 7 | P996TZp25PM | 2512 |
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;