musiccaps_details (view)
2 rows where musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "guitar accompaniment" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- emotional 2
- fast tempo · 2 ✖
- guitar accompaniment · 2 ✖
- spirited · 2 ✖
- amateur pop music 1
- average audio quality 1
- cheerful 1
- comically happy 1
- e erotic 1
- energetic 1
- fast guitar strumming 1
- feeling loved 1
- flamenco guitar 1
- folk music 1
- folk singer 1
- free spirit 1
- fun 1
- groovy music 1
- groovy tempo 1
- happy 1
- latin singer 1
- live performance 1
- male singer 1
- new experiences 1
- party time 1
- passionate 1
- passionate music 1
- passionate singing 1
- piano accompaniment 1
- pop music 1
- positive 1
- retro youtube pop 1
- romantic 1
- scream and shout 1
- song introduction 1
- spirited singing 1
- steady drumming rhythm 1
- street musician 1
- strong bass line 1
- the first time 1
- traditional latin music 1
- yodelling vocals 1
- youthful 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 | |
Bayartsengel yodel | A male singer sings cheerful yodelling vocals. The song is fast tempo, with a steady drumming rhythm, groovy bass line, guitar accompaniment and piano playing enthusiastically. The song is cheerful and thoroughly entertaining. The song is a modern pop tune with yodelling to express happiness and free spirit. | 2011-06-09T11:54:50Z | ulzii bat | Bayartsengel yodel | ["Yodeling", "Music"] | ["fast tempo", "guitar accompaniment", "retro youtube pop", "song introduction", "scream and shout", "pop music", "amateur pop music", "free spirit", "energetic", "song introduction", "youthful", "e erotic", "new experiences", "feeling loved", "the first time", "comically happy", "piano accompaniment", "strong bass line", "steady drumming rhythm", "yodelling vocals", "cheerful", "happy", "positive", "emotional", "spirited", "fun", "party time"] | 1 | I-C14nCneBs | 1857 |
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;