names

36 rows where place_id = 601181

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3644200 1908619 1908619 defendant Bacheler Robert carver 601181 601181 Bacheler, Robert, of Wulpett, carver 0
3678545 1919347 1919347 defendant Copynger Robert yeoman 601181 601181 Copynger, Robert, of Wulpett, yeoman 0
3758281 1944585 1944585 defendant Osbern William butcher 601181 601181 Osbern, William, of Wulpett, butcher 3
3758691 1944712 1944712 plaintiff Bytton William yeoman 601181 601181 Bytton, William, of Wulpett, yeoman 0
3767246 1947396 1947396 defendant Andrewe Joan widow 601181 601181 Andrewe, Joan, of Wulpett, widow 1
3774380 1949710 1949710 defendant Sharp John shoemaker 601181 601181 Sharp, John, of Wulpett, shoemaker 2
3776778 1950483 1950483 plaintiff Cage John yeoman 601181 601181 Cage, John, of Wulpett, yeoman 0
3795390 1956429 1956429 defendant Mynnys John husbandman 601181 601181 Mynnys, John, of Wulpett, husbandman 1
3797249 1957025 1957025 defendant Turnour John husbandman 601181 601181 Turnour, John, of Wulpett, husbandman 0
3801039 1958241 1958241 plaintiff May William tanner 601181 601181 May, William, of Wulpett, tanner 0
3818577 1963713 1963713 plaintiff May William tanner 601181 601181 May, William, of Wulpett, tanner 0
3834049 1968589 1968589 plaintiff Maye William tanner 601181 601181 Maye, William, of Wulpett, tanner 0
3834053 1968589 1968589 defendant Lawdys William brickmaker 601181 601181 Lawdys, William, of Wulpett, brickmaker 3
3834054 1968589 1968589 defendant Elderyche William yeoman 601181 601181 Elderyche, William, of Wulpett, yeoman 4
3840111 1970480 1970480 plaintiff Abell William (legal representative) 601181 601181 Abell, William, of Wulpett, executors of 0
3848674 1973172 1973172 plaintiff Kebill Robert (legal representative) 601181 601181 Kebill, Robert, of Wulpett, executor of 0
3848686 1973177 1973177 plaintiff Kebyll Robert (legal representative) 601181 601181 Kebyll, Robert, of Wulpett, executor of 0
3865011 1978499 1978499 plaintiff May William tanner 601181 601181 May, William, of Wulpett, tanner 0
3865013 1978499 1978499 defendant Flode Simon husbandman 601181 601181 Flode, Simon, of Wulpett, husbandman 0
3865019 1978501 1978501 plaintiff Maye William tanner 601181 601181 Maye, William, of Wulpett, tanner 0
3865021 1978501 1978501 defendant Turnour John husbandman 601181 601181 Turnour, John, of Wulpett, husbandman 0
3892820 1987848 1987848 defendant Gage Robert tanner 601181 601181 Gage, Robert, of Wulpett, tanner 0
3892821 1987848 1987848 defendant Coke Richard laborer 601181 601181 Coke, Richard, of Wulpett, laborer 1
3892823 1987849 1987849 defendant Wade John husbandman 601181 601181 Wade, John, of Wulpett, husbandman 0
3994496 2022780 2022780 defendant Harrys Gilbert husbandman 601181 601181 Harrys, Gilbert, of Wulpett, husbandman 2
3994497 2022780 2022780 defendant Turner Edward sherman 601181 601181 Turner, Edward, of Wulpett, sherman 3
4015411 2030206 2030206 defendant Unger Thomas husbandman 601181 601181 Unger, Thomas, of Wulpett, husbandman 1
4047944 2041710 2041710 defendant Cristmas Thomas clerk 601181 601181 Cristmas, Thomas, of Wulpett, clerk 2
4126413 2069734 2069734 defendant Crosse Roger shoemaker 601181 601181 Crosse, Roger, of Wulpett, shoemaker 0
4126414 2069734 2069734 defendant Mathewe John shoemaker 601181 601181 Mathewe, John, of Wulpett, shoemaker 1
4234479 2107602 2107602 defendant Hunte Henry tanner 601181 601181 Hunte, Henry, of Wulpett, tanner 1
4397113 2163603 2163603 defendant Smyth Francis gent 601181 601181 Smyth, Francis, of Wulpett, gent 0
4965737 2346679 2346679 defendant Lenyng or Levyng Richard cordwainer 601181 601181 Lenyng or Levyng, Richard, of Wulpett, cordwainer 0
5566697 2524856 2524856 plaintiff Copynger Robert (legal representative) 601181 601181 Copynger, Robert, of Wulpett, executor of 0
5598996 2534566 2534566 defendant Andrew John husbandman 601181 601181 Andrew, John, of Wulpett, husbandman 1
5598997 2534566 2534566 defendant Andrewe Thomas husbandman 601181 601181 Andrewe, Thomas, of Wulpett, husbandman 2

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