musiccaps_details (view)
2 rows where musiccaps_aspects contains "bright drumming", musiccaps_aspects contains "fast tempo" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- bright drumming · 2 ✖
- fast tempo · 2 ✖
- youthful · 2 ✖
- afro beats 1
- akuba 1
- alternative rock 1
- bass drum 1
- carefree 1
- catchy 1
- cheerful 1
- clave 1
- conga 1
- cymbals 1
- dance groove 1
- dominant music 1
- energetic 1
- enthusiastic 1
- foreign language 1
- funky bass line 1
- funky keyboard harmony 1
- groovy electric guitar accompaniment 1
- happy 1
- hard rock 1
- inspirational 1
- lively 1
- male singer 1
- male vocal backup 1
- male vocalist 1
- nigerian music 1
- pleasant 1
- propulsive percussion 1
- reflective 1
- reggae 1
- rock 1
- spirited 1
- ugandan song 1
- upstroke rhythm guitar 1
- vigorous 1
- world music 1
musiccaps_names (array) 6 ✖
- Music 2
- Afrobeat 1
- Dance music 1
- Music of Africa 1
- Singing 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
RapScallions - The Garage Sessions - "What Do Ya Say?" | A male vocalist sings this enthusiastic song. The tempo is fast with infectious drumming, groovy bass lines, funky electric guitar harmony and an energetic keyboard accompaniment with vocal backup. The song is energetic, high-spirited, youthful, infectious, pulsating and vigorous. This song is a popular Alternative Rock. | 2013-04-02T04:59:36Z | OfficialRapScallions | BUY THE NEW ALBUM "IN MY HEAD" on iTunes https://itunes.apple.com/us/album/in-my-head-ep/id611204088 The Garage Sessions #2: "What Do Ya Say?" Vocals: Sergio Ochoa Guitar: Dario Forzato Bass: Chris Clemence Drums: James Forsberg Video Director: Alessandro Casati RapScallions would like to thank their sponsors: D'Addario Strings, Planet Waves, Evans, Pro Mark, Warwick and Truth Custom Drums. | ["Singing", "Music", "Ska"] | ["male vocalist", "fast tempo", "male vocal backup", "cymbals", "bass drum", "bright drumming", "funky keyboard harmony", "groovy electric guitar accompaniment", "funky bass line", "youthful", "spirited", "enthusiastic", "energetic", "lively", "vigorous", "rock", "hard rock", "alternative rock"] | 7 | 5xBfKiQcMZQ | 707 | |
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;