names

36 rows where place_id = 617553

✎ 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
3720109 1932566 1932566 defendant Brown William husbandman 617553 617553 Brown, William, of Snelston, husbandman 1
3738989 1938400 1938400 defendant Broun William husbandman 617553 617553 Broun, William, of Snelston, husbandman 0
3738990 1938400 1938400 defendant Assheton Lawrence husbandman 617553 617553 Assheton, Lawrence, of Snelston, husbandman 1
3738992 1938401 1938401 defendant Broun William husbandman 617553 617553 Broun, William, of Snelston, husbandman 0
3738993 1938401 1938401 defendant Asshton Lawrence husbandman 617553 617553 Asshton, Lawrence, of Snelston, husbandman 1
3767960 1947615 1947615 defendant Assheton Lawrence husbandman 617553 617553 Assheton, Lawrence, of Snelston, husbandman 0
3774561 1949769 1949769 defendant Sutton John yeoman 617553 617553 Sutton, John, of Snelston, yeoman 2
3774565 1949770 1949770 defendant Sutton John yeoman 617553 617553 Sutton, John, of Snelston, yeoman 2
3803028 1958847 1958847 defendant Sutton Thurstan yeoman 617553 617553 Sutton, Thurstan, of Snelston, yeoman 1
3963140 2011708 2011708 defendant Loute or Lonte Trustram husbandman 617553 617553 Loute or Lonte, Trustram, of Snelston, husbandman 0
3963141 2011708 2011708 defendant Loute or Lonte John laborer 617553 617553 Loute or Lonte, John, of Snelston, laborer 1
4185074 2090285 2090285 defendant Cumber Thomas husbandman 617553 617553 Cumber, Thomas, of Snelston, husbandman 1
4526311 2208516 2208516 defendant Throweley Margery (legal representative) 617553 617553 Throweley, Margery, of Snelston, formerly wife of John, executor of 5
4526325 2208519 2208519 defendant Throweley Mareda (legal representative) 617553 617553 Throweley, Mareda, of Snelston, formerly wife of John, executor of 5
4803411 2297258 2297258 plaintiff Bartelot John (legal representative) 617553 617553 Bartelot, John, of Snelston, executors of 0
4803412 2297258 2297258 plaintiff Howessone Henry   617553 617553 (Howessone, Henry, of Snelston 1
4803436 2297263 2297263 plaintiff Bartelut John (legal representative) 617553 617553 Bartelut, John, of Snelston, executors of 0
4977174 2350130 2350130 defendant Forman John yeoman 617553 617553 Forman, John, of Snelston, yeoman 3
4980924 2351230 2351230 defendant Helay James husbandman 617553 617553 Helay, James, of Snelston, husbandman 3
4987801 2353317 2353317 defendant Sutton Benedict husbandman 617553 617553 Sutton, Benedict, of Snelston, husbandman 2
5354357 2461428 2461428 defendant Assheton Richard husbandman 617553 617553 Assheton, Richard, of Snelston, husbandman 0
5354358 2461428 2461428 defendant Martyne Thomas husbandman 617553 617553 Martyne, Thomas, of Snelston, husbandman 1
5418506 2480462 2480462 defendant Dyne Richard husbandman 617553 617553 Dyne, Richard, of Snelston, husbandman 0
5436451 2485836 2485836 defendant Dyne Richard husbandman 617553 617553 Dyne, Richard, of Snelston, husbandman 0
5436453 2485837 2485837 defendant Dyne Richard husbandman 617553 617553 Dyne, Richard, of Snelston, husbandman 0
5436455 2485838 2485838 defendant Dyne Richard husbandman 617553 617553 Dyne, Richard, of Snelston, husbandman 0
5527285 2513112 2513112 defendant Todde Henry chaplain 617553 617553 Todde, Henry, of Snelston, chaplain 0
5538744 2516601 2516601 defendant Cotes Henry laborer 617553 617553 Cotes, Henry, of Snelston, laborer 0
5538745 2516601 2516601 defendant Fayrechyld Thomas miller 617553 617553 Fayrechyld, Thomas, of Snelston, miller 1
5580042 2528838 2528838 defendant Sutton Nicholas husbandman 617553 617553 Sutton, Nicholas, of Snelston, husbandman 0
5583086 2529783 2529783 defendant Lout Thurstan yeoman 617553 617553 Lout, Thurstan, of Snelston, yeoman 0
5583087 2529783 2529783 defendant Cotys Henry yeoman 617553 617553 Cotys, Henry, of Snelston, yeoman 1
5583088 2529783 2529783 defendant Conhope John laborer 617553 617553 Conhope, John, of Snelston, laborer 2
5598607 2534445 2534445 defendant Cotys Henry yeoman 617553 617553 Cotys, Henry, of Snelston, yeoman 0
5598608 2534445 2534445 defendant Conhope or Couhope John laborer 617553 617553 Conhope or Couhope, John, of Snelston, laborer 1
5598629 2534450 2534450 defendant Todde Robert husbandman 617553 617553 Todde, Robert, of Snelston, 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);