musiccaps_details (view)

2 rows where musiccaps_aspects contains "amateur recording", musiccaps_author = 9 and musiccaps_names contains "Blues"

✎ 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
Afro Cuban Rumba music and dance -- havana, cuba This is an amateur recording of an Afro-cuban dance music performance. There are male vocals singing joyfully. There is a percussion orchestra made up of diverse elements such as the conga, the bongo and the timbales are playing in the rhythmic background. The atmosphere is lively and vibrant. Although the audio quality is not that great, this piece can still be sampled for use in beat-making. 2009-03-26T00:28:54Z mathmuse live at the palenque -- vedado, havana, cuba ["Blues", "Traditional music", "Music", "Speech", "Dance music"] ["afro cuban dance", "amateur recording", "street performance", "male vocals", "percussion", "conga", "bongo", "timbale", "lively", "vibrant"] 9 07mS0mSTDjY 124
Journey - "Lights" guitar solo This is an amateur recording of a guitar solo for a rock music piece. The solo is being played on an overdriven electric guitar while the piano and the bass guitar in the backing track play the main tune. There is a 6/8 rock beat played on the acoustic drums for the rhythm section. There is a raw feel to it. The piece can be used to gather electric guitar samples to be used in beat-making. 2009-08-16T15:44:28Z ChuckieVeee Journey - "Lights" guitar solo played on an Epiphone Prophecy GX through a Roland Micro Cube ["Blues", "Music"] ["amateur recording", "rock music", "instrumental", "electric guitar", "guitar solo", "bass guitar", "piano", "acoustic drums", "groovy", "hard", "raw"] 9 s2GctT6NuyQ 4917

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;