musiccaps_details (view)
12 rows where musiccaps_aspects contains "enthusiastic" and musiccaps_aspects contains "loud"
This data as json
musiccaps_aspects (array) 167 ✖
- enthusiastic · 12 ✖
- loud · 12 ✖
- energetic 10
- fast tempo 8
- instrumental 6
- youthful 6
- male vocalist 5
- vibrant 5
- boisterous 3
- groovy bass line 3
- inferior audio quality 3
- intense 3
- medium tempo 3
- muffled audio 3
- people talking 3
- pop rock 3
- rock 3
- upbeat 3
- amateur recording 2
- amplified guitar 2
- animated 2
- digital music 2
- dj 2
- dj mixer 2
- electronic music 2
- hard rock 2
- heavy metal 2
- keyboard harmony 2
- metal 2
- noisy 2
- passionate 2
- playful 2
- powerful 2
- rock and roll 2
- sonic power 2
- spirited 2
- vehement 2
- vocal backup 2
- accompanying music 1
- acoustic pop rock 1
- aerophone 1
- aggressive singing 1
- amplified harmonica 1
- amplified instruments 1
- amplified keyboard 1
- anthem 1
- assertive 1
- background noises 1
- beeping 1
- blues harp 1
- boomy 1
- brass instrument 1
- bright 1
- busy 1
- buzzing 1
- catchy 1
- chanting 1
- chaotic 1
- cheerful 1
- clapping 1
- clicking sound 1
- club music 1
- complex harmony 1
- concert performance 1
- confusing 1
- coughing 1
- cymbals 1
- dance clubs 1
- dance groove 1
- dance music 1
- digital drum 1
- dissonant 1
- dominating vocals 1
- double neck guitar 1
- drum machine 1
- edm 1
- electric guitar 1
- electrifying 1
- emphatic 1
- energetic drumming 1
- enthusiastic electric guitar lead 1
- external amplification 1
- folk music 1
- forceful 1
- free reed instrument 1
- french harp 1
- funk pop 1
- funky 1
- funky bass line 1
- gig 1
- groovy 1
- guitar harmony 1
- gunshots 1
- happy 1
- hard hitting drumming 1
- harmonica lesson 1
- harmonica melody 1
- harmonica solo 1
- high pitch 1
- high torque 1
- home recording 1
- home video 1
- incoherent lyrics 1
- infectious drumming 1
- insistent 1
- intense drumming 1
- intense electric guitar 1
- intense electric guitar harmony 1
- intense electric guitar lead 1
- jarring 1
- keyboard accompaniment 1
- live performance 1
- lively electric guitar 1
- loud electric guitar feedback 1
- lucid 1
- male singer 1
- male voice speaking 1
- melodious 1
- mouth organ 1
- people cheering 1
- people talking in the background 1
- peppy 1
- persuasive 1
- phone ringing 1
- phono output 1
- phonograph record 1
- pop 1
- popnrock 1
- profanity 1
- psychedelic music 1
- pulsating 1
- punchy drumming 1
- punk rock 1
- repetitive 1
- rhythmic acoustic guitar 1
- rock instrumental 1
- rustling 1
- scratching sound 1
- sonic power’ 1
- sonic treat 1
- static 1
- syncopated 1
- syncopated harmony 1
- synth pop 1
- synthesiser arrangement 1
- synthesiser articulation 1
- synthesiser harmony 1
- talking 1
- tambirine 1
- tambourine beats 1
- trance 1
- trippy 1
- tuneful 1
- turn table 1
- tutorial 1
- upbeat catchy 1
- vibrations 1
- video game music 1
- vigorous 1
- vigorous drumming 1
- vigorous vivacious 1
- vinyl records 1
- vivacious 1
- vocal chant 1
- whirring 1
- whirring sounds 1
- wind instrument 1
musiccaps_names (array) 27 ✖
- Music 10
- Rock music 3
- Blues 2
- Harmonica 2
- Rock and roll 2
- Roll 2
- Singing 2
- Wind instrument, woodwind instrument 2
- Bass guitar 1
- Country 1
- Dance music 1
- Disco 1
- Electric guitar 1
- Grunge 1
- House music 1
- Inside, large room or hall 1
- Jazz 1
- Musical instrument 1
- Progressive rock 1
- Sampler 1
- Scratch 1
- Scratching (performance technique) 1
- Synthesizer 1
- Synthetic singing 1
- Tambourine 1
- Tapping (guitar technique) 1
- Vocal music 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;