musiccaps_details (view)
3 rows where musiccaps_aspects contains "banjo" and musiccaps_aspects contains "melodic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- banjo · 3 ✖
- melodic · 3 ✖
- country music 2
- instrumental 2
- violin 2
- acoustic guitar 1
- american 1
- beseeching 1
- bluegrass 1
- country pop 1
- country song 1
- country songs 1
- easygoing 1
- emotional 1
- engaging 1
- fast tempo 1
- fiddle 1
- folk 1
- folk music 1
- keyboard accompaniment 1
- lively 1
- male singer 1
- mandolin 1
- medium fast tempo 1
- pleading 1
- pleasant 1
- popping sound 1
- prayer 1
- regional music 1
- request 1
- resonator 1
- rhythmic drumming 1
- sentimental 1
- skilful 1
- snappy 1
- soft 1
- spirited 1
- spirited string arrangement 1
- steady bass 1
- stringed instrument 1
- vibration 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Little Rock Getaway Performed by Daniel Patrick | This music is a lively Banjo instrumental. The tempo is fast with the musician dexterously playing a very spirited, vivacious and complex harmony. There is no other instrument accompaniment. This instrument is often heard in Country and Bluegrass. | 2009-03-21T18:53:07Z | James Duckworth | Number one of a session of seven song I was privileged to video of the young 14 year old self taught banjo talent Daniel Patrick from my area. Sit back enjoy the tune. Look for the others soon. www.danielpatrickandfamily.com | ["Banjo", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["instrumental", "fast tempo", "banjo", "stringed instrument", "country music", "folk music", "bluegrass", "popping sound", "snappy", "vibration", "lively", "spirited", "melodic", "engaging", "pleasant", "skilful"] | 7 | BWvKAcOV_co | 1251 | |
Avenged Sevenfold-Dear God Lyrics | A male vocalist sings this melodious country song. The tempo is medium with rhythmic acoustic guitar, fiddle, resonator, banjo, dobro and mandolin accompaniment, keyboard harmony, steady drumming and straight bass lines. The song is mellow, emotional, prayerful, pleading, sentimental, passionate and melodious. This song is Country Pop. | 2009-12-31T14:57:13Z | ComedyGHN | Avenged Sevenfold - Dear God Lyrics! AMAZING TUNE! SUBSCRIBE ;D | ["Music", "Roll"] | ["male singer", "medium fast tempo", "country song", "pleading", "request", "country pop", "spirited string arrangement", "acoustic guitar", "fiddle", "resonator", "banjo", "mandolin", "violin", "rhythmic drumming", "steady bass", "keyboard accompaniment", "country music", "country songs", "regional music", "soft", "melodic", "prayer", "beseeching", "emotional", "sentimental"] | 7 | OI7S7vaBT4I | 2424 | |
Cluck Old Hen. This time with song and fretless mountain banjo. | This is an instrumental folk song with the melody played both by a banjo and a violin at the same time. The combination of these instruments creates a very American, western-movie type of atmosphere. It could be used in opening sequences of movies/shows taking place in rural USA. | 2010-09-08T22:41:56Z | Jesper Deleuran | Tobias Enevoldsen and I playing Cluck Old Hen tonight. I play on a fretless mountain banjo build by John Peterson. Look him up here: http://www.youtube.com/user/frailingbanjo | ["Banjo", "Music", "Bluegrass"] | ["banjo", "violin", "folk", "easygoing", "melodic", "instrumental", "american"] | 9 | flLjMZMydXc | 3975 |
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;