musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "dance rhythm" and musiccaps_aspects contains "groovy music" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- dance rhythm · 2 ✖
- groovy music · 2 ✖
- instrumental music 2
- poor audio quality 2
- adrenaline rush 1
- blues music 1
- classic guitar hits 1
- couples dancing 1
- emotional 1
- energetic 1
- erotic 1
- fast strumming rhythm 1
- fast tempo 1
- flamenco guitar style 1
- groovy 1
- guitar lead 1
- guitar player 1
- guitar strumming 1
- gypsy guitar music 1
- hooting 1
- jazz blues 1
- latin dance music 1
- latin guitar player 1
- madly in love 1
- medium tempo 1
- music lesson ideo 1
- passionate 1
- people cheering 1
- rhumba music 1
- romantic 1
- solo instrumental 1
- soloist 1
- tango 1
- virtuous guitarist 1
musiccaps_names (array) 8 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Tommy Emmanuel - The best acoustic guitar live blues! | The song is an instrumental. The song is fast tempo with soloists playing an enthusiastic guitar strumming and harmony. The song is energetic and entertaining. The audio is poor and the song is played in front of a live audience that is cheering and hooting in approval. | 2010-03-03T19:34:12Z | kolipas | Firstly, I do not upload such kind of videos as I have only uploaded gaming (runescape) videos so far. However, I was totally hooked by this blues improvisation and it would be a crime if I didn't share it. So here it is. If you are interested about this artist, here is his official website. www.tommyemmanuel.com You can download his music there. If this video will get enough views and rates, I might upload similar ones in the future. Enjoy. acoustic guitar blues 12 bars runescape best ever funny awsome epic increadible sick improvisation freestyle live | ["Folk music", "Music"] | ["poor audio quality", "instrumental music", "virtuous guitarist", "classic guitar hits", "adrenaline rush", "people cheering", "groovy", "hooting", "guitar player", "soloist", "fast strumming rhythm", "energetic", "passionate", "dance rhythm", "groovy music", "jazz blues", "gypsy guitar music", "blues music", "fast tempo"] | 1 | E3F9bzeCgTQ | 1528 |
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;