musiccaps_details (view)
1 row where musiccaps_aspects contains "steady drumming rhythm" and "youtube_published" is on date 2015-12-07
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 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;