names

61 rows where place_id = 603072

✎ 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
3652961 1911257 1911257 plaintiff Wethurs John clerk 603072 603072 Wethurs, John, of Yorks, clerk 0
3667342 1915723 1915723 plaintiff Wilson William (legal representative) 603072 603072 Wilson, William, of Yorks, Alderman, executrix of 0
3695879 1924946 1924946 plaintiff Roberdys Richard clerk 603072 603072 Roberdys, Richard, of Yorks, clerk 0
3695881 1924947 1924947 plaintiff Roberdys Richard clerk 603072 603072 Roberdys, Richard, of Yorks, clerk 0
3711554 1929925 1929925 defendant Kelnehist or Kelvehist Edmund gent 603072 603072 Kelnehist or Kelvehist, Edmund, of Yorks, gent 0
3721702 1933071 1933071 defendant Caward John   603072 603072 Caward, John, of Yorks 9
3726364 1934515 1934515 defendant Curwyn Thomas gent 603072 603072 Curwyn, Thomas, of Yorks, gent 2
3733436 1936698 1936698 plaintiff Eckylsley Edward gent 603072 603072 Eckylsley, Edward, of Yorks, gent 0
3864412 1978294 1978294 defendant Curvyn Thomas esq 603072 603072 Curvyn, Thomas, of Sheriff Hewton, Yorks, esq 0
3874453 1981683 1981683 defendant Greveson John chapman 603072 603072 Greveson, John, of Durham, Yorks, chapman 2
3949968 2007069 2007069 defendant Cressye Hugh gent 603072 603072 Cressye, Hugh, of Yorks, gent 4
4020069 2031904 2031904 defendant Hall James gent 603072 603072 Hall, James, of Yorks, gent 4
4020084 2031906 2031906 defendant Hall James gent 603072 603072 together with Hall, James, of Yorks, gent 4
4031141 2035810 2035810 defendant Chapham George gent 603072 603072 Chapham, George, of Chapman, Yorks, gent 0
4065776 2048054 2048054 defendant Hewett Francis gent 603072 603072 Hewett, Francis, of Wales, Yorks, gent 0
4119706 2067335 2067335 defendant Hewytt Francis gent 603072 603072 Hewytt, Francis, of Wales, Yorks, gent 0
4165514 2083439 2083439 defendant Farles Henry chapman 603072 603072 Farles, Henry, of Durham, Yorks , chapman 1
4187584 2091158 2091158 defendant Raners Charles clothier 603072 603072 Raners, Charles, of Yorks, clothier 1
4191171 2092476 2092476 defendant Hewytt Francis gent 603072 603072 Hewytt, Francis, of Wales, Yorks, gent 0
4280090 2122946 2122946 defendant Syms Nicholas husbandman 603072 603072 Syms, Nicholas, of Wales, Yorks, husbandman 0
4280092 2122947 2122947 defendant Syms Nicholas husbandman 603072 603072 Syms, Nicholas, of Wales, Yorks, husbandman 0
4412909 2168912 2168912 defendant Lock Thomas yeoman 603072 603072 Lock, Thomas, of Sheriff Huton, Yorks, yeoman 0
4669035 2256020 2256020 defendant Kexby John weaver 603072 603072 Kexby, John, of Yorks, weaver 1
4726104 2273452 2273452 defendant Kirke Thomas vintner 603072 603072 Kirke, Thomas, of Yorks, vintner 0
4739533 2277445 2277445 defendant Shaltok John husbandman 603072 603072 Shaltok, John, of Yorks, husbandman 4
4745447 2279174 2279174 defendant Hunt John husbandman 603072 603072 Hunt, John, of Wales, Yorks, husbandman 0
4751125 2280806 2280806 defendant Briwtolwe John de walker 603072 603072 Briwtolwe, John de, of Yorks, walker 3
4753051 2281342 2281342 defendant Yarum William chapman 603072 603072 Yarum, William, of Yorks, chapman 2
4809636 2299178 2299178 defendant Holtby Robert mercer 603072 603072 Holtby, Robert, of Yorks, mercer 0
4811580 2299731 2299731 defendant Chaffer John butcher 603072 603072 Chaffer, John, of Yorks, butcher 2
4820905 2302627 2302627 defendant Chaffere John butcher 603072 603072 Chaffere, John, of Yorks, butcher 1
4832209 2306106 2306106 defendant Ledle John husbandman 603072 603072 Ledle, John, of Wales, Yorks, husbandman 2
4853542 2312522 2312522 defendant Russell Thomas husbandman 603072 603072 Russell, Thomas, of Wales, Yorks, husbandman 0
4867942 2316942 2316942 defendant Bogger William vintner 603072 603072 Bogger, William, of Yorks, vintner 0
4893224 2324594 2324594 defendant Burgh Thomas (legal representative) 603072 603072 Burgh, Thomas, of Yorks, esq, executors of 2
4899402 2326453 2326453 defendant Pynder John husbandman 603072 603072 Pynder, John, of Wales, Yorks, husbandman 1
4935123 2337393 2337393 defendant Marchall John yeoman 603072 603072 Marchall, John, of Yorks, yeoman 1
5003995 2358061 2358061 defendant Alexander William dyer 603072 603072 Alexander, William, of Yorks, dyer 1
5026906 2364737 2364737 defendant Skypwyth John merchant 603072 603072 Skypwyth, John, of Yorks, merchant 0
5036334 2367478 2367478 plaintiff Vavysour Henry esq 603072 603072 Vavysour, Henry, of Yorks, esq 0
5036336 2367478 2367478 plaintiff Holthorp William esq 603072 603072 Holthorp, William, of Yorks, esq 2
5048423 2371166 2371166 defendant Colynson Roger chapman 603072 603072 Colynson, Roger, of Yorks, chapman 3
5069951 2377506 2377506 plaintiff Russell Robert   603072 603072 Russell, Robert, of Yorks 0
5085791 2382240 2382240 defendant Scaresbek Gilbert esq 603072 603072 Scaresbek, Gilbert, of Yorks, esq 0
5176213 2408734 2408734 defendant Allerton John dealer 603072 603072 Allerton, John, of Yorks, dealer 1
5237938 2426683 2426683 defendant Howet John   603072 603072 Howet, John, of Wales, Yorks, "sunyour" 1
5243386 2428261 2428261 defendant Acclom John gent 603072 603072 Acclom, John, of Yorks, gent 5
5343577 2458178 2458178 defendant Jonson William yeoman 603072 603072 Jonson, William, of Yorks, yeoman 1
5354316 2461416 2461416 defendant Lyndeley John yeoman 603072 603072 Lyndeley, John, of Yorks, yeoman 4
5374067 2467490 2467490 defendant Aldfeld Thomas yeoman 603072 603072 Aldfeld, Thomas, of Yorks, yeoman 2
5390432 2472325 2472325 defendant Hewet John yeoman 603072 603072 Hewet, John, of Wales, Yorks, yeoman 3
5390796 2472433 2472433 defendant Hewet John yeoman 603072 603072 Hewet, John, of Wales, Yorks, yeoman 3
5433227 2484903 2484903 defendant Hewet John yeoman 603072 603072 Hewet, John, of Wales, Yorks, yeoman 2
5433950 2485107 2485107 defendant Hewet John yeoman 603072 603072 Hewet, John, of Wales, Yorks, yeoman 0
5491868 2502477 2502477 defendant Clarell Thomas (legal representative) 603072 603072 Clarell, Thomas, of Yorks, esq, administratrix of 0
5556467 2521865 2521865 defendant Strykeland Walter   603072 603072 Strykeland, Walter, of Yorks, knight 0
5556468 2521865 2521865 defendant Midilton Thomas   603072 603072 Midilton, Thomas, of Yorks, knight 1
5625749 2551995 2551995 defendant Sprot Thomas merchant 603072 603072 Sprot, Thomas, of Yorks, merchant 1
5628887 2553005 2553005 defendant Beverley John spicer 603072 603072 Beverley, John, of Yorks, spicer 0
5630058 2553403 2553403 defendant Relyngton William gent 603072 603072 Relyngton, William, of Yorks, gent 0
5630527 2553558 2553558 defendant Fanyn David tailor 603072 603072 Fanyn, David, of Yorks, tailor 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);