names

75 rows where place_id = 590245

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3600355 1867755 1867755 defendant Prouet or Pronet Robert clerk 590245 590245 Prouet or Pronet, Robert, of Benacre, clerk 2
3619560 1873685 1873685 defendant Alderson alias Jekson John painter 590245 590245 Alderson alias Jekson, John, of Benacre, painter 3
3623707 1874948 1874948 plaintiff Smyth William (legal representative) 590245 590245 Smyth, William, of Benacre, executors of 0
3623708 1874948 1874948 plaintiff Smyth Alice widow 590245 590245 (Smyth, Alice, of Benacre, widow 1
3625475 1875506 1875506 defendant Pronet or Provet Robert clerk 590245 590245 Pronet or Provet, Robert, of Benacre, clerk 2
3645254 1908923 1908923 defendant Smyth Richard husbabndman 590245 590245 Smyth, Richard, of Benacre, husbabndman 0
3694747 1924561 1924561 defendant Wryght Richard husbandman 590245 590245 Wryght, Richard, of Benacre, husbandman 0
3695876 1924945 1924945 defendant More Andrew husbandman 590245 590245 More, Andrew, of Benacre, husbandman 1
3849200 1973345 1973345 defendant Mascall John husbandman 590245 590245 Mascall, John, of Benacre, husbandman 3
3870306 1980320 1980320 defendant Amys Thomas husbandman 590245 590245 Amys, Thomas, of Benacre, husbandman 0
3885151 1985286 1985286 defendant Gyrlyng William husbandman 590245 590245 Gyrlyng, William, of Benacre, husbandman 0
3920742 1997285 1997285 defendant Palmer Robert husbandman 590245 590245 Palmer, Robert, of Benacre, husbandman 0
3933742 2001580 2001580 defendant Palmer Robert husbandman 590245 590245 Palmer, Robert, of Benacre, husbandman 1
3949047 2006732 2006732 defendant Palmer Robert yeoman 590245 590245 Palmer, Robert, of Benacre, yeoman 0
4250793 2113242 2113242 defendant Puncher John widow 590245 590245 Puncher, John, of Benacre, widow 2
4283383 2124093 2124093 defendant Kell or Kebb Thomas husbandman 590245 590245 Kell or Kebb, Thomas, of Benacre, husbandman 2
4455913 2186866 2186866 defendant Prentys John   590245 590245 Prentys, John, of Benacre 1
4511674 2204098 2204098 defendant Dykeman Augustine shipman 590245 590245 Dykeman, Augustine, of Benacre, shipman 7
4549183 2215682 2215682 defendant Hor_ William   590245 590245 Hor_, William, of Benacre 6
4703568 2266492 2266492 defendant Dowet Robert clerk 590245 590245 Dowet, Robert, of Benacre, clerk 1
4710468 2268631 2268631 defendant Hame John yeoman 590245 590245 Hame, John, of Benacre, yeoman 0
4753014 2281331 2281331 defendant Frere Richard husbandman 590245 590245 Frere, Richard, of Benacre, husbandman 0
4753280 2281408 2281408 defendant Rag Richard   590245 590245 Rag, Richard, of Benacre, parson 0
4804873 2297727 2297727 defendant Porter William gent 590245 590245 Porter, William, of Benacre, gent 0
4841415 2308848 2308848 defendant Ivet William gent 590245 590245 Ivet, William, of Benacre, gent 0
4868699 2317182 2317182 defendant Juwet William gent 590245 590245 Juwet, William, of Benacre, gent 0
4868713 2317183 2317183 defendant Juet William gent 590245 590245 together with Juet, William, of Benacre, gent 4
4868719 2317184 2317184 defendant Juwet William gent 590245 590245 Juwet, William, of Benacre, gent 0
4904655 2328064 2328064 defendant Man John butcher 590245 590245 Man, John, of Benacre, butcher 0
4918044 2332159 2332159 defendant Wulley John husbandman 590245 590245 Wulley, John, of Benacre, husbandman 0
4973505 2349022 2349022 defendant Whittokesmede John gent 590245 590245 Whittokesmede, John, of Benacre, gent 0
5039655 2368504 2368504 defendant Banham John husbandman 590245 590245 Banham, John, of Benacre, husbandman 0
5069782 2377454 2377454 defendant Godfrey William husbandman 590245 590245 Godfrey, William, of Benacre, husbandman 1
5095667 2385156 2385156 defendant Colford William shipman 590245 590245 Colford, William, of Benacre, shipman 0
5097247 2385623 2385623 defendant Asshewell Thomas   590245 590245 Asshewell, Thomas, of Benacre, sow gelder 2
5097248 2385623 2385623 defendant Qwyntyn Richard husbandman 590245 590245 Qwyntyn, Richard, of Benacre, husbandman 3
5130020 2395265 2395265 defendant Cook John   590245 590245 Cook, John, of Benacre 0
5130021 2395265 2395265 defendant Umfrey John husbandman 590245 590245 Umfrey, John, of Benacre, husbandman 1
5149309 2400929 2400929 defendant Cook John butcher 590245 590245 Cook, John, of Benacre, butcher 0
5149310 2400929 2400929 defendant Humfrey John husbandman 590245 590245 Humfrey, John, of Benacre, husbandman 1
5197817 2415099 2415099 defendant Cook John butcher 590245 590245 Cook, John, of Benacre, butcher 2
5210299 2418738 2418738 defendant Cook John butcher 590245 590245 Cook, John, of Benacre, , butcher 0
5210301 2418739 2418739 defendant Cook John butcher 590245 590245 Cook, John, of Benacre, butcher 0
5216041 2420423 2420423 defendant Coke John butcher 590245 590245 Coke, John, of Benacre, butcher 1
5259008 2432932 2432932 defendant Hayne Thomas husbandman 590245 590245 Hayne, Thomas, of Benacre, husbandman 1
5362727 2463989 2463989 defendant Whitokesmede John gent 590245 590245 Whitokesmede, John, of Benacre, gent 4
5377001 2468400 2468400 defendant Cook John butcher 590245 590245 Cook, John, of Benacre, butcher 0
5393034 2473079 2473079 defendant Cook John butcher 590245 590245 Cook, John, of Benacre, butcher 0
5398896 2474750 2474750 defendant Belle John husbandman 590245 590245 Belle, John, of Benacre, husbandman 0
5407435 2477196 2477196 defendant Dey John yeoman 590245 590245 (Dey, John, of Benacre, yeoman 1
5407439 2477197 2477197 defendant Dey John yeoman 590245 590245 (Dey, John, of Benacre, yeoman 1
5420680 2481110 2481110 defendant Dey John yeoman 590245 590245 (Dey, John, of Benacre, yeoman 1
5420684 2481111 2481111 defendant Dey John yeoman 590245 590245 (Dey, John, of Benacre, yeoman 1
5447123 2489030 2489030 defendant Staunton John laborer 590245 590245 Staunton, John, of Benacre, laborer 2
5452336 2490570 2490570 defendant Cook John (legal representative) 590245 590245 Cook, John, of Benacre, butcher, executor of 0
5459579 2492778 2492778 defendant Staunton John laborer 590245 590245 Staunton, John, of Benacre, laborer 2
5462024 2493538 2493538 defendant Wode John yeoman 590245 590245 Wode, John, of Benacre, yeoman 0
5471516 2496430 2496430 defendant Wode Robert husbandman 590245 590245 Wode, Robert, of Benacre, husbandman 0
5509782 2507894 2507894 defendant Cook John (legal representative) 590245 590245 Cook, John, of Benacre, butcher, executor of 0
5509783 2507894 2507894 defendant Preweyt Robert clerk 590245 590245 Preweyt, Robert, of Benacre, clerk 1
5509785 2507895 2507895 defendant Cook John (legal representative) 590245 590245 Cook, John, of Benacre, butcher, executor of 0
5509786 2507895 2507895 defendant Preweyt Robert clerk 590245 590245 Preweyt, Robert, of Benacre, clerk 1
5517575 2510338 2510338 defendant Hastyng William husbandman 590245 590245 Hastyng, William, of Benacre, husbandman 1
5517576 2510338 2510338 defendant Wode Robert husbandman 590245 590245 Wode, Robert, of Benacre, husbandman 2
5530877 2514172 2514172 defendant Coke John (legal representative) 590245 590245 Coke, John, of Benacre, butcher, executor of 0
5530878 2514172 2514172 defendant Pronet or Prouet or Provet Robert clerk 590245 590245 Pronet or Prouet or Provet, Robert, of Benacre, clerk 1
5537882 2516336 2516336 defendant Hullok Thomas husbandman 590245 590245 Hullok, Thomas, of Benacre, husbandman 1
5538655 2516573 2516573 defendant Prewet Robert clerk 590245 590245 Prewet, Robert, of Benacre, clerk 0
5540188 2517058 2517058 defendant Couper Thomas husbandman 590245 590245 Couper, Thomas, of Benacre, husbandman 0
5543479 2518077 2518077 defendant Joye Alice widow 590245 590245 Joye, Alice, of Benacre, widow 2
5546148 2518864 2518864 defendant Proveyt or Proneyt Robert clerk 590245 590245 Proveyt or Proneyt, Robert, of Benacre, clerk 2
5579854 2528780 2528780 defendant Drane John yeoman 590245 590245 Drane, John, of Benacre, yeoman 0
5579855 2528780 2528780 defendant Couper Robert husbandman 590245 590245 Couper, Robert, of Benacre, husbandman 1
5622297 2550892 2550892 defendant Elfy William   590245 590245 Elfy, William, of Benacre 0
5626677 2552317 2552317 defendant Brede John husbandman 590245 590245 Brede, John, of Benacre, husbandman 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);