musiccaps_details (view)
4 rows where musiccaps_aspects contains "intimate" and musiccaps_author = 4 sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- intimate · 4 ✖
- low quality 3
- passionate 3
- live performance 2
- noisy 2
- addictive 1
- emotional 1
- fade out 1
- groovy bass 1
- groovy double bass 1
- groovy wooden percussions 1
- inhale sound 1
- jazz 1
- mystical 1
- passionate female vocal 1
- pop 1
- reverberant breathy flute melody 1
- shimmering hi hats 1
- shimmering shakers 1
- trombone solo 1
- warm 1
- wide electric guitar melodies 1
- wooden impact 1
musiccaps_names (array) 8 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bobby Previte's TERMINAL 4 - So Percussion and Bobby Previte | The low quality recording features a live performance of groovy wooden percussion. There is a wooden impact in the form of a wooden stick falling on the floor - which is a part of the groove. The recording is a bit noisy, due to a ventilation system, which also makes it very intimate. | 2011-04-27T19:30:54Z | Bobby Previte | If you can't watch it all, check out 21:30...and the "special guest" at the end... from TERMINALS: PART 1 - DEPARTURES Five Concertos for Percussion Ensemble and Soloist composed by Bobby Previte featuring So Percussion - Eric Beach, Josh Quillen, Adam Sliwinski, and Jason Treuting and guest soloist Bobby Previte, drums. Recorded from the live world premiere, March 28, 2011 at The Ecstatic Music Festival as part of WNYC's New Sounds Live series produced by John Schaefer, recorded for broadcast by Ed Haber at WNYC. Video shot by Arrien Zinghini Audio and video mixed and edited by Bobby Previte | ["Wood block", "Percussion"] | ["low quality", "live performance", "groovy wooden percussions", "wooden impact", "noisy", "intimate"] | 4 | 7DIPyJB4osY | 819 | |
Jazz Cimbasso - Donna Lee, WDR Big Band featuring Mattis Cederberg | The low quality recording features a live performance of a jazz song and it consists of groovy double bass, trombone solo and shimmering hi-hats. The recording is a bit noisy and it sounds warm, intimate and passionate. | 2012-01-20T22:52:27Z | cimbassonista | Here's an arrangement of Donna Lee by Michael Philip Mossman. The WDR Big Band featuring me on cimbasso. As always, I play the HAAG cimbasso. | ["Brass instrument", "Trombone"] | ["low quality", "noisy", "intimate", "live performance", "jazz", "trombone solo", "groovy double bass", "shimmering hi hats", "passionate", "warm"] | 4 | p1DNl8BF49U | 4677 | |
Nasty Girl by Destiny's Child | The Pop song features a passionate female vocal singing over groovy bass, wide electric guitar melodies and shimmering shakers, as the overall audio is slowly fading out. It sounds addictive, passionate and intimate. | 2007-04-15T07:50:17Z | Bubblez1636 | Destiny's Child's song, Nasty Girl, with a compilation of video footage they made AFTERWARDS. Funny | ["Singing", "Funk"] | ["pop", "passionate female vocal", "groovy bass", "wide electric guitar melodies", "shimmering shakers", "fade out", "addictive", "passionate", "intimate"] | 4 | C-7ubPOCeJk | 1314 | |
笛演奏 「田舎笛と空笛」 ~伝統音楽デジタルライブラリー | The low quality recording features a reverberant breathy flute melody with an inhale sound in-between. It sounds mystical, passionate and emotional. | 2009-05-01T09:21:47Z | senzoku-online | 笛の演奏 | ["Wind instrument, woodwind instrument", "Flute"] | ["reverberant breathy flute melody", "inhale sound", "low quality", "intimate", "mystical", "passionate", "emotional"] | 4 | 0u5-WiBKam8 | 221 |
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;