musiccaps_details (view)
1 row where musiccaps_aspects contains "creepy atmosphere", musiccaps_author = 6 and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Creepy old Music box - "When Memories Break" | This file contains audio playing a high pitched melody on a music box. The melody sounds a little freighting and is full of reverb. From the recording you can hear a little bit of white noise. This song may be playing in a horror movie scene. | 2014-06-18T12:35:57Z | BadWabbitz | a music box thang i made using fl studio. "When memories break" Named by LPS LIVIE. Sharing your short stories is highly encouraged, I enjoy reading. This piece is stock, keeping sound effects to a bare minimum. Adding your own effects if you choose to use is fine and encouraged. Anyone can use this song for whatever freely, please give credit. If you'd like to read some of my short stories head on over to https://www.reddit.com/user/BadWabbitz/submitted/ Picture - Gravity Falls. - i love it's a creepy picture | ["Jingle (music)", "Music"] | ["dark melody", "music box", "white noise", "creepy atmosphere"] | 6 | 0ewQiU3q5jM | 194 |
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;