musiccaps_details (view)
6 rows where musiccaps_aspects contains "groovy bass" and musiccaps_names contains "Electronic 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Fifth Element - Techno opera | The low quality recording features a passionate female vocalist singing over dissonant brass stabs, groovy bass, wooden snare hits, synth pad chords, punchy kicks and shimmering hi-hats. It sounds groovy and passionate. | 2010-05-17T19:22:17Z | 1kRaFt (KRAFTWIN) | Fifth Element - Techno opera. Original: Performed by Inva Mula. Composed and Produced by Eric Serra. More: http://www.imdb.com/title/tt0119116/soundtrack | ["Electronic music", "Music", "Opera", "Techno"] | ["low quality", "dissonant brass stabs", "groovy bass", "passionate female vocal", "wooden snare hits", "punchy kick", "shimmering hi hats", "groovy", "passionate", "synth pad chords"] | 4 | WE0JqjuhaQI | 3076 | |
| 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 | |
| Skibadee + Bashy MC FACEOFF 1XTRA | The low quality recording features a hip hop song where a fruity male vocal is rapping over punchy kick and snare hits, shimmering hi hats, groovy bass and brass melody. It sounds bouncy, groovy and upbeat. | 2007-04-17T08:17:05Z | danshish | Skibadee + Bashy MC FACEOFF on 1XTRA then some other mc's | ["Drum and bass", "Electronic music", "Music", "Rapping", "Hip hop music"] | ["low quality", "hip hop", "fruity male vocal", "brass melody", "punchy kick", "punchy snare", "shimmering hi hats", "groovy bass", "groovy", "bouncy", "upbeat"] | 4 | YZvv4hOlNqw | 3294 | |
| album dugem house music indonesia 2011 mp3 terbaru 2011 2012 new update flv.FLV - YouTube.flv | The low quality recording features a house music that consists an echoing female scream and reverberant flat male vocal over repetitive percussive synth melody, wooden percussions, groovy bass, shimmering hi hats, reversed snare hits and punchy "4 on the floor" kick pattern. It sounds hypnotic, energetic and exciting. | 2012-02-26T04:24:43Z | Ymas Por | ["Disco", "Electronic music", "Music"] | ["house music", "low quality", "echoing female scream", "down sweep synth", "repetitive percussive synth melody", "wooden percussions", "groovy bass", "punchy \"4 on the floor\" kick pattern", "shimmering hi hats", "reverberant flat male vocal", "reversed snare hits", "energetic", "hypnotic", "exciting"] | 4 | hhU78ykPr5w | 4127 | ||
| 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;