musiccaps_details (view)
2 rows where musiccaps_aspects contains "ambient", musiccaps_aspects contains "ethereal" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- ambient · 2 ✖
- ethereal · 2 ✖
- big reverb 1
- childlike 1
- complex sound design 1
- hazy 1
- high gliding synth melody 1
- hip hop 1
- instrumental 1
- intro 1
- muffled autotuned vocals 1
- no drums 1
- picking up the phone 1
- rotary phone rings 1
- tape hiss 1
- warm 1
musiccaps_names (array) 3 ✖
- Music 2
- Bell 1
- Telephone bell ringing 1
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 | |
Beady Eye - Don't Brother Me | An ambient instrumental piece with no drums, big reverb and complex sound design elements. Tape hiss can be heard in the background and the vibe is hazy and warm with childlike wonder. | 2013-06-09T12:29:01Z | BeadyEyeRecords | © SME © Sony Music Entertainment © Beady Eye "Don't Brother Me" is a song by Beady Eye from the BE album. BE is the second studio album by the band. LYRICS: Don't bother me when I'm done Have a little fun, did you hear he come? You say that you're free but I'm one Always in the sun which is number one You know I'm a man, I'll make you if I can You know I'm a man, I'll do what I can Don't bother me when you're done Sick of all your lying, skimming and you crying They say that I'm free but I'm one I'm always in the sun, did you number one? You know I'm a man, I'll make you if I can You know I'm a man, I'll do what I can In the morning I've been calling, I'm hoping you understand All and nothing, I'll keep pushing Come on now, give peace a chance, take my hand, be a man In the morning I've been calling, I'm hoping you understand All and nothing, I'll keep pushing Come on now, give peace a chance In the morning I've been calling, I'm hoping you understand All and nothing, I'll keep pushing Come on now, give peace a chance, take my hand, be a man | ["Bell", "Music"] | ["instrumental", "big reverb", "complex sound design", "tape hiss", "ethereal", "hazy", "warm", "childlike", "no drums", "ambient"] | 8 | sgTZHSTnU40 | 4971 |
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;