musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "country music" and musiccaps_aspects contains "people talking"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- country music · 2 ✖
- people talking · 2 ✖
- acoustic guitar 1
- always with you 1
- amateur recording 1
- ambient noises 1
- ambient room noise 1
- auto harp 1
- autoharp accompaniment 1
- backup singers vocal harmony 1
- bad audio quality 1
- best day of my life 1
- bluegrass 1
- celebratory 1
- cheerful 1
- cheering 1
- clapping 1
- concert 1
- country folk music 1
- country love songs 1
- country romantic hits 1
- crying 1
- emotional 1
- enthusiastic 1
- fast tempo 1
- female singer 1
- festive 1
- gig 1
- guitar rhythm 1
- happy 1
- happy cheerful positive 1
- inferior audio quality 1
- keyboard accompaniment 1
- live performance 1
- lively 1
- male vocalists 1
- mandolin 1
- spirited 1
- steady drumming rhythm 1
- together forever 1
- vigorous banjo 1
- vivacious 1
- wedding dance 1
- wedding dance song 1
- youthful 1
musiccaps_names (array) 6 ✖
- Banjo 1
- Bluegrass 1
- Country 1
- Music 1
- Music of Latin America 1
- Rock and roll 1
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 | |
Suprise Thriller Wedding Dance!!! | A female singer sings this beautiful love song with backup singers in vocal harmony. The song is medium tempo with a steady drumming rhythm, percussive bass line, autoharp accompaniment, guitar rhythm and keyboard accompaniment. The song has poor audio quality and makes an excellent wedding dance song. | 2009-04-21T00:29:24Z | Jeffrey Brinkley | Me and my wife and kids suprised our guest with thriller!! | ["Music of Latin America"] | ["wedding dance", "female singer", "country music", "wedding dance song", "bad audio quality", "ambient room noise", "country love songs", "backup singers vocal harmony", "steady drumming rhythm", "keyboard accompaniment", "autoharp accompaniment", "guitar rhythm", "country romantic hits", "always with you", "together forever", "crying", "happy cheerful positive", "people talking", "emotional", "best day of my life"] | 1 | bPWbeWf5xNI | 3622 |
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;