musiccaps_details (view)
6 rows where search matches "guitar", musiccaps_aspects contains "dance rhythm" and musiccaps_aspects contains "emotional" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 89 ✖
- dance rhythm · 6 ✖
- emotional · 6 ✖
- medium tempo 6
- poor audio quality 5
- romantic 4
- passionate 3
- spirited 3
- cheerful 2
- groovy rhythm 2
- guitar rhythm 2
- guitar strumming 2
- instrumental music 2
- latin dance music 2
- live performance 2
- traditional music 2
- acapella 1
- acoustic guitar strumming 1
- acoustic song 1
- ambient room noise 1
- ambient room noises 1
- bad audio quality 1
- banjo 1
- child performers 1
- clapping percussions 1
- country bluegrass 1
- country dance music 1
- country folk music 1
- country music 1
- couples dancing 1
- dance groove 1
- dance rhythm l 1
- entertaining 1
- erotic 1
- exciting 1
- exercise playlist 1
- feel good 1
- female backup singers 1
- female singer 1
- fiddlers 1
- flamenco guitar style 1
- folk singers 1
- footstep sounds 1
- groovy music 1
- guiro percussions 1
- guitar accompaniment 1
- guitar lead 1
- heartfelt 1
- hissing sounds 1
- keyboard accompaniment 1
- latin dance band 1
- latin folk singer 1
- latin guitar player 1
- latin oercussions 1
- latin percussions 1
- live audience 1
- live dance class 1
- madly in love 1
- male and female singer 1
- male backup singers 1
- male latin singer 1
- male singer 1
- music lesson ideo 1
- never give up 1
- people clapping 1
- people dancing 1
- piano accompaniment 1
- positive 1
- retro pop song 1
- retro super hits 1
- rhumba music 1
- room echoes 1
- soaring vocals 1
- solo instrumental 1
- soulful singer 1
- steady drumming rhythm 1
- story telling 1
- string bass 1
- string bass line 1
- strong bass line 1
- tango 1
- the country life 1
- the wild west 1
- traditional folk song 1
- violinists 1
- vocal crooning 1
- vocal harmony 1
- walking bass line 1
- workout music 1
- yodelling melody 1
musiccaps_names (array) 15 ✖
- Music 6
- Country 2
- Flamenco 2
- Musical instrument 2
- Plucked string instrument 2
- Singing 2
- Acoustic guitar 1
- Banjo 1
- Bowed string instrument 1
- Chant 1
- Guitar 1
- Music of Africa 1
- Ska 1
- Tambourine 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
el grillo enamorado | A male singer sings this passionate melody. The song is medium tempo with Latin percussion, guiro percussions, guitar rhythm, piano accompaniment and guitar rhythm. The song is romantic and spirited. The song is a Latin dance song with poor audio quality. | 2008-09-05T17:39:10Z | Piko | el grillo enamorado con imagenes de grillos | ["Music of Africa", "Music", "Ska"] | ["male latin singer", "poor audio quality", "latin percussions", "people dancing", "latin dance band", "dance groove", "emotional", "soaring vocals", "latin folk singer", "walking bass line", "piano accompaniment", "dance rhythm", "entertaining", "romantic", "story telling", "passionate", "spirited", "guiro percussions", "medium tempo", "guitar rhythm"] | 1 | 2cxvYC9QZac | 391 | |
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 | |
요들송 _ 키스 요들 _ Kuss Jodle _ Kiss Yodel _ 목장주인김원섭 _ 박진아 | A male singer sings with a female backup singer in vocal harmony. The song is medium tempo with a yodelling medley and guitar strumming rhythm and no other instrumentation. The song is exciting and passionate. The song has poor audio quality. | 2010-11-11T11:53:45Z | 목장주인tv | 요들송 _ 키스 요들 _ Kuss Jodle _ Kiss Yodel 2009.5.7. 성남아트센터 김원섭(010-4061-6404)의 '나눔의 열린 음악회'중에서 kmwonseop@hanmail.net | ["Singing", "Chant", "Music", "Vocal music"] | ["male and female singer", "yodelling melody", "poor audio quality", "clapping percussions", "dance rhythm", "spirited", "traditional music", "guitar accompaniment", "acoustic song", "traditional folk song", "folk singers", "live performance", "live audience", "ambient room noises", "hissing sounds", "exciting", "emotional", "medium tempo", "people clapping"] | 1 | m9MQdg0k1t0 | 4448 | |
Joan Armatrading - Love And Affection 1976 | A female singer sings this beautiful melody with male and female backup singers in vocal harmony. The song is medium tempo with an acoustic guitar playing rhythm and strong string bass line with no percussion instrumentation. The song is emotional and heartfelt. The song has acapella influences and is soulful. The song is of poor audio recording quality. | 2010-03-19T15:03:53Z | fritz51329 | Joan Armatrading - Love And Affection 1976 I am not in love But I'm open to persuasion East or West Where's the best For romancing With a friend I can smile But with a lover I could hold my head back I could really laugh Really laugh Thank you You took me dancing 'Cross the floor Cheek to cheek But with a lover I could really move Really move I could really dance Really dance Really dance Really dance I could really move Really move Really move Really move Now if I can feel the sun In my eyes And the rain on my face Why can't I Feel love I can really love Really love Really love Really love Really love Love love love love Love love love love Now I got all The friends that I want I may need more But I shall just stick to those That I have got With friends I still feel So insecure Little darling I believe you could Help me a lot Just take my hand And lead me where you will No conversation No wave goodnight Just make love With affection Sing me another love song But this time With a little dedication Sing it, sing it You know that's what I like Once more with feeling Give me love Give me love Give me love Love (Instrumental) Make love with affection Sing me another love song But this time With a little dedication Sing it, sing it You know that's what I like With affection Sing me another love song But this time With a little dedication Sing it, sing it You know that's what I like With affection With a little dedication Once more with feeling You know that's what I like | ["Singing", "Flamenco", "Music"] | ["female singer", "soulful singer", "poor audio quality", "male backup singers", "string bass line", "acoustic guitar strumming", "vocal harmony", "female backup singers", "retro pop song", "cheerful", "emotional", "retro super hits", "dance rhythm", "medium tempo", "string bass", "acapella", "passionate", "romantic", "heartfelt", "feel good", "vocal crooning"] | 1 | oag3I4VRXyM | 4645 | |
Nancy 🇮🇳 Rumba 🇮🇳 (Juan Serrano) | The song is an instrumental. The tempo is medium with a guitarist playing traditional flamenco style guitar in a rhumba rhythm. The song has a Latin dance groove and sounds delightful. The song has a poor audio quality. | 2015-07-07T18:32:38Z | Aman (Flamenco Guitarist) | Nancy (Rumba Flamenca) composed by Juan Serrano played by me on YAMAHA CG172SF Flamenco guitar. | ["Country", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["rhumba music", "latin guitar player", "instrumental music", "medium tempo", "emotional", "romantic", "erotic", "madly in love", "couples dancing", "tango", "guitar lead", "guitar strumming", "music lesson ideo", "poor audio quality", "latin dance music", "groovy music", "solo instrumental", "groovy music", "dance rhythm", "flamenco guitar style"] | 1 | w4Z1QuBOMWU | 5236 |
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;