musiccaps_details (view)
4 rows where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "classical" and musiccaps_aspects contains "instrumental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- cheerful · 4 ✖
- classical · 4 ✖
- instrumental · 4 ✖
- fast tempo 2
- merry 2
- acordion 1
- ball rom dancing 1
- ball room 1
- batman 1
- brass band 1
- burgeoning 1
- celebratory 1
- chamber music 1
- charming 1
- colourful 1
- country music 1
- dense 1
- electric cello 1
- elegant 1
- exquisite 1
- flute 1
- folk music 1
- folk song 1
- guitar 1
- hand percussion 1
- happy 1
- horn 1
- lighthearted 1
- lively 1
- madal 1
- medium tempo 1
- melodic 1
- melodious harmony 1
- ost 1
- pleasant harmonious 1
- regional music 1
- rich 1
- sarangi 1
- saxophone 1
- shakers 1
- string instrument 1
- string section 1
- strings section 1
- trombone 1
- trumpet 1
- tuba 1
- vibrant 1
- violin symphony 1
- violins 1
- vivid 1
- western classical 1
- wind instruments 1
- wood wind 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mozart - Horn concerto n°3 - Brain / Philharmonia / Karajan | This is a classical music piece. There is a wide range of strings in the orchestra playing a lively melody while a horn is in the lead. The atmosphere is lighthearted. This piece could be used in the soundtrack of a documentary where there are natural movements happening in the scene. | 2013-10-13T10:26:25Z | incontrario motu | Wolfgang Amadeus Mozart Horn concerto n°3 K.447 I. Allegro 0:00 II. Romance. Larghetto 7:04 III. Allegro 12:01 Dennis Brain Philharmonia Orchestra Herbert von Karajan Studio recording, London, XI.1953 | ["Brass instrument", "French horn"] | ["classical", "instrumental", "strings section", "horn", "lively", "cheerful", "lighthearted"] | 9 | KEp2NhraIZI | 2070 | |
Falconry 2 | Hunting with Goshawks, Peregrine Falcons and Harris' Hawks | This music is a Western Classical. The tempo is fast with a lively violin harmony, electric cello, piano and string accompaniments. The music is classical, colourful, burgeoning, well layered, dense, rich, full , pleasant, cheerful, merry and elegant. | 2012-06-25T01:12:22Z | Hawkins Falconry | Please visit our website for more information on our Private Falconry Experiences and one-to-one courses: http://www.hawkinsfalconry.co.uk/ Please like our Facebook page for exclusive offers and deals: https://www.facebook.com/pages/Hawkins-Falconry/136082499768950 Twitter: https://twitter.com/HawkinsFalconry Instagram - Hawkins Falconry For more videos please subscribe to my YouTube channel: http://www.youtube.com/user/hawkinsfalconry Thanks for watching... | ["Electric piano", "Keyboard (musical)", "Piano"] | ["instrumental", "violins", "fast tempo", "chamber music", "elegant", "burgeoning", "dense", "rich", "exquisite", "cheerful", "merry", "celebratory", "colourful", "ost", "batman", "ball room", "ball rom dancing", "western classical", "classical", "violin symphony", "electric cello", "guitar", "string section", "vivid", "vibrant", "cheerful"] | 7 | Qt8Ze-k2h2o | 2645 | |
Baraha Jewellery, Jordan, Hong Kong | This music is instrumental. The tempo is slow with a harmonious melody of string instruments, percussion and wind instruments which sound like the Indian Sarangi, dhol or madal , shakers and a flute. The music is classical, simple, enchanting and melodic. This song is a Folk song Instrumental. | 2012-09-06T16:53:26Z | DigitalEyeHK | Baraha Jewellery, Jordan, Hong Kong. www.barahajewellery.com. FOR MORE VIDEO http://www.jpthk.com | ["Traditional music", "Music"] | ["instrumental", "medium tempo", "flute", "string instrument", "cheerful", "charming", "classical", "melodic", "sarangi", "madal", "folk music", "country music", "regional music", "folk song", "shakers", "hand percussion"] | 7 | otVPTo72q4w | 4662 | |
Tocata Enxovia CCB (Rancho do Ezequiel) | This music is a lively instrumental. The tempo is fast with the charming harmony of trumpet, saxophone, tuba and a rhythmic accordion accompaniment. The music is fresh, spirited,lively, pleasant, merry, cheerful, charming and entertaining. This music is a classical piece. | 2016-10-10T21:54:41Z | Doglinha Vieira | Acordeon Fabricio Sousafone Doglinha Trombone Ezequiel Saxofone Everton | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Trombone"] | ["instrumental", "fast tempo", "brass band", "tuba", "wind instruments", "wood wind", "acordion", "trombone", "trumpet", "saxophone", "melodious harmony", "pleasant harmonious", "cheerful", "happy", "merry", "classical"] | 7 | rOOBAGxxjBk | 4873 |
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;