musiccaps_details (view)
3 rows where musiccaps_aspects contains "cheerful" and musiccaps_aspects contains "cozy" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- cheerful · 3 ✖
- cozy · 3 ✖
- instrumental 2
- no singer 2
- american folk music 1
- banjo 1
- bell 1
- bells 1
- calming 1
- cute 1
- easygoing 1
- folk singing 1
- jingle 1
- keyboard 1
- kids song 1
- male vocal 1
- music box 1
- organ 1
- percussive elements 1
- playful 1
- relaxing 1
- steady tempo 1
- xylophone 1
musiccaps_names (array) 12 ✖
- Music 3
- Inside, small room 2
- Banjo 1
- Bell 1
- Bluegrass 1
- Glockenspiel 1
- Guitar 1
- Mandolin 1
- Marimba, xylophone 1
- Musical instrument 1
- Song 1
- Vibraphone 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Funny Dogs Vs Cat Toys! Funny Reactions : Louie and Marie The Beagles | This is an instrumental kids song. There is a xylophone and a music box playing a cute and cheerful melody. The atmosphere of the piece is cozy and relaxing. This piece could be used as a backing track for a nursery rhyme. It could be used in the soundtrack of a movie targeted at children. | 2016-02-29T21:43:56Z | Louie The Beagle | Funny Dogs Vs Cat Toys! Funny Reactions : Louie and Marie The Beagles. Cat toys are no match for these cute and hilariously funny dogs. SUBSCRIBE : http://goo.gl/Rq5egL FOLLOW US https://www.facebook.com/beaglelouie https://twitter.com/beaglelouie https://instagram.com/thebeaglelouie/ PLAYLISTS : BEST OF LOUIE : https://goo.gl/tZXXRJ MINIONS MINIONS : https://goo.gl/W4in8J FUNNY BEAGLEY THINGS : https://goo.gl/zGBAf5 DOG TOY CRITIC : https://goo.gl/7VuQae Click here for more Funny Minion Videos : https://goo.gl/W4in8J I always wondered what my beagles would do with cat toys. Now i know the cat nip makes them crazy! :-) Louie is not a big fan of battery operated toys so i won't bother him with them. PS : The toy at the start is a KONG SAFESTIX and not a sex toy haha :-) | ["Music", "Marimba, xylophone", "Vibraphone", "Glockenspiel", "Inside, small room"] | ["kids song", "no singer", "instrumental", "xylophone", "music box", "bell", "calming", "relaxing", "cheerful", "cute", "cozy"] | 9 | K-0qmhvJyzE | 2050 | |
Grand Californian Hotel & Spa Disneyland | This is a jingle piece. There is no singer in this piece. There is an organ and a keyboard playing the main melody while bells and other percussive elements provide the rhythmic background. The atmosphere is cheerful. This piece could be used as an advertisement jingle. It could also be used at a festive event setting such as Christmas or Thanksgiving. | 2008-02-23T22:17:44Z | ggg11333 | A look around the Hotel during our stay. 02-21-08 | ["Bell", "Music", "Inside, small room"] | ["jingle", "no singer", "instrumental", "keyboard", "organ", "bells", "percussive elements", "cheerful", "playful", "cozy"] | 9 | 1l7BjFDQLUM | 307 | |
Old Ground Hog | This is an American folk music piece. There is a male vocalist singing in the folk style. The banjo is playing a cheerful melody at a steady tempo. The atmosphere of the piece is cozy and easygoing. This piece could be playing in the background at a roadside diner. It could also be included in the soundtrack of a movie or a TV show taking place in rural USA. | 2009-10-23T23:49:03Z | guy wolff | Here is one in double C capoed at the fourth fret and the fifth string tuned drone to the second string . It is one we all learned from the Folkways record from the early 60's "Music from Clarence Tom Ashley's " this song played by Doc Watson . It is one of the first songs I ever learned on Banjo . Today I like playing this in Double C tuning | ["Banjo", "Guitar", "Music", "Mandolin", "Musical instrument", "Song", "Bluegrass"] | ["american folk music", "male vocal", "folk singing", "banjo", "cheerful", "cozy", "easygoing", "steady tempo"] | 9 | QK-mjNg8cPo | 2613 |
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;