musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "groovy rhythm", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional 4
- groovy rhythm · 4 ✖
- male singer · 4 ✖
- steady drumming rhythm · 4 ✖
- medium tempo 3
- poor audio quality 3
- cymbals crashing 2
- exciting 2
- guitar accompaniment 2
- guitar rhythm 2
- keyboard accompaniment 2
- passionate 2
- percussive bass line 2
- romantic 2
- adventurous 1
- ambient room noise 1
- bad audio quality 1
- classic rock 1
- dance rhythm 1
- dance rhythm l 1
- drum rolls 1
- enteric 1
- exercise playlist 1
- female singer 1
- footstep sounds 1
- keybiard accompaniment 1
- latin dance music 1
- latin oercussions 1
- live dance class 1
- love songs 1
- …
musiccaps_names (array) 9 ✖
- Music 4
- Christian music 1
- Grunge 1
- Independent music 1
- Pop music 1
- Progressive rock 1
- Psychedelic rock 1
- Rock music 1
- Tambourine 1
youtube_published (date) 4 ✖
- 2009-05-26 1
- 2009-10-27 1
- 2010-08-30 1
- 2011-09-04 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Zwan - Lyric (Video Version) | A male and female singer sing this vocal duet. The song is medium fast tempo with a guitar accompaniment, steady drumming rhythm with exciting drum rolls, cymbals crashes and a percussive bass line. The song is romantic and exciting. The song is retro pop with a bad audio quality. | 2009-10-27T01:54:19Z | Warner Records Vault | © 2005 WMG Lyric (Video Version) | ["Music", "Independent music", "Pop music", "Grunge"] | ["male singer", "female singer", "guitar accompaniment", "keyboard accompaniment", "vocal duet", "retro pop hits", "medium fast tempo", "poor audio quality", "groovy rhythm", "steady drumming rhythm", "percussive bass line", "keyboard accompaniment", "drum rolls", "cymbals crashing", "romantic", "exciting", "emotional", "adventurous", "passionate", "retro pop hits"] | 1 | CwmUMySSNQc | 1417 | |
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 | |
Matthew Perryman Jones - Save you lyrics | A male singer sings this poignant love song. The song is medium tempo with a steady drumming rhythm, strong bass line, keyboard accompaniment, guitar accompaniment and percussion hits. The song is emotional and romantic. The song audio quality is bad. | 2010-08-30T19:02:00Z | dionyts91 | Matthew Perryman Jones' official website: http://mpjmusic.com this is one of the KYLE XY 's, ONE TREE HILL 's , PRETTY LITTLE LIARS' soundtracks !! i love it!! I M SORRY FOR POSSIBLE MISTAKES ON THE LYRICS!! i don't own any rights! | ["Christian music", "Music"] | ["male singer", "classic rock", "pop song", "bad audio quality", "medium tempo", "string bass line", "guitar accompaniment", "piano accompaniment", "keybiard accompaniment", "steady drumming rhythm", "emotional", "passionate", "groovy rhythm", "new age", "romantic song", "sadness", "realisation", "modern pop songs", "love songs"] | 1 | Jq2w30NYstQ | 2037 | |
Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | A male singer sings this cool spirited melody. The song is medium tempo with a steady drumming rhythm, guitar playing lead, guitar strumming, strong bass line and various percussion hits. The song is exciting and energetic. The song has poor audio quality. | 2009-05-26T06:56:15Z | SirHenryII | Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | ["Music", "Psychedelic rock", "Rock music", "Progressive rock"] | ["male singer", "guitar rhythm", "percussive bass line", "medium tempo", "groovy rhythm", "old school music", "spirited singing", "retro pop music", "story telling", "steady drumming rhythm", "marching rhythm", "cymbals crashing", "snare hits", "enteric", "exciting", "positive cheerful", "spirited", "emotional", "vintage hits", "poor audio quality"] | 1 | ckOe-8qdaew | 3736 |
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;