musiccaps_details (view)
3 rows where musiccaps_aspects contains "poor audio quality" and musiccaps_names contains "Foghorn"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Winchester Mystery House Documentary (1963) - Lillian Gish | The song is an instrumental soundtrack. The tempo is medium with a string section harmony, horn section, flutes playing , violins playing and lower harmony played judiciously. The song is haunting and full of suspense. The song is a vintage suspense movie soundtrack. | 2015-02-18T06:50:32Z | stevers62 | This is the 1963 documentary (narrated by Lillian Gish) of the Winchester Mystery House. It's fascinating to see it as it was in 1963, and Lillian's narration is great. Hope you enjoy! Another YouTube user was kind enough to upload a version of this a couple years ago, and I found it fascinating. The only problem was the original source material was fairly washed out, and the full color network logo was extremely distracting. I made it black-and-white and increased the contrast to make it easier to see the material. It's still not great, but the content is so fascinating, historic, and spooky, it's still great viewing. If whoever posted the original wants to re-post this version, please just download and ping me and I'll take this one down. Just hoping to share this fascinating documentary. By the way, if you can redirect this to a 3-D television, it really gives a much better sense of depth and interest. | ["Foghorn", "Music", "Outside, urban or manmade"] | ["poor audio quality", "movie soundtrack", "haunting", "eerie", "string section harmony", "flutes playing", "crouching bass line", "horn section", "conductor", "instrumental", "suspense", "emotional", "building anticipation", "no percussion instruments", "retro movie soundtrack", "spooky movie", "dramatic", "philharmonic orchestra"] | 1 | 17AtKbQ7glU | 239 | |
| Kirk Douglas (Einar) viking funeral | The song is an instrumental movie soundtrack. The song is medium tempo with a choral section changing, trumpet playing melody and drums playing in a march rhythm. The song is majestic like a funeral march. The song is a movie soundtrack with a poor audio quality issue. | 2012-02-26T07:20:29Z | Joe Cortez | Final scene and closing credits from The Vikings by Richard Fleischer (1958) Título brasileiro: Vikings, Os Conquistadores | ["Foghorn", "Music", "Outside, rural or natural"] | ["poor audio quality", "movie soundtrack", "deteriorated audio quality", "retro movie themes", "emotional", "tribute", "passionate", "spirited", "trumpet playing", "majestic", "choral harmony", "changing tones", "funeral march", "triumphant", "royal march", "steady drumming rhythm", "medium tempo", "army marching", "choir singers"] | 1 | LClTjcyNJSI | 2163 | |
| Michael Manring "Adhan" | The song is an instrumental. The tempo is slow with an organ playing sustained chords. The audio quality is poor with a lot of hissing and strong gains that are distorted. The song is background music for a home video. The song is emotional and ominous. | 2007-12-06T05:04:31Z | Brian Wilson | Mr Manring, Hyperbass and 2 eBowS. Michael says this song was inspired by the sounds of the Muslim call to prayer. Haters telling me to take this down because it's blasphemy? Get an afterlife. | ["Bass guitar", "Guitar", "Foghorn", "Music", "Musical instrument", "Plucked string instrument"] | ["poor audio quality", "ominous music", "song intro", "meditative", "pensive", "melancholic", "slow tempo", "organ playing chords", "buzzing", "humming", "hot signal", "background music", "sad", "emotional", "instrumental", "amateur music recording", "unpleasant", "passionately"] | 1 | xx1RccwlF5g | 5365 |
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;