musiccaps_details (view)

4 rows where musiccaps_aspects contains "male voice" 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
chopping new zealand maize 2014 This hard rock song features a male voice singing the main melody. The song starts with a distortion guitar playing a riff. The percussion plays a simple beat in common time. Once the voice starts singing, the guitars play power chords using down strokes. The bass follows the root notes of the chords. The mood of this song is happy. This song can be played in a car chase sequence in a movie. 2014-06-15T20:17:58Z snoopfizzel john Austin maize season new Zealand ["Heavy metal", "Music", "Punk rock", "Progressive rock", "Grunge"] ["hard rock", "glam rock", "male voice", "happy mood", "distortion guitar", "rock percussion", "fast tempo", "rock bass"] 0 Gde1fn1Y1uM 1745
tribute to Oi, ska & Punk This punk rock song features a male voice singing the main melody at a comfortable pitch. This is accompanied by percussion playing a simple rock beat. A distortion guitar plays power chords using downstrokes. The bass plays the root notes of the chords. This song is played at a moderate tempo. This song can be played at the end credits of an action movie. 2009-04-29T02:58:40Z skinbash69 This is the tribute to all of my friends in the Oi, Ska & Punk Scene in the asian countries such as Singapore, Malaysia, Indonesia, Philippines & Brunei. Keep the scene alive...CHEER. ["Heavy metal", "Music", "Punk rock", "Ska", "Progressive rock"] ["punk rock", "male voice", "distortion guitar", "percussion", "bass", "moderate tempo", "upbeat song"] 0 PP3kNqPM434 2532
Indie Music Streaming - 6 Years This country rock song features a male voice singing at a high pitch. This is accompanied by percussion playing a simple beat. A guitar strums chords. The bass guitar plays the root notes of the chords. The mood of this song is romantic. This song can be played in a romantic movie. 2015-07-09T03:30:11Z Music Lesson Central Indie Music Streaming Music Lesson Central - Learn How To Play Music Learn Guitar, Piano, Bass, Drums, Harmonica, and Mandolin ["Music", "Independent music", "Rock music", "Song", "Progressive rock"] ["country rock", "male voice", "moderate tempo", "bass guitar", "electric guitar", "simple percussion", "romantic mood"] 0 WeDA1mDFSCo 3120
JC-120 Roland Jazz Chorus Amp This is the recording of a gear showcase. There is a male voice advertising an effect amp. The distorted electric guitar is playing a crunchy-sounding riff with the added effect of the chorus amp. The atmosphere is hard-hitting. Some parts of this recording could be used in heavy guitar samples for beat-making. Such parts could also work in sections of an advertisement jingle. 2007-03-13T06:13:47Z nikmarkmedia Johnny DeMarco and Gary Lenaire Show you the Amazing Powers of the Legendary Roland Jazz Chorus JC-120 ["Electric guitar", "Guitar", "Heavy metal", "Music", "Musical instrument", "Rock music", "Speech", "Progressive rock", "Grunge", "Plucked string instrument"] ["gear showcase", "jam", "male voice", "advertising", "distorted electric guitar", "guitar solo", "amp", "chorus", "hard-hitting", "crunchy"] 9 hRQJgZVxRX0 4103

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;