names

189 rows where place_id = 598213

✎ 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
3631591 1904694 1904694 defendant Oldman John baker 598213 598213 Oldman, John, of Walsyngham, baker 0
3633428 1905268 1905268 defendant Marley George gent 598213 598213 Marley, George, of Walsyngham, gent 5
3645193 1908906 1908906 defendant Karre Thomas pedder 598213 598213 Karre, Thomas, of Walsyngham, pedder 0
3658655 1912961 1912961 defendant Copynger Richard yeoman 598213 598213 Copynger, Richard, of Walsyngham, yeoman 0
3661702 1913938 1913938 plaintiff (not given) Richard prior of Vowell 598213 598213 (Vowell, Richard, of Walsyngham, prior of the House of the Blessed Mary 1
3662813 1914285 1914285 defendant Burgett Peter husbandman 598213 598213 Burgett, Peter, of Walsyngham, husbandman 2
3664058 1914708 1914708 defendant Copynger Richard yeoman & inn holder 598213 598213 Copynger, Richard, of Walsyngham, yeoman & inn holder 0
3666619 1915502 1915502 plaintiff (not given) Richard prior of Vowell 598213 598213 Vowell, Richard, of Walsyngham, prior of the Priory of the Blessed Mary 0
3677781 1919099 1919099 plaintiff Maltby William   598213 598213 Maltby, William, of Walsyngham 0
3677783 1919100 1919100 plaintiff Maltby William   598213 598213 Maltby, William, of Walsyngham 0
3677785 1919101 1919101 plaintiff Maltby William   598213 598213 Maltby, William, of Walsyngham 0
3677787 1919102 1919102 plaintiff Maltby William   598213 598213 Maltby, William, of Walsyngham 0
3677790 1919103 1919103 plaintiff Maltby William   598213 598213 Maltby, William, of Walsyngham 0
3677877 1919134 1919134 defendant Hert John inholder 598213 598213 Hert, John, of Walsyngham, inholder 0
3678090 1919195 1919195 defendant Hart John innholder 598213 598213 Hart, John, of Walsyngham, innholder 0
3689619 1922914 1922914 defendant Rogerson alias Colyns Christopher innkeeper 598213 598213 Rogerson alias Colyns, Christopher, of Walsyngham, innkeeper 0
3689623 1922915 1922915 defendant Rogerson Christopher innkeeper 598213 598213 Rogerson, Christopher, of Walsyngham, innkeeper 0
3692283 1923756 1923756 defendant Leon John (legal representative) 598213 598213 Leon, John, of Walsyngham, baker, executor of 0
3693668 1924213 1924213 defendant Lyon John (legal representative) 598213 598213 Lyon, John, of Walsyngham, baker, executor of 2
3695960 1924976 1924976 plaintiff Rogerson alias Colyns Christopher   598213 598213 Rogerson alias Colyns, Christopher, of Walsyngham 0
3695962 1924977 1924977 plaintiff Rogerson alias Colyns Christopher   598213 598213 Rogerson alias Colyns, Christopher, of Walsyngham 0
3697534 1925450 1925450 defendant Dry James (legal representative) 598213 598213 Dry, James, of Walsyngham, innholder, executors of 1
3704905 1927827 1927827 defendant Hoker Robert butcher 598213 598213 Hoker, Robert, of Walsyngham, butcher 0
3705000 1927856 1927856 defendant Colyns Christopher innholder 598213 598213 Colyns, Christopher, of Walsyngham, innholder 4
3722268 1933223 1933223 plaintiff Mateshale Thomas, senior   598213 598213 Mateshale, Thomas, senior, of Walsyngham 0
3722288 1933231 1933231 plaintiff Mattsale Thomas, senior   598213 598213 Mattsale, Thomas, senior, of Walsyngham 0
3730753 1935845 1935845 defendant Clyfton John yeoman 598213 598213 Clyfton, John, of Walsyngham, yeoman 0
3742886 1939631 1939631 defendant Grene Richard butcher 598213 598213 Grene, Richard, of Walsyngham, butcher 0
3749735 1941826 1941826 defendant Sheryngham Robert grocer 598213 598213 Sheryngham, Robert, of Walsyngham, grocer 3
3751611 1942419 1942419 plaintiff Oldman John   598213 598213 Oldman, John, of Walsyngham 0
3751612 1942419 1942419 defendant Rogerson alias Colens Christopher innholder 598213 598213 Rogerson alias Colens, Christopher, of Walsyngham, innholder 0
3764815 1946662 1946662 defendant Sheryngham Robert grocer 598213 598213 Sheryngham, Robert, of Walsyngham, grocer 2
3770816 1948563 1948563 defendant Hart John (legal representative) 598213 598213 Hart, John, of Walsyngham, executors of 0
3799733 1957838 1957838 plaintiff Keswyke William   598213 598213 Keswyke, William, of Walsyngham 0
3799735 1957839 1957839 plaintiff Keswyke William   598213 598213 Keswyke, William, of Walsyngham 0
3802132 1958562 1958562 plaintiff Oldman John   598213 598213 Oldman, John, of Walsyngham 0
3812614 1961833 1961833 defendant Curtes Thomas yeoman 598213 598213 Curtes, Thomas, of Walsyngham, yeoman 0
3812685 1961859 1961859 plaintiff Croune Edmund   598213 598213 Croune, Edmund, of Walsyngham 0
3820819 1964402 1964402 defendant Porter James mercer 598213 598213 Porter, James, of Walsyngham, mercer 2
3827412 1966438 1966438 defendant Reynold William draper 598213 598213 Reynold, William, of Walsyngham, draper 2
3840921 1970727 1970727 defendant Manthorp Edmund turner 598213 598213 Manthorp, Edmund, of Walsyngham, turner 2
3846592 1972486 1972486 defendant Oldman John baker 598213 598213 Oldman, John, of Walsyngham, baker 4
3848221 1973011 1973011 defendant Clemens Thomas husbandman 598213 598213 Clemens, Thomas, of Walsyngham, husbandman 1
3854123 1974928 1974928 plaintiff Sydney Thomas gent 598213 598213 Sydney, Thomas, of Walsyngham, gent 0
3882980 1984571 1984571 plaintiff Turner Thomas mercer 598213 598213 Turner, Thomas, of Walsyngham, mercer 0
3882992 1984577 1984577 plaintiff Turnour Thomas mercer 598213 598213 Turnour, Thomas, of Walsyngham, mercer 0
3887699 1986139 1986139 defendant Gott William mercer 598213 598213 Gott, William, of Walsyngham, mercer 1
3889237 1986638 1986638 defendant Butterell John pewterer 598213 598213 Butterell, John, of Walsyngham, pewterer 0
3903359 1991346 1991346 defendant Butterall John pewterer 598213 598213 Butterall, John, of Walsyngham, pewterer 0
3903584 1991427 1991427 defendant Wakefyld Andrew blacksmith 598213 598213 Wakefyld, Andrew, of Walsyngham, blacksmith 0
3908946 1993285 1993285 defendant Purser Alan tailor 598213 598213 Purser, Alan, of Walsyngham, tailor 4
3913752 1994944 1994944 plaintiff Bradde Nicholas mercer 598213 598213 Bradde, Nicholas, of Walsyngham, mercer 0
3918898 1996641 1996641 defendant Deynes John mercer 598213 598213 Deynes, John, of Walsyngham, mercer 3
3922084 1997715 1997715 defendant Ebbys or Ellys Edmund mercer 598213 598213 Ebbys or Ellys, Edmund, of Walsyngham, mercer 3
3923984 1998333 1998333 defendant Chapman William mercer 598213 598213 Chapman, William, of Walsyngham, mercer 1
3948198 2006432 2006432 defendant Foy John yeoman 598213 598213 Foy, John, of Walsyngham, yeoman 0
3956201 2009241 2009241 defendant Balam Robert esq 598213 598213 Balam, Robert, of Walsyngham, esq 0
3958188 2009936 2009936 defendant Crome Robert brewer 598213 598213 Crome, Robert, of Walsyngham, brewer 0
3958894 2010194 2010194 defendant Chapman William chapman 598213 598213 Chapman, William, of Walsyngham, chapman 1
3989004 2020808 2020808 plaintiff Ayde Nicholas   598213 598213 Ayde, Nicholas, of Walsyngham 0
3989007 2020809 2020809 plaintiff Ayde Nicholas yeoman 598213 598213 Ayde, Nicholas, of Walsyngham, yeoman 0
4009561 2028188 2028188 plaintiff Newman Thomas yeoman 598213 598213 Newman, Thomas, of Walsyngham, yeoman 0
4022030 2032608 2032608 defendant Godfrey Robert gent 598213 598213 Godfrey, Robert, of Walsyngham, gent 1
4029119 2035058 2035058 defendant Broune Nicholas yeoman 598213 598213 Broune, Nicholas, of Walsyngham, yeoman 1
4044064 2040329 2040329 plaintiff Pynchebeck Richard yeoman 598213 598213 Pynchebeck, Richard, of Walsyngham, yeoman 0
4048048 2041743 2041743 defendant Mynne Nicholas esq 598213 598213 Mynne, Nicholas, of Walsyngham, esq 0
4243757 2110894 2110894 defendant Browne Nicholas gent 598213 598213 Browne, Nicholas, of Walsyngham, gent 0
4331557 2140851 2140851 defendant Mortymer John   598213 598213 Mortymer, John, of Walsyngham, hat maker 1
4336998 2142668 2142668 defendant Jygges Thomas husbandman 598213 598213 Jygges, Thomas, of Walsyngham, husbandman 0
4424042 2172373 2172373 plaintiff Hilgrave Robert de   598213 598213 Hilgrave, Robert de, of Walsyngham 0
4431827 2174730 2174730 defendant Galoun John   598213 598213 Galoun, John, of Walsyngham 1
4477464 2193616 2193616 defendant Smyth William   598213 598213 Smyth, William, of Walsyngham 0
4509277 2203379 2203379 defendant Bocher John   598213 598213 Bocher, John, of Walsyngham 1
4515432 2205242 2205242 plaintiff Child James master 598213 598213 Child, James, of Walsyngham, master 0
4527214 2208792 2208792 plaintiff Lexham John   598213 598213 Lexham, John, of Walsyngham 0
4527215 2208792 2208792 defendant Sadeler Reginald   598213 598213 Sadeler, Reginald, of Walsyngham 0
4527216 2208792 2208792 defendant Millere John   598213 598213 Millere, John, of Walsyngham 1
4573131 2223130 2223130 defendant Childe James   598213 598213 Childe, James, of Walsyngham, clerk, son of Thomas 3
4573136 2223131 2223131 defendant Childe James   598213 598213 Childe, James, of Walsyngham, clerk, son of Thomas 3
4574279 2223486 2223486 defendant Fullere Geoffrey   598213 598213 Fullere, Geoffrey, of Walsyngham 0
4574280 2223486 2223486 defendant Barbour Walter   598213 598213 Barbour, Walter, of Walsyngham 1
4577592 2224500 2224500 defendant Bonde Thomas   598213 598213 Bonde, Thomas, of Walsyngham 0
4578119 2224659 2224659 plaintiff Childe James clerk 598213 598213 Childe, James, of Walsyngham, clerk 0
4585213 2226798 2226798 defendant Tabernar Thomas   598213 598213 Tabernar, Thomas, of Walsyngham 0
4588955 2227919 2227919 defendant Leenge Stephen   598213 598213 Leenge, Stephen, of Walsyngham 0
4588957 2227920 2227920 defendant Leenge Stephen   598213 598213 Leenge, Stephen, of Walsyngham 0
4601780 2231777 2231777 defendant Lente Thomas   598213 598213 Lente, Thomas, of Walsyngham 1
4607396 2233424 2233424 defendant Barbour Walter   598213 598213 Barbour, Walter, of Walsyngham 0
4627265 2239474 2239474 defendant Fullere Geoffrey   598213 598213 Fullere, Geoffrey, of Walsyngham 1
4627268 2239475 2239475 defendant Fullere Geoffrey   598213 598213 Fullere, Geoffrey, of Walsyngham 1
4630706 2240501 2240501 defendant Robbe Henry   598213 598213 Robbe, Henry, of Walsyngham 13
4637789 2242592 2242592 defendant Barbour William   598213 598213 Barbour, William, of Walsyngham 0
4641204 2243519 2243519 defendant Bulwere Robert   598213 598213 Bulwere, Robert, of Walsyngham 1
4643955 2244332 2244332 defendant Warham Robert   598213 598213 Warham, Robert, of Walsyngham 1
4643956 2244332 2244332 defendant Halle Adam   598213 598213 Halle, Adam, of Walsyngham 2
4648376 2245571 2245571 defendant Rowle Henry   598213 598213 Rowle, Henry, of Walsyngham 15
4649762 2245954 2245954 defendant Blogge Robert   598213 598213 Blogge, Robert, of Walsyngham 1
4649827 2245972 2245972 defendant Kempe John   598213 598213 Kempe, John, of Walsyngham 5
4649842 2245973 2245973 defendant Plowryght E_ butcher 598213 598213 Plowryght, E_, of Walsyngham, butcher 7
4653608 2247058 2247058 defendant Barbour Walter yeoman 598213 598213 Barbour, Walter, of Walsyngham, yeoman 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);