musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "toddlers"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- medium tempo · 2 ✖
- toddlers · 2 ✖
- animals 1
- animated singing 1
- animated video 1
- bee buzzing 1
- cheerful 1
- child speaking 1
- children dancing 1
- children videos 1
- children’s song 1
- educational material 1
- english tutorial for kids 1
- english tutorials 1
- fun learning 1
- groovy bass line 1
- instrumental 1
- kindergarten videos 1
- learning 1
- male singer 1
- montessori 1
- nursery rhymes 1
- piano accompaniment 1
- positive 1
- preschool teaching 1
- schools 1
- spirited 1
- steady drumming rhythm 1
- subdued music 1
- videos for toddlers 1
- watch and learn 1
- zoo 1
musiccaps_names (array) 7 ✖
- Music 2
- Buzz 1
- Child speech, kid speaking 1
- Exciting music 1
- Funk 1
- Music for children 1
- Speech 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 | |
Animals | Zoo | Kids | Music | Preschool | Silly Bus | A male singer sings this animated melody . The song is medium tempo with a groovy bass , keyboard accompaniment and steady drumming rhythm. The song is cheerful and animated and designed as educational material for little children. | 2011-09-11T22:29:16Z | Silly Bus | Silly Bus is proud to release our At The Zoo song and video. | ["Funk", "Music", "Exciting music"] | ["medium tempo", "male singer", "groovy bass line", "preschool teaching", "educational material", "learning", "schools", "toddlers", "positive", "cheerful", "spirited", "fun learning", "children dancing", "animated video", "nursery rhymes", "zoo", "animals", "steady drumming rhythm", "piano accompaniment", "children’s song", "animated singing"] | 1 | hhohfEC82JI | 4130 |
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;