musiccaps_details (view)

3 rows where musiccaps_aspects contains "steady drumming rhythm" and musiccaps_names contains "Jazz"

✎ 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
music wydad 2010 A male singer leads backup singers in a vocal harmony. The song is medium tempo with a heavy percussive drum rhythm, strong bass line, keyboard accompaniment and a trumpet playing in unison with the vocals. The song is groovy and passionate and sounds like the theme song of a football club. The song audio quality is very poor. 2010-10-01T18:21:22Z zouhir564 music wydad 2010 ["Jazz", "Music", "Middle Eastern music"] ["male singers", "vocal harmony", "trumpet playing in unison", "percussive bass line", "heavy bass drum rhythm", "brass band", "football match theme", "bad audio quality", "hissing tones", "spirited", "emotional", "medium tempo", "passionate", "fans", "steady drumming rhythm", "keyboard accompaniment"] 1 A3vsvL-Yx0Q 1063
Prince Buster - All my loving The song is an instrumental. The tempo is medium with a distinctive reggae style backbeat drumming rhythm and a guitar playing rhythm along with a bass guitar solo. The song is extremely passionate and groovy in nature. The audio quality is poor. 2008-09-12T17:27:26Z Schmidthorst69 Killer Rocksteady version of this alltime Beatles classic tune by the one and only voice of the people! ["Swing music", "Jazz", "Music", "Reggae", "Ska"] ["instrumental music", "reggae music", "drum stick play", "ska song", "classic dance hits", "tropical vibes", "medium tempo", "bouncy", "retro dance hits", "tropical paradise", "rim shots", "ska music", "retro ska", "syncopated rhythms", "guitar accompaniment", "groovy bass line", "instrumental music", "guitar lead", "retro hits", "steady drumming rhythm", "groo"] 1 SkFG5SoXsVk 2784
salam- pentru cristofor la udi A male singer sings this passionate vocal. The song is medium tempo with a groovy bass line, steady drumming rhythm and a violin playing a solo. The song is a live performance by a folk singer. The song has a bad audio quality issue. 2008-09-28T14:54:29Z elicsir0515 talent:X ["Jazz", "Music", "Orchestra", "Speech"] ["male singer", "screaming", "poor audio quality", "wedding music", "live band", "arabic folk singer", "excited vocals", "medium tempo", "groovy bass line", "steady drumming rhythm", "crowd noise", "ambient street noise", "folk singer", "live audience", "live performance", "violin playing solo"] 1 bZJoTauRldE 3634

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;