musiccaps_details (view)
3 rows where musiccaps_aspects contains "percussion" and musiccaps_aspects contains "repetitive melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- moderate tempo 3
- percussion · 3 ✖
- repetitive melody · 3 ✖
- dance song 2
- happy mood 2
- male voice 2
- african beat 1
- backing voices 1
- bass 1
- female backing voice 1
- female voice 1
- flute 1
- funk bass 1
- funk song 1
- groovy bassline 1
- guitar 1
- guitar tron effect 1
- male backing voice 1
- male backing voices 1
- pop song 1
- saxophone 1
- tambourine 1
- trumpet 1
- upbeat 1
musiccaps_names (array) 4 ✖
- Music 3
- Funk 2
- Exciting music 1
- Music of Africa 1
youtube_published (date) 3 ✖
- 2006-06-07 1
- 2011-06-14 1
- 2015-06-10 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Funktomas - How G Is The Party | This funk song features a male voice singing the main melody. Other voices sing backing vocals in harmony. A saxophone plays a repetitive melody. This is accompanied by percussion playing a funk beat. The bass plays a funky bassline. A guitar plays muted chords using a tron effect. This song is upbeat and has a happy mood. This song can be played at a retro style disco. | 2011-06-14T20:17:22Z | drean1964 | Label : Goodgroove Records - 2009 - -Select 720p for better sound- "Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use." | ["Funk", "Music", "Exciting music"] | ["funk song", "male voice", "backing voices", "tambourine", "saxophone", "percussion", "guitar", "funk bass", "moderate tempo", "upbeat", "repetitive melody", "guitar tron effect"] | 0 | 4a1a-lmDVaY | 587 | |
SUPERSCI - Get! (Feat. Remedeeh) (Official Video) | This pop song features a female voice singing the main melody. This is accompanied by male and female backing voices. The voices sing a repetitive melody. This is accompanied by percussion playing a simple beat. Trumpets play a backing melody. The bass plays a groovy descending bassline. The mood of this song is happy. This song can be played at a club. | 2006-06-07T17:33:35Z | Supersci Flyphonic | Swedish hip hop at its finest with a sweet summer vibe. Supersci's first video from the 2006 album "Pinetrees on the Pavement". Shot around the Sundsvall area using super-8 film. Video directed by Måns Berthas. Music produced by Flyphonic Beats. Lyrics by Mr Noun, Arka and Remedeeh. www.flyphonic.com/supersci | ["Funk", "Music"] | ["pop song", "female voice", "male backing voice", "female backing voice", "percussion", "trumpet", "bass", "moderate tempo", "dance song", "repetitive melody", "happy mood"] | 0 | EtmKuWPpjG0 | 1598 | |
Zigido-Eddy Kenzo[Official] | This African beat song features a male voice singing the main melody. Other voices sing one word after each line. This is accompanied by percussion playing an African dance beat. The bass plays a groovy bassline. A flute plays the same melody as the main voice. This song has a happy mood. This song can be played in a dance party. | 2015-06-10T11:28:50Z | Eddy Kenzo | In this song Eddy Kenzo Talks about the struggle of a Ghetto boy who suffered a lot during his childhood but due to hard-work and believing in GOD, Zigido is seeing success. CHECK IT OUT. WORK-HARD~BELIEVE~ACHIEVE. #BIGTALENTMUSIC. Subscribe to this channel = http://www.youtube.com/suscription_center?add_user=eddykenzo Like my official Facebook page = https://www.facebook.com/syfepro1 Follow me on Twitter = https://twitter.com/eddykenzoficial Follow me on Twitter = https://instagram.com/eddykenzo/ | ["Music of Africa", "Music"] | ["dance song", "african beat", "male voice", "male backing voices", "percussion", "groovy bassline", "flute", "moderate tempo", "happy mood", "repetitive melody"] | 0 | mpymEs4Mcw8 | 4494 |
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;