musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "distorted bass guitar", musiccaps_aspects contains "harsh" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- distorted bass guitar · 2 ✖
- energetic 2
- harsh · 2 ✖
- low quality 2
- messy 2
- aggressive drum cymbals 1
- aggressive electric guitar melody 1
- distorted 1
- electric guitar slide 1
- flat male vocal 1
- loud 1
- metal 1
- muddy 1
- muffled kick 1
- muffled snare 1
- punchy kick 1
- punchy snare 1
- rock 1
- shimmering cymbals 1
- volume ducking 1
- wide electric guitar chords 1
musiccaps_names (array) 4 ✖
- Music 2
- Angry music 1
- Heavy metal 1
- Rustling leaves 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
When We Team Up - 5,000 Candles In The Wind | The low quality recording features a rock song that consists of wide electric guitar chords, punchy kick and snare, electric guitar slide, distorted bass guitar, aggressive drums cymbals and flat male vocals singing over it. It sounds energetic, but also harsh and messy thanks to those cymbals. | 2013-01-01T17:33:25Z | WhenWeTeamUp | Hey everyone, we are a Pacific Northwest Pop Punk band called When We Team Up. This is the first track off of our debut Ep " Not For Me, But For My Friends" that comes out on January 22nd of 2013. Head over to Facebook.com/WhenWeTeamUp and like us if you like what you hear!!! | ["Heavy metal", "Music", "Rustling leaves"] | ["rock", "energetic", "low quality", "wide electric guitar chords", "aggressive drum cymbals", "punchy kick", "punchy snare", "electric guitar slide", "distorted bass guitar", "flat male vocal", "harsh", "messy"] | 4 | 7jWRIjFaoeU | 875 | |
E__V___O & I Hm I Pking vid | The low quality recording features a metal song that consists of aggressive electric guitar melody, distorted bass guitar, shimmering cymbals and muffled kick and snare hits. It sounds energetic, but also harsh, messy, distorted, muddy and loud, since the frequencies are clashing with each other. The volume of the song is dwindling occasionally, making it a really low quality sounding track. | 2007-03-24T22:59:44Z | evothepker | E__V___O & I Hm I presents duo video, includes crazy hits =D edited by evo. | ["Music", "Angry music"] | ["volume ducking", "aggressive electric guitar melody", "distorted bass guitar", "shimmering cymbals", "muffled kick", "muffled snare", "metal", "low quality", "harsh", "messy", "distorted", "muddy", "loud", "energetic"] | 4 | afb7pI_01O4 | 3567 |
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;