musiccaps_details (view)
3 rows where musiccaps_aspects contains "fun", musiccaps_names contains "Inside, small room" and musiccaps_names contains "Synthetic singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- fun · 3 ✖
- happy 3
- low quality 3
- mono 3
- noisy 3
- thin 2
- audio stuttering 1
- childish vocal 1
- children song 1
- crushed 1
- funky guitar melody 1
- funny female vocal 1
- funny male vocal 1
- groovy piano 1
- happy sounding bells melody 1
- harmonized kids vocals 1
- kids song 1
- mellow piano chord progression 1
- messy 1
- muffled 1
- muffled flute melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Barney I Love you season 3 version 8 | The low quality recording features a harmonized kids' vocals singing over a muffled flute melody. The recording is very noisy and it is in mono, but regardless it sounds happy and fun. | 2014-10-05T15:15:59Z | BarneyInGrade11 | audio from Mystery and the balls 1995 clip from Lets play games 2005 | ["Music", "Synthetic singing", "Inside, small room"] | ["low quality", "harmonized kids vocals", "noisy", "mono", "muffled flute melody", "happy", "fun"] | 4 | Gj6etuzTWlQ | 1750 | |
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 | |
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 |
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;