musiccaps_details (view)
3 rows where musiccaps_aspects contains "fun", musiccaps_aspects contains "kids song" and musiccaps_aspects contains "mono"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- fun · 3 ✖
- happy 3
- kids song · 3 ✖
- low quality 3
- mono · 3 ✖
- noisy 3
- acoustic rhythm guitar 1
- audio stuttering 1
- childish vocal 1
- cover 1
- crackling sound 1
- crushed 1
- funky guitar melody 1
- girls vocal 1
- groovy piano 1
- mellow cowbell 1
- messy 1
- muffled 1
- shimmering bells 1
- sweet girl vocal 1
- thin 1
musiccaps_names (array) 8 ✖
- Music 3
- Chink, clink 1
- Inside, small room 1
- Mandolin 1
- Music for children 1
- Speech 1
- Synthetic singing 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Cat that loves Horses | The low quality video features a cover of a kids song and it consists of a sweet girl vocal singing over acoustic rhythm guitar. The recording is in mono, noisy and it sounds fun and happy. | 2008-10-19T03:57:30Z | kangurski | so cute :) | ["Music", "Mandolin", "Ukulele"] | ["low quality", "mono", "cover", "sweet girl vocal", "acoustic rhythm guitar", "noisy", "fun", "happy", "kids song"] | 4 | 9ZWmZdgrE78 | 1023 | |
Elmo | The low quality recording features a kids song played through a toy and it consists of childish vocal singing over groovy piano chords and funky guitar melody. It is noisy, in mono and it sounds happy, fun, but also thin, messy, muffled and crushed. | 2007-05-07T00:40:48Z | lttleD03 | Me dancing we elmo lol | ["Music", "Synthetic singing", "Inside, small room"] | ["low quality", "noisy", "kids song", "crushed", "mono", "audio stuttering", "muffled", "messy", "thin", "happy", "fun", "groovy piano", "childish vocal", "funky guitar melody"] | 4 | J7d3nuS9wqg | 1969 | |
まちかどド・レ・ミ【ドレミタウン編】 その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;