The Unsearchable Index: On Boxes, Basements, and the Data Before Google
I found it in the municipal basement, in a room that smelled of damp concrete and obsolete machinery. I wasn’t looking for it; I was looking for a sewer map. But there, wedged between a stack of zoning amendments from the 1970s and a crate of unused “Y2K Readiness” badges, was a cardboard box. Its label, written in a precise, fading hand, read: “Cemetery Plot Transfers, 1985-1992. Index.”
I lifted the lid. Inside were not files, but cards. Thousands of them, 3x5 inches, the soft yellow of aged newsprint. Each card held a name, a date, a plot number, and a few lines of notes in the same meticulous script. This was the database. Not a .DBF file, not a relational table, but a physical object you could riffle through with your thumb. The “index” was the box itself, its contents ordered by a logic I couldn’t immediately discern—was it by date of transfer? By surname? By section of the graveyard? The system lived only in the mind of the clerk who wrote them, and perhaps in the muscle memory of their hands.
The Logic in the Fingers
Spending an hour with that box changed how I think about open data. We speak of datasets as clean, structured, machine-readable things. We envision APIs and CSV downloads. But so much of the world’s information, the deeply public record, lived first in a state like this: tactile, local, and utterly unsearchable by any engine but human intuition. To find John Doe’s plot, you had to know how the clerk thought. You had to understand that ‘Mc’ and ‘Mac’ were filed together, that transfers after a burial were kept in a separate sequence, that a certain smudge in the corner meant the record was cross-referenced with the tax assessor’s office.
Digitizing this box would be an act of translation, and like all translations, it would involve loss. You could capture the names and dates. But you could not capture the weight of the card, the slight tear at the edge that meant it was frequently handled, the faint pencil annotation in a different hand that signaled a later audit. The provenance—the story of the data’s own life—was embedded in its material form.
This is the quiet challenge of the readable public record. The goal isn’t just to make the *information* public, but to make its *context* perceptible. When we scan and OCR and structure, we often flatten the idiosyncratic pathways that were the original search algorithm. We replace a knowable, if quirky, physical system with a black-box digital one that promises total recall but understands nothing.
I never did find my sewer map. But I left thinking about that clerk, and the incredible, fragile efficiency of their system. It was open, in that it was a public record. It was preserved, sitting in that basement. But it was only readable if you understood its native language—a language of cardboard, handwritten glyphs, and spatial memory. Our digital archives are magnificent, but they can feel bloodless. They lack the smell of concrete and the sound of a thumb flicking through cards. Sometimes, preservation means saving not just the data, but the echo of the gesture it took to find it.
Notes & further reading
A few pages I came back to while writing this:
- Vancouver, WA
- The Subversive Static: A Defense of the Unchanging Web Page
- Madison, WI
- The Museum of Broken URLs: On Digital Fragility and the Art of Repair
- Milwaukee, WI
- The Unwritten Archive: What Gets Lost When We Only Save the Published Web
- a useful directory
- a local resource
- a place-by-place guide
- one area's overview
- a regional guide
- a helpful reference
- a practical rundown