musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "no other instruments" and musiccaps_author = 0
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Guitar Harmonica WildWood Flower Folk music Country rack blues | This folk song features a harmonica playing the main melody. This is accompanied by an acoustic guitar strumming chords. There are no other instruments in this song. This is an instrumental song. There are no voices in this song. The mood of this song is upbeat and happy. This song can be played in a movie scene involving a highway drive. | 2008-06-01T07:49:24Z | Matthew Shelton | http://harmonicasuperstart.com/ Guitar and Harmonica simultaneously played: WildWood Flower Folk to Country styles, same song, 1 harmonica, two different keys. Go to HarmonicaSuperStart.com for more great info on playing the harmonica | ["Harmonica", "Wind instrument, woodwind instrument"] | ["harmonica", "acoustic guitar", "country song", "folk song", "no voices", "instrumental", "no percussion", "no other instruments", "moderate tempo", "upbeat"] | 0 | fWfQxB2pVrc | 3952 | |
Dust In The Wind - Vocal Cover. | This slow rock song starts with an acoustic guitar playing chords in fingerstyle. For each chord, a pedal bass note is played while the higher pitch notes are played in a repeated sequence of three notes being played one after the other. A male voice sings the main melody. There are no other instruments in this song. This song can be played in a movie scene where a car is driving across a deserted highway. | 2009-10-12T20:44:26Z | Aaron James Haslam Guitar Covers | This is my dads cover of the great Kansas song Dust in the wind. He's wanted to record this song for a long time so we decided to get him into our home studio. Recorded raw onto a backing track. Pretty good I think you'll agree? Look out for our original tunes coming soon! | ["Music", "Bluegrass"] | ["slow rock song", "male voice", "acoustic guitar", "fingerstyle guitar", "moderate tempo", "no other instruments", "no percussion", "pedal bass notes"] | 0 | wc4UEh8wvCA | 5278 |
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;