names

22 rows where place_id = 623273

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3751573 1942405 1942405 defendant Hardeman Roger yeoman 623273 623273 Hardeman, Roger, of Warrington, Lancs, yeoman 0
3981759 2018235 2018235 defendant Marbury Robert gent 623273 623273 Marbury, Robert, of Warrington, Lancs, gent 1
4004089 2026235 2026235 defendant Cartwright Richard yeoman 623273 623273 Cartwright, Richard, of Warrington, Lancs, yeoman 0
4061363 2046467 2046467 plaintiff Dunbavyne Anthony   623273 623273 Dunbavyne, Anthony, of Warrington, Lancs, woollen draper 0
4094356 2058322 2058322 defendant Grace Thomas chapman 623273 623273 Grace, Thomas, of Warrington, Lancs, chapman 0
4099018 2059974 2059974 defendant Sanckye or Saukye Thomas, junior gent 623273 623273 Sanckye or Saukye, Thomas, junior, of Warrington, Lancs, gent 2
4112879 2064875 2064875 defendant Sadler John chapman 623273 623273 Sadler, John, of Warrington, Lancs, chapman 0
4141451 2075170 2075170 defendant Gryme Henry gent 623273 623273 Gryme, Henry, of Warrington, Lancs, gent 0
4162880 2082545 2082545 defendant Grysse or Grice Richard yeoman 623273 623273 Grysse or Grice, Richard, of Warrington, Lancs, yeoman 0
4162882 2082546 2082546 defendant Grysse or Grice Thomas yeoman 623273 623273 Grysse or Grice, Thomas, of Warrington, Lancs, yeoman 0
4207289 2098103 2098103 defendant Aspenwall Humphrey vintner 623273 623273 Aspenwall, Humphrey, of Warrington, Lancs, vintner 0
4240283 2109725 2109725 defendant Chaddocke John blacksmith 623273 623273 Chaddocke, John, of Warrington, Lancs, blacksmith 0
4257239 2115400 2115400 defendant Spencer Robert yeoman 623273 623273 Spencer, Robert, of Warrington, Lancs, yeoman 2
4269477 2119380 2119380 defendant Spencer Robert yeoman 623273 623273 Spencer, Robert, of Warrington, Lancs, yeoman 2
4269480 2119381 2119381 defendant Spencer Robert yeoman 623273 623273 Spencer, Robert, of Warrington, Lancs, yeoman 1
4273744 2120763 2120763 defendant Chaddocke John blacksmith 623273 623273 Chaddocke, John, of Warrington, Lancs, blacksmith 0
4318162 2136460 2136460 defendant Shert John yeoman 623273 623273 Shert, John, of Warrington, Lancs, yeoman 1
4342377 2144606 2144606 defendant Shorte John vintner 623273 623273 Shorte, John, of Warrington, Lancs, vintner 2
4349425 2147062 2147062 defendant Dowlmon Robert chapman 623273 623273 Dowlmon, Robert, of Warrington, Lancs, chapman 1
4366255 2152971 2152971 defendant Short John vintner 623273 623273 Short, John, of Warrington, Lancs, vintner 3
4384574 2159531 2159531 defendant Tildesley Hugh gent 623273 623273 Tildesley, Hugh, of Warrington, Lancs, gent 0
4387518 2160468 2160468 defendant Sherte John innholder 623273 623273 Sherte, John, of Warrington, Lancs, innholder 1

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