names

21 rows where place_id = 731636

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4295165 2128354 2128354 defendant Boothe George esq 731636 731636 Boothe, George, of Irenham, esq 2
4762702 2284313 2284313 defendant Whyte John husbandman 731636 731636 Whyte, John, of Irenham, husbandman 0
4847103 2310594 2310594 defendant Hilton Godfrey   731636 731636 Hilton, Godfrey, of Irenham, knight 0
4857221 2313644 2313644 defendant Cole John husbandman 731636 731636 Cole, John, of Irenham, husbandman 1
4859120 2314228 2314228 defendant Cole John husbandman 731636 731636 Cole, John, of Irenham, husbandman 1
4896350 2325523 2325523 defendant Hylton Godfrey   731636 731636 Hylton, Godfrey, of Irenham, knight 1
4916205 2331572 2331572 defendant Poklyngton William clerk 731636 731636 Poklyngton, William, of Irenham, clerk 0
4974002 2349187 2349187 defendant Scheffeld John husbandman 731636 731636 Scheffeld, John, of Irenham, husbandman 0
4987042 2353067 2353067 defendant Hylton Godfrey   731636 731636 Hylton, Godfrey, of Irenham, knight 0
5001491 2357326 2357326 defendant Coke John husbandman 731636 731636 Coke, John, of Irenham, husbandman 0
5009925 2359777 2359777 defendant Hylton Godfrey   731636 731636 Hylton, Godfrey, of Irenham, knight 0
5009929 2359779 2359779 defendant Auburn John husbandman 731636 731636 Auburn, John, of Irenham, husbandman 0
5016827 2361818 2361818 defendant Cook John husbandman 731636 731636 Cook, John, of Irenham, husbandman 0
5016828 2361818 2361818 defendant Auburn Thomas husbandman 731636 731636 Auburn, Thomas, of Irenham, husbandman 1
5036295 2367466 2367466 defendant Hylton Godefrey   731636 731636 Hylton, Godefrey, of Irenham, knight 0
5098274 2385924 2385924 defendant Tolwyche Thomas husbandman 731636 731636 Tolwyche, Thomas, of Irenham, husbandman 0
5098275 2385924 2385924 defendant Auburn Thomas husbandman 731636 731636 Auburn, Thomas, of Irenham, husbandman 1
5098276 2385924 2385924 defendant Auburn John laborer 731636 731636 Auburn, John, of Irenham, laborer 2
5122543 2393025 2393025 defendant Hilton Godfrey   731636 731636 Hilton, Godfrey, of Irenham, knight 0
5122547 2393026 2393026 defendant Hilton Godfrey   731636 731636 Hilton, Godfrey, of Irenham, knight 0
5122551 2393027 2393027 defendant Holton Godfrey   731636 731636 Holton, Godfrey, of Irenham, knight 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);