musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic", musiccaps_names contains "Electronica", musiccaps_names contains "Music" and musiccaps_names contains "Soul 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 |
---|---|---|---|---|---|---|---|---|---|---|
2013 BMW ActiveHybrid 3 M Sport engine sound and 0-100km/h | The Drum & Bass song features wide piano chords layered with wide synth pad chords, followed by echoing vocal melody at the beginning, double pedal kick, punchy snare and manically played hi hats. Right before the beat drops, there is a wide reverberant riser that lifts the energy of the track, preparing the listener for it. It sounds energetic, uptempo and manic - like something you would hear on commercials. | 2013-05-13T03:23:06Z | PDriveTV | 2013 BMW ActiveHybrid 3 M Sport engine sound and 0-100km/h. Head over to http://performancedrive.com.au/2013-bmw-activehybrid-3-m-sport-review-video/ for the full review. 2013 BMW ActiveHybrid 3 M Sport 3.0-litre turbo inline six-cylinder with 40kW/210Nm electric motor assist 250kW and 450Nm Eight-speed sports automatic with paddle shifters, rear-wheel drive 0-100km/h in 5.4 seconds (as tested) | ["Drum and bass", "Music", "Soul music", "Electronica"] | ["drum & bass", "wide piano chords", "echoing vocal melody", "double pedal kick", "punchy snare", "manically played hi hats", "wide reverberant riser", "wide synth pad chords", "manic", "energetic", "uptempo"] | 4 | 2zjtZYqg3Ow | 426 | |
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 |
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;