musiccaps_details (view)
4 rows where musiccaps_aspects contains "passionate", musiccaps_author = 1 and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 65 ✖
- passionate · 4 ✖
- guitar accompaniment 3
- male singer 3
- spirited 3
- average audio quality 2
- backup singers 2
- fast tempo 2
- groovy music 2
- medium tempo 2
- poor audio quality 2
- romantic 2
- adrenaline rush 1
- ambient room noise 1
- brass band 1
- clapping percussions 1
- dance rhythm 1
- emotional 1
- energetic 1
- exercise class 1
- fast drumming rhythm 1
- fast guitar strumming 1
- female singers 1
- flamenco guitar 1
- folk music 1
- folk singer 1
- groovy 1
- groovy bass line 1
- groovy rhythm 1
- groovy tempo 1
- gym music 1
- hissing vocals 1
- home studio 1
- inspiring 1
- keybiard accompaniment 1
- latin dance hits 1
- latin dance music 1
- latin dance rhythm 1
- latin dancers 1
- latin percussion 1
- latin percussions 1
- latin singer 1
- life lessons 1
- live performance 1
- love performance 1
- male latin singer 1
- motivational 1
- passionate music 1
- passionate singing 1
- percussive bass line 1
- piano accompaniment 1
- rapping vocals 1
- retro pop hits 1
- screaming vocals 1
- song cover 1
- spirited singing 1
- street music 1
- street musician 1
- strong bass line 1
- traditional latin music 1
- trumpets 1
- trumpets blaring 1
- workout playlist 1
- youthful 1
- zumba dance hits 1
- zumba music 1
musiccaps_names (array) 9 ✖
- Music 4
- Song · 4 ✖
- Maraca 2
- Singing 2
- Flamenco 1
- Independent music 1
- Pop music 1
- Salsa music 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 | |
Dale Maraca - ABS in Zumba Dance Class with ART ( Mo Betta ) | A male singer sings this Latin dance tune. The song is medium tempo with trumpets, latin percussions; medium drumming rhythm, keyboard harmony and guitar accompaniment. The song is exciting and groovy. The audio quality is poor and is played for work out exercise. | 2009-12-21T09:41:49Z | 19mobetta06 | Great song for ab work. Pull stomach in and use your hips in circular motion not so much work with the shoulders. www.CardioAssassin.com | ["Music", "Song", "Maraca"] | ["ambient room noise", "poor audio quality", "gym music", "zumba dance hits", "trumpets", "guitar accompaniment", "latin percussion", "strong bass line", "latin dance hits", "workout playlist", "passionate", "spirited", "adrenaline rush", "male singer", "latin dance music", "exercise class", "zumba music", "medium tempo", "groovy music"] | 1 | Sj5MQtqDw8Y | 2783 | |
Jakes List Jun 2012 Top 10 Independent Music Video Uploads | Male and female singers sing this vocal harmony. The song is medium tempo with a groovy bass-line, keyboard accompaniment, guitar rhythm and a steady drumming rhythm with clapping percussions. The song is exciting and groovy. The song is a classic pop hit cover with an average quality sound. | 2012-06-30T22:34:02Z | Jake Niall Foster | The top 10 music video uploads for the month of June 2012 (with a cut-off date of 22 Jun) for Independent and Unsigned artists. | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["male singer", "backup singers", "female singers", "clapping percussions", "groovy bass line", "medium tempo", "guitar accompaniment", "keybiard accompaniment", "song cover", "home studio", "average audio quality", "hissing vocals", "spirited", "passionate", "dance rhythm", "groovy rhythm", "life lessons", "motivational", "inspiring", "retro pop hits"] | 1 | lR8am4rK7qQ | 4395 | |
La Maraca | A male Latin singer sings this energetic vocal with male backup singers in vocal harmony. The song is fast tempo with quick Latin percussions, groovy bass line, keyboard accompaniment and trumpets blaring. The song is energetic and passionate. The song has poor audio quality. | 2008-04-10T19:01:41Z | adonismasgozadera | AdonisGozadera.com | ["Music", "Song", "Salsa music", "Maraca"] | ["male latin singer", "backup singers", "screaming vocals", "rapping vocals", "street music", "fast tempo", "poor audio quality", "piano accompaniment", "latin percussions", "percussive bass line", "fast drumming rhythm", "energetic", "youthful", "romantic", "love performance", "brass band", "trumpets blaring", "groovy", "passionate", "latin dancers", "latin dance rhythm"] | 1 | zNSV9GkpRfM | 5468 |
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;