names

27 rows where place_id = 615564

✎ 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
3709500 1929275 1929275 defendant Chesten Thomas husbandman 615564 615564 Chesten, Thomas, of Ereswell, husbandman 0
4039684 2038805 2038805 defendant Deresley Thomas, senior husbandman 615564 615564 Deresley, Thomas, senior, of Ereswell, husbandman 0
4039685 2038805 2038805 defendant Deresley Thomas, junior laborer 615564 615564 Deresley, Thomas, junior, of Ereswell, laborer 1
4039686 2038805 2038805 defendant Deresley Richard laborer 615564 615564 Deresley, Richard, of Ereswell, laborer 2
4486887 2196614 2196614 defendant Frende James thatcher 615564 615564 Frende, James, of Ereswell, thatcher 0
4506433 2202511 2202511 plaintiff Thorndon John   615564 615564 Thorndon, John, of Ereswell, on his own account 0
4581978 2225805 2225805 defendant Bullok John   615564 615564 Bullok, John, of Ereswell, son of John 8
4596456 2230140 2230140 defendant Helyrs John   615564 615564 Helyrs, John, of Ereswell 0
4623087 2238199 2238199 plaintiff Martyn Robert   615564 615564 Martyn, Robert, of Ereswell 0
4623089 2238199 2238199 defendant Daunce Reginald   615564 615564 Daunce, Reginald, of Ereswell 1
4624238 2238567 2238567 plaintiff Nene William   615564 615564 Nene, William, of Ereswell 0
4636577 2242266 2242266 defendant Pryour John   615564 615564 Pryour, John, of Ereswell 10
4636578 2242266 2242266 defendant Grene John   615564 615564 Grene, John, of Ereswell 11
4640836 2243418 2243418 defendant Gilberd John   615564 615564 Gilberd, John, of Ereswell 4
4645413 2244727 2244727 plaintiff Nene William   615564 615564 Nene, William, of Ereswell 0
4682357 2260104 2260104 plaintiff Neve Thomas   615564 615564 Neve, Thomas, of Ereswell, parson 0
4753285 2281409 2281409 defendant Rastolf John   615564 615564 Rastolf, John, of Ereswell, parson 0
4775053 2288191 2288191 plaintiff West Robert (legal representative) 615564 615564 West, Robert, of Ereswell, executors of 0
5155604 2402794 2402794 plaintiff Mathewe William   615564 615564 Mathewe, William, of Ereswell 0
5172168 2407580 2407580 plaintiff Mathewe William   615564 615564 Mathewe, William, of Ereswell 0
5427045 2483028 2483028 defendant Andrewe John husbandman 615564 615564 Andrewe, John, of Ereswell, husbandman 0
5444945 2488373 2488373 defendant Thornton John husbandman 615564 615564 Thornton, John, of Ereswell, husbandman 2
5445010 2488394 2488394 defendant Andrewe John   615564 615564 Andrewe, John, of Ereswell 0
5480668 2499181 2499181 defendant Thorndon John husbandman 615564 615564 Thorndon, John, of Ereswell, husbandman 3
5573124 2526692 2526692 defendant Teryngton Robert woolman 615564 615564 Teryngton, Robert, of Ereswell, woolman 0
5615598 2548668 2548668 defendant Middelhorn John   615564 615564 Middelhorn, John, of Ereswell 0
5633599 2554504 2554504 defendant Hay Thomas woolman 615564 615564 Hay, Thomas, of Ereswell, woolman 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);