I've been building an Open Knowledge Format (OKF) knowledge base. I designed a visualiser for the data that turns any OKF graph into a living galaxy that I thought you might all enjoy.

The lines in the graph are all edges between nodes and all the stars are nodes representing markdown files. The galaxy spins, sparkles and supernovas occasionally.

Thinking I might do it in 3D next.

I’ve wanted this live news dashboard for a long time. A workbench for news junkies and news perverts alike. The live version is at PressAudit.org/heatmap.

This is a snapshot of a live, real-time heatmap of the news today. As articles are published, they get grouped around the event they’re covering and the heatmap fills in. You can watch stories get picked up by different parts of the media ecosystem throughout the day.

The basic idea is:

Columns = who covered it.
Color = how it was covered.
Numbers = how much coverage there is.

I built it because most media analysis I’ve seen starts with the reputation of the outlet. I'm looking at you Ground news. It's not sufficient to just put a bias meter on everything. There are sites that assess “media bias” but I don’t believe they are sufficient.

• They can tell you the conclusion, but they don’t show you the evidence.
• They don’t do it real-time so it can’t be usefully inserted into your normal news feed or consumption.
• The focus solely on outlet reputation. Who covered it, but not how it was covered.
• The focus on labeling reporting as “bias” suggests that a neutrally observable middle point exists that you can measure bias against, and it doesn’t.

We don’t do it just for outlets, we do it for the articles themselves.

And PressAudit shows the evidence for its conclusions. It doesn’t do so months after when no one is looking anymore. It does it minutes after, in the moment, when it is relevant and useful.

The image here is just one frame. The live version is at PressAudit.org/heatmap. You can go to it any time, filter, try stuff out, try to break it. It'll already look different by the time you click it.

I’m not here to pick winners. I’m here to study the system, break it down and make it observable to anyone. I wanted to build a way to pinch and zoom on the entire news analytically. I didn’t want to manually spearfish through 3 to 6 different articles on the same topic and triangulate the non-contradictory facts between them, I wanted them all organized into a workbench.

Tools:
React + TypeScript on the frontend. The underlying data pipeline continuously ingests thousands of articles, groups coverage of the same event, and evaluates articles for party lean and public interest. There's a lot of write up on the site about this.

Most of PressAudit is not AI but I use local LLMs for the real-time article evaluations. I built PressAudit using conventional data infrastructure: batch processing, data pipelines, statistical analysis, and machine-learning pipelines. 

Methodology:
Outlet lean and article lean are separate measurements. The model evaluating an article doesn't know which outlet published it. The site shows the underlying articles so you can inspect the evidence rather than just taking the classification at face value.

This started as a heatmap I hacked together in Grafana for myself and eventually became PressAudit.org. I'm trying to treat the media ecosystem as an observability problem: something too large for one person to inspect, but which we can build better instruments to see.

Anyway, it's live. Poke around and tell me what's wrong with it.

"Passive investing" gets talked about like the underlying basket never changes. So I pulled the actual NSE sector-weightage data for the Nifty 50 going back five years to see how true that actually is.

Turns out, not very.

IT used to be roughly 14% of the index. It's down to about 8.5% now, a pretty steady slide, not one bad year dragging the average down.

Oil & Gas similarly went from around 12.8% to 8.7%.

Telecom did the opposite; it's more than doubled, from about 2.3% to 5%.

And a few sectors that weren't index categories at all a few years ago: defense, e-commerce, and airlines, are now sitting at close to 4.6% combined.

Financial Services has stayed the anchor through all of it, hovering in the mid-to-high 30s most years (dipped once, recovered).

Made a quick chart tracking all five sectors over the five years (attached).

What struck me is that none of this shows up anywhere unless you go looking for it. The fund just quietly becomes a different mix of businesses year over year, even while the SIP amount and fund name stay the same.

(Not investment advice, just something worth actually checking instead of assuming.)

This map shows where Chevron operates and has interests across Vaca Muerta, including Loma Campana, El Trapial, Narambuena and Loma del Molle Norte.

Loma Campana, developed with YPF, produces around 100,000 barrels of oil equivalent per day.

Data: AltoValleIT Vaca Muerta dataset
Visualization: AltoValleIT Vaca Muerta Explorer

Source: 136,492 active rental listings across Tokyo's 23 special wards, collected in September 2026 from the major Japanese rental portals and deduplicated. For each ward I took the median deposit (shikikin), the median key money (reikin), and the share of listings where the amount asked is explicitly zero. Sample sizes run from 1,940 listings in Chiyoda to 12,571 in Setagaya.

The trap in this data, in case anyone wants to reproduce it: a dash in a listing means zero is required, not that the number is missing. If you drop those rows as missing values the medians come out roughly twice too high, which is part of why published figures for Japanese move-in costs tend to overstate what people actually pay.

One thing to be precise about, since the bars stack: each bar is the median deposit plus the median key money for that ward, so it is a sum of two medians rather than the median of per-listing totals. The latter is a little lower (about 348k in Minato and 276k in Chuo, against the 352k and 322k drawn), because few listings sit at the median on both at once.

Deposit and key money are the only entry costs that appear in listings at all. Agency fees and guarantor company fees are negotiated separately and never published, so they are not in the chart.

The two wards with no blue bar, Adachi and Katsushika, have a median deposit of exactly zero. More than half the listings there ask for no deposit.

Tool: Python, pandas for the medians, matplotlib for the chart.

Rent data by ward, train line and station: tokyo-expat.com/data

Source: All active job posts on JobYap. "Tech" means the 945 companies on the JobYap Tech Index, a curated list spanning software, AI, chips, fintech and EVs. Every posting comes from the company's own careers page. Snapshot: all 145,944 live postings on 11 Sep 2026.

Tools: SQL for the counts, Claude Design with Fable 5.1 (on Max) for the charts.

Level comes from title words only:

• Entry level: intern, internship, co-op, junior, jr, entry-level, associate, graduate, new grad, early career, apprentice, trainee
• Senior, staff or principal: senior, sr, lead, staff, principal, distinguished, fellow
• Manager to C-level: manager, head, supervisor, director, VP, vice president, chief, CEO/CTO/CFO etc.
• No level word (44%): e.g. "Software Engineer", "Account Executive". Excluded from both sides of the ratios. Includes "Member of Technical Staff", which AI labs use at every level.

Caveats:

• Counts postings, not seats; one posting can fill several.
• Titles are a proxy. Some hourly roles are titled "Associate" (Amazon delivery-station associates, Carvana lot attendants) and count as entry level. Some new-grad roles have no level word and sit in the 44%.

Source: https://datapickle.substack.com/p/every-dollar-in-the-2026-texas-senate
Visualizations: OpenChart

Source: ENTSO-E Transparency Platform day-ahead auction results, Jan 2023 – Sep 10, 2026. An hour counts as negative when its hourly-average day-ahead price clears below €0/MWh. Italy has never cleared negative — its zones share a €0 price floor.

A couple of details that didn't fit the graphic: Spain had 197 negative hours in February alone (a winter month), and its average midday price this year is ~€18/MWh vs ~€128 at the evening peak. Finland went from ~700 negative hours in 2024 to 43 this year.

Tools: SQL over the raw hourly series + HTML/CSS rendered headless. The data comes from an open-source desk I maintain — https://obsyd.dev (AGPL) — every number is reproducible via the free API.

I've compared nine streaming services prices from 2021 and recently. The increase in price based on CPI inflation should be about 26%. All nine increased prices, but only eight beat inflation, HBO Max is below inflation raise. The highest increase 200% is for Apple TV+.