names

161 rows where place_id = 592242

✎ 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
3607066 1869874 1869874 defendant Ely William husbandman 592242 592242 Ely, William, of Morley, husbandman 2
3631137 1904560 1904560 defendant Drurey Robert gent 592242 592242 Drurey, Robert, of Morley, gent 0
3631138 1904560 1904560 defendant Bassam John husbandman 592242 592242 Bassam, John, of Morley, husbandman 1
3637939 1906684 1906684 plaintiff Stevynson William   592242 592242 Stevynson, William, of Morley 0
3637940 1906684 1906684 defendant Mannyng William husbandman 592242 592242 Mannyng, William, of Morley, husbandman 0
3639857 1907279 1907279 defendant Fuller Robert husbandman 592242 592242 Fuller, Robert, of Morley, husbandman 0
3644608 1908724 1908724 defendant Fuller Robert yeoman 592242 592242 Fuller, Robert, of Morley, yeoman 2
3644611 1908725 1908725 defendant Fuller Robert yeoman 592242 592242 Fuller, Robert, of Morley, yeoman 1
3667333 1915720 1915720 defendant Wandelesse Richard yeoman 592242 592242 Wandelesse, Richard, of Morley, yeoman 1
3667334 1915720 1915720 defendant Morley Richard gent 592242 592242 Morley, Richard, of Morley, gent 2
3668452 1916084 1916084 defendant Pyke Thomas husbandman 592242 592242 Pyke, Thomas, of Morley, husbandman 2
3673596 1917770 1917770 defendant Fuller Robert yeoman 592242 592242 Fuller, Robert, of Morley, yeoman 4
3712724 1930295 1930295 defendant Elys Richard sherman 592242 592242 Elys, Richard, of Morley, sherman 2
3714586 1930859 1930859 defendant Dudman William husbamdman 592242 592242 Dudman, William, of Morley, husbamdman 1
3714587 1930859 1930859 defendant Ellys Robert husbamdman 592242 592242 Ellys, Robert, of Morley, husbamdman 2
3714588 1930859 1930859 defendant Gretehede Robert chapman 592242 592242 Gretehede, Robert, of Morley, chapman 3
3724700 1934010 1934010 defendant Souche William, senior esq 592242 592242 Souche, William, senior, of Morley, esq 0
3732372 1936362 1936362 defendant Mownton William laborer 592242 592242 Mownton, William, of Morley, laborer 1
3745613 1940533 1940533 defendant Sebarn Margaret widow 592242 592242 Sebarn, Margaret, of Morley, widow 4
3758160 1944539 1944539 defendant Pycher Lawrence husbandman 592242 592242 Pycher, Lawrence, of Morley, husbandman 1
3769210 1948022 1948022 defendant Dammott William husbandman 592242 592242 Dammott, William, of Morley, husbandman 0
3769211 1948022 1948022 defendant Wryght Thomas husbandman 592242 592242 Wryght, Thomas, of Morley, husbandman 1
3783979 1952771 1952771 plaintiff Lovell Alice (legal representative) 592242 592242 Lovell, Alice, of Morley, executor of 0
3793966 1955983 1955983 defendant Ellys Robert husbandman 592242 592242 Ellys, Robert, of Morley, husbandman 4
3793967 1955983 1955983 defendant Ellys Thomas laborer 592242 592242 Ellys, Thomas, of Morley, laborer 5
3793968 1955983 1955983 defendant Otes Lawrence laborer 592242 592242 Otes, Lawrence, of Morley, laborer 6
3793969 1955983 1955983 defendant Scott Robert husbandman 592242 592242 Scott, Robert, of Morley, husbandman 7
3793970 1955983 1955983 defendant Barker John husbandman 592242 592242 Barker, John, of Morley, husbandman 8
3793971 1955983 1955983 defendant Fosserd Henry laborer 592242 592242 Fosserd, Henry, of Morley, laborer 9
3793972 1955983 1955983 defendant Crowder William husbandman 592242 592242 Crowder, William, of Morley, husbandman 10
3793973 1955983 1955983 defendant Bentley John husbandman 592242 592242 Bentley, John, of Morley, husbandman 11
3793974 1955983 1955983 defendant Clerkson William husbandman 592242 592242 Clerkson, William, of Morley, husbandman 12
3793975 1955983 1955983 defendant Burnell William, senior husbandman 592242 592242 Burnell, William, senior, of Morley, husbandman 13
3794792 1956245 1956245 defendant Grethed Robert woolman 592242 592242 Grethed, Robert, of Morley, woolman 0
3794793 1956245 1956245 defendant Scott Robert clothier 592242 592242 Scott, Robert, of Morley, clothier 1
3794794 1956245 1956245 defendant Harde Thomas clothman 592242 592242 Harde, Thomas, of Morley, clothman 2
3794795 1956245 1956245 defendant Ellys Robert clothman 592242 592242 Ellys, Robert, of Morley, clothman 3
3794796 1956245 1956245 defendant Dudman William husbandman 592242 592242 Dudman, William, of Morley, husbandman 4
3795662 1956522 1956522 defendant Elles Robert husbandman 592242 592242 Elles, Robert, of Morley, husbandman 0
3795663 1956522 1956522 defendant Ells Thomas laborer 592242 592242 Ells, Thomas, of Morley, laborer 1
3795664 1956522 1956522 defendant Berker John husbandman 592242 592242 Berker, John, of Morley, husbandman 2
3795665 1956522 1956522 defendant Crowder William sherman 592242 592242 Crowder, William, of Morley, sherman 3
3795666 1956522 1956522 defendant Otes Lawrence tailor 592242 592242 Otes, Lawrence, of Morley, tailor 4
3795667 1956522 1956522 defendant Leversege William sherman 592242 592242 Leversege, William, of Morley, sherman 5
3795668 1956522 1956522 defendant Burnell William laborer 592242 592242 Burnell, William, of Morley, laborer 6
3795669 1956522 1956522 defendant Clerkson William laborer 592242 592242 Clerkson, William, of Morley, laborer 7
3799785 1957854 1957854 defendant Trewe Benedict husbandman 592242 592242 Trewe, Benedict, of Morley, husbandman 0
3802513 1958680 1958680 defendant Hamond Robert husbandman 592242 592242 Hamond, Robert, of Morley, husbandman 0
3802917 1958810 1958810 defendant Parker Henry   592242 592242 Parker, Henry, of Morley, knight 0
3835023 1968894 1968894 plaintiff Parker Henry   592242 592242 Parker, Henry, of Morley, knight 0
3841078 1970783 1970783 defendant Chere William husbandman 592242 592242 Chere, William, of Morley, husbandman 3
3841291 1970856 1970856 defendant Wryght Thomas husbandman 592242 592242 Wryght, Thomas, of Morley, husbandman 4
3897680 1989432 1989432 defendant Sabourne William husbandman 592242 592242 Sabourne, William, of Morley, husbandman 4
3901257 1990645 1990645 defendant Seberne William yoman 592242 592242 Seberne, William, of Morley, yoman 3
3911558 1994182 1994182 defendant Rogers Thomas clothier 592242 592242 Rogers, Thomas, of Morley, clothier 0
3911775 1994265 1994265 defendant Crensener John gent 592242 592242 Crensener, John, of Morley, gent 0
3911938 1994317 1994317 defendant Cressener John esq 592242 592242 Cressener, John, of Morley, esq 0
3916636 1995936 1995936 defendant Stanton George husbandman 592242 592242 Stanton, George, of Morley St Peter, husbandman 1
3925234 1998751 1998751 defendant Roger Thomas yeoman 592242 592242 Roger, Thomas, of Morley, yeoman 0
3959106 2010269 2010269 plaintiff Sedley Martin gent 592242 592242 Sedley, Martin, of Morley, gent 0
3969690 2014006 2014006 plaintiff Cowper William baker 592242 592242 Cowper, William, of Morley, baker 0
3969691 2014006 2014006 defendant Raynold William husbandman or ploughwright 592242 592242 Raynold, William, of Morley, husbandman or ploughwright 0
3969692 2014006 2014006 defendant Raynold Robert husbandman 592242 592242 Raynold, Robert, of Morley, husbandman 1
3998604 2024238 2024238 defendant Crane Adrian yeoman 592242 592242 Crane, Adrian, of Morley, yeoman 0
4041292 2039373 2039373 defendant Crane Adrian yeoman 592242 592242 Crane, Adrian, of Morley, yeoman 0
4045151 2040717 2040717 defendant Singleton Charles gent 592242 592242 Singleton, Charles, of Morley, gent 0
4045153 2040718 2040718 defendant Singleton Charles gent 592242 592242 Singleton, Charles, of Morley, gent 0
4045736 2040920 2040920 plaintiff Seborne James husbandman 592242 592242 Seborne, James, of Morley, husbandman 0
4055801 2044456 2044456 defendant Thompson John miller 592242 592242 Thompson, John, of Morley, miller 0
4055803 2044456 2044456 defendant Blisse Richard miller 592242 592242 Blisse, Richard, of Morley, miller 2
4059592 2045822 2045822 defendant Clarke Edward clerk 592242 592242 Clarke, Edward, of Morley, or of Gunston, Suff, clerk 0
4059601 2045824 2045824 defendant Raynold Richard husbandman 592242 592242 Raynold, Richard, of Morley, husbandman 3
4060535 2046169 2046169 defendant Foxe Thomas husbandman 592242 592242 Foxe, Thomas, of Morley, husbandman 0
4060537 2046169 2046169 defendant Gooche Anthony husbandman 592242 592242 Gooche, Anthony, of Morley, husbandman 2
4071885 2050245 2050245 defendant Holden Thomas gent 592242 592242 Holden, Thomas, of Morley, gent 0
4071886 2050245 2050245 defendant Pyckerynge James yeoman 592242 592242 Pyckerynge, James, of Morley, or of Harborowe, Leics, yeoman 1
4075621 2051585 2051585 plaintiff Sacheverell Henry esq 592242 592242 Sacheverell, Henry, of Morley, esq 0
4075924 2051693 2051693 plaintiff Seaborne James yeoman 592242 592242 Seaborne, James, of Morley, yeoman 0
4075926 2051693 2051693 defendant Cressye Richard thatcher or laborer 592242 592242 Cressye, Richard, of Morley, thatcher or laborer 1
4075929 2051694 2051694 plaintiff Seaborne James yeoman 592242 592242 Seaborne, James, of Morley, yeoman 0
4080478 2053330 2053330 defendant Hobert Owen gent or esq 592242 592242 Hobert, Owen, of Morley, gent or esq 0
4094951 2058523 2058523 defendant Thyrkettell Edmund yeoman 592242 592242 Thyrkettell, Edmund, of Morley, yeoman 2
4113215 2064994 2064994 defendant Brigges John yeoman 592242 592242 Brigges, John, of Morley, yeoman 3
4113222 2064995 2064995 defendant Bridges John yeoman 592242 592242 Bridges, John, of Morley, yeoman 3
4138726 2074217 2074217 defendant Jeffrey Thomas chapman 592242 592242 Jeffrey, Thomas, of Morley, chapman 3
4139085 2074346 2074346 defendant Mannyng William husbandman 592242 592242 Mannyng, William, of Morley, husbandman 0
4184371 2090034 2090034 defendant Davy Robert weaver 592242 592242 Davy, Robert, of Morley, weaver 0
4193698 2093363 2093363 defendant Kepas Edward husbandman 592242 592242 Kepas, Edward, of Morley, husbandman 3
4202206 2096315 2096315 defendant Dacye Thomas husbandman 592242 592242 Dacye, Thomas, of Morley, husbandman 1
4276247 2121634 2121634 defendant Killam Thomas blacksmith 592242 592242 Killam, Thomas, of Morley, blacksmith 2
4316952 2136046 2136046 defendant Doggett John husbandman 592242 592242 Doggett, John, of Morley, husbandman 0
4317859 2136358 2136358 defendant Hunter William yeoman 592242 592242 Hunter, William, of Morley, yeoman 1
4329396 2140142 2140142 defendant Kyllam Thomas smith 592242 592242 Kyllam, Thomas, of Morley, smith 1
4331971 2140988 2140988 defendant Lovell Edward yeoman 592242 592242 Lovell, Edward, of Morley, yeoman 0
4331974 2140989 2140989 defendant Lovell Edward yeoman 592242 592242 Lovell, Edward, of Morley, yeoman 0
4348911 2146882 2146882 defendant Castleton William clerk 592242 592242 Castleton, William, of Morley, clerk 0
4390235 2161356 2161356 defendant Barrett Peter   592242 592242 Barrett, Peter, of Morley, hat maker 1
4391417 2161746 2161746 defendant Rawlyn John tanner 592242 592242 Rawlyn, John, of Morley, tanner 1
4392391 2162081 2162081 defendant Addams Robert   592242 592242 Addams, Robert, of Morley, wheelwright 0
4393264 2162352 2162352 defendant Stevenson John, junior tailor 592242 592242 Stevenson, John, junior, of Morley, tailor 0

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