musiccaps_details (view)
2 rows where musiccaps_aspects contains "guitar accompaniment", musiccaps_aspects contains "spirited" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- emotional 2
- guitar accompaniment · 2 ✖
- spirited · 2 ✖
- steady drumming rhythm · 2 ✖
- amateur pop music 1
- beachside party 1
- brass band harmony 1
- caribbean music style 1
- caribbean percussions rhythm 1
- cheerful 1
- classic reverse hits 1
- comically happy 1
- dance groove 1
- e erotic 1
- energetic 1
- enjoy life 1
- fast tempo 1
- feeling loved 1
- female singer 1
- free spirit 1
- fun 1
- groovy bass line 1
- happy 1
- inspiring 1
- life is a dance 1
- life is good 1
- medium tempo 1
- new experiences 1
- party time 1
- passionate 1
- people dancing 1
- piano accompaniment 1
- pop music 1
- positive 1
- reggae groove 1
- reggae hits 1
- retro youtube pop 1
- scream and shout 1
- song introduction 1
- spirited singing 1
- strong bass line 1
- the first time 1
- tropical dance hit 1
- trumpets blaring 1
- yodelling vocals 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- /t/dd00003 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
singing sandra crying | A female singer sings this passionate melody. The song is medium tempo with steady drumming rhythm, groovy bass line, Caribbean percussion, guitar accompaniment and a brass band playing percussively. The song is emotional and spirited. The song is a classic renege hit. | 2008-09-26T00:01:17Z | ANDY WONG KEE | music | ["Music", "/t/dd00003"] | ["female singer", "spirited singing", "reggae hits", "tropical dance hit", "caribbean music style", "trumpets blaring", "caribbean percussions rhythm", "medium tempo", "guitar accompaniment", "groovy bass line", "steady drumming rhythm", "brass band harmony", "emotional", "passionate", "reggae groove", "classic reverse hits", "spirited", "dance groove", "beachside party", "people dancing", "inspiring", "life is good", "enjoy life", "life is a dance"] | 1 | XXBVsNt2Qr8 | 3192 |
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;