musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance music", musiccaps_aspects contains "perky" and musiccaps_aspects contains "tambourine beats"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- catchy 2
- club music 2
- dance music · 2 ✖
- perky · 2 ✖
- tambourine beats · 2 ✖
- amplified flute 1
- amplified ney 1
- auto tuned voices 1
- bongos 1
- breezy fresh 1
- bulgarian 1
- congas 1
- dance pop 1
- edm 1
- electro pop 1
- electronic music 1
- energetic 1
- fast tempo 1
- female vocalist 1
- groovy 1
- hand percussion 1
- infectious drumming 1
- instrumental 1
- keyboard harmony 1
- medium fast tempo 1
- middle eastern music 1
- ney 1
- oud 1
- oud rhythm 1
- pleasant 1
- pop folk 1
- pop hits 1
- punchy 1
- retro pop 1
- romantic 1
- simple melody 1
- steady drumming 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- upbeat 1
- vocalisation 1
- workout music 1
musiccaps_names (array) 3 ✖
- Music 2
- Burst, pop 1
- Music of Africa 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Madeon - Pop Culture | This song is a Retro electronic instrumental. The tempo is fast with electronically arranged music, slick drumming, bright amplified keyboard harmony, tambourine beats,synthesiser arrangements and male and female vocalisation. The song is youthful, groovy,vibrant, upbeat, passionate, catchy and punchy. This song is a Retro EDM. | 2013-12-02T21:31:12Z | Chris Taylor | Music Video | ["Music", "Burst, pop"] | ["instrumental", "electro pop", "fast tempo", "pop hits", "retro pop", "edm", "dance music", "club music", "workout music", "vocalisation", "perky", "energetic", "catchy", "upbeat", "synthesiser arrangement", "tambourine beats", "infectious drumming", "auto tuned voices", "keyboard harmony"] | 7 | B496Qv0CuOQ | 1203 | |
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;