musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic music" and musiccaps_aspects contains "experimental music" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- electronic music · 2 ✖
- experimental music · 2 ✖
- instrumental 2
- medium tempo 2
- abstract tones 1
- ambient 1
- amplifiers 1
- audio research 1
- complex chords 1
- electric current manipulation 1
- electronic dance music 1
- electronic keyboard 1
- energetic passionate 1
- funk jazz 1
- futuristic 1
- high pitched frequencies 1
- innovative 1
- jazz and electronic collaboration 1
- jazz style drumming 1
- jazz-o-tech 1
- low frequencies 1
- mysterious 1
- percussive rhythm 1
- poor audio quality 1
- science experiment 1
- sonorous harmony 1
- techno jazz 1
musiccaps_names (array) 8 ✖
- Cacophony 1
- Electric piano 1
- Exciting music 1
- Keyboard (musical) 1
- Music 1
- Piano 1
- Soundtrack music 1
- Synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
ATJAZZ - It's complete | This music is instrumental. The tempo is medium with synthesiser harmony and jazz style drumming. The music is a collaboration of jazz and electronica. It is an experimental,futuristic,funky, psychedelic and Ambient Funk Jazz. | 2009-01-12T12:23:52Z | optimusprime1968 | Fifth track of the album titled "Labfunk" Watch it in HQ http://www.youtube.com/watch?v=9KK6rg03bC8&fmt=18 | ["Electric piano", "Keyboard (musical)", "Piano"] | ["instrumental", "medium tempo", "electronic music", "jazz style drumming", "electronic keyboard", "funk jazz", "experimental music", "techno jazz", "jazz-o-tech", "innovative", "jazz and electronic collaboration", "ambient", "futuristic", "experimental music", "complex chords"] | 7 | 9KK6rg03bC8 | 995 | |
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;