musiccaps_details (view)
5 rows where musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "no percussion" and musiccaps_names contains "Plucked string instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- moderate tempo · 5 ✖
- no percussion · 5 ✖
- male voice 3
- no other instruments 3
- no vocal melody 2
- no voices 2
- romantic mood 2
- acoustic guitar 1
- amateur recording 1
- announcement 1
- banjo 1
- banjo song 1
- bluegrass 1
- country song 1
- distortion guitar 1
- double bass 1
- easy listening 1
- fingerstyle 1
- fingerstyle guitar 1
- flamenco 1
- folk song 1
- guitar 1
- guitar song 1
- harmonics 1
- heavy metal 1
- instructional audio 1
- instrumental 1
- mandolin 1
- minimal instruments 1
- octaves 1
- patriotic song 1
- pop song 1
- relaxing song 1
musiccaps_names (array) 14 ✖
- Music 5
- Plucked string instrument · 5 ✖
- Musical instrument 3
- Acoustic guitar 2
- Banjo 2
- Guitar 2
- Speech 2
- Strum 2
- Bluegrass 1
- Bowed string instrument 1
- Flamenco 1
- Harmonic 1
- Mandolin 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 |
---|---|---|---|---|---|---|---|---|---|---|
How to Play Trust by Megadeth Guitar Lesson (w/ Tabs!!) | This song features a distortion guitar. This is an instructional video. The song features an open note followed by the octave. Then a descending pattern is played on the distortion guitar. The voice gives instructions on how to play the pattern. There is no percussion in this song. There are no other instruments in this song. There is no vocal melody in this song. | 2009-03-15T04:06:25Z | m169marroquin | http://www.ObeyYourMATTster.com | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["distortion guitar", "heavy metal", "male voice", "instructional audio", "octaves", "no other instruments", "no percussion", "no vocal melody", "moderate tempo"] | 0 | 52odOK7G2kg | 628 | |
Bell’s Harmonic | This instrumental pop song features an acoustic guitar being played fingerstyle. The notes are being plucked. Guitar harmonics are played in between the plucked notes. This song is played at a moderate tempo. There is no percussion in this song. There are no other instruments in this song. The mood of this song is relaxing. This song can be played in a coffee shop. | 2015-12-10T22:08:52Z | Alan Gogoll | Become a Supporter: https://www.youtube.com/channel/UC8NhGqX78q_bsuYtP-K9Oig/join Bell's Harmonic by Alan Gogoll 💿 Stream/Support → https://open.spotify.com/playlist/37i9dQZF1DZ06evO4C2uGb 🌅 Website → https://www.alangogoll.com Seahorse Bells is the fifth studio album from Australian Solo Acoustic Guitarist Alan Gogoll. Each of the five original compositions showcases Alan's original 'Bell Harmonics' technique and guitar tunings that have become his signature sound and featuring for the first time his signature Paul Mineur guitar. | ["Guitar", "Acoustic guitar", "Music", "Strum", "Harmonic", "Plucked string instrument"] | ["pop song", "acoustic guitar", "fingerstyle", "harmonics", "moderate tempo", "no percussion", "no other instruments", "no voices", "easy listening", "relaxing song"] | 0 | 9xV0nmojVeg | 1051 | |
David Serva por Seguiriya | This song features a guitar being played to a flamenco melody. Fingerstyle guitar is used. The song starts off at a higher register and ends at the lower register. The guitar is strummed at intervals. There are no other instruments in this song. There are no voices in this instrumental song. This song has a romantic mood. This song can be played at a quiet restaurant overlooking the sunset. | 2010-05-08T16:19:56Z | Dararith Long | David Jones (Serva) por Seguiriya in one of his public recordings. I really like the intro. The bulerias ending is quite nice as well. About the life of Serva: http://www.sfflamenco.com/historical/features/2002-04/balladofgypsydavy.html | ["Flamenco", "Acoustic guitar", "Music", "Strum", "Plucked string instrument"] | ["guitar song", "flamenco", "fingerstyle guitar", "no other instruments", "no voices", "instrumental", "moderate tempo", "romantic mood", "no percussion"] | 0 | EIzBD62ja8E | 1543 | |
Memphis Yodel | This amateur recording features a male voice singing the main melody. This is accompanied by a banjo being strummed in a country rhythm. This song is sung at a moderate tempo. This song has a patriotic feel. There are no other instruments in this song apart from the tenor banjo. This song can be played in a patriotic American movie. | 2008-12-23T05:34:54Z | lewdite | This is one of my favorite Jimmie Rodgers songs. Recorded in 1928. Here I am with my trusty tenor banjo. I recorded this song with my friend Johnny Fast. He has a fantastic voice (I do the yodeling) and to make it easy for you to check it out I've posted as a video response. THE WORDS & CHORDS TO THIS SONG AT: www.youtube.com/LDsongscreen | ["Banjo", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["country song", "banjo song", "amateur recording", "no percussion", "male voice", "moderate tempo", "folk song", "minimal instruments", "patriotic song"] | 0 | LFYRuK8YstI | 2168 | |
We'll Meet Again Sweet Heart- Japanese bluegrass Band in Korea.wmv | This bluegrass song starts off with a male voice making an announcement. The music starts to play. The banjo plays an introductory bluegrass lick. This is accompanied by an acoustic guitar strumming chords. The double bass plays the root note and the fifth of the chord. The mandolin plays the rhythm section in the song. There is no vocal melody in this song. There is no percussion in this song. This song can be played in a movie with a Western theme. | 2010-11-25T14:46:00Z | sun shin | ["Banjo", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bowed string instrument"] | ["bluegrass", "male voice", "announcement", "no percussion", "no vocal melody", "mandolin", "guitar", "banjo", "double bass", "moderate tempo", "romantic mood"] | 0 | oyAAhjGTNvQ | 4671 |
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;