names

90 rows where place_id = 600376

✎ 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
3640782 1907563 1907563 defendant Horne Ralph yeoman 600376 600376 Horne, Ralph, of Newmarket, Suff, yeoman 0
3650932 1910662 1910662 defendant Smyth John innholder 600376 600376 Smyth, John, of Newmarket, Suff, innholder 0
3650934 1910663 1910663 defendant Smyth John innholder 600376 600376 Smyth, John, of Newmarket, Suff, innholder 0
3668493 1916101 1916101 defendant Elmer Nicholas yeoman 600376 600376 Elmer, Nicholas, of Newmarket, Suff, yeoman 0
3678414 1919302 1919302 defendant Tyllot William mercer 600376 600376 Tyllot, William, of Newmarket, Suff, mercer, Blakman, Robert, of Bury St Edmunds, mercer 0
3680221 1919886 1919886 defendant Tyllot William mercer 600376 600376 Tyllot, William, of Newmarket, Suff, mercer 1
3710793 1929692 1929692 defendant Whitehall John fishmonger 600376 600376 Whitehall, John, of Newmarket, Suff, fishmonger 0
3712884 1930348 1930348 defendant Parmentour alias Couper William yeoman 600376 600376 Parmentour alias Couper, William, of Newmarket, Suff, yeoman 0
3712886 1930349 1930349 defendant Parmentour alias Cowper William yeoman 600376 600376 Parmentour alias Cowper, William, of Newmarket, Suff, yeoman 0
3726306 1934497 1934497 defendant Smyth Alice widow 600376 600376 Smyth, Alice, of Newmarket, Suff, widow 0
3729946 1935620 1935620 defendant Cowper alias Parmanter William raffman 600376 600376 Cowper alias Parmanter, William, of Newmarket, Suff, raffman 0
3742040 1939377 1939377 defendant Smyth Alice widow 600376 600376 Smyth, Alice, of Newmarket, Suff, widow 0
3758654 1944702 1944702 defendant Parmenton or Parmentor alias Cowper William yeoman 600376 600376 Parmenton or Parmentor alias Cowper, William, of Newmarket, Suff, yeoman 0
3775366 1950036 1950036 defendant Oderyche Ralph   600376 600376 Oderyche, Ralph, of Newmarket, Suff, tallow chandler 2
3777059 1950572 1950572 defendant Awtheriche Ralph chandler 600376 600376 Awtheriche, Ralph, of Newmarket, Suff, chandler 0
3828434 1966765 1966765 defendant Nytynghale William laborer 600376 600376 Nytynghale, William, of Newmarket, Suff, laborer 2
3845915 1972280 1972280 plaintiff Funston Henry yeoman 600376 600376 Funston, Henry, of Newmarket, Suff, yeoman 0
3866765 1979120 1979120 defendant Chandeler John husbandman 600376 600376 Chandeler, John, of Newmarket, Suff, husbandman 1
3875587 1982076 1982076 plaintiff Fouston Henry, senior (legal representative) 600376 600376 Fouston, Henry, senior, of Newmarket, Suff, yeoman, executrix of 0
3879052 1983246 1983246 defendant Rowce John innholder 600376 600376 Rowce, John, of Newmarket, Suff, innholder 3
3879057 1983247 1983247 defendant Rowce John innholder 600376 600376 Rowce, John, of Newmarket, Suff, innholder 3
3886789 1985843 1985843 defendant Papper John yeoman 600376 600376 Papper, John, of Newmarket, Suff, yeoman 2
3886790 1985843 1985843 defendant Papper Robert yeoman 600376 600376 Papper, Robert, of Newmarket, Suff, yeoman 3
3958071 2009890 2009890 defendant Funston John husbandman 600376 600376 Funston, John, of Newmarket, Suff, husbandman 2
4002047 2025513 2025513 defendant Funtstone Christopher yeoman 600376 600376 Funtstone, Christopher, of Newmarket, Suff, yeoman 0
4005895 2026878 2026878 defendant Turner Robert mercer 600376 600376 Turner, Robert, of Newmarket, Suff, mercer 0
4019563 2031724 2031724 defendant Budd alias Aldridge Robert yeoman or blacksmith 600376 600376 Budd alias Aldridge, Robert, of Newmarket, Suff, yeoman or blacksmith 0
4037909 2038207 2038207 defendant Turner Robert yeoman 600376 600376 Turner, Robert, of Newmarket, Suff, yeoman 1
4038242 2038313 2038313 defendant Archer Thomas baker 600376 600376 Archer, Thomas, of Newmarket, Suff, baker 0
4071931 2050260 2050260 defendant Stanor Thomas husbandman 600376 600376 Stanor, Thomas, of Newmarket, Suff, husbandman 0
4075937 2051695 2051695 defendant Stawver John husbandman 600376 600376 Stawver, John, of Newmarket, Suff, husbandman 1
4095716 2058800 2058800 defendant King Thomas yeoman 600376 600376 King, Thomas, of Newmarket, Suff, yeoman 0
4106686 2062682 2062682 defendant Dane Thomas fisherman 600376 600376 Dane, Thomas, of Newmarket, Suff, fisherman 0
4131045 2071419 2071419 defendant Turner Robert yeoman 600376 600376 Turner, Robert, of Newmarket, Suff, yeoman 0
4223009 2103538 2103538 defendant Funston Christopher yeoman 600376 600376 Funston, Christopher, of Newmarket, Suff, yeoman 1
4251167 2113368 2113368 defendant Roote David pedder 600376 600376 Roote, David, of Newmarket ,Suff, pedder 0
4317028 2136067 2136067 defendant Funston Christopher, junior yeoman 600376 600376 Funston, Christopher, junior, of Newmarket, Suff, chapman, yeoman 0
4671927 2256866 2256866 defendant Gatewarde Richard husbandman 600376 600376 Gatewarde, Richard, of Newmarket, Suff, husbandman 3
4688813 2262056 2262056 defendant Clakke Walter pedder 600376 600376 Clakke, Walter, of Newmarket, Suff, pedder 0
4710813 2268737 2268737 defendant Souter Thomas husbandman 600376 600376 Souter, Thomas, of Newmarket, Suff, husbandman 0
4742091 2278181 2278181 defendant Clak Walter yeoman 600376 600376 Clak, Walter, of Newmarket, Suff, yeoman 1
4742791 2278400 2278400 defendant Doo Richard yeoman 600376 600376 Doo, Richard, of Newmarket, Suff, yeoman 0
4746982 2279620 2279620 defendant Kyrkeby John gent 600376 600376 (Kyrkeby, John, of Newmarket, Suff, gent 1
4764412 2284857 2284857 defendant Benet John husbandman 600376 600376 Benet, John, of Newmarket, Suff, husbandman 2
4779993 2289744 2289744 defendant Fethelere Peter   600376 600376 Fethelere, Peter, of Newmarket, Suff, parchment maker 0
4814433 2300621 2300621 defendant Forld John yeoman 600376 600376 (Forld, John, of Newmarket, Suff, yeoman 2
4818660 2301920 2301920 defendant Spycer Henry shoemaker 600376 600376 Spycer, Henry, of Newmarket, Suff, shoemaker 0
4840927 2308697 2308697 defendant Kaukwrong Thomas ostler 600376 600376 Kaukwrong, Thomas, of Newmarket, Suff, ostler 1
4873030 2318523 2318523 defendant Farwell William butcher 600376 600376 Farwell, William, of Newmarket, Suff, butcher 0
4873034 2318524 2318524 defendant Farwell William butcher 600376 600376 Farwell, William, of Newmarket, Suff, butcher 0
4884462 2322043 2322043 defendant Cook Lawrence husbandman 600376 600376 Cook, Lawrence, of Newmarket, Suff, husbandman 1
4894860 2325057 2325057 defendant Smyth Thomas chapman 600376 600376 Smyth, Thomas, of Newmarket, Suff, chapman 3
4919278 2332539 2332539 defendant Hattewrong Henry gent 600376 600376 Hattewrong, Henry, of Newmarket, Suff, gent 2
4935746 2337571 2337571 defendant Leyston John panierman 600376 600376 Leyston, John, of Newmarket, Suff, panierman 0
4953520 2343023 2343023 defendant Ferrour or Smith John yeoman 600376 600376 together with Ferrour or Smith, John, of Newmarket, Suff, yeoman 2
4974603 2349370 2349370 defendant Lothe Ralph chapman 600376 600376 Lothe, Ralph, of Newmarket, Suff, chapman 0
4999020 2356588 2356588 defendant Dawes William mercer 600376 600376 Dawes, William, of Newmarket, Suff, mercer 3
5018883 2362410 2362410 defendant Balsham alias Dawys William yeoman 600376 600376 Balsham alias Dawys, William, of Newmarket, Suff, yeoman 0
5022295 2363414 2363414 defendant Balsam alias Dawys William chapman 600376 600376 Balsam alias Dawys, William, of Newmarket, Suff, chapman 1
5027857 2365027 2365027 defendant Ballone Ralph smith 600376 600376 Ballone, Ralph, of Newmarket, Suff, smith 2
5034958 2367083 2367083 defendant Balsham William yeoman 600376 600376 Balsham, William, of Newmarket, Suff, yeoman 2
5056592 2373544 2373544 defendant Coterell Nicholas yeoman 600376 600376 Coterell, Nicholas, of Newmarket, Suff, yeoman 1
5063997 2375763 2375763 defendant Coterell Nicholas yeoman 600376 600376 Coterell, Nicholas, of Newmarket, Suff, yeoman 0
5073593 2378584 2378584 defendant Leyceter Thomas fisher 600376 600376 Leyceter, Thomas, of Newmarket, Suff, fisher 1
5104780 2387835 2387835 defendant Coterell Nicholas husbandman 600376 600376 Coterell, Nicholas, of Newmarket, Suff, husbandman 3
5202332 2416445 2416445 defendant Rothe John tailor 600376 600376 Rothe, John, of Newmarket, Suff, tailor 0
5223058 2422458 2422458 defendant Wilkynson Edward yeoman 600376 600376 Wilkynson, Edward, of Newmarket, Suff, yeoman 1
5236489 2426258 2426258 defendant Loee Ralph tailor 600376 600376 Loee, Ralph, of Newmarket, Suff, tailor 1
5237922 2426676 2426676 defendant Jynyng Richard yeoman 600376 600376 (Jynyng, Richard, of Newmarket, Suff, yeoman 1
5241557 2427730 2427730 defendant Corte Thomas chapman 600376 600376 Corte, Thomas, of Newmarket, Suff, chapman 4
5292446 2442786 2442786 defendant Lote Ralph yeoman 600376 600376 Lote, Ralph, of Newmarket, Suff, yeoman 4
5316104 2449890 2449890 defendant Lucas Richard (legal representative) 600376 600376 Lucas, Richard, of Newmarket, Suff, chaplain, executors of 0
5335300 2455627 2455627 defendant Beteryng Henry husbandman 600376 600376 Beteryng, Henry, of Newmarket, Suff, husbandman 0
5366030 2465033 2465033 plaintiff Boydone Thomas   600376 600376 Boydone, Thomas, of Newmarket, Suff 0
5366032 2465034 2465034 plaintiff Boydone Thomas   600376 600376 Boydone, Thomas, of Newmarket, Suff 0
5375357 2467881 2467881 defendant Meye William smith 600376 600376 Meye, William, of Newmarket, Suff, smith 2
5375373 2467886 2467886 defendant Meye William smith 600376 600376 Meye, William, of Newmarket, Suff, smith 0
5399323 2474878 2474878 defendant Gynne John   600376 600376 Gynne, John, of Newmarket, Suff, pedlar 3
5403779 2476155 2476155 defendant Baker Thomas yeoman 600376 600376 Baker, Thomas, of Newmarket, Suff, yeoman 3
5412327 2478631 2478631 defendant Gynne John pedder 600376 600376 Gynne, John, of Newmarket, Suff, pedder 2
5417001 2479995 2479995 defendant Baker Thomas yeoman 600376 600376 Baker, Thomas, of Newmarket, Suff, yeoman 2
5419268 2480690 2480690 defendant Porter Thomas yeoman 600376 600376 Porter, Thomas, of Newmarket, Suff, yeoman 1
5434016 2485126 2485126 defendant Baker Thomas yeoman 600376 600376 Baker, Thomas, of Newmarket, Suff, yeoman 2
5437469 2486148 2486148 defendant (illegible) Thomas yeoman 600376 600376 _, Thomas, of Newmarket, Suff, yeoman 0
5439644 2486800 2486800 defendant Fleg Robert yeoman 600376 600376 Fleg, Robert, of Newmarket, Suff, yeoman 0
5475351 2497620 2497620 defendant Porter Thomas yeoman 600376 600376 Porter, Thomas, of Newmarket, Suff, yeoman 0
5480663 2499180 2499180 defendant Patryngton John innholder 600376 600376 Patryngton, John, of Newmarket, Suff, innholder 3
5481642 2499439 2499439 defendant Wright John yeoman 600376 600376 Wright, John, of Newmarket, Suff, yeoman 2
5501987 2505543 2505543 defendant Folkys William hosteler 600376 600376 Folkys, William, of Newmarket, Suff, hosteler 0
5522681 2511920 2511920 defendant Dowe Thomas yeoman 600376 600376 Dowe, Thomas, of Newmarket, Suff, yeoman 0

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