musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "low quality" 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 | |
DJ Princess @ Pulse | The low quality recording features an electro song being played in a club and it consists of high pitched, repetitive, female vocals singing over groovy bass, punchy snare hits and shimmering hi hats. It sounds upbeat and energetic, even though the sound is muffled, noisy and in mono. | 2007-09-10T06:28:59Z | Shannon Wood | spinnin' at our (dubbz, me) bday party 8/31/07 | ["Electronic music", "House music", "Music", "Pulse"] | ["low quality", "boomy", "muffled", "high pitched female vocals", "jungle", "groovy bass", "punchy snare", "shimmering hi hats", "upbeat", "noisy", "mono", "energetic"] | 4 | XI9CNsX6JSE | 3173 | |
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 |
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;