musiccaps_details (view)
1 row where musiccaps_aspects contains "repetitive", musiccaps_aspects contains "room tone ambience" and musiccaps_aspects contains "synth pad"
This data as json, CSV (advanced)
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;