names

19 rows where place_id = 773470

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4600775 2231467 2231467 defendant Dotesse Robert   773470 773470 Dotesse, Robert, of Blaneford Forum 0
4623395 2238290 2238290 defendant Formage Edward   773470 773470 Formage, Edward, of Blaneford Forum 0
4660644 2249151 2249151 defendant Gry- John   773470 773470 Gry-, John, of Blaneford Forum, millward 0
4743217 2278542 2278542 defendant Bilden John husbandman 773470 773470 Bilden, John, of Blaneford Forum, husbandman 0
4780280 2289834 2289834 defendant Tanner Walter cooper 773470 773470 Tanner, Walter, of Blaneford Forum, cooper 0
4795651 2294792 2294792 defendant Coteler John husbandman 773470 773470 Coteler, John, of Blaneford Forum, husbandman 0
4854813 2312854 2312854 defendant Cryps John   773470 773470 Cryps, John, of Blaneford Forum, mill ward 0
4864484 2315865 2315865 defendant Bayded Thomas tailor 773470 773470 Bayded, Thomas, of Blaneford Forum, tailor 1
4917692 2332046 2332046 defendant Knyght Robert butcher 773470 773470 Knyght, Robert, of Blaneford Forum, butcher 1
4938296 2338358 2338358 defendant Knyght Robert husbandman 773470 773470 Knyght, Robert, of Blaneford Forum, husbandman 0
4956020 2343765 2343765 defendant Lagwater John saddler 773470 773470 (Lagwater, John, of Blaneford Forum, saddler 5
4981285 2351323 2351323 defendant Crispe Robert husbandman 773470 773470 Crispe, Robert, of Blaneford Forum, husbandman 0
5005059 2358379 2358379 defendant Couper Walter husbandman 773470 773470 Couper, Walter, of Blaneford Forum, husbandman 6
5080018 2380504 2380504 defendant Smyth Nicholas yeoman 773470 773470 Smyth, Nicholas, of Blaneford Forum, yeoman 0
5088981 2383155 2383155 defendant Deyman Richard husbandman 773470 773470 Deyman, Richard, of Blaneford Forum, husbandman 0
5625928 2552063 2552063 plaintiff Maundeware Henry   773470 773470 Maundeware, Henry, of Blaneford Forum 0
5629818 2553325 2553325 defendant Clerke Godfrey husbandman 773470 773470 Clerke, Godfrey, of Blaneford Forum, husbandman 0
5631108 2553735 2553735 defendant Chetell John husbandman 773470 773470 Chetell, John, of Blaneford Forum, husbandman 2
5635738 2555133 2555133 defendant Body John baker 773470 773470 Body, John, of Blaneford Forum, baker 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);