names

254 rows where place_id = 587921

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592838 1865376 1865376 plaintiff Grouter Victor   587921 587921 Grouter, Victor, of Stanton 0
3604549 1869087 1869087 defendant Sternndall John yeoman 587921 587921 Sternndall, John, of Stanton, yeoman 0
3605402 1869357 1869357 defendant Balhed Robert husbandman 587921 587921 Balhed, Robert, of Stanton, husbandman 1
3605719 1869451 1869451 defendant Balhed Robert husbandman 587921 587921 Balhed, Robert, of Stanton, husbandman 1
3608655 1870367 1870367 defendant Wellys Geoffrey yeoman 587921 587921 Wellys, Geoffrey, of Stanton, yeoman 2
3609429 1870612 1870612 defendant Balhed Robert yeoman 587921 587921 Balhed, Robert, of Stanton, yeoman 2
3629992 1904232 1904232 defendant Penyale John   587921 587921 Penyale, John, of Stanton, shepherd 0
3631313 1904603 1904603 defendant Maister Simon smith 587921 587921 Maister, Simon, of Stanton, smith 0
3631446 1904647 1904647 defendant Maister Simon smith 587921 587921 Maister, Simon, of Stanton, smith 0
3638681 1906911 1906911 defendant Balled Robert yeoman 587921 587921 Balled, Robert, of Stanton, yeoman 0
3639516 1907166 1907166 defendant Clerk Simon husbandman 587921 587921 Clerk, Simon, of Stanton, husbandman 0
3640079 1907343 1907343 defendant Clerk Simon husbandman 587921 587921 Clerk, Simon, of Stanton, husbandman 2
3641157 1907684 1907684 defendant Wanton Andrew (legal representative) 587921 587921 Wanton, Andrew, of Stanton, executor of 0
3642570 1908119 1908119 defendant Baker Edmund yeoman 587921 587921 Baker, Edmund, of Stanton, yeoman 0
3645140 1908887 1908887 defendant Master Simon smith 587921 587921 Master, Simon, of Stanton, smith 2
3646313 1909239 1909239 plaintiff Holyer John   587921 587921 Holyer, John, of Stanton, administrators of 0
3646317 1909239 1909239 defendant Elys Thomas husbandman 587921 587921 Elys, Thomas, of Stanton, husbandman 1
3646318 1909239 1909239 defendant Master Simon husbandman 587921 587921 Master, Simon, of Stanton, husbandman 2
3651663 1910880 1910880 defendant Balhed Robert yeoman 587921 587921 Balhed, Robert, of Stanton, yeoman 1
3656197 1912185 1912185 defendant Blomfeld William husbandman 587921 587921 Blomfeld, William, of Stanton, husbandman 2
3658969 1913070 1913070 plaintiff Furmage Nicholas (legal representative) 587921 587921 Furmage, Nicholas, of Stanton, yeoman, executors of 0
3658972 1913070 1913070 defendant Baker Edmund husbandman 587921 587921 Baker, Edmund, of Stanton, husbandman 0
3658973 1913071 1913071 plaintiff Furmage Nicholas (legal representative) 587921 587921 Furmage, Nicholas, of Stanton, yeoman, executors of 0
3658976 1913071 1913071 defendant Baker Edmund husbandman 587921 587921 Baker, Edmund, of Stanton, husbandman 0
3668602 1916130 1916130 defendant Pylkyngton Edmund esq 587921 587921 Pylkyngton, Edmund, of Stanton, esq 1
3671308 1917000 1917000 defendant Johnson Christopher clerk 587921 587921 Johnson, Christopher, of Stanton, clerk 0
3675313 1918321 1918321 defendant Turnour Richard yeoman 587921 587921 Turnour, Richard, of Stanton, yeoman 1
3677978 1919156 1919156 defendant Langley Edmund husbandman 587921 587921 Langley, Edmund, of Stanton, husbandman 0
3682483 1920624 1920624 defendant Nutte Robert husbandman 587921 587921 Nutte, Robert, of Stanton, husbandman 0
3682484 1920624 1920624 defendant Blomfeld William laborer 587921 587921 Blomfeld, William, of Stanton, laborer 1
3688938 1922700 1922700 defendant Fraunces Richard husbandman 587921 587921 Fraunces, Richard, of Stanton, husbandman 0
3694209 1924391 1924391 defendant Page Robert   587921 587921 Page, Robert, of Stanton, tile maker 7
3694210 1924391 1924391 defendant Tryker William husbandman 587921 587921 Tryker, William, of Stanton, husbandman 8
3697940 1925577 1925577 defendant Clerke Simon husbandman 587921 587921 Clerke, Simon, of Stanton, husbandman 0
3703225 1927279 1927279 defendant Taylour Thomas yeoman 587921 587921 Taylour, Thomas, of Stanton, yeoman 0
3708223 1928865 1928865 defendant Page Robert   587921 587921 Page, Robert, of Stanton, tile maker 3
3722202 1933203 1933203 defendant Langley Edmund husbandman 587921 587921 Langley, Edmund, of Stanton, husbandman 0
3761530 1945617 1945617 defendant Fenwyk Ralph   587921 587921 Fenwyk, Ralph, of Stanton, knight 0
3765967 1947025 1947025 defendant Baker Edmund husbandman 587921 587921 Baker, Edmund, of Stanton, husbandman 1
3775732 1950159 1950159 defendant Larke Robert laborer 587921 587921 Larke, Robert, of Stanton, laborer 0
3775733 1950159 1950159 defendant Baker Edmund husbandman 587921 587921 Baker, Edmund, of Stanton, husbandman 1
3779683 1951381 1951381 defendant Fenwyk Ralph   587921 587921 Fenwyk, Ralph, of Stanton, knight 0
3784319 1952881 1952881 defendant Tryker William yeoman 587921 587921 Tryker, William, of Stanton, yeoman 2
3784325 1952882 1952882 defendant Tryker William yeoman 587921 587921 Tryker, William, of Stanton, yeoman 2
3797698 1957178 1957178 defendant Atkyn William husbandman 587921 587921 Atkyn, William, of Stanton, husbandman 0
3813873 1962247 1962247 defendant Fenwyke Ralph   587921 587921 Fenwyke, Ralph, of Stanton, knight 0
3824129 1965419 1965419 defendant Brygge Christopher yeoman 587921 587921 Brygge, Christopher, of Stanton, yeoman 0
3828774 1966875 1966875 defendant Alanson Richard husbandman 587921 587921 Alanson, Richard, of Stanton, husbandman 0
3828775 1966875 1966875 defendant Alanson Richard laborer 587921 587921 Alanson, Richard, of Stanton, laborer 1
3828776 1966875 1966875 defendant Alanson William laborer 587921 587921 Alanson, William, of Stanton, laborer 2
3857108 1975854 1975854 defendant Trykker William husbandman 587921 587921 Trykker, William, of Stanton, husbandman 0
3858944 1976482 1976482 defendant Pylkyngton Edward gent 587921 587921 Pylkyngton, Edward, of Stanton, gent 0
3874410 1981669 1981669 defendant Rokewood William (legal representative) 587921 587921 Rokewood, William, of Stanton, esq, administratrix of 0
3874411 1981669 1981669 defendant Rokewood Anne widow 587921 587921 Rokewood, Anne, of Stanton, widow 1
3880608 1983777 1983777 defendant Tryker William yeoman 587921 587921 Tryker, William, of Stanton, yeoman 0
3886102 1985602 1985602 defendant Byerdley Thomas yeoman 587921 587921 Byerdley, Thomas, of Stanton, yeoman 1
3889831 1986839 1986839 plaintiff Gytto John   587921 587921 Gytto, John, of Stanton 0
3900746 1990477 1990477 defendant Tre John yeoman 587921 587921 Tre, John, of Stanton, yeoman 0
3906987 1992624 1992624 defendant Goche Thomas husbandman 587921 587921 Goche, Thomas, of Stanton, husbandman 2
3919639 1996902 1996902 defendant Wydows William yeoman 587921 587921 Wydows, William, of Stanton, yeoman 0
3929282 2000137 2000137 defendant Man Thomas husbandman 587921 587921 Man, Thomas, of Stanton, husbandman 0
3938286 2003143 2003143 defendant Taylour Robert husbandman 587921 587921 Taylour, Robert, of Stanton, husbandman 0
3938287 2003143 2003143 defendant Baker Thomas husbandman 587921 587921 Baker, Thomas, of Stanton, husbandman 1
3966455 2012902 2012902 defendant Taylor Stephen yeoman 587921 587921 Taylor, Stephen, of Stanton, yeoman 0
3969039 2013788 2013788 defendant Sowter John husbandman 587921 587921 Sowter, John, of Stanton, husbandman 0
3976299 2016281 2016281 defendant Pylkynton George gent 587921 587921 Pylkynton, George, of Stanton, gent 0
4000205 2024842 2024842 plaintiff Gooche Thomas yeoman 587921 587921 Gooche, Thomas, of Stanton, yeoman 0
4000208 2024843 2024843 plaintiff Gooche Thomas yeoman 587921 587921 Gooche, Thomas, of Stanton, yeoman 0
4000210 2024844 2024844 plaintiff Gooche Thomas yeoman 587921 587921 Gooche, Thomas, of Stanton, yeoman 0
4000668 2025013 2025013 defendant Morley John yeoman 587921 587921 Morley, John, of Stanton, yeoman 0
4033619 2036673 2036673 plaintiff Grigges Thomas weaver 587921 587921 Grigges, Thomas, of Stanton, weaver 0
4042904 2039938 2039938 defendant Wheler Richard husbandman 587921 587921 Wheler, Richard, of Stanton, husbandman 1
4064697 2047661 2047661 defendant Stevens John yeoman 587921 587921 Stevens, John, of Stanton, yeoman 0
4080545 2053355 2053355 defendant Burgoyne George gent 587921 587921 Burgoyne, George, of Stanton, gent 1
4128406 2070451 2070451 defendant Towne Robert clerk 587921 587921 Towne, Robert, of Stanton, clerk 1
4128407 2070451 2070451 defendant Turner George yeoman 587921 587921 Turner, George, of Stanton, yeoman 2
4146891 2077064 2077064 defendant Hall Richard husbandman 587921 587921 Hall, Richard, of Stanton, husbandman 1
4148786 2077696 2077696 defendant Turner George husbandman 587921 587921 Turner, George, of Stanton, husbandman 0
4158709 2081120 2081120 defendant Russell John yeoman 587921 587921 Russell, John, of Stanton, yeoman 1
4194925 2093787 2093787 defendant Chapman John yeoman 587921 587921 Chapman, John, of Stanton, yeoman 4
4201750 2096158 2096158 defendant Towne Robert clerk 587921 587921 Towne, Robert, of Stanton, clerk 1
4221061 2102861 2102861 defendant Gouche Thomas husbandman 587921 587921 Gouche, Thomas, of Stanton, husbandman 0
4230900 2106305 2106305 defendant Palmer Robert clerk 587921 587921 Palmer, Robert, of Stanton, clerk 3
4303770 2131446 2131446 defendant Taylor Edward yeoman 587921 587921 Taylor, Edward, of Stanton, yeoman 2
4304861 2131836 2131836 defendant Forman Richard victualer 587921 587921 Forman, Richard, of Stanton, victualer 0
4306245 2132321 2132321 defendant Cox Walter husbandman 587921 587921 Cox, Walter, of Stanton, husbandman 0
4319540 2136946 2136946 defendant Man John pedder 587921 587921 Man, John, of Stanton, pedder 1
4323011 2138109 2138109 defendant Bosvile Thomas gent 587921 587921 Bosvile, Thomas, of Stanton, gent 1
4330784 2140595 2140595 defendant Doo Robert yeoman 587921 587921 Doo, Robert, of Stanton, yeoman 0
4333311 2141423 2141423 defendant Poyser William husbandman 587921 587921 Poyser, William, of Stanton, husbandman 0
4333312 2141423 2141423 defendant Hoode Richard husbandman 587921 587921 Hoode, Richard, of Stanton, husbandman 1
4333313 2141423 2141423 defendant Woodcocke John husbandman 587921 587921 Woodcocke, John, of Stanton, husbandman 2
4347713 2146447 2146447 defendant Parker Thomas yeoman 587921 587921 Parker, Thomas, of Stanton, yeoman 1
4347999 2146552 2146552 defendant Childe Thomas carpenter 587921 587921 Childe, Thomas, of Stanton, carpenter 0
4385219 2159744 2159744 defendant Poyser William husbandman 587921 587921 Poyser, William, of Stanton, husbandman 0
4394083 2162623 2162623 defendant Leveriche Anthony shoemaker 587921 587921 Leveriche, Anthony, of Stanton, shoemaker 0
4406634 2166783 2166783 defendant Apperley William yeoman 587921 587921 Apperley, William, of Stanton, yeoman 0
4406635 2166783 2166783 defendant Apperley Nicholas   587921 587921 Apperley, Nicholas, of Stanton, yeoman, his brother 1
4424810 2172599 2172599 defendant Belle Walter   587921 587921 Belle, Walter, of Stanton 0
4424811 2172599 2172599 defendant Shepelherd Geoffrey le   587921 587921 Shepelherd, Geoffrey le, of Stanton 1

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