home / musiccaps

musiccaps_details (view)

3 rows where musiccaps_aspects contains "psychedelic" 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
System Of A Down - Chop Suey (Pinkpop Festival 2002) This song is a vigorous metal instrumental. The tempo is fast with intense drumming, fiery electric guitar riff, amplified guitar rhythms and energetic keyboard accompaniment. The music is energetic, aggressive, youthful, spirited, goth, intense,psychedelic and trance like. This instrumental is Hard Rock/Metal. 2008-07-10T10:54:28Z innervis1on Chop Suey + La Isla Bonita (Cover). Live @ Pinkpop Festival 2002 ["Heavy metal", "Music", "Progressive rock"] ["intense", "vigorous", "loud electric guitar feedback", "intense", "psychedelic", "trap", "trance", "hard rock", "enthusiastic", "energetic", "spirited", "hyper", "fast tempo", "goth rock", "heavy metal", "amplified guitar", "intense drumming", "chattering sounds", "scratching", "screeching", "vigorous keyboard"] 7 -dVgUSrR8g4 68
Oceans -- Prog Rock Instrumental -- 1976 Electra Omega X210 This is an instrumental progressive rock piece. There is an electric guitar playing an arpeggio in the melodic background while another is playing a solo as the lead. A simple 4/4 rock beat is with electronic drum sounds. The atmosphere has a trippy, psychedelic feeling to it. This piece could be used in the trip/nightmare sequences of retro themed horror movies. 2008-07-09T02:39:57Z wnorcott http://www.fillmorepedal.com This is a -- S T E R E O -- progressive rock guitar instrumental called Oceans. Played on the 1976 Electra Omega X210 guitar. This guitar piece is kind of like Pink Floyd meets Robin Trower meets Yes. I built the guitar effects myself. The 1976 Electra Omega X210 guitar is a Les Paul Custom with a jacaranda figureboard and Electra's funktastic Magnaflux 50 pickups. I recorded part 2 over on Vimeo here is the link http://www.vimeo.com/1324272 NOTE To play it in stereo type this at the end of the URL &fmt=18 or just click on this link http://www.youtube.com/watch?v=FXQxobF8FWw&fmt=18 I HOPE YOU LIKE IT. ["Electric guitar", "Guitar", "Music", "Independent music", "Rock music", "Progressive rock"] ["progressive rock", "instrumental", "electric guitar", "guitar solo", "effect pedal", "electronic drums", "trippy", "psychedelic"] 9 FXQxobF8FWw 1645
A Static Lullaby "Toxic" Official Music Video HQ | Director: Robby Starbuck A male vocalist sings this energetic rock song. The song is fast tempo with emphatic drumming, groovy bass lines, funky electric guitar feedback and keyboard accompaniment, with animated, high pitched backup. The song is youthful, energetic,spirited, intense, psychedelic and passionate. This song is Hard Rock. 2009-03-02T21:57:13Z RobbyStarbuck Please watch after clicking "High quality" button Directed By: Robby Starbuck (follow on twitter @robbystarbuck) Song: Toxic Label: Fearless Album: Punk Goes Pop 2 Released March 2, 2009! www.robbystarbuck.com ["Heavy metal", "Music", "Rock music", "Drum machine", "Progressive rock", "Grunge"] ["male singer", "fast tempo", "youthful", "progressive", "compelling", "passionate", "funky electric guitar feedback", "emphatic drumming", "groovy bass lines", "animated vocal backup", "high pitched singing", "funky electri guitar feedback", "youthful", "progressive", "hard rock", "metal", "hard metal", "goth rock", "punk rock", "energetic", "emphatic", "intense", "goth", "psychedelic"] 7 JrOV2Xz2djA 2039

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;
Powered by Datasette · Queries took 767.732ms · About: simonw/musiccaps-datasette