people

212,064 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: hydrated, mobilization (date), date_of_birth (date), date_of_death (date), date_of_burial (date), first_seen (date), last_seen (date)

Next page

CREATE TABLE people (
        slug TEXT PRIMARY KEY, url TEXT,
        name TEXT, name_override TEXT, photo TEXT,
        status TEXT, rank TEXT, unit TEXT,
        place_of_birth TEXT, place_of_death TEXT,
        death_lat TEXT, death_lon TEXT,
        cause TEXT, mobilization TEXT,
        awards TEXT, award_url TEXT,
        dob TEXT, dod TEXT, burial TEXT,
        date_of_birth TEXT, date_of_death TEXT, date_of_burial TEXT,
        sources_json TEXT, fields_json TEXT, raw_html_path TEXT,
        hydrated INTEGER DEFAULT 0,
        first_seen TEXT, last_seen TEXT, fails INTEGER DEFAULT 0);
CREATE INDEX idx_people_hydrated ON people(hydrated);
CREATE INDEX idx_people_date_of_death ON people(date_of_death);