musiccaps_details (view)
20 rows where musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "strong bass line"
This data as json
musiccaps_aspects (array) 214 ✖
- poor audio quality · 20 ✖
- strong bass line · 20 ✖
- medium tempo 13
- emotional 11
- passionate 9
- instrumental music 8
- steady drumming rhythm 8
- male singer 7
- romantic 6
- energetic 5
- keyboard accompaniment 5
- spirited 5
- exciting 4
- groovy music 4
- guitar rhythm 4
- keyboard harmony 4
- motivational 4
- female singer 3
- guitar accompaniment 3
- hissing noise 3
- inspiring 3
- slow tempo 3
- vocal harmony 3
- ambient room noise 2
- backup singers 2
- cheerful 2
- dance rhythm 2
- drum rolls 2
- electronic dance music 2
- female backup singers 2
- folk music 2
- groovy rhythm 2
- guitar lead 2
- hip hop dance hits 2
- hip hop music 2
- latin dance music 2
- live audience 2
- live performance 2
- love song 2
- movie soundtrack 2
- people cheering 2
- people dancing 2
- piano accompaniment 2
- poignant 2
- retro dance hits 2
- retro pop hits 2
- soaring vocals 2
- string section harmony 2
- techno dance music 2
- various percussion hits 2
- ad jingle 1
- adrenaline rush 1
- amateur singing 1
- ambient noises 1
- angelic 1
- arabian music influences 1
- arabian nights 1
- arabic music 1
- arabic percussions 1
- bad quality audio 1
- beep tones 1
- bollywood music 1
- buzzing 1
- cameras clicking 1
- car horn playing percussively 1
- carols 1
- cast introduction 1
- cheerful courtship song 1
- child prodigy 1
- christmas carols 1
- christmas time 1
- clapping percussions 1
- clapping randomly 1
- classic hits 1
- club mix 1
- competition 1
- country hits 1
- crowds clapping 1
- crowds whistling 1
- cymbals crashing 1
- cymbals crashing tones 1
- dance arena 1
- dance floor 1
- dance groove 1
- dance rhythm l 1
- dance song 1
- dance-off 1
- dealing with depression 1
- desert sands 1
- deteriorated audio quality 1
- distant music 1
- diva 1
- dj 1
- documentary soundtrack 1
- doo-wop hits 1
- echoes 1
- eerie harmonies 1
- encouraging crowd 1
- entertaining 1
- exercise class 1
- exercise playlist 1
- fashion show tune 1
- fear 1
- feeling good 1
- female child singer 1
- flute solo 1
- folk instrumental music 1
- footstep sounds 1
- forgive me 1
- fun 1
- gets adventure 1
- ghetto boys 1
- groovy dance rhythm 1
- groovy drumming rhythm 1
- groovy guitar rhythm 1
- grunge keyboard tones 1
- gym music 1
- heartfelt 1
- hi- hop dance hits 1
- hissing tones 1
- historical 1
- home music studio 1
- home video 1
- hood 1
- humming 1
- i’m sorry 1
- keybiard accompaniment 1
- keybiard harmony 1
- keyboard synth harmony 1
- keyboard trance melody 1
- latin dance hits 1
- latin oercussions 1
- latin percussion 1
- life lessons 1
- lifetime experience 1
- lilting vocals 1
- live concert 1
- live dance class 1
- live show performance 1
- loneliness 1
- longing for you 1
- loving 1
- madly in love 1
- male backup singers 1
- medium fast tempo 1
- medium-fast tempo 1
- melancholic 1
- memdium tempo 1
- modern pop hits 1
- modern techno hits 1
- music concert 1
- never give up 1
- never say die 1
- new age 1
- no percussion instruments 1
- no percussions 1
- noise 1
- people jumping 1
- percussive hits 1
- philharmonic orchestra 1
- poor quality recording 1
- pop hits 1
- private video 1
- rap music 1
- reggae music influence 1
- retro pop super hits 1
- retro songs 1
- retro techno music 1
- rock band playing 1
- room echoes 1
- santa claus 1
- screaming sounds 1
- sexy 1
- show soundtrack 1
- slick drumming rhythm 1
- slick percussion clicks 1
- solid drum play 1
- song cover 1
- song introduction 1
- sonic effects 1
- story telling 1
- stress 1
- string section playing rhythmically 1
- stringed instruments 1
- strong bas slime 1
- strong bass drum kicks 1
- subtle percussion rhythm 1
- suspense 1
- synth string pads 1
- tamil love songs 1
- tamil movie songs 1
- techno drum rhythm 1
- techno drumming 1
- techno drumming rhythm 1
- techno pop song 1
- tension 1
- theremin 1
- theremin player 1
- timeless hits 1
- together for ever 1
- traditional muscle 1
- traditional music 1
- trance music 1
- trance music vibes 1
- trumpets 1
- tv advertisement sound track 1
- violin accompaniment 1
- violin playing emotionally 1
- whistling tones 1
- woo her 1
- workout music 1
- workout playlist 1
- zumba dance hits 1
- zumba music 1
musiccaps_names (array) 28 ✖
- Music 19
- Applause 3
- Sad music 2
- Song 2
- Acoustic guitar 1
- Brass instrument 1
- Christian music 1
- Crackle 1
- Didgeridoo 1
- Disco 1
- Electronica 1
- Exciting music 1
- Funk 1
- Guitar 1
- Happy music 1
- House music 1
- Humming 1
- Mandolin 1
- Maraca 1
- Plucked string instrument 1
- Pop music 1
- Rattle (instrument) 1
- Scary music 1
- Spray 1
- Strum 1
- Tambourine 1
- Theremin 1
- Trumpet 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;