musiccaps_details (view)
2 rows where musiccaps_aspects contains "distorted", musiccaps_aspects contains "punchy "4 on the floor" kick" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- crushed 2
- distorted · 2 ✖
- low quality 2
- punchy "4 on the floor" kick · 2 ✖
- compilation 1
- electro 1
- energetic 1
- exciting 1
- groovy bass 1
- harmonizing male vocals 1
- heavy 1
- live performance 1
- repetitive electric guitar melody 1
- repetitive synth keys melody 1
- shimmering hi hats 1
- shimmering open hat 1
- shimmering open hats 1
- techno 1
- thin 1
- wide percussive elements 1
musiccaps_names (array) 4 ✖
- Music 2
- Burst, pop 1
- Exciting music 1
- Roll 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 | |
Benjamin Diamond - Music Sounds Better With You (Part One) @ CABARET ALEATOIRE | The low quality recording features a live performance that contains harmonizing male vocals singing over repetitive synth keys and electric guitar melody, followed by groovy bass, shimmering hats and punchy "4 on the floor" kick pattern. The recording is noisy, distorted and crushed, but it sounds energetic and exciting. | 2009-02-21T12:37:05Z | mikanou2410 | Stardust - Music Sounds Better With You WWW.SPLASHMYMILK.COM | ["Music", "Burst, pop", "Exciting music"] | ["harmonizing male vocals", "low quality", "electro", "energetic", "exciting", "punchy \"4 on the floor\" kick", "distorted", "repetitive electric guitar melody", "repetitive synth keys melody", "groovy bass", "shimmering open hats", "shimmering hi hats", "live performance", "crushed"] | 4 | kbAMGp-TKJo | 4333 |
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;