musiccaps_details (view)

3 rows where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "low quality" and musiccaps_names contains "French horn"

✎ 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
Sarah Willis of the Berlin Philharmonic: Second Horn Tricks The low quality recording features sustained french horn tones played, while there is a low female vocal and flat male vocal talking, followed by some laughs, shoe squeaking and woodwind melody played in the background. The recording is a bit noisy and it sounds like the musicians are rehearsing. 2011-03-19T00:12:25Z Nina Perlove Nina Perlove observes Sarah Willis coaching members of the YouTUbe Symphony Orchestra at the Sydney Opera House. ["Brass instrument", "French horn"] ["low quality", "noisy", "sustained french horn tones", "low female vocal", "flat male vocal", "laughing", "shoe squeaking sound", "woodwind melody", "rehearse"] 4 4tH9knHaTd0 613
World of Warships - 1:42 Scale: Cruiser Varyag The low quality recording features a short snippet of flat male vocal talking, while in the background an orchestral music is playing. The music contains sustained brass melody, wide huge percussion and sustained strings melody. It sounds powerful and epic. 2016-01-27T14:26:16Z Wargaming Europe They are small, only 1:42 in scale compared to their real-life counterparts, but they have great stories to tell. New video in our series focuses on Russian cruiser Varyag. To keep up to date with our latest development, contests and events visit http://worldofwarships.eu/ Follow us on Facebook: http://www.facebook.com/worldofwarships Instagram: https://instagram.com/Wargaming_EU/ Vine: https://vine.co/Wargaming_EU Twitter: https://twitter.com/Wargaming_netEN https://twitter.com/Wargaming_netCZ https://twitter.com/Wargaming_netDE https://twitter.com/Wargaming_netES https://twitter.com/Wargaming_netFR https://twitter.com/Wargaming_netPL https://twitter.com/Wargaming_netTR ["Brass instrument", "French horn"] ["low quality", "orchestral", "sustained brass melody", "wide huge percussions", "sustained strings", "flat male vocal", "epic", "powerful"] 4 W4eLgBYEEqA 3060
Barry Tuckwell french horn lesson part3 The low quality recording features a tutorial that consists of a french horn melody played in-between flat male vocal talking. The recording is noisy, mono and quiet. 2008-07-14T07:42:35Z Angelo Bonaccorso part3 ["Brass instrument", "French horn", "Wind instrument, woodwind instrument"] ["low quality", "noisy", "french horn melody", "flat male vocal", "tutorial", "quiet", "mono"] 4 nZQZ7CpXqAU 4554

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;