musiccaps_details (view)
27 rows where musiccaps_aspects contains "weird" and musiccaps_author = 4
This data as json
musiccaps_aspects (array) 134 ✖
- low quality 27
- weird · 27 ✖
- noisy 9
- mono 7
- compilation 3
- punchy kick 3
- shimmering hi hats 3
- spacey 3
- aggressive 2
- arpeggiated electric guitar melody 2
- clapping 2
- emotional 2
- energetic 2
- groovy 2
- groovy bass 2
- hypnotic 2
- intense 2
- passionate 2
- punchy "4 on the floor" kick pattern 2
- punchy snare 2
- repetitive 2
- shimmering cymbals 2
- suspenseful 2
- synth pad 2
- 8 bit synth lead melody 1
- acoustic guitar chords 1
- acoustic rhythm guitar 1
- addictive 1
- aggressive male breathing 1
- alarm sound effects 1
- arpeggiated theremin melody 1
- background music 1
- background vocals 1
- bag crumpling sound effect 1
- basic sine wave tone 1
- bell impact 1
- bouncy 1
- bright bells 1
- buzzy 1
- buzzy synth bass 1
- buzzy synth leads 1
- chain rattle sound effect 1
- chaotic 1
- claps 1
- clothes movement sound effect 1
- cool 1
- crowd cough 1
- crowd talking 1
- didgeridoo 1
- dissonant string melody 1
- distorted 1
- distorted bass guitar 1
- dj scratching sound effects 1
- door opening sound effect 1
- echoing electric guitar melody 1
- echoing sleepdrone sound effects 1
- electric guitar chords 1
- electric guitar melody solo 1
- energetic crash hit 1
- fade in 1
- fade out 1
- female vocal mumbling 1
- female vocals 1
- flat male vocal 1
- flat male vocals 1
- foot stomping 1
- fruity male vocal 1
- funny 1
- funny synth lead 1
- groovy bass guitar 1
- groovy piano melody 1
- happy 1
- harmonized mixed vocal 1
- harsh 1
- high pitched male chant 1
- high pitched sound effect 1
- high pitched sped up audio 1
- joyful 1
- live performance 1
- loud 1
- loud didgeridoo modulating low tones 1
- loud horn sound 1
- loud white noise 1
- low growly sounds 1
- low percussive elements 1
- low percussive hits 1
- male cough 1
- male scream 1
- manic 1
- mellow synth keys chords 1
- metallic detuned percussion 1
- modern 1
- muffled hip hop song 1
- organ keys melody 1
- outer space 1
- parody 1
- passionate woodwind melody 1
- playback instrumental 1
- plucked melody 1
- plucked strings melody 1
- pop 1
- processed vocoder male vocals 1
- resonating sound 1
- reverberant wooden toms 1
- rock 1
- room tone ambience 1
- sad 1
- sad dark arpeggiated bells melody 1
- shimmering shakers 1
- short accordion melody 1
- silence 1
- siren sound effect 1
- smooth bass guitar 1
- synth bells melody 1
- synth pad chord 1
- synth pad chords 1
- techno 1
- theremin solo melody 1
- tinny wooden percussion 1
- traditional 1
- traditional song 1
- tutorial 1
- uncomfortable 1
- weird male chant 1
- weird mouth noises 1
- wide 1
- wide filtered reverberant laser synth 1
- wide sustained strings 1
- wide sustained strings melody 1
- wide synth lead melody 1
- wide synth pads 1
- wooden impact 1
- wooden percussion hits 1
- wooden percussions 1
musiccaps_names (array) 48 ✖
- Music 21
- Musical instrument 6
- Electronic music 3
- Theremin 3
- Didgeridoo 2
- Echo 2
- Plucked string instrument 2
- Pop music 2
- Acoustic guitar 1
- Bass guitar 1
- Burping, eructation 1
- Carnatic music 1
- Chink, clink 1
- Clapping 1
- Dial tone 1
- Drum 1
- Drum roll 1
- Dubstep 1
- Electric guitar 1
- Electric piano 1
- Exciting music 1
- Foghorn 1
- Groan 1
- Guitar 1
- House music 1
- Inside, small room 1
- Jazz 1
- Keyboard (musical) 1
- Mantra 1
- Music of Asia 1
- Percussion 1
- Piano 1
- Sampler 1
- Scary music 1
- Scrape 1
- Scratching (performance technique) 1
- Shofar 1
- Singing 1
- Singing bowl 1
- Speech 1
- Squeak 1
- Steel guitar, slide guitar 1
- Synthesizer 1
- Techno 1
- Throat clearing 1
- Whale vocalization 1
- Whoop 1
- Wind instrument, woodwind instrument 1
0 records
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;