musiccaps_details (view)
3 rows where musiccaps_aspects contains "electronic music", musiccaps_aspects contains "sharp" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- electronic music · 3 ✖
- sharp · 3 ✖
- instrumental 2
- amateur recording 1
- bass drum 1
- boisterous 1
- children electronic toys 1
- children’s game music 1
- club music 1
- digital drum 1
- distorted sounds 1
- dj 1
- droning sound 1
- elctronic music 1
- electronic arrangements 1
- fast tempo 1
- harsh 1
- high notes 1
- home video 1
- hypnotic 1
- inferior audio quality 1
- intense 1
- loud 1
- loud electric guitar feedback 1
- medium fast tempo 1
- medium tempo 1
- monotone 1
- muddled audio 1
- muffled audio 1
- noisy 1
- psychedelic 1
- raw 1
- slick drumming 1
- snare 1
- subdued song in background 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- trance 1
- unpleasant 1
- unpleasant droning sound 1
- video game music 1
- vigorous 1
- whirring 1
- white noise 1
- whooshing sound 1
musiccaps_names (array) 16 ✖
- Music 3
- Bass guitar 1
- Clatter 1
- Distortion 1
- Drum and bass 1
- Drum machine 1
- Dubstep 1
- Effects unit 1
- Electric guitar 1
- Electronica 1
- Heavy metal 1
- Ice cream truck, ice cream van 1
- Reverberation 1
- Sampler 1
- Techno 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tinnitus y sordera-Tinnitus and deafness | This music is an electronic instrumental. The tempo is medium fast with synthesiser arrangements, digital drumming and an insistent, persistent ,and incessant electronic drone sound that over powers the background music. It is loud, sharp and unpleasant after a bit. | 2016-06-07T16:46:22Z | Remedios naturales Comenius | Si te gustó este vídeo ¡SUSCRÍBETE! Dale manita arriba para mucho mas vídeos como este, comparte con tus amigos y déjame tus comentarios. | ["Sampler", "Drum and bass", "Music", "Techno", "Trance music", "Dubstep", "Drum machine", "Electronica"] | ["electronic music", "medium fast tempo", "loud", "sharp", "unpleasant droning sound", "synthesiser arrangement", "slick drumming", "digital drum", "electronic arrangements", "droning sound", "monotone", "bass drum", "snare", "psychedelic", "trance", "hypnotic", "club music", "dj"] | 7 | XZurp_Ex9No | 3196 | |
Humor: That's how regular guitar sounds with Guitar Hero chords | This music is instrumental. The tempo is medium with a loud , distorted electric guitar harmony. The audio is inferior quality and the sound is raw, loud , unpleasant , boisterous and harsh. There is some noise, like a subdued song playing in the background. | 2009-01-21T04:02:38Z | scooperfield | Is it hard to play Guitar hero with normal guitar? | ["Bass guitar", "Reverberation", "Effects unit", "Electric guitar", "Heavy metal", "Music", "Clatter", "Distortion"] | ["instrumental", "fast tempo", "distorted sounds", "subdued song in background", "harsh", "raw", "inferior audio quality", "vigorous", "boisterous", "noisy", "unpleasant", "electronic music", "intense", "loud electric guitar feedback", "unpleasant", "sharp"] | 7 | c-8SLUH5pp4 | 3673 | |
1/18 Tampa City of Tampa Florida POLICE Diecast Car with Lights and SIREN | This music is instrumental. The tempo is slow with an electronic keyboard playing a simple, high pitched harmony. There are sounds in the background like whirring, whooshing and clicking. The music is not very clear as the audio clip is muffled, but it sounds like video game music or the music Ina child’s electronic toy. | 2010-10-29T21:53:59Z | 6877mercedes Ebay | City of Tampa Florida POLICE Diecast Car with Lights and SIREN | ["Ice cream truck, ice cream van", "Music"] | ["instrumental", "medium tempo", "high notes", "sharp", "children electronic toys", "electronic music", "whirring", "white noise", "whooshing sound", "video game music", "children’s game music", "elctronic music", "synthesiser arrangements", "muffled audio", "muddled audio", "home video", "amateur recording"] | 7 | uwPeQy7ZtGo | 5143 |
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;