musiccaps_details (view)
2 rows where musiccaps_aspects contains "muffled kick" and musiccaps_author = 4 sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- low quality 2
- muffled kick · 2 ✖
- muffled snare 2
- aggressive electric guitar melody 1
- busy line sound effect 1
- distorted 1
- distorted bass guitar 1
- energetic 1
- generic 1
- harsh 1
- loud 1
- loud gliding synth bass 1
- messy 1
- metal 1
- muddy 1
- shimmering cymbals 1
- shimmering ride 1
- tinny hi hats 1
- video game song 1
- volume ducking 1
musiccaps_names (array) 5 ✖
- Music 2
- Angry music 1
- Drum machine 1
- Sampler 1
- Synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Telephone | The low quality recording features a loud, gliding synth bass, muffled snare and kick hits, tinny hi hats and shimmering ride cymbals. There is a busy line sound effect and its rhythm is offbeat relative to the song. It sounds generic - like a song from a video game. | 2010-10-30T05:21:53Z | pigmhall | Animation of telephone and girl | ["Sampler", "Music", "Drum machine", "Synthesizer"] | ["busy line sound effect", "muffled snare", "shimmering ride", "tinny hi hats", "loud gliding synth bass", "generic", "video game song", "low quality", "muffled kick"] | 4 | qtnE1hnCD0M | 4832 |
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;