casualties

106,062 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: conscription, sex, is_died_from_wounds, is_from_decrees, letter, death_at (date), date_of_conscription (date), first_fetched_at (date), last_seen_at (date), deleted_at (date)

Next page

CREATE TABLE casualties (id INTEGER PRIMARY KEY, "fullname" TEXT, "alt_fullname" TEXT, "rank" TEXT, "conscription" TEXT, "days_from_conscription" TEXT, "sex" TEXT, "age" INTEGER, "date_of_birth" TEXT, "date_of_death" TEXT, "death_at" TEXT, "date_of_conscription" TEXT, "date_of_funeral" TEXT, "is_died_from_wounds" INTEGER, "is_from_decrees" INTEGER, "region_of_live" TEXT, "region_of_death" TEXT, "region_of_funeral" TEXT, "sources" TEXT, "letter" TEXT, "first_fetched_at" TEXT, rec_key TEXT, last_seen_at TEXT, deleted_at TEXT);
CREATE INDEX idx_casualties_date_of_death ON casualties(date_of_death);
CREATE INDEX idx_casualties_region_of_death ON casualties(region_of_death);
CREATE INDEX idx_casualties_region_of_live ON casualties(region_of_live);
CREATE INDEX idx_casualties_age ON casualties(age);
CREATE INDEX idx_casualties_conscription ON casualties(conscription);
CREATE INDEX idx_casualties_letter ON casualties(letter);
CREATE INDEX idx_casualties_first_fetched_at ON casualties(first_fetched_at);
CREATE UNIQUE INDEX uq_casualties_rk ON casualties(rec_key);
CREATE INDEX idx_casualties_deleted_at ON casualties(deleted_at);
CREATE INDEX idx_casualties_last_seen_at ON casualties(last_seen_at);