musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "moderate tempo" and musiccaps_names contains "Strum"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- acoustic guitar · 2 ✖
- moderate tempo · 2 ✖
- amateur recording 1
- easy listening 1
- fingerstyle 1
- folk song 1
- harmonics 1
- male voice 1
- no other instruments 1
- no percussion 1
- no voices 1
- pop song 1
- relaxing song 1
- romantic feel 1
- shaker 1
- violin 1
musiccaps_names (array) 8 ✖
- Acoustic guitar 2
- Music 2
- Strum · 2 ✖
- Bluegrass 1
- Guitar 1
- Harmonic 1
- Plucked string instrument 1
- Steel guitar, slide guitar 1
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 | |
Derick Mar09 Irish Heartbeat | This folk song features a male voice singing the main melody. This is accompanied by an acoustic guitar. A shaker plays in place of the percussion. Violins play a melody in the background. The mood of this song is romantic. This song can be played in a flashback scene of a movie. | 2009-04-10T22:33:44Z | Ken Persson | Copyright music and lyrics reproduced by kind permission of Exile for original, exclusive performances by Van Morison, check-out the official channel at www.youtube.com/officialexilefilms. Recorded at a practice of Irish Street for a St Patrick's Day performance at Muldoon's. From L to R, Eileen, bodhran, Derick, vocals & guitar, Margaret, accordion, Brendan, fiddle, and Ken, whistle. | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Bluegrass"] | ["amateur recording", "acoustic guitar", "male voice", "shaker", "violin", "folk song", "romantic feel", "moderate tempo"] | 0 | etmmUjsRNRs | 3903 |
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;