musiccaps_details (view)
2 rows where musiccaps_names contains "Electric guitar" and musiccaps_names contains "Psychedelic rock"
This data as json, CSV (advanced)
musiccaps_names (array) 7 ✖
- Electric guitar · 2 ✖
- Music 2
- Psychedelic rock · 2 ✖
- Blues 1
- Guitar 1
- Progressive rock 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blues Music - A 30 Min Mix Of Great Blues! Modern Blues Compilation | An acoustic drum is playing a 3/3 groove along with a bass. Two e-guitars are playing melodie while one of the e-guitars is highly distorted and takes the lead with a loud and wild melody in the higher register. This song may be playing in a bar. | 2014-06-29T07:00:02Z | MUSIC NATION by KENNETH ST. KING | 30 minutes of FREE excellent modern Blues Music. Please enjoy and share! SET - LIST: 0:00 Shining Light Blues 1:46 Front Porch Boogie 4:33 Super Session Blues 6:54 Mississippi Bender 10:03 Sad & Lonely Blues 13:01 Delta Dog Days 16:09 Kenny's Shuffle 18:57 Cinnamon Sedge 22:43 Kathy's Choice 24:41 Banjo Bangle 25:57 Chilled Blues On Ice 28:07 Strip Trip Photo credits: Feliciano Guimaraes @ Flickr.com link here: https://www.flickr.com/photos/jsome1/477100921/ Additional Music Credits audionautix@ http://audionautix.com/ incompetech@ http://incompetech.com/ Photo use via Creative Commons.Org license found here: https://creativecommons.org/licenses/by/2.0/deed.en_CA Music use via Creative Commons.Org found here: http://creativecommons.org/licenses/by/3.0/ Thanks! ~Kenneth St. King | ["Blues", "Electric guitar", "Music", "Psychedelic rock"] | ["bluesrock", "e-guitars", "e-bass", "acoustic drums", "slow tempo"] | 6 | AjLuenrAsbE | 1160 | |
喃語 LIVE @札幌SOUND CRUE 2015/11/03 | The song is an instrumental. The song is medium tempo with a groovy drumming rhythm, percussive bass line and cool electric guitar riff played repeatedly. The song is exciting and energetic. The song has smooth jazz or funk jazz roots. | 2015-11-18T13:14:34Z | YASASHIIKIMOCHI RECORDS | 2015/11/03@札幌SOUND CRUE 忍者ワールド 0:00 https://youtu.be/BTE_WG2fiT8 山の巨大ゴリラ村を荒らす 05:02 https://youtu.be/qPwVkHXKdsI 清らかな生き物 09:10 https://youtu.be/guj0H2Pdvcg 映像撮影・編集 つるりん こんちゃん てるてる 音声編集 北川 昭行 (Hello Micro Computer) 喃語(nango) http://naango.tumblr.com/ Twitter https://twitter.com/naaango Soundcloud http://soundcloud.com/nang0 Facebook https://www.facebook.com/naaaango | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Psychedelic rock", "Progressive rock"] | ["electric guitar lead", "live performance", "live band", "guitar band", "exciting", "instrumental music", "adrenaline rush", "energetic", "electric guitar riff", "live audience", "entertaining", "funk jazz", "groovy drumming rhythm", "percussive bass line", "cymbals crashing", "improvisational music", "jazz funk", "smooth jazz", "groovy music", "medium fast tempo"] | 1 | Nqb7nw58q08 | 2370 |
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;