musiccaps_details (view)
1 row where musiccaps_aspects contains "repetitive" and musiccaps_names contains "Groan"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- chain rattle sound effect 1
- clothes movement sound effect 1
- door opening sound effect 1
- high pitched male chant 1
- loud white noise 1
- low quality 1
- male scream 1
- manic 1
- repetitive · 1 ✖
- room tone ambience 1
- synth pad 1
- weird 1
- weird male chant 1
youtube_published (date) 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 |
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;