musiccaps_details (view)
2 rows where musiccaps_aspects contains "funk", musiccaps_aspects contains "groovy bass" and musiccaps_names contains "Funk"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- funk · 2 ✖
- groovy bass · 2 ✖
- low quality 2
- 4 on the floor kick 1
- addictive 1
- claps 1
- funky 1
- funky keys melody 1
- groovy 1
- noisy 1
- passionate male vocal 1
- punchy snare 1
- shimmering hi hats 1
- shimmering open hat 1
- shimmering shakers 1
- unbalanced stereo 1
- wide arpeggiated synth strings melody 1
- wooden percussive elements 1
musiccaps_names (array) 3 ✖
- Funk · 2 ✖
- Music 2
- 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 | |
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;