musiccaps_details (view)
3 rows where musiccaps_aspects contains "intro" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- intro · 3 ✖
- ambient 1
- bowling sound fx 1
- bright 1
- children's choir 1
- children's music 1
- children's program 1
- ethereal 1
- happy 1
- high gliding synth melody 1
- high pitched whine 1
- hip hop 1
- instrumental 1
- low pitched vocal effect 1
- muffled autotuned vocals 1
- old tape static 1
- overdriven electric guitar riff 1
- picking up the phone 1
- rotary phone rings 1
- slightly swung 1
- tape speed up 1
- vibraphone 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shyheim - Jiggy Comin' | Mostly ambient sounds of a rotary phone ringing and someone picking up the phone. In the background there is an ethereal sounding high, gliding synth melody and muffled autotuned vocals. Sounds like an intro to a hip hop song. | 2008-01-20T16:49:10Z | hubwielkibuch | Shyheim - The Lost Generation | ["Music", "Telephone bell ringing"] | ["ambient", "rotary phone rings", "high gliding synth melody", "picking up the phone", "ethereal", "muffled autotuned vocals", "intro", "hip hop"] | 8 | 390At7lW4iw | 444 | |
Kids Time 136 3ABN | Sounds like the intro to a children's program. Children's music featuring vibraphone, a children's choir and old tape static in the background. It has a happy, bright feel. | 2013-07-26T03:08:12Z | RaZoom8 | Kids Time 136 3ABN | ["Music", "Vibraphone"] | ["children's music", "vibraphone", "old tape static", "happy", "bright", "children's choir", "intro", "children's program"] | 8 | g8USMvt9np0 | 4008 | |
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;