musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "joyful" and musiccaps_aspects contains "no singer"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- acoustic guitar · 3 ✖
- instrumental 3
- joyful · 3 ✖
- no singer · 3 ✖
- banjo 1
- bass guitar 1
- bluegrass 1
- easygoing 1
- electric guitar 1
- fiddle 1
- generic 1
- harp 1
- irish folk music 1
- lively 1
- mandolin 1
- pastoral 1
- playful 1
- pop-rock 1
- positive 1
- rural 1
- steady tempo 1
- uilleann pipes 1
- ukulele 1
- uplifting 1
- vibrant 1
musiccaps_names (array) 10 ✖
- Music 3
- Bluegrass 2
- Banjo 1
- Flamenco 1
- Folk music 1
- Gospel music 1
- Music of Bollywood 1
- Music of Latin America 1
- Traditional music 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ROZBĚH BLUEGRASS MUSIC | This is a bluegrass music piece. There is a mandolin playing the main tune as the lead while a banjo and an acoustic guitar are supporting it in the melodic background. There is a joyful feeling to this piece. It could be used in the soundtrack of a movie or a TV show with a rural setting. It could also be used in the background of pastoral social media content. | 2011-08-25T14:41:30Z | honzabaseman | 00. Úvod 01. MATTERHORN 02. PLEASE SEARCH A HEART 03. FOX ON THE RUN 04. HROU ZÍSKÁŠ HROW 05. SALT CREEK 06. ZÁTOKA 07. NOČNÍ VLAK 08. ZLATÁ RYBKA 09. BLACK DIAMOND 10. PÁDÍ MISSISSIPPI 11. FOGGY MOUNTAIN BREAKDAUN 12. KAROLÍNA 13. SVÍCEN ZMIZEL V TMÁCH 14. ARKANSAS TRAVELLER 15. PÝCHA PŘEDCHÁZÍ PÁD 16. PŘÍSAHEJ 17. SAIL TO AUSTRALIA | ["Gospel music", "Folk music", "Flamenco", "Music", "Music of Bollywood", "Music of Latin America", "Bluegrass"] | ["bluegrass", "no singer", "instrumental", "banjo", "mandolin", "acoustic guitar", "playful", "joyful", "uplifting", "easygoing", "rural", "pastoral"] | 9 | 0-7PyzhzuYQ | 108 | |
❤ 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 | |
Seán McKeon, Conor McEvoy, John Blake - Traditional Irish Music from LiveTrad.com | This is an Irish folk music piece. There is no singer. The main melody is being played by the uilleann pipes and the fiddle at a high pitch. The acoustic guitar is playing a rapid procession of chords in the background. The atmosphere is lively. This piece could be playing in the background at an Irish pub. It could also be used in the soundtracks of movies and TV shows that have a theme with an Irish influence. | 2012-02-17T12:56:44Z | Livetrad | http://www.livetrad.com Performing a number of reels during a benefit concert for 'Aid Japan for Children', a group working with survivors of the earthquake and tsunami in Japan in 2011. This video was recorded by Martin Moylan at St. Anne's Church on Dawson St., Dublin 2 and we're delighted to add it to the LiveTrad YouTube channel. For more info see 'Aid Japan for Children' on Facebook. | ["Banjo", "Traditional music", "Music", "Bluegrass"] | ["irish folk music", "no singer", "instrumental", "uilleann pipes", "fiddle", "acoustic guitar", "vibrant", "joyful", "lively", "steady tempo"] | 9 | NwA9JSlK_lM | 2378 |
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;