musiccaps_details (view)
2 rows where musiccaps_aspects contains "blues" and musiccaps_names contains "Grunge"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
musiccaps_names (array) 4 ✖
- Grunge · 2 ✖
- Music 2
- Progressive rock 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Peter Driessen A SHARPER TWANG Leather, Steel And Nylons | The song has a bluesy funk feel to it. The singer has a raspy and burly vocal and sits on top of a grungy gritty electric guitar. | 2007-12-29T17:57:07Z | bluesguitarwizard | CD 'A SHARPER TWANG' 'Leather Steel And Nylons' is the second number. | ["Music", "Rock music", "Progressive rock", "Grunge"] | ["funky guitar playing", "bluesy guitar playing", "burly raspy male vocal", "blues", "funk", "grungy electric guitar", "simple drumming"] | 3 | YKQMolFL2Rs | 3276 | |
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;