musiccaps_details (view)

1 row where musiccaps_aspects contains "dramatic", musiccaps_aspects contains "sustained strings melody" and musiccaps_names contains "Bowed string instrument"

✎ View and edit SQL

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
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;