musiccaps_details (view)
2 rows where musiccaps_aspects contains "live performance" and musiccaps_aspects contains "wide" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- live performance · 2 ✖
- low quality 2
- noisy 2
- wide · 2 ✖
- crowd clapping 1
- folk 1
- groovy double bass 1
- groovy keys chords 1
- harmonica melodies 1
- jazz 1
- passionate female vocal 1
- reverberant 1
- shimmering hi hats 1
- shoe tapping 1
- smooth bass 1
musiccaps_names (array) 4 ✖
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 | |
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 |
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;