musiccaps_details (view)
3 rows where "youtube_published" is on date 2008-02-26 sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- amateur recording 1
- ambient scraping synth lead 1
- bass sound 1
- calming 1
- chimes 1
- chinese instrumental 1
- chinese instruments 1
- digital drums 1
- electronic 1
- experimental 1
- guzheng harmony 1
- healing 1
- instrumental 1
- low quality 1
- meditative 1
- melancholic 1
- mono 1
- muddy 1
- muffled 1
- noisy 1
- pensive 1
- pipa accompaniment 1
- slow tempo 1
- soothing 1
- spacey 1
- string instruments 1
- viloin harmony 1
musiccaps_names (array) 4 ✖
- Music 3
- Beatboxing 1
- Scary music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Beautiful China and traditional music | This music is a calm Chinese instrumental melody. The tempo is slow with use of traditional chinese string instruments like the Guzheng and Pipa harmony accompanied with violin symphony and chimes. The music is soft, mellow, melancholic, meditative, dreamy, healing and ethereal. | 2008-02-26T22:59:29Z | baby john | Have a look at our back yard! | ["Music", "Tender music"] | ["instrumental", "slow tempo", "chimes", "melancholic", "string instruments", "pipa accompaniment", "viloin harmony", "calming", "soothing", "meditative", "healing", "pensive", "chinese instruments", "chinese instrumental", "guzheng harmony"] | 7 | KxVbdGPAfjE | 2133 | |
Multi Touch Workshops Aldeburgh Music | The low quality recording features an ambient scraping synth lead playing. It sounds muddy, muffled, but also spacey and the recording is noisy and in mono. | 2008-02-26T14:10:21Z | seeper | A video of seeper.com + flat-e.com working with school kids to put on a live performance using our multi touch table. The event was organised and hosted by Aldeburgh Music. | ["Music", "Scary music"] | ["ambient scraping synth lead", "muddy", "noisy", "mono", "spacey", "muffled", "low quality"] | 4 | 3VTinB14Pmw | 474 | |
ziodennis su boss dr.groove 202 | an uprising low modulated sound comes in with a lot of airy noise before a digital drum rhythm is playing. This is an amateur recording. This sequence may be playing at home programming a sampler. | 2008-02-26T11:07:03Z | ziodennis | primo approccio a una divertente drum machine.. non fare caso al silenzio iniziale.. **** first time on a boss dr202.. pretty fun and live-oriented drummachine.. (silence in the beginning is ok) | ["Beatboxing", "Music"] | ["electronic", "experimental", "bass sound", "digital drums", "amateur recording"] | 6 | OAl2EjbdQG8 | 2408 |
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;