musiccaps_details (view)
3 rows where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "low quality" and musiccaps_names contains "French horn"
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
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;