musiccaps_details (view)
4 rows where musiccaps_aspects contains "dramatic" and musiccaps_names contains "Bowed string instrument"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Fullmetal Alchemist Brotherhood OST 3 - 20. Violoncello's Lament | This audio contains a string section playing a sad/melancholic piece. A violin/viola is playing the lead melody while celli and upright basses being played with a bow are supporting the melody with chords. The lead melody is panned to the right side of the speakers. This song may be playing in a sad and dramatic movie scene. | 2011-06-23T16:15:06Z | ShinyKyuukon | Disclaimer: I do not own any clips or music of this video. All clips and music belong to their respectful owner(s). This video is for enjoyment purposes only. Artist: Senju Akira. | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["cinematic", "orchestral", "sad", "dramatic", "dark", "string section", "slow tempo"] | 6 | 8MF6nFj02sM | 915 | |
| Claude Debussy: Quartet in G Minor, Op. 10 - 4th Mvmt. | This is a live performance of a classical music piece from the impressionist school. It is being performed by a string quartet of two violins, one viola and one cello. The quartet is playing a dramatic tune. The atmosphere is gloomy. This piece could be used in the soundtrack of a drama movie during tragic scenes. | 2006-12-05T01:46:20Z | mashaskripka | Debussy Quartet in G Minor, Op. 10 Tres modere -- tres mouvemente et avec passion. First Violin - Maria Bessmeltseva, second violin - Paris Paraschoudis, Viola - Jesse Griggs, Cello - Heather Scott | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["classical music", "live performance", "impressionist", "instrumental", "string quartet", "violin", "viola", "cello", "dramatic", "profound", "gloomy"] | 9 | WSMdqFEjGXE | 3095 | |
| The Children of Post-War Bosnia | The low quality recording features a flat male vocal talking over a classical song that consists of sustained strings melody. It sounds dramatic and suspenseful. | 2007-10-16T13:32:08Z | Journeyman Pictures | Mostar's Children (Aug 1996) A compassionate report on how young people in Bosnia are coping with re-unification after the Croat-Bosniak conflict. Subscribe to Journeyman for more: http://www.youtube.com/subscription_center?add_user=journeymanpictures At a festival - designed to bring normality back to Mostar - wooden puppets play to rows of rapt, excited faces. Nigel Osbourne, a Scottish Professor of Music, works with the War Child charity to repair young minds scarred by the war. Now enjoying the golden princess and the evil villain on stage, they once suffered snipers, bombardment and hand to hand fighting. Both Serbian and Croat artillery has transformed Mostar - with its antique bridge spanning an emerald green river - into skeletal blocks of rubble. In the Croatian West, little touched by the fighting, glitzy shopping centres pulse with black market cash. But, in spite of the Dayton accord, Croatian politicians want ethnic segregation to remain for children as well as adults. So only the Muslim East celebrates youth festivals and TV programmes sponsored by UNICEF. For more information, visit https://www.journeyman.tv/film/254 Like us on Facebook: https://www.facebook.com/journeymanpictures Follow us on Twitter: https://twitter.com/JourneymanNews https://twitter.com/JourneymanVOD Follow us on Instagram: https://instagram.com/journeymanpictures Produced by ABC Australia - Ref 0254 Distributed by Journeyman Pictures | ["Cello", "Double bass", "Bowed string instrument"] | ["low quality", "classical", "flat male vocal", "dramatic", "suspenseful", "sustained strings melody"] | 4 | cT-KZPVpU9M | 3709 | |
| Matthew McDonald plays Bottesini Grande Allegro alla Mendelssohn | This is a classical music piece from the romantic era. The piece is being performed by the double bass. There is a melancholic atmosphere to the piece. The overall feel is dark and dramatic. This piece could be used in the soundtrack of an art movie. | 2015-12-16T14:15:56Z | matthew mcdonald | Matthew McDonald double bass Tomoko Takahashi piano Giovanni Bottesini Grande Allegro 'alla Mendelssohn'. Recorded live in Berlin Philharmonie Kammermusiksaal November 2014 | ["Cello", "Double bass", "Bowed string instrument"] | ["classical music", "romantic era", "instrumental", "double bass", "melancholic", "dark", "dramatic"] | 9 | ji5wvUUQjHY | 4276 |
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;