names

141 rows where place_id = 587801

✎ 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
3592473 1865261 1865261 defendant Page John   587801 587801 Page, John, of St Osith, butcher, son of Page, William 1
3592474 1865261 1865261 defendant Page John, senior butcher 587801 587801 Page, John, senior, of St Osith, butcher 2
3593166 1865493 1865493 plaintiff Harris Robert   587801 587801 Harris, Robert, of St Osith 0
3594387 1865878 1865878 plaintiff Keverell or Kenerell Thomas   587801 587801 Keverell or Kenerell, Thomas, of St Osith 0
3601117 1868012 1868012 defendant Herryes Robert mariner 587801 587801 Herryes, Robert, of St Osith, mariner 0
3606739 1869783 1869783 defendant Northen Robert husbandman 587801 587801 Northen, Robert, of St Osith, husbandman 2
3608662 1870369 1870369 defendant Motte Thomas husbandman 587801 587801 Motte, Thomas, of St Osith, husbandman 3
3613956 1872021 1872021 defendant Harwar Roger fuller 587801 587801 Harwar, Roger, of St Osith, fuller 0
3613957 1872021 1872021 defendant Sayer William shoemaker 587801 587801 Sayer, William, of St Osith, shoemaker 1
3665406 1915135 1915135 defendant Reynerd John husbandman 587801 587801 Reynerd, John, of St Osith, husbandman 0
3665408 1915135 1915135 defendant Walter John husbandman 587801 587801 Walter, John, of St Osith, husbandman 2
3665409 1915135 1915135 defendant Bedyll John mariner 587801 587801 Bedyll, John, of St Osith, mariner 3
3665411 1915135 1915135 defendant Page John   587801 587801 Page, John, of St Osith, fish monger 5
3765298 1946811 1946811 defendant Allard John laborer 587801 587801 Allard, John, of St Osith, laborer 0
3765301 1946811 1946811 defendant Smyth John weaver 587801 587801 Smyth, John, of St Osith, weaver 3
4109949 2063815 2063815 defendant Clarke Robert   587801 587801 Clarke, Robert, of St Osith, Esse, sailor 0
4109950 2063815 2063815 defendant Grove Thomas innholder 587801 587801 Grove, Thomas, of St Osith, innholder 1
4203017 2096606 2096606 defendant Pomfrett John roper 587801 587801 Pomfrett, John, of St Osith, roper 0
4203019 2096606 2096606 defendant Sadler William husbandman 587801 587801 Sadler, William, of St Osith, husbandman 2
4437829 2181155 2181155 defendant Blanch Thomas   587801 587801 Blanch, Thomas, of St Osith 0
4440465 2181930 2181930 defendant Durnall John   587801 587801 Durnall, John, of St Osith 2
4462105 2188848 2188848 defendant Gevenot John   587801 587801 Gevenot, John, of St Osith 0
4467739 2190587 2190587 plaintiff Bakere Saierus   587801 587801 Bakere, Saierus, of ST Osith 0
4470387 2191386 2191386 defendant Giles Roger chaplain 587801 587801 Giles, Roger, of St Osith, chaplain 0
4473284 2192303 2192303 defendant Lythyng John   587801 587801 Lythyng, John, of St Osith 0
4488597 2197157 2197157 plaintiff Sumpter John   587801 587801 Sumpter, John, of St Osith, son of John 0
4488604 2197158 2197158 plaintiff Sumpter William   587801 587801 Sumpter, William, of St Osith, son of John 0
4508573 2203156 2203156 defendant Levynge Robert   587801 587801 Levynge, Robert, of St Osith 0
4540368 2212885 2212885 defendant Marchall Richard   587801 587801 Marchall, Richard, of St Osith 0
4540372 2212886 2212886 defendant Marchall Richard   587801 587801 Marchall, Richard, of St Osith 1
4540378 2212888 2212888 defendant Marchall Richard   587801 587801 Marchall, Richard, of St Osith 1
4542406 2213517 2213517 defendant Staunton John   587801 587801 Staunton, John, of St Osith 0
4568689 2221790 2221790 defendant Aylmer William   587801 587801 Aylmer, William, of St Osith 0
4568692 2221791 2221791 defendant Aylmer William   587801 587801 Aylmer, William, of St Osith 0
4570754 2222424 2222424 defendant Elyot John   587801 587801 Elyot, John, of St Osith 0
4570756 2222425 2222425 defendant Elyot John   587801 587801 Elyot, John, of St Osith 0
4585145 2226774 2226774 defendant Chapman John   587801 587801 Chapman, John, of St Osith 0
4586022 2227051 2227051 defendant Clerk Thomas   587801 587801 Clerk, Thomas, of St Osith 0
4599558 2231078 2231078 defendant Colman John   587801 587801 Colman, John, of St Osith 0
4605384 2232834 2232834 defendant Goldyngton Simon   587801 587801 Goldyngton, Simon, of St Osith 3
4605393 2232835 2232835 defendant Goldyngton Simon   587801 587801 Goldyngton, Simon, of St Osith 3
4609629 2234109 2234109 plaintiff Burgh William   587801 587801 Burgh, William, of St Osith 0
4628245 2239761 2239761 defendant Dyere Roger   587801 587801 Dyere, Roger, of St Osith 0
4634199 2241540 2241540 defendant Maydon Robert   587801 587801 Maydon, Robert, of St Osith 0
4640493 2243332 2243332 plaintiff Durant John   587801 587801 Durant, John, of St Osith 0
4655977 2247748 2247748 plaintiff Burman John   587801 587801 Burman, John, of St Osith 0
4726374 2273533 2273533 defendant Smyth John smith 587801 587801 Smyth, John, of St Osith, smith 1
4726378 2273534 2273534 defendant Smyth John smith 587801 587801 Smyth, John, of St Osith, smith 1
4751490 2280918 2280918 defendant St Cler William gent 587801 587801 St Cler, William, of St Osith, gent 0
4751491 2280919 2280919 plaintiff Sloman John   587801 587801 Sloman, John, of St Osith, abbot 0
4751492 2280919 2280919 defendant St Cler William gent 587801 587801 St Cler, William, of St Osith, gent 0
4751493 2280919 2280919 defendant Claketon William yeoman 587801 587801 Claketon, William, of St Osith, yeoman 1
4751764 2281006 2281006 defendant Clakton William yeoman 587801 587801 Clakton, William, of St Osith, yeoman 0
4751766 2281007 2281007 defendant St Clare William gent 587801 587801 St Clare, William, of St Osith, gent 0
4751767 2281007 2281007 defendant Potter Thomas laborer 587801 587801 Potter, Thomas, of St Osith, laborer 1
4773769 2287771 2287771 plaintiff Ewell John   587801 587801 Ewell, John, of St Osith 2
4781634 2290268 2290268 plaintiff Ewell John   587801 587801 Ewell, John, of St Osith 2
4789428 2292759 2292759 defendant Seynt Cler Swilliam gent 587801 587801 Seynt Cler, Swilliam, of St Osith, gent 0
4795409 2294720 2294720 defendant Kyrkeby Nicholas   587801 587801 Kyrkeby, Nicholas, of St Osith, servant 3
4795410 2294720 2294720 defendant Clerk Thomas   587801 587801 Clerk, Thomas, of St Osith, servant 4
4795411 2294720 2294720 defendant Bedell John   587801 587801 Bedell, John, of St Osith baker 5
4795412 2294720 2294720 defendant Chirche John   587801 587801 together with Chirche, John, of St Osith, bell ringer 6
4796740 2295135 2295135 defendant Frethe John gent 587801 587801 Frethe, John, of St Osith, gent 0
4796741 2295136 2295136 plaintiff Seyntcler William esq 587801 587801 Seyntcler, William, of St Osith, esq 0
4797874 2295515 2295515 defendant Lithyng William husbandman 587801 587801 Lithyng, William, of St Osith, husbandman 0
4806668 2298296 2298296 plaintiff Chapman John   587801 587801 Chapman, John, of St Osith 0
4823222 2303351 2303351 defendant Cok John shipman 587801 587801 (Cok, John, of St Osith, shipman 1
4823223 2303351 2303351 defendant Story Margaret widow 587801 587801 Story, Margaret, of St Osith, widow 2
4848924 2311130 2311130 plaintiff Smyth Richard   587801 587801 Smyth, Richard, of St Osith 0
4848925 2311130 2311130 defendant Mason Saierus   587801 587801 Mason, Saierus, of St Osith, glove maker 0
4849314 2311264 2311264 defendant Lylye Thomas   587801 587801 Lylye, Thomas, of St Osith, wright 0
4849315 2311264 2311264 defendant Plat William laborer 587801 587801 Plat, William, of St Osith, laborer 1
4851642 2311948 2311948 defendant Jacob Simon skinner 587801 587801 Jacob, Simon, of St Osith, skinner 1
4855549 2313099 2313099 plaintiff at Fryth John   587801 587801 at Fryth, John, of St Osith 0
4855550 2313099 2313099 defendant Koc John shipman 587801 587801 Koc, John, of St Osith, shipman 0
4874128 2318849 2318849 defendant Hunte John yeoman 587801 587801 Hunte, John, of St Osith, yeoman 0
4877391 2319884 2319884 defendant Wilby Richard husbandman 587801 587801 Wilby, Richard, of St Osith, husbandman 0
4877392 2319884 2319884 defendant Cok John shipman 587801 587801 Cok, John, of St Osith, shipman 1
4877694 2319984 2319984 defendant Cok Geoffrey husbandman 587801 587801 Cok, Geoffrey, of St Osith, husbandman 4
4877695 2319984 2319984 defendant Stalker John husbandman 587801 587801 Stalker, John, of St Osith, husbandman 5
4879158 2320420 2320420 defendant Hunte John yeoman 587801 587801 Hunte, John, of St Osith, yeoman 1
4879411 2320492 2320492 defendant Seyntclere William gent 587801 587801 Seyntclere, William, of St Osith, gent 0
4879412 2320492 2320492 defendant Huberd Thomas yeoman 587801 587801 Huberd, Thomas, of St Osith, yeoman 1
4879413 2320492 2320492 defendant Claghton William yeoman 587801 587801 Claghton, William, of St Osith, yeoman 2
4879414 2320492 2320492 defendant Claghton John laborer 587801 587801 Claghton, John, of St Osith, laborer 3
4879415 2320492 2320492 defendant Strawe Robert laborer 587801 587801 Strawe, Robert, of St Osith, laborer 4
4915269 2331281 2331281 plaintiff Depyng John   587801 587801 Depyng, John, of St Osith, abbot 0
4923275 2333701 2333701 defendant Fransham Henry husbandman 587801 587801 Fransham, Henry, of St Osith, husbandman 1
4940868 2339170 2339170 defendant Derby Thomas   587801 587801 Derby, Thomas, of St Osith, mason 0
4940869 2339170 2339170 defendant Crane John husbandman 587801 587801 Crane, John, of St Osith, husbandman 1
4953305 2342951 2342951 defendant Pecche William   587801 587801 Pecche, William, of St Osith, "wereward" 0
4956774 2343983 2343983 defendant Sparke Robert husbandman 587801 587801 Sparke, Robert, of St Osith, husbandman 0
4972460 2348695 2348695 defendant Wylby Richard husbandman 587801 587801 Wylby, Richard, of St Osith, husbandman 0
4984763 2352373 2352373 defendant Hall John husbandman 587801 587801 Hall, John, of St Osith, husbandman 0
4984766 2352373 2352373 defendant Wilby Richard husbandman 587801 587801 Wilby, Richard, of St Osith, husbandman 3
4986363 2352848 2352848 defendant Sabeern William skinner 587801 587801 Sabeern, William, of St Osith, skinner 0
5020168 2362787 2362787 defendant Brid or Bird Alice widow 587801 587801 Brid or Bird, Alice, of St Osith, widow 1
5020194 2362795 2362795 plaintiff Mathewe John   587801 587801 Mathewe, John, of St Osith 1
5023205 2363688 2363688 plaintiff Halle John   587801 587801 Halle, John, of St Osith 0
5023206 2363688 2363688 defendant Dymmok John yeoman 587801 587801 Dymmok, John, of St Osith, yeoman 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);