names

804 rows where place_id = 588126

✎ 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
3593457 1865586 1865586 defendant Heyward James husbandman 588126 588126 Heyward, James, of North Walsham, husbandman 2
3598841 1867263 1867263 defendant Albon Thomas husbandman 588126 588126 Albon, Thomas, of North Walsham, husbandman 1
3602543 1868457 1868457 defendant Herte Thomas husbandman 588126 588126 Herte, Thomas, of North Walsham, husbandman 0
3603380 1868729 1868729 defendant Albon Thomas yeoman 588126 588126 Albon, Thomas, of North Walsham, yeoman 0
3606756 1869787 1869787 defendant Bernard Thomas yeoman 588126 588126 Bernard, Thomas, of North Walsham, yeoman 4
3608708 1870384 1870384 defendant Albon Thomas yeoman 588126 588126 Albon, Thomas, of North Walsham, yeoman 0
3613849 1871987 1871987 defendant Bradefeld Robert yeoman 588126 588126 Bradefeld, Robert, of North Walsham, yeoman 0
3632584 1905009 1905009 defendant Cooke Edmund   588126 588126 Cooke, Edmund, of North Walsham clerk 0
3642363 1908059 1908059 defendant Roughe Cecilia (legal representative) 588126 588126 Roughe, Cecilia, of North Walsham, widow, executrix of Roughe, Thomas, of Barton juxta Smalburgh, yeoman, executors of 0
3649267 1910160 1910160 defendant Mundes John husbandman 588126 588126 Mundes, John, of North Walsham, husbandman 0
3662825 1914287 1914287 defendant Clubbe Nicholas, senior husbandman 588126 588126 Clubbe, Nicholas, senior, of North Walsham, husbandman 1
3689584 1922899 1922899 defendant Walsyngham Robert husbandman 588126 588126 Walsyngham, Robert, of North Walsham, husbandman 3
3692270 1923752 1923752 defendant Norwiche John smith 588126 588126 Norwiche, John, of North Walsham, smith 3
3695226 1924725 1924725 plaintiff Playford John (legal representative) 588126 588126 Playford, John, of North Reppis, senior, executor of 0
3696191 1925029 1925029 defendant Clemens Lionel husbandman 588126 588126 Clemens, Lionel, of North Walsham, husbandman 2
3697995 1925599 1925599 defendant Coystroype John husbandman 588126 588126 Coystroype, John, of North Walsham, husbandman 0
3697997 1925599 1925599 defendant Thirkill Nicholas husbandman 588126 588126 Thirkill, Nicholas, of North Walsham, husbandman 2
3697998 1925599 1925599 defendant Dalle Henry husbandman 588126 588126 Dalle, Henry, of North Walsham, husbandman 3
3702961 1927196 1927196 defendant Walsyngham Robert   588126 588126 Walsyngham, Robert, of North Walsham, wool chapman 1
3704148 1927593 1927593 defendant Walsyngham Robert   588126 588126 Walsyngham, Robert, of North Walsham, paten maker 0
3704150 1927594 1927594 defendant Walsyngham Robert   588126 588126 Walsyngham, Robert, of North Walsham, paten maker 0
3706575 1928341 1928341 defendant Vewter John   588126 588126 Vewter, John, of North Walsham, worsted weaver 2
3709617 1929316 1929316 defendant Vewter John   588126 588126 Vewter, John, of North Walsham, worsted weaver 0
3709619 1929317 1929317 defendant Vewter John   588126 588126 Vewter, John, of North Walsham, worsted weaver 0
3709626 1929318 1929318 defendant Vewter John   588126 588126 Vewter, John, of North Walsham, worsted weaver 0
3709627 1929318 1929318 defendant Woderove John cooper 588126 588126 Woderove, John, of North Walsham, cooper 1
3709628 1929318 1929318 defendant Toppes Thomas baker 588126 588126 Toppes, Thomas, of North Walsham, baker 2
3709630 1929319 1929319 defendant Woderove John cooper 588126 588126 Woderove, John, of North Walsham, cooper 0
3713427 1930514 1930514 defendant Reler Thomas husbandman 588126 588126 Reler, Thomas, of North Walsham, husbandman 0
3716724 1931522 1931522 defendant Walsyngham Robert   588126 588126 Walsyngham, Robert, of North Walsham, wool chapman 1
3718772 1932150 1932150 plaintiff Gewter John   588126 588126 Gewter, John, of North Walsham, worsted weaver 0
3724225 1933863 1933863 defendant Vewteur John   588126 588126 Vewteur, John, of North Walsham, worsted weaver 0
3724722 1934018 1934018 defendant Norwyche John smith 588126 588126 Norwyche, John, of North Walsham, smith 0
3724725 1934018 1934018 defendant Beeston James tailor 588126 588126 Beeston, James, of North Walsham, tailor 3
3727120 1934752 1934752 plaintiff Vewter John   588126 588126 Vewter, John, of North Walsham 0
3727122 1934753 1934753 plaintiff Vewter John   588126 588126 Vewter, John, of North Walsham 0
3735108 1937222 1937222 defendant Lowys Thomas raffman 588126 588126 Lowys, Thomas, of North Walsham, raffman 0
3735421 1937316 1937316 defendant Fayre James husbandman 588126 588126 Fayre, James, of North Walsham, husbandman 2
3740622 1938928 1938928 defendant Beeston John tailor 588126 588126 Beeston, John, of North Walsham, tailor 0
3740696 1938952 1938952 defendant Mundys John husbandman 588126 588126 Mundys, John, of North Walsham, husbandman 1
3740697 1938952 1938952 defendant Sawtre William husbandman 588126 588126 Sawtre, William, of North Walsham, husbandman 2
3742770 1939596 1939596 defendant Walsyngham Robert husbandman 588126 588126 Walsyngham, Robert, of North Walsham, husbandman 0
3747574 1941157 1941157 defendant Skerburgh John tailor 588126 588126 Skerburgh, John, of North Walsham, tailor 4
3747575 1941157 1941157 defendant Hagon William butcher 588126 588126 Hagon, William, of North Walsham, butcher 5
3756242 1943912 1943912 defendant Cubytt Robert   588126 588126 Cubytt, Robert, of North Walsham, worsted weaver 0
3756906 1944136 1944136 defendant Bartylmewes John husbandman 588126 588126 Bartylmewes, John, of North Walsham, husbandman 0
3761448 1945593 1945593 defendant Skerburgh John tailor 588126 588126 Skerburgh, John, of North Walsham, tailor 3
3761449 1945593 1945593 defendant Hagon William butcher 588126 588126 Hagon, William, of North Walsham, butcher 4
3766179 1947075 1947075 defendant Pawlyng Robert tailor 588126 588126 Pawlyng, Robert, of North Walsham, tailor 0
3769838 1948222 1948222 defendant Clubbe Nicholas husbandman 588126 588126 Clubbe, Nicholas, of North Walsham, husbandman 1
3769841 1948223 1948223 defendant Bakon Henry husbandman 588126 588126 Bakon, Henry, of North Walsham, husbandman 1
3771836 1948882 1948882 defendant Walsyngham Robert husbandman 588126 588126 Walsyngham, Robert, of North Walsham, husbandman 1
3772453 1949073 1949073 defendant Walsyngham Robert husbandman 588126 588126 Walsyngham, Robert, of North Walsham, husbandman 0
3778474 1950983 1950983 defendant Myllyngton Robert gent 588126 588126 Myllyngton, Robert, of North Walsham, gent 0
3778953 1951137 1951137 defendant Walsyngham Robert woolman 588126 588126 Walsyngham, Robert, of North Walsham, woolman 0
3779750 1951401 1951401 defendant Walsyngham Robert husbandman 588126 588126 Walsyngham, Robert, of North Walsham, husbandman 0
3780879 1951754 1951754 defendant Anyson Richard   588126 588126 Anyson, Richard, of North Walsham, rough mason 0
3780950 1951776 1951776 defendant Norwiche John smith 588126 588126 Norwiche, John, of North Walsham, smith 4
3786473 1953561 1953561 defendant Sadler John husbandman 588126 588126 Sadler, John, of North Walsham, husbandman 1
3787144 1953770 1953770 defendant Vewter John   588126 588126 Vewter, John, of North Walsham, worsted weaver 0
3791022 1955027 1955027 defendant Rolff Henry yeoman 588126 588126 Rolff, Henry, of North Walsham, yeoman 0
3792339 1955465 1955465 defendant Walsyngham Robert   588126 588126 Walsyngham, Robert, of North Walsham, wool merchant 0
3803509 1959003 1959003 defendant Walsyngham Robert woolman 588126 588126 Walsyngham, Robert, of North Walsham, woolman 2
3803513 1959004 1959004 defendant Hagon William butcher 588126 588126 Hagon, William, of North Walsham, butcher 0
3804502 1959348 1959348 defendant Walsyngham Robert woolman 588126 588126 Walsyngham, Robert, of North Walsham, woolman 0
3804619 1959385 1959385 defendant Rolff Henry yeoman 588126 588126 Rolff, Henry, of North Walsham, yeoman 0
3805532 1959671 1959671 defendant Walsyngham Robert   588126 588126 Walsyngham, Robert, of North Walsham, paten maker 0
3820891 1964428 1964428 defendant Walsyngham Robert woolman 588126 588126 Walsyngham, Robert, of North Walsham, woolman 0
3820898 1964431 1964431 defendant Hagon William butcher 588126 588126 Hagon, William, of North Walsham, butcher 0
3821310 1964556 1964556 defendant Bakon Henry husbandman 588126 588126 Bakon, Henry, of North Walsham, husbandman 0
3821312 1964557 1964557 defendant Clubbe Nicholas husbandman 588126 588126 Clubbe, Nicholas, of North Walsham, husbandman 0
3825838 1965929 1965929 defendant Lubbok Thomas shoemaker 588126 588126 Lubbok, Thomas, of North Walsham, shoemaker 0
3826560 1966153 1966153 defendant Dorant John husbandman 588126 588126 Dorant, John, of North Walsham, husbandman 3
3829396 1967082 1967082 defendant Jowler William husbandman 588126 588126 Jowler, William, of North Walsham, husbandman 3
3829484 1967108 1967108 defendant Barker Edward mercer 588126 588126 Barker, Edward, of North Walsham, mercer 0
3832443 1968066 1968066 defendant Kebyt Andrew fishmonger 588126 588126 Kebyt, Andrew, of North Walsham, fishmonger 0
3833894 1968538 1968538 defendant Holse Geoffrey laborer 588126 588126 Holse, Geoffrey, of North Walsham, laborer 0
3834871 1968847 1968847 defendant Williams John yeoman 588126 588126 Williams, John, of North Walsham, yeoman 1
3835388 1969006 1969006 defendant Fewtrer John   588126 588126 Fewtrer, John, of North Walsham, worsted weaver 0
3835389 1969006 1969006 defendant Tubbyng Nicholas mercer 588126 588126 Tubbyng, Nicholas, of North Walsham, mercer 1
3835390 1969006 1969006 defendant Smyth John shoemaker 588126 588126 Smyth, John, of North Walsham, shoemaker 2
3837945 1969781 1969781 defendant Baxter Thomas husbandman 588126 588126 Baxter, Thomas, of North Walsham, husbandman 0
3837946 1969781 1969781 defendant Hardys Thomas laborer 588126 588126 Hardys, Thomas, of North Walsham, laborer 1
3837947 1969781 1969781 defendant Broun John thatcher 588126 588126 Broun, John, of North Walsham, thatcher 2
3837948 1969781 1969781 defendant Pallyng Robert husbandman 588126 588126 Pallyng, Robert, of of North Walsham, husbandman 3
3838528 1969974 1969974 defendant Norwyche John smith 588126 588126 Norwyche, John, of North Walsham, smith 0
3839550 1970293 1970293 defendant Fewterer John   588126 588126 Fewterer, John, of North Walsham, worsted weaver 4
3840919 1970727 1970727 defendant Walsyngham Robert   588126 588126 Walsyngham, Robert, of North Walsham, wool merchant 0
3841153 1970810 1970810 defendant Wryght Thomas laborer 588126 588126 Wryght, Thomas, of North Walsham, laborer 0
3843402 1971471 1971471 defendant Sywarde Thomas tailor 588126 588126 Sywarde, Thomas, of North Walsham, tailor 0
3844552 1971835 1971835 defendant Barker Edward mercer 588126 588126 Barker, Edward, of North Walsham, mercer 0
3845198 1972061 1972061 plaintiff Empson John (legal representative) 588126 588126 Empson, John, of North Walsham, executors of 0
3845201 1972061 1972061 defendant Rede Richard   588126 588126 Rede, Richard, of North Walsham, mason 0
3845202 1972061 1972061 defendant Gilberd John   588126 588126 Gilberd, John, of North Walsham, mason 1
3845203 1972061 1972061 defendant Clerke Thomas   588126 588126 Clerke, Thomas, of North Walsham, worsted weaver 2
3845209 1972063 1972063 defendant Kebyte Andrew pedder 588126 588126 Kebyte, Andrew, of North Walsham, pedder 2
3847562 1972805 1972805 defendant Walsyngham Robert   588126 588126 Walsyngham, Robert, of North Walsham, paten maker 0
3847563 1972805 1972805 defendant Baly William smith 588126 588126 Baly, William, of North Walsham, smith 1
3848428 1973085 1973085 defendant Kent John fishmonger 588126 588126 Kent, John, of North Walsham, fishmonger 1
3848853 1973233 1973233 defendant Banyard John shoemaker 588126 588126 Banyard, John, of North Walsham, shoemaker 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);