musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance pop", musiccaps_aspects contains "tambourine beats" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- club music 3
- dance music 3
- dance pop · 3 ✖
- synthesiser arrangements 3
- tambourine beats · 3 ✖
- electronic music 2
- enthusiastic 2
- fast tempo 2
- groovy 2
- male vocalist 2
- amplified flute 1
- amplified ney 1
- bongos 1
- breezy fresh 1
- bulgarian 1
- buoyant 1
- catchy 1
- congas 1
- digital drum 1
- digital drumming 1
- dj 1
- dj mixer 1
- electro pop 1
- energetic 1
- energetic drums 1
- energetic vocal backup 1
- female vocalist 1
- hand percussion 1
- heavy reverb 1
- keyboard harmony 1
- medium fast tempo 1
- middle eastern music 1
- ney 1
- oud 1
- oud rhythm 1
- perky 1
- pleasant 1
- pop folk 1
- psychedelic 1
- punchy 1
- rock and roll 1
- romantic 1
- simple melody 1
- steady drumming 1
- surround sound 1
- synth pop 1
- techno mix 1
- techno pop 1
- trance 1
- vivacious 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 3
- Afrobeat 1
- Dance music 1
- Disco 1
- Maraca 1
- Music of Africa 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bad Boy Bill - Classics Vol. 2 - Old School Chicago House Music Trax Wbmx Wgci Wcrx | A male vocalist sings this energetic song. The tempo is fast with synthesiser arrangements, digital drumming and tambourine beats along with an incessant catchy vocal riff and vocalisation. The music is buoyant, energetic,enthusiastic , pulsating, punchy and groovy. This song is Techno Pop. | 2011-11-13T00:00:07Z | djmake | This is a Old Mix from Chicago's Very Own Bad Boy Bill. Old Cassette Mix that was converted to cd. Contact info: Djmake@sbcglobal.net - email www.facebook.com/djmakemoney - fan page www.facebook.com/illtechnics - facebook page | ["Afrobeat", "Disco", "Music"] | ["male vocalist", "fast tempo", "electronic music", "techno pop", "synthesiser arrangements", "tambourine beats", "digital drumming", "surround sound", "rock and roll", "techno mix", "electro pop", "trance", "psychedelic", "energetic", "enthusiastic", "groovy", "dance pop", "dance music", "club music", "heavy reverb"] | 7 | DGlP6oTqe5Y | 1459 | |
DJ HumNoy Maraca YouTube | A male vocalist sings this energetic song. The tempo is fast with synthesiser arrangements, punchy digital drumming, tambourine beats and keyboard harmony. The music is upbeat, punchy, groovy, youthful, buoyant and exciting. This song is Synth Pop. | 2013-12-03T12:25:16Z | ณ๊องจุ้น คนเดิม | ["Music", "Song", "Dance music", "Maraca"] | ["male vocalist", "fast tempo", "energetic drums", "synth pop", "buoyant", "tambourine beats", "digital drum", "synthesiser arrangements", "keyboard harmony", "energetic vocal backup", "dj", "dj mixer", "dance pop", "dance music", "club music", "youthful", "enthusiastic", "vivacious"] | 7 | S7rP6coeLTY | 2742 | ||
ANDREA (SAHARA) ft Kristali - NA EKS - produced by COSTI 2011 | A female vocalist sings this spirited pop. The tempo is medium fast with percussion accompaniment like congas, bongos and drums , tambourine beats,along with amplified flute like the Ney and rhythmic oud. The music is catchy, youthful, groovy, breezy, romantic, pleasant and spirited. This music is contemporary Folk Pop. | 2011-04-27T13:59:10Z | FORZZA MUSIC | Subscribe to my channel: https://bit.ly/ForzzaMusic Subscribe 👉https://bit.ly/2Siqg8P 🔝🎶 NA EKS - produced by COSTI COSTI Grammy Nominated Producer Billboard Hot💯🇺🇸🇷🇴 producer, songwriter, top-liner, compozitor & artist. FORTZAAAA 🔝🎶 Powered by Doctor Music® 2017 Productions & Booking : drstudio@costi.ro International PR Department : office@doctormusic.ro http://www.facebook.com/DrCosti.TheProducer http://twitter.com/CostiOfficial https://instagram.com/costiofficial/ http://www.soundcloud.com/CostiOfficial Costi (The Music Producer) - the first Romanian producer with a Grammy Nomination (Grammy Awards 2012) All rights reserved. Unauthorized reproduction is a violation of applicable laws. | ["Music of Africa", "Music"] | ["female vocalist", "medium fast tempo", "simple melody", "romantic", "breezy fresh", "pleasant", "groovy", "dance music", "dance pop", "club music", "tambourine beats", "catchy", "punchy", "perky", "amplified flute", "ney", "oud", "electronic music", "pop folk", "bulgarian", "middle eastern music", "hand percussion", "congas", "bongos", "steady drumming", "synthesiser arrangements", "amplified ney", "oud rhythm"] | 7 | tJHFSRTPyew | 5026 |
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;