musiccaps_details (view)
1 row where musiccaps_aspects contains "twisted", musiccaps_names contains "Music" and musiccaps_names contains "Scary 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 |
---|---|---|---|---|---|---|---|---|---|---|
What music are you into? - Undertale version | The song is an instrumental with a devilish voice laughing. The tempo is fast with a fast paced drumming rhythm with strong cymbal crashes. The song is probably an adult animated show designed to scare. | 2015-12-24T02:11:49Z | JakobTheQuizGuy | I dig ghost music. All rights to Undertale belong to Toby Fox. Buy Undertale here: http://undertale.com/ | ["Music", "Scary music"] | ["scary laugh", "twisted", "psychological", "satanic", "designed to scare", "devilish music", "spooky", "horror show", "creeps", "jeepers creeps", "percussive bass line", "fast tempo", "scary children’s show", "fast drumming rhythm", "heavy cymbal crashes", "instrumental music"] | 1 | 1ArUx6UCxe4 | 245 |
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;