names

995 rows where place_id = 587414

✎ 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
3588407 1864022 1864022 defendant Inglond George   587414 587414 Inglond, George, of Thetford, holy water clerk 0
3591340 1864919 1864919 plaintiff Dryver Hugh   587414 587414 Dryver, Hugh, of Thetford 2
3595097 1866098 1866098 plaintiff Lynes John   587414 587414 Lynes, John, of Thetford 0
3599870 1867610 1867610 defendant Skepper William yeoman 587414 587414 Skepper, William, of Thetford, yeoman 0
3603252 1868688 1868688 defendant Larke Thomas mercer 587414 587414 Larke, Thomas, of Thetford, mercer 0
3605088 1869257 1869257 defendant Marham Robert yeoman 587414 587414 Marham, Robert, of Thetford, yeoman 1
3606084 1869570 1869570 defendant Tramme Richard barker 587414 587414 Tramme, Richard, of Thetford, barker 1
3606507 1869707 1869707 defendant Whelewright Thomas osteler 587414 587414 Whelewright, Thomas, of Thetford, osteler 5
3607191 1869915 1869915 defendant Gambon William carpenter 587414 587414 Gambon, William, of Thetford, carpenter 1
3608687 1870377 1870377 defendant Skepper William butcher 587414 587414 Skepper, William, of Thetford, butcher 1
3608692 1870378 1870378 defendant Skepper William butcher 587414 587414 Skepper, William, of Thetford, butcher 1
3612245 1871464 1871464 defendant Howeman Robert   587414 587414 Howeman, Robert, of Thetford, shepherd 4
3615651 1872539 1872539 defendant Fayrman Reginald innkeeper 587414 587414 Fayrman, Reginald, of Thetford, innkeeper 0
3615652 1872539 1872539 defendant Reynold John dyer 587414 587414 Reynold, John, of Thetford, dyer 1
3615653 1872539 1872539 defendant Massany or Massavy Simon (legal representative) 587414 587414 Massany or Massavy, Simon, of Thetford, fishmonger, executors of 2
3615654 1872539 1872539 defendant Tonton or Touton Richard yeoman 587414 587414 (Tonton or Touton, Richard, of Thetford, yeoman 3
3617190 1873001 1873001 defendant Reyngnoldys or Reynoldys John dyer 587414 587414 Reyngnoldys or Reynoldys, John, of Thetford, dyer 0
3617406 1873063 1873063 defendant Skepper William yeoman 587414 587414 Skepper, William, of Thetford, yeoman 0
3617407 1873063 1873063 defendant Mondforth John yeoman 587414 587414 Mondforth, John, of Thetford, yeoman 1
3617408 1873063 1873063 defendant Skepper William butcher 587414 587414 Skepper, William, of Thetford, butcher 2
3617415 1873066 1873066 defendant Skepper William yeoman 587414 587414 Skepper, William, of Thetford, yeoman 0
3618009 1873252 1873252 defendant Bere alias Elmede Richard innholder 587414 587414 Bere alias Elmede, Richard, of Thetford, innholder 2
3620846 1874082 1874082 defendant Knyghton Thomas hardwareman 587414 587414 Knyghton, Thomas, of Thetford, hardwareman 3
3624689 1875261 1875261 plaintiff Tyllys William   587414 587414 Tyllys, William, of Thetford 0
3631587 1904692 1904692 defendant Betys William smith 587414 587414 Betys, William, of Thetford, smith 0
3634196 1905496 1905496 defendant Dewe Margaret widow 587414 587414 Dewe, Margaret, of Thetford, widow 3
3636138 1906094 1906094 defendant Scarlet John innholder 587414 587414 Scarlet, John, of Thetford, innholder 1
3642497 1908096 1908096 defendant Carter Andrew mercer 587414 587414 Carter, Andrew, of Thetford, mercer 0
3661366 1913830 1913830 defendant Lake Edmund husbandman 587414 587414 Lake, Edmund, of Thetford, husbandman 0
3662503 1914188 1914188 defendant May William tiler 587414 587414 May, William, of Thetford, tiler 0
3662504 1914188 1914188 defendant Leder Henry tanner 587414 587414 Leder, Henry, of Thetford, tanner 1
3663362 1914465 1914465 plaintiff Parsay Thomas (legal representative) 587414 587414 Parsay, Thomas, of Thetford, executor of 0
3671935 1917221 1917221 defendant Huet Thomas (legal representative) 587414 587414 Huet, Thomas, of Thetford, innholder, executors of 0
3671936 1917221 1917221 defendant Baxster Simon innholder 587414 587414 (Baxster, Simon, of Thetford, innholder 1
3671938 1917222 1917222 defendant Tyborn Richard yeoman 587414 587414 Tyborn, Richard, of Thetford, yeoman 0
3674640 1918119 1918119 defendant Pare John   587414 587414 Pare, John, of Thetford, coverlet weaver 2
3677168 1918901 1918901 defendant Johnson George sherman 587414 587414 Johnson, George, of Thetford, sherman 0
3682977 1920789 1920789 defendant Fishe Nicholas butcher 587414 587414 Fishe, Nicholas, of Thetford, butcher 0
3682978 1920789 1920789 defendant Bolle John tailor 587414 587414 Bolle, John, of Thetford, tailor 1
3689901 1923001 1923001 defendant Freston Robert draper 587414 587414 Freston, Robert, of Thetford, draper 0
3690133 1923073 1923073 plaintiff Fyssh Nicholas   587414 587414 Fyssh, Nicholas, of Thetford 0
3690667 1923245 1923245 defendant Swarston John mercer 587414 587414 Swarston, John, of Thetford, mercer 3
3690668 1923245 1923245 defendant Dreyton Simon husbandman 587414 587414 Dreyton, Simon, of Thetford, husbandman 4
3693656 1924210 1924210 defendant Roberdys Ralph chapman 587414 587414 Roberdys, Ralph, of Thetford, chapman 0
3693659 1924210 1924210 defendant Swarston John mercer 587414 587414 Swarston, John, of Thetford, mercer 3
3694948 1924630 1924630 defendant Swarston John mercer 587414 587414 Swarston, John, of Thetford, mercer 1
3696292 1925060 1925060 defendant Vale William, junior grocer 587414 587414 Vale, William, junior, of Thetford, grocer 3
3696296 1925061 1925061 defendant Vale William, junior grocer 587414 587414 Vale, William, junior, of Thetford, grocer 2
3696299 1925062 1925062 defendant Vale William, junior grocer 587414 587414 Vale, William, junior, of Thetford, grocer 1
3696982 1925282 1925282 defendant Swarston John mercer 587414 587414 Swarston, John, of Thetford, mercer 0
3704591 1927725 1927725 plaintiff Fyssh Nicholas   587414 587414 Fyssh, Nicholas, of Thetford 0
3706549 1928331 1928331 defendant Thirkill Joan widow 587414 587414 Thirkill, Joan, of Thetford, widow 3
3707565 1928660 1928660 defendant Pache John tailor 587414 587414 Pache, John, of Thetford, tailor 4
3707698 1928704 1928704 defendant Bolton Peter yeoman 587414 587414 Bolton, Peter, of Thetford, yeoman 0
3713800 1930616 1930616 plaintiff Attmer William   587414 587414 Attmer, William, of Thetford 0
3713803 1930617 1930617 plaintiff Attmer William   587414 587414 Attmer, William, of Thetford 0
3714506 1930833 1930833 defendant Hoodmyn Thomas yeoman 587414 587414 Hoodmyn, Thomas, of Thetford, yeoman 2
3714757 1930918 1930918 defendant Aleyn Geoffrey yeoman 587414 587414 Aleyn, Geoffrey, of Thetford, yeoman 0
3721414 1933005 1933005 defendant Tolton Richard yeoman 587414 587414 Tolton, Richard, of Thetford, yeoman 3
3722186 1933198 1933198 defendant Beell Ralph draper 587414 587414 Beell, Ralph, of Thetford, draper 0
3732977 1936536 1936536 defendant Dale John grocer 587414 587414 Dale, John, of Thetford, grocer 0
3733808 1936827 1936827 defendant Neyll Richard mercer 587414 587414 Neyll, Richard, of Thetford, mercer 0
3733809 1936827 1936827 defendant Freman Arthur yeoman or werrener 587414 587414 Freman, Arthur, of Thetford, yeoman or werrener 1
3734199 1936937 1936937 defendant Hadley Robert tailor 587414 587414 Hadley, Robert, of Thetford, tailor 1
3737961 1938090 1938090 defendant Beell Ralph raper 587414 587414 Beell, Ralph, of Thetford, raper 0
3739378 1938523 1938523 defendant Bell or Beele Ralph draper 587414 587414 Bell or Beele, Ralph, of Thetford, draper 0
3739571 1938587 1938587 defendant Dalton Peter tailor 587414 587414 Dalton, Peter, of Thetford, tailor 0
3740147 1938777 1938777 defendant Coket Thomas yeoman 587414 587414 Coket, Thomas, of Thetford, yeoman 1
3742255 1939448 1939448 plaintiff Tolton Richard yeoman 587414 587414 Tolton, Richard, of Thetford, yeoman 0
3744464 1940172 1940172 plaintiff Belton Thomas gent 587414 587414 Belton, Thomas, of Thetford, gent 1
3752991 1942868 1942868 defendant Vale John chapman 587414 587414 Vale, John, of Thetford, chapman 2
3755463 1943661 1943661 defendant Busshe Thomas clothier 587414 587414 Busshe, Thomas, of Thetford, clothier 1
3755961 1943818 1943818 defendant Bolton Peter mercer 587414 587414 Bolton, Peter, of Thetford, mercer 0
3756820 1944106 1944106 defendant Dey Thomas innholder 587414 587414 Dey, Thomas, of Thetford, innholder 0
3761422 1945585 1945585 defendant Chamberleyn Robert   587414 587414 Chamberleyn, Robert, of Thetford, shepherd 3
3762498 1945913 1945913 defendant Hudmyn Thomas glasier 587414 587414 Hudmyn, Thomas, of Thetford, glasier 2
3766829 1947290 1947290 defendant Smyth John laborer 587414 587414 Smyth, John, of Thetford, laborer 2
3770699 1948518 1948518 defendant Stroger Walter innholder 587414 587414 Stroger, Walter, of Thetford, innholder 0
3774423 1949724 1949724 plaintiff Atmere Ralph mercer 587414 587414 Atmere, Ralph, of Thetford, mercer 0
3774737 1949828 1949828 defendant Dey Thomas mercer 587414 587414 Dey, Thomas, of Thetford, mercer 0
3775162 1949965 1949965 defendant Dey Thomas innholder 587414 587414 Dey, Thomas, of Thetford, mercer, innholder 0
3777009 1950556 1950556 defendant Aleyn Geoffrey gent 587414 587414 Aleyn, Geoffrey, of Thetford, gent 0
3777625 1950752 1950752 defendant Mosse Robert tailor 587414 587414 Mosse, Robert, of Thetford, tailor 1
3787134 1953768 1953768 defendant Coket Thomas gent 587414 587414 Coket, Thomas, of Thetford, gent 1
3787139 1953769 1953769 defendant Cokett Thomas gent 587414 587414 Cokett, Thomas, of Thetford, gent 1
3789348 1954490 1954490 defendant Symond John husbandman 587414 587414 Symond, John, of Thetford, husbandman 0
3789350 1954490 1954490 defendant Cory Robert husbandman 587414 587414 Cory, Robert, of Thetford, husbandman 2
3791855 1955298 1955298 plaintiff Fikes Robert   587414 587414 Fikes, Robert, of Thetford 1
3797137 1956988 1956988 plaintiff Fykase Robert fishmonger 587414 587414 Fykase, Robert, of Thetford, fishmonger 0
3797687 1957173 1957173 defendant Robard Ralph mercer 587414 587414 Robard, Ralph, of Thetford, mercer 0
3799096 1957627 1957627 defendant Gambon Thomas carpenter 587414 587414 Gambon, Thomas, of Thetford, carpenter 1
3801026 1958235 1958235 plaintiff May John   587414 587414 May, John, of Thetford 0
3801196 1958295 1958295 defendant Smyth John laborer 587414 587414 Smyth, John, of Thetford, laborer 2
3801200 1958296 1958296 defendant Smythe John laborer 587414 587414 Smythe, John, of Thetford, laborer 2
3801642 1958411 1958411 defendant Nyker Thomas engraver 587414 587414 Nyker, Thomas, of Thetford, engraver 0
3803978 1959159 1959159 defendant Atmere Ralph grocer 587414 587414 Atmere, Ralph, of Thetford, grocer 3
3814774 1962533 1962533 defendant Dewe John clerk 587414 587414 Dewe, John, of Thetford, clerk 2
3818691 1963748 1963748 defendant Smyth John laborer 587414 587414 Smyth, John, of Thetford, laborer 2
3819743 1964056 1964056 defendant Aleyn Geffrey gent 587414 587414 Aleyn, Geffrey, of Thetford, gent 0
3820841 1964409 1964409 defendant Dey Thomas innholder and mercer 587414 587414 Dey, Thomas, of Thetford, innholder and mercer 3

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