musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "harsh" and musiccaps_aspects contains "muddy" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 20 ✖
- harsh · 2 ✖
- low quality 2
- muddy · 2 ✖
- aggressive electric guitar melody 1
- distorted 1
- distorted bass guitar 1
- energetic 1
- folk 1
- groovy acoustic guitar melody 1
- loud 1
- messy 1
- metal 1
- muffled kick 1
- muffled snare 1
- passionate male vocal 1
- reverberant 1
- shimmering cymbals 1
- unbalanced stereo image 1
- uplifting 1
- volume ducking 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nicholas Barron - Devil Dog - www.candyrat.com | The low quality recording features a folk song being covered by passionate male vocal and groovy acoustic guitar melody. It sounds uplifting and a bit harsh, muddy and unbalanced as far as the stereo image goes. | 2007-05-22T22:38:12Z | Candyrat Records | CD - AS I AM - http://www.candyrat.com Nicholas Barron http://www.nicholasbarron.com/ | ["Singing", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "passionate male vocal", "groovy acoustic guitar melody", "reverberant", "folk", "uplifting", "unbalanced stereo image", "harsh", "muddy"] | 4 | _RLsXrr0fQo | 3468 | |
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;