musiccaps_details (view)
8 rows where musiccaps_aspects contains "beep"
This data as json
musiccaps_aspects (array) 102 ✖
- beep · 8 ✖
- instrumental 5
- chaotic 3
- dissonant 3
- fast tempo 3
- confusing 2
- distorted sounds 2
- electronic sounds 2
- static 2
- white noise 2
- acoustic guitar 1
- amateur percussionist 1
- amateur recording 1
- banjo 1
- bass synth 1
- boisterous 1
- boisterous unrelated 1
- boomy 1
- bouncy 1
- boys having fun 1
- buoyant 1
- buzzing 1
- catchy vocal riff 1
- cello 1
- censored lyrics 1
- chain saw 1
- country folk 1
- country pop 1
- country song 1
- dance groove 1
- deafening 1
- digital drumming 1
- dissonant unrelated 1
- drum beats 1
- drum machine 1
- drunk singing 1
- eerie 1
- electrical waves 1
- electronic drums 1
- electronic gadgets 1
- electronic music 1
- electronic wave sounds 1
- engine 1
- enthusiastic music 1
- futuristic 1
- game end music 1
- giggling 1
- grim 1
- group singing 1
- hip-hop 1
- home recording 1
- intense violin harmony 1
- jingle 1
- laughing 1
- low audio quality 1
- male harmony 1
- male vocalist 1
- medium harmony 1
- medium tempo 1
- merry 1
- modern 1
- multiple tracks playing 1
- music 1
- mysterious 1
- naughty 1
- noisy 1
- paper rustling 1
- people talking in the background 1
- percussions 1
- phone tone 1
- piano 1
- pop rap 1
- punchy 1
- random 1
- rap 1
- rhythm arrangement 1
- rising pattern 1
- running 1
- scratching sound 1
- shooting 1
- sinister 1
- slow tempo 1
- sound effects 1
- stifled laughter 1
- suggestive 1
- superimposed tracks 1
- synth 1
- synthesised arrangements 1
- telephone busy signal 1
- toy 1
- trumpets 1
- turntable 1
- uneasy 1
- unpleasant 1
- unrelated music 1
- unrelated tracks 1
- video game sounds 1
- vigorous 1
- vinyl record 1
- vocal harmony 1
- wind 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music 8
- Beep, bleep 2
- Busy signal 2
- Background music 1
- Cacophony 1
- Cash register 1
- Chainsaw 1
- Roll 1
- Sonar 1
- Telephone dialing, DTMF 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;