musiccaps_details (view)

3 rows where musiccaps_aspects contains "melodic singing" and musiccaps_names contains "/t/dd00004"

✎ 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
Singing Chasing Pavements This is an amateur vocal cover of a pop music piece. There is a teen female vocalist singing melodically. On the backing track, an acoustic guitar is heard playing the main theme while an acoustic sounding drum track is playing the rhythmic background. The atmosphere is melancholic. 2008-11-14T00:46:48Z alyssa bernal I think it's safe to say that this is one of my favorite songs now. I love it man! geeze. baha. Okay random. freakin love y'all;; lyss ["Music", "/t/dd00004"] ["pop music", "teen female vocal", "melodic singing", "acoustic guitar", "simple drum track", "melancholic", "emotional"] 9 1RhYdQnZ_hw 274
Hayley Williams & Josh Farro - You Ain't Woman Enough (Loretta Lynn cover) - Paramore This is an acoustic live performance of an alternative music piece. There is a female vocalist singing melodically at a soprano range. In the melodic background, there is an acoustic guitar playing a simple tune. The piece has an emotion-filled atmosphere. It could be used in the soundtrack of a drama movie or a TV show. 2009-11-02T07:39:48Z planecrashdream This is the original, first, and only UNPLUGGED performance! This is my video. The other copies of this around youtube are fakes. This was on November 1st, 2009. Ryman Auditorium, Nashville, Tennessee. It was so incredible. PLEASE no comments about the yelling, or comments bashing Jenna or about Hayley and Josh being together. They aren't together and their significant others don't deserve hate. ["Singing", "Music", "/t/dd00004"] ["alternative", "acoustic", "live performance", "female vocal", "soprano", "melodic singing", "acoustic guitar", "simple tune", "emotional"] 9 eWGGj4duzIo 3869
Mennonites Singing on Subway This is a street performance of a church hymn. It is being performed by a choir singing melodically in a devotional manner. The atmosphere is religious. The audio quality is a bit poor. 2007-06-23T14:16:42Z Thomas Byro Did they get lost here? At least their singing is pleasant (Hare Krishnans take note). They are dedicated to a life of belief. I toward knowledge. When the long night claims us, we will be the same ["Choir", "/t/dd00004"] ["street performance", "church hymn", "choir", "melodic singing", "religious", "devotional", "spiritual"] 9 ncMDKMEFhnM 4565

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;