Search everything
One box, every source. Words are matched anywhere; put a phrase in quotes; add * to a word for a prefix; OR works. Try a place, a player, a thing that happened.
Ask it a question
The database is plain SQLite and you can query it here. Pick an example or write your own SELECT; results appear below. Nothing you type can change the data.
What is in it
Take it home
The whole thing is a single SQLite file, twitcraft-database.sqlite (about 155 MB), readable with the sqlite3 command, Python, DB Browser for SQLite, or anything else that speaks SQLite. The full-text indexes are FTS5. The same data feeds every page on this site; this file is the archive, minus the world files and images (those are in the downloads).
lname/lowner column and canonical: chat nicknames and hand-confirmed second accounts are folded in through the aliases table (dio → diocia, spinnibbler → thesillychicken). Hours are two sources joined at the January 2014 reset: chat_hours_pre from the IRC logs, stats_hours from the final map’s statistics files. stats holds every raw counter in every statistics file (stat.mineBlock.56 is diamond ore, stat.playOneMinute is ticks). Signs, books and animals carry the map name and coordinates they were read from; a map deep link is https://map.twitcraft.dio.gg/#<map>:x:y:z:40:0:0.8:0:0:perspective.Sources: the server’s own player and statistics files (October 2013 and January 2015 backups), SkyerCorp’s #twitcraft IRC logs, the phpBB forum mirror, and every sign, book and animal read from the world files. Built with the archive’s own scripts; rebuilt whenever a page’s data changes.