musiccaps_details (view)
3 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2008-10-03
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- low quality 3
- energetic 2
- exciting 2
- addictive 1
- boomy 808 bass 1
- chain rattle sound effect 1
- claps 1
- clothes movement sound effect 1
- distorted filtered bass 1
- door opening sound effect 1
- high pitched male chant 1
- hip hop 1
- loud white noise 1
- male scream 1
- manic 1
- punchy kick 1
- repetitive 1
- room tone ambience 1
- shimmering hi hats 1
- siren sound effect 1
- sustained synth lead 1
- synth lead melody 1
- synth pad 1
- tinny hi hats 1
- weird 1
- weird male chant 1
- wide aggressive electric guitars 1
- wide punchy toms 1
- wide reverberant flat male vocal 1
musiccaps_names (array) 6 ✖
- Music · 3 ✖
- Angry music 1
- Groan 1
- Hip hop music 1
- Rapping 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Kovenant - Cybertrash | The low quality recording features a wide punchy toms, wide aggressive electric guitars, sustained synth lead, distorted filtered bass and tinny hi hats. It sounds energetic and exciting. | 2008-10-03T23:56:49Z | Ricksboycc | For you to Enjoy. | ["Music", "Angry music"] | ["low quality", "wide punchy toms", "wide aggressive electric guitars", "sustained synth lead", "distorted filtered bass", "energetic", "exciting", "tinny hi hats"] | 4 | 3ZhyXbwFQAM | 483 | |
Roy Jones Jr - I Smoke I Drank | The low quality recording features a hip hop song that consists of a wide reverberant flat male vocal rapping over synth lead melody, sire sound effects, punchy kick, boomy 808 bass, claps and shimmering hi hats. It sounds exciting, energetic and addictive - like something you would hear in clubs. | 2008-10-03T14:48:46Z | Body Head Entertainment Films | Roy Jones Jr, Youngbloods and Body Head Bangerz | ["Music", "Rapping", "Hip hop music"] | ["low quality", "hip hop", "synth lead melody", "siren sound effect", "punchy kick", "boomy 808 bass", "claps", "shimmering hi hats", "wide reverberant flat male vocal", "energetic", "exciting", "addictive"] | 4 | RmDfwz0OG8E | 2723 | |
random shoop da whoop collection 2 | The low quality recording features a door opening, room tone ambience, clothes movement and chain rattle sound effects, followed by repetitive high pitched male chant, weird male chant, sudden, loud white noise layered with male scream. In the second part of the clip, there is a synth pad in the background. It sounds aggressive, loud, harsh and weird, almost like a parody clip. | 2008-10-03T15:42:09Z | m1el1puol1m1es | its back! its funny! its scary! its lethal! its Shoopdawhoopitastic! kingdom hearts, jak, sonic and shadow! | ["Music", "Whoop", "Groan"] | ["low quality", "door opening sound effect", "repetitive", "room tone ambience", "chain rattle sound effect", "weird male chant", "high pitched male chant", "loud white noise", "male scream", "manic", "weird", "clothes movement sound effect", "synth pad"] | 4 | TWm0OilO0uw | 2840 |
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;