musiccaps_details (view)

3 rows where musiccaps_aspects contains "classic rock" and musiccaps_names contains "Progressive rock"

✎ 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
The Long Walk Home-"Sights & Sounds" A e-guitar is playing a melody along with the e-bass. The acoustic drums are playing with a loud 8th note rhythm on the ride cymbal. Another e-guitar is playing a high pitched melody on top. This song may be playing at a festival. 2007-06-15T09:38:48Z longWalk07 Video for the song "Sights & Sounds" showing the band on tour earlier this year.... ["Music", "Independent music", "Psychedelic rock", "Rock music", "Progressive rock"] ["classic rock", "e-guitars", "e-bass", "acoustic drums", "medium to uptempo"] 6 ap7xvCBtljs 3574
ROCK 'N ROLL ICE CREAM - Marky Ramone & Missing Sound.mov A male singer sings this rock melody. The song is medium fast tempo with a strong rock drumming rhythm, percussive bass line, distorted guitars playing rhythm and lead along with tambourine percussion. The song is energetic and cheerful. The song is a rock song with an average quality audio. 2012-02-10T11:45:21Z gian maria emendatori ["Heavy metal", "Music", "Punk rock", "Progressive rock", "Grunge"] ["male singer", "rock music", "classic rock", "string rock drumming", "average audio quality", "retro rock", "passionate", "rock band", "youthful", "energetic", "cheerful", "studio recording", "medium fast tempo", "string rock drumming", "tambourine percussions", "electric guitar lead", "percussive guitar strumming", "groovy bass line", "distorted guitars"] 1 fXhN3_gGpQw 3957
Magenta - King Of The Skies A female vocalist sings this spirited song. The tempo is fast with enthusiastic electric guitar harmony, slick drumming, groovy bass lines and synthesiser arrangements. The song is energetic, youthful, fun, pulsating, engaging and emphatic. This song is Alternative Rock. 2006-06-21T17:59:15Z chrismagenta Track from Magenta's The Gathering DVD. Amazing Welsh Progressive Rock band in the vain of Genesis, Yes and Renaissance. ["Singing", "Heavy metal", "Music", "Independent music", "Pop music", "Rock music", "Song", "Progressive rock"] ["female vocalist", "fast tempo", "vibrant electric guitars", "progressive rock", "symphonic rock", "alternative rock", "slick drumming", "synthesiser articulation", "vivacious", "youthful", "vibrant", "groovy bass lines", "engaging", "powerful", "rock", "classic rock", "soft rock"] 7 pp6eSGANq0Y 4737

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;