musiccaps_details (view)
3 rows where musiccaps_aspects contains "fun" and musiccaps_aspects contains "synth keys melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- fun · 3 ✖
- happy 3
- low quality 3
- synth keys melody · 3 ✖
- groovy bass 2
- shimmering hi hats 2
- addictive 1
- claps 1
- digital 1
- dull 1
- kids harmonizing vocals 1
- kids song 1
- mellow snare 1
- muffled 1
- punchy kick 1
- quiet 1
- shimmering bells 1
- simple bass 1
- snare rolls 1
- synth bells melody 1
- synth lead melody 1
- synth strings melody 1
musiccaps_names (array) 8 ✖
- Music 3
- Clapping 1
- Keyboard (musical) 1
- Music for children 1
- Musical instrument 1
- Piano 1
- Sad music 1
- Synthesizer 1
youtube_published (date) 3 ✖
- 2008-11-23 1
- 2012-09-08 1
- 2015-01-10 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
BOLERO fantasy [ Music: Maurice Ravel - Bolero / 10 min. version ] | The low quality recording features a synth key melody played over simple bass and snare rolls. It sounds happy and fun, while the recording is quiet, dull and muffled. | 2008-11-23T10:19:12Z | M. Laurens Bullstar | BOLERO-FANTASY 10min version [Music: Maurice Ravel - Bolero] | ["Music", "Sad music"] | ["low quality", "muffled", "snare rolls", "synth keys melody", "simple bass", "dull", "happy", "fun", "quiet"] | 4 | HOkuea1wExA | 1798 | |
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;