musiccaps_details (view)

3 rows where musiccaps_aspects contains "male choir" and musiccaps_author = 6

✎ 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
Dota 2 Daily WTF - Techies Stories: Minefield The song sounds epic and is fully orchestrated with a string section; brass section; a male choir in the background, fast timpani hits and strings playing a melody. When the song stops, a door knocking sound can be heard along with a short video-game music sequence that does not belong to the previous song. The first song may be playing in a movie trailer. 2015-10-08T12:58:09Z Dota Watafak Dota 2 fail/win compilation Submit your clip / Manda tu video: http://dotawatafak.com/ Check out the WTF Tees: http://shrsl.com/?~8c3r Facebook https://www.facebook.com/DotaWatafak Twitter: https://twitter.com/Dota2WTF Thumbnail Art by: Louissry http://louissry.deviantart.com/ ES_Choirs Of War 3 - Johannes Bornlöf (epidemicsound) RoccoW_-_Break-A-Leg (freemusicarchive.org) -Licensed under Creative Commons: By Attribution 3.0 http://creativecommons.org/licenses/by/3.0/ ["Music", "Knock"] ["cinematic", "epic", "strings", "horn section", "male choir", "timpani hits", "door knocking", "uptempo", "amateur recording"] 6 IKq2OF8jq1c 1895
ACAPPELLA This audio contains several male voices singing an a acapella song as a choir. The voices go from the higher mids to the higher register. This song may be playing live in a church. 2005-11-27T14:40:12Z yr33jh made by me ["Singing", "Music", "Vocal music", "A capella"] ["amateur recording", "acapella", "male choir", "mid to high range", "medium to uptempo"] 6 I_a9OhfTcIc 1918
I Am the Very Model of a Modern Major-General A male choir is at the end of a phrase before a single male voice takes over singing with a mid ranged opera voice along to a piano and an accordion. In the background the crowd is cheering,laughing and clapping. This song may be playing in a theater. 2007-11-11T09:03:29Z ThePenzancePirate Gilbert and Sullivan's raucous operatic tale is captured in all its fun and glory in this production, recorded live at Central Park's Delacorte Theater. Kevin Kline sparkles as the swashbuckling and libidinous Pirate King while Linda Ronstadt makes her theatrical debut as the lovely and virginal Mabel. When Mabel and Frederic, a young pirate bound to serve the Pirate King, fall in love, complications arise and high spirited antics ensue. The incomparable cast offers the best in this boisterous romp. Despite some of the technical shortcomings of the DVD I found it more rewarding than the 1983 movie. I would thoroughly recommend adding a copy of this DVD to your library. ["Applause", "Music"] ["musical/opera", "male mid range voice singing", "acoustic piano", "accordion", "male choir", "background cheering and clapping", "uptempo", "comedic"] 6 zSGWoXDFM64 5477

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;