musiccaps_details (view)
4 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "live performance", musiccaps_aspects contains "sustained strings melody" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Marin Marais: Chaconne in A Major (Book 5); Elisabeth Reed, viola da gamba | The low quality recording features a live performance of a classical song and it consists of harpsichord and sustained strings melodies. The recording is a bit noisy and quite reverberant, as it was recorded in a medium size concert hall. It sounds easygoing, passionate and emotional. | 2015-02-24T02:45:02Z | Voices of Music | The Chaconne in A Major from Marin Marais' fifth book (Pièces de Viole, Cinquième Livre, Paris, 1725). Performed on the viola da gamba by Elisabeth Reed, with Cassandra Luckhardt, viola da gamba, and Katherine Heater, harpsichord. In the first half of the 18th century, the French viol players dazzled audiences with their varied and beautifully crafted compositions as well as their technical abilities. Marais' chaconne shows the work of a mature composer; he balances the motivic elements perfectly with the registration of the instruments. HD Video from Voices of Music. | ["Cello", "Music", "Musical instrument", "Wedding music", "Classical music"] | ["low quality", "classical", "live performance", "harpsichord melody", "sustained strings melody", "emotional", "passionate", "reverberant", "noisy", "easygoing"] | 4 | HJuR9WJ1iRY | 1790 | |
St Julian's School flashmob | The low quality recording features a crowd talking and clapping to a soul song that is played on a playback. The song consists of a passionate female vocal, alongside mixed harmonizing vocals, singing over sustained strings melody, simple bass and harp melody. It sounds emotional and passionate. | 2015-07-16T19:47:33Z | SouthWalesArgus | St Julian's School flashmob for Mrs Gabica | ["Singing", "Music of Asia", "Music"] | ["low quality", "crowd talking", "crowd clapping", "simple bass", "harp melody", "passionate female vocal", "mixed harmonized vocals", "sustained strings melody", "soul", "passionate", "emotional", "live performance", "playback"] | 4 | PuJxL6tLxm4 | 2575 | |
Toshi - Piya Re (UKU) | The low quality recording features a live performance of a folk song that consists of an echoing passionate male vocal singing over sustained strings melody, acoustic guitar melody and some crowd cheering and whistling sounds in the background. It sounds joyful, passionate and emotional overall. | 2009-04-12T19:01:17Z | MariumSaeed | ["Singing", "Music of Asia", "Music"] | ["low quality", "folk", "live performance", "echoing passionate male vocal", "sustained strings melody", "acoustic guitar melody", "crowd cheering", "whistling", "joyful", "passionate", "emotional"] | 4 | e1PG31QlQmc | 3836 | ||
Chellak kani vaayal (“ செல்லக்கனி வாயால் ” ) by varnarameswaran | The low quality recording features a passionate male vocal singing over a wooden percussive element and sustained strings melody. It sounds emotional, passionate - like a traditional middle eastern song. | 2011-03-09T11:37:31Z | Varnarameswaran Singer & Composer | “செல்லக்கனி வாயால்” நல்லைக் கந்தன்மேல் வீரமணி ஐயர் அவர்கள் இயற்றியது. raga:Brindavani Thalam: Aathi vocal:VarnaRameshwaran, Violin: A.Jayadevan , Mirdhangam : Gowryshankar lyrics Innuvai Veeramani Iyer | ["Carnatic music", "Mantra", "Music"] | ["low quality", "wooden percussive element", "passionate male vocal", "traditional", "sustained strings melody", "passionate", "emotional", "live performance"] | 4 | e_W17jp40G4 | 3883 |
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;