musiccaps_details (view)
2 rows where musiccaps_aspects contains "uptempo", musiccaps_author = 4 and musiccaps_names contains "Soul music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- energetic 2
- uptempo · 2 ✖
- double pedal kick 1
- drum & bass 1
- echoing vocal melody 1
- flat female vocal 1
- folk/country 1
- groovy 1
- groovy acoustic rhythm guitar 1
- groovy snare 1
- live performance 1
- low quality 1
- manic 1
- manically played hi hats 1
- punchy snare 1
- smooth double bass 1
- stereo microphone technique 1
- violins melody 1
- wide piano chords 1
- wide reverberant riser 1
- wide synth pad chords 1
musiccaps_names (array) 5 ✖
- Music 2
- Soul music · 2 ✖
- Drum and bass 1
- Electronica 1
- Swing music 1
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 | |
Stray Hens - Cluck Old Hen | The low quality recording features a live performance of a folk/country song that consists of flat female vocal singing over smooth double bass, groovy acoustic rhythm guitar, violins melody and groovy snare rhythm. It sounds a bit noisy and roomy, as it was probably recorded with a stereo microphone technique, but also energetic, uptempo and groovy. | 2014-10-20T13:00:26Z | Stray Hens | Stray Hens Bastings Street Sessions: just for fun. Mandy Connell, Rowena Wise, Sally Taylor, Ryan Tews & Richard Grace, making a foray into old-timey tunes with Sally Taylor (also from bands Appalachian Heaven, the Ugly Uncles and Rising Tide) leading the vocals. With thanks to Andy Reid (venue), Jono Trevillian (camera work), Danni Dragonfire (camera work), Agostino Soldati (fancy camera gear), ryan tews (audio visual gear, production, and editing) | ["Swing music", "Music", "Soul music"] | ["low quality", "flat female vocal", "groovy snare", "smooth double bass", "groovy acoustic rhythm guitar", "violins melody", "live performance", "groovy", "folk/country", "stereo microphone technique", "uptempo", "energetic"] | 4 | P25JeM4lPGw | 2495 |
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;