names

108 rows where place_id = 592107

✎ 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
3606590 1869735 1869735 plaintiff Orell David gent 592107 592107 Orell, David, of Wysebech, gent 0
4422629 2171934 2171934 plaintiff Everard Bartholomew   592107 592107 Everard, Bartholomew, of Wysebech, knight 0
4422630 2171934 2171934 defendant Curteys Reginald   592107 592107 Curteys, Reginald, of Wysebech 0
4422631 2171934 2171934 defendant Benneys Warin   592107 592107 Benneys, Warin, of Wysebech 1
4422632 2171934 2171934 defendant Martyn Thomas   592107 592107 Martyn, Thomas, of Wysebech 2
4422633 2171934 2171934 defendant Hervy John   592107 592107 Hervy, John, of Wysebech 3
4425000 2172657 2172657 defendant Beauveys Adam   592107 592107 Beauveys, Adam, of Wysebech 0
4453551 2186121 2186121 plaintiff Lenn Reginald de   592107 592107 Lenn, Reginald de, of Wysebech 0
4470725 2191494 2191494 defendant Ferrour Thomas   592107 592107 Ferrour, Thomas, of Wysebech 0
4470727 2191495 2191495 defendant Ferrour Thomas   592107 592107 Ferrour, Thomas, of Wysebech 0
4470729 2191496 2191496 defendant Rokelond Robert   592107 592107 Rokelond, Robert, of Wysebech 0
4470731 2191497 2191497 defendant Rokelond Robert   592107 592107 Rokelond, Robert, of Wysebech 0
4475718 2193083 2193083 defendant Sadeler Alexander   592107 592107 Sadeler, Alexander, of Wysebech 0
4475721 2193083 2193083 defendant Bochere Thomas   592107 592107 Bochere, Thomas, of Wysebech 3
4479982 2194405 2194405 defendant Ferour Thomas   592107 592107 Ferour, Thomas, of Wysebech 0
4484222 2195765 2195765 defendant Leyghton Simon   592107 592107 Leyghton, Simon, of Wysebech 0
4484223 2195765 2195765 defendant (illegible) Thomas   592107 592107 ----, Thomas, of Wysebech 1
4484225 2195766 2195766 defendant Leyghton Simon   592107 592107 Leyghton, Simon, of Wysebech 0
4484226 2195766 2195766 defendant Ferrour Thomas   592107 592107 Ferrour, Thomas, of Wysebech 1
4488566 2197144 2197144 plaintiff Style William   592107 592107 Style, William, of Wysebech 0
4495122 2199162 2199162 defendant Wysebech John   592107 592107 Wysebech, John, of Wysebech 0
4504944 2202088 2202088 plaintiff Sherman Adam   592107 592107 Sherman, Adam, of Wysebech, on his own account 0
4508595 2203166 2203166 plaintiff Alisaunder Edmund butcher 592107 592107 Alisaunder, Edmund, of Wysebech, butcher 0
4518029 2206015 2206015 plaintiff Davy Richard   592107 592107 Davy, Richard, of Wysebech 0
4518030 2206015 2206015 defendant Ferrour Walter   592107 592107 Ferrour, Walter, of Wysebech 0
4518031 2206015 2206015 defendant Taillour Thomas   592107 592107 Taillour, Thomas, of Wysebech 1
4518043 2206018 2206018 defendant Taillour Thomas   592107 592107 Taillour, Thomas, of Wysebech 1
4525328 2208263 2208263 plaintiff Isookes Thomas   592107 592107 Isookes, Thomas, of Wysebech 0
4525329 2208263 2208263 defendant Ketyll William   592107 592107 Ketyll, William, of Wysebech 0
4529322 2209454 2209454 defendant Pokedych John   592107 592107 Pokedych, John, of Wysebech 0
4529641 2209551 2209551 defendant Lether William   592107 592107 Lether, William, of Wysebech 0
4529642 2209551 2209551 defendant Reson Thomas   592107 592107 Reson, Thomas, of Wysebech 1
4537780 2212095 2212095 plaintiff Taverner Alexander   592107 592107 Taverner, Alexander, of Wysebech 0
4537868 2212129 2212129 plaintiff Tewe Thomas   592107 592107 Tewe, Thomas, of Wysebech 0
4539089 2212497 2212497 defendant Smyth Richard   592107 592107 Smyth, Richard, of Wysebech 4
4545243 2214434 2214434 defendant Ropere John   592107 592107 Ropere, John, of Wysebech 0
4548559 2215490 2215490 plaintiff Claycroft John   592107 592107 Claycroft, John, of Wysebech 0
4548560 2215490 2215490 defendant Reddyk Hugh   592107 592107 Reddyk, Hugh, of Wysebech 0
4548561 2215490 2215490 defendant Fyscher Thomas   592107 592107 Fyscher, Thomas, of Wysebech 1
4550262 2216029 2216029 plaintiff Dagelard Reginald   592107 592107 Dagelard, Reginald, of Wysebech 0
4578295 2224704 2224704 defendant Tugh Thomas   592107 592107 Tugh, Thomas, of Wysebech 1
4589372 2228053 2228053 defendant Harwedon John   592107 592107 Harwedon, John, of Wysebech 0
4616820 2236262 2236262 defendant Haunowe William   592107 592107 Haunowe, William, of Wysebech 1
4620664 2237452 2237452 plaintiff Joseph John   592107 592107 Joseph, John, of Wysebech, sirotecarius or glove maker 0
4620665 2237452 2237452 defendant Bedforth John   592107 592107 Bedforth, John, of Wysebech 0
4638586 2242822 2242822 plaintiff Cave Richard   592107 592107 Cave, Richard, of Wysebech 0
4639378 2243030 2243030 defendant Austyn John   592107 592107 Austyn, John, of Wysebech 1
4640811 2243413 2243413 defendant Bocher Richard   592107 592107 Bocher, Richard, of Wysebech 4
4640817 2243414 2243414 defendant Bocher Richard   592107 592107 Bocher, Richard, of Wysebech 4
4647182 2245228 2245228 plaintiff Sadelere William   592107 592107 Sadelere, William, of Wysebech 0
4681588 2259855 2259855 defendant Saundre Thomas laborer 592107 592107 Saundre, Thomas, of Wysebech, laborer 3
4683364 2260398 2260398 defendant cokere Walter husbandman 592107 592107 cokere, Walter, of Wysebech, husbandman 4
4726856 2273666 2273666 defendant Mast William husbandman 592107 592107 Mast, William, of Wysebech, husbandman 1
4726857 2273666 2273666 defendant Alden Thomas husbandman 592107 592107 Alden, Thomas, of Wysebech, husbandman 2
4731524 2275056 2275056 defendant Tolyet Roger husbandman 592107 592107 Tolyet, Roger, of Wysebech, husbandman 0
4742398 2278269 2278269 defendant Salter William husbandman 592107 592107 Salter, William, of Wysebech, husbandman 0
4747979 2279919 2279919 plaintiff Lombe John   592107 592107 Lombe, John, of Wysebech 0
4752132 2281104 2281104 defendant Averell Richard husbandman 592107 592107 Averell, Richard, of Wysebech, husbandman 1
4790779 2293202 2293202 defendant Dounham John miller 592107 592107 Dounham, John, of Wysebech, miller 0
4810865 2299521 2299521 defendant Mannyng John husbandman 592107 592107 Mannyng, John, of Wysebech, husbandman 0
4810866 2299521 2299521 defendant Kepe John husbandman 592107 592107 Kepe, John, of Wysebech, husbandman 1
4839975 2308415 2308415 defendant Worme Ellis dyer 592107 592107 Worme, Ellis, of Wysebech, dyer 1
4839980 2308416 2308416 defendant Worme Elis dyer 592107 592107 Worme, Elis, of Wysebech, dyer 1
4884465 2322044 2322044 defendant White John yeoman 592107 592107 (White, John, of Wysebech, yeoman 1
4884466 2322044 2322044 defendant Lylye John chaplain 592107 592107 Lylye, John, of Wysebech, chaplain 2
4884467 2322044 2322044 defendant Kepe John yeoman 592107 592107 Kepe, John, of Wysebech, yeoman 3
4890771 2323862 2323862 defendant White John yeoman 592107 592107 (White, John, of Wysebech, yeoman 1
4890772 2323862 2323862 defendant Lylie John chaplain 592107 592107 Lylie, John, of Wysebech, chaplain 2
4890773 2323862 2323862 defendant Kepe John yeoman 592107 592107 Kepe, John, of Wysebech, yeoman 3
4917494 2331985 2331985 defendant Godesoule John husbandman 592107 592107 Godesoule, John, of Wysebech, husbandman 1
4924001 2333947 2333947 defendant Sutton Geoffrey esq 592107 592107 Sutton, Geoffrey, of Wysebech, esq 1
4924002 2333947 2333947 defendant de Grene William yeoman 592107 592107 de Grene, William, of Wysebech, yeoman 2
4924003 2333947 2333947 defendant Abell Ralph yeoman 592107 592107 Abell, Ralph, of Wysebech, yeoman 3
4945047 2340434 2340434 defendant Mannyng John husbandman 592107 592107 Mannyng, John, of Wysebech, husbandman 0
4945048 2340434 2340434 defendant Grey William husbandman 592107 592107 Grey, William, of Wysebech, husbandman 1
4986679 2352949 2352949 defendant Mayhew Martin brewer 592107 592107 Mayhew, Martin, of Wysebech, brewer 0
5005221 2358423 2358423 defendant Wrigh John husbandman 592107 592107 Wrigh, John, of Wysebech, husbandman 2
5025700 2364420 2364420 defendant Lytster John husbandman 592107 592107 Lytster, John, of Wysebech, husbandman 0
5026822 2364716 2364716 defendant Sadeler Margery widow 592107 592107 Sadeler, Margery, of Wysebech, widow 5
5043291 2369618 2369618 plaintiff Foke John   592107 592107 Foke, John, of Wysebech 0
5043293 2369618 2369618 defendant Adamson John yeoman 592107 592107 Adamson, John, of Wysebech, yeoman 1
5043294 2369618 2369618 defendant Goodsowle John husbandman 592107 592107 Goodsowle, John, of Wysebech, husbandman 2
5043295 2369619 2369619 plaintiff Foke John   592107 592107 Foke, John, of Wysebech 0
5048397 2371159 2371159 defendant Lombe Richard brewer 592107 592107 Lombe, Richard, of Wysebech, brewer 0
5060184 2374619 2374619 plaintiff Foke John   592107 592107 Foke, John, of Wysebech 0
5060185 2374619 2374619 defendant Childeronce or Childerouce William brewer 592107 592107 Childeronce or Childerouce, William, of Wysebech, brewer 0
5060186 2374619 2374619 defendant Amy John husbandman 592107 592107 Amy, John, of Wysebech, husbandman 1
5060188 2374619 2374619 defendant Goodsoule John husbandman 592107 592107 Goodsoule, John, of Wysebech, husbandman 3
5090724 2383674 2383674 defendant Abell Ralph cooper 592107 592107 Abell, Ralph, of Wysebech, cooper 0
5185192 2411417 2411417 plaintiff Foke John   592107 592107 Foke, John, of Wysebech 0
5185195 2411417 2411417 defendant Buk John tailor 592107 592107 (Buk, John, of Wysebech, tailor 2
5218569 2421164 2421164 plaintiff Grene John   592107 592107 Grene, John, of Wysebech 0
5218570 2421164 2421164 defendant Adamson John yeoman 592107 592107 Adamson, John, of Wysebech, yeoman 0
5226872 2423524 2423524 defendant Wylsy William Walter 592107 592107 Wylsy, William, of Wysebech, husbandman, servant of Notesson, Walter 0
5245726 2428914 2428914 defendant Everard John gent 592107 592107 Everard, John, of Wysebech, gent 0
5269464 2436168 2436168 plaintiff Caus Richard   592107 592107 Caus, Richard, of Wysebech 0
5269467 2436169 2436169 plaintiff Caus Richard   592107 592107 Caus, Richard, of Wysebech 0
5302593 2445750 2445750 plaintiff Foke John   592107 592107 Foke, John, of Wysebech 0
5302596 2445750 2445750 defendant Fyssher John husbandman 592107 592107 Fyssher, John, of Wysebech, husbandman 2
5361844 2463732 2463732 defendant Hawe John (legal representative) 592107 592107 Hawe, John, of Wysebech, executor of 3

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