musiccaps_details (view)
2 rows where musiccaps_aspects contains "fun", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "synth keys melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- fun · 2 ✖
- groovy bass · 2 ✖
- happy 2
- low quality 2
- shimmering hi hats 2
- synth keys melody · 2 ✖
- addictive 1
- claps 1
- digital 1
- kids harmonizing vocals 1
- kids song 1
- mellow snare 1
- punchy kick 1
- shimmering bells 1
- synth bells melody 1
- synth lead melody 1
- synth strings melody 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bible Action Songs 2 - Clap, Clap, Clap Your Hands | The low quality recording features a kids song sung by harmonizing kids vocals over shimmering bells, claps, synth keys melody, groovy bass and shimmering hi hats in the right channel of the stereo image. It sounds fun, happy, addictive, thanks to that cadence, and like something kids would listen to. | 2012-09-08T23:44:26Z | virginia beam | ["Music", "Music for children", "Clapping"] | ["kids harmonizing vocals", "shimmering bells", "claps", "synth keys melody", "groovy bass", "shimmering hi hats", "punchy kick", "happy", "fun", "addictive", "low quality", "kids song"] | 4 | u1a5eyk-9ig | 5085 | ||
80s Synth Riffs | The low quality recording features synth strings in the left channel, synth keys melody, synth bells melody in the right channel of the stereo image, groovy bass, shimmering hi hats and mellow snare. It sounds digital, but it gives off happy and fun vibes. | 2015-01-10T07:13:55Z | shochan8883 | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Synthesizer"] | ["low quality", "synth strings melody", "synth lead melody", "synth keys melody", "synth bells melody", "groovy bass", "shimmering hi hats", "mellow snare", "digital", "fun", "happy"] | 4 | xVi1wNljxjk | 5336 |
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;