names

106 rows where place_id = 591037

✎ 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
3603120 1868641 1868641 defendant Sym John, junior husbandman 591037 591037 Sym, John, junior, of Westham, husbandman 0
3607387 1869972 1869972 defendant Radley William yeoman 591037 591037 Radley, William, of Westham, yeoman 2
3653799 1911447 1911447 defendant Atkynne William pulter 591037 591037 Atkynne, William, of Westham, pulter 0
3670811 1916835 1916835 defendant Nundy Stephen   591037 591037 Nundy, Stephen, of Westham, wheelwright 0
3676170 1918590 1918590 defendant Foster John carpenter 591037 591037 Foster, John, of Westham, carpenter 0
3676191 1918598 1918598 defendant Dancort Richard husbandman 591037 591037 Dancort, Richard, of Westham, husbandman 1
3678814 1919441 1919441 defendant Warham John yeoman 591037 591037 Warham, John, of Westham, yeoman 3
3678815 1919441 1919441 defendant Danyell John yeoman 591037 591037 Danyell, John, of Westham, yeoman 4
3682818 1920731 1920731 defendant Smyth William laborer 591037 591037 Smyth, William, of Westham, laborer 3
3688723 1922634 1922634 defendant Nundye Stephen   591037 591037 Nundye, Stephen, of Westham, wheelwright 1
3694498 1924485 1924485 defendant Awger Geoffrey fisher 591037 591037 Awger, Geoffrey, of Westham, fisher 1
3701250 1926633 1926633 defendant Bracy Robert clerk 591037 591037 Bracy, Robert, of Westham, clerk 0
3766119 1947054 1947054 defendant Frende Richard carpenter 591037 591037 Frende, Richard, of Westham, carpenter 3
3775760 1950170 1950170 defendant Clerke John fisherman 591037 591037 Clerke, John, of Westham, fisherman 0
3775761 1950170 1950170 defendant Hanger Richard laborer 591037 591037 Hanger, Richard, of Westham, laborer 1
3781324 1951901 1951901 defendant Dove Robert fisher 591037 591037 Dove, Robert, of Westham, fisher 1
3839852 1970397 1970397 defendant Alen Peter   591037 591037 Alen, Peter, of Westham, horse courser 0
3842439 1971171 1971171 defendant Stanton Richard gent 591037 591037 Stanton, Richard, of Westham, gent 0
3845124 1972035 1972035 defendant Roke William yeoman 591037 591037 Roke, William, of Westham, yeoman 0
3858785 1976423 1976423 defendant Staunton Richard gent 591037 591037 Staunton, Richard, of Westham, gent 0
3879086 1983258 1983258 defendant Drynge Thomas tanner 591037 591037 Drynge, Thomas, of Westham, tanner 0
3881750 1984148 1984148 plaintiff Sleverycke John yeoman 591037 591037 Sleverycke, John, of Westham, yeoman 0
3931382 2000792 2000792 defendant Atwell John   591037 591037 Atwell, John, of Westham 0
3987694 2020347 2020347 defendant A Vale John yeoman 591037 591037 A Vale, John, of Westham, yeoman 0
3987696 2020348 2020348 defendant Avale John yeoman 591037 591037 Avale, John, of Westham, yeoman 0
4000391 2024908 2024908 defendant Lowle John (legal representative) 591037 591037 Lowle, John, of Westham, yeoman, executors of 0
4033497 2036639 2036639 defendant Wylforde Thomas chapman 591037 591037 Wylforde, Thomas, of Westham, chapman 4
4069579 2049401 2049401 defendant Kensley Abraham yeoman 591037 591037 Kensley, Abraham, of Westham, yeoman 0
4082154 2053926 2053926 defendant Corbett Thomas yeoman 591037 591037 Corbett, Thomas, of Westham, yeoman 0
4082156 2053927 2053927 defendant Corbett Thomas yeoman 591037 591037 Corbett, Thomas, of Westham, yeoman 0
4092618 2057668 2057668 defendant Tyrry Mathew yeoman 591037 591037 Tyrry, Mathew, of Westham, yeoman 0
4178389 2087916 2087916 defendant Ades Thomas husbandman 591037 591037 Ades, Thomas, of Westham, husbandman 0
4188196 2091375 2091375 defendant Persevall John clerk 591037 591037 Persevall, John, of Westham, clerk 0
4201716 2096146 2096146 defendant Ades Thomas husbandman 591037 591037 Ades, Thomas, of Westham, husbandman 0
4229127 2105669 2105669 defendant Dixson William yeoman 591037 591037 Dixson, William, of Westham, yeoman 0
4363692 2152083 2152083 defendant Meres Thomas gent 591037 591037 Meres, Thomas, of Westham, gent 0
4500292 2200718 2200718 defendant Egmanton William   591037 591037 Egmanton, William, of Westham, parson 6
4677232 2258497 2258497 plaintiff Halman Thomas   591037 591037 Halman, Thomas, of Westham 0
4804573 2297623 2297623 defendant Lytelbery John husbandman 591037 591037 Lytelbery, John, of Westham, husbandman 0
4836971 2307521 2307521 defendant Ruddok Lambert carpenter 591037 591037 Ruddok, Lambert, of Westham, carpenter 0
4843916 2309614 2309614 defendant Alman James husbandman 591037 591037 Alman, James, of Westham, husbandman 1
4843917 2309614 2309614 defendant West William husbandman 591037 591037 West, William, of Westham, husbandman 2
4864260 2315797 2315797 defendant Norton Henry laborer 591037 591037 Norton, Henry, of Westham, laborer 7
4864267 2315800 2315800 defendant Ruddok Lambert carpenter 591037 591037 Ruddok, Lambert, of Westham, carpenter 0
4872887 2318472 2318472 defendant Colyn John smith 591037 591037 Colyn, John, of Westham, smith 3
4873155 2318555 2318555 defendant Hogges Walter husbandman 591037 591037 Hogges, Walter, of Westham, husbandman 0
4916253 2331588 2331588 defendant Wright Richard   591037 591037 Wright, Richard, of Westham, vicar 0
4968940 2347674 2347674 defendant Colyer Richard husbandman 591037 591037 Colyer, Richard, of Westham, husbandman 1
5008010 2359233 2359233 defendant Burton John shoemaker 591037 591037 Burton, John, of Westham, shoemaker 0
5039259 2368383 2368383 defendant Cokman Simon husbandman 591037 591037 Cokman, Simon, of Westham, husbandman 0
5047975 2371014 2371014 defendant Morley John gent 591037 591037 Morley, John, of Westham, gent 2
5083540 2381578 2381578 defendant Alard William husbandman 591037 591037 Alard, William, of Westham, husbandman 0
5113207 2390258 2390258 defendant Hendyman William tailor 591037 591037 Hendyman, William, of Westham, tailor 6
5230000 2424388 2424388 defendant Payn John brewer 591037 591037 Payn, John, of Westham, brewer 0
5230002 2424388 2424388 defendant Holme John butcher 591037 591037 Holme, John, of Westham, butcher 2
5230003 2424388 2424388 defendant Baldok Nicholas husbandman 591037 591037 Baldok, Nicholas, of Westham, husbandman 3
5239323 2427088 2427088 defendant Baldewyn Richard husbandman 591037 591037 Baldewyn, Richard, of Westham, husbandman 2
5239327 2427089 2427089 defendant Baldewyn Richard husbandman 591037 591037 Baldewyn, Richard, of Westham, husbandman 2
5239333 2427090 2427090 defendant Baldes Richard husbandman 591037 591037 Baldes, Richard, of Westham, husbandman 4
5244944 2428695 2428695 defendant Mower William laborer 591037 591037 Mower, William, of Westham, laborer 0
5257217 2432385 2432385 defendant Foode William yeoman 591037 591037 Foode, William, of Westham, yeoman 1
5276434 2438178 2438178 defendant Whitehed William yeoman 591037 591037 Whitehed, William, of Westham, yeoman 0
5277661 2438549 2438549 defendant Kay Thomas clerk 591037 591037 Kay, Thomas, of Westham, clerk 0
5338892 2456740 2456740 defendant Bradbrige John yeoman 591037 591037 Bradbrige, John, of Westham, yeoman 0
5340545 2457239 2457239 defendant Hyppys Clement yeoman 591037 591037 Hyppys, Clement, of Westham, yeoman 4
5372604 2467032 2467032 defendant Holte Richard chaplain 591037 591037 Holte, Richard, of Westham, chaplain 0
5379186 2469086 2469086 defendant Nut William miller 591037 591037 Nut, William, of Westham, miller 0
5398540 2474643 2474643 defendant Alman John gent 591037 591037 Alman, John, of Westham, gent 1
5423609 2482026 2482026 plaintiff Bradbrygee John (legal representative) 591037 591037 Bradbrygee, John, of Westham, administrator of 0
5423612 2482027 2482027 plaintiff Bradbrygge John (legal representative) 591037 591037 Bradbrygge, John, of Westham, administrator of 0
5423615 2482028 2482028 plaintiff Bradbrygge John (legal representative) 591037 591037 Bradbrygge, John, of Westham, administrator of 0
5433203 2484896 2484896 defendant Hampton John yeoman 591037 591037 Hampton, John, of Westham, yeoman 0
5433204 2484896 2484896 defendant Almon John gent 591037 591037 Almon, John, of Westham, gent 1
5449110 2489629 2489629 defendant Hampton John yeoman 591037 591037 Hampton, John, of Westham, yeoman 0
5449111 2489629 2489629 defendant Alman John gent 591037 591037 Alman, John, of Westham, gent 1
5455614 2491585 2491585 plaintiff Bradbrygge John (legal representative) 591037 591037 Bradbrygge, John, of Westham, administrator of 0
5467379 2495188 2495188 plaintiff Bradbrigge John (legal representative) 591037 591037 Bradbrigge, John, of Westham, administrator of 0
5467382 2495189 2495189 plaintiff Bradbrygge John (legal representative) 591037 591037 Bradbrygge, John, of Westham, administrator of 0
5467385 2495190 2495190 plaintiff Bradbrygge John (legal representative) 591037 591037 Bradbrygge, John, of Westham, administrator of 0
5504590 2506356 2506356 plaintiff Badbrigge John (legal representative) 591037 591037 Badbrigge, John, of Westham, administrator of 0
5504596 2506358 2506358 plaintiff Badbrygge John (legal representative) 591037 591037 Badbrygge, John, of Westham, administrator of 0
5516910 2510114 2510114 defendant Thressher Richard laborer 591037 591037 Thressher, Richard, of Westham, laborer 0
5520331 2511177 2511177 defendant Danyell Nicholas brewer 591037 591037 Danyell, Nicholas, of Westham, brewer 0
5521695 2511601 2511601 defendant Tolton Thomas baker 591037 591037 Tolton, Thomas, of Westham, baker 1
5522265 2511781 2511781 defendant Henley Henry baker 591037 591037 Henley, Henry, of Westham, baker 1
5522266 2511781 2511781 defendant Noreys Robert laborer 591037 591037 Noreys, Robert, of Westham, laborer 2
5522267 2511781 2511781 defendant Iryse Robert weaver 591037 591037 Iryse, Robert, of Westham, weaver 3
5522268 2511781 2511781 defendant Chapman Nicholas fisher 591037 591037 Chapman, Nicholas, of Westham, fisher 4
5527053 2513030 2513030 defendant Fyssher Thomas yeoman 591037 591037 Fyssher, Thomas, of westham, yeoman 0
5534331 2515275 2515275 defendant Symmys John, senior husbandman 591037 591037 Symmys, John, senior, of Westham, husbandman 0
5541009 2517313 2517313 defendant Shipman John, junior husbandman 591037 591037 Shipman, John, junior, of Westham, husbandman 0
5541011 2517314 2517314 defendant Shypman John, junior husbandman 591037 591037 Shypman, John, junior, of Westham, husbandman 0
5541444 2517436 2517436 defendant Colyns William husbandman 591037 591037 Colyns, William, of Westham, husbandman 1
5547504 2519288 2519288 defendant Lenet or Levet William tanner 591037 591037 Lenet or Levet, William, of Westham, tanner 2
5550875 2520288 2520288 defendant Bawedewen William husbandman 591037 591037 Bawedewen, William, of Westham, husbandman 0
5550876 2520288 2520288 defendant Bawedewen Robert husbandman 591037 591037 Bawedewen, Robert, of Westham, husbandman 1
5550904 2520297 2520297 defendant Bawedewen William husbandman 591037 591037 Bawedewen, William, of Westham, husbandman 0
5550905 2520297 2520297 defendant Bawedewen Robert husbandman 591037 591037 Bawedewen, Robert, of Westham, husbandman 1
5583551 2529927 2529927 defendant Bunby John butcher 591037 591037 Bunby, John, of Westham, butcher 0
5587257 2531041 2531041 defendant Staunton John yeoman 591037 591037 Staunton, John, of Westham, yeoman 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);