musiccaps_details (view)
5 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "poor audio quality"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Tubular Bells | The song is an instrumental. The song is medium tempo with three guitars playing in harmony, guitar accompaniment, guitar harmony, guitar lead and a strong bass line. The song is emotional and spirited. The song has an average audio quality and is played in front of a live audience. | 2009-07-01T03:28:17Z | Christine Robertson | California Guitar Trio's version of Tubular Bells live at B.B. King's June 22, 2009 with Tyler Trotter on Melodica | ["Banjo", "Tapping (guitar technique)", "Music"] | ["poor audio quality", "home video recording", "guitar band", "instrumental music", "medium tempo", "guitars playing in harmony", "groovy bass line", "guitar lead", "guitar accompaniment", "entertaining", "emotional", "passionate", "spirited", "lilting"] | 1 | 1RwhRTe-OKk | 275 | |
PARARCA - OCT - 2013 - ARPA Y VIOLIN (A) | The song is instrumental. The tempo is medium with a harpist playing a bass line accompanying a violist. The song is folk-like with a dance rhythm. The audio quality is poor with ambient crowd noise. | 2013-11-01T18:51:07Z | Johnny Torres | ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | ["harpist", "violinist", "dance music", "groovy bass line", "instrumental music", "couples dan", "family gatherings", "poor audio quality", "romantic", "south american folk music", "folk dance music", "instrumental duo", "people talking", "ambient crowd noises", "medium tempo", "sentimental", "emotional", "cheerful", "positive", "festive spirit", "togetherness", "traditional custom dance"] | 1 | 8DQbnR7hwpc | 904 | ||
SALSA CLASICA ROMANTICA MIX RONNY MUSIC | A male singer sings this Latin melody. The song is medium tempo with a groovy Latin percussive rhythm, keyboard accompaniment, brass band harmony and a groovy bass line. The song is romantic and emotional. The song is a salsa dance hit, but has poor audio quality issues.. | 2011-09-30T01:08:54Z | ronnymusic01 | BY DJ RONNY MUSIC | ["Music", "Middle Eastern music", "Salsa music"] | ["salsa", "latin folk music", "male singer", "spirited singing", "emotional", "couples dancing", "passionate song", "mysterious", "latin percussions", "trumpets playing", "medium tempo", "various percussion hits", "keyboard harmony", "romantic", "love songs", "latin romantic hits", "keyboard accompaniment", "poor audio quality", "passionate", "groovy bass line"] | 1 | DKflAAykh6A | 1464 | |
Sylwia Grzeszczak - Flirt [Official Music Video] | A female singer sings this emotional melody. The song is medium tempo with guitar strumming rhythm, strong bass line, steady drumming rhythm, keyboard accompaniment and sound effects. The song is emotional and romantic. The song is a euro pop love song and has poor audio quality. | 2013-04-16T09:57:50Z | SylwiaGrzeszczak | ✅ Subskrybuj: https://bit.ly/WMP_YT ✅ Instagram https://instagram.com/warnermusicpoland ✅ Facebook: https://fb.com/warnermusicpoland ✅ TikTok: https://www.tiktok.com/@warnermusicpoland Music video by Sylwia Grzeszczak performing Flirt. (P) 2013 The copyright in this audiovisual recording is owned by Gorgo under exclusive licence to EMI Music Poland Sp. z.o.o. | ["Music", "Tender music"] | ["female singer", "russian pop star", "medium tempo", "groovy bass line", "emotional", "passionate", "madly in love", "say sorry", "poor audio quality", "guitar strumming", "groovy bas line", "sonic effects", "keybiard accompaniment", "steady drumming rhythm", "romantic", "love song", "euro pop hits"] | 1 | ORikRIu7s1o | 2440 | |
Devendra Banhart - Chin Chin & Muck Muck | A male singer raises this passionate melody. The song is medium tempo with an acoustic guitar accompaniment, groovy bass line and a subtle drumming rhythm. The song is passionate and relaxing. The song is played live and has poor audio quality. | 2009-04-21T19:14:32Z | eachnotesecure | Devendra Banhart performs Chin Chin & Muck Muck live at The Independent in San Francisco in April 2009 | ["Singing", "Music", "Rattle (instrument)"] | ["male singer", "live performance", "groovy bass line", "medium tempo", "story telling", "ambient room nosiness", "people talking", "guitar accompaniment", "bass rhythm", "steady percussions", "folk music", "emotional", "energetic", "people talking", "poor audio quality", "folk music", "folk music", "guitarist"] | 1 | jFek2xLbEww | 4243 |
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;