musiccaps_details (view)
2 rows where musiccaps_aspects contains "christmas song" and musiccaps_aspects contains "pop song" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- christmas song · 2 ✖
- pop song · 2 ✖
- backing voices 1
- bass 1
- bells percussions 1
- cheerful 1
- children's voices 1
- christmas carols 1
- christmas presents 1
- couples dancing 1
- duet 1
- elves 1
- festive 1
- groovy 1
- guitar accompaniment 1
- happy 1
- happy mood 1
- holiday theme 1
- keybiard harmony 1
- male voice 1
- medium tempo 1
- mirth 1
- moderate tempo 1
- percussion 1
- santa claus 1
- saxophone playing medley 1
- snowfall 1
- steady drumming rhythm 1
- synth 1
- the 1
- war 1
- warmth 1
- winter wonderland 1
- wintertime 1
musiccaps_names (array) 5 ✖
- Music 2
- Christian music 1
- Christmas music 1
- Jingle (music) 1
- Singing 1
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 | |
This Is Christmas (Christmas 2013 ) Paul Martin Feat Shauna Gallon | This pop song features a male and female voice singing the main melody. There are backing voices singing fills in between lines. Children sing in the background. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. A synth plays a pedal chord in staccato. This song can be played at the end credits of a holiday movie. | 2009-10-07T15:44:15Z | Chris tmasMusic | One of the Finest Christmas songs still yet to Make It. Please Share this song written & performed by one of worlds finest Christmas Crooners Paul Martin aka Mr Success featuring future star Shauna Gallon & a cast of family & friends shot in Newcastle upon Tyne in 2009. www.franksinatratributesinger.co.uk | ["Christmas music", "Singing", "Christian music", "Music"] | ["pop song", "holiday theme", "duet", "male voice", "children's voices", "christmas song", "percussion", "bass", "synth", "happy mood", "moderate tempo", "backing voices"] | 0 | ODOrls3MuZI | 2411 |
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;