musiccaps_details (view)
5 rows where musiccaps_aspects contains "live performance", musiccaps_author = 4 and musiccaps_names contains "Drum kit"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- live performance · 5 ✖
- low quality 4
- energetic 3
- noisy 3
- distorted 2
- loud 2
- metal 2
- mono 2
- passionate 2
- punchy snare 2
- aggressive 1
- crushed 1
- energetic cymbals 1
- energetic drums 1
- exotic 1
- flat male vocal 1
- folk 1
- groovy bass 1
- groovy double bass 1
- groovy piano chords 1
- harsh 1
- jazz 1
- joyful 1
- manic drums 1
- manic tom roll 1
- messy 1
- muffled 1
- organ keys chords 1
- passionate male vocal 1
- punchy kick 1
- repetitive cowbell percussion 1
- saxophone solo melody 1
- steel drums melody 1
- upbeat 1
- uptempo 1
- wooden percussions 1
- woodwind melody 1
musiccaps_names (array) 18 ✖
- Drum 5
- Drum kit · 5 ✖
- Music 3
- Percussion 3
- Cowbell 2
- Musical instrument 2
- Rimshot 2
- Bass drum 1
- Bellow 1
- Drum roll 1
- Music of Latin America 1
- Orchestra 1
- Punk rock 1
- Rock music 1
- Singing 1
- Snare drum 1
- Steelpan 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Avenged Sevenfold - Second Heartbeat (Cover) | The low quality recording features a live performance of a metal song. The recording is noisy, in mono and so crushed, distorted, harsh and loud that you can barely hear anything but the loud noise. | 2006-04-06T15:42:42Z | merman2006 | Here is a cover of Second Heartbeat By Avenged Sevenfold performed at the "Last KLCVI Concert" Ricky Bowes - Screams Tim Burak - Drums Steph Barette - Guitar/vocals Scott Merhar - Guitar Shawn Vucko - Bass | ["Singing", "Drum", "Drum kit", "Music", "Punk rock", "Rock music", "Bellow"] | ["low quality", "noisy", "mono", "metal", "crushed", "distorted", "loud", "live performance", "harsh"] | 4 | XjGm3Bn4j5k | 3215 | |
Azerbaijan Music Wedding in Israel - Issey | The low quality recording features a live performance of a folk song that consists of a passionate male vocal singing over groovy bass, woodwind melody, punchy snare and wooden percussion. It sounds joyful, energetic and the recording is noisy. | 2007-08-09T13:31:14Z | IzzIPiano | Keyboard played by Issey | ["Drum", "Drum kit", "Music", "Musical instrument", "Wedding music", "Music of Latin America"] | ["low quality", "folk", "passionate male vocal", "groovy bass", "woodwind melody", "punchy snare", "energetic", "wooden percussions", "live performance", "joyful", "noisy"] | 4 | fiAcNMpd2vM | 3971 | |
Andy Demize Cowbell solo | The low quality recording features a live performance of a metal song that features a flat male vocal talking, repetitive cowbell percussion and manic drums. The recording is loud, messy, distorted, muffled and it sounds aggressive and uptempo. | 2007-11-20T23:16:59Z | HyperFuzz | This was during soundcheck in Detroit 11/18/07 | ["Cowbell", "Drum", "Drum kit", "Drum roll", "Rimshot", "Percussion"] | ["low quality", "uptempo", "metal", "loud", "energetic", "messy", "distorted", "flat male vocal", "manic drums", "repetitive cowbell percussion", "aggressive", "muffled", "live performance"] | 4 | jdEbwMS9xqo | 4269 | |
Shirazette Tinnin - Inner Frustration | The low quality recording features a jazz live performance that consists of saxophone solo melody played over energetic cymbals, manic tom roll, punchy snare and kick hits, organ keys chords, groovy double bass and groovy piano chords. It sounds passionate and upbeat. | 2012-08-16T17:50:49Z | Latin Percussion | Shirazette Tinnin visits the LP studio to perform "Inner Frustration." Drums: Shirazette Tinnin Piano : Willerm Delisfort Piano: Rachel Eckroft Guitar: Seth Johnson Bass: Tom DiCarlo Saxophone: Camille Thurman LP LP204A Black Beauty Cowbell LP204A LP Americana Series Peruvian Cajon LP1439 | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["live performance", "jazz", "saxophone solo melody", "manic tom roll", "energetic cymbals", "punchy snare", "organ keys chords", "groovy double bass", "punchy kick", "groovy piano chords", "passionate", "upbeat"] | 4 | t1ULMDpL35I | 4998 | |
Renegades Steel Orchestra | The low quality recording features a live performance of steel drums, followed by energetic drums in the background. It sounds exotic, passionate, energetic and the recording is noisy and in mono. | 2008-02-16T07:33:29Z | panjumbie | Highest-profile ambassadors for the steel pan music, the Renegades Steel Orchestra from Trinidad & Tobago on European Tour 2007. The Panyard Bern (Switzerland) hosted 3 concerts (10 - 12 July 2007) at http://www.thepanyard.ch These 3 concerts have been sponsored by: pan-jumbie.com, panmusic.ch, panch.ch, funlandserenaders.ch, Richardson Steeldrums, and brewery Feldschlösschen Video production by VJ Peter Krüsi | ["Drum", "Drum kit", "Music", "Musical instrument", "Orchestra", "Percussion", "Steelpan"] | ["low quality", "live performance", "steel drums melody", "energetic drums", "energetic", "exotic", "passionate", "mono", "noisy"] | 4 | x22NHqwKSNE | 5302 |
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;