soldiers

64,215 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: hydrated, marked, mark_new, mark_edit, mark_skip, date_of_birth (date), date_of_death (date), first_seen (date), last_seen (date)

Next page

CREATE TABLE soldiers (
        id INTEGER PRIMARY KEY,
        slug TEXT UNIQUE,
        last_name TEXT, first_name TEXT, patronymic TEXT, call_sign TEXT,
        dob TEXT, dod TEXT, date_of_birth TEXT, date_of_death TEXT,
        place_of_birth TEXT, place_of_burial TEXT,
        rank_id INTEGER, rank_name TEXT, military_rank_name TEXT,
        military_position TEXT, military_unit TEXT,
        award_combined TEXT, awards TEXT, cemetery_name TEXT,
        biography TEXT, death_circumstances TEXT,
        photo TEXT, country_flag TEXT, image TEXT, media TEXT,
        raw_json TEXT, hydrated INTEGER DEFAULT 0,
        first_seen TEXT, last_seen TEXT, marked INTEGER DEFAULT 0, comment TEXT, mark_new INTEGER DEFAULT 0, mark_edit INTEGER DEFAULT 0, mark_skip INTEGER DEFAULT 0, burial_media TEXT);
CREATE INDEX idx_soldiers_hydrated ON soldiers(hydrated);
CREATE INDEX idx_soldiers_date_of_death ON soldiers(date_of_death);
CREATE INDEX idx_soldiers_rank_name ON soldiers(rank_name);
CREATE INDEX idx_soldiers_place_of_burial ON soldiers(place_of_burial);