musiccaps_details (view)
2 rows where musiccaps_aspects contains "repetitive", musiccaps_aspects contains "weird" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- low quality 2
- repetitive · 2 ✖
- weird · 2 ✖
- chain rattle sound effect 1
- clothes movement sound effect 1
- door opening sound effect 1
- harsh 1
- high pitched male chant 1
- loud horn sound 1
- loud white noise 1
- male scream 1
- manic 1
- room tone ambience 1
- synth pad 1
- traditional song 1
- weird male chant 1
- wooden impact 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 | |
MOHANLAL-the dancing phenomenon... | The low quality recording features a traditional song played in the beginning, after which there is a loud horn sound and wooden impact. It sounds weird, harsh and repetitive. | 2011-01-15T01:15:14Z | vinurom | "Any dancer may dance like him...but no actor can... Any actor may act like him....but no dancer can....".....That is Mohanlal...the dancing phenomenon.. | ["Wind instrument, woodwind instrument", "Shofar"] | ["low quality", "wooden impact", "loud horn sound", "traditional song", "weird", "repetitive", "harsh"] | 4 | aBEiuYSSEH0 | 3516 |
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;