The Ghost in the Spreadsheet: On Finding My Grandfather in a Public Archive

I never knew my grandfather. He died when my father was young, leaving behind a handful of black-and-white photographs and the kind of stories that get smoother and more opaque with each retelling. He was a silhouette, a man defined by his absence. I had long ago accepted that this was all I would ever have of him.

Then, one Tuesday evening, I fell down one of those rabbit holes that only open data portals can provide. I was researching mid-century urban development for a piece I was writing, trawling through a newly digitized municipal archive. It was a dry landscape of meeting minutes, zoning maps, and permit logs. I was about to close the tab, my eyes glazing over from the endless rows of a CSV file, when a name caught my eye. It was his. His full name, uncommon and precise, nestled in a column titled "Licensee."

My breath hitched. I scrolled frantically. There he was, listed again and again, each entry a tiny, digital fossil. He was granted a license for a radio repair shop in 1953. He applied for a permit to build a new awning in 1957. He was cited for a minor signage violation in 1961, which he promptly rectified. I was no longer looking at a spreadsheet; I was watching a stop-motion film of his professional life. Each cell was a frame, a receipt for a transaction with a world that had forgotten it happened.

The Person in the Protocol

This wasn't a curated family anecdote, polished by nostalgia. It was raw, bureaucratic, and breathtakingly immediate. The data was cold—dates, permit numbers, ordinance codes—but the man it outlined was warm and real. I could see his ambition in the first business license, his pride in the awning permit, his mild frustration (and responsibility) in the violation notice. Open data, in this instance, did what no photo album ever could: it showed me his rhythm. It revealed the mundane, daily grind of building a life.

We often talk about digital preservation in grand terms: saving entire websites, archiving national treasures, backing up the collective memory of humanity. But its most profound power often lies in these micro-restorations. A city clerk, dutifully typing information onto a form, wasn't thinking about legacy. They were thinking about filing. Yet, their act, combined with another clerk decades later who decided to scan instead of shred, created a bridge across time.

I now possess a document that proves my grandfather existed not just as a memory, but as a citizen, a businessman, a person who built things and sometimes made small mistakes. The open data movement, at its heart, is about rejecting the idea that our shared history belongs only in official narratives or family lore. It’s about preserving the right for anyone to stumble upon a ghost in a spreadsheet and, for a moment, invite them back into the world.

Notes & further reading

A few pages I came back to while writing this: