musiccaps_details (view)
3 rows where musiccaps_aspects contains "electronic music", musiccaps_aspects contains "poor audio quality" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- electronic dance music 3
- electronic music · 3 ✖
- poor audio quality · 3 ✖
- medium tempo 2
- abstract tones 1
- adventurous 1
- amplifiers 1
- audio research 1
- buzzing hum 1
- cymbal crash tone 1
- daw setup 1
- distorted tones 1
- dj 1
- dubstep music 1
- electric current manipulation 1
- energetic passionate 1
- experimental music 1
- groovy rhythm 1
- grunge keyboard tones 1
- high pitched frequencies 1
- home studio 1
- instrumental 1
- instrumental music 1
- instrumentals music 1
- long echoes 1
- low frequencies 1
- mysterious 1
- mystery 1
- overdriven keyboard harmony 1
- party time 1
- percussive rhythm 1
- pulsating tones 1
- rubbing tones 1
- science experiment 1
- song ending 1
- song fading 1
- sonorous harmony 1
- steady drumming rhythm 1
- suspense 1
- synth string pad section 1
- techno dance music 1
- techno drumming rhythm 1
- techno tones 1
- trance music 1
musiccaps_names (array) 8 ✖
- Music 3
- Cacophony 1
- Dubstep 1
- Electronic music 1
- Exciting music 1
- Soundtrack music 1
- Synthesizer 1
- White noise 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pirates of the Caribbean Trance/Dance Remix | The song is an instrumental. The song is medium tempo with a loud crash tone which undulates percussively and fades. The song is of poor audio quality and probably faded with a lot of humming noise. | 2007-06-28T22:54:39Z | cornholio | I hope you guys enjoy this. I had some latency issues so I just placed the mp3 file over the video file. Tell me what you think! Software used: FL Studio 7, Sytrus, Nexus Hardware used: M-Audio Axiom 49 | ["Music", "White noise"] | ["instrumental music", "poor audio quality", "suspense", "mystery", "adventurous", "party time", "trance music", "buzzing hum", "electronic dance music", "home studio", "cymbal crash tone", "groovy rhythm", "long echoes", "electronic music", "song fading", "techno tones", "daw setup", "electronic music", "song ending", "medium tempo", "pulsating tones"] | 1 | KpwdlYIdtfs | 2123 | |
Baile de Dubstep | The song is an instrumental. The song is medium tempo with a slick drumming rhythm, grunge keyboard tones, overdriven synth tones and string pad section. The song is groovy and exciting. The audio quality is poor in general. | 2013-03-08T02:22:05Z | Rafael Chávez | Mira mi nuevo video y aprende 3 pasos sencillos https://www.youtube.com/watch?v=nhlQRS4vDYo | ["Electronic music", "Music", "Dubstep"] | ["instrumentals music", "dubstep music", "overdriven keyboard harmony", "poor audio quality", "dj", "electronic music", "grunge keyboard tones", "steady drumming rhythm", "distorted tones", "synth string pad section", "electronic dance music", "techno drumming rhythm", "techno dance music", "rubbing tones"] | 1 | MP7KPlqoQW0 | 2262 | |
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;