musiccaps: musiccaps_details: 4 rows where "youtube

4 rows where "youtube_published" is on date 2008-12-17

descending

youtube_link	musiccaps_caption	youtube_published	youtube_channel	youtube_description	musiccaps_names	musiccaps_aspects	musiccaps_author	youtube_id	musiccaps_rowid
Wii Theremin - Santa Claus is Coming to Town	This music is an instrumental of the Christmas Carol “You Better Watch Out’. The tempo is medium with the lead harmony on the theremin and piano accompaniment. The music is haunting, ethereal, lilting, mesmerising and captivating. This music is a Theremin Instrument.	2008-12-17T15:23:34Z	Ken Moore	This is my submission for NPR's National Caroling Party 2008. The instrument is my homemade Wiimote-powered Theremin (simulator). The technology links a Wiimote controller, infrared LED gloves and a Roland JV-1080 synthesizer to create Theremin-like sounds.	["Music", "Musical instrument", "Theremin"]	["instrumental", "theremin", "electronic sounds", "female voice like sound", "high notes", "better watch out", "piano accompaniment", "christmas carol", "no contact instrument", "ethereal", "eerie sound", "electronic instrument", "air notes", "electromagnetic instrument", "celestial", "beautiful", "captivating", "enthralling", "mesmerising music"]	7	2-K-7T8ZIWA	323
Chromatic Tuner HT-2 Digitech Hardwire por Diego Mizrahi	The low quality recording features a passionate electric guitar solo melody over wide playback rock instrumental. The recording is noisy.	2008-12-17T21:30:31Z	jendrix2008	Diego Mizrahi nos presenta el pedal Chromatic Tuner HT-2 de la línea HardWire de DigiTech. 2008	["Electric guitar", "Music", "Rock music", "Electronic tuner", "Progressive rock"]	["low quality", "wide playback instrumental", "rock", "passionate electric guitar solo melody", "noisy"]	4	NdiSW-p2I0c	2352
김홍철과 친구들 / 아름다운 스위스 아가씨	The folk music excerpt features a group of male and female voices singing the same melody in unison which consists of yodeling. The instrumental consists of a few accordions, an acoustic guitar and an upright bass. The atmosphere is one of joy.	2008-12-17T04:06:12Z	Kane Kang	OBS 경인TV http://www.obs.co.kr 주철환 김미화의 문화전쟁 라이브. http://www.culturewars.tv/ 1983년 요들가수 김홍철을 중심으로 결성된 '김홍철과 친구들'은 알프스 지방의 요들송과 스위스 민속 음악을 연주하는 아시아의 유일한 그룹이었으나, 1993년 김홍철의 캐나다 이민으로 해체되었다가 2003년 재결성되었습니다. '김홍철과 친구들'이 영국의 요들러 'Frank Ifield'의 원곡 'She taught me how to yodel'을 개사한 '아름다운 스위스 아가씨'를 라이브로 부릅니다. Live stage from OBS Culturewars. Korean yodel group "Kim Hong-Chul & Friends" sing Frank Ifield's yodel song 'She taught me how to yodel'.	["Singing", "Yodeling", "Music", "Musical instrument"]	["male and female voices", "accordion", "acoustic guitar", "upright bass", "folk music", "yodeling", "joy"]	2	TEoDtxjlctA	2823
Salty Dog Blues: Piedmont Blues Fingerstyle	The low quality recording features an acoustic guitar blues melody. The recording is very noisy, roomy and you can hear cars passing by in the background.	2008-12-17T22:33:33Z	bostonteabagger71739	My version of the old blues song. A little sloppy I know haha	["Country", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"]	["low quality", "blues", "acoustic guitar melody", "noisy", "roomy", "cars passing"]	4	g_bgmnJ1b_g	4039

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;

musiccaps_details (view)

4 rows where "youtube_published" is on date 2008-12-17

Advanced export