names

12 rows where place_id = 650321

✎ 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
3911489 1994162 1994162 defendant Jenkys Henry mercer 650321 650321 Jenkys, Henry, of Penbrugge, mercer 0
4627452 2239517 2239517 plaintiff Rode Rogoer   650321 650321 Rode, Rogoer, of Penbrugge 0
4745994 2279329 2279329 plaintiff Hakeluyt Thomas   650321 650321 Hakeluyt, Thomas, of Penbrugge, on his own account 0
4771856 2287174 2287174 defendant Neweman William husbandman 650321 650321 Neweman, William, of Penbrugge, husbandman 0
4787599 2292194 2292194 plaintiff Hakeluyte Thomas   650321 650321 Hakeluyte, Thomas, of Penbrugge 0
4822529 2303120 2303120 defendant Tanner John tanner 650321 650321 Tanner, John, of Penbrugge, tanner 0
5023430 2363760 2363760 plaintiff Hareslet John (legal representative) 650321 650321 Hareslet, John, of Penbrugge, laborer, executor of 0
5303731 2446111 2446111 defendant Brace Joan widow 650321 650321 Brace, Joan, of Penbrugge, widow 0
5303732 2446111 2446111 defendant Brace Edmund gent 650321 650321 Brace, Edmund, of Penbrugge, gent 1
5629213 2553111 2553111 defendant Haule Mathew drover 650321 650321 Haule, Mathew, of Penbrugge, drover 1
5634792 2554879 2554879 plaintiff Walker John   650321 650321 Walker, John, of Penbrugge 0
5634793 2554879 2554879 defendant Hanley or Hauley Mathew husbandman 650321 650321 Hanley or Hauley, Mathew, of Penbrugge, husbandman 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);