musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass guitar", musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Grunge"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- groovy bass guitar · 3 ✖
- punchy kick · 3 ✖
- rock 3
- emotional 2
- groovy 2
- low quality 2
- melancholic male vocal 2
- punchy snare 2
- acoustic rhythm guitar 1
- addictive 1
- bouncy snare 1
- electric guitar mellow feedback 1
- heartfelt 1
- instrumental 1
- melancholic 1
- messy 1
- muddy 1
- noisy 1
- passionate 1
- passionate electric guitar solo melody 1
- shimmering hi hats 1
- shimmering ride cymbals 1
- wide electric guitar melody 1
- wooden bouncy percussion 1
musiccaps_names (array) 4 ✖
- Grunge · 3 ✖
- Music 3
- Independent music 2
- Progressive rock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mais häckseln / Corn chopping | #landwirt100k | The Rock instrumental features a passionate electric guitar solo melody played over punchy kick and snare hits, shimmering hi hats, groovy bass guitar, wooden bouncy percussion and electric guitar, mellow feedback, located in the left channel of the stereo image. It sounds groovy, addictive and passionate, thanks to that solo melody. | 2015-10-06T20:27:24Z | Franz Gosch | Fendt 310 Vario Fendt 716 Vario TMS + Kemper Champion 3000 Fendt 309 Vario TMS Steyr 768A Valtra N103.4 H5 | ["Music", "Grunge"] | ["rock", "instrumental", "groovy bass guitar", "passionate electric guitar solo melody", "punchy kick", "punchy snare", "wooden bouncy percussion", "shimmering hi hats", "electric guitar mellow feedback", "groovy", "addictive", "passionate"] | 4 | I4Jp0kB2Ns0 | 1870 | |
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 | |
Kurt Cobain-Half The Man I Used To Be | The low quality recording features a rock song that consists of a melancholic male vocal singing over punchy kick and snare hits, shimmering ride cymbals, groovy bass guitar and acoustic rhythm guitar. It sounds emotional and heartfelt. | 2007-05-01T17:41:40Z | crkuhifan | half the man i used to be song with nirvana's leader kurt cobain | ["Music", "Independent music", "Progressive rock", "Grunge"] | ["low quality", "rock", "melancholic male vocal", "punchy snare", "shimmering ride cymbals", "punchy kick", "groovy bass guitar", "acoustic rhythm guitar", "emotional", "heartfelt"] | 4 | nvRd4xgEWbw | 4591 |
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;