musiccaps_details (view)
5 rows where musiccaps_aspects contains "kids song", musiccaps_aspects contains "mono" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- kids song · 5 ✖
- low quality 5
- mono · 5 ✖
- noisy 5
- fun 3
- happy 3
- acoustic rhythm guitar 2
- crushed 2
- audio stuttering 1
- childish vocal 1
- chiptune vocal 1
- cover 1
- crackling sound 1
- distorted 1
- fun happy 1
- funky guitar melody 1
- girls vocal 1
- groovy piano 1
- keys chords 1
- low male vocal 1
- mellow cowbell 1
- messy 1
- muffled 1
- shimmering bells 1
- sweet girl vocal 1
- thin 1
musiccaps_names (array) 12 ✖
- Music 5
- Chink, clink 1
- Inside, small room 1
- Jingle (music) 1
- Mandolin 1
- Music for children 1
- Singing 1
- Song 1
- Speech 1
- Synthetic singing 1
- Tick-tock 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
pooh and piglet animated talking clock.wmv | The low quality recording features a kids song played through some kind of toy, and it consists of low male vocal singing over some key chords. It sounds distorted and crushed. The recording is noisy and in mono, as it was probably recorded with a poor quality microphone. | 2008-11-28T14:10:48Z | Mark Mckinley | A.A. Milne started the Pooh saga in 1924. On the alarm, the titer-tautor moves up-and-down with Pooh singing: Oh yes, Im rumbly in my tumbly. Up, down, up down, touch the ground. It puts me in the morning. Wonderland Music Co., 1975 (istcc) | ["Music", "Tick-tock"] | ["low quality", "kids song", "distorted", "crushed", "noisy", "mono", "keys chords", "low male vocal"] | 4 | 05JAmKFVy44 | 117 | |
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 | |
THE DUCK SONG pato | The low quality recording features a kids song that consists of chiptune vocal singing over acoustic rhythm guitar. The recording is noisy, in mono and it sounds fun and happy, like something kids listen to. | 2009-03-27T02:20:57Z | MANUEL jesus ALVAREZ | An animated video to go along with Bryant Oden's (http://youtube/songdrops) original song. FREE DOWNLOAD: http://forrestfire101.webs.... LYRICS: Tell me the duck story... A duck walked up to a ... An animated video to go along with Bryant Oden's (http://youtube/songdrops) original song. FREE DOWNLOAD: http://forrestfire101.webs.com/downlo... LYRICS: Tell me the duck story... A duck walked up to a lemonade stand and he said to the man running the stand: Hey! got any grapes? The man said: | ["Singing", "Jingle (music)", "Music", "Song"] | ["low quality", "chiptune vocal", "acoustic rhythm guitar", "noisy", "fun happy", "kids song", "mono"] | 4 | JV_IOR3DqiM | 2014 | |
まちかどド・レ・ミ【ドレミタウン編】 その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;