musiccaps_details (view)
1 row where musiccaps_aspects contains "groovy bongos", musiccaps_aspects contains "pulsating filter modulated riser", musiccaps_aspects contains "shimmering shakers" and musiccaps_names contains "Electronica"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;