musiccaps_details (view)
2 rows where musiccaps_aspects contains "muffled" and musiccaps_aspects contains "snare rolls" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- low quality 2
- muffled · 2 ✖
- snare rolls · 2 ✖
- dull 1
- energetic cymbals 1
- energetic muffled drums 1
- filtered echoing flat male vocal 1
- fun 1
- groovy bass 1
- happy 1
- manic 1
- quiet 1
- rock 1
- simple bass 1
- synth keys melody 1
- uptempo electric guitar melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
BOLERO fantasy [ Music: Maurice Ravel - Bolero / 10 min. version ] | The low quality recording features a synth key melody played over simple bass and snare rolls. It sounds happy and fun, while the recording is quiet, dull and muffled. | 2008-11-23T10:19:12Z | M. Laurens Bullstar | BOLERO-FANTASY 10min version [Music: Maurice Ravel - Bolero] | ["Music", "Sad music"] | ["low quality", "muffled", "snare rolls", "synth keys melody", "simple bass", "dull", "happy", "fun", "quiet"] | 4 | HOkuea1wExA | 1798 | |
The Toy Dolls - PC Stoker | The low quality recording features a rock song that consists of filtered echoing flat male vocals, energetic muffled drums, energetic cymbals, snare rolls, uptempo electric guitar melody and groovy bass. It sounds manic and muffled, like it lacks the bass and overall frequency balance. | 2007-11-01T06:29:55Z | MBSS20 | Check out some punk gear: https://www.occultpunkshirts.com/one-offs.html The Toy Dolls Video of PC Stoker 1986 Promo. | ["Music", "Roll"] | ["low quality", "rock", "filtered echoing flat male vocal", "energetic muffled drums", "energetic cymbals", "snare rolls", "manic", "uptempo electric guitar melody", "groovy bass", "muffled"] | 4 | bpwO0lbJPF4 | 3655 |
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;