musiccaps_details (view)

3 rows where musiccaps_aspects contains "crowd cheering", musiccaps_aspects contains "male voice singing" and musiccaps_names contains "Music"

✎ 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
posdata te quiero galway girl Two acoustic guitars being strummed can be heard while a male voice is singing in the mid range. Someone is strumming chords in a higher key alone. In the background you can hear acoustic drums and the crowd is cheering. This song may be playing live in a pub. 2009-09-12T14:37:30Z Adri Terroba galway girl-posdata te quiero DISCLAIMER: NO COPYRIGHT INFRINGEMENT INTENDED. FOR ENTERTAINMENT PURPOSES ONLY ["Singing", "Banjo", "Country", "Music"] ["pop/singer-songwriter", "amateur recording", "acoustic guitars", "mandolin", "male voice singing", "acoustic drums", "crowd cheering", "uptempo", "uplifting energy"] 6 BhJa0kTUdGY 1276
Joel Turner Live. Coke Live 2006 This audio contains someone beatboxing. Then a male voice starts singing loud and at a higher pitch. The crowd is cheering in the background. This song may be playing live during a beatbox performance. 2006-04-15T06:32:50Z lynxplayuh Joel Turner Live. Coke Live 2006 ["Beatboxing", "Music", "Speech", "Vocal music", "Inside, large room or hall"] ["amateur recording", "beatbox", "male voice singing", "crowd cheering", "medium to uptempo", "cheerful atmosphere"] 6 ByF0pp-dVEo 1309
BEAST - You / Fiction LIVE THis song contains a piano playing a major chord progression in the midrange with the left hand playing bass notes creating a simple bassline. An acoustic drum is playing a constant groove without any big changes. A male voice is singing in a higher register getting backing vocals from another male voice. In the background you can hear the crowd cheering. It mostly sounds like female voices. This song may be playing at a live concert. 2011-06-16T14:16:43Z DBSKtelevison Having already won a triple crown for "Fiction", the B2ST boys performed a special goodbye stage for their fans on today's Mnet M! Countdown. Though it has only been a month, the boys are wrapping up promotions on a high, having won triple crowns on M! Countdown and Music Bank, and being a two-time Mutizen winner on Inkigayo. In gratitude, B2ST will present their fans with a performance of their cute and lively song, "You". The production crew for M! Countdown stated, "B2ST, who showed their sorrowful and charismatic performance with their song 'Fiction', will be showing their sweet and lovely side through this performance. Please look forward to it!" ["Singing", "Music of Asia", "Music", "Independent music", "Pop music"] ["pop", "piano", "acoustic drums", "crowd cheering", "male voice singing", "higher pitch", "uptempo"] 6 yIFP8fkq8GU 5398

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;