Skip to content

2026-10-04 — OSRS player count data

Latest
Latest

Choose a tag to compare

View all tags
@UsefulEndymion UsefulEndymion released this 04 Oct 00:01
data-2026-10-04
573e3fa
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Full snapshot of the OSRS Player Count database, taken 2026-10-04.

Files

file size sha256
osrs_data-2026-10-04.db.gz 41.3 MB c206b1a9b43385cfe2f10a3348fa87f506b7a8cca43807e77578cd923a9fd213
osrs_global-2026-10-04.csv 4.4 MB c7bb9b800cd3c5f08a47bf65d64644f9a86dc15f59374ed5d64a1933674560b5

Coverage

This dataset has three eras, and they do not all start at the same time:

period what exists tables
2013-02-26 .. 2025-10-08 weekly average + peak, global only history_import
2025-10-19 .. 2025-12-04 ~5-minute global samples, no per-world data players
2025-12-04 .. 2026-10-04 ~5-minute global samples + ~30-minute per-world scrapes players, world_data

The middle era is the one that catches people out: global history begins before per-world tracking did, so joining the two leaves a gap of several weeks where only the global series exists.

Row counts

table rows
players 88,979
world_data 4,624,807
scrape_events 13,623
world_details 233
locations 8
activities 100
history_import 1,308

Known caveats

  • Retired worlds are not flagged. There is no worlds dimension table, so worlds Jagex has since removed look identical to live ones.
  • Activity names are not de-duplicated. Variants like Castle Wars 1 / Castle Wars 2 are stored exactly as published. Group them at display time if you need to; the raw strings are kept for fidelity.
  • The archived peak series ends before the average series. In history_import, peak runs to 2025-09-17T00:00:00Z but average runs to 2025-10-01T00:00:00Z. Nothing later exists for peak in the source archive, so a Peak line will look like it stops early. That is the source, not data loss.
  • Gaps exist wherever the tracker was down. They are not interpolated.

Provenance

History before 2025-10-08 is weekly pre-aggregated data imported from misplaceditems.com via the Wayback Machine, and is credited per-row in history_import.source. Everything after is native tracking by this project.

The snapshot also carries a dump_meta table repeating all of the above, so the file stays self-describing if it gets separated from this page.

Using it

gunzip osrs_data-2026-10-04.db.gz
sqlite3 osrs_data-2026-10-04.db "SELECT * FROM dump_meta;"

osrs_global-2026-10-04.csv is the global player-count series on its own (90,287 rows), for anyone who does not want to open a SQLite database.

Assets 4
Loading