musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy music" and musiccaps_names contains "Flamenco"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- emotional 2
- groovy music · 2 ✖
- romantic 2
- average audio quality 1
- couples dancing 1
- dance rhythm 1
- erotic 1
- fast guitar strumming 1
- fast tempo 1
- flamenco guitar 1
- flamenco guitar style 1
- folk music 1
- folk singer 1
- groovy tempo 1
- guitar accompaniment 1
- guitar lead 1
- guitar strumming 1
- instrumental music 1
- latin dance music 1
- latin guitar player 1
- latin singer 1
- live performance 1
- madly in love 1
- male singer 1
- medium tempo 1
- music lesson ideo 1
- passionate 1
- passionate music 1
- passionate singing 1
- poor audio quality 1
- rhumba music 1
- solo instrumental 1
- spirited 1
- spirited singing 1
- street musician 1
- tango 1
- traditional latin music 1
musiccaps_names (array) 10 ✖
- Flamenco · 2 ✖
- Music 2
- Acoustic guitar 1
- Country 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Singing 1
- Song 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 |
---|---|---|---|---|---|---|---|---|---|---|
Flamenco en la calle. Cáceres | A male singer sings this spirited Latin vocal. The song is fast tempo with slick guitar strumming and percussive guitar accompaniment. The song is romantic and steeped in rich Latin classical music traditions. The song is about a Latin street musician playing folk music. The recording is of average quality. | 2016-01-22T12:08:16Z | Antonio Lara Arco | En pleno casco antiguo de la ciudad... | ["Singing", "Flamenco", "Music", "Song", "Vocal music"] | ["male singer", "latin singer", "average audio quality", "fast tempo", "groovy tempo", "fast guitar strumming", "guitar accompaniment", "groovy music", "romantic", "emotional", "passionate", "spirited", "passionate singing", "spirited singing", "flamenco guitar", "live performance", "street musician", "passionate music", "traditional latin music", "folk singer", "folk music"] | 1 | Bx726MYz6Uo | 1306 | |
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;