musiccaps_details (view)
2 rows where musiccaps_aspects contains "4 on the floor kick", musiccaps_aspects contains "low quality", musiccaps_aspects contains "shimmering open hat" and musiccaps_aspects contains "shimmering shakers"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Budai, Vic - Viami Mice (Original Mix) [Deux Minds Records] | The Dance Electronic track features a filtered clapping, suspenseful synth arpeggio melody, shimmering open hat, subtle hi hat, tinny syncopated percussive element, groovy bongos located in the right channel and pulsating filter modulated riser that bring the energy up. In the second part of the loop there is a "4 on the floor" kick pattern with a slight variation, alongside wide, echoing female exhales and shimmering shakers. It sounds low quality, especially since there is a tiny audio cutout, but also energetic, like something you would hear in the clubs. | 2013-01-23T09:04:23Z | Hegedűs András | ["Drum and bass", "Music", "Techno", "Electronica"] | ["dance/electronic", "low quality", "4 on the floor kick", "filtered clapping", "suspenseful synth arpeggio melody", "shimmering open hat", "subtle hi hat", "tinny syncopated percussive element", "groovy bongos", "energetic", "shimmering shakers", "pulsating filter modulated riser", "wide echoing female exhale", "audio cutout"] | 4 | O28kY0aN8VI | 2393 |
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;