musiccaps_details (view)

1 row where musiccaps_aspects contains "flute", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "male voice"

✎ 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
Coral Castle's Ed Leedskalnin Vintage Footage This instrumental music is relaxing. It features a slow melody played on a harp. A flute continues to play a melody with the harp playing in the background. A male voice talks in the end in a narrative tone. This music can be played in a dream sequence in a movie. 2011-11-15T22:03:08Z wasarkiam Coral Castle aka Rock Gate Ed Leedskalnin, an animated, friendly, simple man who quarried over eleven hundred tons of coral rock for his Castle using tools fashioned from wrecking-yard junk, never revealing just how he managed to rise and position the massive coral blocks that make up his compound. The original site remained in Florida City until the mid l930's at which time, the story goes, someone planned to build a sub-division nearby. A fanatic for privacy, Ed packed up his entire quarry and moved it to the present location in Homestead. No one ever saw him load or unload the massive tonnage from a friend's truck he'd enlisted to transport the gigantic stones. The relocation progressed easily, and the entire complex was re-erected at its new location.Ed never revealing just how he managed to rise and position the massive coral blocks that make up his compound. An air of mystery surrounded the two story monolith known as the tower, which housed his workshop and living quarters. He was secretive and almost always worked at night; no one ever saw him. Ed seemed to have a sixth sense with which he could detect when he was being watched, often the hallmark of an intuitive. Ed stated, "if I concentrate on somebody's back while that person doesn't know it, they're liable to get restless and look around. I've noticed, I can chase the mosquitos away with this same, concentrated, look." Originally named "Rock Gate Park" the complex now known as Coral Castle is listed on the National Register of Historic Places. Ed disputed contempory science and believed, "all matter consists of magnets which can produce measurable phenomena, and electricity." Ed would say he had "re-discovered the laws of weight, measurement, and leverage," and that these concepts "involved the relationship of the Earth to celestial alignments." He claimed to see beads of light which he believed to be the physical presence of nature's magnetism, and life force, or what we term today chi. Visit our Channel for Ancient Mysteries including the mys… ["Saxophone", "Wind instrument, woodwind instrument", "Vibraphone"] ["instrumental music", "relaxing music", "flute", "harp music", "slow tempo", "male voice", "narration"] 0 j-93krRXAaY 4226

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;