musiccaps_details (view)
3 rows where musiccaps_aspects contains "couples dancing" and musiccaps_aspects contains "poor audio quality" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- couples dancing · 3 ✖
- emotional 3
- poor audio quality · 3 ✖
- romantic 3
- male singer 2
- medium tempo 2
- ambient hall noise 1
- booming bass line 1
- buzzing tones 1
- classic pop songs 1
- country dance 1
- dance floor 1
- dance hall 1
- dance rhythm 1
- erotic 1
- fiddle playing 1
- flamenco guitar style 1
- groovy bass line 1
- groovy music 1
- guitar lead 1
- guitar rhythm 1
- guitar strumming 1
- high gain noise 1
- instrumental music 1
- keyboard accompaniment 1
- keyboard harmony 1
- latin dance music 1
- latin folk music 1
- latin guitar player 1
- latin percussions 1
- latin romantic hits 1
- love song 1
- love songs 1
- love you much 1
- madly in love 1
- music lesson ideo 1
- mysterious 1
- passionate 1
- passionate song 1
- people dancing 1
- retro dance hits 1
- rhumba music 1
- salsa 1
- slow dance music 1
- slow tempo 1
- solo instrumental 1
- spirited singing 1
- steady drumming rhythm 1
- tango 1
- trumpets playing 1
- various percussion hits 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 |
---|---|---|---|---|---|---|---|---|---|---|
Cowboy Cha Cha (partner dance) by Silver Spurs France | A male singer sings this retro pop melody. The song is medium tempo with a steady drumming rhythm, steady bass line, guitar accompaniment, and fiddler playing. The song is romantic and slow dance-like. The audio quality is very poor. | 2010-07-05T10:34:29Z | Shirley Davidson | Dance.......Cowboy Cha Cha Choreographed by Toshio Suzuki Music .......I Just Wanna Dance With You by George Strait Danced by dancers from Silver Spurs South West France at a social event July 2010. | ["Singing", "Country", "Music", "Tambourine"] | ["slow tempo", "slow dance music", "people dancing", "couples dancing", "dance hall", "dance floor", "ambient hall noise", "poor audio quality", "buzzing tones", "high gain noise", "male singer", "classic pop songs", "retro dance hits", "country dance", "emotional", "romantic", "fiddle playing", "guitar rhythm", "steady drumming rhythm", "love song", "love you much", "booming bass line"] | 1 | B8pesuUc8Ek | 1209 | |
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 | |
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;