I wonder how hard it is to download the whole database from this source. Would be cool if they released a straight sqlite file or something to do analysis.
Or the next AI fad 'LAPD officer generator'
AR glasses with cop recognition
Watch the Watchers: LAPD officer database
11–20 of 109 posts
Re: Watch the Watchers: LAPD officer database
#12I wonder how hard it is to download the whole database from this source. Would be cool if they released a straight sqlite file or something to do analysis.
The site doesn't seem to be thrown together very well, you can dump the entire DB by searching for a space character [0] (assuming every officer should have a space in their full name). It dumps as a nice JSON format with all the details.
All the headshots can easily be extracted by appending "https://watchthewatchers.net/headshots/" to the values from the "imagePath" value in the JSON dump.
Re: Watch the Watchers: LAPD officer database
#13[flagged]
this is like my favorite hobby when I'm bored and forced to watch football
Re: Watch the Watchers: LAPD officer database
#14I wonder how hard it is to download the whole database from this source. Would be cool if they released a straight sqlite file or something to do analysis.
The site doesn't seem to be thrown together very well, you can dump the entire DB by searching for a space character [0] (assuming every officer should have a space in their full name). It dumps as a nice JSON format with all the details. All the headshots can easily be extracted by appending " https://watchthewatchers.net/headshots/ " to the values from the "imagePath" value in the JSON dump. [0] https://watchthewat…
Here's a preview of clicking the API link:
https://i.imgur.com/nbhL64L.png
It took a while to load for me, so I'm posting this to spare the site from the HN hug of death, even if just a little bit.
Re: Watch the Watchers: LAPD officer database
#152019 list of LAPD Officers and their serial numbers
https://archive.org/details/LAPDRosterSortedByNameFebruary20...
Re: Watch the Watchers: LAPD officer database
#16I wonder how hard it is to download the whole database from this source. Would be cool if they released a straight sqlite file or something to do analysis.
The site doesn't seem to be thrown together very well, you can dump the entire DB by searching for a space character [0] (assuming every officer should have a space in their full name). It dumps as a nice JSON format with all the details. All the headshots can easily be extracted by appending " https://watchthewatchers.net/headshots/ " to the values from the "imagePath" value in the JSON dump. [0] https://watchthewat…
> you can dump the entire DB by searching for a space character
I abused this trick to perform local fuzzy searches for usernames, results would update with no delay on every keypress, the competing devs were so blown away and couldn't tell how I did it lol.
Best exploit ever. It wouldn't have scaled but it was still so funny to see everyone else's reactions.
Re: Watch the Watchers: LAPD officer database
#17Unless there is an equivalent LAPD initiative that uploads the pictures of law-abiding citizens with names and other identifying info to the public web, there will be suspicions that this is an anti-police (rather than anti-police-surveillance-abuse) measure intended to intimidate and obstruct police work.
Neither is it clear how representative the organizers are of those law-abiding citizens generally rather than a minority mix of genuine victims of police abuse and political agitators using them.
Note this is not a criticism of representative community efforts to hold police forces to account for bad behaviour, but this particular approach seems to play an antagonistic role informed as much by political ideology as genuine concern about police overreach.
Re: Watch the Watchers: LAPD officer database
#18I’m not sure I understand the point of Copwatching and documenting police abuses. Everyone knows about police abuses—the police even document their own abuses themselves with bodycams. It doesn’t matter to them because there are never consequences. It’s pointless to do all this documenting without a way to turn it into accountability.
Re: Watch the Watchers: LAPD officer database
#19[flagged]
No way, "Thomas"?
Re: Watch the Watchers: LAPD officer database
#20are we watching those who watch the watchers.