musiccaps_details (view)
3 rows where musiccaps_aspects contains "muddy" and musiccaps_names contains "Independent music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- muddy · 3 ✖
- low quality 2
- messy 2
- rock 2
- acoustic drums 1
- addictive 1
- arpeggiated piano melody 1
- bad mix 1
- bass guitar 1
- boomy bass 1
- boomy kick 1
- bouncy snare 1
- claps 1
- distorted electric guitar 1
- emotional 1
- flat double male vocals 1
- groovy 1
- groovy bass guitar 1
- grunge 1
- hip hop 1
- loud 1
- male vocal 1
- melancholic 1
- melancholic male vocal 1
- noisy 1
- powerful 1
- punchy kick 1
- rebellious 1
- soft crash cymbal 1
- wide electric guitar melody 1
musiccaps_names (array) 10 ✖
- Independent music · 3 ✖
- Music 3
- Grunge 1
- Heavy metal 1
- Progressive rock 1
- Psychedelic rock 1
- Punk rock 1
- Rhythm and blues 1
- Rock music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Senium - Might as well (Music Video) | This is a grunge rock music piece. A distorted electric guitar playing power chords leads the tune with a bass guitar in the background. Loud acoustic drums provide the rhythmic background while also playing a lot of fills. There is also a male vocal. The music has a rebellious atmosphere mixed with a rough sound that is characteristic of the grunge scene. This piece could be used as a soundtrack in college drama movies/TV series. It could also be used in advertisements targeted at teenagers. | 2013-11-11T22:48:49Z | Senium | #grunge #senium #rock Music video for our opening track off our new album "You're not from here" Directed and edited by: Andrew McNicholas Order on senium1.bandcamp.com Google Music Itunes Spotify | ["Heavy metal", "Music", "Punk rock", "Independent music", "Psychedelic rock", "Rock music", "Progressive rock"] | ["grunge", "rock", "male vocal", "distorted electric guitar", "bass guitar", "acoustic drums", "muddy", "loud", "powerful", "rebellious"] | 9 | 3obJKn19jTE | 504 | |
Kakalimutan Na Kita by Snap, Jhay-Han, Lyreen (420 Music 2015) Ft. Team Independent | The low quality recording features a hip hop song sung with an addictive flow by flat double male vocals over arpeggiated piano melody, boomy, layered bass and kick hits, soft crash cymbal and claps. It sounds muddy and messy as the mix of the song is bad making the frequencies clash with each other - especially in the low end. | 2015-04-28T12:06:35Z | BIÑAN SQUAD SKEPTRON | 1st verse - Snap -https://www.facebook.com/profile.php?id=100008168167035&fref=ufi 2nd and 4th verse - Jhayhan -https://www.facebook.com/jhayhan.abordo14 3rd And Chorus - Lyreen - https://www.facebook.com/lyreen.potss 420 Music 2015 | ["Music", "Independent music", "Rhythm and blues", "Song"] | ["low quality", "hip hop", "arpeggiated piano melody", "boomy kick", "claps", "soft crash cymbal", "flat double male vocals", "boomy bass", "muddy", "messy", "bad mix", "addictive"] | 4 | SG24NL2Xi3A | 2752 | |
Smashing Pumpkins - Whir (Whirl) | The low quality recording features a rock song that consists of melancholic male vocal singing over a wide electric guitar melody, bouncy snare, groovy bass guitar and punchy kick. The recording is noisy, muddy and messy, since the frequencies are clashing with each other - drums cymbals are inaudible. Regardless, it sounds groovy, emotional and melancholic thanks to that vocal. | 2012-04-26T21:13:42Z | xthreenightsx | Demo '92 | ["Music", "Independent music", "Grunge"] | ["low quality", "rock", "wide electric guitar melody", "melancholic male vocal", "bouncy snare", "groovy bass guitar", "noisy", "muddy", "messy", "punchy kick", "melancholic", "emotional", "groovy"] | 4 | aO0QzRPiEC4 | 3533 |
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;