names

118 rows where place_id = 611520

✎ 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
3637327 1906479 1906479 plaintiff Sigo Henry (legal representative) 611520 611520 Sigo, Henry, of Bryston, executors of 0
3688745 1922641 1922641 defendant Newman John carpenter 611520 611520 Newman, John, of Bryston, carpenter 1
3702450 1927027 1927027 defendant Catys Thomas husbandman 611520 611520 Catys, Thomas, of Bryston, husbandman 2
3705631 1928043 1928043 defendant Apulton John, senior (legal representative) 611520 611520 Apulton, John, senior, of Bryston, husbandman, executors of 0
3705632 1928043 1928043 defendant Apulton John husbandman 611520 611520 (Apulton, John, of Bryston, husbandman 1
3705633 1928043 1928043 defendant Toly Margery widow 611520 611520 Toly, Margery, of Bryston, widow 2
3717382 1931721 1931721 defendant Newman Edmund carpenter 611520 611520 Newman, Edmund, of Bryston, carpenter 0
3732309 1936344 1936344 defendant Newman John husbandman 611520 611520 Newman, John, of Bryston, husbandman 2
3738545 1938263 1938263 defendant Colman Richard carpenter 611520 611520 Colman, Richard, of Bryston, carpenter 0
3843171 1971393 1971393 defendant Catys John husbandman 611520 611520 Catys, John, of Bryston, husbandman 1
3843173 1971394 1971394 defendant Warne Nicholas husbandman 611520 611520 Warne, Nicholas, of Bryston, husbandman 0
3895431 1988681 1988681 defendant Reymes Eustace husbandman 611520 611520 Reymes, Eustace, of Bryston, husbandman 0
3895432 1988681 1988681 defendant Cadys Thomas husbandman 611520 611520 Cadys, Thomas, of Bryston, husbandman 1
3895433 1988681 1988681 defendant Bryght Edward husbandman 611520 611520 Bryght, Edward, of Bryston, husbandman 2
3896260 1988958 1988958 defendant Broun Richard clerk 611520 611520 Broun, Richard, of Bryston, clerk 0
3896262 1988959 1988959 defendant Browne Robert clerk 611520 611520 Browne, Robert, of Bryston, clerk 0
3912791 1994609 1994609 defendant Tolke William husbandman 611520 611520 Tolke, William, of Bryston, husbandman 0
3929086 2000069 2000069 plaintiff Browne Richard clerk 611520 611520 Browne, Richard, of Bryston, clerk 0
4017685 2031035 2031035 defendant Large Robert husbandman 611520 611520 Large, Robert, of Bryston, husbandman 0
4017686 2031035 2031035 defendant Coser John husbandman 611520 611520 Coser, John, of Bryston, husbandman 1
4017687 2031035 2031035 defendant Cates John husbandman 611520 611520 Cates, John, of Bryston, husbandman 2
4017688 2031035 2031035 defendant Hill Thomas husbandman 611520 611520 Hill, Thomas, of Bryston, husbandman 3
4017689 2031035 2031035 defendant Baldyng John husbandman 611520 611520 Baldyng, John, of Bryston, husbandman 4
4154846 2079790 2079790 defendant Bacon William husbandman 611520 611520 Bacon, William, of Bryston, husbandman 0
4225240 2104295 2104295 defendant Batelye William thatcher 611520 611520 Batelye, William, of Bryston, thatcher 2
4225241 2104295 2104295 defendant Batelye Robert carpenter 611520 611520 Batelye, Robert, of Bryston, carpenter 3
4320776 2137362 2137362 defendant Batelye Thomas thatcher 611520 611520 Batelye, Thomas, of Bryston, thatcher 0
4320777 2137362 2137362 defendant Batelye William thatcher 611520 611520 Batelye, William, of Bryston, thatcher 1
4320778 2137362 2137362 defendant Batelye Robert carpenter 611520 611520 Batelye, Robert, of Bryston, carpenter 2
4339807 2143695 2143695 defendant Arnold Robert tailor 611520 611520 Arnold, Robert, of Bryston, tailor 0
4389424 2161088 2161088 defendant Arnolde Robert tailor 611520 611520 Arnolde, Robert, of Bryston, tailor 0
4389426 2161089 2161089 defendant Arnolde Robert tailor 611520 611520 Arnolde, Robert, of Bryston, tailor 0
4482755 2195314 2195314 defendant Souter John   611520 611520 Souter, John, of Bryston 1
4577212 2224389 2224389 defendant Maupas John   611520 611520 Maupas, John, of Bryston 1
4732444 2275321 2275321 plaintiff Parker John   611520 611520 Parker, John, of Bryston 0
4759607 2283349 2283349 plaintiff Clerk Henry   611520 611520 Clerk, Henry, of Bryston 0
4780183 2289800 2289800 defendant Holbeme John husbandman 611520 611520 Holbeme, John, of Bryston, husbandman 3
4836637 2307433 2307433 plaintiff Everrard Simon   611520 611520 Everrard, Simon, of Bryston 0
4836639 2307433 2307433 defendant Merwen Edmumd yeoman 611520 611520 Merwen, Edmumd, of Bryston, yeoman 0
4838651 2308014 2308014 defendant Frere (illegible) yeoman 611520 611520 Frere, _, of Bryston, yeoman 1
4851891 2312026 2312026 defendant Awety John husbandman 611520 611520 Awety, John, of Bryston, husbandman 0
4852536 2312215 2312215 defendant Everard Simon butcher 611520 611520 Everard, Simon, of Bryston, butcher 0
4852537 2312215 2312215 defendant Frere Godwin yeoman 611520 611520 Frere, Godwin, of Bryston, yeoman 1
4852538 2312215 2312215 defendant Coldham Thomas yeoman 611520 611520 Coldham, Thomas, of Bryston, yeoman 2
4852539 2312215 2312215 defendant Moris Walter yeoman 611520 611520 Moris, Walter, of Bryston, yeoman 3
4863965 2315704 2315704 plaintiff Everard Simon   611520 611520 Everard, Simon, of Bryston 0
4864181 2315774 2315774 defendant Joynour Nicholas yeoman 611520 611520 Joynour, Nicholas, of Bryston, yeoman 0
4871552 2318073 2318073 defendant Norton John yeoman 611520 611520 Norton John, of Bryston, yeoman 0
4872582 2318382 2318382 defendant Awety John yeoman 611520 611520 Awety, John, of Bryston, yeoman 0
4873151 2318553 2318553 defendant D- Roger yeoman 611520 611520 D-, Roger, of Bryston, yeoman 5
4962128 2345577 2345577 defendant Coldham Thomas husbandman 611520 611520 Coldham, Thomas, of Bryston, husbandman 6
4964938 2346428 2346428 defendant Norton Thomas husbandman 611520 611520 Norton, Thomas, of Bryston, husbandman 0
4989321 2353740 2353740 defendant Foulere Robert laborer 611520 611520 Foulere, Robert, of Bryston, laborer 0
4989322 2353740 2353740 defendant Sawyer John fuller 611520 611520 Sawyer, John, of Bryston, fuller 1
4989323 2353740 2353740 defendant Norton Nicholas fuller 611520 611520 Norton, Nicholas, of Bryston, fuller 2
5020868 2363001 2363001 plaintiff Everard John   611520 611520 Everard, John, of Bryston, his son 1
5074206 2378770 2378770 defendant Hamond Edmund husbandman 611520 611520 Hamond, Edmund, of Bryston, husbandman 0
5094651 2384848 2384848 defendant Park Robert baker 611520 611520 Park, Robert, of Bryston, baker 2
5104720 2387818 2387818 defendant (not given) Robert vicar of Smyth 611520 611520 Smyth, Robert, of Bryston, vicar of Tuttyngton 0
5118953 2391976 2391976 defendant Park Robert husbandman 611520 611520 Park, Robert, of Bryston, husbandman 2
5171336 2407342 2407342 plaintiff Langwade Thomas   611520 611520 Langwade, Thomas, of Bryston 0
5171337 2407342 2407342 defendant Coldam Henry husbandman 611520 611520 Coldam, Henry, of Bryston, husbandman 0
5171338 2407342 2407342 defendant Coldam Simon husbandman 611520 611520 Coldam, Simon, of Bryston, husbandman 1
5195418 2414410 2414410 defendant Park Robert of baker 611520 611520 Park, Robert of, of Bryston, baker 0
5195421 2414410 2414410 defendant Mordewe Thomas butcher 611520 611520 Mordewe, Thomas, of Bryston, butcher 3
5209277 2418446 2418446 defendant Park Robert of baker 611520 611520 Park, Robert of, of Bryston, baker 0
5209280 2418446 2418446 defendant Mordewe Thomas butcher 611520 611520 Mordewe, Thomas, of Bryston, butcher 3
5233034 2425242 2425242 defendant Coldham Simon husbandman 611520 611520 Coldham, Simon, of Bryston, husbandman 0
5251527 2430582 2430582 defendant Mony John husbandman 611520 611520 Mony, John, of Bryston, husbandman 1
5251539 2430585 2430585 defendant Mony John husbandman 611520 611520 Mony, John, of Bryston, husbandman 1
5252373 2430854 2430854 plaintiff Barbour William yeoman 611520 611520 Barbour, William, of Bryston, yeoman 0
5279342 2439049 2439049 defendant Coldam Henry laborer 611520 611520 Coldam, Henry, of Bryston, laborer 0
5279343 2439049 2439049 defendant Simman Robert husbandman 611520 611520 Simman, Robert, of Bryston, husbandman 1
5279344 2439049 2439049 defendant Belly Thomas laborer 611520 611520 Belly, Thomas, of Bryston, laborer 2
5279345 2439049 2439049 defendant Gellowe John husbandman 611520 611520 Gellowe, John, of Bryston, husbandman 3
5279346 2439049 2439049 defendant Hewemanys John husbandman 611520 611520 Hewemanys, John, of Bryston, husbandman 4
5287075 2441231 2441231 defendant Souman or Seuman Robert yeoman 611520 611520 Souman or Seuman, Robert, of Bryston, yeoman 1
5288082 2441530 2441530 defendant Tolke William husbandman 611520 611520 Tolke, William, of Bryston, husbandman 0
5291312 2442462 2442462 defendant Joye John laborer 611520 611520 Joye, John, of Bryston, laborer 3
5298571 2444557 2444557 defendant Coldham Henry husbandman 611520 611520 Coldham, Henry, of Bryston, husbandman 1
5305281 2446584 2446584 defendant Deny John husbandman 611520 611520 Deny, John, of Bryston, husbandman 0
5319742 2451000 2451000 defendant Boleyn Thomas husbandman 611520 611520 Boleyn, Thomas, of Bryston, husbandman 0
5323677 2452167 2452167 defendant Coldeham alias Petyte Simon husbandman 611520 611520 Coldeham alias Petyte, Simon, of Bryston, husbandman 0
5329917 2454019 2454019 defendant Jerveys Thomas yeoman 611520 611520 Jerveys, Thomas, of Bryston, yeoman 1
5332977 2454930 2454930 defendant Lathe William smith 611520 611520 Lathe, William, of Bryston, smith 2
5337683 2456344 2456344 defendant Gerveys Thomas husbandman 611520 611520 Gerveys, Thomas, of Bryston, husbandman 0
5348645 2459707 2459707 defendant Jerveys Thomas yeoman 611520 611520 Jerveys, Thomas, of Bryston, yeoman 0
5349374 2459935 2459935 defendant Toly Robert husbandman 611520 611520 Toly, Robert, of Bryston, husbandman 1
5349875 2460096 2460096 defendant Lath William smith 611520 611520 Lath, William, of Bryston, smith 0
5349881 2460097 2460097 defendant Lathe William smith 611520 611520 Lathe, William, of Bryston, smith 0
5349959 2460117 2460117 defendant Gervys Thomas butcher 611520 611520 Gervys, Thomas, of Bryston, butcher 0
5356365 2462060 2462060 plaintiff Chamberleyn Thomas   611520 611520 Chamberleyn, Thomas, of Bryston 3
5356373 2462061 2462061 plaintiff Chamberleyn Thomas   611520 611520 Chamberleyn, Thomas, of Bryston 3
5358556 2462736 2462736 defendant Everard Katherine widow 611520 611520 Everard, Katherine, of Bryston, widow 1
5384758 2470725 2470725 defendant Toly Robert laborer 611520 611520 Toly, Robert, of Bryston, laborer 3
5384787 2470725 2470725 defendant Langwade Thomas (legal representative) 611520 611520 Langwade, Thomas, of Bryston, yeoman, administrator of John Bryston, of Bryston, senior, esq, executors of 32
5384788 2470725 2470725 defendant Langewade John yeoman 611520 611520 (Langewade, John, of Bryston, yeoman 33
5384789 2470725 2470725 defendant Lanwade Marion widow 611520 611520 Lanwade, Marion, of Bryston, widow 34
5396775 2474170 2474170 defendant Toly Robert laborer 611520 611520 Toly, Robert, of Bryston, laborer 3
5396804 2474170 2474170 defendant Langewade Thomas esq 611520 611520 Langewade, Thomas, of Bryston, yeoman, administrator of John Bryston, senior, of Bryston, esq 32

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