musiccaps_details (view)

3 rows where musiccaps_aspects contains "compilation" and musiccaps_names contains "Singing"

✎ 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
Vlog No. 12 - SHINee's unofficial Vlogs of 2012 - mistakes & unexpected The low quality recording features a compilation of recordings where the first recording in the loop is a live performance that's distorted, loud and in mono. The second part of the recording is very noisy and it features bright bells, some resonating sounds and it sounds weird. 2013-01-11T19:53:33Z maggie198333 more to come~ please do not re-upload https://twitter.com/maggieline7 http://www.tudou.com/home/maggie198333 ["Singing", "Music of Asia", "Music", "Pop music", "Chink, clink"] ["low quality", "live performance", "loud", "distorted", "bright bells", "noisy", "mono", "resonating sound", "weird", "compilation"] 4 6II4JGJDyZo 740
Cecilia Bartoli's Operatic Vocal Range (in about a minute!) This piece is a compilation of an opera singer's high-pitched singing that shows how high of a pitch she can reach. For the most part, she is holding a single high note as the strings in the orchestra provide the harmonic background. 2010-12-23T17:05:25Z SsteinwayS US: http://amzn.to/2itVgnr Canada: http://amzn.to/2iRUtNK Cecilia Bartoli’s vocal range: from low E below middle C to high E-flat above soprano high C! ["Singing", "Music", "Opera"] ["opera", "classical", "orchestra", "strings", "female vocal", "high-pitched singing", "compilation", "vocal range"] 9 AElgGuUSSKE 1088
Demi lovato head voice and whistle register The low quality recording features a compilation of pop songs. The first song features an echoing female vocal sining, alongside wide harmonizing female vocals, over arpeggiated solo electric guitar melody, sustained strings progression, smooth bass, soft kick hits, punchy snare, simple hi hats and shimmering open hat. At the very end of the loop, there is a short snippet of the second song that consists of flat female vocals singing over claps, synth keys melody and punchy kick. It sounds emotional and passionate, even though the mix is bad. 2014-03-08T13:11:42Z Richard Cross Demi lovato head voice whistle register and exclamations. The last one is an F7 not an F8. Follow me on Twitter @Richardtcross ["Singing", "Music", "Song", "Zing"] ["low quality", "pop", "echoing female vocal", "punchy snare", "shimmering open hat", "simple hi hats", "wide harmonizing female vocals", "smooth bass", "arpeggiated electric guitar solo melody", "sustained strings progression", "soft kick", "compilation", "claps", "punchy kick", "flat female vocal", "synth keys melody", "emotional", "passionate", "uplifting"] 4 GHQlBD-6rkA 1707

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;