names

25 rows where place_id = 592597

✎ 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
3608209 1870224 1870224 defendant Felippes John clothmaker 592597 592597 Felippes, John, of Monks Illegh, clothmaker 1
3624166 1875089 1875089 defendant Isbell William husbandman 592597 592597 Isbell, William, of Monks Illegh, husbandman 1
4508557 2203152 2203152 defendant Bonde John tailor 592597 592597 Bonde, John, of Monks Illegh, tailor 5
4514537 2204967 2204967 defendant Pager William farmer 592597 592597 Pager, William, of Monks Illegh, farmer 0
4591629 2228739 2228739 defendant Blok Richard   592597 592597 Blok, Richard, of Monks Illegh 1
4682199 2260054 2260054 defendant Webbe Joan widow 592597 592597 Webbe, Joan, of Monks Illegh, widow 0
4998871 2356546 2356546 defendant Alysaunder William fuller 592597 592597 Alysaunder, William, of Monks Illegh, fuller 0
5004449 2358197 2358197 defendant Lys Robert husbandman 592597 592597 Lys, Robert, of Monks Illegh, husbandman 0
5113698 2390400 2390400 defendant Alysaundre Richard yeoman 592597 592597 Alysaundre, Richard, of Monks Illegh, yeoman 0
5113699 2390400 2390400 defendant Prynchat Simon husbandman 592597 592597 Prynchat, Simon, of Monks Illegh, husbandman 1
5202923 2416618 2416618 defendant Astele William weaver 592597 592597 Astele, William, of Monks Illegh, weaver 0
5282940 2440073 2440073 defendant Fryday Thomas husbandman 592597 592597 Fryday, Thomas, of Monks Illegh, husbandman 0
5282941 2440073 2440073 defendant Cobold Thomas loader 592597 592597 Cobold, Thomas, of Monks Illegh, loader 1
5286524 2441067 2441067 plaintiff Tylere Thomas   592597 592597 Tylere, Thomas, of Monks Illegh 1
5286527 2441068 2441068 plaintiff Tylere Thomas   592597 592597 Tylere, Thomas, of Monks Illegh 1
5286530 2441069 2441069 plaintiff Tylere Thomas   592597 592597 Tylere, Thomas, of Monks Illegh 1
5334482 2455387 2455387 defendant Shippe Robert fuller 592597 592597 Shippe, Robert, of Monks Illegh, fuller 1
5344328 2458405 2458405 defendant Shoppe Robert fuller 592597 592597 Shoppe, Robert, of Monks Illegh, fuller 1
5349362 2459930 2459930 plaintiff Calle John   592597 592597 Calle, John, of Monks Illegh 0
5371470 2466659 2466659 defendant Turnour Adam husbandman 592597 592597 Turnour, Adam, of Monks Illegh, husbandman 0
5389120 2471937 2471937 defendant Turnour Adam husbandman 592597 592597 Turnour, Adam, of Monks Illegh, husbandman 0
5401825 2475585 2475585 defendant Turnour Adam husbandman 592597 592597 Turnour, Adam, of Monks Illegh, husbandman 0
5430649 2484104 2484104 defendant Turnour Adam husbandman 592597 592597 Turnour, Adam, of Monks Illegh, husbandman 0
5502745 2505773 2505773 defendant Schoppe Robert fuller 592597 592597 Schoppe, Robert, of Monks Illegh, fuller 3
5516873 2510100 2510100 defendant Schoppe Robert fuller 592597 592597 Schoppe, Robert, of Monks Illegh, fuller 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);