musiccaps_details (view)
2 rows where musiccaps_aspects contains "bright drumming" and musiccaps_aspects contains "dance groove" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- bright drumming · 2 ✖
- dance groove · 2 ✖
- fast tempo 2
- afro beats 1
- akuba 1
- animated 1
- bass drums 1
- brass band 1
- carefree 1
- catchy 1
- cheerful 1
- clave 1
- conga 1
- dominant music 1
- emphatic percussion 1
- energetic 1
- enthusiastic 1
- foreign language 1
- happy 1
- inspirational 1
- instrumental 1
- lively trumpets 1
- male singer 1
- nigerian music 1
- percussion 1
- pleasant 1
- propulsive percussion 1
- reflective 1
- reggae 1
- rock and roll 1
- snare 1
- spirited 1
- swing 1
- tambourine beats 1
- trumpet harmony 1
- ugandan song 1
- upstroke rhythm guitar 1
- world music 1
- youthful 1
musiccaps_names (array) 6 ✖
- Music 2
- Afrobeat 1
- Dance music 1
- Music of Africa 1
- Music of Asia 1
- Timpani 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
HD 120515 Girls' Generation SNSD TaeTiSeo TTS - Twinkle @ Show Champion | This music is an energetic Rock and Roll instrumental. The tempo is fast with animated, infectious drumming, lively trumpets and tambourine beats. The music is upbeat, pulsating, thumping, vivacious, bright, with a perky dance groove. This music is Rock and Roll. | 2012-05-18T01:47:44Z | Ky Pham | HD 120515 Girls' Generation SNSD TaeTiSeo TTS - Twinkle @ Show Champion Tiffany, Taeyeon, Seohyun - TAETISEO! 120503 120504 120505 120506 120510 120511 120512 120513 120517 120518 120519 120520 120521 120524 120525 120526 120527 120531 120601 120602 120603 120607 120608 120609 120619 120614 120615 120616 120617 120621 120622 120623 120624 | ["Timpani", "Music of Asia", "Music"] | ["instrumental", "fast tempo", "bright drumming", "dance groove", "animated", "energetic", "percussion", "emphatic percussion", "lively trumpets", "bass drums", "tambourine beats", "snare", "trumpet harmony", "brass band", "spirited", "animated", "enthusiastic", "swing", "rock and roll"] | 7 | OH2SQhJqZDg | 2420 | |
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;