names

222 rows where place_id = 587396

✎ 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
3591293 1864903 1864903 defendant Englyssh Anthony clerk 587396 587396 Englyssh, Anthony, of Halsted, clerk 0
3596008 1866380 1866380 defendant Ryse Ralph yeoman 587396 587396 Ryse, Ralph, of Halsted, yeoman 0
3604435 1869055 1869055 defendant Felton Lewis yeoman 587396 587396 Felton, Lewis, of Halsted, yeoman 0
3604928 1869205 1869205 defendant Hayward William husbandman 587396 587396 Hayward, William, of Halsted, husbandman 7
3619491 1873660 1873660 defendant Petyte John husbandman 587396 587396 Petyte, John, of Halsted, husbandman 0
3620894 1874098 1874098 defendant Harpon William shoemaker 587396 587396 Harpon, William, of Halsted, shoemaker 0
3633608 1905322 1905322 defendant Turnour Robert butcher 587396 587396 Turnour, Robert, of Halsted, butcher 0
3644932 1908824 1908824 defendant Bayly Richard butcher 587396 587396 Bayly, Richard, of of Halsted, butcher 1
3654335 1911616 1911616 defendant Rote John husbandman 587396 587396 Rote, John, of Halsted, husbandman 0
3656414 1912251 1912251 defendant Salle William yeoman 587396 587396 Salle, William, of Halsted, yeoman 0
3661435 1913848 1913848 defendant Lynde Edmund yeoman 587396 587396 Lynde, Edmund, of Halsted, yeoman 0
3675593 1918402 1918402 defendant Priour Roger husbandman 587396 587396 Priour, Roger, of Halsted, husbandman 0
3675594 1918402 1918402 defendant Clerk Edmund husbandman 587396 587396 Clerk, Edmund, of Halsted, husbandman 1
3682547 1920646 1920646 defendant Tanner Richard laborer 587396 587396 Tanner, Richard, of Halsted, laborer 0
3690851 1923302 1923302 defendant Cowley John yeoman 587396 587396 Cowley, John, of Halsted, yeoman 2
3698128 1925640 1925640 defendant Broun John courser 587396 587396 Broun, John, of Halsted, courser 2
3729192 1935379 1935379 defendant Turnour Robert, junior courser 587396 587396 Turnour, Robert, junior, of Halsted, courser 1
3729193 1935379 1935379 defendant Bayly alias Boucher Richard butcher 587396 587396 Bayly alias Boucher, Richard, of Halsted, butcher 2
3729196 1935380 1935380 defendant Turnour Robert, junior courser 587396 587396 Turnour, Robert, junior, of Halsted, courser 1
3729197 1935380 1935380 defendant Bayly alias Boucher Richard butcher 587396 587396 Bayly alias Boucher, Richard, of Halsted, butcher 2
3735740 1937416 1937416 defendant Robard John husbandman 587396 587396 Robard, John, of Halsted, husbandman 1
3736369 1937617 1937617 defendant Pudney John husbandman 587396 587396 Pudney, John, of Halsted, husbandman 1
3740849 1938996 1938996 defendant Norman Robert carpenter 587396 587396 Norman, Robert, of Halsted, carpenter 0
3743718 1939917 1939917 defendant Cooke Thomas husbandman 587396 587396 Cooke, Thomas, of Halsted, husbandman 1
3744264 1940103 1940103 defendant Tothe John laborer 587396 587396 Tothe, John, of Halsted, laborer 2
3746839 1940932 1940932 defendant Petley William yeoman 587396 587396 Petley, William, of Halsted, yeoman 0
3752028 1942556 1942556 defendant Angore Richard yeoman 587396 587396 Angore, Richard, of Halsted, yeoman 2
3752029 1942556 1942556 defendant Angore Thomas yeoman 587396 587396 Angore, Thomas, of Halsted, yeoman 3
3762341 1945864 1945864 defendant Whyte Henry butcher 587396 587396 Whyte, Henry, of Halsted, butcher 2
3782537 1952281 1952281 defendant Whyte Henry butcher 587396 587396 Whyte, Henry, of Halsted, butcher 1
3786763 1953656 1953656 defendant Decamaiore Matthew clothmaker 587396 587396 Decamaiore, Matthew, of Halsted, clothmaker 0
3786764 1953656 1953656 defendant Decamaiore Lawrence clothmaker 587396 587396 Decamaiore, Lawrence, of Halsted, clothmaker 1
3786765 1953656 1953656 defendant Carte John smith 587396 587396 Carte, John, of Halsted, smith 2
3789831 1954648 1954648 defendant Harlewyn Thomas clerk 587396 587396 Harlewyn, Thomas, of Halsted, clerk 1
3796535 1956789 1956789 defendant Clerke Thomas yeoman 587396 587396 Clerke, Thomas, of Halsted, yeoman 2
3806372 1959904 1959904 defendant Pudney John husbandman 587396 587396 Pudney, John, of Halsted, husbandman 2
3824112 1965413 1965413 defendant Petley Thomas yeoman 587396 587396 Petley, Thomas, of Halsted, yeoman 0
3824451 1965518 1965518 plaintiff Welby Thomas (legal representative) 587396 587396 Welby, Thomas, of Halsted, executors of 0
3824452 1965518 1965518 plaintiff Hall John gent 587396 587396 (Hall, John, of Halsted, gent 1
3831392 1967708 1967708 defendant Turnour John butcher 587396 587396 Turnour, John, of Halsted, butcher 0
3831631 1967789 1967789 plaintiff Hall John esq 587396 587396 Hall, John, of Halsted, esq 0
3840258 1970522 1970522 defendant Pudney John husbandman 587396 587396 Pudney, John, of Halsted, husbandman 0
3851005 1973905 1973905 defendant Rydysdale alias Loker Thomas husbandman 587396 587396 Rydysdale alias Loker, Thomas, of Halsted, husbandman 0
3858022 1976157 1976157 defendant Pudney John husbandman 587396 587396 Pudney, John, of Halsted, husbandman 1
3869520 1980048 1980048 defendant Pudney John husbandman 587396 587396 Pudney, John, of Halsted, husbandman 0
3870846 1980500 1980500 defendant Pudney John husbandman 587396 587396 Pudney, John, of Halsted, husbandman 0
3894899 1988502 1988502 plaintiff Sewhall William husbandman 587396 587396 Sewhall, William, of Halsted, husbandman 0
3896615 1989077 1989077 plaintiff Veynor Robert clothmaker 587396 587396 Veynor, Robert, of Halsted, clothmaker 0
3899034 1989882 1989882 defendant Cutler alias Lestur John clothmaker 587396 587396 Cutler alias Lestur, John, of Halsted, clothmaker 2
3899880 1990173 1990173 plaintiff Bragge Henry husbandman 587396 587396 Bragge, Henry, of Halsted, husbandman 0
3901764 1990813 1990813 plaintiff Cutler John clothier 587396 587396 Cutler, John, of Halsted, clothier 0
3921542 1997543 1997543 defendant Polley Richard husbandman 587396 587396 Polley, Richard, of Halsted, husbandman 1
3922404 1997810 1997810 defendant Mannyng John husbandman 587396 587396 Mannyng, John, of Halsted, husbandman 4
3924014 1998341 1998341 defendant Lunt John clothier 587396 587396 Lunt, John, of Halsted, clothier 1
3924747 1998594 1998594 plaintiff Veynour Robert clothmaker 587396 587396 Veynour, Robert, of Halsted, clothmaker 0
3936516 2002538 2002538 defendant Osborne Richard fuller 587396 587396 Osborne, Richard, of Halsted, fuller 0
3936517 2002538 2002538 defendant Clenche Robert   587396 587396 Clenche, Robert, of Halsted 1
3984437 2019190 2019190 defendant Welby Richard esq 587396 587396 (Welby, Richard, of Halsted, esq 1
3985746 2019664 2019664 plaintiff Walter Nicholas yeoman 587396 587396 Walter, Nicholas, of Halsted, yeoman 0
3985749 2019664 2019664 defendant Hunwicke Alan yeoman 587396 587396 Hunwicke, Alan, of Halsted, yeoman 2
3985750 2019664 2019664 defendant Grey Thomas   587396 587396 Grey, Thomas, of Halsted, linen mercer 3
4016551 2030625 2030625 defendant Melsham Robert yeoman 587396 587396 Melsham, Robert, of Halsted, yeoman 0
4028264 2034760 2034760 defendant Pylgrym Lawrence husbandman 587396 587396 Pylgrym, Lawrence, of Halsted, or of Castle Hethingham, Essex, husbandman 0
4087180 2055705 2055705 defendant Graye Thomas   587396 587396 Graye, Thomas, of Halsted, linen draper 0
4087182 2055705 2055705 defendant Wynde George shoemaker 587396 587396 Wynde, George, of Halsted, shoemaker 2
4087183 2055705 2055705 defendant Medcalf John alias Isaac glover 587396 587396 Medcalf, John alias Isaac, of Halsted, glover 3
4106868 2062750 2062750 defendant Smyth John weaver 587396 587396 Smyth, John, of Halsted, weaver 0
4124345 2069000 2069000 defendant Welby Vincent gent 587396 587396 Welby, Vincent, of Halsted, gent 0
4134242 2072571 2072571 defendant Boyes Robert butcher 587396 587396 Boyes, Robert, of Halsted, butcher 0
4134244 2072572 2072572 defendant Boyes Robert butcher 587396 587396 Boyes, Robert, of Halsted, butcher 0
4154936 2079823 2079823 defendant Lansdall Peter weaver 587396 587396 Lansdall, Peter, of Halsted, weaver 0
4158082 2080894 2080894 defendant Pyerson John clothier 587396 587396 Pyerson, John, of Halsted, clothier 0
4191899 2092727 2092727 defendant Colman Anthony gent 587396 587396 Colman, Anthony, of Halsted, gent 1
4222470 2103351 2103351 defendant Kynge William yeoman 587396 587396 Kynge, William, of Halsted, yeoman 1
4239641 2109494 2109494 defendant Crismas John yeoman 587396 587396 Crismas, John, of Halsted, yeoman 0
4239643 2109495 2109495 defendant Kinge William husbandman 587396 587396 Kinge, William, of Halsted, husbandman 0
4276025 2121561 2121561 defendant Medcalfe Isaac glover 587396 587396 Medcalfe, Isaac, of Halsted, glover 0
4281098 2123289 2123289 defendant Byrde Thomas husbandman 587396 587396 Byrde, Thomas, of Halsted, husbandman 0
4282990 2123953 2123953 defendant Cristmas John innholder 587396 587396 Cristmas, John, of Halsted, innholder 1
4284980 2124677 2124677 defendant Burton Edward yeoman 587396 587396 Burton, Edward, of Halsted, yeoman 0
4313073 2134692 2134692 defendant Stockdall Stephen (legal representative) 587396 587396 Stockdall, Stephen, of Halsted, chapman, executrix of 0
4339286 2143506 2143506 defendant Boyes William butcher 587396 587396 Boyes, William, of Halsted, butcher 0
4341679 2144369 2144369 defendant Denny Edward chapman 587396 587396 Denny, Edward, of Halsted, chapman 1
4341680 2144369 2144369 defendant Foster Thomas chapman 587396 587396 Foster, Thomas, of Halsted, chapman 2
4359957 2150726 2150726 defendant Boyes William butcher 587396 587396 Boyes, William, of Halsted, butcher 0
4359958 2150726 2150726 defendant Hunwick John yeoman 587396 587396 Hunwick, John, of Halsted, yeoman 1
4359959 2150726 2150726 defendant Medcalf Isaac glover 587396 587396 Medcalf, Isaac, of Halsted, glover 2
4359960 2150726 2150726 defendant Wangford John, senior husbandman 587396 587396 Wangford, John, senior, of Halsted, husbandman 3
4361763 2151366 2151366 defendant Hunwick John yeoman 587396 587396 Hunwick, John, of Halsted, yeoman 0
4361765 2151367 2151367 defendant Smith Robert (legal representative) 587396 587396 Smith, Robert, of Halsted, clothier, executors of 0
4361766 2151367 2151367 defendant Bland Anthony yeoman 587396 587396 (Bland, Anthony, of Halsted, yeoman 1
4361767 2151367 2151367 defendant Hunwick John yeoman 587396 587396 Hunwick, John, of Halsted, yeoman 2
4367249 2153344 2153344 defendant Fynche John husbandman 587396 587396 Fynche, John, of Halsted, husbandman 1
4410249 2168027 2168027 defendant Smyth Robert, senior fuller 587396 587396 Smyth, Robert, senior, of Halsted, fuller 0
4410250 2168027 2168027 defendant Smyth Robert, junior yeoman 587396 587396 Smyth, Robert, junior, of Halsted, yeoman 1
4410251 2168027 2168027 defendant Smyth Ambrose   587396 587396 Smyth, Ambrose, of Halsted, yeoman, son of Robert senior 2
4490610 2197758 2197758 defendant Baker Richard   587396 587396 Baker, Richard, of Halsted 2
4506788 2202594 2202594 defendant Warde John, senior   587396 587396 Warde, John, senior, of Halsted 5
4507171 2202710 2202710 defendant Dyere John   587396 587396 Dyere, John, of Halsted 0
4508446 2203123 2203123 defendant Fullere Robert clerk 587396 587396 Fullere, Robert, of Halsted, clerk 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);