musiccaps_details (view)

1 row where musiccaps_aspects contains "mono", musiccaps_aspects contains "reverberant" and "youtube_published" is on date 2011-05-10

✎ 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
Bugle Calls : Every bugle call The low quality recording features a bright brass melody played in a reverberant space. The recording is in mono and it is a bit noisy. 2011-05-10T22:25:05Z Jenna Marbles NEW CHANNEL : http://YOUTUBE.COM/RYANTHOMASTV bugle calls: A bugle call is a short tune, originating as a military signal announcing scheduled and certain non-scheduled events on a military installation, battlefield, or ship. Historically, bugles, drums, and other loud musical instruments were used for clear communication in the noise and confusion of a battlefield. Naval bugle calls were also used to command the crew of many warships (signaling between ships being by way of signal flags.)A defining feature of a bugle call is that it consists only of notes from a single overtone series. This is in fact a requirement if it is to be playable on a bugle or equivalently on a trumpet without moving the valves. (If a bandsman plays calls on a trumpet, for example, one particular key may be favored or even prescribed, such as: all calls to be played with the first valve down.)Bugle calls typically indicated the change in daily routines of camp. Every duty around camp had its own bugle call, and since cavalry had horses to look after, they heard twice as many signals as regular infantry. "Boots and Saddles" was the most imperative of these signals and could be sounded without warning at any time of day or night, signaling the men to equip themselves and their mounts immediately. Bugle calls also relayed commanders' orders on the battlefield, signaling the troops to Go Forward, To the Left, To the Right, About, Rally on the Chief, Trot, Gallop, Rise up, Lay down, Commence Firing, Cease Firing, Disperse, and other specific actions Adjutant's Call: indicates that the adjutant is about to form the guard, battalion, or regiment. Alarm (as played by Sam Jaffe near the end of Gunga Din) Assembly: Signals troops to assemble at a designated place. Attention: Sound as a warning that troops are about to be called to attention. Boots and Saddles: Sounded for mounted troops to mount and take their place in line. Call to Quarters: Signals all personnel not authorized to be absent to return to their quarters for the night. Charge: Si… ["Brass instrument", "Trumpet"] ["low quality", "bright brass melody", "noisy", "mono", "reverberant"] 4 S7igso5_MBE 2741

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;