names

19 rows where place_id = 667392

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3984961 2019378 2019378 defendant Harlesay William husbandman 667392 667392 Harlesay, William, of Bayldon, husbandman 0
4138972 2074309 2074309 defendant Thomlynson Katherine widow 667392 667392 Thomlynson, Katherine, of Bayldon, widow 0
4311492 2134162 2134162 defendant Moorehouse Robert collier 667392 667392 Moorehouse Robert, of Bayldon, collier 3
4392655 2162163 2162163 defendant Hallyday John husbandman 667392 667392 Hallyday, John, of Bayldon, husbandman 0
4602252 2231921 2231921 defendant Wade Robert   667392 667392 Wade, Robert, of Bayldon 2
4602258 2231922 2231922 defendant Wade Robert   667392 667392 Wade, Robert, of Bayldon 2
4664603 2250408 2250408 defendant Bayldon William gent 667392 667392 Bayldon, William, of Bayldon, gent 0
4766677 2285569 2285569 plaintiff Litster Richard   667392 667392 Litster, Richard, of Bayldon 0
4848227 2310917 2310917 defendant Huchunson John yeoman 667392 667392 Huchunson, John, of Bayldon, yeoman 0
4860570 2314663 2314663 defendant Leper John husbandman 667392 667392 Leper, John, of Bayldon, husbandman 0
4929226 2335557 2335557 defendant Hewetson John yeoman 667392 667392 Hewetson, John, of Bayldon, yeoman 0
5098464 2385982 2385982 defendant Litster Richard jusbandman 667392 667392 Litster, Richard, of Bayldon, jusbandman 1
5098465 2385982 2385982 defendant Litster William   667392 667392 Litster, William, of Bayldon, servant 2
5098466 2385982 2385982 defendant Litster John weaver 667392 667392 Litster, John, of Bayldon, weaver 3
5108395 2388892 2388892 defendant Bayldon Robert gent 667392 667392 Bayldon, Robert, of Bayldon, gent 0
5490021 2501901 2501901 defendant Tonge William husbandman 667392 667392 Tonge, William, of Bayldon, husbandman 0
5490022 2501901 2501901 defendant Tonge Thomas laborer 667392 667392 Tonge, Thomas, of Bayldon, laborer 1
5490023 2501901 2501901 defendant Hudson William laborer 667392 667392 Hudson, William, of Bayldon, laborer 2
5490024 2501901 2501901 defendant Fysche Godfrey husbandman 667392 667392 Fysche, Godfrey, of Bayldon, husbandman 3

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);