names

102 rows where place_id = 590178

✎ 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
3600164 1867703 1867703 defendant Marchall William husbandman 590178 590178 Marchall, William, of Bekyngham, husbandman 0
3611840 1871363 1871363 defendant Noddell John husbandman 590178 590178 Noddell, John, of Bekyngham, husbandman 0
3626865 1903252 1903252 defendant Crosse John yeoman 590178 590178 Crosse, John, of Bekyngham, yeoman 2
3633722 1905356 1905356 defendant Eccleson or Ekkilston William husbandman 590178 590178 Eccleson or Ekkilston, William, of Bekyngham, husbandman 0
3660570 1913566 1913566 defendant Kynsall Thomas yeoman 590178 590178 Kynsall, Thomas, of Bekyngham, yeoman 3
3660574 1913567 1913567 defendant Kynsoll Thomas   590178 590178 Kynsoll, Thomas, of Bekyngham, Kentl yoeman 2
3683716 1921041 1921041 defendant Crosse William husbandman 590178 590178 Crosse, William, of Bekyngham, husbandman 0
3713236 1930445 1930445 defendant Knyght Thomas tailor 590178 590178 Knyght, Thomas, of Bekyngham, tailor 1
3785516 1953259 1953259 defendant Crosse William yeoman 590178 590178 Crosse, William, of Bekyngham, yeoman 0
3801990 1958517 1958517 defendant Crosse William yeoman 590178 590178 Crosse, William, of Bekyngham, yeoman 0
3806691 1959991 1959991 defendant Kydmore Thomas sawyer 590178 590178 Kydmore, Thomas, of Bekyngham, sawyer 0
3903623 1991442 1991442 defendant Burdon William clerk 590178 590178 Burdon, William, of Bekyngham, clerk 0
3916375 1995859 1995859 defendant Crosse John yeoman 590178 590178 Crosse, John, of Bekyngham, yeoman 0
3916376 1995859 1995859 defendant Clyderowe Thomas husbandman 590178 590178 Clyderowe, Thomas, of Bekyngham, husbandman 1
3916378 1995859 1995859 defendant Clyfton John husbandman 590178 590178 Clyfton, John, of Bekyngham, husbandman 3
3918874 1996634 1996634 defendant Spur William Notts, yeoman 590178 590178 Spur William, of Bekyngham, Notts, yeoman 1
3965154 2012421 2012421 defendant Nealeship Hugh husbandman 590178 590178 Nealeship, Hugh, of Bekyngham, husbandman 0
3971777 2014693 2014693 defendant Spurre William (legal representative) 590178 590178 Spurre, William, of Bekyngham, yeoman, executors of 0
4415276 2169671 2169671 defendant Sibethorp Thomas de   590178 590178 Sibethorp, Thomas de, of Bekyngham, parson 0
4415291 2169678 2169678 defendant Sibethorp Thomas de   590178 590178 Sibethorp, Thomas de, of Bekyngham, parson 0
4417501 2170359 2170359 defendant Sibethorp Thomas de   590178 590178 Sibethorp, Thomas de, of Bekyngham, parson 0
4417503 2170360 2170360 defendant Sibethorp Thomas de   590178 590178 Sibethorp, Thomas de, of Bekyngham, parson 0
4417504 2170361 2170361 plaintiff Sibethorp Thomas de   590178 590178 Sibethorp, Thomas de, of Bekyngham, parson 0
4417576 2170386 2170386 plaintiff Spens John   590178 590178 Spens, John, of Bekyngham 0
4417577 2170386 2170386 defendant Flanbergh Richard de chaplain of the BM chapel 590178 590178 Flanbergh, Richard de, of Bekyngham, chaplain of the BM chapel 0
4419289 2170914 2170914 defendant Cashale William   590178 590178 Cashale, William, of Bekyngham, son of Joan 1
4419293 2170915 2170915 defendant Cashale William de   590178 590178 Cashale, William de, of Bekyngham, son of Joan 2
4424554 2172517 2172517 plaintiff Justis Richard de   590178 590178 Justis, Richard de, of Bekyngham, son of John 0
4424555 2172517 2172517 defendant Barneby William de   590178 590178 Barneby, William de, of Bekyngham, prebendary of the prebend, in the St Mary's church in Suthwell 0
4424556 2172518 2172518 plaintiff Justix Richard   590178 590178 Justix, Richard, of Bekyngham, son of John 0
4431502 2174620 2174620 defendant Sibethorp Thomas de   590178 590178 Sibethorp, Thomas de, of Bekyngham, parson 0
4433719 2175309 2175309 defendant Notebroun Gilbert chaplain & warden of the chapel of the BM 590178 590178 Notebroun, Gilbert, of Bekyngham, chaplain & warden of the chapel of the BM 0
4434209 2175463 2175463 defendant Sibethorp Thomas de   590178 590178 Sibethorp, Thomas de, of Bekyngham, parson 0
4434258 2175474 2175474 plaintiff Justes Richard   590178 590178 Justes, Richard, of Bekyngham, son of John 0
4434259 2175474 2175474 defendant Barneby William de   590178 590178 Barneby, William de, of Bekyngham, prebendary of the prebend of the church of the BM, in Southwell 0
4434399 2175511 2175511 defendant Sibethorp Thomas de   590178 590178 Sibethorp, Thomas de, of Bekyngham, parson 0
4434401 2175512 2175512 defendant Sibthorp Thomas de   590178 590178 Sibthorp, Thomas de, of Bekyngham, parson 0
4475743 2193087 2193087 plaintiff Fery John chaplain 590178 590178 Fery, John, of Bekyngham, chaplain 0
4475744 2193087 2193087 defendant Plansworth John   590178 590178 Plansworth, John, of Bekyngham 0
4505394 2202218 2202218 defendant Whithanson John   590178 590178 Whithanson, John, of Bekyngham 0
4511135 2203932 2203932 defendant Plansworth John de   590178 590178 Plansworth, John de, of Bekyngham 0
4518514 2206163 2206163 defendant Bek William   590178 590178 Bek, William, of Bekyngham 0
4523247 2207594 2207594 defendant Bek William   590178 590178 Bek, William, of Bekyngham 0
4537041 2211855 2211855 defendant Bek William   590178 590178 Bek, William, of Bekyngham 0
4539824 2212718 2212718 defendant Padley William   590178 590178 Padley, William, of Bekyngham 0
4565745 2220844 2220844 defendant Regerson John   590178 590178 Regerson, John, of Bekyngham 1
4582893 2226078 2226078 defendant Hales Richard   590178 590178 Hales, Richard, of Bekyngham 1
4592153 2228901 2228901 defendant Elens_ John   590178 590178 Elens_, John, of Bekyngham 0
4595524 2229858 2229858 defendant atte Cros John chaplain 590178 590178 atte Cros, John, of Bekyngham, chaplain 1
4595810 2229944 2229944 defendant Slawester John   590178 590178 Slawester, John, of Bekyngham 0
4610119 2234251 2234251 defendant Repynghall Reginald   590178 590178 Repynghall, Reginald, of Bekyngham 5
4633417 2241306 2241306 defendant Tebaude William   590178 590178 Tebaude, William, of Bekyngham 0
4636374 2242211 2242211 defendant Pyndar John, sen   590178 590178 Pyndar, John, sen, of Bekyngham 3
4645575 2244775 2244775 defendant Halys Richard   590178 590178 Halys, Richard, of Bekyngham 1
4649992 2246014 2246014 defendant Barbet Robert   590178 590178 Barbet, Robert, of Bekyngham 5
4652471 2246724 2246724 defendant Bocher Ralph butcher 590178 590178 Bocher, Ralph, of Bekyngham, butcher 0
4652472 2246724 2246724 defendant Bate Thomas laborer 590178 590178 Bate, Thomas, of Bekyngham, laborer 1
4662540 2249753 2249753 defendant Taillour Richard tailor 590178 590178 Taillour, Richard, of Bekyngham, tailor 0
4716406 2270448 2270448 defendant Repyngham Robert butcher 590178 590178 Repyngham, Robert, of Bekyngham, butcher 4
4726345 2273523 2273523 defendant Proktour John husbandman 590178 590178 Proktour, John, of Bekyngham, husbandman 0
4762576 2284275 2284275 defendant Proktour Robert husbandman 590178 590178 Proktour, Robert, of Bekyngham, husbandman 0
4762578 2284275 2284275 defendant Hales Richard husbandman 590178 590178 Hales, Richard, of Bekyngham, husbandman 2
4772029 2287227 2287227 defendant Smyth Robert husbandman 590178 590178 Smyth, Robert, of Bekyngham, husbandman 0
4796077 2294927 2294927 defendant Tee John   590178 590178 Tee, John, of Bekyngham 0
4833894 2306609 2306609 defendant London John butcher 590178 590178 London, John, of Bekyngham, butcher 2
4837541 2307677 2307677 defendant Fraunceys Robert husbandman 590178 590178 Fraunceys, Robert, of Bekyngham, husbandman 1
4837542 2307677 2307677 defendant Bocher William husbandman 590178 590178 Bocher, William, of Bekyngham, husbandman 2
4837551 2307680 2307680 defendant Fraunceys Robert husbandman 590178 590178 Fraunceys, Robert, of Bekyngham, husbandman 1
4837552 2307680 2307680 defendant Bocher William husbandman 590178 590178 Bocher, William, of Bekyngham, husbandman 2
4843834 2309592 2309592 defendant Tye John (legal representative) 590178 590178 Tye, John, of Bekyngham, executors of 0
4854132 2312702 2312702 defendant Webster Richard husbandman 590178 590178 Webster, Richard, of Bekyngham, husbandman 6
4871254 2317982 2317982 defendant Webster Richard   590178 590178 Webster, Richard, of Bekyngham 2
4871259 2317983 2317983 defendant Fraunces Robert husbandman 590178 590178 Fraunces, Robert, of Bekyngham, husbandman 1
4871260 2317983 2317983 defendant Padley Thomas husbandman 590178 590178 Padley, Thomas, of Bekyngham, husbandman 2
4934614 2337218 2337218 defendant Webster Richard husbandman 590178 590178 Webster, Richard, of Bekyngham, husbandman 0
4948915 2341644 2341644 defendant Egleston John husbandman 590178 590178 Egleston, John, of Bekyngham, husbandman 0
4948916 2341644 2341644 defendant Egleston Robert husbandman 590178 590178 Egleston, Robert, of Bekyngham, husbandman 1
4948921 2341646 2341646 defendant She- Richard husbandman 590178 590178 She-, Richard, of Bekyngham, husbandman 0
4948922 2341646 2341646 defendant Grene Giles   590178 590178 Grene, Giles, of Bekyngham, servant 1
5010485 2359943 2359943 plaintiff Warde William yeoman 590178 590178 Warde, William, of Bekyngham, yeoman 0
5050539 2371788 2371788 defendant Wakefeld Thomas husbandman 590178 590178 Wakefeld, Thomas, of Bekyngham, husbandman 0
5066829 2376607 2376607 defendant Boner or Bouer John gent 590178 590178 Boner or Bouer, John, of Bekyngham, gent 4
5072656 2378303 2378303 defendant Grene Giles husbandman 590178 590178 Grene, Giles, of Bekyngham, husbandman 0
5079026 2380211 2380211 defendant Fauconer Robert husbandman 590178 590178 Fauconer, Robert, of Bekyngham, husbandman 0
5082834 2381372 2381372 defendant Bosom Hugh clerk 590178 590178 Bosom, Hugh, of Bekyngham, clerk 0
5084001 2381717 2381717 defendant Lever or Lener Alexander yeoman 590178 590178 Lever or Lener, Alexander, of Bekyngham, yeoman 1
5090854 2383716 2383716 plaintiff Lever Alexander   590178 590178 Lever, Alexander, of Bekyngham 1
5090856 2383716 2383716 defendant Franceys John yeoman 590178 590178 Franceys, John, of Bekyngham, yeoman 0
5090857 2383716 2383716 defendant Webser John yeoman 590178 590178 Webser, John, of Bekyngham, yeoman 1
5214967 2420099 2420099 defendant Midday John husbandman 590178 590178 Midday, John, of Bekyngham, husbandman 0
5355575 2461816 2461816 defendant Parker Thomas husbandman 590178 590178 Parker, Thomas, of Bekyngham, husbandman 0
5372154 2466881 2466881 defendant Lamberd Thomas husbandman 590178 590178 Lamberd, Thomas, of Bekyngham, husbandman 4
5459648 2492801 2492801 defendant Pope Robert husbandman 590178 590178 Pope, Robert, of Bekyngham, husbandman 0
5476121 2497868 2497868 defendant Pynder Robert husbandman 590178 590178 Pynder, Robert, of Bekyngham, husbandman 0
5511726 2508518 2508518 defendant Parker Thomas husbandman 590178 590178 Parker, Thomas, of Bekyngham, husbandman 0
5511727 2508518 2508518 defendant Pynder John husbandman 590178 590178 Pynder, John, of Bekyngham, husbandman 1
5558193 2522346 2522346 defendant Helford John yeoman 590178 590178 Helford, John, of Bekyngham, yeoman 1
5590864 2532115 2532115 defendant Person Richard clerk 590178 590178 Person, Richard, of Bekyngham, clerk 0
5590865 2532115 2532115 defendant Cooke Robert husbandman 590178 590178 Cooke, Robert, of Bekyngham, husbandman 1
5618420 2549583 2549583 plaintiff Millet William   590178 590178 Millet, William, of Bekyngham 0

Next page

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);