musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "energetic", musiccaps_aspects contains "mono" and musiccaps_aspects contains "noisy"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- energetic · 4 ✖
- low quality 4
- mono · 4 ✖
- noisy · 4 ✖
- live performance 3
- punchy snare 3
- groovy bass 2
- passionate 2
- punchy kick 2
- aggressive 1
- aggressive electric guitar riffs 1
- banjo solo melody 1
- blues 1
- buzzy 1
- country 1
- crowd cheering 1
- distorted 1
- distorted bass 1
- distorted bass guitar 1
- electric guitar chords 1
- electric guitar melody 1
- electric guitar solo melody 1
- energetic cymbals 1
- energetic drums 1
- energetic female vocal 1
- hard rock 1
- harmonica solo melody 1
- messy 1
- muffled 1
- rock 1
- …
musiccaps_names (array) 12 ✖
youtube_published (date) 4 ✖
- 2006-10-04 1
- 2007-09-01 1
- 2007-12-02 1
- 2012-03-29 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
I Love Rock'n Roll - Anna-Maria Zimmermann | The low quality recording features a live performance of a rock song that consists of an energetic female vocal singing over electric guitar chords, punchy snare and kick hits and distorted bass guitar. The recording is very noisy and buzzy, in mono, muffled and messy, as it was probably recorded with a phone. It still sounds energetic. | 2007-12-02T10:34:45Z | Leni281 | Anna-Maria Zimmermann (von DSDS 2006) singt "I Love Rock'n Roll" Livemitschnitt vom Nevio Konzert vom 09.04.06 in Hirschaid | ["Singing", "Music", "Rock music", "Roll"] | ["low quality", "buzzy", "noisy", "rock", "mono", "energetic", "muffled", "messy", "distorted", "live performance", "punchy kick", "punchy snare", "distorted bass", "energetic female vocal", "electric guitar chords"] | 4 | 7Mv4eKPe850 | 838 | |
Almafuerte -Pepsi Music 2005- Tu eres su seguridad | The low quality recording features a live performance of a hard rock song that consists of punchy kick and snare hits, energetic cymbals, distorted bass guitar and aggressive electric guitar riffs. There are some crowd cheering sounds in the background. It sounds energetic, aggressive and the recording is noisy and in mono. | 2007-09-01T07:42:30Z | Metal-Argento | Almafuerte en el Pepsi Music, el dia que toco Megadeth (09-10-05) http://www.metal-argentino.com.ar | ["Music", "Exciting music"] | ["low quality", "noisy", "mono", "crowd cheering", "energetic", "aggressive", "punchy snare", "punchy kick", "aggressive electric guitar riffs", "energetic cymbals", "distorted bass guitar", "hard rock"] | 4 | Vo6eT8eMMfQ | 3032 | |
EARL SCRUGGS & STEVE MARTIN - DUELING BANJOS-EARLSCRUGGS DEAD AT 88-WEB-GIFTS.COM | The low quality recording features a live performance of a country song and it consists of banjo solo melody and electric guitar melody going back and forth, energetic drums, groovy bass and sustained strings melody playing in the background. The recording is noisy and in mono, and it sounds energetic and passionate. | 2012-03-29T13:51:03Z | TINKER2ELVIS | Scruggs died Wednesday morning at age 88 of natural causes. The legacy he helped build with bandleader Bill Monroe, guitarist Lester Flatt and the rest of the Blue Grass Boys was evident all around Nashville, where he died in an area hospital. His string-bending, mind-blowing way of picking helped transform a regional sound into a national passion. "It's not just bluegrass, it's American music," bluegrass fan turned country star Dierks Bentley said. "There's 17- or 18-year-old kids turning on today's country music and hearing that banjo and they have no idea where that came from. That sound has probably always been there for them and they don't realize someone invented that three-finger roll style of playing. You hear it everywhere | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["low quality", "mono", "noisy", "live performance", "banjo solo melody", "electric guitar solo melody", "energetic drums", "groovy bass", "sustained string melody", "energetic", "passionate", "country", "uptempo"] | 4 | nqd7mXvHupU | 4581 | |
Steve Miller mercury blues norton buffalo harmonica solo | The low quality recording features a live performance of blues songs and it consists of a harmonica solo melody played over groovy bass, punchy snare, shimmering cymbals and electric guitar melody. As it was recorded with a phone, there are some whistling crowd noises, aside from the fact that the recording is in mono and noisy. It still sounds energetic and passionate. | 2006-10-04T03:46:37Z | Sunshine Day | part of song with awesome harmonica solo by norton | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "whistling sound", "mono", "noisy", "harmonica solo melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "live performance", "blues", "passionate", "energetic"] | 4 | ovomUNSo_uo | 4666 |
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;