musiccaps_details (view)
2 rows where musiccaps_aspects contains "happy", musiccaps_aspects contains "reggae" and musiccaps_names contains "Afrobeat"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- happy · 2 ✖
- reggae · 2 ✖
- afro beats 1
- akuba 1
- bright drumming 1
- carefree 1
- catchy 1
- cheerful 1
- clave 1
- conga 1
- dance groove 1
- dominant music 1
- electric guitar licks 1
- fast tempo 1
- flat male vocal 1
- foreign language 1
- groovy bass 1
- inspirational 1
- male singer 1
- metallic snare 1
- nigerian music 1
- offbeat acoustic rhythm guitar chords 1
- pleasant 1
- propulsive percussion 1
- reflective 1
- simple kick 1
- ugandan song 1
- uplifting 1
- upstroke rhythm guitar 1
- wide background harmonizing female vocals 1
- wide tinny percussive elements 1
- world music 1
- youthful 1
musiccaps_names (array) 7 ✖
- Afrobeat · 2 ✖
- Music 2
- Music of Africa 2
- Dance music 1
- Funk 1
- Mouse 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Eek A Mouse - Talking About The Business | The Reggae song features a flat male vocal singing, alongside wide background harmonizing female vocals, over metallic snare, simple kick hits, offbeat acoustic rhythm guitar chords, groovy bass, electric guitar licks and tinny percussive elements widely spread in the stereo image. Sounds happy and uplifting, like something you can listen to while chilling at the beach. | 2009-08-17T08:56:37Z | GJW | album: eeksperience release: 2001 label: Rfo Records | ["Afrobeat", "Music of Africa", "Funk", "Music", "Mouse", "Ska"] | ["reggae", "offbeat acoustic rhythm guitar chords", "wide background harmonizing female vocals", "flat male vocal", "groovy bass", "electric guitar licks", "metallic snare", "wide tinny percussive elements", "happy", "uplifting", "simple kick"] | 4 | R5JRh08zgMo | 2666 | |
Sitya Loss Remix - Eddy Kenzo | A male vocalist sings this energetic Nigerian song. The tempo is fast and upbeat with keyboard harmony and Afro beats of conga, clave, drums and akuba. The music is upbeat, catchy, spirited, energetic, youthful and pulsating with a dance groove. This song is a Reggae song. | 2014-02-20T13:25:19Z | Eddy Kenzo | big talent young managment | ["Afrobeat", "Music of Africa", "Music", "Dance music"] | ["male singer", "fast tempo", "nigerian music", "world music", "propulsive percussion", "upstroke rhythm guitar", "dominant music", "pleasant", "catchy", "youthful", "dance groove", "happy", "cheerful", "carefree", "conga", "clave", "akuba", "bright drumming", "reggae", "ugandan song", "foreign language", "afro beats", "reggae", "inspirational", "reflective"] | 7 | Xaq-segSEsQ | 3200 |
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;