This sound effect can be found on Sounds Of The City, which was made by Ovation Records.
https://soundeffects.fandom.com/wiki/File:Ovation_Records,_Police_Patrol_Wagon_Siren.ogg