names

29 rows where place_id = 591892

✎ 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
3605906 1869509 1869509 defendant Herryson Thomas clerk 591892 591892 Herryson, Thomas, of Brysle, clerk 2
4529518 2209515 2209515 defendant Coupere Thomas   591892 591892 Coupere, Thomas, of Brysle 0
4554767 2217420 2217420 plaintiff Hamond John   591892 591892 Hamond, John, of Brysle, son of Thomas 1
4554773 2217421 2217421 plaintiff Hamond John   591892 591892 Hamond, John, of Brysle, son of Thomas 1
4809269 2299072 2299072 defendant Fendy John yeoman 591892 591892 Fendy, John, of Brysle, yeoman 2
4863511 2315558 2315558 plaintiff Hamond John   591892 591892 Hamond, John, of Brysle 1
4866570 2316506 2316506 defendant Baron Thomas husbandman 591892 591892 Baron, Thomas, of Brysle, husbandman 0
4866575 2316507 2316507 defendant Whitefote Henry husbandman 591892 591892 Whitefote, Henry, of Brysle, husbandman 0
4866577 2316508 2316508 defendant Whitefote Henry husbandman 591892 591892 Whitefote, Henry, of Brysle, husbandman 0
4950647 2342167 2342167 defendant Paxman Geoffrey husbandman 591892 591892 Paxman, Geoffrey, of Brysle, husbandman 0
4955867 2343722 2343722 plaintiff Man Thomas yeoman 591892 591892 Man, Thomas, of Brysle, yeoman 1
4975023 2349505 2349505 defendant Colyn John   591892 591892 Colyn, John, of Brysle, collar maker 2
5035168 2367150 2367150 defendant Copuldyk William esq 591892 591892 Copuldyk, William, of Brysle, esq 0
5110873 2389576 2389576 defendant Sylvester Richard carpenter 591892 591892 Sylvester, Richard, of Brysle, carpenter 0
5126630 2394263 2394263 defendant Nobys or Novys Robert yeoman 591892 591892 Nobys or Novys, Robert, of Brysle, yeoman 0
5126631 2394263 2394263 defendant Sylvester Richard yeoman 591892 591892 Sylvester, Richard, of Brysle, yeoman 1
5220667 2421739 2421739 defendant Grys or Erys Roger husbandman 591892 591892 Grys or Erys, Roger, of Brysle, husbandman 0
5241849 2427814 2427814 defendant Gryt Roger husbandman 591892 591892 Gryt, Roger, of Brysle, husbandman 4
5279360 2439052 2439052 defendant Roo William yeoman 591892 591892 Roo, William, of Brysle, yeoman 7
5308822 2447679 2447679 defendant Wodrove Thomas husbandman 591892 591892 Wodrove, Thomas, of Brysle, husbandman 0
5337244 2456209 2456209 defendant Barker Robert yeman 591892 591892 Barker, Robert, of Brysle, yeman 0
5353014 2461031 2461031 defendant Playford John husbandman 591892 591892 Playford, John, of Brysle, husbandman 2
5381638 2469801 2469801 defendant Ere John husbandman 591892 591892 Ere, John, of Brysle, husbandman 2
5445566 2488570 2488570 defendant Reed William husbandman 591892 591892 Reed, William, of Brysle, husbandman 0
5445568 2488570 2488570 defendant Neell John carpenter 591892 591892 Neell, John, of Brysle, carpenter 2
5483495 2500010 2500010 defendant Est John husbandman 591892 591892 Est, John, of Brysle, husbandman 1
5510170 2508017 2508017 defendant Est John husbandman 591892 591892 Est, John, of Brysle, husbandman 0
5544821 2518490 2518490 defendant Est William butcher 591892 591892 Est, William, of Brysle, butcher 0
5633644 2554521 2554521 defendant Souter John husbandman 591892 591892 Souter, John, of Brysle, husbandman 3

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);