names

29 rows where place_id = 627482

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3776487 1950400 1950400 defendant Byssetor Thomas husbandman 627482 627482 Byssetor, Thomas, of Brentwood, Essex, husbandman 0
3852890 1974518 1974518 defendant Baker alias Ingleby William yeoman 627482 627482 Baker alias Ingleby, William, of Brentwood, Essex, yeoman 1
3852893 1974519 1974519 defendant Baker alias Ingleby William yeoman 627482 627482 Baker alias Ingleby, William, of Brentwood, Essex, yeoman 1
3900872 1990521 1990521 defendant Baker William yeoman 627482 627482 Baker, William, of Brentwood, Essex, yeoman 2
3900881 1990523 1990523 defendant Baker William yeoman 627482 627482 Baker, William, of Brentwood, Essex, yeoman 2
3903911 1991546 1991546 defendant Salmond Robert yeoman 627482 627482 (Salmond, Robert, of Brentwood, Essex, yeoman 1
3911634 1994213 1994213 defendant Carter Henry yeoman 627482 627482 Carter, Henry, of Brentwood, Essex, yeoman 1
3954922 2008786 2008786 defendant Bysshoppe John yeoman 627482 627482 Bysshoppe, John, of Brentwood, Essex, yeoman 1
3989991 2021172 2021172 defendant Wynterbotton John yeoman 627482 627482 Wynterbotton, John, of Brentwood, Essex, yeoman 2
4022501 2032773 2032773 defendant Whyghte John yeoman 627482 627482 Whyghte, John, of Brentwood, Essex, yeoman 0
4086428 2055428 2055428 defendant Wall John tailor 627482 627482 Wall, John, of Brentwood, Essex, tailor 0
4086432 2055430 2055430 defendant Wall John tailor 627482 627482 Wall, John, of Brentwood, Essex, tailor 0
4086434 2055431 2055431 defendant Wall John tailor 627482 627482 Wall, John, of Brentwood, Essex, tailor 0
4179935 2088461 2088461 defendant Dyer Richard yeoman 627482 627482 Dyer, Richard, of Brentwood, Essex, yeoman 0
4210573 2099253 2099253 defendant Harris John yeoman 627482 627482 Harris, John, of Brentwood, Essex, yeoman 2
4223510 2103713 2103713 defendant Ponde Robert yeoman 627482 627482 Ponde, Robert, of Brentwood, Essex, yeoman 2
4263522 2117463 2117463 defendant Pounde or Ponde Robert yeoman 627482 627482 Pounde or Ponde, Robert, of Brentwood, Essex, yeoman 2
4337762 2142956 2142956 defendant Skynner Richard glover 627482 627482 Skynner, Richard, of Brentwood, Essex, glover 0
4342102 2144518 2144518 defendant Pryor Francis yeoman 627482 627482 Pryor, Francis, of Brentwood, Essex, yeoman 0
4342775 2144747 2144747 defendant Pryor Francis yeoman 627482 627482 Pryor, Francis, of Brentwood, Essex, yeoman 0
4343406 2144969 2144969 defendant Stewarde Bartholomew chapman 627482 627482 Stewarde, Bartholomew, of Brentwood, Essex, chapman 1
4694620 2263814 2263814 defendant Baynard John skinner 627482 627482 Baynard, John, of Brentwood, Essex, skinner 2
4694857 2263880 2263880 defendant Baynard John skinner 627482 627482 Baynard, John, of Brentwood, Essex, skinner 2
4707266 2267651 2267651 defendant Goldman John yeoman 627482 627482 (Goldman, John, of Brentwood, Essex, yeoman 2
4763888 2284698 2284698 defendant Sele William   627482 627482 Sele, William, of Brentwood, Essex, spice seller 0
4773036 2287538 2287538 defendant Smyth John hosteller 627482 627482 Smyth, John, of Brentwood, Essex, hosteller 0
4841161 2308771 2308771 defendant Richard John yeoman 627482 627482 Richard, John, of Brentwood, Essex, yeoman 2
5210241 2418722 2418722 defendant Staunford Joan widow 627482 627482 Staunford, Joan, of Brentwood, Essex, widow 0
5426100 2482759 2482759 defendant Alyson Richard butcher 627482 627482 Alyson, Richard, of Brentwood, Essex, butcher 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);