Public domain, long term Minecraft multiplayer CCU data.
About Minetrack Data
Starting October 2016, Minetrack has been pinging a selection of Minecraft servers every 3-5 seconds. The resulting databases are a time series collection of each included Minecraft servers self reported player count. I have opted to publish those databases into the public domain because while niche, no other collections of this type of data have been publicized to my knowledge.
Each database is a .sql file, as generated by SQLite. Besides any pruning, all databases have been released in their original schemas and have not been optimized for analysis or publishing.
Each database has two indexes already defined (pre-built by Minetrack).
For databases published prior to July 2020, the playerCount column will store a 0 value if Minetrack failed to ping the server.
Unforunately, this means you cannot differentiate between erroneous pings and playerCount values that
happen to be 0. Any databases published July 2020 and onward will instead insert a nullplayerCount value to denote an error when pinging.
The timestamp column is a unix epoch time in milliseconds denoting when the ping
response (or error) has been handled.
Some Minecraft servers may have only been tracked for a portion of the database's full date range.
Records may be incomplete for the start and end days of each database's respective date range. Other databases will likely contain the remaining records (with some overlap).
CREATE TABLE pings (timestamp BIGINT NOT NULL, ip TINYTEXT, playerCount MEDIUMINT);
CREATE INDEX ip_index ON pings (ip, playerCount);
CREATE INDEX timestamp_index on PINGS (timestamp);
Starting August 1st 2020, Minetrack automatically publishes daily database releases of the last 24 hours, using the UTC timezone, at 1am each day. Prior to this, Minetrack databases were manually published in large, numbered releases. These legacy releases remain available for download for historical purposes and will remain in their original format.
To help automate downloading new database releases, each database is released using the date format %-d-%-m-%Y.sql.zip as its filename.
All published databases are hosted and served using BunnyCDN, with bandwidth costs paid out of pocket. If you're interested in trying BunnyCDN, consider using my referral code to help support Minetrack Data. Thank you!
All published databases on this page are licensed under CC0 1.0 (Public Domain Dedication, "No Copyright").
The person who associated a work with this deed has dedicated the work to the public domain by waiving all of his or her rights to the work worldwide under copyright law, including all related and neighboring rights, to the extent allowed by law.
You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission.