musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy" and musiccaps_names = "["Disco"]"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DJ Snake & AlunaGeorge - You Know You Like It (T-Mass & Arman Cekin Remix) | A female singer sings this cool melody with backup singers in vocal harmony. The song is fast tempo with a percussive bass line, steady drumming with various percussion hits, keyboard harmony and other sonic effects. The song is groovy and exciting. The song is a modern techno dance hit. | 2015-05-09T16:08:18Z | Trap City | PREMIERE: DJ Snake & AlunaGeorge - You Know You Like It (T-Mass & Arman Cekin Remix) Subscribe here: http://trapcity.tv/subscribe Free Download: http://trapcity.tv/uvjbX ➥ Become a fan of Trap City: http://trapcity.tv/soundcloud http://trapcity.tv/facebook http://trapcity.tv/twitter http://trapcity.tv/instagram http://trapcity.tv/vine http://trapcity.tv/plugdj http://www.trapcity.net ➥ Follow T-Mass: http://www.soundcloud.com/t-mass http://www.facebook.com/tmassofficial http://www.twitter.com/tmassofficial http://www.instagram.com/tmassofficial ➥ Follow Arman Cekin: http://www.soundcloud.com/armancekin http://www.facebook.com/arman.cekin http://www.twitter.com/cekinarman http://www.instagram.com/armancekin | ["Disco"] | ["female singer", "backup singers", "vocal harmony", "techno dance music", "electronic dance music", "percussive bass line", "percussive hits", "keyboard accompaniment", "exciting", "dj", "party night", "dance with you", "careless nights", "exciting", "enthusiastic", "groovy", "passionate", "romantic", "ibiza nights", "tropical beach party", "sundowner", "fast percussion rhyme", "fast tempo"] | 1 | B2yLFcmZ51I | 1197 | |
Mariah Carey - Fantasy + Lyrics (HD) | This is an R&B/pop dance music piece. There is a versatile female vocalist singing melodically. There is a keyboard and an electric guitar playing the melody while there is a groovy bass guitar line in the background. The rhythmic background is provided by an electronic drum beat. The atmosphere is urban and danceable. This piece could be used in the soundtrack of a romantic comedy movie. | 2009-05-30T15:48:31Z | MIMINHEROFOREVER | Oh when you walk by every night Talking sweet and looking fine I get kind of hectic inside Oh baby I'm so into you Darling if you only knew All the things that flow through my mind But it's just a [Chorus:] Sweet sweet fantasy baby When I close my eyes You come and take me On and on and on It's so deep in my daydreams But it's just a sweet sweet fantasy baby Images of rapture Creep into me slowly As you're going to my head And my heart beats faster When you take me over Time and time and time again But it's just a [Chorus] I'm in heaven With my boyfriend My laughing boyfriend There's no beginning and there is no end Feels like I'm dreaming but I'm not sleeping It's just a [Chorus] | ["Disco"] | ["r&b", "pop dance", "versatile female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "groovy", "urban", "danceable"] | 9 | JmbrGzgxrJ4 | 2032 | |
"Same Heart" - Bella Thorne & Zendaya [OFFICIAL FULL] (Lyrics Video) HQ | The low quality recording features a pop song that consists a passionate female lead vocal, alongside harmonizing female vocal, singing over groovy synth bas, claps, shimmering hi hats, punchy "4 on the floor" kick pattern, electric guitar melody and short groovy synth keys chords. It sounds energetic, groovy and addictive. The recording is noisy. | 2012-08-08T23:07:02Z | BellaDisneyLyrics | Song: Same Heart Artist: Zendaya ft.Bella Thorne Album: Shake It Up: Made In Japan | ["Disco"] | ["low quality", "pop", "groovy synth bass", "passionate female lead vocal", "harmonizing female vocal", "claps", "shimmering hi hats", "punchy \"4 on the floor\" kick pattern", "electric guitar melody", "short groovy synth keys chords", "energetic", "groovy", "addictive", "noisy"] | 4 | ojdqgnmcgYM | 4654 |
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;