musiccaps_details (view)

2 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2006-04-19

✎ 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
cacophony - concerto This music is a vigorous electric guitar instrumental. The tempo is fast with an electric guitar rapid melody lead and an electric guitar Accompaniment. The melody is contrasted and syncopated. The music is dark, intense, extreme, dire and compelling Heavy Metal. 2006-04-19T19:26:13Z chrisote cool ["Music", "Cacophony"] ["instrumental", "fast tempo", "electric guitar", "amplified guitars", "sonic power", "loud feedback", "syncopated harmony", "electric guitar lead", "electric guitar rhythm", "intense", "sinister", "dire", "grim", "compelling", "heavy metal", "hard rock", "dexterity", "home video", "home recording"] 7 BXo1Tr_oJds 1254
"11 O'Clock Tick Tock" - Belfast , January 1981 The low quality recording features a live performance of a rock song and it features passionate male vocals, alongside harmonizing male vocals, singing over arpeggiated electric guitar melody, boomy bass guitar, punchy kick and snare hits and shimmering open hats. It sounds noisy and messy, as the frequencies are clashing with each other, but it is still groovy and emotional regardless. 2006-04-19T19:19:34Z u2log The audience reaction is great in this clip. ["Bass guitar", "Music", "Punk rock", "Rock and roll"] ["low quality", "rock", "live performance", "arpeggiated electric guitar melody", "passionate male vocal", "harmonizing male vocals", "boomy bass guitar", "shimmering open hats", "punchy kick", "punchy snare", "messy", "noisy", "groovy", "emotional"] 4 zWJC_qr2610 5486

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;