musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "dance rhythm", musiccaps_aspects contains "groovy rhythm", musiccaps_aspects contains "medium tempo" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- dance rhythm · 3 ✖
- groovy rhythm · 3 ✖
- medium tempo · 3 ✖
- emotional 2
- male singer 2
- passionate 2
- spirited 2
- ambient room noise 1
- average audio quality 1
- backup singers 1
- bad audio quality 1
- banjo 1
- cheerful 1
- child performers 1
- clapping percussions 1
- country bluegrass 1
- country dance music 1
- country folk music 1
- country music 1
- dance rhythm l 1
- exercise playlist 1
- female singers 1
- fiddlers 1
- footstep sounds 1
- groovy bass line 1
- guitar accompaniment 1
- guitar rhythm 1
- guitar strumming 1
- hissing vocals 1
- home studio 1
- …
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cha Cha Espana (Spain) -Line Dance (Demo & Teach) | A male singer sings this passionate melody. The song is medium tempo with guitar strumming rhythm, steady drumming rhythm, keyboard accompaniment and a percussive bass line. The song is romantic with a cool dance groove. The audio quality is poor. | 2011-09-04T22:49:49Z | 2011JulietBeginner | 32 Count, 4 Wall, Beginner Level Line Dance. Choreographed by Ira Weisburd & Motti Kotzer (dancewithira@comcast.net) (Published: September, 2011) Music: GOZAR LA VIDA by Julio Iglesias; Album: NOCHE DE CUATRO LUNAS; Year: 2000; Track: 1 Intro: 32 counts. Starts approx. 19 sec. into the song. NO TAGS, NO RESTARTS !! Danced by: Juliet Lam Videographer / Editor : Walt & Fang-Li Hsu. | ["Music", "Tambourine"] | ["male singer", "latin dance music", "live dance class", "dance rhythm", "footstep sounds", "ambient room noise", "room echoes", "medium tempo", "emotional", "groovy rhythm", "dance rhythm", "steady drumming rhythm", "strong bass line", "guitar rhythm", "keyboard accompaniment", "latin oercussions", "exercise playlist", "workout music", "poor audio quality", "romantic", "dance rhythm l"] | 1 | FCzMqo8kh1o | 1623 | |
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 | |
Jakes List Jun 2012 Top 10 Independent Music Video Uploads | Male and female singers sing this vocal harmony. The song is medium tempo with a groovy bass-line, keyboard accompaniment, guitar rhythm and a steady drumming rhythm with clapping percussions. The song is exciting and groovy. The song is a classic pop hit cover with an average quality sound. | 2012-06-30T22:34:02Z | Jake Niall Foster | The top 10 music video uploads for the month of June 2012 (with a cut-off date of 22 Jun) for Independent and Unsigned artists. | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["male singer", "backup singers", "female singers", "clapping percussions", "groovy bass line", "medium tempo", "guitar accompaniment", "keybiard accompaniment", "song cover", "home studio", "average audio quality", "hissing vocals", "spirited", "passionate", "dance rhythm", "groovy rhythm", "life lessons", "motivational", "inspiring", "retro pop hits"] | 1 | lR8am4rK7qQ | 4395 |
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;