musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "no other instruments" and musiccaps_names contains "Inside, small room"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- instrumental · 3 ✖
- no other instruments · 3 ✖
- no voices 3
- electric guitar 2
- acoustic guitar 1
- blues vibe 1
- fingerpicking 1
- flanger effect 1
- guitar effects 1
- pentatonic scale 1
- romantic melody 1
- slow tempo 1
musiccaps_names (array) 10 ✖
- Guitar 3
- Inside, small room · 3 ✖
- Music 3
- Musical instrument 3
- Plucked string instrument 3
- Chorus effect 1
- Distortion 1
- Effects unit 1
- Electronic tuner 1
- Reverberation 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Brothers in Arms (Dire Straits)- Acoustic Fingerstyle Guitar | This song features a melody played on an acoustic guitar. Delay and reverb effects are added to the sound. This song starts off with notes being fingerpicked. The second bar involves a chord being held and allowed to ring for four counts. This is followed by a double stop and then descending notes played with a higher open string. The melody is romantic. There are no voices in this song. This song can be played in a romantic movie. | 2012-10-29T23:27:22Z | Yoni Schlesinger | Full Tutorial & Tabs are available on my website https://www.yonischlesinger.com/post/brothers-in-arms-dire-straits-tutorial-tabs You can also get it through me. Contact me here for more details mishloa44@gmail.com Acoustic Guitar Fingerstyle for Brothers in Arms by the great Dire Straits. Performed and arranged by Yoni Schlesinger. ========================================================== * Can't wait for my public tutorial of this song? *Wish to learn it in another key, style or easier version? * Want me to teach you any other song in my style, even one I haven't performed already on my chanel? Now you can get it- Personal Video Tutorial by Me, in a Fair Price :) For more details, please contact me here: Mishloa44@gmail.com ===================================================== * For more Videos and Tutorials, please support the Chanel :) https://www.paypal.me/yonischlesinger My website https://www.yonischlesinger.com/ Instagram: https://www.instagram.com/yonischlez/ Facebook Page: https://www.facebook.com/yonischlez/ Wisio: https://www.wisio.com/YoniSchlesinger Cheers! | ["Reverberation", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["acoustic guitar", "fingerpicking", "guitar effects", "no other instruments", "no voices", "instrumental", "slow tempo", "romantic melody"] | 0 | P0vjXnnIiR4 | 2491 | |
Vox Valvetronix VT20+ Demo | This is a clip featuring an electric guitar being played through an amp. First a chord is played. This is followed by a descending pentatonic lick being played. This lick has a blues feel. This is an instrumental song. There are no voices in this song. There are no other instruments in this song. | 2011-02-28T21:58:24Z | lucidspoon | A quick demo of a few of the Vox Valvetronix VT20+ amp models. | ["Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["electric guitar", "pentatonic scale", "no other instruments", "no voices", "instrumental", "blues vibe"] | 0 | QZNrK337wow | 2627 | |
MXR Micro Flanger | This song features an electric guitar playing arpeggiated chords. The guitar is playing with a flanger effect added to change the tone. There are no other instruments in this song. There are no voices in this song. This is an instrumental song. This song can be used in an instructional video on an effects processor. | 2008-12-27T17:59:29Z | blondegraemey | Vintage MXR Micro Flanger with crumbling foam problem! Description and demonstration. | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion", "Inside, small room"] | ["electric guitar", "flanger effect", "no other instruments", "no voices", "instrumental"] | 0 | wYtd_Sq2-Tw | 5274 |
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;