musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "harsh" and musiccaps_aspects contains "messy" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 33 ✖
- harsh · 4 ✖
- low quality 4
- messy · 4 ✖
- energetic 3
- distorted 2
- distorted bass guitar 2
- punchy kick 2
- punchy snare 2
- rock 2
- addictive 1
- addictive female vocal 1
- aggressive drum cymbals 1
- aggressive electric guitar melody 1
- distorted electric guitar chords 1
- electric guitar melody 1
- electric guitar slide 1
- flat male vocal 1
- groovy bass 1
- live performance 1
- loud 1
- metal 1
- muddy 1
- muffled kick 1
- muffled snare 1
- passionate 1
- playback 1
- shimmering cymbals 1
- snare roll 1
- string melody 1
- traditional pop 1
- volume ducking 1
- wide electric guitar chords 1
- wooden percussions 1
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
When We Team Up - 5,000 Candles In The Wind | The low quality recording features a rock song that consists of wide electric guitar chords, punchy kick and snare, electric guitar slide, distorted bass guitar, aggressive drums cymbals and flat male vocals singing over it. It sounds energetic, but also harsh and messy thanks to those cymbals. | 2013-01-01T17:33:25Z | WhenWeTeamUp | Hey everyone, we are a Pacific Northwest Pop Punk band called When We Team Up. This is the first track off of our debut Ep " Not For Me, But For My Friends" that comes out on January 22nd of 2013. Head over to Facebook.com/WhenWeTeamUp and like us if you like what you hear!!! | ["Heavy metal", "Music", "Rustling leaves"] | ["rock", "energetic", "low quality", "wide electric guitar chords", "aggressive drum cymbals", "punchy kick", "punchy snare", "electric guitar slide", "distorted bass guitar", "flat male vocal", "harsh", "messy"] | 4 | 7jWRIjFaoeU | 875 | |
E__V___O & I Hm I Pking vid | The low quality recording features a metal song that consists of aggressive electric guitar melody, distorted bass guitar, shimmering cymbals and muffled kick and snare hits. It sounds energetic, but also harsh, messy, distorted, muddy and loud, since the frequencies are clashing with each other. The volume of the song is dwindling occasionally, making it a really low quality sounding track. | 2007-03-24T22:59:44Z | evothepker | E__V___O & I Hm I presents duo video, includes crazy hits =D edited by evo. | ["Music", "Angry music"] | ["volume ducking", "aggressive electric guitar melody", "distorted bass guitar", "shimmering cymbals", "muffled kick", "muffled snare", "metal", "low quality", "harsh", "messy", "distorted", "muddy", "loud", "energetic"] | 4 | afb7pI_01O4 | 3567 | |
Fatima Tuz Zahra Oyshee-De De pal Tule de - Live on RTV MUSIC STATION | The low quality recording features a live performance of a traditional pop song and it consists of an addictive female vocal singing over punchy kick and snare hits, groovy bass, electric guitar melody, strings melody and wooden percussion. There is a short snare roll, right before the bass drops. It sounds messy, a bit harsh, distorted, but also passionate, addictive and energetic. | 2015-11-15T15:01:18Z | Oyshee Express | Singer- Fatima Tuz zahra Oyshee Lyric & Tune: Abdur Rahman Boyati Produced by Khoshru Anchored by Liza Bass Guitar- Sohel Rana Flute: Kamrul Lead Guitar: Roman Keyboard: Nadim Pad: Sakib Percussion: Ujjol | ["Music of Asia", "Music", "Salsa music"] | ["live performance", "low quality", "traditional pop", "addictive female vocal", "punchy snare", "wooden percussions", "snare roll", "groovy bass", "string melody", "electric guitar melody", "punchy kick", "messy", "distorted", "harsh", "passionate", "addictive", "energetic"] | 4 | eISYX9koocM | 3855 | |
Dani California cover | The low quality recording features distorted electric guitar chords playing over rock songs played on playback. It sounds messy and harsh, as the frequencies of the room and the actual sound of the guitar and song are clashing with each other. | 2006-05-01T21:34:48Z | geraci89 | just me playing along to my favourite song on the radio right now by my favourite band:):) enjoy! | ["Guitar", "Music", "Musical instrument", "Rock music", "Progressive rock", "Plucked string instrument"] | ["low quality", "distorted electric guitar chords", "playback", "harsh", "messy", "rock"] | 4 | m8poFnEbvW8 | 4447 |
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;