musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic cymbals" and musiccaps_aspects contains "snare rolls" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- energetic cymbals · 2 ✖
- low quality 2
- snare rolls · 2 ✖
- distant trumpet melody 1
- energetic 1
- energetic muffled drums 1
- filtered echoing flat male vocal 1
- groovy bass 1
- loud 1
- manic 1
- manic metallic percussions 1
- mono 1
- muffled 1
- noisy 1
- rock 1
- uptempo electric guitar melody 1
musiccaps_names (array) 9 ✖
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Music 1
- Percussion 1
- Rimshot 1
- Roll 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Banda Aires Del Pacifico | The low quality recording features a live performance of distant trumpet melody, followed by energetic cymbals, snare roll and manically played metallic percussion. It sounds energetic and loud, while the recording is noisy and in mono, as it was probably recorded with a phone. | 2009-08-19T06:13:20Z | Labazuuka | el pony tocando tarolas jeje ....salsa pss al 100 | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "distant trumpet melody", "manic metallic percussions", "energetic cymbals", "snare rolls", "energetic", "loud", "noisy", "mono"] | 4 | 7lV4IvuW2lk | 881 | |
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;