musiccaps_details (view)
5 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Punk rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- low quality · 5 ✖
- punchy kick · 5 ✖
- energetic 4
- punchy snare 4
- rock 3
- shimmering hi hats 3
- emotional 2
- flat male vocal 2
- groovy 2
- groovy bass 2
- groovy bass guitar 2
- punk 2
- addictive 1
- aggressive 1
- aggressive electric guitar riffs 1
- arpeggiated electric guitar melody 1
- background male vocal 1
- boomy bass guitar 1
- drum sticks countdown 1
- electric guitars melodies 1
- energetic cymbals 1
- exciting 1
- harmonizing male vocals 1
- live performance 1
- mellow 1
- messy 1
- noisy 1
- passionate female vocal 1
- passionate male vocal 1
- shimmering cymbals 1
- shimmering open hats 1
- soft 1
- upbeat 1
- wide electric guitar melody 1
- wide electric guitars 1
musiccaps_names (array) 16 ✖
- Punk rock · 5 ✖
- Music 4
- Rock music 3
- Bass guitar 2
- Progressive rock 2
- Background music 1
- Drum kit 1
- Guitar 1
- Happy music 1
- Heavy metal 1
- Musical instrument 1
- Pop music 1
- Psychedelic rock 1
- Rock and roll 1
- Ska 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fed Up - "So Stupid" | The low quality recording features a punk song that consists of a groovy bass guitar, punchy kick, shimmering hi hats, energetic cymbals and aggressive electric guitar riffs. At the very beginning of the loop, there is a drum stick countdown, after which the bass drops. It sounds energetic, groovy and aggressive. | 2007-05-04T20:57:37Z | f1rstperson | This was the first music video I ever edited and filmed. It is simply awful, but it's fun too look back at the process and realize the things we learn. The band Fed Up was from Kansas City...this song was off their first EP....and they grew to be one of the best punk rock bands around (in my opinion). Check out the other video I did for them 3 years later...called "When Looking Back". | ["Bass guitar", "Heavy metal", "Music", "Punk rock", "Rock music", "Progressive rock"] | ["punk", "low quality", "groovy bass guitar", "punchy snare", "punchy kick", "shimmering hi hats", "energetic cymbals", "aggressive electric guitar riffs", "aggressive", "energetic", "groovy", "drum sticks countdown"] | 4 | ARXTRdKCupM | 1115 | |
Pocket Rocket - See The Problem (Punk Rock Music Video) | The low quality recording features a punk song that contains flat male vocal singing over punchy kick and snare hits, shimmering cymbals, wide electric guitars and groovy bass guitar. It sounds energetic, exciting and upbeat - like something you would jump to at concerts. | 2006-09-22T06:12:51Z | powerswap | The first music video of the aspiring austrian punk-rock-band "Pocket Rocket". | ["Background music", "Music", "Punk rock", "Pop music", "Ska", "Happy music"] | ["punk", "energetic", "exciting", "groovy bass guitar", "wide electric guitars", "shimmering cymbals", "punchy snare", "punchy kick", "flat male vocal", "upbeat", "low quality"] | 4 | pbVYSktQ5jE | 4726 | |
Silent Hill Shattered Memories - Hell Frozen Rain | The low quality recording features a rock song that consists of a passionate female vocal singing over punchy kick and snare hits, shimmering hi hats, wide electric guitar melody and groovy bass guitar. It sounds energetic and addictive in the first half of the loop, while in the second part it's mellow and softer. | 2009-12-17T08:21:09Z | Person Whatname | Artist : Akira Yamaoka Vocals: Mary Elizabeth McGlynn at 3:56, it's "THERE's one that confuses me". thanks to ares5566 for the correction. From Silent Hill Shattered Memories Soundtrack. This song plays during the credits, depends on which ending you get. AWESOME FACT : at 3:34, you can hear part of Silent Hill 1 theme :) | ["Punk rock", "Psychedelic rock", "Rock music", "Song", "Progressive rock"] | ["low quality", "rock", "passionate female vocal", "wide electric guitar melody", "groovy bass", "shimmering hi hats", "punchy kick", "punchy kick", "mellow", "energetic", "addictive", "soft"] | 4 | qrzNABqN420 | 4828 | |
Alkaline Trio - All On Black (Live On Letterman) | The low quality recording features a rock song that consists of a flat male vocal, alongside background male vocals, singing over shimmering hi hats, groovy bass, punchy kick and snare hits and electric guitar melodies. It sounds energetic and emotional. | 2007-06-24T14:06:26Z | AllHopeDeleted | All On Black Performed Live on Letterman from the album 'Good Mourning' http://www.youtube.com/jazzbandrock | ["Drum kit", "Guitar", "Music", "Musical instrument", "Punk rock", "Rock music"] | ["low quality", "rock", "background male vocal", "flat male vocal", "shimmering hi hats", "electric guitars melodies", "groovy bass", "punchy kick", "punchy snare", "emotional", "energetic"] | 4 | yQN9gj7Vk0w | 5408 | |
"11 O'Clock Tick Tock" - Belfast , January 1981 | The low quality recording features a live performance of a rock song and it features passionate male vocals, alongside harmonizing male vocals, singing over arpeggiated electric guitar melody, boomy bass guitar, punchy kick and snare hits and shimmering open hats. It sounds noisy and messy, as the frequencies are clashing with each other, but it is still groovy and emotional regardless. | 2006-04-19T19:19:34Z | u2log | The audience reaction is great in this clip. | ["Bass guitar", "Music", "Punk rock", "Rock and roll"] | ["low quality", "rock", "live performance", "arpeggiated electric guitar melody", "passionate male vocal", "harmonizing male vocals", "boomy bass guitar", "shimmering open hats", "punchy kick", "punchy snare", "messy", "noisy", "groovy", "emotional"] | 4 | zWJC_qr2610 | 5486 |
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;