musiccaps_details (view)

1 row where musiccaps_aspects contains "ambient outdoor sounds", musiccaps_aspects contains "engaging", musiccaps_aspects contains "lively viloin" and musiccaps_aspects contains "playful"

✎ 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
Electrocute Your Nerves To Music This music is a lively violin composition. The tempo is fast with a spirited violin harmony and vivacious viola and cello accompaniment. The music is upbeat, happy, cheerful, playful, fresh and captivating with the voice of a woman superimposed on it with static and ambient outdoor sounds. This instrumental is a background music to a live presentation happening outdoors. 2014-05-07T13:00:06Z Hard Science Watch Tara turn Anthony and Alex into puppets using a hacked TENS unit! Thanks so much for watching Hard Science! We're going on hiatus, think of it like summer break. If you want more science AND more Tara be sure to check out DNews: https://www.youtube.com/user/DNewsChannel Check out DIY Tryin' to see how they made the hacked TENS unit: https://www.youtube.com/watch?v=k9wpirvB5_A&list=UU31lhxGZwVLcchmL0fwWBYg To see more of Alex, watch Animalist News here: http://animalist.com/animalistnews SAFETY NOTE: keep the electrode pairs on the same side of the body, never crossing the body/heart. TENS Unit http://en.wikipedia.org/wiki/Transcutaneous_electrical_nerve_stimulation Transcutaneous electrical nerve stimulation (TENS) is the use of electric current produced by a device to stimulate the nerves for therapeutic purposes. Electrical Muscle Stimulation http://en.wikipedia.org/wiki/Electrical_muscle_stimulation Electrical muscle stimulation (EMS), also known as neuromuscular electrical stimulation (NMES) or electromyostimulation, is the elicitation of muscle contraction using electric impulses. Luigi Galvani http://en.wikipedia.org/wiki/Electrical_muscle_stimulation Luigi Galvani (1791) provided the first scientific evidence that current can activate muscle. Watch Hard Science on TestTube: http://testtube.com/hardscience Subscribe now! http://www.youtube.com/subscription_center?add_user=hardscienceshow Watch extra footage from Hard Science here: http://testtube.com/hardscienceextras Follow Hard Science on Twitter: http://twitter.com/hardscienceshow Like Hard Science on Facebook: http://facebook.com/hardscienceshow Add Hard Science on Google+: http://goo.gl/BKfY3U Anthony on Twitter: http://twitter.com/acarboni Tara on Twitter: http://twitter.com/taralongest Alex on Twitter: http://twitter.com/damnitsgood808 Special thanks to our Science Advisors! Dr. Kiki Sanford: ?http://twis.org Zeke Kossover: http://www.kossover.net Hard Science Crew: Executive Producer: Barry Pousman Producer: Nicolette Beth… ["Swing music", "Jazz", "Music", "Speech"] ["instrumental", "fast tempo", "woman speaking", "background", "superimposed vocals", "cheerful", "playful", "lively viloin", "vivacious cello", "viola", "upbeat", "engaging", "spirited", "static", "ambient outdoor sounds", "cheerful melody"] 7 4ZwGxgOwBUc 585

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;