musiccaps_details (view)
1 row where musiccaps_aspects contains "high pitched whine" and musiccaps_names contains "Skateboard" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 8 ✖
- bowling sound fx 1
- high pitched whine · 1 ✖
- instrumental 1
- intro 1
- low pitched vocal effect 1
- overdriven electric guitar riff 1
- slightly swung 1
- tape speed up 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DISTRICT TEAM EDIT 2012 | This sounds like an instrumental intro. It starts with a bowling sound effect as well as the sound of a tape player speeding up, producing both a high-pitched whine and a low-pitched vocal sounding effect. This leads into a slightly swung, overdriven electric guitar riff. | 2012-06-24T23:32:54Z | TheRealDistrict | http://www.districtscoot.com/ Follow us in Facebook: http://www.facebook.com/pages/The-Real-District-Scooters-Page/114545808605099 District proudly introduce the new team: Helmeri Pirinen Rory Coe Coedie Donovan Michael Goumaz Cameron Ward Chris Hart Brandon James Tom Mattingly The Black Keys - Gold on the cealing Thanks to Max for filming most of Helmeri's clips: http://vimeo.com/celerityproductions | ["Music", "Skateboard"] | ["instrumental", "intro", "bowling sound fx", "tape speed up", "high pitched whine", "low pitched vocal effect", "overdriven electric guitar riff", "slightly swung"] | 8 | xeHt-R5ScmI | 5344 |
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;