musiccaps_details (view)
3 rows where "youtube_published" is on date 2015-07-20 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- ambient nature sound 1
- ambient nature sounds 1
- audio tracks super imposed on each other 1
- blades turning 1
- breeze 1
- bright synth 1
- classical 1
- electric saw 1
- emotional 1
- engine whirring 1
- fast finger snapping 1
- gardening machinery sounds 1
- home video 1
- instrumental 1
- j-pop 1
- japanese music 1
- keyboard melody 1
- live performance 1
- live recording 1
- loud ambient sounds 1
- low quality 1
- passionate 1
- passionate dynamic classical piano melody 1
- pleasant music 1
- reverberant 1
- sound of water 1
- squishy sounds 1
- subdued background song 1
- upbeat japanese pop dance music 1
- wind blowing 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Firewood chainsaw processing on chainsaw bench Malkas zāģis | The song is an instrumental. The song is medium tempo with a cool groove being played on a keyboard. The ambient sounds are that of a gardening hardware tool being conked into starting with wind noise and gravel crunching tones. The song is being played as background music for the home video. The audio quality is harsh and not pleasant to hear. | 2015-07-20T11:10:52Z | runcio21 | Firewood chainsaw, Malkas zāģis | ["Chainsaw", "Music"] | ["instrumental", "subdued background song", "keyboard melody", "pleasant music", "loud ambient sounds", "audio tracks super imposed on each other", "ambient nature sounds", "squishy sounds", "sound of water", "gardening machinery sounds", "engine whirring", "blades turning", "electric saw", "ambient nature sound", "wind blowing", "breeze", "home video"] | 7 | TIL8jEw8pSc | 2829 | |
G. Bottesini - Introduzione Tema e Variazioni sul 'Carnevale di Venezia' | The low quality recording features a live performance of a passionately and dynamically played classical piano melody. It is quite reverberant, as it was probably recorded in some concert hall. It also sounds emotional and passionate, even though the sound is not perfect. | 2015-07-20T05:40:20Z | Yong-Woo, Cho (조용우) | 15.07.2015 in Recital Hall (Seoul Arts Center) in Korea in 예술의전당 리사이틀홀 귀국독주회 中... | ["Music", "Musical instrument", "Classical music"] | ["low quality", "live performance", "classical", "passionate dynamic classical piano melody", "reverberant", "emotional", "passionate"] | 4 | UWl99yJsb8M | 2922 | |
指パッチンで太鼓の達人エンジェルドリームを再現 | The performer is snapping his fingers in rhythm with the upbeat japanese music playing in the background. The song is a j-pop song and features vibrant rhythmic synth activity and has a general dance feel to it. It's a live recording. | 2015-07-20T06:17:38Z | りゅうくんの工房 | 指パッチンで太鼓の達人エンジェルドリームを再現 ↓シリーズもの ナイトオブナイツ https://youtu.be/FSt9CT0csxM | ["Finger snapping", "Music"] | ["fast finger snapping", "upbeat japanese pop dance music", "j-pop", "japanese music", "bright synth", "live recording"] | 3 | z7vNtEcM9Bk | 5458 |
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;