musiccaps_details (view)
3 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2012-04-16
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- ambient naturesounds 1
- breezy 1
- crowd singing 1
- digital drum 1
- electronic music 1
- emotional 1
- instrumental 1
- live performance 1
- live recording 1
- low quality 1
- low quality audio 1
- medium fast tempo 1
- mellow piano chords 1
- muffled sounds 1
- outdoor 1
- passionate 1
- poor audio quality 1
- pop 1
- reverberant soft male vocal 1
- rustling 1
- soulful 1
- synthesiser arrangement 1
- untintelligible human vocal sounds 1
- windy 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1991 Integra DA rattle can paintjob walkaround | This music is an Electronic instrumental. The tempo is medium with synthesiser articulation and drum machine arrangement. The music is muffled as the audio is of poor quality and the recording is done outdoors. There are ambient nature sounds in the background like the wind and some rustling. | 2012-04-16T20:15:08Z | ecotectech | 1991 Integra DA fresh rattle can paint job. | ["Music", "Rattle"] | ["instrumental", "medium fast tempo", "poor audio quality", "muffled sounds", "electronic music", "digital drum", "synthesiser arrangement", "outdoor", "ambient naturesounds", "windy", "breezy", "rustling"] | 7 | AuZNuyR2OJs | 1182 | |
Han Kyung-il - Sad invitation, 한경일 - 슬픈 초대장, Music Camp 20030830 | The low quality recording features a live performance of a pop song that contains a reverberant soft male vocal singing over mellow piano chords. There are crowd singing noises in the background. It sounds soulful, passionate and emotional. | 2012-04-16T01:06:53Z | MBCkpop | Han Kyung-il - Sad invitation, 한경일 - 슬픈 초대장, Music Camp(음악캠프), 193회, EP193, 2003/08/30, MBC TV, South Korea | ["Music", "Sad music"] | ["low quality", "live performance", "pop", "reverberant soft male vocal", "crowd singing", "mellow piano chords", "soulful", "passionate", "emotional"] | 4 | Xl4RSHQsnl8 | 3220 | |
MOKK -solo-"Humming" trailer.mov | This audio includes a woman making unintelligible animal sounds with her voice. The audio is recorded live in low quality. | 2012-04-16T04:28:29Z | MOKK2008 | 2012年1月 MOKK -solo-「Humming」(渋谷Space Edge) 演出・振付:村本すみれ 出演:鈴木優理子、羽太結子、池田遼(少年王者館)http://www.mokk.cc まるでさざ波の、小さくて白い飛沫のように 淋しげでうかれた、苦しくて愛おしい、なまいきで切ない、 まだそれは、それぞれの「声」の断片でした。 カセットレコーダーに閉じ込めたはずのそれらは いつしか、とけだし、まざり、ひびき、 くりかえし、くりかえし ただの振動となりました。 生まれたばかりの宇宙に、祝福を。 Humming. | ["Humming", "Music"] | ["live recording", "low quality audio", "untintelligible human vocal sounds"] | 3 | wraN7rWUsfI | 5288 |
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;