musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "digital/acoustic drums", musiccaps_names contains "Drum" and musiccaps_names contains "Hi-hat"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Tinashe - Mr. Presumption | A digital kick in playing on every beat along with short voice samples with breathy sounds that sound seductive. Then the song changes into someone fingerpicking an acoustic guitar along to someone playing an acoustic snare/hihat with brushes. This first song may be playing in a club and the second one at a live concert. | 2009-12-02T21:26:27Z | boXd productions | as introduced by 4Music's 'Intros' series - but without the annoying and highly pretentious introduction at the beginning ... | ["Cymbal", "Drum", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["techno/singer-songwriter", "acoustic guitar", "digital/acoustic drums", "male voice samples", "seductive", "medium to uptempo"] | 6 | gjujPd1lP8E | 4050 |
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;