musiccaps_details (view)
2 rows where musiccaps_aspects contains "kids song" and musiccaps_aspects contains "shimmering bells"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- fun 2
- happy 2
- kids song · 2 ✖
- low quality 2
- shimmering bells · 2 ✖
- addictive 1
- claps 1
- crackling sound 1
- girls vocal 1
- groovy bass 1
- kids harmonizing vocals 1
- mellow cowbell 1
- mono 1
- noisy 1
- punchy kick 1
- shimmering hi hats 1
- synth keys melody 1
musiccaps_names (array) 5 ✖
- Music 2
- Music for children 2
- Chink, clink 1
- Clapping 1
- Speech 1
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 | ||
まちかどド・レ・ミ【ドレミタウン編】 その3 | The low quality recording features a kids song that features a shimmering bell melody, mellow cowbell and girl vocals singing over it. The recording is in mono and noisy - the audio is really crackling. It sounds fun and happy, like something that kids would listen to. | 2015-04-17T18:53:26Z | aki12160 | まちかどド・レ・ミ(ドレミタウン編)『てびょうしあしぶみ』より ①あめのゆうえんち ②たのしいね ③ロックのえかきうた ④どうぶつえんへいこう | ["Music", "Music for children", "Chink, clink", "Speech"] | ["low quality", "girls vocal", "shimmering bells", "kids song", "mellow cowbell", "crackling sound", "noisy", "mono", "fun", "happy"] | 4 | zWEznZ40k2Q | 5485 |
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;