names

17 rows where place_id = 596502

✎ 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
3625052 1875368 1875368 defendant Payn John yeoman 596502 596502 Payn, John, of Wenhaston, yeoman 0
3787239 1953802 1953802 defendant Jefferys William butcher 596502 596502 Jefferys, William, of Wenhaston, butcher 1
3888581 1986440 1986440 defendant Gylon William husbandman 596502 596502 Gylon, William, of Wenhaston, husbandman 5
3888583 1986440 1986440 defendant Warn Thomas laborer 596502 596502 Warn, Thomas, of Wenhaston, laborer 7
3902632 1991111 1991111 defendant Gybon William husbandman 596502 596502 Gybon, William, of Wenhaston, husbandman 5
3902634 1991111 1991111 defendant Warne Thomas laborer 596502 596502 Warne, Thomas, of Wenhaston, laborer 7
3904322 1991694 1991694 plaintiff Hawe Robert (legal representative) 596502 596502 Hawe, Robert, of Wenhaston, executor of 0
3916905 1996019 1996019 defendant Fox George baker 596502 596502 Fox, George, of Wenhaston, baker 2
3943553 2004863 2004863 defendant Broke John husbandman 596502 596502 Broke, John, of Wenhaston, husbandman 1
3962142 2011340 2011340 defendant Tradescant or Tradestant Richard husbandman 596502 596502 Tradescant or Tradestant, Richard, of Wenhaston, husbandman 0
4068400 2048998 2048998 defendant Bennett Roger tanner 596502 596502 Bennett, Roger, of Wenhaston, tanner 0
4072336 2050408 2050408 defendant Watson William butcher 596502 596502 Watson, William, of Wenhaston, butcher 0
4108278 2063228 2063228 defendant Skeete Thomas husbandman 596502 596502 Skeete, Thomas, of Wenhaston, husbandman 0
4121255 2067897 2067897 defendant Uttyng John butcher 596502 596502 Uttyng, John, of Wenhaston, butcher 1
4122440 2068334 2068334 defendant Gyrlyng William butcher 596502 596502 Gyrlyng, William, of Wenhaston, butcher 0
4239430 2109412 2109412 defendant Allyn Thomas husbandman 596502 596502 Allyn, Thomas, of Wenhaston, husbandman 0
4283613 2124176 2124176 defendant Logett John butcher 596502 596502 Logett, John, of Wenhaston, 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);