- Joined
- Oct 6, 2024
Sadly I work 16 hour shifts at the ball crushing factory at the moment, so I don't have the time to do anything I don't already know how to do. (this includes spreadsheets which I have no experience with unfortunately).
UK Migrant Crime Tracker Development Thread
- Thread starter Crunkle
- Start date
-
Want to keep track of this thread?
Accounts can bookmark posts, watch threads for updates, and jump back to where you stopped reading.
Create account
- Joined
- Apr 9, 2024
Absolutely no problem at all, thanks for gathering the stuff last night. Will be adding those to the DB soon.
- Joined
- Oct 6, 2024
The above site is an excellent resource for monitoring courts on the local level. Short of visiting your local council archives buildings, this is the only way to view court records in the UK. You are required to make an account however fake information can be used without issue. Just don't make it look obviously faked (I'm sure you all have legit looking fake names and addresses ready to go).
For instance here we can see in Brighton Magistrates Courtroom 7, Akbar Sohrabi-Karyani was sentenced on charges brought by the CPS. Those chargers were: Breaching a criminal order and theft from a shop (2 counts). You will have to do your own further research to find specifics but it is an excellent tool nontheless.
Similarly here, you can see in Luton Crown Court 1, His Honour Judge Simon had three cases. A pre trial review of Arran Davidson, a 'For Mention' on Raymond Dolby's offence (for mention is an on record case update effectively) and finally a trial for Azhar Mahmood. Notice the second and third cases are Sexual Offences as the complainents in both have their anonymity protected.
All these records are only up for a couple of days before being removed, if you want further records it's off to the local council archives or pay for Courtserve's professional software. Furthermore, copying, reproduction and distribution in any form or media whatsoever and in any country, is expressly prohibited. Use this website on here and to personally confirm details, but you will need to go elsewhere if you want to use this information on the website.
- Joined
- Mar 20, 2024
Good project @Crunkle, since you need someone to host all of this I might be able to help, but I wouldn't be able to have the server running year-round since I'm a frequent flyer. I could set it up in one of the Gulf States but I might get shafted up the ass because all the rapists coincidentally happen to be named Mohammad.
Last edited:
- Joined
- Apr 9, 2024
Thanks very much and thanks for the possible host option. Going to try and get this on a server tonight, I've got a host picked out which accepts crypto so will give that a go first.
I'll know who to come to if anything goes down! Depending on the reaction, I may also get a Tor site up.
- Joined
- Apr 9, 2024
Oh shit, sorry. Completely missed this message in the weirdness with the site being DDoSed.
That looks insane. Way more in-depth than what I'm doing. Literally just collecting the lat/lon for now. You're right about stats, definitely.
Depends on the data you have! If you just have articles and links then send it to me in DM or put it in one message in this thread. If it's more in-depth then feel free to send over a CSV, might be a bit easier that way.
GIS Merchant
kiwifarms.net
- Joined
- Aug 12, 2025
We will correspond over DMs from now on to avoid clogging up the thread and you can keep everyone updated with the overall progress.
There I will share some thoughts on the geodatabase I made and what data I want to collect.
I will send you data on a weekly basis, probably on the weekends and trail and error will show what's the best data acquisition approach.
The only question I have is what would be what are the most "credible" news sources Britain has to offer, because I'm currently perusing thesun but if you have some "better" sites I will use the sun as the first source and try to find the same incident report from another news source.
- Joined
- Oct 6, 2024
The Telegraph for the right wing perspective and The Guardian for the left wing perspective.
- Joined
- Apr 9, 2024
Great question, you're in for a world of pain, though. Most right-wing sites here that bother to report the crimes have nasty paywalls. Almost all of the time, I can put a paywalled article into archive.is and it will show up in full so that's a good trick.
A few possible sites:
- order-order.com (Guido Fawkes, my go-to. They report quite reliably on the migrant-related happenings).
- gbnews.com (most likely to report on these crimes)
- dailymail.co.uk (if you can skip through the nonsense about "influencers" and paparazzi)
- express.co.uk (also reliably reports on the migrant stuff, got to keep a close eye on it though)
- unherd.com (mostly opinion pieces which are good for a read outside of this project but they'll occasionally have some good information in there if it's related to the article)
UPDATE
I've purchased a domain and a server!Not sure if the site will go up tonight as I am really tired, but it's almost ready to go up. Once the database is set up and the site is working, I'll DM you @BrightonAndHoveAlbion and @GIS Merchant (unless you don't want to) you the link to the website once it's good to be tested. I really want to hammer it, see how it handles stress. I've applied heavy caching on the frontend.
I've spoken to the owner of howfarfrommydoorstep.co.uk and we're going to be collaborating. For the V1, I'll link to that site from mine and I think he'll want to be doing the same from an email I've just read/replied to. Seems very switched, definitely an asset to what we want to achieve. I've registered the project under a `.org` domain name so that lends us credibility and also possibly means this could become larger than just a map website.
- Joined
- Jul 29, 2024
Very cool project. Do UK legal documents regarding criminal offenders specify whether they are migrant criminals or home-grown migrant criminals?
- Joined
- Apr 9, 2024
Usually, yeah. To try and lessen their sentence they pull the "well I'm a poor poor asylum seeker so that's why I rape!" card, which is almost always committed to court record. Their default defense might actually help us find and categorise the crimes.
Outside of that, we have news articles which usually mention this.
- Joined
- Jul 29, 2024
Very interesting, thank you for explaining. I wondered if the UK courts would suppress that information but it appears their records are more public than I thought.
I have zero tech skills so I wish I could contribute to your project in some way.
- Joined
- Apr 9, 2024
UPDATE
The site has been deployed! I'd love to share it with you all now but it needs a bit of further testing and a few bugfixes. Had a few friends test but will send out some DMs after I've populated the production DB with some reports before I make it "public".Will likely post a link here later or tomorrow.
- Joined
- Dec 10, 2023
You're a fucking legend man. You should probably include the OG article link alongside the archive (if available) in case someone wants to load the original article to lower load times, since normies probably don't want to click on archive sites, but this is a minor nitpick.
Aside from that and just simply finding more crime incidents, it looks good.
I'd love to help find more crimes for you to put on this site, even though I'm not sure where I could look for that kind of stuff
Aside from that and just simply finding more crime incidents, it looks good.
I'd love to help find more crimes for you to put on this site, even though I'm not sure where I could look for that kind of stuff
Last edited:
- Joined
- Apr 9, 2024
Hey, yeah I did think about this. The archives always include the original link so I was thinking that instead of having articles on my site that in a year or two might be dead, we have the archive link and the article link if anyone wants to go there and see if it's been changed/moved/edited. A lot of news sites do that these days.
@Mound Dweller mentioned this too in some feedback but I think it's not a bad thing to push boomer boundaries with archives. They've got the best chance of staying on the Internet for as long as possible. If boomers will donate to scams because it has the British flag on, they'll click on an archive link. We'll see what the response is but definitely will look at doing this if I get this feedback much more.
Maybe some way of posting the raw article link and then queue off an archival service which populates the DB once the archive has been done. Bit too complex for the MVP but could look at adding for the V2 release.
UK news sites like GB News, The Express, Daily Mail. There's also court records for most courts in the UK but that'll be quite heavy-lifting in proving the migration status as the government hides this intentionally.
- Joined
- Dec 10, 2023
Found an article and tried to submit it, but I got an error.
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: "" CONTEXT: unnamed portal parameter $2 = '' (Connection: pgsql, SQL: insert into "reports" ("name_of_criminal", "age", "country_of_origin_id", "date_arrived_in_country", "latitude", "longitude", "articles", "is_new", "hidden", "updated_at", "created_at") values (?, , ?, ?, ?, ?, ["https
![:\](/styles/custom/emotes/svg/chris-confused.svg "Confused :\")
/\/www.gbnews.com\/news\/migrant-crisis-asylum-seeker-arrested-common-assault-canary-wharf-london","https/\/archive.ph\/oZLiJ"], 1, 1, 2025-08-17 00:24:19, 2025-08-17 00:24:19) returning "id")I resubmitted it with the same info and it did work. I believe it's because I tried typing "20s" as the age since that was the age range specified, but it didn't let me so I removed it.
I'll continue to send in whatever reports I can.
- Joined
- Apr 9, 2024
If you've been sending in the last five or so, great work. All fantastic, all accurate. Working my way through to get them on the map.Found an article and tried to submit it, but I got an error.
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: "" CONTEXT: unnamed portal parameter $2 = '' (Connection: pgsql, SQL: insert into "reports" ("name_of_criminal", "age", "country_of_origin_id", "date_arrived_in_country", "latitude", "longitude", "articles", "is_new", "hidden", "updated_at", "created_at") values (?, , ?, ?, ?, ?, ["https
View attachment 7789851
I resubmitted it with the same info and it did work. I believe it's because I tried typing "20s" as the age since that was the age range specified, but it didn't let me so I removed it.
I'll continue to send in whatever reports I can.
Great spot on this bug too, probably some missing validation on that field. For now if you can't specify an exact age, just leave it. I'd rather be missing the information than have anything that's incorrect.
- Joined
- Dec 10, 2023
That was the first one I sent in, but I'm sending in a few more slowly but surely.