musiccaps_details (view)
2 rows where musiccaps_aspects contains "emotional" and musiccaps_aspects contains "male singers"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- emotional · 2 ✖
- male singers · 2 ✖
- acordian harmony 1
- ambient sounds 1
- bad audio quality 1
- brass band 1
- cheerful 1
- fans 1
- fast tempo 1
- folk music 1
- football match theme 1
- foreign language 1
- happy 1
- heavy bass drum rhythm 1
- hissing tones 1
- inferior audio quality 1
- keyboard accompaniment 1
- live performance 1
- lively 1
- loud 1
- male harmony 1
- medium tempo 1
- passionate 1
- passionate singing 1
- percussive bass line 1
- rhythmic acoustic guitar 1
- spirited 1
- steady drumming rhythm 1
- three part harmony 1
- trumpet playing in unison 1
- upbeat 1
- vocal harmony 1
musiccaps_names (array) 6 ✖
youtube_published (date) 2 ✖
- 2010-10-01 1
- 2011-11-13 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
music wydad 2010 | A male singer leads backup singers in a vocal harmony. The song is medium tempo with a heavy percussive drum rhythm, strong bass line, keyboard accompaniment and a trumpet playing in unison with the vocals. The song is groovy and passionate and sounds like the theme song of a football club. The song audio quality is very poor. | 2010-10-01T18:21:22Z | zouhir564 | music wydad 2010 | ["Jazz", "Music", "Middle Eastern music"] | ["male singers", "vocal harmony", "trumpet playing in unison", "percussive bass line", "heavy bass drum rhythm", "brass band", "football match theme", "bad audio quality", "hissing tones", "spirited", "emotional", "medium tempo", "passionate", "fans", "steady drumming rhythm", "keyboard accompaniment"] | 1 | A3vsvL-Yx0Q | 1063 | |
Cel ce legi rani care dor-grup burla&horodnic | A group of male vocalists sing this charming melody in a foreign language. The tempo is fast with accordion lead music and acoustic guitar accompaniment. The song is lively, happy, light , warm, cheerful and charming . The audio quality is inferior as it seems to be an amateur home recording with ambient sounds. This Song is a Folk song. | 2011-11-13T02:38:31Z | dorin juravle | Dorin Gach, Dorin Medrihan, Valy Motac, Florin Motac, Danut Covali, Cornel Mihalescu | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["male singers", "male harmony", "fast tempo", "rhythmic acoustic guitar", "acordian harmony", "lively", "loud", "folk music", "emotional", "passionate singing", "three part harmony", "live performance", "ambient sounds", "inferior audio quality", "cheerful", "upbeat", "happy", "foreign language"] | 7 | QHCHK-NPO_U | 2607 |
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;