names

16 rows where case_id = 2472626

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5391424 2472626 2472626 plaintiff Perpoynt Henry knight   Perpoynt, Henry, knight 0
5391425 2472626 2472626 defendant Wryght William husbandman 586121 586121 Wryght, William, of Carleton, husbandman 0
5391426 2472626 2472626 defendant Norwele Thomas husbandman 586121 586121 Norwele, Thomas, of Carleton, husbandman 1
5391427 2472626 2472626 defendant Mabson or Mauson William husbandman 586121 586121 Mabson or Mauson, William, of Carleton, husbandman 2
5391428 2472626 2472626 defendant Mabson Richard husbandman 586121 586121 Mabson, Richard, of Carleton, husbandman 3
5391429 2472626 2472626 defendant Greves Robert husbandman 586121 586121 Greves, Robert, of Carleton, husbandman 4
5391430 2472626 2472626 defendant Middelton William husbandman 586121 586121 Middelton, William, of Carleton, husbandman 5
5391431 2472626 2472626 defendant Quynt John laborer 586121 586121 Quynt, John, of Carleton, laborer 6
5391432 2472626 2472626 defendant Matloke John husbandman 586121 586121 Matloke, John, of Carleton, husbandman 7
5391433 2472626 2472626 defendant By_e Thomas husbandman 595865 595865 By_e, Thomas, of Gedlyng, husbandman 8
5391434 2472626 2472626 defendant Balye William husbandman 603099 603099 Balye, William, of Gedlynge, husbandman 9
5391435 2472626 2472626 defendant (illegible) Robert husbandman 595865 595865 _, Robert, of Gedlyng, husbandman 10
5391436 2472626 2472626 defendant Stere Robert husbandman 595865 595865 Stere, Robert, of Gedlyng, husbandman 11
5391437 2472626 2472626 defendant Baylye Richard husbandman 595865 595865 Baylye, Richard, of Gedlyng, husbandman 12
5391438 2472626 2472626 defendant Norwell John husbandman 595865 595865 Norwell, John, of Gedlyng, husbandman 13
5391439 2472626 2472626 defendant Norwell William husbandman 595865 595865 Norwell, William, of Gedlyng, husbandman 14

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