musiccaps_details (view)
1 row where musiccaps_aspects contains "cats sound effect" and musiccaps_aspects contains "fun" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 9 ✖
- animals 1
- cats sound effect · 1 ✖
- chickens sound effect 1
- fun · 1 ✖
- groovy piano melody 1
- happy 1
- low quality 1
- plucked strings melody 1
- sheep sound effects 1
musiccaps_names (array) 3 ✖
- /t/dd00032 1
- Happy music 1
- Music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Silly Song with Animal Sounds • Happy Funny Love Song for Children Kids Kindergarten Preschoolers | The low quality recording features a groovy piano and plucked strings melody playing over some animal sound effects. Some of the sounds that can be heard are chickens, cats and sheep sound effects. It sounds happy and fun, like something a kid would listen to. | 2011-11-22T07:58:43Z | Mark Andrew Hansen Music | About Love Family Life. This Cute Fun Clever Kids Song - "The Silly Song" - Stimulates your child's brain with fast clever nonsense rhymes which includes elements designed to promote brain development including:- fast unrelated words & graphics, random animal sounds, and varying orchestral musical instruments. Guess what animals are calling out after each chorus. Listen for different orchestral instruments in every verse. Ideal for children aged 5+ (kindergarten, early school, bright toddlers & preschoolers). Now on iTunes & AppleMusic - https://itun.es/au/x5nr5 Now on Spotify - https://open.spotify.com/album/3jasEXvhUp3PB0jEQRLwhE Download Digital Album with Lyrics and Activity Sheets for Songs at:- http://markhansen.biz All Kids Song Videos are at:- http://www.youtube.com/playlist?list=PLEB3C81A1FA84295B | ["Music", "Happy music", "/t/dd00032"] | ["low quality", "fun", "happy", "groovy piano melody", "plucked strings melody", "chickens sound effect", "sheep sound effects", "cats sound effect", "animals"] | 4 | ksImihlU3qM | 4361 |
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;