musiccaps_details (view)
1 row where musiccaps_aspects contains "drums break", musiccaps_aspects contains "flat female vocal", musiccaps_aspects contains "pigs oink sound effects" and musiccaps_aspects contains "shimmering cymbals"
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Pig Files: Episode 1 | The low quality recording features a soft rock song playing over pigs oinks sound effects. The song contains a short drum break at the beginning, punchy snare, simple kick pattern, smooth bass guitar, wide acoustic rhythm guitar, shimmering cymbals and flat female vocals singing over it. Sounds like it is some kind of documentary about pigs, as the song is playing in the background. | 2007-04-01T11:50:05Z | miffywickham | National Sit-In at Wasleys Piggery, South Australia. Music by Mel Watson. | ["Music", "Oink"] | ["low quality", "pigs oink sound effects", "soft rock", "noisy ambience", "drums break", "flat female vocal", "wide acoustic rhythm guitar", "smooth bass guitar", "punchy snare", "simple kick pattern", "shimmering cymbals"] | 4 | kvIt_9P79Ro | 4366 |
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;