musiccaps_details (view)
1 row where musiccaps_aspects contains "bizarre", musiccaps_aspects contains "computer sounds" and "youtube_published" is on date 2012-10-16
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 |
---|---|---|---|---|---|---|---|---|---|---|
Secret Skate Park in Hana Maui Hawaii | There is a high-pitched computer-like sound effect in the piece. It gives this cold, uneasy feeling. It could be used in a cyberpunk video game or a dystopian movie. | 2012-10-16T08:18:03Z | jase | Zach Tilton and I heard about a new park that was mid way to completion and yet already sk8'able. So we took a board and headed out. The people in Hana, Maui are AMAZING and showed epic hospitality! We gave away some gear, sold some gear and had a sweet time. I shot, edited and composed the music for this quick vid. please be gentle in your remarks! ;) no one got paid for this. we were just having a bit of fun. Shot and edited by me: Jase Bennett www.instagram.com/jasebennett | ["Music", "Sonar"] | ["noise", "sound effects", "computer sounds", "electronic", "eerie", "bizarre"] | 9 | dql-sQqgVXI | 3818 |
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;