Skip to content
View jckkrr's full-sized avatar
🥭
Hello Sunshine!
🥭
Hello Sunshine!
Block or Report

Block or report jckkrr

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
jckkrr/README.md

Want to see what's really going on?

🥇 Winner of the 2023 European Centre for Press and Media Freedom IJ4EU Impact Award

I build intelligence tools that break front-page news and drive award-winning investigations.

My investigations have: 🛂: exposed World Cup passport fraud for The New York Times; 🗞️ been front-page news for The Age; 📻: been broadcast by the ABC; 💰 informed federal anti-money laundering investigations; and 🚓: featured in Interpol briefings.

Areas of interest: cyber and OSINT; fact-checking and anti-disinformation; corporate intelligence; gambling investigations; aviation as a source of alternative data; and government data.

📍 Melbourne, Australia

#investigativeAnalytics #digitalOSINT #dataStoryteller #dataTranslations #dataViz #investigativejournalism


Case studies

✈️ Aviation data ✈️

Screenshot 2023-03-08 150415

Aviation is a trove of stories waiting to be mined, and there's been no time that this was more exident than during the pandemic. Here's three times of the stories it has helped me uncover.

  • I analysed 1,000,000+ pings from police helicopters during Melbourne's lockdowns. ... and it showed that the rumours were true: they really did spend a disproportionate amount of time over the northern suburbs. Find it at: constituent.au

  • I revealed that the Australian government hired disgraced Crown Casino's private jets to fly COVID-aid across the Pacific ... and in combination with other open-source intelligence techniques, discovered a front-page story for The Age and Sydney Morning Herald. Find it at: The Age

  • I found that half of Australia's airports were actaully busier during the pandemic ... and as I reported for Business Insider, this was largely thanks to FIFO workers in the west driving much of the demand,as well as some internal tourism. Find it at: GitHub

⚽ Gambling investigations ⚽

newplot(102)

The offshore gambling industry is a source of fascination, and of mind-bending stories. Here are three examples of how I've used data to investigate the industry.

  • I investigated a suspected fixed match by comparing its odds to hundreds to those in a decade-long archive ... and found how extraordinary the match really was. Find it on: Github

  • I did a cyber audit on Bet365's network of sites targetting the Chinese black market ... and this research was then used as part of a federal anti-money-laundering investigation.

  • I build tools to determine the size of football's offshore betting market ... and found that 8 per cent of games offered by unregulated bookmakers come from Australia.

🗳️ Government and corporate analytics 🗳️

image

Make it easier to get data they put barriers around is one of my favourite jobs. Here's three times I did that.

  • I turned ASIC company records into interactive network maps ... and discovered just how close a senator was to a disinformation group.

  • I fact-checked a premier's spin via a PDF reader ... and found that he really was full of spin.

  • I created an interactive public-facing tool to show who is connected in the UK Companies House database ... which then expands to show the associates of those associates. Find it on Streamlit

The UKCH is an outstanding resource for finding business connections. This tool makes the process more efficient and revealing, by creating network maps of a person's business associates - which then expands to show the associates of those associates.

✈️ WHO MET WHO? ✈️

image

OSINT investigators wish they could get access to flight records. This tool doesn't do that, but it does show which planes landed and took off on the same days from an airport, which can be useful in offering potentially solutions to who was meeting whom.

It applies relational alegbra to the constructed databases built from the Open Sky Network and HexDB.io APIS, in order to return the details on all aircraft that fit the search criteria.

Find it on Streamlit | Github

These are just a taste of the tools we have available. We'd love to tell you moreabout them. Get in touch at studio@constituent.au

👁️👁️👁️ Visualisations 👁️👁️👁️

AusVotes2022_tpp_vs_sa1 newplot(103) newplot(104)

image image

image image image newplot(105)


Made in Melbourne


Python Pandas Plotly Plotly NumPy Python Python

Pinned

  1. UK_Companies_House_Network_Mapper UK_Companies_House_Network_Mapper Public

    Who's connected to who in the world of business? This tool shows you all the connections, by scraping data from the Comanies House website to build a interactive network map.

    Jupyter Notebook

  2. asic_mapper asic_mapper Public

    Company records are an essential part of many investigations. This script takes company record PDFs from the Australian Securities & Investments Commission (ASIC) and converts them into an interact…

    Jupyter Notebook

  3. Ambulance_Victoria_Quarterly_Reports_PDF_Scraper Ambulance_Victoria_Quarterly_Reports_PDF_Scraper Public

    Nobody enjoys copying and pasting text from PDFs. This script does that for you, for Ambulance Victoria quarterly response times data.

  4. Unlayering_Oddsportal Unlayering_Oddsportal Public

    The data security of the Oddsportal website keeps out unsophisticated web-scrapers. Other sites could learn from this.

    Jupyter Notebook 6

  5. hackathon-submission-template hackathon-submission-template Public

    Forked from bellingcat/hackathon-submission-template

    Template repository and README for submissions to Bellingcat's Global Hackathon

  6. half_of_australian_airports_were_busier_during_pandemic half_of_australian_airports_were_busier_during_pandemic Public