musiccaps_details (view)
4 rows where musiccaps_names = "["Music", "Rock music", "Progressive rock"]" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Magasin - Eraserheads (Paolo Santos Cover) | instrumental rock music with a drum kit, lots of cymbal crashes, acoustic guitar strumming, harmonized lead guitars and an active bass guitar. | 2008-02-07T23:57:50Z | joaq25 | Song:Magasin Artist:Eraserheads(This version sang by Paolo Santos) | ["Music", "Rock music", "Progressive rock"] | ["rock", "four chord jam", "drum kit", "cymbal crashes", "acoustic guitar strumming", "harmonized lead guitars", "active bass guitar", "instrumental"] | 8 | 9kt7rsziUVQ | 1038 | |
Genesis - Cinema Show (second part) live | This music is an upbeat instrumental. The tempo is fast with keyboard harmony, enthusiastic drumming and electronic arrangements. The harmony sounds like a synthetic sound of a bagpiper . The music is chaotic, quirky, playful, and cheerful. | 2006-08-31T18:22:42Z | lies112 | Genesis playing the Cinema Show in concert | ["Music", "Rock music", "Progressive rock"] | ["instrumental", "fast tempo", "keyboard harmony", "electronic music", "quirky", "confusion", "upbeat", "electronic arrangements", "playful", "animated", "bagpiper sound", "hard hitting drums", "chaotic music"] | 7 | KU2bOYiBX28 | 2086 | |
RUIDO ROSA - MIEDO A CAER | This is an energetic rock music piece with a female vocalist singing in the Spanish language. The repeated theme is played by a strong electric bass guitar. There is a loud and simple rock drum beat in the background. A distorted electric guitar can also be heard holding a sustained note. All these components result in a rebellious atmosphere. This song could be used in rock bars. | 2011-08-26T07:45:49Z | Ruido Rosa | Miedo a caer es el segundo sencillo que se desprende del primer EP homónimo de la banda Ruido Rosa. www.ruidorosa.com.mx contacto: ruidorosaa@gmail.com | ["Music", "Rock music", "Progressive rock"] | ["rock music", "bass guitar", "repeated theme", "drums", "electric guitar", "female vocal", "spanish", "loud", "rebellious", "energetic"] | 9 | rs5ecH8Lh3s | 4906 | |
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;