names

147 rows where place_id = 588422

✎ 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
3594476 1865900 1865900 defendant Pynder John fisher 588422 588422 Pynder, John, of Croyland, fisher 1
3594477 1865900 1865900 defendant Hothyn Hugh waterman 588422 588422 Hothyn, Hugh, of Croyland, waterman 2
3609296 1870567 1870567 plaintiff Wryght Margaret widow 588422 588422 Wryght, Margaret, of Croyland, widow 0
3660017 1913396 1913396 defendant Chylde William tailor 588422 588422 Chylde, William, of Croyland, tailor 0
3666937 1915605 1915605 plaintiff Wells or Bridges John   588422 588422 Wells or Bridges, John, of Croyland, abbot of the Monastery of the Blessed Mary & Sts Bartholomew & Guthlac 0
3853394 1974686 1974686 defendant Smyth Robert fisher 588422 588422 Smyth, Robert, of Croyland, fisher 0
3855657 1975409 1975409 defendant Keling alias North Robert fisher 588422 588422 Keling alias North, Robert, of Croyland, fisher 0
3855659 1975410 1975410 defendant Keling alias North Robert fisher 588422 588422 Keling alias North, Robert, of Croyland, fisher 0
3855660 1975410 1975410 defendant Harryet William fisher 588422 588422 Harryet, William, of Croyland, fisher 1
3855661 1975410 1975410 defendant Cott William fisher 588422 588422 Cott, William, of Croyland, fisher 2
3855662 1975410 1975410 defendant Pynder John fisher 588422 588422 Pynder, John, of Croyland, fisher 3
3855664 1975411 1975411 defendant Pynder John fisher 588422 588422 Pynder, John, of Croyland, fisher 0
3924618 1998547 1998547 defendant Freston John yeoman 588422 588422 Freston, John, of Croyland, yeoman 2
3933934 2001647 2001647 defendant Harryet William fisher 588422 588422 Harryet, William, of Croyland, fisher 0
3942413 2004474 2004474 defendant Smtyh William fisher 588422 588422 Smtyh, William, of Croyland, fisher 0
4006087 2026948 2026948 defendant Durrant John yeoman 588422 588422 Durrant, John, of Croyland, yeoman 0
4006088 2026948 2026948 defendant Wyche Richard, senior yeoman 588422 588422 Wyche, Richard, senior, of Croyland, yeoman 1
4006089 2026948 2026948 defendant (not given) John churchwardens of Preyst 588422 588422 Preyst, John, of Croyland, yeoman, churchwardens of Croyland 2
4187411 2091095 2091095 defendant Warde John   588422 588422 Warde, John, of Croyland, yeoman, boatwright 2
4187412 2091095 2091095 defendant Cherington Thomas fisher 588422 588422 Cherington, Thomas, of Croyland, yeoman, fisher 3
4210960 2099392 2099392 defendant Cherington Thomas fisherman 588422 588422 Cherington, Thomas, of Croyland, yeoman, fisherman 3
4211742 2099663 2099663 defendant Walker Roger, junior tanner 588422 588422 Walker, Roger, junior, of Croyland, tanner 0
4211745 2099664 2099664 defendant Walker Roger, junior tanner 588422 588422 Walker, Roger, junior, of Croyland, tanner 0
4283206 2124028 2124028 defendant Williams George yeoman 588422 588422 Williams, George, of Croyland, or of Wysbitch, Isle of Ely, Cams, yeoman 0
4349919 2147231 2147231 defendant Smartfoote Richard baker 588422 588422 Smartfoote, Richard, of Croyland, baker 0
4350460 2147422 2147422 defendant Smartfoote Richard baker 588422 588422 Smartfoote, Richard, of Croyland, or of Wisbich, Isle of Ely, Cams, baker 0
4419211 2170884 2170884 plaintiff Baillif John le   588422 588422 Baillif, John le, of Croyland 0
4484941 2195988 2195988 plaintiff Ppenreth John   588422 588422 Ppenreth, John, of Croyland 0
4503303 2201603 2201603 plaintiff Paternoster Fulk   588422 588422 Paternoster, Fulk, of Croyland 0
4524944 2208144 2208144 plaintiff Chinatour John   588422 588422 Chinatour, John, of Croyland 1
4540521 2212933 2212933 plaintiff Wessyngton John   588422 588422 Wessyngton, John, of Croyland 0
4544215 2214109 2214109 plaintiff Barkere William   588422 588422 Barkere, William, of Croyland 0
4544216 2214109 2214109 defendant Burgh William   588422 588422 Burgh, William, of Croyland, shoe maker 0
4561461 2219519 2219519 defendant Baker William butcher 588422 588422 Baker, William, of Croyland, butcher 0
4578111 2224656 2224656 plaintiff Chiffatour Thomas   588422 588422 Chiffatour, Thomas, of Croyland 0
4631099 2240623 2240623 plaintiff Boton John   588422 588422 Boton, John, of Croyland 1
4631101 2240623 2240623 defendant Upton Johnn glasier 588422 588422 Upton, Johnn, of Croyland, glasier 0
4639846 2243158 2243158 defendant Bate William   588422 588422 Bate, William, of Croyland 1
4679352 2259158 2259158 plaintiff Kelby Thomas (legal representative) 588422 588422 Kelby, Thomas, of Croyland, executors of 0
4691417 2262842 2262842 defendant Jankynson Thomas   588422 588422 Jankynson, Thomas, of Croyland 0
4691473 2262857 2262857 plaintiff Wytlesey John, junior   588422 588422 Wytlesey, John, junior, of Croyland 0
4710051 2268500 2268500 defendant Harowe Thomas butcher 588422 588422 Harowe, Thomas, of Croyland, butcher 0
4769623 2286474 2286474 defendant Maddy William fishmonger 588422 588422 Maddy, William, of Croyland, fishmonger 2
4776033 2288503 2288503 defendant Upton Richard   588422 588422 Upton, Richard, of Croyland, abbot 0
4804233 2297511 2297511 defendant Flete Robert laborer 588422 588422 Flete, Robert, of Croyland, laborer 0
4824980 2303850 2303850 plaintiff Tomson Thomas   588422 588422 Tomson, Thomas, of Croyland 0
4825061 2303879 2303879 defendant Thakker John butcher 588422 588422 Thakker, John, of Croyland, butcher 0
4851395 2311881 2311881 defendant Bateson Thomas husbandman 588422 588422 Bateson, Thomas, of Croyland, husbandman 0
4851510 2311909 2311909 defendant Nicolyn John husbandman 588422 588422 Nicolyn, John, of Croyland, husbandman 16
4851511 2311909 2311909 defendant Wegle Thomas   588422 588422 Wegle, Thomas, of Croyland, boat man 17
4858579 2314058 2314058 defendant Snowe Geoffrey   588422 588422 Snowe, Geoffrey, of Croyland 0
4859914 2314471 2314471 defendant Fermery William husbandman 588422 588422 Fermery, William, of Croyland, husbandman 0
4863777 2315645 2315645 plaintiff Erle Simon   588422 588422 Erle, Simon, of Croyland 0
4872523 2318365 2318365 defendant Coker Thomas boarman 588422 588422 Coker, Thomas, of Croyland, boarman 0
4873484 2318666 2318666 defendant Coker William husbandman 588422 588422 Coker, William, of Croyland, husbandman 1
4873485 2318666 2318666 defendant Fouler William husbandman 588422 588422 Fouler, William, of Croyland, husbandman 2
4873486 2318666 2318666 defendant Maddy William husbandman 588422 588422 together with Maddy, William, of Croyland, husbandman 3
4873487 2318666 2318666 defendant Body John husbandman 588422 588422 Body, John, of Croyland, husbandman 4
4873488 2318666 2318666 defendant Wyseberd Nigel husbandman 588422 588422 Wyseberd, Nigel, of Croyland, husbandman 5
4873489 2318666 2318666 defendant Tebbe Richard husbandman 588422 588422 Tebbe, Richard, of Croyland, husbandman 6
4873490 2318666 2318666 defendant Wryght John, junior husbandman 588422 588422 Wryght, John, junior, of Croyland, husbandman 7
4873513 2318670 2318670 defendant Wyseberd Nigel fisher 588422 588422 Wyseberd, Nigel, of Croyland, fisher 10
4873529 2318672 2318672 defendant Launder William husbandman 588422 588422 Launder, William, of Croyland, husbandman 3
4873530 2318672 2318672 defendant Erle Simon husbandman 588422 588422 Erle, Simon, of Croyland, husbandman 4
4873542 2318673 2318673 defendant Wyseberd Nigel fisher 588422 588422 Wyseberd, Nigel, of Croyland, fisher 9
4882804 2321543 2321543 defendant Smyth Robert smith 588422 588422 Smyth, Robert, of Croyland, smith 0
4884305 2321998 2321998 plaintiff Masson Richard fishmonger 588422 588422 Masson, Richard, of Croyland, fishmonger 0
4890399 2323764 2323764 defendant Storme John laborer 588422 588422 Storme, John, of Croyland, laborer 0
4897449 2325864 2325864 plaintiff Woxbrygge John   588422 588422 Woxbrygge, John, of Croyland 0
4899076 2326354 2326354 defendant Smyth Robert smith 588422 588422 Smyth, Robert, of Croyland, smith 0
4914454 2331038 2331038 defendant Clerk John baker 588422 588422 Clerk, John, of Croyland, baker 0
4914455 2331038 2331038 defendant Maddy Thomas husbandman 588422 588422 Maddy, Thomas, of Croyland, husbandman 1
4928732 2335412 2335412 defendant Plummer John plumber 588422 588422 Plummer, John, of Croyland, plumber 0
4928733 2335412 2335412 defendant Bryche Simon plumer 588422 588422 Bryche, Simon, of Croyland, plumer 1
4934730 2337258 2337258 defendant Body John fisher 588422 588422 Body, John, of Croyland, fisher 2
4939816 2338842 2338842 defendant Clerk John baker 588422 588422 Clerk, John, of Croyland, baker 0
4939817 2338842 2338842 defendant Maddy Thomas husbandman 588422 588422 Maddy, Thomas, of Croyland, husbandman 1
4943228 2339852 2339852 plaintiff Gerner Stephen yeoman 588422 588422 Gerner, Stephen, of Croyland, yeoman 0
4943231 2339853 2339853 plaintiff Gernon Stephen yeoman 588422 588422 Gernon, Stephen, of Croyland, yeoman 0
4947078 2341079 2341079 defendant Toche Robert cooper 588422 588422 Toche, Robert, of Croyland, cooper 1
4953632 2343052 2343052 defendant Standwell or Stanwell William husbandman 588422 588422 Standwell or Stanwell, William, of Croyland, husbandman 0
4953635 2343052 2343052 defendant Foukesson Thomas husbandman 588422 588422 Foukesson, Thomas, of Croyland, husbandman 3
4955859 2343719 2343719 defendant Launder John husbandman 588422 588422 Launder, John, of Croyland, husbandman 0
4973898 2349156 2349156 plaintiff Lytylbury Thomas esq 588422 588422 Lytylbury, Thomas, of Croyland, esq 0
4987881 2353343 2353343 defendant Launder John tailor 588422 588422 Launder, John, of Croyland, tailor 0
4996601 2355838 2355838 defendant Wryght John fisher 588422 588422 Wryght, John, of Croyland, fisher 0
5009158 2359564 2359564 defendant Tomson John, sen husbandman 588422 588422 Tomson, John, sen, of Croyland, husbandman 0
5013029 2360639 2360639 defendant Tomson John, senior husbandman 588422 588422 Tomson, John, senior, of Croyland, husbandman 10
5043758 2369760 2369760 plaintiff Gentyll Nicholas   588422 588422 Gentyll, Nicholas, of Croyland 0
5068719 2377140 2377140 plaintiff Potell Henry chaplain 588422 588422 Potell, Henry, of Croyland, chaplain 0
5073698 2378619 2378619 defendant Potell Jenry chaplain 588422 588422 Potell, Jenry, of Croyland, chaplain 0
5094808 2384893 2384893 defendant Nutkyn John fisher 588422 588422 Nutkyn, John, of Croyland, fisher 3
5095872 2385219 2385219 defendant Launder John fisher 588422 588422 Launder, John, of Croyland, fisher 0
5095873 2385219 2385219 defendant Herry John laborer 588422 588422 Herry, John, of Croyland, laborer 1
5100974 2386697 2386697 defendant Wryght John, senior husbandman 588422 588422 Wryght, John, senior, of Croyland, husbandman 4
5100976 2386697 2386697 defendant Wryght Nicholas husbandman 588422 588422 Wryght, Nicholas, of Croyland, husbandman 6
5102691 2387199 2387199 defendant Pynder Clement laborer 588422 588422 Pynder, Clement, of Croyland, laborer 2
5102692 2387199 2387199 defendant Mason John, senior laborer 588422 588422 Mason, John, senior, of Croyland, laborer 3
5114060 2390505 2390505 defendant Strotte John yeoman 588422 588422 Strotte, John, of Croyland, yeoman 0
5114870 2390763 2390763 plaintiff Mason Richard   588422 588422 Mason, Richard, of Croyland 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);