Clarke County veterans roll

Name: Clarke County veterans roll
Creator: Our Clarke
Published: 2026-10-12
License: https://creativecommons.org/licenses/by/4.0/

Every person on the Our Clarke roll of Clarke County veterans, from the colonial wars to Afghanistan, one row per person with every field the roll holds and the sources cited for it.

In

2,312 people the Our Clarke roll of Clarke County veterans lists, from the colonial wars to Afghanistan, one row per person, with the sources behind each row.

Not in

2 rows the /veterans/ page does not show: people or families who asked not to be published, rows found not to be veterans, and rows whose only basis is a title. A veteran who may be living is listed without a birth year. No service numbers, addresses or other identifiers are included.

Effective date

October 12, 2026

Download

CSV 1.7 MB
SHA-256 cc09ccca97c5c6b6a99ebf0608a77e93478b239938f3653eee9cf07593473ef4
XLSX (spreadsheet) 383 KB
SHA-256 28caaa23da72f2d8ac87b1a7cfad962e8ed082ee74da0dca51c0bc1e7a0f3ac9

Version

1.0.0

Published

October 12, 2026

License

CC BY 4.0. Cite the sources named in each row's citations column when reusing a row, in addition to the Our Clarke citation.

Cite as

Our Clarke. "Clarke County veterans roll." Dataset, version 1.0.0, published 2026-10-12. Compiled by Our Clarke from the sources cited in each row. https://ourclarke.com/data/#clarke-veterans-roll. License: CC BY 4.0.

Documentation

README.md · schema.md · datapackage.json · manifest.json

Browse

Roll of Clarke County veterans

README

Rendered from README.md, the file this directory serves.

Clarke County veterans roll

Every person on the Our Clarke roll of Clarke County veterans, from the colonial wars to Afghanistan, one row per person with every field the roll holds and the sources cited for it.

Dataset ID: clarke-veterans-roll
Tier: 1 (Genealogy)
Version: 1.0.0
Publication date: 2026-10-12
Records: 2,312
License: Creative Commons Attribution 4.0 International (CC BY 4.0)
Source of truth: https://ourclarke.com/veterans/

Coverage

In: 2,312 people the Our Clarke roll of Clarke County veterans lists, from the colonial wars to Afghanistan, one row per person, with the sources behind each row.
Not in: 2 rows the /veterans/ page does not show: people or families who asked not to be published, rows found not to be veterans, and rows whose only basis is a title. A veteran who may be living is listed without a birth year. No service numbers, addresses or other identifiers are included.
Effective date: 2026-10-12

Source

Our Clarke roll of Clarke County veterans. Compiled by Our Clarke from the sources cited in each row. https://ourclarke.com/veterans/

Source file SHA-256: 5f994b4c4f5fc9be0e0b472347bdc546701095b0649cc2abf468750d6a1e4629

Attribution: Cite the sources named in each row's citations column when reusing a row, in addition to the Our Clarke citation.

Files

File	Format	Size	Rows	SHA-256
clarke-veterans-roll-2026-10-12.csv	CSV	1,785,017 bytes	2,312	`cc09ccca97c5c6b6a99ebf0608a77e93478b239938f3653eee9cf07593473ef4`
clarke-veterans-roll-2026-10-12.xlsx	XLSX	392,188 bytes	2,312	`28caaa23da72f2d8ac87b1a7cfad962e8ed082ee74da0dca51c0bc1e7a0f3ac9`

Column definitions are in schema.md. Machine-readable metadata is in datapackage.json. Every file in this directory, with its size and SHA-256, is listed in manifest.json.

Held fields

status: Working notes on the project's own pages and release steps, not facts about the person.
recent_death_flag: A working note for the project's own family-sensitivity review of a death within ten years, not a fact about the person.
research notes, decision files and internal record codes: The citations column keeps each source as cited and removes the project's working paths, record codes and catalog numbers.

Row filters

Every row passed the download boundary's two filters before it was written: rows about a person who may be living are excluded, and rows whose state is unresolved (verify, lead, ambiguous and similar) are excluded. This publication excluded 0 rows as possibly living and 0 as unresolved at that boundary.

Reading the data

Each row is a lead from a named source, not a verified service record. A camp list, cemetery note or casualty card is not a service record, and one name may be two people or two names one person.

A blank birth or death field means no source used here gives one. It is not a statement that the person is living.

Spellings are the sources' own. name_variants lists the other forms found; a reading the sources disagree on is described in citations.

The page /veterans/ is the source of truth. A correction made there reaches this file at the next publication.

How to cite

Versions

Each publication is dated in its filenames. Earlier publications are kept unchanged at https://ourclarke.com/data/snapshots/.

Column schema

Rendered from schema.md, the file this directory serves.

Schema: Clarke County veterans roll

Dataset clarke-veterans-roll, version 1.0.0, published 2026-10-12. One row per record; the CSV and the "Records" sheet of the XLSX carry the same columns in the same order.

Column	Type	Description
`person_id`	string	Stable Our Clarke identifier for the person on the roll. Does not change between versions.
`name`	string	The name as the roll shows it.
`name_variants`	string	Other spellings and forms of the name found in the sources, separated by semicolons.
`war`	string	The war the roll lists the person under: Colonial, Revolution, 1812, Mexican, Civil War, Spanish-American, WWI, WWII, Korea, Vietnam, Afghanistan, Other or "not stated".
`wars_all`	string	Every war the sources place the person in, separated by semicolons.
`war_basis`	string	What the war rests on, in the words of the record behind it.
`branch_unit`	string	Branch, unit, rank or company as the sources give it.
`birth_year`	string	Birth year where a source states it; sometimes a date. Empty when no source gives one, and always empty for a veteran who may be living.
`death_date_or_year`	string	Death date or year where a source states it. Empty is not a statement that the person is living.
`death_as_stated`	string	The death, wound or casualty as the source words it, where one does.
`burial`	string	Burial place where a source gives one.
`clarke_basis`	string	Why the person belongs on a Clarke County roll: the home, birth, death, burial or Clarke unit a source states.
`deceased_basis`	string	Why the person is taken to be deceased: a record of death, or the roll's rule for wars that ended in 1919 or earlier and for people born before 1916. Empty or "living or not known" for a veteran who may be living.
`source_families`	string	The kinds of source behind the row, as the codes the /veterans/ page uses, separated by commas.
`sources_described`	string	The same source kinds in words, separated by semicolons.
`citations`	string	The sources for the row as citations: title, date, page and what the source says, as recorded when each source was read. Separate passages are joined with a vertical bar.
`green_hill_register_id`	string	The row of the Green Hill Cemetery dataset (/data/#green-hill-cemetery) for this burial, where one row is certain.
`page_url`	url	The person's own page on Our Clarke, where there is one.

An empty cell means the value is not recorded in the source, or could not be read from it. It never means zero.

All data downloads · Snapshots