musiccaps_details (view)
1 row where musiccaps_aspects contains "modern" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_names (array) 1 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
What You Waiting For? (Jacques Lu Cont's TWD Mix) | The low quality recording features a wide synth lead melody, synth pad chords and a bell impact at the very end, which slowly fades out. It sounds modern and kind of weird, due to the sudden bell impact. | 2011-12-20T19:55:14Z | Daniel Fierro | Jacques Lu Cont (Aka Stuart Price) remix of Gwen Stefani's 'What You Waiting For?'. Originally released as the first single from the album 'Love. Angel. Music. Baby.' 2004 Interscope. Music owned by Interscope Records. | ["Singing bowl"] | ["pop", "wide synth lead melody", "synth pad chords", "bell impact", "fade out", "low quality", "modern", "weird"] | 4 | 5tNOauvQWQQ | 702 |
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;