names

107 rows where place_id = 586026

✎ 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
3587729 1863807 1863807 defendant Turke Gilbert laborer 586026 586026 Turke, Gilbert, of Wadeherst, laborer 8
3592382 1865232 1865232 defendant Aylmot William laborer 586026 586026 Aylmot, William, of Wadeherst, laborer 5
3601807 1868224 1868224 plaintiff Benge John, senior (legal representative) 586026 586026 Benge, John, senior, of Wadeherst, executrix of 0
3601811 1868224 1868224 defendant Levyshoth John smith 586026 586026 Levyshoth, John, of Wadeherst, smith 2
3607152 1869901 1869901 defendant Turke William, junior husbandman 586026 586026 Turke, William, junior, of Wadeherst, husbandman 0
3616095 1872671 1872671 defendant Marchall William chaplain 586026 586026 Marchall, William, of Wadeherst, chaplain 0
3616097 1872672 1872672 defendant Marchall William chaplain 586026 586026 Marchall, William, of Wadeherst, chaplain 0
3620866 1874089 1874089 defendant Benge John gent 586026 586026 Benge, John, of Wadeherst, gent 0
3647992 1909775 1909775 plaintiff May Thomas (legal representative) 586026 586026 May, Thomas, of Wadeherst, executors of 0
3647999 1909776 1909776 plaintiff May Thomas (legal representative) 586026 586026 May, Thomas, of Wadeherst, executors of 0
3722793 1933395 1933395 defendant Yong William husbandman 586026 586026 Yong, William, of Wadeherst, husbandman 0
3738089 1938131 1938131 defendant Tompkyn John   586026 586026 Tompkyn, John, of Wadeherst, ash burner 0
3757981 1944479 1944479 defendant Whitfeld Robert yeoman 586026 586026 Whitfeld, Robert, of Wadeherst, yeoman 0
3768716 1947862 1947862 defendant Farne Emma widow 586026 586026 Farne, Emma, of Wadeherst, widow 0
3768717 1947862 1947862 defendant Farne William husbandman 586026 586026 Farne, William, of Wadeherst, husbandman 1
3768718 1947862 1947862 defendant Batys Christopher husbandman 586026 586026 Batys, Christopher, of Wadeherst, husbandman 2
3781593 1951980 1951980 plaintiff Harrys Walter   586026 586026 Harrys, Walter, of Wadeherst 0
3781595 1951981 1951981 plaintiff Harrys Walter   586026 586026 Harrys, Walter, of Wadeherst 0
3805119 1959543 1959543 defendant Wood Roger yeoman 586026 586026 Wood, Roger, of Wadeherst, yeoman 1
3807192 1960146 1960146 plaintiff Whytfeld Robert clothier 586026 586026 Whytfeld, Robert, of Wadeherst, clothier 0
4256675 2115206 2115206 defendant Olyff William yeoman 586026 586026 Olyff, William, of Wadeherst, yeoman 0
4462464 2188953 2188953 defendant Peny John   586026 586026 Peny, John, of Wadeherst 1
4566586 2221121 2221121 defendant Freke William   586026 586026 Freke, William, of Wadeherst 0
4577594 2224501 2224501 defendant atte Forde John   586026 586026 atte Forde, John, of Wadeherst 0
4580174 2225288 2225288 defendant Freke William   586026 586026 Freke, William, of Wadeherst 0
4587028 2227349 2227349 defendant Webbe Lawrence   586026 586026 Webbe, Lawrence, of Wadeherst 0
4630239 2240367 2240367 defendant Freke Thomas   586026 586026 Freke, Thomas, of Wadeherst 0
4658420 2248513 2248513 defendant Birchet John turner 586026 586026 Birchet, John, of Wadeherst, turner 0
4658422 2248514 2248514 defendant Birchet John turner 586026 586026 Birchet, John, of Wadeherst, turner 0
4672363 2257005 2257005 defendant Catte Henry laborer 586026 586026 Catte, Henry, of Wadeherst, laborer 0
4678968 2259030 2259030 defendant Freke Thomas parker 586026 586026 Freke, Thomas, of Wadeherst, parker 1
4684218 2260667 2260667 plaintiff Praty Thomas   586026 586026 Praty, Thomas, of Wadeherst 0
4703240 2266392 2266392 defendant Durant William   586026 586026 Durant, William, of Wadeherst, plough man 2
4703241 2266392 2266392 defendant Freke Thomas   586026 586026 Freke, Thomas, of Wadeherst, park man 3
4757900 2282846 2282846 plaintiff Broun Thomas   586026 586026 Broun, Thomas, of Wadeherst 0
4757901 2282846 2282846 defendant Erle Thomas husbandman 586026 586026 Erle, Thomas, of Wadeherst, husbandman 0
4786309 2291763 2291763 defendant Wouborne John husbandman 586026 586026 Wouborne, John, of Wadeherst, husbandman 0
4786310 2291763 2291763 defendant Bakere Thomas laborer 586026 586026 Bakere, Thomas, of Wadeherst, laborer 1
4786311 2291763 2291763 defendant Benyt John laborer 586026 586026 Benyt, John, of Wadeherst, laborer 2
4786312 2291763 2291763 defendant Bakere Thomas tiler 586026 586026 Bakere, Thomas, of Wadeherst, tiler 3
4786313 2291763 2291763 defendant Trowere John husbandman 586026 586026 Trowere, John, of Wadeherst, husbandman 4
4813112 2300218 2300218 defendant Westoune Richard laborer 586026 586026 Westoune, Richard, of Wadeherst, laborer 0
4819945 2302315 2302315 plaintiff Praty Thomas   586026 586026 Praty, Thomas, of Wadeherst 0
4826498 2304325 2304325 defendant Salle Robert   586026 586026 Salle, Robert, of Wadeherst, vicar 0
4874218 2318880 2318880 defendant Water Robert husbandman 586026 586026 Water, Robert, of Wadeherst, husbandman 0
4916175 2331561 2331561 defendant Oluve John baker 586026 586026 Oluve, John, of Wadeherst, baker 1
4916176 2331561 2331561 defendant Beuke John, junior hosier 586026 586026 Beuke, John, junior, of Wadeherst, hosier 2
4931499 2336233 2336233 defendant Frek Thomas husbandman 586026 586026 Frek, Thomas, of Wadeherst, husbandman 0
4941416 2339338 2339338 plaintiff Erl Thomas   586026 586026 Erl, Thomas, of Wadeherst, husbandman, administrators of 0
4941418 2339338 2339338 defendant Stoner Richard husbandman 586026 586026 Stoner, Richard, of Wadeherst, husbandman 0
4941419 2339339 2339339 plaintiff Erl Thomas   586026 586026 Erl, Thomas, of Wadeherst, husbandman, administrators of 0
4941421 2339339 2339339 defendant Stoner Richard husbandman 586026 586026 Stoner, Richard, of Wadeherst, husbandman 0
4962392 2345656 2345656 defendant Yonge Roger husbandman 586026 586026 Yonge, Roger, of Wadeherst, husbandman 0
4987229 2353128 2353128 defendant Mette William husbandman 586026 586026 Mette, William, of Wadeherst, husbandman 0
4994585 2355240 2355240 defendant Wyrall Nicholas   586026 586026 Wyrall, Nicholas, of Wadeherst, vicar 0
5004516 2358220 2358220 defendant Youngge John laborer 586026 586026 Youngge, John, of Wadeherst, laborer 2
5004520 2358221 2358221 defendant Youngge John laborer 586026 586026 Youngge, John, of Wadeherst, laborer 2
5024529 2364088 2364088 defendant Busse John husbandman 586026 586026 Busse, John, of Wadeherst, husbandman 0
5053216 2372563 2372563 defendant Bele Lawrence husbandman 586026 586026 Bele, Lawrence, of Wadeherst, husbandman 0
5069411 2377346 2377346 defendant Fygge Walter shoemaker 586026 586026 Fygge, Walter, of Wadeherst, shoemaker 0
5109313 2389151 2389151 defendant Playsted John clerk 586026 586026 Playsted, John, of Wadeherst, clerk 0
5268386 2435880 2435880 defendant Crotynden Simon husbandman 586026 586026 Crotynden, Simon, of Wadeherst, husbandman 1
5286107 2440946 2440946 defendant Crotynden Simon husbandman or yeoman 586026 586026 Crotynden, Simon, of Wadeherst, husbandman or yeoman 0
5292591 2442828 2442828 defendant atte Hole John weaver or husbandman 586026 586026 atte Hole, John, of Wadeherst, weaver or husbandman 3
5312575 2448794 2448794 plaintiff Barham John   586026 586026 Barham, John, of Wadeherst 0
5332501 2454784 2454784 defendant Cherdson Simon husbandman 586026 586026 Cherdson, Simon, of Wadeherst, husbandman 2
5332502 2454784 2454784 defendant Rysden John, junior parker 586026 586026 Rysden, John, junior, of Wadeherst, parker 3
5359756 2463091 2463091 defendant Yong John husbandman 586026 586026 Yong, John, of Wadeherst, husbandman 0
5376260 2468169 2468169 defendant Fyssher Margaret widow 586026 586026 Fyssher, Margaret, of Wadeherst, widow 0
5376261 2468169 2468169 defendant Crotynden Thomas laborer 586026 586026 Crotynden, Thomas, of Wadeherst, laborer 1
5379784 2469259 2469259 defendant Fyssher Margery widow 586026 586026 Fyssher, Margery, of Wadeherst, widow 1
5392073 2472813 2472813 defendant Leveshoth John smith 586026 586026 Leveshoth, John, of Wadeherst, smith 0
5392825 2473020 2473020 defendant Crotynden Thomas laborer 586026 586026 Crotynden, Thomas, of Wadeherst, laborer 0
5394188 2473397 2473397 defendant Bate Nicholas husbandman 586026 586026 Bate, Nicholas, of Wadeherst, husbandman 0
5409910 2477934 2477934 defendant Chambyr Katherine widow 586026 586026 (Chambyr, Katherine, of Wadeherst, widow 1
5409911 2477934 2477934 defendant Chambyr Thomas laborer 586026 586026 Chambyr, Thomas, of Wadeherst, laborer 2
5417852 2480266 2480266 defendant Tokyngherst John smith 586026 586026 Tokyngherst, John, of Wadeherst, smith 0
5425242 2482520 2482520 defendant Kyngewode Thomas yeoman 586026 586026 Kyngewode, Thomas, of Wadeherst, yeoman 0
5425243 2482520 2482520 defendant Leveshothe John smith 586026 586026 Leveshothe, John, of Wadeherst, smith 1
5425244 2482520 2482520 defendant Berham William tailor 586026 586026 Berham, William, of Wadeherst, tailor 2
5426245 2482803 2482803 defendant Tokyngherst John smith 586026 586026 Tokyngherst, John, of Wadeherst, smith 0
5443708 2488041 2488041 defendant Berham William tailor 586026 586026 Berham, William, of Wadeherst, tailor 1
5443709 2488041 2488041 defendant Kyngewod Thomas yeoman 586026 586026 Kyngewod, Thomas, of Wadeherst, yeoman 2
5443833 2488072 2488072 defendant Leveshoth John cutler 586026 586026 Leveshoth, John, of Wadeherst, cutler 0
5456530 2491880 2491880 defendant Leveshoth John cutler 586026 586026 Leveshoth, John, of Wadeherst, cutler 0
5487836 2501250 2501250 defendant Broun William husbandman 586026 586026 Broun, William, of Wadeherst, husbandman 0
5487847 2501253 2501253 defendant Broun William husbandman 586026 586026 Broun, William, of Wadeherst, husbandman 0
5491004 2502210 2502210 defendant Berham Richard (legal representative) 586026 586026 Berham, Richard, of Wadeherst, husbandman, executors of 0
5491005 2502210 2502210 defendant Long John pulter 586026 586026 (Long, John, of Wadeherst, pulter 1
5497149 2504086 2504086 defendant Cherson Simon (legal representative) 586026 586026 Cherson, Simon, of Wadeherst, husbandman, executors of 1
5497150 2504086 2504086 defendant Cherson Alice widow 586026 586026 (Cherson, Alice, of Wadeherst, widow 2
5497151 2504086 2504086 defendant Lukke William husbandman 586026 586026 Lukke, William, of Wadeherst, husbandman 3
5497731 2504265 2504265 defendant Godyng Richard husbandman 586026 586026 Godyng, Richard, of Wadeherst, husbandman 0
5497735 2504265 2504265 defendant Bate Nicholas yeoman 586026 586026 Bate, Nicholas, of Wadeherst, yeoman 4
5497737 2504266 2504266 defendant Godyng Richard husbandman 586026 586026 Godyng, Richard, of Wadeherst, husbandman 0
5497741 2504266 2504266 defendant Bate Nicholas yeoman 586026 586026 Bate, Nicholas, of Wadeherst, yeoman 4
5509238 2507746 2507746 defendant Hoget William husbandman 586026 586026 Hoget, William, of Wadeherst, husbandman 1
5512010 2508615 2508615 defendant Cherson Simon (legal representative) 586026 586026 Cherson, Simon, of Wadeherst, husbandman, executors of 0
5512011 2508615 2508615 defendant Cherson Alice widow 586026 586026 (Cherson, Alice, of Wadeherst, widow 1
5512012 2508615 2508615 defendant Lukke William cordwainer 586026 586026 Lukke, William, of Wadeherst, cordwainer 2

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