musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "lively" and musiccaps_author = 7
This data as json, CSV (advanced)
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 | |
HONK - Hesitation | This music is instrumental. The tempo is fast with trumpet harmony, keyboard accompaniment, infectious drumming, syncopated, funky bass lines, lively piano and electric and acoustic guitar riffs. The music is upbeat, groovy, complex harmony, ambient, soulful and funky. This song is Funk Soul; | 2010-05-19T16:30:27Z | 123c123c123c | Honk - Honk LP :: 1974 | ["Swing music", "Music", "Soul music"] | ["instrumental", "fast tempo", "rock", "blues", "trumpets", "lively spirited", "complex harmony", "complex chords", "cymbal rides", "dance groove", "peppy", "perky", "vivacious", "keyboard harmony", "piano accompaniment", "groovy bass lines", "acoustic guitar", "electric guitar", "slick drumming", "trumpets", "lively", "ambient", "soothing", "improvisation", "soul", "funk/soul", "rhythmic", "dance groove", "syncopated bass lines", "rhythmic counter play", "infectious drum grooves"] | 7 | 2sIfE3KOi5s | 410 | |
Are Kahe Ko Kahe Ko - Shashi Kapoor - Zeenat Aman - Chori Mera Kaam - Bollywood Songs - Asha Bhosle | This song is a Retro Hindi movie song. The tempo is fast with rhythmic guitar, vigorous guitar, keyboard harmony, congas and bongos. The music is minimalistic and simple with speech like singing. The song is playful, cheerful, upbeat, youthful and energetic. | 2012-06-04T11:06:50Z | Shemaroo Filmi Gaane | Movie : Chori Mera Kaam (1975) Music Director: Kalyanji Anandji Singers: Kishore Kumar and Asha Bhosle Director: Brij Lyrics: Verma Malik Enjoy this Hit song from the 1975 movie Chori Mera Kaam starring Ashok Kumar, Shashi Kapoor, Zeenat Aman and Pran. From the latest Bollywood songs to the oldest, SUBSCRIBE now to http://www.YouTube.com/FilmiGaane To see all the latest music playlists that we've created just for you, click here - http://www.youtube.com/user/filmigaane/videos?sort=dd&flow=list&view=1 Connect with us on :- Facebook - http://www.Facebook.com/FilmiGaane Twitter - http://Twitter.com/FilmiGaane Join us on Pinterest - http://pinterest.com/shemaroo Circle and follow us on Google+ - https://plus.google.com/+shemaroo . Download Filmi Gaane App - http://twd.bz/fg Sign up for Free and get daily updates on New Videos, exclusive Web Shows, contests & much more http://youtube.shemaroo.com/default.aspx Send us your feedback and suggestions at : connect@shemaroo.com | ["Singing", "Music", "Music of Bollywood"] | ["duet", "fast tempo", "hindi song", "bollywood", "bongos", "keyboard accompaniment", "lively", "youthful", "love song", "playful", "young love", "passionate", "minimalist", "emotional", "bollywood retro", "speech like singing", "acoustic guitar", "electric guitar", "sprechstimme"] | 7 | iEQwupwwp0s | 4171 |
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;