musiccaps_details (view)
4 rows where musiccaps_aspects contains "chaotic" and musiccaps_aspects contains "groovy bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- chaotic · 4 ✖
- groovy bass · 4 ✖
- low quality 3
- flat male vocal 2
- acustic guitar 1
- bass guitar 1
- blues 1
- boomy 1
- brass melody 1
- confusing 1
- dissonant strings 1
- dub 1
- energetic 1
- energetic drums 1
- fast tempo 1
- groovy bass lines 1
- groovy piano 1
- intense 1
- jazz 1
- keyboard harmony 1
- live performance 1
- lively drumming 1
- loud 1
- male vocalist 1
- manic 1
- messy 1
- muddy 1
- noisy 1
- offbeat guitar melody 1
- punchy snare 1
- repetitive organ keys chords 1
- rock 1
- shimmering cymbals 1
- shimmering hi hats 1
- soft kick 1
- soft kick hits 1
- soft snare 1
- steady drumming 1
- superimposed syncopated strings 1
- syncopated music 1
- two tracks playing 1
- ukele 1
- unrelated tracks 1
- woodwinds melody 1
musiccaps_names (array) 12 ✖
- Music 3
- Brass instrument 1
- Clarinet 1
- Country 1
- Music of Latin America 1
- Psychedelic rock 1
- Punk rock 1
- Rock and roll 1
- Saxophone 1
- Song 1
- Trombone 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Skip & The Creations - Harlem Shuffle | The low quality recording features a rock song that consists of flat male vocal singing over punchy snare, soft kick hits, repetitive organ keys chords, shimmering hi hats and groovy bass. It sounds messy, loud, muddy and chaotic, since the frequencies are clashing with each other due to a bad mix. | 2010-06-21T19:30:48Z | Anhalter Udo | This version of "Harlem Shuffle" is relative unknown - but for me the best what I've heard ( sorry Stones Fans ). The song is on Skip & The Creation Alb. "Mobab" (Orig. 1966) & also on Sampler "The Best Of Justice Records" This powerful band was from Virginia. | ["Country", "Music", "Punk rock", "Psychedelic rock", "Song", "Rock and roll"] | ["low quality", "muddy", "messy", "rock", "flat male vocal", "punchy snare", "groovy bass", "repetitive organ keys chords", "soft kick hits", "shimmering hi hats", "chaotic", "loud"] | 4 | Bgsy5UpXx8I | 1275 | |
Sud Sound System@Villa Ada - feat. Maria Ganja | The low quality recording features a live performance of dub song manically rapped by flat male vocals, followed by energetic drums, groovy bass and offbeat key chords. The recording is noisy and chaotic a bit, as it is probably recorded with a phone. | 2007-07-25T12:28:57Z | Ivano Zizzi | grande performance! Sud sound systema a "Roma Incontra il mondo" VILLA ADA. Nuh se po proibire & erba erba | ["Music", "Music of Latin America"] | ["low quality", "dub", "noisy", "live performance", "energetic", "offbeat guitar melody", "energetic drums", "flat male vocal", "chaotic", "groovy bass"] | 4 | JN_VJCJhC4Y | 1996 | |
Partitura Brasileirinho samba jazz solo e improviso, flauta e trombone. | The low quality recording features shimmering cymbals, brass melody, woodwinds melody, groovy piano, groovy bass and soft kick and snare hits played altogether. It sounds chaotic and manic. | 2014-02-04T21:14:11Z | jeferson ramos | ["Brass instrument", "Clarinet", "Saxophone", "Trombone"] | ["low quality", "shimmering cymbals", "brass melody", "woodwinds melody", "groovy piano", "groovy bass", "soft kick", "soft snare", "manic", "chaotic"] | 4 | KLFoZA8btu4 | 2075 | ||
The Ukulele Orchestra - Wuthering Heights | A male vocalist sings this melodic jazz/blues. The tempo is medium fast with a piano accompaniment, groovy bass lines, infectious drumming and guitar accompaniment. There is a sound of syncopated ukulele and another string instrument playing over the song. The song is melodic and ambient but the superimposed strings melody is making it chaotic, busy, confusing and confusing. | 2007-02-12T00:31:35Z | daviie | The Ukulele Orchestra - Wuthering Heights | ["Music", "Ukulele"] | ["male vocalist", "fast tempo", "jazz", "blues", "dissonant strings", "groovy bass", "steady drumming", "intense", "keyboard harmony", "lively drumming", "superimposed syncopated strings", "syncopated music", "groovy bass lines", "two tracks playing", "unrelated tracks", "chaotic", "confusing", "ukele", "acustic guitar", "bass guitar", "boomy"] | 7 | KmBaE7ozWow | 2117 |
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;