musiccaps_details (view)
2 rows where musiccaps_aspects contains "low quality" and musiccaps_names contains "Groan"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- low quality · 2 ✖
- chain rattle sound effect 1
- clothes movement sound effect 1
- door opening sound effect 1
- filtered male breathing sound effects 1
- high pitched male chant 1
- intense 1
- loud white noise 1
- male muffled screaming sound effect 1
- male scream 1
- manic 1
- monster roar sound effects 1
- repetitive 1
- room tone ambience 1
- suspenseful 1
- synth pad 1
- video game 1
- weird 1
- weird male chant 1
- wide strings rising melody 1
youtube_published (date) 2 ✖
- 2008-10-03 1
- 2011-02-04 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
[iOS] Dead Space Boss Alternate Death with Sound HD | The low quality video features a filtered male breathing sound effects, muffled male screaming sound effects, monster roar sound effects and wide strings rising melody. It sounds intense and suspenseful, almost like some old horror movie with low quality sound. | 2011-02-04T02:34:23Z | PlayervsGame | Death by Chomp iPhone, iPod Touch, iTouch, iPad | ["Music", "Groan"] | ["low quality", "filtered male breathing sound effects", "suspenseful", "wide strings rising melody", "intense", "monster roar sound effects", "male muffled screaming sound effect", "video game"] | 4 | VLjcIlZvkY0 | 2992 |
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;