names

55 rows where place_id = 586426

✎ 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
3588691 1864107 1864107 plaintiff Bolles Godfrey gent 586426 586426 Bolles, Godfrey, of Gosberkyrke, gent 0
3603923 1868898 1868898 plaintiff Floter Thomas   586426 586426 Floter, Thomas, of Gosberkyrke 0
3619536 1873678 1873678 defendant Humpe Robert yeoman 586426 586426 Humpe, Robert, of Gosberkyrke, yeoman 0
3619537 1873678 1873678 defendant Dowesyng Simon husbandman 586426 586426 Dowesyng, Simon, of Gosberkyrke, husbandman 1
3627780 1903548 1903548 defendant Honyngham John, senior   586426 586426 Honyngham, John, senior, of Gosberkyrke 0
3672716 1917471 1917471 defendant Floter John husbandman 586426 586426 Floter, John, of Gosberkyrke, husbandman 0
3672718 1917472 1917472 defendant Floter John husbandman 586426 586426 Floter, John, of Gosberkyrke, husbandman 0
3672720 1917473 1917473 defendant Haltoft John husbandman 586426 586426 Haltoft, John, of Gosberkyrke, husbandman 0
3782727 1952341 1952341 defendant Monkley John butcher 586426 586426 Monkley, John, of Gosberkyrke, butcher 3
3847268 1972708 1972708 plaintiff Harryman Nicholas yeoman 586426 586426 Harryman, Nicholas, of Gosberkyrke, yeoman 0
3875560 1982063 1982063 defendant Humper John yeoman 586426 586426 Humper, John, of Gosberkyrke, yeoman 0
4053725 2043712 2043712 defendant Typler William husbandman 586426 586426 Typler, William, of Gosberkyrke, husbandman 0
4053726 2043712 2043712 defendant Johnson Richard butcher 586426 586426 Johnson, Richard, of Gosberkyrke, butcher 1
4436242 2176076 2176076 plaintiff Ry Nicholas de   586426 586426 Ry, Nicholas de, of Gosberkyrke, son of Edmund, knight 0
4436248 2176077 2176077 plaintiff Ry Nicholas   586426 586426 Ry, Nicholas, of Gosberkyrke, son of Ralph, knight 0
4437995 2181201 2181201 defendant Dene William   586426 586426 Dene, William, of Gosberkyrke 0
4469308 2191072 2191072 defendant Crispe John   586426 586426 Crispe, John, of Gosberkyrke 0
4592640 2229047 2229047 defendant Launde Thomas de la   586426 586426 Launde, Thomas de la, of Gosberkyrke 2
4766518 2285521 2285521 plaintiff Leper Richard   586426 586426 Leper, Richard, of Gosberkyrke 0
4802250 2296894 2296894 defendant Hall Robert husbandman 586426 586426 Hall, Robert, of Gosberkyrke, husbandman 0
4819010 2302025 2302025 defendant Hall Robert husbandman 586426 586426 Hall, Robert, of Gosberkyrke, husbandman 0
4872474 2318350 2318350 defendant Wyke John   586426 586426 Wyke, John, of Gosberkyrke, Lincs gent 0
4872475 2318350 2318350 defendant Warde John husbandman 586426 586426 Warde, John, of Gosberkyrke, husbandman 1
4948731 2341587 2341587 defendant atte Halle Robert husbandman 586426 586426 atte Halle, Robert, of Gosberkyrke, husbandman 0
4993552 2354944 2354944 defendant Hudde John husbandman 586426 586426 Hudde, John, of Gosberkyrke, husbandman 2
5004440 2358194 2358194 defendant Bayseboll Robert husbandman 586426 586426 Bayseboll, Robert, of Gosberkyrke, husbandman 0
5009887 2359767 2359767 defendant Warde William husbandman 586426 586426 Warde, William, of Gosberkyrke, husbandman 3
5020525 2362892 2362892 plaintiff Edmund Thomas   586426 586426 Edmund, Thomas, of Gosberkyrke 2
5020529 2362892 2362892 defendant Baker Thomas husbandman 586426 586426 Baker, Thomas, of Gosberkyrke, husbandman 3
5038550 2368172 2368172 defendant Roberd John yeoman 586426 586426 Roberd, John, of Gosberkyrke, yeoman 0
5232392 2425043 2425043 defendant Colle John carpenter 586426 586426 Colle, John, of Gosberkyrke, carpenter 0
5246611 2429170 2429170 defendant Flouter John husbandman 586426 586426 Flouter, John, of Gosberkyrke, husbandman 1
5253289 2431129 2431129 defendant Bocher John butcher 586426 586426 Bocher, John, of Gosberkyrke, butcher 0
5263903 2434469 2434469 defendant Obray Thomas, junior husbandman 586426 586426 Obray, Thomas, junior, of Gosberkyrke, husbandman 0
5263904 2434469 2434469 defendant Gybson William laborer 586426 586426 Gybson, William, of Gosberkyrke, laborer 1
5267030 2435446 2435446 defendant Broun Thomas clerk 586426 586426 Broun, Thomas, of Gosberkyrke, clerk 0
5282959 2440077 2440077 defendant Alisaundre John husbandman 586426 586426 Alisaundre, John, of Gosberkyrke, husbandman 1
5314121 2449239 2449239 defendant Vassell Thomas yeoman 586426 586426 Vassell, Thomas, of Gosberkyrke, yeoman 1
5351590 2460596 2460596 defendant Warde Richard husbandman 586426 586426 Warde, Richard, of Gosberkyrke, husbandman 5
5385144 2470825 2470825 plaintiff Brunswyn Thomas (legal representative) 586426 586426 Brunswyn, Thomas, of Gosberkyrke, executors of 0
5385146 2470825 2470825 plaintiff Hempe Robert   586426 586426 Hempe, Robert, of Gosberkyrke 2
5385147 2470825 2470825 defendant Garner Ralph husbandman 586426 586426 Garner, Ralph, of Gosberkyrke, husbandman 0
5397206 2474286 2474286 plaintiff Brunswyn Thomas (legal representative) 586426 586426 Brunswyn, Thomas, of Gosberkyrke, executors of 0
5397208 2474286 2474286 plaintiff Hompe or Hempe Robert   586426 586426 Hompe or Hempe, Robert, of Gosberkyrke 2
5397209 2474286 2474286 defendant Garner Ralph husbandman 586426 586426 Garner, Ralph, of Gosberkyrke, husbandman 0
5397211 2474287 2474287 plaintiff Brunswyn Thomas (legal representative) 586426 586426 Brunswyn, Thomas, of Gosberkyrke, executors of 0
5397213 2474287 2474287 plaintiff Hompe or Hempe Robert   586426 586426 Hompe or Hempe, Robert, of Gosberkyrke 2
5406277 2476866 2476866 defendant Floweter Thomas husbandman 586426 586426 (Floweter, Thomas, of Gosberkyrke, husbandman 1
5406278 2476866 2476866 defendant Hempe Robert husbandman 586426 586426 Hempe, Robert, of Gosberkyrke, husbandman 2
5476002 2497834 2497834 defendant Thorp Adam   586426 586426 Thorp, Adam, of Gosberkyrke, rope maker 2
5484391 2500248 2500248 defendant Fraunces Thomas husbandman 586426 586426 Fraunces, Thomas, of Gosberkyrke, husbandman 0
5499673 2504845 2504845 defendant Clough John yeoman 586426 586426 Clough, John, of Gosberkyrke, yeoman 1
5546282 2518906 2518906 defendant Honyngham John yeoman 586426 586426 Honyngham, John, of Gosberkyrke, yeoman 0
5604478 2536264 2536264 defendant Blankney William herdman 586426 586426 Blankney, William, of Gosberkyrke, herdman 0
5604479 2536264 2536264 defendant Cousyn or Consyn William herdman 586426 586426 Cousyn or Consyn, William, of Gosberkyrke, herdman 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);