musiccaps_details (view)
2 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "techno" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- low quality · 2 ✖
- techno · 2 ✖
- aggressive 1
- buzzy synth leads 1
- claps 1
- compilation 1
- crushed 1
- distorted 1
- dj scratching sound effects 1
- energetic 1
- groovy bass 1
- heavy 1
- punchy "4 on the floor" kick 1
- punchy "4 on the floor" kick pattern 1
- shimmering hi hats 1
- shimmering open hat 1
- thin 1
- weird 1
- wide percussive elements 1
musiccaps_names (array) 5 ✖
- Music 2
- Electronic music 1
- House music 1
- Roll 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
audio era mini sound system.wmv | The low quality recording features a techno song that consists of a compilation of sounds. The first version is thin and crushed, as it was played on a speaker and recorded with a poor microphone. The second version is the actual song being played, which consists of a "4 on the floor" kick patter, wide percussive elements and shimmering open hats. The final, third version is crushed, distorted and heavy as it consists of very loud kick punches. | 2010-03-24T12:47:26Z | audioeraprofessional | new 12" sound box(t-box)design of audio era | ["Music", "Roll"] | ["low quality", "thin", "distorted", "punchy \"4 on the floor\" kick", "shimmering open hat", "crushed", "techno", "wide percussive elements", "compilation", "heavy"] | 4 | 2f1UXGix_Cw | 394 | |
Dancing to Techno Music | The low quality recording features a techno song that consists of DJ scratching sound effects, groovy bass, buzzy synth leads, punchy "4 on the floor" kick pattern, shimmering hi hats and some claps. It sounds energetic, aggressive and weird - due to those synth lead "screams". | 2007-10-27T05:55:40Z | Sebastien Verrot | A french dancer, Spoke, dancing to techno music with a combination of smurf, break dance and tecktonik. | ["Electronic music", "House music", "Music", "Techno"] | ["techno", "low quality", "dj scratching sound effects", "groovy bass", "buzzy synth leads", "punchy \"4 on the floor\" kick pattern", "shimmering hi hats", "claps", "energetic", "weird", "aggressive"] | 4 | nvoGwmKh6NI | 4592 |
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;