musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "kids song" and musiccaps_aspects contains "mono" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- kids song · 3 ✖
- low quality 3
- mono · 3 ✖
- noisy 3
- acoustic rhythm guitar 2
- fun 2
- happy 2
- audio stuttering 1
- childish vocal 1
- chiptune vocal 1
- cover 1
- crushed 1
- fun happy 1
- funky guitar melody 1
- groovy piano 1
- messy 1
- muffled 1
- sweet girl vocal 1
- thin 1
musiccaps_names (array) 8 ✖
- Music 3
- Inside, small room 1
- Jingle (music) 1
- Mandolin 1
- Singing 1
- Song 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 | |
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 |
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;