musiccaps_details (view)
5 rows where musiccaps_aspects contains "digital drums", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- digital drums · 5 ✖
- medium tempo · 5 ✖
- pop · 5 ✖
- atmospheric synthesiser 1
- backing voices 1
- bass 1
- club 1
- club music 1
- dance groove 1
- dance hits 1
- dance music 1
- dance pop 1
- digital bass 1
- digital flute 1
- digital strings and brass 1
- dissonant 1
- drum machine 1
- drum rhythm 1
- e-bass 1
- edm 1
- electric organ 1
- electronic music 1
- enigmatic 1
- female vocals 1
- female voice singing 1
- flute sound 1
- heavily synthesised 1
- high notes 1
- high pitched 1
- higher register 1
- male voice rapping 1
- male voice singing 1
- male voices singing 1
- male voices singing/rapping 1
- party music 1
- piano 1
- psychedelic 1
- romantic 1
- sensitive 1
- strings 1
- trance 1
- trap 1
- trippy 1
- uplifting mood 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music 5
- Afrobeat 1
- Christian music 1
- Dubstep 1
- Electronic music 1
- Happy music 1
- Hip hop music 1
- Music of Africa 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Amor Secreto - Kendo Kaponi ( Lyrics ) | This song contains a piano playing a melody in the mid range and also in the higher register. A flute is adding another melody in the mid range. A digital drum is holding a simple groove before dropping out completely. A male voice is softly rapping/talking in the mid range then another male with an effect takes over singing in a higher pitch. In the background you can hear strings underlaying chords. This song may be playing with headphones daydreaming. | 2011-06-16T16:52:05Z | MsCuBaNiTa01 | ["Music", "Tender music"] | ["pop", "piano", "strings", "digital drums", "digital flute", "male voices singing/rapping", "romantic", "sensitive", "medium tempo"] | 6 | 6sWVG6GyJBU | 793 | ||
New Ethiopian Music 2014 by Tsehay Amare Kora Yalew | This song contains percussive digital drums. In the background you can hear a string instrument playing a melody along with a digital flute sound. A keyboard is playing digital strings and brass sounds setting accents and a countermelody. The female voice is singing in the same melody as the strings. A bass is also playing the melody but at the low register. This song may be playing in a dance video-clip. | 2014-05-24T22:08:54Z | Sora Tv | New Ethiopian Music 2014 by Tsehay Amare Kora Yalew | ["Music", "Happy music"] | ["pop", "digital drums", "bass", "digital strings and brass", "flute sound", "female voice singing", "medium tempo"] | 6 | 9Qd6AdTq3Ls | 1005 | |
Mt Eden Dubstep - Sarah McLachlan: Silence | A female vocalist sings this trippy vocal riff. The tempo is medium with atmospheric synthesiser and digital drums. The song is heavily synthesised and is psychedelic, intense, enigmatic, mysterious and youthful with a dance groove. This song is an EDM/Electro Pop song. | 2009-06-12T09:12:04Z | Mt Eden Official | ► FREE DOWNLOAD : http://click.dj/mreden/sarah-mclachlan-silence-mt-eden-remix ► Facebook: https://www.facebook.com/MtEdenOfficial ► SoundCloud: http://soundcloud.com/mtedenofficial ► YouTube: http://www.youtube.com/MtEdenDnB08 ► Twitter: https://twitter.com/MtEdenOfficial ► Beatport: http://www.beatport.com/artist/mt-ede... Cheers for all the support . We can't wait to share more with you Enjoy | ["Electronic music", "Music", "Dubstep"] | ["female vocals", "electronic music", "enigmatic", "medium tempo", "atmospheric synthesiser", "electronic music", "high notes", "high pitched", "dissonant", "psychedelic", "heavily synthesised", "drum rhythm", "digital drums", "drum machine", "youthful", "dance music", "dance hits", "pop", "dance pop", "club", "club music", "dance music", "party music", "dance groove", "edm", "trance", "trap", "trippy"] | 7 | Nymjfq2kXnI | 2384 | |
Brandon Flowers - Only The Young (Official Video) | A digital drum is playing a simple groove along with an e-bass. An organ is playing long chords with a lot of reverb. On top of that male voices sing a melody in harmony. Their voices sound high. This song may be playing with headphones while running. | 2010-10-13T00:00:08Z | BrandonFlowersVEVO | Music video by Brandon Flowers performing Only The Young. (C) 2010 The Island Def Jam Music Group #BrandonFlowers #OnlyTheYoung #Vevo | ["Christian music", "Music"] | ["pop", "electric organ", "digital drums", "e-bass", "male voices singing", "higher register", "medium tempo"] | 6 | uBENjCPS8LI | 5097 | |
Ding Dong Holiday Official Video | This song contains digital drums playing a hiphop kinda feel along with a bassline. The most energy comes from the male voice singing with autotune and a lot of backing voices cheering and singing along: Then a male voice starts rapping. The backing voices are spread across the both sides of the speakers. This song may be playing outside chilling with your friends. | 2012-02-02T21:54:29Z | Teonray Chichester | ["Afrobeat", "Music of Africa", "Music", "Hip hop music"] | ["pop", "digital bass", "digital drums", "male voice singing", "backing voices", "male voice rapping", "medium tempo", "uplifting mood"] | 6 | w6MtzUCl4vM | 5241 |
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;