musiccaps_details (view)
3 rows where musiccaps_aspects contains "country music" and musiccaps_aspects contains "melodic" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- country music · 3 ✖
- melodic · 3 ✖
- banjo 2
- folk music 2
- instrumental 2
- regional music 2
- acoustic guitar 1
- beseeching 1
- bluegrass 1
- charming 1
- cheerful 1
- classical 1
- country pop 1
- country song 1
- country songs 1
- emotional 1
- engaging 1
- fast tempo 1
- fiddle 1
- flute 1
- folk song 1
- hand percussion 1
- keyboard accompaniment 1
- lively 1
- madal 1
- male singer 1
- mandolin 1
- medium fast tempo 1
- medium tempo 1
- pleading 1
- pleasant 1
- popping sound 1
- prayer 1
- request 1
- resonator 1
- rhythmic drumming 1
- sarangi 1
- sentimental 1
- shakers 1
- skilful 1
- snappy 1
- soft 1
- spirited 1
- spirited string arrangement 1
- steady bass 1
- string instrument 1
- stringed instrument 1
- vibration 1
- violin 1
musiccaps_names (array) 7 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Baraha Jewellery, Jordan, Hong Kong | This music is instrumental. The tempo is slow with a harmonious melody of string instruments, percussion and wind instruments which sound like the Indian Sarangi, dhol or madal , shakers and a flute. The music is classical, simple, enchanting and melodic. This song is a Folk song Instrumental. | 2012-09-06T16:53:26Z | DigitalEyeHK | Baraha Jewellery, Jordan, Hong Kong. www.barahajewellery.com. FOR MORE VIDEO http://www.jpthk.com | ["Traditional music", "Music"] | ["instrumental", "medium tempo", "flute", "string instrument", "cheerful", "charming", "classical", "melodic", "sarangi", "madal", "folk music", "country music", "regional music", "folk song", "shakers", "hand percussion"] | 7 | otVPTo72q4w | 4662 | |
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 |
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;