names

19 rows where place_id = 623866

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3754776 1943450 1943450 defendant Bowdon William grocer 623866 623866 Bowdon, William, of Chelmsford, grocer 0
3888680 1986469 1986469 defendant Adams Thomas stringer 623866 623866 Adams, Thomas, of Chelmsford, stringer 1
3898765 1989790 1989790 defendant Samford John smith 623866 623866 Samford, John, of Chelmsford, smith 0
3898766 1989790 1989790 defendant Clarke Christopher shoemaker 623866 623866 Clarke, Christopher, of Chelmsford, shoemaker 1
3901970 1990887 1990887 defendant Auncell John butcher 623866 623866 Auncell, John, of Chelmsford, butcher 0
3904275 1991675 1991675 defendant Sadlyngton William husbandman 623866 623866 Sadlyngton, William, of Chelmsford, husbandman 0
3905366 1992063 1992063 plaintiff Keteryche William   623866 623866 Keteryche, William, of Chelmsford, wheelwright 0
3908472 1993130 1993130 defendant Bowden William tallowchandler 623866 623866 Bowden, William, of Chelmsford, tallowchandler 1
3911487 1994161 1994161 defendant Dowe John baker 623866 623866 Dowe, John, of Chelmsford, baker 0
4066877 2048450 2048450 plaintiff Hubberd Thomas   623866 623866 Hubberd, Thomas, of Chelmsford 0
4086707 2055536 2055536 plaintiff Bridges Mathew gent 623866 623866 Bridges, Mathew, of Chelmsford, gent 0
4093625 2058042 2058042 defendant Hubert Thomas   623866 623866 Hubert, Thomas, of Chelmsford, linen draper 1
4276919 2121857 2121857 defendant Burles Thomas husbandman 623866 623866 Burles, Thomas, of Chelmsford, husbandman 0
4321390 2137574 2137574 defendant Huytson Robert clerk 623866 623866 Huytson, Robert, of Chelmsford, clerk 2
4355908 2149285 2149285 defendant Stoe John   623866 623866 Stoe, John, of Chelmsford, tincker, or of Colchester, jerkin maker 1
4438926 2181466 2181466 defendant Staleworth John   623866 623866 Staleworth, John, of Chelmsford 2
4591991 2228850 2228850 defendant Donyngton John   623866 623866 Donyngton, John, of Chelmsford 0
4714742 2269940 2269940 defendant Savage William   623866 623866 Savage, William, of Chelmsford, wool man 1
5430042 2483918 2483918 defendant Bocher Thomas butcher 623866 623866 Bocher, Thomas, of Chelmsford, butcher 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);