musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental" and musiccaps_names contains "Music for children"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- instrumental · 2 ✖
- angry sounds 1
- animated movie 1
- animated movie background score 1
- animated music 1
- bee buzzing 1
- child speaking 1
- children videos 1
- children’s movie 1
- comical 1
- electronic sounds 1
- english tutorial for kids 1
- english tutorials 1
- fast tempo 1
- funky bass 1
- funny 1
- glass shattering 1
- keyboard harmony 1
- kindergarten videos 1
- medium tempo 1
- montessori 1
- playful music 1
- punching sounds 1
- subdued music 1
- toddlers 1
- trombone 1
- trumpet harmony 1
- videos for toddlers 1
- watch and learn 1
- whistling 1
musiccaps_names (array) 6 ✖
youtube_published (date) 2 ✖
- 2011-12-24 1
- 2013-10-07 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Buzz Does Not Know His Age! | Class 3 | EVS | Our First School | This music is instrumental. The tempo is medium with a piano harmony with the voice of a child speaking and a bee buzzing superimposed on the music. This clip is a tutorial on how to speak English. The music is subdued with the emphatic and loud voice of the child. | 2011-12-24T08:06:44Z | toonmastieyf | how home is the first school,getting to know about the culture of their family & the different members of family-their likes/dislikes. | ["Music", "Music for children", "Buzz", "Speech", "Child speech, kid speaking"] | ["instrumental", "medium tempo", "kindergarten videos", "toddlers", "videos for toddlers", "montessori", "child speaking", "subdued music", "bee buzzing", "children videos", "watch and learn", "english tutorial for kids", "english tutorials"] | 7 | OiAJB9uydS8 | 2460 | |
Panchatantra Hindi Animation Stories Cat and Monkey | This music is an animated instrumental. The tempo is fast with a playful trumpet harmony, trombone, synthesised sounds and sounds of glass shattering,punching and grunting. This music is a background score for an animated movie for kids. | 2013-10-07T07:37:09Z | sateesh kumar | ["Music", "Music for children", "Breaking"] | ["instrumental", "fast tempo", "animated music", "playful music", "funny", "comical", "children’s movie", "trumpet harmony", "trombone", "glass shattering", "punching sounds", "angry sounds", "keyboard harmony", "funky bass", "electronic sounds", "animated movie", "animated movie background score", "whistling"] | 7 | hVikKRODjbI | 4114 |
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;