musiccaps_details (view)
7 rows where musiccaps_aspects contains "dance music", musiccaps_aspects contains "vocalisation" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 107 ✖
- dance music · 7 ✖
- vocalisation · 7 ✖
- fast tempo 5
- instrumental 5
- club music 4
- catchy 3
- dance groove 3
- edm 3
- electronic music 3
- energetic 3
- keyboard harmony 3
- buoyant 2
- dj 2
- dj mixer 2
- drum machine 2
- groovy 2
- infectious drumming 2
- perky 2
- psychedelic 2
- punchy 2
- upbeat 2
- youthful 2
- alternative hip-hop 1
- animated trumpets 1
- atmospheric 1
- auto tuned voices 1
- background chatter 1
- bad audio quality 1
- beat boxing 1
- boomy 1
- car honking 1
- catchy beat 1
- catchy vocal riff 1
- cheerful 1
- cheerful drumming 1
- compelling 1
- congas 1
- dance pop 1
- electro pop 1
- electronic instrumentation 1
- electronically arranged music 1
- enthusiastic drumming 1
- female backup 1
- festivities 1
- funky 1
- funky bass lines 1
- funky basslines 1
- funky electric guitar riff 1
- futuristic 1
- guitar 1
- happy 1
- harmonica 1
- heavy 1
- heavy synthesisation 1
- hip-hop 1
- hip-hop hits 1
- home recording 1
- home video 1
- insistent 1
- intense 1
- intense drumming 1
- interactive 1
- joyful 1
- lively backup vocals 1
- lively keyboard harmony 1
- loud 1
- male singer 1
- male vocals 1
- medium fast tempo 1
- merry 1
- minimalist instrumentation 1
- muffled audio 1
- obscure audio 1
- party song 1
- party whistle 1
- peppy 1
- phonograph record 1
- plethora of instruments 1
- pop 1
- pop hits 1
- portugal 1
- progressive 1
- punchy beat 1
- punchy beats 1
- rap 1
- reggae fusion 1
- retro pop 1
- robotic voice 1
- salsa 1
- screeching 1
- sound manipulation 1
- spirited 1
- spirited drumming 1
- static 1
- synthesiser arrangement 1
- synthesiser articulation 1
- tambourine beat 1
- tambourine beats 1
- thumping 1
- thumping sounds 1
- trumpets animated trumpet 1
- turntable 1
- vibrant 1
- vibrations 1
- vinyl disc 1
- vocal backup 1
- workout music 1
musiccaps_names (array) 19 ✖
- Music 7
- Music of Africa 2
- Afrobeat 1
- Beatboxing 1
- Burst, pop 1
- Crackle 1
- Dance music 1
- Drum and bass 1
- Drum machine 1
- Dubstep 1
- Electronic dance music 1
- Exciting music 1
- Grunge 1
- House music 1
- Pop music 1
- Rattle (instrument) 1
- Sampler 1
- Shuffle 1
- Vehicle horn, car horn, honking 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DJ Fresh - Pink Panther | This music is an electronic instrumental. The tempo is medium fast with synthesiser arrangements, DJ mixer, turn table and digital drums. The music is futuristic , emphatic, intense, loud , enthusiastic; heavily synthesised and groovy. It has a psychedelic, trace-like vibe. | 2008-06-27T17:14:58Z | Henry Weallans | DJ Fresh Drum & Bass | ["Sampler", "Drum and bass", "House music", "Music", "Dubstep", "Electronic dance music", "Drum machine", "Grunge", "Dance music"] | ["instrumental", "electronic music", "drum machine", "boomy", "punchy", "buoyant", "sound manipulation", "phonograph record", "vinyl disc", "heavy synthesisation", "female backup", "vocalisation", "futuristic", "progressive", "insistent", "compelling", "dj mixer", "synthesiser articulation", "dance music", "edm", "club music", "energetic", "intense", "heavy", "punchy", "groovy", "atmospheric", "youthful", "spirited", "psychedelic"] | 7 | A8b-0yWXBCE | 1073 | |
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 | |
Hora Quente com Vencedores Conc. Inter. Kizomba Angola 2012 | A male vocalist sings this high spirited Portugal song. The tempo is fast with keyboard harmony, punchy drumming, groovy bass lines, animated trumpets, backed with harmonica, party whistles, lively vocalisation and vocal backup, tambourine beats and congas. This song is a sonic treat with a plethora of instruments in perfect sync and harmony. It is happy, joyful and merry with a dance groove. | 2012-04-21T00:28:34Z | Samir Gomes | Hora Quente | ["Music of Africa", "Music", "Rattle (instrument)"] | ["male vocals", "fast tempo", "cheerful", "cheerful drumming", "funky basslines", "animated trumpets", "harmonica", "plethora of instruments", "congas", "dance groove", "party song", "festivities", "happy", "joyful", "merry", "tambourine beat", "congas", "party whistle", "trumpets animated trumpet", "vocalisation", "vocal backup", "portugal", "dance music", "salsa", "spirited drumming", "funky bass lines", "lively keyboard harmony"] | 7 | FDO5BekX478 | 1624 | |
jamie and millie couple shuffle | This is Electronic Dance music. The tempo is fast with synthesiser arrangements, punchy Digital drum rhythm, electronic sounds and a recurring, catchy vocal riff with the sound of talking in the background.The music is obscure as it is an amateur recording . It is buoyant, youthful, energetic, enthusiastic, and pulsating with a dance groove. | 2009-05-03T12:50:31Z | Carnesy | ["Music", "Shuffle"] | ["instrumental", "fast tempo", "electronic music", "obscure audio", "thumping sounds", "vocalisation", "punchy beats", "robotic voice", "background chatter", "electronically arranged music", "home video", "home recording", "muffled audio", "psychedelic", "dance music", "edm", "catchy vocal riff"] | 7 | K2h6UiZSoZ4 | 2054 | ||
K'Naan ABC's | Male vocalist sings this upbeat Hip-Hop song. The tempo is fast with minimal instrumentation of a lively infectious, punchy drumming and enthusiastic vocal backup and incessant, vigorous vocalisation. The song is buoyant, catchy, punchy, funky, youthful,groovy, engaging, vibrant and vivacious. This song is contemporary Hip-Hop/Rap. | 2009-01-23T20:28:16Z | K'naan Warsame | The new video for "ABC's" from K'NAAN's upcoming release "Troubador"; featuring Chubb Rock | ["Afrobeat", "Music of Africa", "Music", "Exciting music"] | ["male singer", "lively backup vocals", "alternative hip-hop", "reggae fusion", "interactive", "vocalisation", "fast tempo", "infectious drumming", "keyboard harmony", "hip-hop", "rap", "hip-hop hits", "minimalist instrumentation", "upbeat", "catchy", "buoyant", "punchy", "peppy", "perky", "dj", "dj mixer", "dance pop", "dance music", "dance groove", "club music", "groovy", "funky"] | 7 | Ovk5EfFj7Ws | 2482 | |
Battle of Sounds in Lapu-Lapu City Mactan,Cebu... | This song is an instrumental. The tempo is fast but as the audio quality is bad it is hard to hear the song well. The song is electronic music with a boomy, thumping drum beats, rhythmic vocalisation and electrical wave disturbance causing a screechy ,static sound. This song is an Electro Pop song. | 2014-06-16T22:09:35Z | jim earl | Category: 4pcs.Compression Driver Tweeter, 4pcs.15inches Mid-Speakers, 4pcs.18inches Sub-Speakers,3pcs.Power Amplifier unlimited wattage of Amps.,Speakers & Processors Quantity... | ["Music", "Crackle"] | ["instrumental", "loud", "thumping", "vocalisation", "energetic", "dance music", "dj", "turntable", "drum machine", "static", "fast tempo", "bad audio quality", "screeching", "thumping", "vibrations", "electronic music", "intense drumming", "dj", "club music"] | 7 | TKSFbf-wQ8I | 2831 | |
Orianthi and Michael Jackson during the "This Is It" tour rehearsals | This song is an instrumental. The tempo is slow with vigorous drumming, keyboard and electric guitar harmony,beatboxing and the sound of a car horn .The song is vibrant, punchy, vigorous and upbeat with a dance groove. This song is a Pop Hit. | 2009-08-31T18:39:09Z | OfficialOrianthi | Orianthi and Michael Jackson during the "This Is It" tour rehearsals | ["Beatboxing", "Music", "Pop music", "Vehicle horn, car horn, honking"] | ["car honking", "instrumental", "enthusiastic drumming", "keyboard harmony", "punchy beat", "dance groove", "pop", "electronic instrumentation", "beat boxing", "vocalisation", "catchy beat", "medium fast tempo", "vibrant", "youthful", "catchy", "dance music", "funky electric guitar riff", "guitar"] | 7 | t7oAteGa55g | 5008 |
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;