names

26 rows where place_id = 757558

✎ 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
4446962 2183965 2183965 plaintiff Drapper Henry   757558 757558 Drapper, Henry, of Yarum 0
4447391 2184095 2184095 defendant Preston Richard de   757558 757558 Preston, Richard de, of Yarum 0
4480997 2194732 2194732 defendant Olyver Robert   757558 757558 Olyver, Robert, of Yarum 0
4480998 2194732 2194732 defendant Coke William   757558 757558 Coke, William, of Yarum 1
4500204 2200696 2200696 defendant Doreham John   757558 757558 Doreham, John, of Yarum 2
4560190 2219134 2219134 defendant Ayte John   757558 757558 Ayte, John, of Yarum 0
4560191 2219134 2219134 defendant Laurenson John   757558 757558 Laurenson, John, of Yarum 1
4560192 2219134 2219134 defendant Ayte William   757558 757558 Ayte, William, of Yarum 2
4570913 2222469 2222469 defendant Kirkeby William de   757558 757558 Kirkeby, William de, of Yarum 0
4603773 2232364 2232364 defendant Webster Robert   757558 757558 Webster, Robert, of Yarum 4
4603776 2232364 2232364 defendant Scolemaister Henry   757558 757558 Scolemaister, Henry, of Yarum 7
4678589 2258909 2258909 defendant Paule William yeoman 757558 757558 Paule, William, of Yarum, yeoman 0
4691172 2262759 2262759 defendant Scolemaystre Henry   757558 757558 Scolemaystre, Henry, of Yarum, school master 3
4761865 2284054 2284054 defendant Cook Maud widow 757558 757558 Cook, Maud, of Yarum, widow 1
4782178 2290425 2290425 defendant Patrykson William laborer 757558 757558 Patrykson, William, of Yarum, laborer 0
4782180 2290425 2290425 defendant Huton John shoemaker 757558 757558 Huton, John, of Yarum, shoemaker 2
4988405 2353499 2353499 defendant Spycer William spicer 757558 757558 Spycer, William, of Yarum, spicer 14
4988407 2353499 2353499 defendant Webster John weaver 757558 757558 Webster, John, of Yarum, weaver 16
4988426 2353501 2353501 defendant Webster John weaver 757558 757558 Webster, John, of Yarum, weaver 13
5073417 2378533 2378533 defendant Gebon Robert chapman 757558 757558 Gebon, Robert, of Yarum, chapman 2
5076129 2379363 2379363 defendant Selby Thomas mercer 757558 757558 Selby, Thomas, of Yarum, mercer 0
5090461 2383590 2383590 defendant Loweson John husbandman 757558 757558 Loweson, John, of Yarum, husbandman 0
5090462 2383590 2383590 defendant Seton William, junior barker 757558 757558 Seton, William, junior, of Yarum, barker 1
5090463 2383590 2383590 defendant Adyngham Robert weaver 757558 757558 Adyngham, Robert, of Yarum, weaver 2
5090464 2383590 2383590 defendant Mynsman Thomas weaver 757558 757558 Mynsman, Thomas, of Yarum, weaver 3
5384647 2470695 2470695 defendant Trafford Ralph yeoman 757558 757558 Trafford, Ralph, of Yarum, yeoman 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);