musiccaps_details (view)
3 rows where musiccaps_aspects contains "exciting", musiccaps_names contains "Progressive rock" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- exciting · 3 ✖
- guitar rhythm 2
- male singer 2
- medium tempo 2
- poor audio quality 2
- story telling 2
- adventurous 1
- cymbals crashing 1
- distorted guitar lead 1
- emotional 1
- energetic 1
- energetic crash cymbals 1
- enteric 1
- groovy bass 1
- groovy bass line 1
- groovy rhythm 1
- head bangers 1
- marching rhythm 1
- old school music 1
- people screaming 1
- percussive bass line 1
- positive 1
- positive cheerful 1
- punchy kick 1
- punchy snare 1
- retro classic rock 1
- retro pop music 1
- rock 1
- rock band 1
- rock drumming rhythm 1
- rock groupies 1
- rock hits 1
- romantic 1
- screaming vocals 1
- shimmering hi hats 1
- snare hits 1
- spirited 1
- spirited singing 1
- steady drumming rhythm 1
- vintage hits 1
- wide electric guitar melody 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music 3
- Progressive rock · 3 ✖
- Rock music · 3 ✖
- Psychedelic rock 2
- Christian music 1
- Grunge 1
- Guitar 1
- Heavy metal 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | A male singer sings this cool spirited melody. The song is medium tempo with a steady drumming rhythm, guitar playing lead, guitar strumming, strong bass line and various percussion hits. The song is exciting and energetic. The song has poor audio quality. | 2009-05-26T06:56:15Z | SirHenryII | Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | ["Music", "Psychedelic rock", "Rock music", "Progressive rock"] | ["male singer", "guitar rhythm", "percussive bass line", "medium tempo", "groovy rhythm", "old school music", "spirited singing", "retro pop music", "story telling", "steady drumming rhythm", "marching rhythm", "cymbals crashing", "snare hits", "enteric", "exciting", "positive cheerful", "spirited", "emotional", "vintage hits", "poor audio quality"] | 1 | ckOe-8qdaew | 3736 | |
Straight way Black or White Christian rock music Doug Middleton lead guitar | A male singer sings this rock melody. The song is medium tempo with a rock drumming rhythm, percussive bass line, distorted guitar accompaniment and keyboard accompaniment. The song is exciting and energetic. The song has poor audio quality. | 2010-01-26T03:10:24Z | tannere1 | Christian music Straight way title black or white doug middleton | ["Christian music", "Guitar", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song", "Progressive rock", "Grunge"] | ["poor audio quality", "rock band", "poor audio quality", "retro classic rock", "story telling", "romantic", "adventurous", "rock groupies", "rock hits", "medium tempo", "guitar rhythm", "groovy bass line", "rock drumming rhythm", "people screaming", "distorted guitar lead", "male singer", "screaming vocals", "exciting", "positive", "youthful", "head bangers"] | 1 | njFM8DvmPVU | 4571 | |
Starship Trooper in 1080p HD by Yes | The Rock song features a shimmering hi hats, energetic crash cymbal, punchy kick and snare hits, groovy bass guitar and wide electric guitars melodies playing on top of them. It sounds energetic and exciting. | 2013-11-19T02:05:24Z | vzqk50HD | From Wikipedia: According to Alice Cooper on his radio show Nights with Alice Cooper, Anderson claimed to have written the first two movements of "Starship Trooper" alone, though the "Disillusion" movement (which evolved from an earlier song "For Everyone", heard on Something's Coming: The BBC Recordings 1969--1970 and The Word Is Live) is credited to Chris Squire. The Würm part of "Starship Trooper" is a continuous cadenza of chords (G-Eb-C) played by ensemble and repeated adlib: first accompaniment: electric guitar on the right stereo channel, then acoustic guitar, bass pedals, and drums from middle channel, then organ and bass guitar with tremolo and distortion from left channel, then starts the guitar solo, that swaps from side to side. The whole piece lasts about three and a half minutes. "Würm" originally evolved from a song called "Nether Street" by Howe's earlier group, Bodast.[13] While "Wurm" (without the umlaut over the "u") is an Old English word for "dragon" (worm, wurm, wyrm), the Würm is a river in Germany which gave its name to an ice age in geology. Lyrics: Sister bluebird flying high above Shine your wings forward to the sun Hide the mystries of life on your way Though you've seen them, please don't say a word What you don't know, I have never heard Starship trooper, go sailing on by Catch my soul, catch the very light Hide the moment from my eager eye Though you've seen them, please don't tell a soul What you can't see, can't be very whole Speak to me of summer Long winters longer than time can remember The setting up of other roads To travel on in old accustomed ways I still remember the talks by the water The proud sons and daughter That knew the knowledge of the land Spoke to me in sweet accustomed ways Mother life, hold firmly on to me Catch my knowledge higher than the day Lose as much as only you can show Though you've seen me, please don't say a word What I don't know, I have never shared Loneliness is a power that we possess to give or take away forever All I know can be shown by… | ["Music", "Rock music", "Progressive rock"] | ["rock", "shimmering hi hats", "energetic crash cymbals", "wide electric guitar melody", "groovy bass", "punchy snare", "punchy kick", "energetic", "exciting"] | 4 | xk4U8BembHM | 5349 |
Advanced export
JSON shape: default, array, newline-delimited
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;