names

28 rows where place_id = 609695

✎ 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
3679828 1919755 1919755 defendant Hole alias Howell John carrier 609695 609695 Hole alias Howell, John, of Pynhoo, carrier 0
3684542 1921298 1921298 defendant Gerves Walter husbandman 609695 609695 Gerves, Walter, of Pynhoo, husbandman 4
3684543 1921298 1921298 defendant Mylward James gent 609695 609695 Mylward, James, of Pynhoo, gent 5
3692102 1923698 1923698 defendant Brownwyll Philip husbandman 609695 609695 Brownwyll, Philip, of Pynhoo, husbandman 0
3731079 1935946 1935946 defendant Grosse John husbandman 609695 609695 Grosse, John, of Pynhoo, husbandman 0
3874389 1981659 1981659 defendant Serger Joan spinster 609695 609695 Serger, Joan, of Pynhoo, spinster 0
3876488 1982384 1982384 defendant Sarger Joan spinster 609695 609695 Sarger, Joan, of Pynhoo, spinster 0
3890471 1987069 1987069 defendant Renell or Revell James husbandman 609695 609695 Renell or Revell, James, of Pynhoo, husbandman 0
3938001 2003040 2003040 defendant Reynoldes James yeoman 609695 609695 Reynoldes, James, of Pynhoo, yeoman 1
3973874 2015430 2015430 defendant Cole John butcher 609695 609695 Cole, John, of Pynhoo, butcher 0
4026392 2034082 2034082 defendant Jonson Nicholas husbandman 609695 609695 Jonson, Nicholas, of Pynhoo, husbandman 0
4026393 2034082 2034082 defendant Knyght Nicholas husbandman 609695 609695 Knyght, Nicholas, of Pynhoo, husbandman 1
4026394 2034082 2034082 defendant Tryckhay Walter husbandman 609695 609695 Tryckhay, Walter, of Pynhoo, husbandman 2
4026396 2034083 2034083 defendant Peter alias Anthony John gent 609695 609695 Peter alias Anthony, John, of Pynhoo, gent 0
4028829 2034959 2034959 defendant Kelly alias Gervys Alexander husbandman 609695 609695 Kelly alias Gervys, Alexander, of Pynhoo, husbandman 0
4130813 2071330 2071330 defendant Turnor John husbandman 609695 609695 Turnor, John, of Pynhoo, husbandman 1
4154523 2079675 2079675 defendant Roo Joan widow 609695 609695 Roo, Joan, of Pynhoo, widow 0
4154524 2079675 2079675 defendant Turnor John husbandman 609695 609695 Turnor, John, of Pynhoo, husbandman 1
4202085 2096273 2096273 defendant Turnor John husbandman 609695 609695 Turnor, John, of Pynhoo, husbandman 0
5033159 2366580 2366580 defendant Baron John husbandman 609695 609695 together with Baron, John, of Pynhoo, husbandman 7
5317632 2450360 2450360 defendant Pytte Henry laborer 609695 609695 Pytte, Henry, of Pynhoo, laborer 0
5317633 2450360 2450360 defendant Tope John laborer 609695 609695 Tope, John, of Pynhoo, laborer 1
5384699 2470708 2470708 defendant Germyn John husbandman 609695 609695 Germyn, John, of Pynhoo, husbandman 2
5423573 2482013 2482013 defendant Germyn John husbandman 609695 609695 Germyn, John, of Pynhoo, husbandman 1
5423576 2482014 2482014 defendant Germyn John husbandman 609695 609695 Germyn, John, of Pynhoo, husbandman 1
5453408 2490908 2490908 defendant Germyn John husbandman 609695 609695 Germyn, John, of Pynhoo, husbandman 2
5467333 2495177 2495177 defendant Germyn John husbandman 609695 609695 Germyn, John, of Pynhoo, husbandman 2
5530240 2513966 2513966 defendant Broune Thomas husbandman 609695 609695 Broune, Thomas, of Pynhoo, husbandman 1

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