musiccaps_details (view)
1 row where musiccaps_aspects contains "melodic", musiccaps_author = 6 and "youtube_published" is on date 2008-12-30
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 |
---|---|---|---|---|---|---|---|---|---|---|
Windows Vista Instant BSOD (7F) When Unplugging Dazzle Capture Card | A lo-fi pluck, bell sound is playing an arpeggio melody. It sounds dreamy and melancholic. This song may be playing in a sequence of a video game. | 2008-12-30T21:31:02Z | pokemonfan4000 | The music playing is the game over theme from A Link To The Past running off my Gamecube. Remember my Dazzle capture card I use to record some of my videos with? Well, to get an instant Blue Screen of Death with stop code 7F on Windows Vista, simply remove the Dazzle's USB cable when Pinnacle Studio is using it. | ["Ice cream truck, ice cream van", "Music"] | ["melodic", "slower tempo", "dreamy lo-fi sound", "amateur recording"] | 6 | tUppIOzUo2Q | 5041 |
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;