musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic music", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- electronic dance music 2
- electronic music · 2 ✖
- medium tempo · 2 ✖
- poor audio quality · 2 ✖
- abstract tones 1
- adventurous 1
- amplifiers 1
- audio research 1
- buzzing hum 1
- cymbal crash tone 1
- daw setup 1
- electric current manipulation 1
- energetic passionate 1
- experimental music 1
- groovy rhythm 1
- high pitched frequencies 1
- home studio 1
- instrumental 1
- instrumental music 1
- long echoes 1
- low frequencies 1
- mysterious 1
- mystery 1
- party time 1
- percussive rhythm 1
- pulsating tones 1
- science experiment 1
- song ending 1
- song fading 1
- sonorous harmony 1
- suspense 1
- techno tones 1
- trance music 1
musiccaps_names (array) 6 ✖
- Music 2
- Cacophony 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 | |
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;