musiccaps_details (view)
5 rows where musiccaps_aspects contains "noisy", musiccaps_aspects contains "wide" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- low quality 5
- noisy · 5 ✖
- wide · 5 ✖
- live performance 2
- arpeggiated electric guitar melody 1
- calming 1
- crowd clapping 1
- electric guitar melody solo 1
- folk 1
- groovy double bass 1
- groovy keys chords 1
- harmonica melodies 1
- hydraulophone melody 1
- jazz 1
- mystical 1
- passionate 1
- passionate female vocal 1
- relaxing 1
- reverberant 1
- shimmering hi hats 1
- shoe tapping 1
- simple strings melody 1
- smooth bass 1
- water leaking 1
- weird 1
musiccaps_names (array) 15 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dark Eyes(러시아 민요 - 검은 눈동자) | The low quality recording features a live performance of a folk song and it consists of harmonica melodies played over groovy double bass and shimmering hi-hats. The recording is noisy and fairly wide. | 2009-09-10T17:00:40Z | Choi, Seung-Joon | Modern Harmonica Ensemble(Director: Choi Seung-Joon): the 2nd Regular Concert August 12, 2009 Sejong Chamber Hall, Seoul, Korea 모던 하모니카 앙상블 제2회 정기연주회(모던 하모니카 앙상블과 함께하는 청소년 음악회)2009년 8월 12일 세종문화회관 체임버홀 | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "live performance", "folk", "harmonica melodies", "groovy double bass", "shimmering hi hats", "noisy", "wide"] | 4 | 3Nwsd439zmU | 459 | |
G3 Modeling Sounds vs. Real Guitar Amps - Acoustic Simulator | The low quality recording features widely spread electric guitar melodies. One of the melodies is solo and it is panned to the right channel, while the other one is an arpeggiated electric guitar melody, and it is panned to the left channel of the stereo image. The recording is a bit noisy and weird, since it is a bit too wide, but it also sounds passionate. | 2011-11-18T16:30:02Z | ZoomcorpUK | Demonstration video clips of the G3 by Koichi Korenaga, guitarist/producer. You can listen to line-recorded modeling sounds of the G3 versus sounds of real guitar amps recorded with mics. Follow Zoom UK on Twitter: www.twitter.com/zoomuk | ["Bass guitar", "Echo", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "noisy", "wide", "electric guitar melody solo", "arpeggiated electric guitar melody", "passionate", "weird"] | 4 | 7xD_Ib3VS_w | 891 | |
卡農 | The Low Quality Recording features a widely spread simple strings melody. The recording is a bit noisy. | 2012-10-08T16:16:48Z | 芒果黃金 | ["Harpsichord", "Keyboard (musical)"] | ["low quality", "simple strings melody", "noisy", "wide"] | 4 | gwBfZJ5IGOA | 4067 | ||
Get Happy tap dance | The low quality recording features a live performance of shoe tapping over a jazz song that consists of passionate female vocal singing over smooth bass and groovy key chords. There are crowd clapping sounds in the background. The actual sounds of shoe tappings is widely spread in the stereo image and it is reverberant, as it was probably performed in a huge space. | 2013-01-12T03:29:15Z | jenny seiler | Get Happy | ["Music", "Tap"] | ["live performance", "crowd clapping", "noisy", "shoe tapping", "jazz", "passionate female vocal", "smooth bass", "groovy keys chords", "low quality", "wide", "reverberant"] | 4 | hFqZZrj0rnM | 4089 | |
Hydraulophone in concert | The low quality recording features a hydraulophone melody played alongside water leaking sound. The recording is wide, noisy and it sounds relaxing and calming. | 2007-04-12T01:31:06Z | hydraulist | Suite for Hydraulophone, as performed by Ryan Janzen in the Great Hall, with the Hart House Symphonic Band. This is the world's first orchestral performance in which instruments make sound from all three states of matter (solid, liquid, and gas). Other orchestras use only 2 states of matter: solid (percussion and strings), and gas (wind instruments). For more videos, see www.splashtones.com | ["Music", "Musical instrument", "Orchestra", "Classical music", "Inside, large room or hall"] | ["low quality", "hydraulophone melody", "water leaking", "noisy", "wide", "mystical", "calming", "relaxing"] | 4 | tnJb9WyhCUc | 5066 |
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;