musiccaps_details (view)
9 rows where musiccaps_aspects contains "dance music", musiccaps_aspects contains "pop" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 116 ✖
- dance music · 9 ✖
- pop · 9 ✖
- youthful 7
- fast tempo 6
- club music 4
- dance groove 4
- energetic 4
- enthusiastic 4
- foreign language 4
- dj 3
- groovy bass line 3
- instrumental 3
- keyboard harmony 3
- buoyant 2
- catchy 2
- dance hits 2
- dance pop 2
- digital drums 2
- edm 2
- electronic music 2
- enigmatic 2
- funky 2
- groovy 2
- male singer 2
- male vocalist 2
- pop hits 2
- psychedelic 2
- punchy 2
- punchy drumming 2
- recurring vocal riff 2
- regional pop 2
- rhythmic acoustic guitar 2
- synth pop 2
- synthesiser arrangement 2
- synthesiser arrangements 2
- trance 2
- trap 2
- vocal backup 2
- world music 2
- acoustic guitar 1
- amateur drumming 1
- animated percussions 1
- atmospheric synthesiser 1
- beat boxing 1
- bouncy 1
- bright 1
- bright violin 1
- car honking 1
- catchy beat 1
- celebration 1
- clapping 1
- club 1
- dissonant 1
- drum machine 1
- drum rhythm 1
- electro pop 1
- electronic flute 1
- electronic instrumental 1
- electronic instrumentation 1
- electronic pop 1
- emphatic vocals 1
- enthusiastic drumming 1
- enthusiastic vocal backup 1
- enthusiastic vocals 1
- excited 1
- female singer 1
- female vocals 1
- flute 1
- folk music 1
- folk pop 1
- folk song 1
- funky bass line 1
- funky electric guitar riff 1
- guitar 1
- happy 1
- heavily synthesised 1
- high notes 1
- high pitched 1
- high spirited 1
- hip-hop pop 1
- house 1
- inferior audio quality 1
- intense electric guitar 1
- jarring 1
- lively keyboard harmony 1
- lively mandolin 1
- lively piano 1
- loud 1
- medium fast 1
- medium fast tempo 1
- medium tempo 1
- merry 1
- party hits 1
- party music 1
- people cheering 1
- people talking 1
- pop rock 1
- punchy bass lines 1
- punchy beat 1
- rapid tempo 1
- rock 1
- rock and roll 1
- shakers 1
- spirited 1
- spirited drumming 1
- straight drumming 1
- synthesised vocal riff 1
- tambourine 1
- tambourine beats 1
- trippy 1
- upbeat 1
- vibrant 1
- vigorous drumming 1
- vigorous vivacious 1
- vivacious 1
- vocalisation 1
musiccaps_names (array) 22 ✖
- Music 9
- Dubstep 2
- Electronic dance music 2
- Music of Africa 2
- Beatboxing 1
- Burst, pop 1
- Dance music 1
- Disco 1
- Electronic music 1
- Electronica 1
- Harmonic 1
- House music 1
- Inside, large room or hall 1
- Jingle (music) 1
- Musical instrument 1
- Pop music 1
- Rock music 1
- Roll 1
- Singing 1
- Ska 1
- Techno 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 |
---|---|---|---|---|---|---|---|---|---|---|
Rock 'n' Roll Girls -- John Fogerty | A male vocalist sings this spirited rock and rock song. The tempo is fast with bright drumming, intense electric guitar feedback, keyboard harmony and rhythmic acoustic guitar with vocal backup. The song is upbeat, spirited, enthusiastic, vibrant, vivacious, buoyant and youthful with a dance groove. The sound quality is inferior making it difficult to understand the lyrics or the finer elements of this Rock and Roll song. | 2008-09-03T02:10:47Z | zanzkantdance | John Fogerty performs "Rock and Roll Girls" from Centerfield live in Oakland in 1986, set to various background videos. | ["Singing", "Music", "Musical instrument", "Rock music", "Roll", "Inside, large room or hall"] | ["male vocalist", "fast tempo", "intense electric guitar", "punchy drumming", "keyboard harmony", "vocal backup", "rhythmic acoustic guitar", "groovy bass line", "loud", "jarring", "inferior audio quality", "people cheering", "people talking", "energetic", "enthusiastic", "vigorous vivacious", "bright", "enthusiastic", "dance music", "pop", "pop rock", "rock", "rock and roll"] | 7 | 1ZaxqZMs21M | 287 | |
Θα κάνω φασαρία-Γιαννούλης Βαζαίος | A male vocalist sings this animated song in a foreign language. The tempo is fast with a bright applied violin accompaniment, lively drumming, groovy bass line, tambourine beats, rhythmic mandolin and acoustic guitar accompany net. The song is lively, energetic, vibrant, happy, vivacious and merry with a dance groove. This song is a Folk Pop/Regional Pop. | 2010-06-29T13:03:59Z | mike gr | από το cd ''να μαστε πάλι[πιτσιρίκα]'' | ["Jingle (music)", "Music"] | ["male singer", "fast tempo", "regional pop", "folk pop", "emphatic vocals", "foreign language", "bright violin", "energetic", "animated percussions", "lively mandolin", "acoustic guitar", "groovy bass line", "folk song", "folk music", "world music", "pop", "pop hits", "youthful", "dance music", "celebration", "merry", "happy"] | 7 | 40D4L5Ndi6k | 529 | |
Pop Folk and Balkan hits,20.flv | A female vocalist sings this enthusiastic pop. The tempo is fast with an energetic and punchy drumming, synthesiser arrangements and flute melody. The song is youthful, enthusiastic, upbeat, vivacious, vibrant with a dance groove. This song is contemporary pop. | 2011-01-12T11:56:48Z | Fredom281 M | ["Music", "Burst, pop"] | ["female singer", "fast tempo", "flute", "electronic flute", "vivacious", "excited", "enthusiastic", "dance music", "club music", "youthful", "upbeat", "enthusiastic", "dj", "punchy drumming", "synthesiser arrangement", "enthusiastic vocals", "foreign language", "pop"] | 7 | 6VJ_auuKzss | 763 | ||
Zina Rifia "houbak nar" by SOFALK, ABDER, NABIL - Rai'n'B Fever 4 | A male vocalist sings this energetic pop song. The tempo is fast with piano accompaniment, bright digital drumming, synthesiser arrangements and groovy bass lines. The song is youthful, fresh, catchy, vivacious, upbeat, sprightly and buoyant with a dance groove. This song is a Hip-Hop Pop song. | 2011-05-01T14:45:49Z | Najim Sofalk | ZINA RIFIA AVEC SOFALK, ABDER, NABIL ET J-BEEZY ... MERCI POUR VOS COMMENTAIRES C'EST JUSTE ENORME !! | ["Music of Africa", "Music"] | ["male vocalist", "medium fast", "foreign language", "pop", "hip-hop pop", "groovy bass line", "lively piano", "digital drums", "synthesiser arrangements", "youthful", "spirited", "dance groove", "club music", "dance pop", "dance music", "groovy", "funky", "youthful", "high spirited"] | 7 | Jk2mvFrdZTU | 2030 | |
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 | |
Mahlathini & The Mahotella Queens - Mbaqanga (1991) | A male vocalist sings this upbeat song in a foreign language. The tempo is fast with a lively keyboard harmony, spirited drumming, funky bass line, rhythmic acoustic guitar, shakers enthusiastic vocal backup and clapping. The song is upbeat, high-spirited, energetic, buoyant, cheerful, peppy, happy and groovy. This song is a lively Pop song. | 2007-12-30T19:14:10Z | NickLotay | Music video to one of the group's hit songs, "Mbaqanga", from 1991. Featuring the late, great 'groaner' Simon Mahlathini Nkabinde, the everlasting Mahotella Queens (left to right: Nobesuthu Shawe, Hilda Tloubatla, Mildred Mangxola), and the unstoppable backing band Makgona Tsohle Band. Original music video with improved soundtrack. | ["Music of Africa", "Music", "Ska"] | ["male singer", "fast tempo", "foreign language", "rhythmic acoustic guitar", "groovy", "dance music", "dance groove", "pop", "shakers", "lively keyboard harmony", "spirited drumming", "funky bass line", "enthusiastic vocal backup", "clapping", "keyboard harmony", "tambourine beats", "catchy", "punchy", "bouncy", "buoyant", "energetic", "enthusiastic", "pop", "regional pop", "world music"] | 7 | TEWYFkjH2jc | 2822 | |
Mix Musica Electronica 2013 (Electro House) VOL 14 | This song is an energetic electronic instrumental. The song is medium fast tempo with an insistent synthesiser rhythm, dissonant tambourine funky bass and basic , amateur drumming, recurring vocal riff and vocal backup . The song is youthful, spirited, punchy and catchy with a dance groove. This song is an Electro Pop song. | 2013-08-16T21:54:34Z | leonel ybarra | Dj L30- Electro House 2013 , Mix de los mejores temas de electro: VOL 14 (Mix agosto 2013) Tracklist: 1-MACKLEMORE RYAN LEWIS THRIFT SHOP (DFM MIX) 2-Michael Woods Clanga (Original Mix) 3-Will Moore Super Jam (Original Mix) 4-Carnage Borgore Incredible (Original Mix) Seguime en SOUNDCLOUD: https://soundcloud.com/leonel-ybarra ----------------------------------------------------------------------------- DESCARGÁ el Mix: http://www.mediafire.com/download/6d61k3dtdz1onws/14- Si te gusto click en Mg.. :D Y SUSCRIBITE.... Best Electro & House 2014 New Years Party Mix Best Dance Music 2014 New Electro House House 2014 (Winter Love #5) Dj D3evice & MindOneBG The Best Electro House -- Dance Mix 2014 Sexy Girl ( FreeYoutube ) Electro House 2014 ! THE Best Dance Music New Electro House Hand UP 2014 #49 New Best of electro progressive House Music ( Club Mix Remix 2014 ) Electro House Mix 2014 Electro & House Club Mix 2014 | Bangerbeatz Ep.49 (PeeTee vs Merk & Kremont) New Techno & Electro House Hands Up 2014 { Sexy DIRTY House Music } #32 Electro & House 2014 Dance Mix #57 New Best Electro House Techno 2014 #28 NEW BEST ELECTRO HOUSE MUSİC MIX 2013/2014 CLUB MİX NEW DANCE MUSİC ELECTRO HOUSE MUSIC MIX 2013 NEW ELECTRONIC DUBSTEP MUSIC 2013 [EP.2] BEST ELECTRO HOUSE MIX OF 2012 / SPECIAL ELECTRO MIX / [EP.24] - By Dj Epsilon BEST OF 2013 ELECTRO HOUSE MIX - NEW #23 BEST DAMN ELECTRO HOUSE MIX OF 2013 / SPECIAL ELECTRO DANCE MIX / [EP.47] - By Dj Epsilon Dirty Electro House Music Mix 2014 The best Mix Electro House MUSIC 2014 #27 Electro & House Club Mix 2014 | Bangerbeatz Ep.49 (PeeTee vs Merk & Kremont) THE BEST ELECTRO HOUSE MUSIC HAPPY NEW YEAR MIX 2014 Best Dance Music 2014 New Electro House House 2014 (Winter Love #5) Dj D3evice & MindOneBG Electro House New Best Club Mix Remix Radio Edit 2014 Music { Sexy Hot Girl } BEST Electro & House Dance Charts Party Mix 2014 #53 BEST ELECTRO HOUSE & CLUB PROGRESSIVE DANCE MUSIC MEGAMIX 2013 [100 MIN] | DJ Adi-G Musica Electronica 2014 2013 NEW The Best Of The Ele… | ["Disco", "House music", "Music", "Electronic dance music", "Dance music", "Electronica"] | ["instrumental", "fast tempo", "electro pop", "amateur drumming", "house", "dj", "dance music", "punchy", "funky", "youthful", "buoyant", "synthesiser arrangement", "tambourine", "punchy bass lines", "straight drumming", "recurring vocal riff", "dance music", "synth pop", "pop", "pop hits", "vocal backup"] | 7 | UUJ1DNycpiQ | 2919 | |
Da Blitz - Moving On (mickey o'hare & dj harmonic remix) | This song is an electronic instrumental. The song is fast tempo with vigorous drumming and electronic instrumentation and synthesiser articulation with catchy synthesised vocal riff which. The song is upbeat, vibrant, vivacious, vigorous, psychedelic, enigmatic and youthful with a trance like dance vibe. This song is an EDM/Synth pop. | 2012-04-17T14:06:31Z | MakinaMuzika | www.facebook.com/makinamuzika | ["Music", "Techno", "Dubstep", "Electronic dance music", "Harmonic"] | ["edm", "instrumental", "fast tempo", "synth pop", "edm", "electronic pop", "electronic instrumental", "synth pop", "dance hits", "rapid tempo", "dance music", "trance", "trap", "psychedelic", "pop", "electronic music", "vigorous drumming", "synthesiser arrangements", "synthesised vocal riff", "recurring vocal riff", "club music", "dance hits", "party hits", "youthful", "energetic", "enigmatic", "enthusiastic", "dj"] | 7 | lGaA1dJQ0AQ | 4387 | |
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;