musiccaps_details (view)
2 rows where musiccaps_aspects contains "advertisement jingle" and musiccaps_aspects contains "cheerful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- advertisement jingle · 2 ✖
- cheerful · 2 ✖
- acoustic drums 1
- bass drum hits 1
- bass guitar 1
- bouncy rhythm 1
- children talking 1
- cool bass solo 1
- cool drum roll 1
- documentary video soundtrack 1
- drum sticks 1
- exciting 1
- female vocal 1
- funk pop music 1
- funky groove 1
- generic 1
- groovy rhythm 1
- hand saw 1
- instrumental music 1
- kids song 1
- major key 1
- medium tempo 1
- playful 1
- poor audio quality 1
- positive 1
- sawing noise 1
- steady drumming rhythm 1
- tom sounds 1
- video soundtrack’ toms sounds 1
- wind chimes 1
musiccaps_names (array) 13 ✖
- Bass drum 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Hi-hat 1
- Music for children 1
- Percussion 1
- Rimshot 1
- Rub 1
- Sawing 1
- Snare drum 1
- Tools 1
- Wood 1
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 | |
JS-7 Japanese Hand Saw | The song is an instrumental. The tempo is medium with ambient sounds like a sawing tool sounds, guitar rhythm, bass guitar solo and a steady drumming with various percussion hits. The song is an advertisement jingle for a tool works company. The sound quality is average with ambient room sounds. | 2009-03-24T01:04:51Z | Bridge City Tool Works | A look at Bridge City Tool Works Adjustable Back Rip and Crosscut Japanese Saw. | ["Sawing", "Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Tools", "Rub", "Wood", "Bass drum", "Percussion"] | ["hand saw", "instrumental music", "documentary video soundtrack", "advertisement jingle", "poor audio quality", "bouncy rhythm", "tom sounds", "sawing noise", "medium tempo", "cool bass solo", "steady drumming rhythm", "groovy rhythm", "video soundtrack’ toms sounds", "drum sticks", "cool drum roll", "bass drum hits", "exciting", "positive", "cheerful", "funky groove", "funk pop music"] | 1 | ZCR7qJ2IgGI | 3347 |
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;