names

508 rows where place_id = 586606

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589194 1864265 1864265 defendant Dychefeld John cordwainer 586606 586606 Dychefeld, John, of Chester, cordwainer 0
3589195 1864265 1864265 defendant Clerk John cordwainer 586606 586606 Clerk, John, of Chester, cordwainer 1
3589196 1864265 1864265 defendant Mossarop John cordwainer 586606 586606 Mossarop, John, of Chester, cordwainer 2
3589197 1864265 1864265 defendant Kele Thomas cordwainer 586606 586606 Kele, Thomas, of Chester, cordwainer 3
3589200 1864266 1864266 defendant Dychefeld John cordwainer 586606 586606 Dychefeld, John, of Chester, cordwainer 0
3589201 1864266 1864266 defendant Clerk John cordwainer 586606 586606 Clerk, John, of Chester, cordwainer 1
3589202 1864266 1864266 defendant Mossecrope John cordwainer 586606 586606 Mossecrope, John, of Chester, cordwainer 2
3589203 1864266 1864266 defendant Kele Thomas cordwainer 586606 586606 Kele, Thomas, of Chester, cordwainer 3
3640260 1907388 1907388 defendant A Barowe Robert chapman 586606 586606 A Barowe, Robert, of Chester, chapman 2
3656027 1912139 1912139 defendant a Barton Thomas chapman 586606 586606 a Barton, Thomas, of Chester, chapman 0
3656029 1912139 1912139 defendant Borowe Robert chapman 586606 586606 Borowe, Robert, of Chester, chapman 2
3656030 1912139 1912139 defendant Harper John chapman 586606 586606 Harper, John, of Chester, chapman 3
3656228 1912197 1912197 defendant Barowe Robert mercer 586606 586606 Barowe, Robert, of Chester, mercer 0
3656233 1912198 1912198 defendant Barrowe Robert mercer 586606 586606 Barrowe, Robert, of Chester, mercer 0
3656238 1912199 1912199 defendant Barrowe Robert mercer 586606 586606 Barrowe, Robert, of Chester, mercer 0
3666043 1915318 1915318 defendant Hol-ora George   586606 586606 Hol-ora, George, of Chester, knight 1
3675388 1918340 1918340 defendant Bradburn Roland gent 586606 586606 (Bradburn, Roland, of Chester, gent 1
3676114 1918569 1918569 defendant Barton Thomas mercer 586606 586606 Barton, Thomas, of Chester, mercer 1
3676115 1918569 1918569 defendant Gaton Charles ironmonger 586606 586606 Gaton, Charles, of Chester, ironmonger 2
3676116 1918569 1918569 defendant Grymesdych Richard merchant 586606 586606 Grymesdych, Richard, of Chester, merchant 3
3700094 1926261 1926261 defendant Werall Thomas merchant 586606 586606 Werall, Thomas, of Chester, merchant 1
3710421 1929578 1929578 defendant Bruyn Robert (legal representative) 586606 586606 Bruyn, Robert, of Chester, executor of 0
3710422 1929578 1929578 defendant Bruyn Robert yeoman 586606 586606 Bruyn, Robert, of Chester, yeoman 1
3711273 1929829 1929829 defendant Goodman William merchant 586606 586606 Goodman, William, of Chester, merchant 0
3712640 1930269 1930269 defendant Brereton William   586606 586606 Brereton, William, of Chester, knight 2
3727651 1934923 1934923 defendant Breerton Ralph gent 586606 586606 Breerton, Ralph, of Chester, gent 1
3728204 1935083 1935083 defendant Brekenhede Ralph gent 586606 586606 Brekenhede, Ralph, of Chester, gent 3
3728230 1935090 1935090 defendant Whytmore Richard gent 586606 586606 Whytmore, Richard, of Chester, gent 2
3742474 1939517 1939517 defendant Hurlston Margery widow 586606 586606 Hurlston, Margery, of Chester, widow 0
3748334 1941410 1941410 plaintiff Goodman Richard merchant 586606 586606 Goodman, Richard, of Chester, merchant 0
3749549 1941772 1941772 defendant Hurleton Margaret widow 586606 586606 Hurleton, Margaret, of Chester, widow 1
3764581 1946578 1946578 defendant Hurleton Margery widow 586606 586606 Hurleton, Margery, of Chester, widow 1
3767174 1947378 1947378 defendant (not given) Hugh rector of Aphol 586606 586606 Aphol, Hugh, of Chester, rector of Eccleston 2
3767175 1947378 1947378 defendant Dymmok Uriam gent 586606 586606 Dymmok, Uriam, of Chester, gent 3
3769751 1948193 1948193 defendant Bostoke Ralph draper 586606 586606 Bostoke, Ralph, of Chester, draper 0
3789040 1954384 1954384 defendant Snede William draper 586606 586606 Snede, William, of Chester, draper 0
3791291 1955109 1955109 defendant Loker John ironmonger 586606 586606 Loker, John, of Chester, ironmonger 0
3795594 1956507 1956507 defendant Fraunces Henry merchant 586606 586606 Fraunces, Henry, of Chester, merchant 0
3822219 1964853 1964853 defendant Kyrkes John mercer 586606 586606 Kyrkes, John, of Chester, mercer 0
3840327 1970542 1970542 defendant Kyrkys John chapman 586606 586606 Kyrkys, John, of Chester, chapman 3
3843873 1971624 1971624 defendant Chamberlayn Richard (legal representative) 586606 586606 Chamberlayn, Richard, of Chester, administrator of 0
3843876 1971625 1971625 defendant Chamberlayne Richard (legal representative) 586606 586606 Chamberlayne, Richard, of Chester, administrator of 0
3849213 1973349 1973349 defendant Dutton Lawrence mercer 586606 586606 Dutton, Lawrence, of Chester, mercer 0
3857105 1975853 1975853 defendant Crosse Robert glover 586606 586606 Crosse, Robert, of Chester, glover 3
3866553 1979042 1979042 defendant Smyth Thomas alderman 586606 586606 Smyth, Thomas, of Chester, chapman, son of Smyth, Thomas, of Westchester, alderman 0
3866559 1979043 1979043 defendant Smyth Thomas alderman 586606 586606 Smyth, Thomas, of Chester, chapman, son of Smyth, Thomas, of Westchester, alderman 0
3869109 1979915 1979915 defendant Dymmoke Edmund merchant 586606 586606 Dymmoke, Edmund, of Chester, merchant 0
3871946 1980850 1980850 defendant Wryght Robert draper 586606 586606 Wryght, Robert, of Chester, draper 0
3872920 1981160 1981160 defendant Smyth John clothier 586606 586606 Smyth, John, of Chester, clothier 1
3874928 1981839 1981839 defendant Cru Roland chapman 586606 586606 Cru, Roland, of Chester, chapman 0
3878591 1983088 1983088 defendant Smyth Thomas mercer 586606 586606 Smyth, Thomas, of Chester, mercer 0
3878592 1983088 1983088 defendant Newhall William mercer 586606 586606 Newhall, William, of Chester, mercer 1
3878790 1983155 1983155 defendant Newhall William mercer 586606 586606 Newhall, William, of Chester, mercer 1
3887362 1986037 1986037 defendant Conwey Peter goldsmith 586606 586606 Conwey, Peter, of Chester, goldsmith 0
3890668 1987144 1987144 defendant Bavante alias Roper Thomas ironmonger 586606 586606 Bavante alias Roper, Thomas, of Chester, ironmonger 0
3890669 1987144 1987144 defendant Frances John butcher 586606 586606 Frances, John, of Chester, butcher 1
3890671 1987145 1987145 defendant Davante alias Roper Thomas butcher or ironmonger 586606 586606 Davante alias Roper, Thomas, of Chester, butcher or ironmonger 0
3890672 1987145 1987145 defendant Frances John butcher 586606 586606 Frances, John, of Chester, butcher 1
3890777 1987182 1987182 defendant Constantyne Philip merchant 586606 586606 Constantyne, Philip, of Chester, merchant 0
3896280 1988966 1988966 defendant Wryne alias Waryne Ralph gent 586606 586606 Wryne alias Waryne, Ralph, of Chester, gent 0
3897708 1989442 1989442 plaintiff Wryght Richard (legal representative) 586606 586606 Wryght, Richard, of Chester, alderman, executrix of 0
3898795 1989799 1989799 defendant Aldrese William merchant 586606 586606 Aldrese, William, of Chester, merchant 0
3901662 1990784 1990784 defendant Marser William chapman 586606 586606 Marser, William, of Chester, chapman 2
3901670 1990786 1990786 defendant Masse Thomas chapman 586606 586606 Masse, Thomas, of Chester, chapman 2
3901683 1990788 1990788 defendant Dutton Lawrence chapman 586606 586606 Dutton, Lawrence, of Chester, chapman 3
3901684 1990788 1990788 defendant Lowe Richard chapman 586606 586606 Lowe, Richard, of Chester, chapman 4
3901686 1990789 1990789 defendant Smyth Peter chapman 586606 586606 Smyth, Peter, of Chester, chapman 0
3902441 1991049 1991049 defendant Jones Robert merchant 586606 586606 Jones, Robert, of Chester, merchant 0
3906302 1992395 1992395 defendant Smyth John draper 586606 586606 Smyth, John, of Chester, draper 0
3906303 1992395 1992395 defendant Longley Thomas merchantman 586606 586606 Longley, Thomas, of Chester, merchantman 1
3908409 1993108 1993108 defendant Mayer John clerk 586606 586606 Mayer, John, of Chester, clerk 0
3911942 1994318 1994318 defendant Radforde Richard merchant 586606 586606 Radforde, Richard, of Chester, merchant 2
3913220 1994753 1994753 plaintiff Barton Robert, senior (legal representative) 586606 586606 Barton, Robert, senior, of Chester, alderman, executors of 0
3913824 1994970 1994970 defendant Offeley John merchant 586606 586606 Offeley, John, of Chester, merchant 0
3916031 1995749 1995749 defendant Jones Robert mercer 586606 586606 Jones, Robert, of Chester, mercer 0
3916607 1995930 1995930 defendant Langley Thomas draper 586606 586606 Langley, Thomas, of Chester, draper 0
3916612 1995931 1995931 defendant Langley Thomas draper 586606 586606 Langley, Thomas, of Chester, draper 0
3920167 1997082 1997082 defendant Martyn Thomas merchant 586606 586606 Martyn, Thomas, of Chester, merchant 0
3920169 1997083 1997083 defendant Wayley John ironmonger 586606 586606 Wayley, John, of Chester, ironmonger 0
3920171 1997084 1997084 defendant Weyley John ironmonger 586606 586606 Weyley, John, of Chester, ironmonger 0
3920178 1997087 1997087 defendant Marten Thomas merchant 586606 586606 Marten, Thomas, of Chester, merchant 0
3923336 1998113 1998113 plaintiff Smyth John baker 586606 586606 Smyth, John, of Chester, baker 0
3926117 1999055 1999055 defendant Streyt Peter butcher 586606 586606 Streyt, Peter, of Chester, butcher 1
3926307 1999121 1999121 defendant Irenshawe Robert mercer 586606 586606 Irenshawe, Robert, of Chester, mercer 0
3926628 1999239 1999239 plaintiff Aldersey Hugh Alderman 586606 586606 Aldersey, Hugh, of Chester, Alderman 1
3927153 1999416 1999416 defendant Dutton Richard draper 586606 586606 Dutton, Richard, of Chester, draper 1
3927456 1999528 1999528 defendant Vawdry Robert gent 586606 586606 (Vawdry, Robert, of Chester, gent 3
3927462 1999529 1999529 defendant Vewdry Robert gent 586606 586606 (Vewdry, Robert, of Chester, gent 3
3928659 1999924 1999924 defendant Longley Thomas merchant 586606 586606 Longley, Thomas, of Chester, merchant 0
3928758 1999956 1999956 defendant Gorstelowe Thomas merchant 586606 586606 Gorstelowe, Thomas, of Chester, merchant 0
3928759 1999956 1999956 defendant Rogers Ralph merchant 586606 586606 Rogers, Ralph, of Chester, merchant 1
3928760 1999956 1999956 defendant Stewarde Thomas merchant 586606 586606 Stewarde, Thomas, of Chester, merchant 2
3928761 1999956 1999956 defendant Tomson Edward merchant 586606 586606 Tomson, Edward, of Chester, merchant 3
3928770 1999958 1999958 defendant Coystelowe Thomas merchant 586606 586606 Coystelowe, Thomas, of Chester, merchant 0
3928771 1999958 1999958 defendant Rogers Ralph merchant 586606 586606 Rogers, Ralph, of Chester, merchant 1
3928772 1999958 1999958 defendant Stewarde Thomas merchant 586606 586606 Stewarde, Thomas, of Chester, merchant 2
3928775 1999959 1999959 defendant Gorstelowe Thomas merchant 586606 586606 Gorstelowe, Thomas, of Chester, merchant 0
3928776 1999959 1999959 defendant Rogers Ralph merchant 586606 586606 Rogers, Ralph, of Chester, merchant 1
3928777 1999959 1999959 defendant Stewarde Thomas merchant 586606 586606 Stewarde, Thomas, of Chester, merchant 2
3931259 2000746 2000746 defendant Delithey John draper 586606 586606 Delithey, John, of Chester, draper 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);