musiccaps_details (view)
2 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "upbeat" and musiccaps_names contains "Rimshot"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- live performance · 2 ✖
- upbeat · 2 ✖
- acoustic drums 1
- bass guitar 1
- electric guitar 1
- energetic cymbals 1
- experimental pop 1
- gloomy 1
- groovy double bass 1
- groovy piano chords 1
- indietronica 1
- jazz 1
- manic tom roll 1
- melancholic 1
- organ keys chords 1
- passionate 1
- punchy kick 1
- punchy snare 1
- repeated theme 1
- saxophone solo melody 1
musiccaps_names (array) 8 ✖
- Bass drum 2
- Drum 2
- Drum kit 2
- Percussion 2
- Rimshot · 2 ✖
- Snare drum 2
- Cowbell 1
- Drum roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
múm - Full Performance (Live on KEXP) | This is the live performance of an indietronica music piece. The melody is being played by the electric guitars and the bass guitar. The rhythmic background consists of a fast tempo acoustic drum beat. The atmosphere is melancholic. This piece could be used in the soundtrack of a drama movie that takes place in a city setting. | 2014-02-28T13:00:04Z | KEXP | http://KEXP.ORG presents múm performing live from KEX Hostel during Iceland Airwaves. Recorded November 2, 2013. Songlist: A Little Bit, Sometimes The Colorful Stabwound Toothwheels One Smile Audio Engineer: Dana Wachs Cameras: Jim Beckmann, Shelly Corbett & Scott Holpainen Editor: Patrick Richardson Wright http://icelandairwaves.is http://mum.is http://kexp.org | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["indietronica", "experimental pop", "live performance", "electric guitar", "repeated theme", "bass guitar", "acoustic drums", "melancholic", "gloomy", "upbeat"] | 9 | ui6ERk-AySw | 5132 |
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;