Minetrack 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.

Feel free to email me with any questions.

Schema

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 null playerCount 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);

License

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.