names

89 rows where place_id = 592738

✎ 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
3608704 1870383 1870383 defendant West Richard chapman 592738 592738 West, Richard, of Godmanchester, Hunts, chapman 1
3635405 1905871 1905871 defendant West Richard yeoman 592738 592738 West, Richard, of Godmanchester, Hunts, yeoman 0
3675350 1918329 1918329 defendant Stacy John   592738 592738 Stacy, John, of Godmanchester, Hunts, surgeon 0
3712863 1930342 1930342 defendant Wynde John (legal representative) 592738 592738 Wynde, John, of Godmanchester, Hunts, gent, executrix of 2
3715794 1931227 1931227 defendant Hunt Robert husbandman 592738 592738 Hunt, Robert, of Godmanchester, Hunts, husbandman 3
3717414 1931729 1931729 defendant Welsshe Gilbert husbandman 592738 592738 Welsshe, Gilbert, of Godmanchester, Hunts, husbandman 0
3765642 1946918 1946918 defendant Ibott or Ivott Francis chapman 592738 592738 Ibott or Ivott, Francis, of Godmanchester, Hunts, chapman 1
3801027 1958235 1958235 defendant Pelle John husbandman 592738 592738 Pelle, John, of Godmanchester, Hunts, husbandman 0
3841920 1971041 1971041 defendant Woodward William gent 592738 592738 Woodward, William, of Godmanchester, Hunts, gent 0
3859450 1976649 1976649 defendant Woodward William gent 592738 592738 Woodward, William, of Godmanchester, Hunts, gent 0
3859479 1976659 1976659 defendant Woodward William gent 592738 592738 Woodward, William, of Godmanchester, Hunts, gent 0
3859482 1976660 1976660 defendant Woodward William gent 592738 592738 Woodward, William, of Godmanchester, Hunts, gent 0
3904361 1991706 1991706 defendant Croftys William grocer 592738 592738 Croftys, William, of Godmanchester, Hunts, grocer 2
3927216 1999439 1999439 defendant Massy Robert yeoman 592738 592738 Massy, Robert, of Godmanchester, Hunts, yeoman 0
3947621 2006231 2006231 plaintiff Collyns Thomas yeoman 592738 592738 Collyns, Thomas, of Godmanchester, Hunts, yeoman 0
3952343 2007891 2007891 plaintiff Herne Robert yeoman 592738 592738 Herne, Robert, of Godmanchester, Hunts, yeoman 0
3961191 2011008 2011008 defendant Collyn John yeoman 592738 592738 Collyn, John, of Godmanchester, Hunts, yeoman 0
3961397 2011083 2011083 plaintiff Tryce Thomas yeoman 592738 592738 Tryce, Thomas, of Godmanchester, Hunts, yeoman 0
3974628 2015692 2015692 plaintiff Herne Robert innholder 592738 592738 Herne, Robert, of Godmanchester, Hunts, innholder 0
3976603 2016391 2016391 defendant Collyns Thomas yeoman 592738 592738 Collyns, Thomas, of Godmanchester, Hunts, yeoman 0
3998484 2024195 2024195 plaintiff Fetherbye John haberdasher 592738 592738 Fetherbye, John, of Godmanchester, Hunts, haberdasher 0
3998486 2024196 2024196 plaintiff Fetherbye John yeoman 592738 592738 Fetherbye, John, of Godmanchester, Hunts, yeoman 0
3999248 2024486 2024486 plaintiff Froste John yeoman 592738 592738 Froste, John, of Godmanchester, Hunts, yeoman 0
3999882 2024726 2024726 defendant Gynn Edmund yeoman or ship maker 592738 592738 Gynn, Edmund, of Godmanchester, Hunts, yeoman or ship maker 0
4014238 2029821 2029821 defendant Collyns Thomas yeoman 592738 592738 Collyns, Thomas, of Godmanchester, Hunts, yeoman 0
4018068 2031181 2031181 defendant Fetherbye John chapman 592738 592738 Fetherbye, John, of Godmanchester, Hunts, chapman 0
4020647 2032112 2032112 defendant Collins Thomas yeoman 592738 592738 Collins, Thomas, of Godmanchester, Hunts, yeoman 0
4069130 2049251 2049251 defendant Wylmote John butcher 592738 592738 Wylmote, John, of Godmanchester, Hunts, butcher 0
4077847 2052376 2052376 defendant Core William gent 592738 592738 Core, William, of Godmanchester, Hunts, gent 1
4082721 2054128 2054128 defendant Kervyll Edmund gent 592738 592738 Kervyll, Edmund, of Godmanchester, Hunts, gent 0
4138216 2074037 2074037 defendant Tryce Robert gent 592738 592738 Tryce, Robert, of Godmanchester, Hunts, gent 0
4141624 2075236 2075236 defendant Trice Nicholas gent 592738 592738 Trice, Nicholas, of Godmanchester, Hunts, gent 0
4186047 2090609 2090609 defendant Normanton alias Kneseworthe Thomas yeoman 592738 592738 Normanton alias Kneseworthe, Thomas, of Godmanchester, Hunts, yeoman 0
4186324 2090702 2090702 defendant Parpoynte or Pharepointe Richard husbandman 592738 592738 Parpoynte or Pharepointe, Richard, of Godmanchester, Hunts, husbandman 0
4186328 2090704 2090704 defendant Trice Robert gent 592738 592738 Trice, Robert, of Godmanchester, Hunts, gent 0
4186330 2090705 2090705 defendant Newman John husbandman 592738 592738 Newman, John, of Godmanchester, Hunts, husbandman 0
4197618 2094722 2094722 defendant Daryngton Ambrose clerk 592738 592738 Daryngton, Ambrose, of Godmanchester, Hunts, clerk 0
4209483 2098864 2098864 defendant Glascocke William husbandman 592738 592738 Glascocke, William, of Godmanchester, Hunts, husbandman 0
4218668 2102027 2102027 defendant Banckys Richard gent 592738 592738 Banckys, Richard, of Godmanchester, Hunts, or of Shelford Parva Cams, gent 0
4221159 2102898 2102898 defendant Banckys Richard gent 592738 592738 Banckys, Richard, of Godmanchester, Hunts, or of Shelford Parva Cams, gent 0
4225410 2104350 2104350 defendant Alred William yeoman 592738 592738 Alred, William, of Godmanchester, Hunts, yeoman 0
4225412 2104351 2104351 defendant Normanton John yeoman 592738 592738 Normanton, John, of Godmanchester, Hunts, yeoman 0
4242114 2110356 2110356 defendant Core William yeoman 592738 592738 Core, William, of Godmanchester, Hunts, yeoman 2
4243084 2110678 2110678 defendant Besouthe Richard yeoman 592738 592738 Besouthe, Richard, of Godmanchester, Hunts, yeoman 1
4251806 2113594 2113594 defendant Gore William yeoman 592738 592738 Gore, William, of Godmanchester, Hunts, yeoman 2
4253374 2114119 2114119 defendant Besouthe Richard yeoman 592738 592738 Besouthe, Richard, of Godmanchester, Hunts, yeoman 1
4255947 2114964 2114964 defendant Banck Richard gent 592738 592738 Banck, Richard, of Godmanchester, Hunts, gent 0
4259434 2116129 2116129 defendant Banckys Richard gent 592738 592738 Banckys, Richard, of Godmanchester, Hunts, gent 0
4267458 2118750 2118750 defendant Bysouthe Richard yeoman 592738 592738 Bysouthe, Richard, of Godmanchester, Hunts, yeoman 0
4271084 2119904 2119904 defendant Bankes Richard gent 592738 592738 Bankes, Richard, of Godmanchester, Hunts, gent 1
4273402 2120664 2120664 defendant Banckys Richard gent 592738 592738 Banckys, Richard, of Godmanchester, Hunts, or of Shelforde Parva, Cams, gent 0
4273410 2120667 2120667 defendant Blanckys alias Bankes Richard gent 592738 592738 Blanckys alias Bankes, Richard, of Godmanchester, Hunts,or of Shelforde Parva, gent 0
4287278 2125508 2125508 defendant Normanton Thomas husbandman 592738 592738 Normanton, Thomas, of Godmanchester, Hunts, husbandman 0
4314767 2135276 2135276 defendant Campynett Richard gent 592738 592738 Campynett, Richard, of Godmanchester, Hunts, gent 0
4315901 2135671 2135671 defendant Tapper George yeoman 592738 592738 Tapper, George, of Godmanchester, Hunts, yeoman 1
4339898 2143726 2143726 defendant Evens or Ivans John yeoman 592738 592738 Evens or Ivans, John, of Godmanchester, Hunts, yeoman 1
4353385 2148410 2148410 defendant Cromwell Oliver esq 592738 592738 Cromwell, Oliver, of Godmanchester, Hunts, esq 0
4360467 2150910 2150910 defendant Mason Richard butcher 592738 592738 Mason, Richard, of Godmanchester, Hunts, butcher 0
4375083 2156149 2156149 defendant Egelsfeild James chapman 592738 592738 Egelsfeild, James, of Godmanchester, Hunts, chapman 1
4388721 2160860 2160860 defendant Tapworth George innholder 592738 592738 Tapworth, George, of Godmanchester, Hunts, innholder 3
4406920 2166878 2166878 defendant Cromwell Oliver esq 592738 592738 Cromwell, Oliver, of Godmanchester, Hunts, esq 0
4407952 2167226 2167226 defendant Sherman Robert baker 592738 592738 Sherman, Robert, of Godmanchester, Hunts, baker 0
4655754 2247683 2247683 defendant Ive John butcher 592738 592738 Ive, John, of Godmanchester, Hunts, butcher 1
4705434 2267066 2267066 defendant Ponder William maltman 592738 592738 Ponder, William, of Godmanchester, Hunts, maltman 0
4754805 2281882 2281882 defendant Quenhithe Reginald husbandman 592738 592738 (Quenhithe, Reginald, of Godmanchester, Hunts, husbandman 1
4897614 2325918 2325918 defendant Cony John, senior husbandman 592738 592738 Cony, John, senior, of Godmanchester, Hunts, husbandman 0
4925271 2334334 2334334 defendant Cony John maltman 592738 592738 Cony, John, of Godmanchester, Hunts, maltman 0
5070274 2377603 2377603 defendant Powe William pardoner 592738 592738 Powe, William, of Godmanchester, Hunts, pardoner 0
5100281 2386526 2386526 defendant Page John fisher 592738 592738 Page, John, of Godmanchester, Hunts, fisher 0
5242389 2427985 2427985 defendant Shillyng John husbandman 592738 592738 (Shillyng, John, of Godmanchester, Hunts, husbandman 1
5242403 2427991 2427991 defendant Shillyng John husbandman 592738 592738 (Shillyng, John, of Godmanchester, Hunts, husbandman 1
5244260 2428509 2428509 defendant Hopwode William butcher 592738 592738 Hopwode, William, of Godmanchester, Hunts, butcher 0
5244268 2428510 2428510 defendant Horwode William butcher 592738 592738 Horwode, William, of Godmanchester, Hunts, butcher 0
5281562 2439673 2439673 defendant Wales Thomas butcher 592738 592738 Wales, Thomas,of Godmanchester, Hunts, butcher 0
5292308 2442750 2442750 defendant Nicoll William yeoman 592738 592738 Nicoll, William, of Godmanchester, Hunts, yeoman 2
5414490 2479270 2479270 defendant Freir William husbandman 592738 592738 Freir, William, of Godmanchester, Hunts, husbandman 0
5503500 2506006 2506006 defendant Stephens William clerk 592738 592738 Stephens, William, of Godmanchester, Hunts, clerk 0
5510598 2508153 2508153 defendant Notyngham William smith 592738 592738 Notyngham, William, of Godmanchester, Hunts, smith 0
5525509 2512570 2512570 defendant Fawne Richard chapman 592738 592738 Fawne, Richard, of Godmanchester, Hunts, chapman 0
5557260 2522084 2522084 defendant Clerk John draper 592738 592738 Clerk, John, of Godmanchester, Hunts, draper 0
5558210 2522351 2522351 defendant Clerke John draper 592738 592738 Clerke, John, of Godmanchester, Hunts, draper 0
5558213 2522352 2522352 defendant Clarke John draper 592738 592738 Clarke, John, of Godmanchester, Hunts, draper 1
5558846 2522541 2522541 defendant Fawne Richard chapman 592738 592738 Fawne, Richard, of Godmanchester, Hunts, chapman 2
5582076 2529462 2529462 plaintiff Dalton William yeoman 592738 592738 Dalton, William, of Godmanchester, Hunts, yeoman 0
5582078 2529463 2529463 plaintiff Dalton William yeoman 592738 592738 Dalton, William, of Godmanchester, Hunts, yeoman 0
5586317 2530761 2530761 defendant Wynd John, junior gent 592738 592738 Wynd, John, junior, of Godmanchester, Hunts, gent 0
5597675 2534167 2534167 defendant Laxston John yeoman 592738 592738 Laxston, John, of Godmanchester, Hunts, yeoman 5
5602212 2535590 2535590 defendant Lordan Mark   592738 592738 Lordan, Mark, of Godmanchester, Hunts, minstrel 0
5602215 2535591 2535591 defendant Lorydam Mark   592738 592738 Lorydam, Mark, of Godmanchester, Hunts, minstrel 0

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