musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "mandolin"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- acoustic guitar 3
- amateur recording · 3 ✖
- mandolin · 3 ✖
- ambient noises 1
- auto harp 1
- bluegrass 1
- celebratory 1
- cheerful 1
- cheering 1
- clapping 1
- concert 1
- country folk music 1
- country music 1
- country/folk 1
- e-bass 1
- enthusiastic 1
- fast tempo 1
- festive 1
- flutes 1
- gig 1
- happy 1
- inferior audio quality 1
- live performance 1
- lively 1
- male and female voices singing 1
- male vocalists 1
- medium tempo 1
- medium to uptempo 1
- people talking 1
- percussion 1
- spirited 1
- upright bass 1
- vigorous banjo 1
- violin 1
- vivacious 1
- whistling 1
- youthful 1
musiccaps_names (array) 11 ✖
youtube_description 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Muddy Hill Boys - Bluegrass To Rockin'The Country Jamboree | A group of male vocalists sing this happy, upbeat country /bluegrass song. The tempo is fast with vigorous and animated acoustic guitar, banjo, mandolin and auto harp lead and harmony. The song is a live performance with ambient sounds of clapping, cheering and people talking. This song is a cheerful Country Pop/Bluegrass song. | 2015-04-05T21:37:46Z | chrisdixie1 | https://www.facebook.com/themuddyhillboys?fref=ts Rockin' The Country Jamboree N°1 - à TOURS 37 FRANCE organisé par DiscOldies le 28/03/2015 | ["Banjo", "Country", "Music", "Rock and roll", "Bluegrass"] | ["male vocalists", "fast tempo", "cheerful", "happy", "acoustic guitar", "vigorous banjo", "auto harp", "mandolin", "ambient noises", "clapping", "cheering", "people talking", "live performance", "gig", "concert", "cheering", "country music", "country folk music", "bluegrass", "inferior audio quality", "amateur recording", "lively", "spirited", "enthusiastic", "vivacious", "youthful", "happy", "celebratory", "festive"] | 7 | 0XxinBtKouQ | 179 | |
Kjarkas - Yo no he nacido para sufrir HD | This song contains someone strumming a melody on a mandolin while more people are whistling along. Then a mandolin, an e-bass and an acoustic guitar are playing a short melody in a lower key before breaking into the next part along with flutes and percussions. This song may be played outside by musicians performing. | 2016-07-07T01:47:40Z | calacas555 | Tema que será parte de la nueva producción cdgráfica del grupo Kjarkas denominado la Leyenda Viva | ["Folk music", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "acoustic guitar", "e-bass", "mandolin", "flutes", "whistling", "percussion", "medium tempo"] | 6 | ZTVMsW1h3bI | 3379 | |
Rooster Song | This song contains an upright bass playing a simple bassline along with an acoustic guitar strumming chords and a mandolin playing a fast paced melody. A violin is ending the phrase in the mid range. Then male and female voices are singing with the female voice being the lead voice. In the background you can hear the crowd laughing. This song may be playing as a local concert. | 2007-01-11T22:59:38Z | Phil Greer | Timberline's most requested song... | ["Banjo", "Music", "Musical instrument", "Violin, fiddle", "Bowed string instrument"] | ["country/folk", "upright bass", "acoustic guitar", "violin", "mandolin", "male and female voices singing", "medium to uptempo", "amateur recording"] | 6 | j0UMI2DrnMA | 4229 |
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;