musiccaps_details (view)
1 row where musiccaps_aspects contains "wooden percussions", musiccaps_names contains "Wood block" and "youtube_published" is on date 2015-09-15
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 |
---|---|---|---|---|---|---|---|---|---|---|
Meshuggah - Spasm - The Djentophonic Ensemble | The low quality recording features wooden percussion playing in the right channel, shimmering xylophone playing in the left channel and dissonant bells chords in the middle of the stereo image. It sounds suspenseful and intense. | 2015-09-15T07:44:01Z | Djentophonic Official | "Spasm" played on classical percussion. djentophonic @gmail.com for more info. | ["Wood block", "Percussion"] | ["low quality", "wide", "wooden percussions", "shimmering xylophone", "dissonant bells chords", "intense", "suspenseful"] | 4 | tlDBOenCGV4 | 5061 |
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;