musiccaps_details (view)
1 row where musiccaps_aspects contains "ambient", musiccaps_author = 8 and "youtube_published" is on date 2013-06-09
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;