names

50 rows where place_id = 602304

✎ 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
3649429 1910211 1910211 defendant Bultell William husbandman 602304 602304 Bultell, William, of Swaffham Market, husbandman 3
3677287 1918947 1918947 plaintiff Leman Thomas clerk 602304 602304 Leman, Thomas, of Swaffham Market, clerk 0
3682607 1920665 1920665 defendant Malet Peter butcher 602304 602304 Malet, Peter, of Swaffham Market, butcher 0
3699795 1926161 1926161 defendant Langham William husbandman 602304 602304 Langham, William, of Swaffham Market, husbandman 0
3712131 1930111 1930111 defendant Langham William husbandman 602304 602304 Langham, William, of Swaffham Market, husbandman 0
3720337 1932640 1932640 defendant Thebold Brian yeoman 602304 602304 Thebold, Brian, of Swaffham Market, yeoman 0
3735866 1937455 1937455 defendant Awdeley John   602304 602304 Awdeley, John, of Swaffham Market, knight 0
3741141 1939091 1939091 defendant Bosom or Besom Robert chaplain 602304 602304 (Bosom or Besom, Robert, of Swaffham Market, chaplain 1
3744087 1940046 1940046 defendant Loveday Alan   602304 602304 Loveday, Alan, of Swaffham Market, "rafman" 0
3757651 1944372 1944372 defendant Awdeley John   602304 602304 Awdeley, John, of Swaffham Market, knight 0
3774003 1949583 1949583 defendant Carter William draper 602304 602304 Carter, William, of Swaffham Market, draper 0
3783784 1952694 1952694 defendant Harpeley John husbandman 602304 602304 Harpeley, John, of Swaffham Market, husbandman 0
3785811 1953349 1953349 defendant Mere John husbandman 602304 602304 Mere, John, of Swaffham Market, husbandman 2
3786120 1953450 1953450 defendant Ram John husbandman 602304 602304 Ram, John, of Swaffham Market, husbandman 0
3790574 1954874 1954874 defendant Olde alis Hold John tanner 602304 602304 Olde alis Hold, John, of Swaffham Market, tanner 0
3808736 1960611 1960611 defendant May Simon husbandman 602304 602304 May, Simon, of Swaffham Market, husbandman 0
3810663 1961234 1961234 defendant Foster Miles draper 602304 602304 Foster, Miles, of Swaffham Market, draper 0
3810664 1961234 1961234 defendant Mychell William husbandman 602304 602304 Mychell, William, of Swaffham Market, husbandman 1
3810971 1961331 1961331 defendant Cressy John mercer 602304 602304 Cressy, John, of Swaffham Market, mercer 0
3812940 1961944 1961944 defendant Coo John yeoman 602304 602304 Coo, John, of Swaffham Market, yeoman 0
3812941 1961944 1961944 defendant Dey Robert laborer 602304 602304 Dey, Robert, of Swaffham Market, laborer 1
3823155 1965154 1965154 defendant Lawes Henry mercer 602304 602304 Lawes, Henry, of Swaffham Market, mercer 0
3823156 1965154 1965154 defendant Bukke Robert woolman 602304 602304 Bukke, Robert, of Swaffham Market, woolman 1
3824091 1965407 1965407 defendant Gryggys Ambrice or Aubrey gent 602304 602304 Gryggys, Ambrice or Aubrey, of Swaffham Market, gent 0
3824093 1965408 1965408 defendant Gryggys Ambrice gent 602304 602304 Gryggys, Ambrice, of Swaffham Market, gent 0
3825621 1965865 1965865 defendant Thyrlyng Henry laborer 602304 602304 Thyrlyng, Henry, of Swaffham Market, laborer 3
3839840 1970392 1970392 defendant Thyrlyng Henry husbandman 602304 602304 Thyrlyng, Henry, of Swaffham Market, husbandman 0
3841451 1970904 1970904 defendant Lavelowe or Lewelowe Walter yeoman 602304 602304 Lavelowe or Lewelowe, Walter, of Swaffham Market, yeoman 3
3847968 1972940 1972940 defendant Wryght John cooper 602304 602304 Wryght, John, of Swaffham Market, cooper 0
3847969 1972940 1972940 defendant Bunne Robert husbandman 602304 602304 Bunne, Robert, of Swaffham Market, husbandman 1
3857481 1975975 1975975 defendant Langman John husbandman 602304 602304 Langman, John, of Swaffham Market, husbandman 0
3870429 1980354 1980354 defendant Cressy John mercer 602304 602304 Cressy, John, of Swaffham Market, mercer 0
3870430 1980354 1980354 defendant Aylmer Henry shoemaker 602304 602304 Aylmer, Henry, of Swaffham Market, shoemaker 1
3870431 1980354 1980354 defendant Parker John shoemaker 602304 602304 Parker, John, of Swaffham Market, shoemaker 2
3877765 1982802 1982802 defendant Fyn Richard husbandman 602304 602304 Fyn, Richard, of Swaffham Market, husbandman 0
3907824 1992905 1992905 defendant Bukke Robert   602304 602304 Bukke, Robert, of Swaffham Market, wool merchant 0
3907825 1992905 1992905 defendant Bryell Robert   602304 602304 Bryell, Robert, of Swaffham Market, surgeon, son of Theobald Bryell 1
3929534 2000227 2000227 plaintiff Cannon alais Canaham Robert draper 602304 602304 Cannon alais Canaham, Robert, of Swaffham Market, draper 0
3941237 2004073 2004073 defendant Johnson Lawrence husbandman 602304 602304 Johnson, Lawrence, of Swaffham Market, husbandman 3
3945526 2005510 2005510 defendant Levolde alias Furrour John skinner 602304 602304 Levolde alias Furrour, John, of Swaffham Market, skinner 0
3946607 2005881 2005881 plaintiff Canham Robert yeoman 602304 602304 Canham, Robert, of Swaffham Market, yeoman 0
3973817 2015411 2015411 defendant Raynold Thomas butcher 602304 602304 Raynold, Thomas, of Swaffham Market, butcher 0
3993062 2022269 2022269 plaintiff Canon John draper 602304 602304 Canon, John, of Swaffham Market, draper 0
4235230 2107881 2107881 defendant Cannon Simon yeoman 602304 602304 Cannon, Simon, of Swaffham Market, yeoman 0
4258019 2115653 2115653 defendant Warde Thomas butcher 602304 602304 Warde, Thomas, of Swaffham Market, butcher 1
4289063 2126146 2126146 defendant Chavenor or Chavenor Robert gent 602304 602304 Chavenor or Chavenor, Robert, of Swaffham Market, gent 0
5499092 2504668 2504668 plaintiff Blake Simon   602304 602304 Blake, Simon, of Swaffham Market 2
5535362 2515586 2515586 defendant Cartar Geoffrey   602304 602304 Cartar, Geoffrey, of Swaffham Market, wool chapman 0
5582990 2529754 2529754 defendant Johnson William husbandman 602304 602304 Johnson, William, of Swaffham Market, husbandman 1
5608125 2537447 2537447 defendant Payn William yeoman 602304 602304 Payn, William, of Swaffham Market, yeoman 1

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