musiccaps_details (view)
2 rows where musiccaps_aspects contains "soft kick hits", musiccaps_names contains "Grunge" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- low quality 2
- soft kick hits · 2 ✖
- acoustic rhythm guitar 1
- addictive 1
- blues 1
- boomy 1
- bouncy snare hits 1
- electric rhythm guitar melody 1
- energetic 1
- filtered monotone male vocal 1
- groovy bass 1
- groovy bass guitar 1
- groovy organ keys chords 1
- harmonizing background vocals 1
- passionate male vocal 1
- poor mix 1
- punchy snare 1
- rock 1
- shimmering cymbals 1
- shimmering wide cymbals 1
- wide toms roll 1
musiccaps_names (array) 4 ✖
- Grunge · 2 ✖
- Music · 2 ✖
- Punk rock 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Crags - Please, Sniff The Air (Official) | The low quality recording features a rock song that consists passionate male vocal, alongside, harmonizing background vocals, singing over shimmering wide cymbals, bouncy snare hits, soft kick hits, electric rhythm guitar melody in the left channel, groovy bass guitar, acoustic rhythm guitar in the right channel of the stereo image and some wide toms roll. It sounds addictive and energetic. | 2015-08-24T07:36:04Z | Mathieu Epiney | Please, Sniff The Air by The Crags © 2015 www.thecrags.ch https://www.facebook.com/thecragsmusic Music Video by EPIDEMIC music video epidemic.ch epidemicmusicvideos@gmail.com Recorded & Mixed by Claude Lander @ Taurus Studio | ["Music", "Punk rock", "Grunge", "Soul music"] | ["low quality", "rock", "passionate male vocal", "harmonizing background vocals", "shimmering wide cymbals", "bouncy snare hits", "soft kick hits", "electric rhythm guitar melody", "groovy bass guitar", "wide toms roll", "addictive", "energetic", "acoustic rhythm guitar"] | 4 | U-UF93NA3ko | 2881 | |
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;