musiccaps_details (view)
2 rows where musiccaps_aspects contains "bright drumming", musiccaps_aspects contains "cheerful" and musiccaps_aspects contains "pleasant"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- bright drumming · 2 ✖
- cheerful · 2 ✖
- fast tempo 2
- happy 2
- pleasant · 2 ✖
- world music 2
- afro beats 1
- akuba 1
- banjo 1
- carefree 1
- catchy 1
- clave 1
- conga 1
- dance groove 1
- dominant music 1
- enthusiastic 1
- foreign language 1
- funky bass lines 1
- inspirational 1
- keyboard harmony 1
- latin pop 1
- latin song 1
- male singer 1
- male vocalist 1
- nigerian music 1
- pandeireta 1
- propulsive percussion 1
- reflective 1
- reggae 1
- regional music 1
- rhythmic acoustic guitar 1
- spanish guitar 1
- sunny 1
- ugandan song 1
- upbeat 1
- upstroke rhythm guitar 1
- warm 1
- youthful 1
musiccaps_names (array) 5 ✖
- Music 2
- Afrobeat 1
- Dance music 1
- Music of Africa 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SOUL VIBRATION - Frequenza reggae | A male vocalist sings this vivacious latin pop song. The tempo is fast with rhythmic Spanish guitar,keyboard harmony, bright drumming, mandolin harmony, groovy bass line and lively pandeira beats. The song is melodic, simple, happy, cheerful, bouncy, peppy , warm and joyful. | 2010-08-30T17:45:36Z | AstonBarret | SOUL VIBRATION - Frequenza reggae - REGGAE MATERA | ["Music", "Soul music"] | ["male vocalist", "fast tempo", "latin pop", "latin song", "banjo", "spanish guitar", "keyboard harmony", "bright drumming", "world music", "regional music", "happy", "cheerful", "enthusiastic", "warm", "sunny", "upbeat", "pleasant", "funky bass lines", "pandeireta", "rhythmic acoustic guitar"] | 7 | CP3phqztym0 | 1360 | |
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;