musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "exciting" and musiccaps_aspects contains "wide electric guitar melody" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- energetic 3
- exciting · 3 ✖
- shimmering hi hats 3
- wide electric guitar melody · 3 ✖
- groovy bass 2
- low quality 2
- passionate male vocal 2
- punchy kick 2
- punchy snare 2
- rock 2
- claps 1
- energetic crash cymbals 1
- groovy bass guitar 1
- harmonizing background vocals 1
- live performance 1
- people cheering sounds 1
- pop 1
- snare roll 1
musiccaps_names (array) 6 ✖
- Music 2
- Rock music 2
- Music of Asia 1
- Progressive rock 1
- Rock and roll 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ずっと好きだった | The low quality recording features a live performance of a rock song and it consists of a passionate male vocal singing over groovy bass guitar, wide electric guitar melody, shimmering hi hats, punchy kick and snare hits. It sounds energetic and exciting. | 2011-10-08T06:45:59Z | Sheik | ["Singing", "Music", "Rock music", "Rock and roll"] | ["low quality", "rock", "live performance", "passionate male vocal", "wide electric guitar melody", "groovy bass guitar", "shimmering hi hats", "punchy kick", "punchy snare", "energetic", "exciting"] | 4 | InfQUMh935c | 1941 | ||
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 | |
365 Days- Leon Thomas III Ft. Victoria Justice W/Lyrics | The low quality recording features a pop song that consists of a passionate male vocal, alongside harmonizing background vocals, singing over people cheering sounds, shimmering hi hats, claps, snare rolls, groovy bass and wide electric guitar melody. It sounds energetic and exciting. | 2011-10-09T01:46:15Z | stephylove33 | Just in time for October!! Think Pink For Breast Cancer =) XOXO | ["Music of Asia"] | ["low quality", "pop", "harmonizing background vocals", "people cheering sounds", "claps", "shimmering hi hats", "snare roll", "passionate male vocal", "groovy bass", "wide electric guitar melody", "energetic", "exciting"] | 4 | JXS5eW7g4HY | 2016 |
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;