musiccaps_details (view)
1 row where musiccaps_aspects contains "rock", musiccaps_aspects contains "shimmering hi hats", musiccaps_aspects contains "wide electric guitar chords" and musiccaps_author = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
I've Got My Glasses On 👓 Wearing Glasses Song for Children 🧐🤓😎 The Wiggles | The low quality recording features a rock song that consists of a flat male vocal and flat female vocal talking, followed by punchy kick and snare hits, shimmering hi hats, energetic crash hits, wide electric guitar chords, groovy bass guitar and synth lead melody. It sounds energetic. | 2013-02-07T23:21:04Z | The Wiggles | Subscribe to our channel for more Wiggly videos: http://ab.co/WigglesYouTube For more Wiggly fun: Website ► http://TheWiggles.com.au Facebook ► http://facebook.com/TheWiggles Twitter ► http://twitter.com/TheWiggles Instagram ► http://instagram.com/TheWiggles Spotify ► https://ab.co/TheWigglesSpotify US & UK Shop ► https://thewigglestore.com/ AUS Shop ► https://thewigglestore.com.au/ #glasses #kidsglasses #thewiggles | ["Music", "Independent music", "Speech"] | ["low quality", "rock", "flat female vocal", "flat male vocal", "energetic crash cymbal", "groovy bass guitar", "wide electric guitar chords", "synth lead melody", "shimmering hi hats", "punchy kick", "punchy snare", "energetic"] | 4 | b-Y-AjW6MJ0 | 3594 |
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;