This sound effect can be found on Earshot SFX by DXM Productions.
https://soundeffects.fandom.com/wiki/File:Earshot,_NY_Siren_By_Woop.ogg