names

171 rows where place_id = 589315

✎ 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
3597207 1866750 1866750 defendant Horton Roger gent 589315 589315 Horton, Roger, of Catton, gent 0
3619504 1873666 1873666 defendant Wardell Thomas yeoman 589315 589315 Wardell, Thomas, of Catton, yeoman 0
3621520 1874273 1874273 defendant Perne Robert husbandman 589315 589315 Perne, Robert, of Catton, husbandman 0
3621522 1874274 1874274 defendant Thressher Reginald husbandman 589315 589315 Thressher, Reginald, of Catton, husbandman 0
3649131 1910115 1910115 defendant Horseley Thomas yeoman 589315 589315 Horseley, Thomas, of Catton, yeoman 0
3747402 1941102 1941102 defendant Horton Roger (legal representative) 589315 589315 Horton, Roger, of Catton, executor of 0
3747408 1941103 1941103 defendant Horton Roger (legal representative) 589315 589315 Horton, Roger, of Catton, executor of 0
3763632 1946265 1946265 defendant Hunter Robert yeoman 589315 589315 Hunter, Robert, of Catton, yeoman 0
3805153 1959554 1959554 defendant Fall Richard husbandman 589315 589315 Fall, Richard, of Catton, husbandman 0
3807180 1960142 1960142 plaintiff Whyte William   589315 589315 Whyte, William, of Catton, worsted weaver 0
3807182 1960142 1960142 defendant Goodwyn Henry smith 589315 589315 Goodwyn, Henry, of Catton, smith 1
3807183 1960142 1960142 defendant Davy Nicholas husbandman 589315 589315 Davy, Nicholas, of Catton, husbandman 2
3807184 1960142 1960142 defendant Ryches John husbandman 589315 589315 Ryches, John, of Catton, husbandman 3
3830643 1967468 1967468 defendant Watson William husbandman 589315 589315 Watson, William, of Catton, husbandman 0
3830644 1967468 1967468 defendant Layng William husbandman 589315 589315 Layng, William, of Catton, husbandman 1
3830646 1967469 1967469 plaintiff Franke Thomas clerk 589315 589315 Franke, Thomas, of Catton, clerk 0
3845197 1972060 1972060 defendant Merkaunt Robert husbandman 589315 589315 Merkaunt, Robert, of Catton, husbandman 1
3858534 1976334 1976334 defendant Sheparde John yeoman 589315 589315 Sheparde, John, of Catton, yeoman 0
3861059 1977181 1977181 defendant Markaunt Robert husbandman 589315 589315 Markaunt, Robert, of Catton, husbandman 3
3900035 1990232 1990232 plaintiff Bonde John   589315 589315 Bonde, John, of Catton 1
3916838 1995998 1995998 defendant Baker William tailor 589315 589315 Baker, William, of Catton, tailor 0
3916839 1995998 1995998 defendant Dyngle Lawrence husbandman 589315 589315 Dyngle, Lawrence, of Catton, husbandman 1
3932275 2001099 2001099 plaintiff Flowerdewe John (legal representative) 589315 589315 Flowerdewe, John, of Catton, yeoman, executor of 0
3941379 2004126 2004126 plaintiff Trye alias Tre Anne (legal representative) 589315 589315 Trye alias Tre, Anne, of Catton, widow, administrator of 0
3946325 2005789 2005789 plaintiff Butler John yeoman 589315 589315 Butler, John, of Catton, yeoman 0
3946329 2005790 2005790 plaintiff Butler John yeoman 589315 589315 Butler, John, of Catton, yeoman 0
3957822 2009797 2009797 plaintiff Pycto Alice widow 589315 589315 Pycto, Alice, of Catton, widow 1
3973259 2015221 2015221 defendant Spencer Thomas gent 589315 589315 Spencer, Thomas, of Catton, gent 4
4003445 2025996 2025996 plaintiff Horton Christopher gent 589315 589315 Horton, Christopher, of Catton, gent 1
4021046 2032251 2032251 plaintiff Wright John singleman 589315 589315 Wright, John, of Catton, singleman 0
4021050 2032252 2032252 plaintiff Wright John singleman 589315 589315 Wright, John, of Catton, singleman 0
4056458 2044694 2044694 plaintiff Braythwayt Tristram yeoman 589315 589315 Braythwayt, Tristram, of Catton, yeoman 0
4057528 2045070 2045070 defendant Candler Simon husbandman 589315 589315 Candler, Simon, of Catton, husbandman 0
4057530 2045071 2045071 defendant Clark Thomas husbandman 589315 589315 Clark, Thomas, of Catton, husbandman 0
4057532 2045072 2045072 defendant Clarke alias Webster Thomas husbandman 589315 589315 Clarke alias Webster, Thomas, of Catton, husbandman 0
4101937 2061006 2061006 defendant Butt Thomas husbandman 589315 589315 Butt, Thomas, of Catton, husbandman 1
4148214 2077508 2077508 defendant Joynt Richard husbandman 589315 589315 Joynt, Richard, of Catton, husbandman 2
4150126 2078181 2078181 defendant Chapman Richard yeoman 589315 589315 Chapman, Richard, of Catton, yeoman 0
4150337 2078249 2078249 defendant Butler John yeoman 589315 589315 Butler, John, of Catton, yeoman 1
4156725 2080430 2080430 defendant Candler Simon husbandman 589315 589315 Candler, Simon, of Catton, husbandman 1
4161374 2082058 2082058 defendant Chapman Richard gent 589315 589315 Chapman, Richard, of Catton, gent 0
4196598 2094357 2094357 defendant Wattes Peter husbandman 589315 589315 Wattes, Peter, of Catton, husbandman 1
4197114 2094544 2094544 defendant Barnes John carpenter 589315 589315 Barnes, John, of Catton, carpenter 0
4197115 2094544 2094544 defendant Wattes William husbandman 589315 589315 Wattes, William, of Catton, husbandman 1
4197116 2094544 2094544 defendant Edgor Alice widow 589315 589315 Edgor, Alice, of Catton, widow 2
4207958 2098343 2098343 defendant Buntynge Robert Norf, or of Norwich, yeoman 589315 589315 Buntynge Robert, of Catton, Norf, or of Norwich, yeoman 1
4214766 2100671 2100671 defendant Bootes Stephen husbandman 589315 589315 Bootes, Stephen, of Catton, or of Barton, husbandman 0
4221447 2102992 2102992 defendant Boot Stephen yeoman 589315 589315 Boot, Stephen, of Catton, yeoman 3
4223815 2103816 2103816 defendant Dayle William yeoman 589315 589315 Dayle, William, of Catton, yeoman 0
4247283 2112067 2112067 defendant Boot Stephen yeoman 589315 589315 Boot, Stephen, of Catton, yeoman 3
4251583 2113514 2113514 defendant Bootes Stephen yeoman 589315 589315 Bootes, Stephen, of Catton, or of Barton, yeoman 0
4251584 2113514 2113514 defendant Watt William husbandman 589315 589315 Watt, William, of Catton, husbandman 1
4251587 2113515 2113515 defendant Bootes Stephen yeoman 589315 589315 Bootes, Stephen, of Catton, yeoman 0
4258648 2115853 2115853 defendant Bootes Stephen yeoman 589315 589315 Bootes, Stephen, of Catton, yeoman 2
4275863 2121507 2121507 defendant Baile William yeoman 589315 589315 Baile, William, of Catton, yeoman 0
4275864 2121507 2121507 defendant Thompson William yeoman 589315 589315 Thompson, William, of Catton, yeoman 1
4275868 2121508 2121508 defendant Baill William yeoman 589315 589315 Baill, William, of Catton, yeoman 1
4275869 2121508 2121508 defendant Thompson William yeoman 589315 589315 Thompson, William, of Catton, yeoman 2
4275870 2121508 2121508 defendant Burnett Elizabeth widow 589315 589315 Burnett, Elizabeth, of Catton, widow 3
4281244 2123349 2123349 defendant Howling Thomas husbandman 589315 589315 Howling, Thomas, of Catton, husbandman 2
4289721 2126386 2126386 defendant Norforth John yeoman 589315 589315 Norforth, John, of Catton, yeoman 2
4315815 2135640 2135640 defendant Aston or Asshon Roger husbandman 589315 589315 Aston or Asshon, Roger, of Catton, husbandman 0
4315816 2135640 2135640 defendant Hacon John husbandman 589315 589315 Hacon, John, of Catton, husbandman 1
4319697 2137001 2137001 defendant Howlinges Thomas husbandman 589315 589315 Howlinges, Thomas, of Catton, husbandman 2
4328919 2139986 2139986 defendant Aston Roger husbandman 589315 589315 Aston, Roger, of Catton, husbandman 0
4328920 2139986 2139986 defendant Hacon John husbandman 589315 589315 Hacon, John, of Catton, husbandman 1
4332947 2141304 2141304 defendant Bootes Stephen yeoman 589315 589315 Bootes, Stephen, of Catton, yeoman 0
4350206 2147333 2147333 defendant Dowsynge alias Smyth Robert yeoman 589315 589315 Dowsynge alias Smyth, Robert, of Catton, yeoman 1
4406482 2166732 2166732 defendant Smyth Robert yeoman 589315 589315 Smyth, Robert, of Catton, yeoman 0
4409519 2167779 2167779 defendant Smythe Robert yeoman 589315 589315 Smythe, Robert, of Catton, yeoman 2
4410351 2168058 2168058 defendant Smythe Robert yeoman 589315 589315 Smythe, Robert, of Catton, yeoman 0
4410353 2168059 2168059 defendant Smythe Robert yeoman 589315 589315 Smythe, Robert, of Catton, yeoman 0
4439488 2181615 2181615 defendant Bakeron Ada   589315 589315 Bakeron, Ada, of Catton 1
4446425 2183798 2183798 defendant Modyman Robert   589315 589315 Modyman, Robert, of Catton 0
4459769 2188108 2188108 plaintiff Saper Robert   589315 589315 Saper, Robert, of Catton 0
4489590 2197462 2197462 defendant Modyman Robert   589315 589315 Modyman, Robert, of Catton 1
4489591 2197462 2197462 defendant Wedoweson John   589315 589315 Wedoweson, John, of Catton 2
4518176 2206057 2206057 defendant Hopkynson John   589315 589315 Hopkynson, John, of Catton 0
4518177 2206057 2206057 defendant Preest Henry   589315 589315 Preest, Henry, of Catton 1
4557962 2218422 2218422 defendant Nikson John   589315 589315 Nikson, John, of Catton 0
4564350 2220419 2220419 defendant Fenrother Adam   589315 589315 Fenrother, Adam, of Catton, parson 4
4564356 2220420 2220420 defendant Fenrother Adam   589315 589315 Fenrother, Adam, of Catton, parson 2
4568323 2221664 2221664 defendant Alkobarowe John chaplain 589315 589315 Alkobarowe, John, of Catton, chaplain 1
4568324 2221664 2221664 defendant Moll Edmund   589315 589315 Moll, Edmund, of Catton 2
4585083 2226756 2226756 defendant Ketyl John   589315 589315 Ketyl, John, of Catton 0
4591772 2228781 2228781 defendant Wryght Ralph   589315 589315 Wryght, Ralph, of Catton 0
4618604 2236827 2236827 defendant Byron Thomas   589315 589315 Byron, Thomas, of Catton 1
4628779 2239928 2239928 defendant Moese William (legal representative) 589315 589315 Moese, William, of Catton, executor of 7
4683346 2260395 2260395 defendant Maassyngham Edmund gent 589315 589315 Maassyngham, Edmund, of Catton, gent 0
4726284 2273505 2273505 defendant Ketton John husbandman 589315 589315 Ketton, John, of Catton, husbandman 1
4732491 2275333 2275333 defendant Massyngham Edmund gent 589315 589315 Massyngham, Edmund, of Catton, gent 0
4747651 2279819 2279819 defendant Massyngham Edmund yeoman 589315 589315 Massyngham, Edmund, of Catton, yeoman 2
4764636 2284925 2284925 defendant Manfeld John chaplain 589315 589315 Manfeld, John, of Catton, chaplain 0
4766260 2285440 2285440 defendant Todenham Richard   589315 589315 Todenham, Richard, of Catton, mason 0
4774212 2287915 2287915 defendant Percy Henry   589315 589315 Percy, Henry, of Catton, knight alias lord of Hundmanbye 0
4774215 2287916 2287916 defendant Percy Henry   589315 589315 Percy, Henry, of Catton, knight of the Bath 0
4779756 2289662 2289662 defendant Barden John yeoman 589315 589315 Barden, John, of Catton, yeoman 0
4779758 2289662 2289662 defendant Marsshall John husbandman 589315 589315 Marsshall, John, of Catton, husbandman 2
4784154 2291044 2291044 plaintiff del Chambyr Robert   589315 589315 del Chambyr, Robert, of Catton 0
4790187 2293014 2293014 plaintiff Keton John   589315 589315 Keton, John, of Catton 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);