musiccaps_details (view)
1 row where musiccaps_aspects contains "advertisement jingle", musiccaps_aspects contains "female vocal" and musiccaps_aspects contains "major key"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dream Town Cherry Blossom Stores | This is an advertisement jingle in the style of a kids song. It is in major key. There is a female vocalist singing in the lead while the sound of children talking can be heard every now and then. The bass guitar is playing a groovy tune. There are wind chimes that can be noticed. The rhythmic background consists of a simple acoustic drum beat. The atmosphere is cheerful but generic. | 2013-06-01T13:13:03Z | Place For Mantras | Hi Great Toy Videos For Kids to Enjoy & Lear New Things from It, Games for Kids, Children's, Toddlers, New Born babies Girls & Boys, even parents will enjoy this videos with families, in school this videos will be for educational purpose in preschools also. Helps parenting in childhood with fun, dance, learn enjoy or make or learn how to do videos. Sing Songs Along & Also Karaoke Live for youths, mothers, teachers, laugh, entertain, like, teach. Television Ads, commercials with dancing Videos & nursery Rhymes. Kids Videos, Toy Videos from across the world with famous brands like Barbie, Lego, Famosa, Mattel, Fisher price, Cars, Mario, games, online games, play live & enjoy. Superman Spiderman Batman Doremon Babe lade Sinchan Cartoons Micky Mouse Disney | ["Music for children"] | ["advertisement jingle", "major key", "kids song", "female vocal", "children talking", "wind chimes", "bass guitar", "acoustic drums", "playful", "cheerful", "generic"] | 9 | EUmfsCvmkgo | 1564 |
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;