musiccaps_details (view)
4 rows where musiccaps_aspects contains "children song" and musiccaps_aspects contains "noisy" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- children song · 4 ✖
- fun 4
- happy 4
- low quality 4
- noisy · 4 ✖
- mono 3
- funny male vocal 2
- joyful 2
- acoustic rhythm guitar 1
- church bells melody 1
- claps 1
- clock ticking 1
- cover 1
- emotional 1
- emotional girl vocal 1
- flat female vocal 1
- funny female vocal 1
- happy sounding bells melody 1
- harmonizing vocals 1
- innocent 1
- mellow piano chord progression 1
- muffled 1
- plucked strings melody 1
- shimmering bells melody 1
- thin 1
- unbalanced stereo 1
- uptempo 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Big Bird, Cookie Monster, and Oscar the Grouch by Ideal | The low quality recording features a children's song played on TV that consists of funny male and female vocal singing over mellow piano chord progression and happy sounding bells melody. It is really noisy and in mono, but it sounds happy and fun - like something kids would listen to. | 2011-06-03T18:54:14Z | whitgreene1 | This is one of my two sets of "The Trio" telling a story. This set will find a new home soon. This set is not playing from a cassette tape, rather a digitized version of the cassette tape playing from a MP3 player. All ten of the "trio" stories that I have are contained in the MP3 player as well as a few that only animate Big Bird. These guys always bring a smile to your face. | ["Music", "Synthetic singing", "Inside, small room"] | ["low quality", "thin", "noisy", "funny male vocal", "funny female vocal", "fun", "happy", "happy sounding bells melody", "mellow piano chord progression", "children song", "mono"] | 4 | xxCnmao8FAs | 5367 | |
ダンシングサンタさん | The low quality recording features a children's song played on some small device that reproduces mono sound. The song consists of a funny male vocal, alongside harmonizing vocals, singing over a shimmering bell melody and some claps. It sounds happy, fun, joyful, muffled and the recording is noisy. | 2008-11-17T01:21:15Z | ohanacafe | 少し早いけどお家をクリスマスに | ["Christmas music", "Christian music", "Music", "Synthetic singing"] | ["children song", "low quality", "uptempo", "mono", "noisy", "funny male vocal", "harmonizing vocals", "shimmering bells melody", "claps", "happy", "fun", "joyful", "muffled"] | 4 | PduP4CpaDtY | 2551 | |
Sukey's Circle! Vol. 1: Tick Tock (expanded version) - (SD) | The low quality recording features a children's song that consists of a clock ticking, church bells melody, plucked strings melody and flat female vocal singing over it. It sounds happy, joyful and fun. The recording is mono and noisy. | 2011-05-02T13:30:42Z | SukeyMolloy | Learn more about Sukeys Circle! at http://www.sukeymolloy.com. Join Sukey Molloy and her favorite friends Sunny and Tick Tock at Sukey’s Circle! for ‘Tick Tock’. Sukey dances, plays, and sings with Tick Tock while rocking, jumping, hopping and clapping. This is the original expanded version. You can also see Tick Tock on Vol. 3, and listen to the Tick Tock song on Sukey’s first CD, Circle Songs created for ages 1-5. | ["Music", "Music for children", "Tick", "Glockenspiel"] | ["low quality", "clock ticking", "church bells melody", "flat female vocal", "plucked strings melody", "happy", "joyful", "fun", "children song", "noisy", "mono"] | 4 | YLlbLSNxdQ4 | 3277 | |
The Sound of Music Video Audition Contest | The low quality recording features a cover of a children's song and it consists of an emotional girl vocal singing over acoustic rhythm guitar located in the right channel of the stereo image, which makes the stereo image unbalanced. The recording is a bit noisy and It sounds fun, happy, emotional and innocent. | 2009-08-17T18:08:11Z | Marty Frolick | Emily auditioning for Brigitta von Trapp | ["Music", "/t/dd00032"] | ["low quality", "emotional girl vocal", "acoustic rhythm guitar", "cover", "noisy", "unbalanced stereo", "fun", "happy", "emotional", "children song", "innocent"] | 4 | KCytKo5LzCc | 2066 |
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;