musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "punchy "4 on the floor" kick pattern" and musiccaps_names contains "House music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Youtube mix - Deep, Soulful, Underground Part 6 | The low quality recording features an electro house song that consists of punchy "4 on the floor" kick pattern, claps, funky electric guitar melody, groovy synth keys, groovy bass that glues everything together and shimmering shakers. It sounds a bit muddy, but also energetic, fun and exciting - like something you would hear in clubs during 70s and 80s a lot. | 2007-07-07T04:25:13Z | laurentkm3 | Cue Kids -- Fruity Grooves part 2 (In Love) Cajmere feat Dajae--Brighter Days (Original Mix) Laurent presents Center of the Earth Music - The Deep.The Soulful.The Underground. I do a live one hour deep, soulful, and underground mix show from 11am-noon every Tuesday EST at http://www.faderwave.net/ Just go to the website and look at the top left hand side where it says "TUNE IN NOW!" ENJOY!!!!! | ["House music", "Music", "Techno", "Soul music", "Electronica"] | ["low quality", "mono", "house", "punchy \"4 on the floor\" kick pattern", "claps", "funky electric guitar", "groovy synth keys", "groovy bass", "shimmering shakers", "energetic", "exciting", "fun", "muddy"] | 4 | EmSZKb0LdVM | 1587 | |
Dancing to Techno Music | The low quality recording features a techno song that consists of DJ scratching sound effects, groovy bass, buzzy synth leads, punchy "4 on the floor" kick pattern, shimmering hi hats and some claps. It sounds energetic, aggressive and weird - due to those synth lead "screams". | 2007-10-27T05:55:40Z | Sebastien Verrot | A french dancer, Spoke, dancing to techno music with a combination of smurf, break dance and tecktonik. | ["Electronic music", "House music", "Music", "Techno"] | ["techno", "low quality", "dj scratching sound effects", "groovy bass", "buzzy synth leads", "punchy \"4 on the floor\" kick pattern", "shimmering hi hats", "claps", "energetic", "weird", "aggressive"] | 4 | nvoGwmKh6NI | 4592 | |
Stardust - Music Sounds Better With You (Stardust Electric Remix) | The Electro song features a punchy "4 on the floor" kick pattern perfectly complemented by groovy bass, followed by tinny laser percussive sound effects, shimmering cymbals, claps and echoing pulsating synth lead melody. Sounds energetic, a bit addictive thanks to that synth lead and something like you would hear in electronic dance music clubs. | 2011-06-06T15:30:08Z | francescoivrea | The Original 2008 Electro Remix by Stardust for his amazing single Label:Not On Label Catalog#:DUST001 Format:Vinyl, 12", White Label, Single Sided, Unofficial Release Country:UK Released:03 Dec 2008 Genre:Electronic Style:House, Electro | ["Electronic music", "House music", "Music"] | ["electro", "tinny laser percussive sound effect", "punchy \"4 on the floor\" kick pattern", "clapping", "shimmering cymbals", "echoing pulsating synth lead melody", "energetic", "addictive", "groovy bass"] | 4 | tllFsEPv7Ls | 5062 |
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;