musiccaps_details (view)
3 rows where musiccaps_aspects contains "messy" and musiccaps_names contains "Independent music" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- low quality 3
- messy · 3 ✖
- muddy 2
- rock 2
- addictive 1
- arpeggiated piano melody 1
- bad mix 1
- boomy bass 1
- boomy kick 1
- bouncy snare 1
- claps 1
- distorted 1
- emotional 1
- flat double male vocals 1
- groovy 1
- groovy bass guitar 1
- hip hop 1
- melancholic 1
- melancholic male vocal 1
- noisy 1
- punchy kick 1
- punchy snare 1
- shimmering hi hats 1
- smooth bass 1
- soft crash cymbal 1
- soft kick hits 1
- thin 1
- throaty male vocal 1
- wide arpeggiated electric guitar melody 1
- wide electric guitar melody 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Funnel cloud of geese filmed with drone | The low quality recording features a rock song that consists of throaty male vocal singing over widely spread arpeggiated electric guitar melody, smooth bass guitar, punchy snare, shimmering hi hats and soft kick hits. It sounds thin, distorted and messy, since the frequencies are clashing. | 2014-11-26T14:57:06Z | H_3301_W | This is what it looks like to be inside a tornado of geese. The funnel cloud was about 2,800 feet tall. Just hovered and watched them. Drone did not seem to bother them at all. | ["Music", "Independent music"] | ["low quality", "rock", "throaty male vocal", "wide arpeggiated electric guitar melody", "smooth bass", "punchy snare", "shimmering hi hats", "soft kick hits", "messy", "thin", "distorted"] | 4 | F7JllgnefSI | 1615 | |
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;