names

42 rows where place_id = 626287

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3769163 1948012 1948012 defendant Scotte John husbandman 626287 626287 Scotte, John, of Witlesford, husbandman 0
3770462 1948442 1948442 defendant Eye or Gye alias Flexman John   626287 626287 Eye or Gye alias Flexman, John, of Witlesford, millwright 1
3771467 1948767 1948767 defendant Rande William yeoman 626287 626287 Rande, William, of Witlesford, yeoman 0
4120560 2067631 2067631 defendant Barton John maltster 626287 626287 Barton, John, of Witlesford, yeoman, maltster 0
4272423 2120352 2120352 defendant Twynne Christopher husbandman 626287 626287 Twynne, Christopher, of Witlesford, husbandman 0
4272424 2120352 2120352 defendant Newton Thomas glover 626287 626287 Newton, Thomas, of Witlesford, glover 1
4272529 2120388 2120388 defendant Smythe John glover 626287 626287 Smythe, John, of Witlesford, glover 2
4641639 2243656 2243656 defendant Cook Stephen carpenter 626287 626287 Cook, Stephen, of Witlesford, carpenter 0
4641640 2243656 2243656 defendant Cook Richard smith 626287 626287 Cook, Richard, of Witlesford, smith 1
4661403 2249391 2249391 defendant Brounyng Maud brewster 626287 626287 Brounyng, Maud, of Witlesford, brewster 0
4661405 2249391 2249391 defendant Fullere John husbandman 626287 626287 Fullere, John, of Witlesford, husbandman 2
4661409 2249392 2249392 defendant Fullere John husbandman 626287 626287 Fullere, John, of Witlesford, husbandman 2
4692250 2263091 2263091 defendant Godyn John husbandman 626287 626287 Godyn, John, of Witlesford, husbandman 0
4722155 2272260 2272260 defendant Dulkyns John husbandman 626287 626287 Dulkyns, John, of Witlesford, husbandman 0
4722566 2272372 2272372 defendant Janyn John laborer 626287 626287 Janyn, John, of Witlesford, laborer 0
4756684 2282454 2282454 defendant Gellesson William husbandman 626287 626287 Gellesson, William, of Witlesford, husbandman 0
4756685 2282454 2282454 defendant Sandre John   626287 626287 Sandre, John, of Witlesford 1
4806687 2298301 2298301 defendant Godyn John yeoman 626287 626287 Godyn, John, of Witlesford, yeoman 0
4811454 2299693 2299693 defendant Beste Thommas laborer 626287 626287 Beste, Thommas, of Witlesford, laborer 0
4811456 2299693 2299693 defendant Rose John husbandman 626287 626287 with Rose, John, of Witlesford, husbandman 2
4811457 2299693 2299693 defendant Geffrey John laborer 626287 626287 Geffrey, John, of Witlesford, laborer 3
4811462 2299695 2299695 defendant Beste Thomas laborer 626287 626287 Beste, Thomas, of Witlesford, laborer 0
4811467 2299696 2299696 defendant Beste Thomas laborer 626287 626287 Beste, Thomas, of Witlesford, laborer 2
4837330 2307617 2307617 defendant Hunt John, sen husbandman 626287 626287 Hunt, John, sen, of Witlesford, husbandman 2
4837332 2307617 2307617 defendant Soon John husbandman 626287 626287 Soon, John, of Witlesford, husbandman 4
4864564 2315888 2315888 defendant Hunte John, junior husbandman 626287 626287 Hunte, John, junior, of Witlesford, husbandman 3
4874246 2318890 2318890 defendant Millere alias Webbe John miller 626287 626287 Millere alias Webbe, John, of Witlesford, miller 0
4894654 2324998 2324998 defendant Janyn John laborer 626287 626287 Janyn, John, of Witlesford, laborer 0
4901788 2327165 2327165 defendant Janyn John laborer 626287 626287 Janyn, John, of Witlesford, laborer 0
4942995 2339786 2339786 defendant Beste John, senior thatcher 626287 626287 Beste, John, senior, of Witlesford, thatcher 3
4942996 2339786 2339786 defendant Beste John, junior husbandman 626287 626287 Beste, John, junior, of Witlesford, husbandman 4
4983712 2352057 2352057 defendant Hunte John yeoman 626287 626287 Hunte, John, of Witlesford, yeoman 0
4983714 2352057 2352057 defendant Shipperd John cordwainer 626287 626287 Shipperd, John, of Witlesford, cordwainer 2
4983717 2352058 2352058 defendant Hunte John yeoman 626287 626287 Hunte, John, of Witlesford, yeoman 0
4983719 2352058 2352058 defendant Shippard John cordwainer 626287 626287 Shippard, John, of Witlesford, cordwainer 2
5043483 2369672 2369672 defendant Hunt John carpenter 626287 626287 Hunt, John, of Witlesford, carpenter 3
5098140 2385888 2385888 defendant Brome John, senior husbandman 626287 626287 Brome, John, senior, of Witlesford, husbandman 0
5108809 2389004 2389004 defendant Duxfeld John husbandman 626287 626287 Duxfeld, John, of Witlesford,husbandman 2
5394530 2473495 2473495 defendant Style John carpenter 626287 626287 Style, John, of Witlesford, carpenter 2
5557627 2522188 2522188 defendant Neweton Nicholas husbandman 626287 626287 Neweton, Nicholas, of Witlesford, husbandman 1
5630185 2553446 2553446 defendant Godyn John, junior yeoman 626287 626287 Godyn, John, junior, of Witlesford, yeoman 2
5630189 2553447 2553447 defendant Godyn John, junior yeoman 626287 626287 Godyn, John, junior, of Witlesford, yeoman 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);