musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "poor mix"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- groovy bass · 3 ✖
- poor mix · 3 ✖
- boomy 2
- low quality 2
- 4 on the floor cowbell pattern 1
- 4 on the floor kick 1
- accordion melody 1
- acoustic rhythm guitar 1
- addictive 1
- blues 1
- claps 1
- country 1
- filtered monotone male vocal 1
- fruity male vocal 1
- fun 1
- groovy 1
- groovy organ keys chords 1
- happy 1
- male chants 1
- muddy 1
- organ keys chords 1
- passionate male vocal 1
- punchy snare 1
- reggae 1
- shimmering cymbals 1
- shimmering hi hats 1
- shimmering shakers 1
- soft crash cymbal 1
- soft kick hits 1
- syncopated snare 1
musiccaps_names (array) 5 ✖
- Music 3
- Grunge 1
- Music of Africa 1
- Salsa music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Movado- Last Night | The low quality recording features a reggae song that consists of a fruity male vocal singing over shimmering hi hats, groovy bass, organ keys, chords, claps and male vocal chants. It sounds addictive, groovy and muddy, due to the poor quality of the mix. | 2007-07-18T18:57:07Z | Andone111 | Movado's Last Night on the Show Off Riddim. | ["Music of Africa", "Music"] | ["reggae", "male chants", "fruity male vocal", "shimmering hi hats", "groovy bass", "organ keys chords", "claps", "low quality", "muddy", "poor mix", "addictive", "groovy"] | 4 | 7pYavsK9sPg | 884 | |
Javier Molina & Eldorado - Cowboy Cumbia (Official Music Video) | The Country song features a passionate male vocalist singing over accordion melody, groovy bass, layered "4 on the floor" kick and cowbell pattern, soft crash cymbal, shimmering shakers and acoustic rhythm guitar. It sounds fun and happy, even though the song is poorly mixed, as it sounds a bit boomy. | 2011-08-01T16:05:34Z | TejanoSA | Javier Molina & Eldorado performing Cowboy Cumbia (Official Music Video) © 1998 Javier Molina | ["Singing", "Music", "Salsa music"] | ["country", "passionate male vocal", "accordion melody", "groovy bass", "4 on the floor cowbell pattern", "acoustic rhythm guitar", "fun", "happy", "4 on the floor kick", "syncopated snare", "soft crash cymbal", "shimmering shakers", "poor mix", "boomy"] | 4 | bLjOJRg2P_Q | 3618 | |
Hellsing Opening (Full Song) | The low quality recording features a blues song that consists of filtered monotone male vocal singing over groovy bass, groovy organ keys, chords, soft kick hits, punchy snare and shimmering cymbals. The song is poorly mixed, as the vocals are not so much in the face as they should be, probably because the bass is eating the other elements - making it sound boomy. | 2008-10-02T19:30:20Z | M00skit0 | Hellsing Op. Full. Yasushi Ishii - Logos naki World | ["Music", "Grunge"] | ["blues", "punchy snare", "groovy bass", "filtered monotone male vocal", "shimmering cymbals", "soft kick hits", "groovy organ keys chords", "boomy", "low quality", "poor mix"] | 4 | d-KxsdWX9xE | 3754 |
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;