musiccaps_details (view)
4 rows where musiccaps_aspects contains "cello", musiccaps_aspects contains "cheerful" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 62 ✖
- cello · 4 ✖
- cheerful · 4 ✖
- animated 3
- fast tempo 3
- instrumental 3
- auto harp 2
- brass instrument 2
- fun 2
- happy 2
- trumpet 2
- viola 2
- vocalisation 2
- acoustic guitar 1
- animated voices 1
- banjo 1
- bowed string instruments 1
- brass band 1
- breezy 1
- child playing 1
- child’s voice 1
- church bell 1
- classic music 1
- concert 1
- country folk music 1
- country music 1
- electric guitar 1
- energetic 1
- enthusiastic 1
- exciting 1
- fiddle 1
- high energy 1
- high spirited 1
- intense 1
- joyful 1
- live audience 1
- live performance 1
- lively 1
- lively backup 1
- lively violin 1
- lively vocals 1
- male vocalist 1
- merry 1
- orchestra 1
- orchestral music 1
- perky 1
- playful 1
- playful music 1
- poor audio quality 1
- pop 1
- regional music 1
- soothing 1
- spirited 1
- static 1
- symphony 1
- trombone 1
- violin 1
- violin harmony 1
- violins 1
- whimsical 1
- wind instrument 1
- xylophone 1
- youthful 1
musiccaps_names (array) 13 ✖
- Music 3
- Banjo 1
- Bluegrass 1
- Bowed string instrument 1
- Cello 1
- Classical music 1
- Country 1
- Double bass 1
- Musical instrument 1
- Pizzicato 1
- Song 1
- Soundtrack music 1
- Vibraphone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Sound of Music Soundtrack - 1 - Prelude/The Sound of Music | This music clip is an Orchestral piece. There is a trumpet playing a lively solo to the accompaniment of an animated, vigorous Violin symphony and a church bell at the end. The music is lively, spirited, vivacious, happy and cheerful with the violins, cello and viola adding a happy, cheerful vibe to this Classical Instrumental. | 2011-03-15T01:38:18Z | xosoundtrackloverxo | The Sound of Music Soundtrack - 40th Anniversary Edition | ["Music", "Classical music", "Soundtrack music"] | ["instrumental", "lively violin", "orchestral music", "cheerful", "symphony", "bowed string instruments", "brass instrument", "brass band", "trumpet", "classic music", "church bell", "lively", "happy", "spirited", "animated", "exciting", "energetic", "youthful", "joyful", "cello", "viola"] | 7 | I4Rhe1XViYg | 1871 | |
Origami Rabbit by Stephen O'Hanlon | This music is an instrumental with a medium fast tempo. The music is orchestral with a lively brass band harmony, violin accompaniment, xylophone beats, a bright trombone and cello bass. The music is animated, lively, playful,whimsical, perky and puckish. | 2009-04-01T12:48:37Z | Mari Michaelis -Marigami | Download the diagram and follow along with the video! This video gives instructions for how to fold Stephen O'Hanlon's Rabbit. This cute Rabbit is quick and easy to fold and they multiply quickly. Level: low intermediate Visit www.marigami.com for links to the diagram and more origami videos. | ["Music", "Vibraphone"] | ["instrumental", "fast tempo", "orchestra", "cello", "xylophone", "animated", "whimsical", "perky", "high spirited", "violin", "trumpet", "trombone", "wind instrument", "brass instrument", "playful music", "violin harmony", "happy", "cheerful", "soothing"] | 7 | a4BjqKd8FsI | 3514 | |
The Seldom Scene - After Midnight | A male vocalist sings this high energy Country Song. The tempo is fast with animated Banjo, fiddle, auto harp, acoustic guitar and cello. The song is cheerful, happy, enthusiastic, fervent, pulsating, buoyant and animated with vocalising and backup. This song is a spirited Country Folk Song. | 2008-01-14T14:52:51Z | BluegrassLibrary | John Duffey, Ben Eldridge, Mike Auldridge, Phil Rosenthal, & Tom Gray | ["Banjo", "Country", "Music", "Musical instrument", "Song", "Bluegrass"] | ["male vocalist", "fast tempo", "country music", "lively vocals", "lively backup", "banjo", "cello", "auto harp", "fiddle", "acoustic guitar", "country music", "country folk music", "vocalisation", "high energy", "fun", "merry", "cheerful", "live performance", "concert", "live audience", "enthusiastic", "animated", "regional music"] | 7 | q-sJu8CoZts | 4750 | |
Snoopy & Woodstock 3 | This music is an animated instrumental. The tempo is fast with a lively cello bass line , viola and violin harmony with a lead strung instrument which is either an Auto Harp or electric guitar. There is a child’s voice superimposed on the music with incoherent words and a lot of static. The music is lively, intense,playful, fun, cheerful, animated and breezy. This music is an animated Pop. | 2007-02-19T00:19:07Z | HITMANIV | Snoopy and Woodstock get their roll on | ["Cello", "Double bass", "Pizzicato", "Bowed string instrument"] | ["instrumental", "fast tempo", "animated voices", "cello", "pop", "fun", "breezy", "child playing", "auto harp", "static", "poor audio quality", "electric guitar", "violins", "auto harp", "viola", "intense", "playful", "child’s voice", "vocalisation", "cheerful"] | 7 | sUh43prJYMM | 4954 |
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;