musiccaps_details (view)
3 rows where musiccaps_aspects contains "funk" and musiccaps_aspects contains "groovy bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- funk · 3 ✖
- groovy bass · 3 ✖
- low quality 3
- funky 2
- groovy 2
- punchy snare 2
- shimmering hi hats 2
- 4 on the floor kick 1
- addictive 1
- brass melody 1
- claps 1
- crowd cheering 1
- crowd singing 1
- funky keys melody 1
- noisy 1
- passionate male vocal 1
- punchy kick 1
- shimmering bells glissando 1
- shimmering open hat 1
- shimmering shakers 1
- unbalanced stereo 1
- weird arrangement 1
- wide arpeggiated synth strings melody 1
- wooden percussive elements 1
musiccaps_names (array) 4 ✖
- Music 3
- Funk 2
- Exciting music 1
- Music of Africa 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Wildfire - Dance With Me - FUNK | The low quality recording features a funk song that consists of passionate male vocal singing over shimmering open hats and shakers, funky and groovy keys melody, groovy bass, wooden percussive elements and "4 on the floor" kick pattern. It is noisy, but also funky and the stereo image is unbalanced, as the song is leaning towards the right channel. | 2015-06-21T00:15:31Z | Djegu | Wild Fire – WFP-0003 http://www.discogs.com/Wildfire-Time-Is-The-Answer/release/3557173 http://www.juno.co.uk/products/tropical-disco-hustle-volume-2/569473-01/ | ["Music of Africa", "Funk", "Music"] | ["low quality", "funk", "funky keys melody", "shimmering shakers", "shimmering open hat", "passionate male vocal", "wooden percussive elements", "groovy bass", "4 on the floor kick", "noisy", "unbalanced stereo"] | 4 | DdxW_JziHTA | 1500 | |
Stand-Up Revolution Music Video performed by Ozomatli | The low quality recording features a funk song that consists of crowd cheering and crowd singing over punchy kick and snare hits, shimmering hi hats, brass melody and groovy bass. There is a shimmering bell glissando that serves as a transition into the next section. Overall it sounds funky and groovy. | 2013-02-08T00:23:37Z | Gabriel Iglesias | Stand-Up Revolution Music Video performed by 3 time Grammy nominated OZOMATLI! Director: Alex Ferarri http://alexferrari.com Want to see me live? Check out http://fluffyguy.com/tour-dates to see when I'm in your area! If you really want to take our relationship to the next level?!? Like me on Facebook. http://facebook.com/fluffyguy Subscribe on my YouTube. http://youtube.com/fluffyguy Add me on Google+ http://fluffyguy.com/googleplus and Follow me on Twitter. http://twitter.com/fluffyguy Website. http://fluffyguy.com Webstore. http://fluffyshop.com OZOMATLI Facebook: http://www.facebook.com/ozomatli Twitter: http://twitter.com/ozomatli Youtube: http://www.youtube.com/Ozomatli | ["Music", "Exciting music"] | ["low quality", "crowd cheering", "crowd singing", "funk", "punchy snare", "brass melody", "groovy bass", "shimmering hi hats", "punchy kick", "weird arrangement", "shimmering bells glissando", "funky", "groovy"] | 4 | xzU6sJot-Gk | 5374 | |
Tigerstyle With Kaka Bhania - Nachna Onda Nei | The low quality recording features a funk song that consists of a groovy bass, shimmering hi hats, punchy snare, claps and wide arpeggiated synth strings melody. It sounds groovy, funky and addictive. | 2008-04-28T18:57:31Z | Kazoo | It's the soundtrack of Sulemans and Madhus performance on Britain's got Talent. | ["Funk", "Music"] | ["low quality", "funk", "groovy bass", "shimmering hi hats", "claps", "punchy snare", "wide arpeggiated synth strings melody", "groovy", "funky", "addictive"] | 4 | ymuRKv9iJm4 | 5439 |
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;