musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "banjo", musiccaps_aspects contains "country music" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 56 ✖
- banjo · 3 ✖
- country music · 3 ✖
- cheerful 2
- country folk music 2
- live performance 2
- acoustic guitar 1
- acoustic guitar accompaniment 1
- animated 1
- auto harp 1
- auto harp harmony 1
- bad audio quality 1
- cello 1
- child performers 1
- concert 1
- country bluegrass 1
- country dance music 1
- country folk song 1
- country pop 1
- country pop instrumental 1
- country song instrumental 1
- dance rhythm 1
- dobro 1
- dulcet 1
- emotional 1
- enthusiastic 1
- fast tempo 1
- fiddle 1
- fiddlers 1
- fun 1
- groovy rhythm 1
- guitar strumming 1
- high energy 1
- instrumental 1
- instrumental music 1
- live audience 1
- lively backup 1
- lively vocals 1
- male vocalist 1
- medium tempo 1
- mellifluous 1
- mellow 1
- merry 1
- never give up 1
- passionate 1
- peaceful 1
- positive 1
- regional music 1
- slow tempo 1
- soothing 1
- spirited 1
- steady drumming 1
- the country life 1
- the wild west 1
- traditional music 1
- violinists 1
- vocalisation 1
musiccaps_names (array) 12 ✖
- Music 3
- Musical instrument · 3 ✖
- Banjo 2
- Country 2
- Bluegrass 1
- Bowed string instrument 1
- Echo 1
- Electric guitar 1
- Guitar 1
- Plucked string instrument 1
- Song 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 |
---|---|---|---|---|---|---|---|---|---|---|
sleepy man banjo boys vs mountain rhythm | The song is instrumental. The tempo is medium with a prolific fiddler playing melody and a banjo and guitar accompaniment. The song is adventurous and exciting. The song is a classic country instrumental. The song has poor audio quality. | 2011-05-15T21:20:57Z | RubenProducciones | blatle of banjos. read the description: friends can go to this link and give it a like, would help me a lot to back up videos like this :) http://www.youtube.com/watch?v=g1I7seXs6O4 | ["Banjo", "Country", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["violinists", "country music", "fiddlers", "child performers", "instrumental music", "guitar strumming", "country folk music", "live performance", "groovy rhythm", "country dance music", "the country life", "the wild west", "dance rhythm", "passionate", "emotional", "spirited", "never give up", "cheerful", "positive", "traditional music", "bad audio quality", "country bluegrass", "banjo", "medium tempo"] | 1 | O84YjlJ_Qw4 | 2402 | |
EGIL SKJELNES - LOOK AT US | This music is a country song instrumental. The tempo is slow with a mellifluous Auto Harp harmony, steady drumming, rhythmic acoustic guitar, and subtle bass lines. The music is melodic, soothing, peaceful, nostalgic,mellow and dulcet Country Song Instrumental. | 2012-07-08T07:31:41Z | Steelnes | Homevideo Live July 2012 | ["Echo", "Electric guitar", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar"] | ["instrumental", "slow tempo", "steady drumming", "banjo", "dobro", "dulcet", "country pop instrumental", "peaceful", "acoustic guitar accompaniment", "auto harp harmony", "country music", "country pop", "country folk song", "country song instrumental", "mellow", "soothing", "mellifluous"] | 7 | XaUXJG0BZuk | 3198 | |
The Seldom Scene - After Midnight | A male vocalist sings this high energy Country Song. The tempo is fast with animated Banjo, fiddle, auto harp, acoustic guitar and cello. The song is cheerful, happy, enthusiastic, fervent, pulsating, buoyant and animated with vocalising and backup. This song is a spirited Country Folk Song. | 2008-01-14T14:52:51Z | BluegrassLibrary | John Duffey, Ben Eldridge, Mike Auldridge, Phil Rosenthal, & Tom Gray | ["Banjo", "Country", "Music", "Musical instrument", "Song", "Bluegrass"] | ["male vocalist", "fast tempo", "country music", "lively vocals", "lively backup", "banjo", "cello", "auto harp", "fiddle", "acoustic guitar", "country music", "country folk music", "vocalisation", "high energy", "fun", "merry", "cheerful", "live performance", "concert", "live audience", "enthusiastic", "animated", "regional music"] | 7 | q-sJu8CoZts | 4750 |
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;