musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "cheerful", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- cheerful · 3 ✖
- medium tempo · 3 ✖
- steady drumming rhythm · 3 ✖
- exciting 2
- positive 2
- advertisement jingle 1
- backup singers 1
- bass drum hits 1
- bells percussions 1
- bouncy rhythm 1
- christmas carols 1
- christmas presents 1
- christmas song 1
- cool bass solo 1
- cool drum roll 1
- couples dancing 1
- documentary video soundtrack 1
- drum sticks 1
- elves 1
- emotional 1
- energetic 1
- ethnic percussions 1
- female singer 1
- festive 1
- fun 1
- funk pop music 1
- funky groove 1
- groovy 1
- groovy rhythm 1
- guitar accompaniment 1
- …
musiccaps_names (array) 15 ✖
- Music 2
- Bass drum 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Happy music 1
- Hi-hat 1
- Jingle (music) 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 |
---|---|---|---|---|---|---|---|---|---|---|
豬之歌 - 香香 | A female singer sings this lovely melody with a choral harmony support. The song is medium tempo with a Steady drumming rhythm, various percussion, percussive bass line, keyboard accompaniment and guitar rhythm. The song slows down at the end. The song is emotional and exciting. | 2011-11-26T13:35:07Z | TigerleoAB | 豬之歌 詞/曲:毛慧 豬 你的鼻子有兩個孔 感冒時的你 還掛著鼻涕牛牛 豬 你有著黑漆漆的眼 望呀望呀望 也看不到邊 豬 你的耳朵是那麼大 呼扇呼扇 也聽不到我在罵你傻 豬 你的尾巴是卷又捲 原來跑跑跳跳 還離不開它 哦~~~ 豬頭豬腦豬身豬尾巴 從來不挑食的乖娃娃 每天睡到日曬三桿後 從不刷牙從不打架 豬 你的肚子是那麼鼓 一看就知道 受不了生活的苦 豬 你的皮膚是那麼白 上輩子一定投在 那富貴人家 哦~~~ 傳說你的祖先有八釘耙 算命先生說他命中犯桃花 見到漂亮姑娘 就嘻嘻哈哈 不會臉紅 不會害怕 豬頭豬腦豬身豬尾巴 從來不挑食的乖娃娃 每天睡到日曬三桿後 從不刷牙 從不打架 哦~~~ 傳說你的祖先有八釘耙 算命先生說他命中犯桃花 見到漂亮姑娘 就嘻嘻哈哈 不會臉紅 不會害怕 你很像他 咳咳嗯 | ["Music", "Happy music"] | ["female singer", "backup singers", "pop music", "percussive bass line", "song ending", "medium tempo", "keyboard accompaniment", "fun", "cheerful", "positive", "emotional", "romantic", "vocal harmony", "steady drumming rhythm", "percussive bas slime", "keyboard harmony", "ethnic percussions", "exciting", "energetic", "vocal harmony", "pop hits", "retro pop hits", "video soundtrack", "various percussion hits"] | 1 | Ur8O3h8S0K4 | 2947 | |
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 | |
Santa's Elves - Dogs and Cats with Human Hands Making Toys - Freshpet | The song is an instrumental. The song is medium tempo with a groovy bass line, steady drumming rhythm, guitar accompaniment, saxophone playing melody and bells percussions. The song is cheerful and festive. The song is a Christmas song with a lot of fun and cheer. | 2015-12-07T16:06:45Z | Freshpet | Adorable dogs and cats dressed as Santa’s elves with human hands making toys: just another thing to love about the holidays. http://freshpet.com/ For each share of this video, Freshpet will donate one fresh meal to a pet in need from our network of pet rescues and shelters. Watch the behind the scenes video to see how we did it! https://youtu.be/U6ll-ug1h3g See last year’s Freshpet Holiday Feast! https://www.youtube.com/watch?v=vhg7Xm4FXAY We are on a mission – to bring the power of real, fresh pet food to dogs and cats. And we’re committed to doing so in ways that are good for our pets, for people and for the planet. At Freshpet, our dogs and cats aren’t just our pets. They’re part of the family. And as our families choose to eat fresh, less-processed foods, we thought it made sense that our pets should too. That’s why we made Freshpet. Just fresh meats and fresh veggies, and no preservatives. Look for the Freshpet fridge and our new Fresh Baked recipes in the pet aisle. Connect with us! https://www.facebook.com/Freshpet https://twitter.com/Freshpet http://instagram.com/Freshpet http://pinterest.com/Freshpet https://plus.google.com/+Freshpet https://en.wikipedia.org/wiki/Freshpet https://www.youtube.com/user/freshpet400 Special thanks to the Salt Lake County Animal Service for their participation in this video Mr. and Mrs. Santa Paws painting in background by Heather Mattoon. See more at http://catsinclothes.org/ | ["Jingle (music)", "Music"] | ["christmas song", "saxophone playing medley", "santa claus", "elves", "bells percussions", "warmth", "medium tempo", "steady drumming rhythm", "keybiard harmony", "guitar accompaniment", "cheerful", "festive", "groovy", "christmas carols", "war", "the", "mirth", "wintertime", "snowfall", "winter wonderland", "couples dancing", "pop song", "christmas presents", "happy"] | 1 | y6NS77HLjEE | 5382 |
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;