musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic guitar" and musiccaps_names contains "Rimshot" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- acoustic guitar · 2 ✖
- aggressive 1
- bass guitar 1
- digital/acoustic drums 1
- electric guitar 1
- gothic rock 1
- grunt-like singing 1
- hard-hitting 1
- male vocals 1
- male voice samples 1
- medium to uptempo 1
- punk rock 1
- seductive 1
- techno/singer-songwriter 1
musiccaps_names (array) 9 ✖
- Bass drum 2
- Drum 2
- Percussion 2
- Rimshot · 2 ✖
- Snare drum 2
- Cymbal 1
- Drum kit 1
- Drum roll 1
- Hi-hat 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tinashe - Mr. Presumption | A digital kick in playing on every beat along with short voice samples with breathy sounds that sound seductive. Then the song changes into someone fingerpicking an acoustic guitar along to someone playing an acoustic snare/hihat with brushes. This first song may be playing in a club and the second one at a live concert. | 2009-12-02T21:26:27Z | boXd productions | as introduced by 4Music's 'Intros' series - but without the annoying and highly pretentious introduction at the beginning ... | ["Cymbal", "Drum", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["techno/singer-songwriter", "acoustic guitar", "digital/acoustic drums", "male voice samples", "seductive", "medium to uptempo"] | 6 | gjujPd1lP8E | 4050 | |
The Damned - Smash It Up Parts 1 & 2 (Official Audio) | This is a punk rock music piece. There are male vocals singing in a grunt-like manner. The melody is being played by an electric guitar while a bass guitar plays in the background. The rhythm consists of a slightly fast-paced rock acoustic drum beat. The piece has an aggressive atmosphere. It could be used in the soundtrack of an action-filled video game. | 2014-08-19T09:24:23Z | Ace Records | Official audio for Smash It Up Parts 1 & 2 by The Damned, released on Ace Records. Subscribe to the official Ace channel for more classics, lost gems, playlists, and more: http://www.youtube.com/AceRecordsBroadcast http://acerecords.co.uk/machine-gun-etiquette | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["punk rock", "gothic rock", "male vocals", "grunt-like singing", "electric guitar", "bass guitar", "acoustic guitar", "hard-hitting", "aggressive"] | 9 | -FFx68qSAuY | 31 |
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;