names

314 rows where place_id = 590484

✎ 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
3601360 1868090 1868090 defendant Dounham Edmund yeoman 590484 590484 Dounham, Edmund, of Watton, yeoman 0
3601361 1868090 1868090 defendant Dounham Richard yeoman 590484 590484 Dounham, Richard, of Watton, yeoman 1
3601362 1868090 1868090 defendant Dounham William yeoman 590484 590484 Dounham, William, of Watton, yeoman 2
3606914 1869826 1869826 defendant Lysse Thomas yeoman 590484 590484 Lysse, Thomas, of Watton, yeoman 0
3618021 1873256 1873256 defendant Unketyll John husbandman 590484 590484 Unketyll, John, of Watton, husbandman 1
3631863 1904774 1904774 defendant Warant John husbandman 590484 590484 Warant, John, of Watton, husbandman 4
3669837 1916511 1916511 plaintiff Bordyope John (legal representative) 590484 590484 Bordyope, John, of Watton, executor of 0
3669840 1916511 1916511 defendant Eybroke Margaret widow 590484 590484 Eybroke, Margaret, of Watton, widow 1
3670529 1916746 1916746 plaintiff Burdyope John (legal representative) 590484 590484 Burdyope, John, of Watton, executor of 0
3670532 1916746 1916746 defendant Eybroke Margaret widow 590484 590484 Eybroke, Margaret, of Watton, widow 1
3686149 1921830 1921830 plaintiff Borough John   590484 590484 Borough, John, of Watton 0
3686151 1921830 1921830 defendant Dunham William husbandman 590484 590484 Dunham, William, of Watton, husbandman 1
3701587 1926745 1926745 plaintiff Broun Cuthbert   590484 590484 Broun, Cuthbert, of Watton 0
3701877 1926841 1926841 plaintiff Burugh John   590484 590484 Burugh, John, of Watton 0
3701878 1926841 1926841 defendant Donham Edmund (legal representative) 590484 590484 Donham, Edmund, of Watton, executor of 0
3701879 1926841 1926841 defendant Donham William husbandman 590484 590484 Donham, William, of Watton, husbandman 1
3709612 1929315 1929315 defendant Magges or Magget Roger husbandman 590484 590484 Magges or Magget, Roger, of Watton, husbandman 0
3709620 1929317 1929317 defendant Magges Richard husbandman 590484 590484 Magges, Richard, of Watton, husbandman 1
3712118 1930107 1930107 defendant Halom John husbandman 590484 590484 Halom, John, of Watton, husbandman 2
3712624 1930265 1930265 defendant Peryns William husbandman 590484 590484 Peryns, William, of Watton, husbandman 0
3712625 1930265 1930265 defendant Peryns James laborer 590484 590484 Peryns, James, of Watton, laborer 1
3716907 1931574 1931574 defendant Markaunt George yeoman 590484 590484 Markaunt, George, of Watton, yeoman 0
3723315 1933563 1933563 defendant Sherewyn John butcher 590484 590484 Sherewyn, John, of Watton, butcher 1
3734038 1936894 1936894 defendant Broun William husbandman 590484 590484 Broun, William, of Watton, husbandman 0
3736827 1937771 1937771 defendant Ap Howell John carpenter 590484 590484 Ap Howell, John, of Watton, carpenter 0
3739356 1938515 1938515 defendant Naggys Thomas mercer 590484 590484 Naggys, Thomas, of Watton, mercer 0
3748632 1941503 1941503 defendant Bothomsell Stephen mercer 590484 590484 Bothomsell, Stephen, of Watton, mercer 0
3758608 1944688 1944688 defendant Tyler Richard pewterer 590484 590484 Tyler, Richard, of Watton, pewterer 2
3761865 1945719 1945719 defendant Broun William husbandman 590484 590484 Broun, William, of Watton, husbandman 0
3763093 1946088 1946088 defendant Bothomsell Stephen mercer 590484 590484 Bothomsell, Stephen, of Watton, mercer 0
3769963 1948262 1948262 defendant Bothomsell Stephen   590484 590484 Bothomsell, Stephen, of Watton 1
3772617 1949128 1949128 defendant Markaunt George yeoman 590484 590484 Markaunt, George, of Watton, yeoman 0
3772618 1949128 1949128 defendant Fekkett William yeoman 590484 590484 Fekkett, William, of Watton, yeoman 1
3780034 1951480 1951480 defendant Broun William husbandman 590484 590484 Broun, William, of Watton, husbandman 0
3787418 1953858 1953858 defendant Botomshale Stephen mercer 590484 590484 Botomshale, Stephen, of Watton, mercer 3
3789263 1954459 1954459 defendant Fykett William yeoman 590484 590484 Fykett, William, of Watton, yeoman 0
3789527 1954550 1954550 defendant Cokke William tailor 590484 590484 Cokke, William, of Watton, tailor 0
3794260 1956076 1956076 defendant Markant George yeoman 590484 590484 Markant, George, of Watton, yeoman 0
3796491 1956773 1956773 defendant Harvy William husbandman 590484 590484 Harvy, William, of Watton, husbandman 4
3799252 1957679 1957679 plaintiff Hyncke John (legal representative) 590484 590484 Hyncke, John, of watton, executor of 0
3811814 1961596 1961596 defendant Bocher Thomas butcher 590484 590484 Bocher, Thomas, of Watton, butcher 1
3827705 1966529 1966529 defendant Markaunt George husbandman 590484 590484 Markaunt, George, of Watton, husbandman 2
3827788 1966558 1966558 defendant Bowgeon Thomas husbandman 590484 590484 Bowgeon, Thomas, of Watton, husbandman 1
3830923 1967556 1967556 defendant Markaunte George yeoman 590484 590484 Markaunte, George, of Watton, yeoman 0
3836576 1969343 1969343 defendant Bothamsaylle Stephen mercer 590484 590484 Bothamsaylle, Stephen, of Watton, mercer 0
3839604 1970310 1970310 defendant Botomsall Stephen mercer 590484 590484 Botomsall, Stephen, of Watton, mercer 0
3841947 1971047 1971047 defendant Grey Thomas husbandman 590484 590484 Grey, Thomas, of Watton, husbandman 0
3851580 1974081 1974081 defendant Bothomsale Stephen mercer 590484 590484 Bothomsale, Stephen, of Watton, mercer 1
3857004 1975823 1975823 defendant Fedymont Robert carpenter 590484 590484 Fedymont, Robert, of Watton, carpenter 0
3861793 1977410 1977410 defendant Sponer John smith 590484 590484 Sponer, John, of Watton, smith 1
3861800 1977411 1977411 defendant Brown William husbandman 590484 590484 Brown, William, of Watton, husbandman 2
3862072 1977502 1977502 defendant Botomsall Stephen mercer 590484 590484 Botomsall, Stephen, of Watton, mercer 1
3862075 1977503 1977503 defendant Botomsall Stephen mercer 590484 590484 Botomsall, Stephen, of Watton, mercer 1
3864068 1978166 1978166 defendant Hert Richard yeoman 590484 590484 Hert, Richard, of Watton, yeoman 2
3864069 1978166 1978166 defendant Fedymounde Robert carpenter 590484 590484 Fedymounde, Robert, of Watton, carpenter 3
3864070 1978166 1978166 defendant Brown William husbandman 590484 590484 Brown, William, of Watton, husbandman 4
3866275 1978949 1978949 defendant Markaunt George yeoman 590484 590484 Markaunt, George, of Watton, yeoman 0
3870309 1980321 1980321 defendant Markam George yeoman 590484 590484 Markam, George, of Watton, yeoman 0
3870310 1980321 1980321 defendant Fyket William husbandman 590484 590484 Fyket, William, of Watton, husbandman 1
3873944 1981506 1981506 defendant Coke John weaver 590484 590484 Coke, John, of Watton, weaver 0
3885765 1985492 1985492 defendant Browne William husbandman 590484 590484 Browne, William, of Watton, husbandman 2
3889371 1986677 1986677 plaintiff Godfrye Robert weaver 590484 590484 Godfrye, Robert, of Watton, weaver 0
3889531 1986730 1986730 defendant Coper Robert butcher 590484 590484 Coper, Robert, of Watton, butcher 0
3898073 1989566 1989566 defendant Cowper Robert butcher 590484 590484 Cowper, Robert, of Watton, butcher 0
3899556 1990067 1990067 defendant Brown William husbandman 590484 590484 Brown, William, of Watton, husbandman 0
3901372 1990680 1990680 defendant Kyryson Robert husbandman 590484 590484 Kyryson, Robert, of Watton, husbandman 1
3905351 1992057 1992057 defendant Worseley William husbandman 590484 590484 Worseley, William, of Watton, husbandman 1
3906630 1992510 1992510 defendant Wylson John chapman 590484 590484 Wylson, John, of Watton, chapman 2
3918288 1996452 1996452 defendant Bowgen George husbandman 590484 590484 Bowgen, George, of Watton, husbandman 0
3923779 1998257 1998257 defendant Bottomsall Stephen mercer 590484 590484 Bottomsall, Stephen, of Watton, mercer 2
3929834 2000318 2000318 defendant Foxe John clerk of the parish church 590484 590484 Foxe, John, of Watton, clerk of the parish church 0
3935308 2002122 2002122 defendant Weston Robert yeoman 590484 590484 Weston, Robert, of Watton, yeoman 0
3944888 2005307 2005307 defendant Powle Leonard shoemaker 590484 590484 Powle, Leonard, of Watton, shoemaker 0
3957311 2009619 2009619 defendant Dancke John yeoman 590484 590484 Dancke, John, of Watton, yeoman 3
3965424 2012519 2012519 defendant Mayce Thomas chapman 590484 590484 Mayce, Thomas, of Watton, chapman 1
3975392 2015959 2015959 plaintiff Howse Thomas   590484 590484 Howse, Thomas, of Watton 0
3981675 2018203 2018203 defendant Clarke Thomas tailor 590484 590484 Clarke, Thomas, of Watton, or of Wackton All Saints, tailor 0
4045383 2040803 2040803 defendant Wade Alexander husbandman 590484 590484 Wade, Alexander, of Watton, husbandman 0
4049325 2042205 2042205 plaintiff Turner Henry   590484 590484 Turner, Henry, of Watton 0
4049327 2042206 2042206 plaintiff Turner Henry   590484 590484 Turner, Henry, of Watton 0
4054860 2044131 2044131 defendant Smyth Thomas yeoman 590484 590484 Smyth, Thomas, of Watton, yeoman 0
4055428 2044335 2044335 defendant Bongeon or Bougeon Thomas husbandman 590484 590484 Bongeon or Bougeon, Thomas, of Watton, husbandman 3
4060650 2046211 2046211 defendant House James   590484 590484 House, James, of Watton, tailor, singleman, son of Thomas 1
4060660 2046215 2046215 defendant House Thomas tailor 590484 590484 House, Thomas, of Watton, draper, tailor 0
4067382 2048639 2048639 defendant House Thomas tailor 590484 590484 House, Thomas, of Watton, tailor 0
4067383 2048639 2048639 defendant Fyckett Henry innholder 590484 590484 Fyckett, Henry, of Watton, innholder 1
4067384 2048639 2048639 defendant House James tailor 590484 590484 House, James, of Watton, tailor 2
4072395 2050431 2050431 defendant Hanserd James innkeeper 590484 590484 Hanserd, James, of Watton, innkeeper 0
4072396 2050431 2050431 defendant Roberdson Gilbert sherman 590484 590484 Roberdson, Gilbert, of Watton, sherman 1
4072397 2050431 2050431 defendant Payne Henry haberdasher 590484 590484 Payne, Henry, of Watton, haberdasher 2
4072400 2050432 2050432 defendant Hansard James innkeeper 590484 590484 Hansard, James, of Watton, innkeeper 1
4077433 2052217 2052217 defendant Howse William tailor 590484 590484 Howse, William, of Watton, tailor 0
4077615 2052280 2052280 defendant Kyddell Stephen yeoman 590484 590484 Kyddell, Stephen, of Watton, yeoman 2
4080454 2053320 2053320 defendant Skarle Richard chapman 590484 590484 Skarle, Richard, of Watton, chapman 1
4080455 2053320 2053320 defendant Smyth Thomas chapman 590484 590484 Smyth, Thomas, of Watton, chapman 2
4085533 2055099 2055099 defendant Gallaway William cooper 590484 590484 Gallaway, William, of Watton, cooper 0
4085536 2055099 2055099 defendant Hanserd James yeoman 590484 590484 Hanserd, James, of Watton, yeoman 3
4087025 2055652 2055652 defendant Smyth Thomas mercer 590484 590484 Smyth, Thomas, of Watton, mercer 1
4087516 2055831 2055831 defendant Goslyng John yeoman 590484 590484 Goslyng, John, of Watton, or of Blickling, yeoman 0
4090102 2056745 2056745 defendant Bannam Thomas husbandman 590484 590484 Bannam, Thomas, of Watton, husbandman 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);