musiccaps_details (view)
3 rows where musiccaps_aspects contains "classical" and musiccaps_aspects contains "happy"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- classical · 3 ✖
- happy · 3 ✖
- fast tempo 2
- instrumental 2
- acordion 1
- audio cutouts 1
- background music 1
- brass band 1
- cheerful 1
- cheerful melody 1
- fun 1
- happy piano chord progression 1
- happy woodwind instrument 1
- harpsichord melody 1
- keyboard instrument 1
- lively melodic 1
- low quality 1
- melodious harmony 1
- merry 1
- mono 1
- pleasant 1
- pleasant harmonious 1
- rhythmic shoe tapping foley 1
- saxophone 1
- spirited 1
- string plucking 1
- trombone 1
- trumpet 1
- tuba 1
- upbeat 1
- warm 1
- western classical 1
- western music 1
- wind instruments 1
- wood wind 1
musiccaps_names (array) 8 ✖
- Music 2
- Brass instrument 1
- Foghorn 1
- Harpsichord 1
- Keyboard (musical) 1
- Musical instrument 1
- Tap 1
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mario Donadío constructor de clavicémbalos | This music is instrumental. The tempo is fast with a lively and happy harpsichord melody. The music is upbeat, engaging, happy, cheerful and peppy. This music is a Classical piano/harpsichord Instrumental. | 2008-03-13T20:11:04Z | Periódico Vivir en El Poblado | Mario Donadío constructor de clavicémbalos. Muestra un instrumento que acaba de construir y nos enseña cómo funciona y cómo suena. | ["Harpsichord", "Keyboard (musical)"] | ["instrumental", "fast tempo", "harpsichord melody", "western classical", "western music", "classical", "lively melodic", "pleasant", "keyboard instrument", "spirited", "warm", "happy", "cheerful melody", "upbeat", "string plucking"] | 7 | BojCkFK3pNg | 1292 | |
Hand Tap Dancing by Virginia Trautz | The Classical music features a happy sounding piano chord progression and happy woodwind instrument, followed by rhythmic shoe tapping foley effect. you could tell that the music is played on speakers, while the foley artist is trying to sync the shoe tapping to the scene. Judging by the audio cutouts and mono sound, you could tell that it is an old, low quality, recording. | 2010-09-11T20:00:08Z | Eileen Trautz | Virginia Trautz still taps, but with her HANDS in tiny tap shoes. It is too cute! Virginia Trautz has been a dancer all her life, now she is 86 and taps with her hands. It looks and sounds like real tap dancing! Virgina Trautz performs at retirement homes in South Jersey. She is choreographing her Christmas show now! | ["Music", "Tap"] | ["classical", "low quality", "mono", "rhythmic shoe tapping foley", "background music", "happy woodwind instrument", "happy piano chord progression", "happy", "fun", "audio cutouts"] | 4 | Q75y0TIp7Ds | 2595 | |
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;