musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "medium tempo" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- instrumental · 3 ✖
- medium tempo · 3 ✖
- poor audio quality 2
- abstract tones 1
- ambient room noise 1
- ambient room sounds 1
- amplifiers 1
- audio research 1
- background music 1
- beep tones 1
- button clicks 1
- doorsteps 1
- drawer closing 1
- electric current manipulation 1
- electronic dance music 1
- electronic music 1
- energetic passionate 1
- experimental music 1
- female voice 1
- high pitched frequencies 1
- home improvement video 1
- home video 1
- low frequencies 1
- male singer 1
- musical instruments 1
- mysterious 1
- noise 1
- non musical tones 1
- offbeat 1
- passionate singing 1
- percussive rhythm 1
- pop song 1
- quirky 1
- science experiment 1
- sonorous harmony 1
- tooth brush music 1
- unimpressive sounds 1
- vibration magic 1
- weird 1
- whirring sounds 1
- wind noise 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Oscar Meble SZUFLADA BLUMOTION Kuchnia na wymiar wzór klasyczny | Ambient sound still in the room with a mild background music playing. A male singer sings a passionate melody with subtle background music. The audio quality is very poor with drawer sliding sound and general noise. | 2010-10-14T10:17:25Z | oscarmeble | Niniejszy film przedstawia zastosowanie systemu Bloumotion firmy Blum. Kuchnia wykonana przez firmę www.oscar-meble.pl, najwyższa jakość i staranność wykonania. | ["Music", "Drawer open or close"] | ["ambient room noise", "instrumental", "male singer", "beep tones", "wind noise", "doorsteps", "noise", "non musical tones", "home improvement video", "unimpressive sounds", "drawer closing", "home video", "passionate singing", "medium tempo"] | 1 | -SWaCArvQug | 48 | |
Music Toothbrush | The song is music created by a toothbrush. The tempo is medium and sounds like a female singer singing in high pitch, motor whirring sounds and button clicks. The audio is poor quality in nature. | 2009-03-13T14:03:47Z | dixter | ["Toothbrush", "Music"] | ["button clicks", "whirring sounds", "background music", "poor audio quality", "weird", "musical instruments", "quirky", "offbeat", "ambient room sounds", "poor audio quality", "female voice", "pop song", "tooth brush music", "weird", "offbeat", "vibration magic", "instrumental", "medium tempo"] | 1 | QYxFWV85-pg | 2626 | ||
Music From Outer Space - Weird Sound Generator WSG - Modified with CV inputs | The song is instrumental. The tempo is medium with electrical current manipulation to produce different frequencies to play percussively and harmonically with each other. The song is for scientific research and not pleasing to the ear. The song is of poor audio quality. | 2011-10-22T19:05:48Z | Djo HxC | A demo of the MFOS WSG. This one is modified with CV inputs. http://www.musicfromouterspace.com More information of my build here: http://modularsynth.wordpress.com/mfos-weird-sound-generator-wsg/ | ["Music", "Cacophony", "Soundtrack music", "Synthesizer", "Exciting music"] | ["electronic music", "instrumental", "amplifiers", "high pitched frequencies", "low frequencies", "medium tempo", "percussive rhythm", "sonorous harmony", "poor audio quality", "mysterious", "energetic passionate", "experimental music", "abstract tones", "science experiment", "electric current manipulation", "electronic dance music", "audio research"] | 1 | Ysrlv2UlG8A | 3317 |
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;