musiccaps_details (view)

1 row where musiccaps_aspects contains "synth delay effect", musiccaps_author = 2, musiccaps_names contains "Ukulele" and "youtube_published" is on date 2010-12-27

✎ 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
Helping Our Wild Deer Friend Eva The music features a stringed instrument playing a melody. I'm not sure what instrument it is, it sounds oriental. I can say for sure it's not an acoustic guitar. This instrument has a synth delay effect on, meaning whenever a note is played, a device plays that same note with the sound of a synth. 2010-12-27T18:15:45Z Pelorian Pages Our wild deer friend Eva is the matriarch of her herd, and we live on the herd's traditional migration area. Over many years the herd has "adopted us" and they greatly appreciate that we don't care if they eat the clover lawn we planted, or any of the other vegetation. Sometimes, when we notice a deer in trouble, we help out. Eva had two large scrapes on her back. Perhaps she ran through the woods and scraped against some low hanging branches. We used the Bach Flower Remedy Rescue Cream on her wounds to help heal them, and to lessen the chance that they would become infected. Since deer love to eat flowers more than almost anything else, we are sure Eva approves of the Rescue Cream. Music in the video from Starseed: http://www.starseedmusic.net The musical track featured in this video is titled: "In's Herz der Dinge" (Into the Heart of Things) recorded live in concert. For the full story, and more photos and videos, see the Deer in the Yard web pages: http://www.pelorian.com/deer.html ["Music", "Ukulele"] ["stringed instrument", "synth delay effect", "oriental"] 2 yIOUPSGFqoY 5399

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;