names

13,702 rows where place_id = 585936

✎ 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
3587531 1863748 1863748 defendant Colforth William yeoman 585936 585936 Colforth, William, of Norwich, yeoman 2
3587752 1863815 1863815 plaintiff at Assh Alexander   585936 585936 at Assh, Alexander, of Norwich 0
3587763 1863820 1863820 plaintiff att Assh Alexander   585936 585936 att Assh, Alexander, of Norwich 0
3587765 1863821 1863821 plaintiff att Assh Alexander   585936 585936 att Assh, Alexander, of Norwich 0
3588001 1863900 1863900 defendant Oldman John, junior   585936 585936 Oldman, John, junior, of Norwich, lime burner 0
3588003 1863901 1863901 defendant Oldman John, junior   585936 585936 Oldman, John, junior, of Norwich, lime burner 0
3588409 1864023 1864023 defendant Hemmyng Robert dyer 585936 585936 Hemmyng, Robert, of Norwich, dyer 0
3588410 1864023 1864023 defendant Amy John dyer 585936 585936 Amy, John, of Norwich, dyer 1
3588523 1864055 1864055 plaintiff Best Robert grocer 585936 585936 Best, Robert, of Norwich, grocer 0
3588527 1864056 1864056 plaintiff Best Robert grocer 585936 585936 Best, Robert, of Norwich, grocer 0
3588581 1864073 1864073 plaintiff Birde William engraver 585936 585936 Birde, William, of Norwich, engraver 0
3588618 1864084 1864084 defendant Chapman William laborer 585936 585936 Chapman, William, of Norwich, laborer 2
3588620 1864085 1864085 plaintiff Blomvyle John   585936 585936 Blomvyle, John, of Norwich, notary 0
3588627 1864086 1864086 plaintiff Blomvyle John   585936 585936 Blomvyle, John, of Norwich, notary 0
3588629 1864087 1864087 plaintiff Blomvyle John   585936 585936 Blomvyle, John, of Norwich, notary 0
3588632 1864088 1864088 plaintiff Blomvyll John   585936 585936 Blomvyll, John, of Norwich, notary 0
3588753 1864126 1864126 defendant Caly Richard fuller 585936 585936 Caly, Richard, of Norwich, fuller 0
3588754 1864126 1864126 defendant Ferrour Stephen dyer 585936 585936 Ferrour, Stephen, of Norwich, dyer 1
3588755 1864126 1864126 defendant Whytefare Edmund baker 585936 585936 Whytefare, Edmund, of Norwich, baker 2
3588757 1864127 1864127 defendant Caly Richard fuller 585936 585936 Caly, Richard, of Norwich, fuller 0
3588758 1864127 1864127 defendant Whytefar Edmund baker 585936 585936 Whytefar, Edmund, of Norwich, baker 1
3589421 1864330 1864330 defendant Slyford Thomas gent 585936 585936 Slyford, Thomas, of Norwich, gent 0
3589895 1864481 1864481 plaintiff Chittok John (legal representative) 585936 585936 Chittok, John, of Norwich, alderman, administrator of 0
3589898 1864481 1864481 defendant Abbotes Thomas yeoman 585936 585936 Abbotes, Thomas, of Norwich, yeoman 1
3589900 1864481 1864481 defendant Ampulford John brewer 585936 585936 (Ampulford, John, of Norwich, brewer 3
3589946 1864495 1864495 defendant Parker Nicholas gent 585936 585936 Parker, Nicholas, of Norwich, gent 0
3590202 1864577 1864577 plaintiff Welles John alderman 585936 585936 Welles, John, of Norwich, alderman 1
3590735 1864743 1864743 plaintiff Curson Philip alderman 585936 585936 Curson, Philip, of Norwich, alderman 0
3590738 1864743 1864743 defendant Cooke Robert draper 585936 585936 Cooke, Robert, of Norwich, draper 2
3590784 1864756 1864756 defendant Yemys Robert clerk 585936 585936 Yemys, Robert, of Norwich, clerk 2
3591008 1864813 1864813 plaintiff Davy Edmund vintner 585936 585936 Davy, Edmund, of Norwich, vintner 0
3591009 1864813 1864813 defendant Beamond Christopher vintner 585936 585936 Beamond, Christopher, of Norwich, vintner 0
3591010 1864814 1864814 plaintiff Davy Edmund vintner 585936 585936 Davy, Edmund, of Norwich, vintner 0
3591210 1864875 1864875 defendant Thakker Robert butcher 585936 585936 Thakker, Robert, of Norwich, butcher 0
3591446 1864951 1864951 defendant Verdon William laborer 585936 585936 Verdon, William, of Norwich, laborer 2
3591472 1864958 1864958 plaintiff Ebbys John mercer 585936 585936 Ebbys, John, of Norwich, mercer 0
3591890 1865077 1865077 plaintiff Ferrour Richard alderman 585936 585936 Ferrour, Richard, of Norwich, alderman 0
3591893 1865078 1865078 plaintiff Ferrour Richard alderman 585936 585936 Ferrour, Richard, of Norwich, alderman 0
3591898 1865080 1865080 plaintiff Ferrour William dyer 585936 585936 Ferrour, William, of Norwich, dyer 0
3591901 1865081 1865081 plaintiff Ferrour William scrivener 585936 585936 Ferrour, William, of Norwich, scrivener 0
3591903 1865081 1865081 defendant Dewe John laborer 585936 585936 Dewe, John, of Norwich, laborer 1
3591904 1865081 1865081 defendant Caly Simon   585936 585936 Caly, Simon, of Norwich, coverlet weaver 2
3591906 1865081 1865081 defendant Blake Agnes widow 585936 585936 Blake, Agnes, of Norwich, widow 4
3591971 1865102 1865102 defendant Machon Robert embroiderer 585936 585936 Machon, Robert, of Norwich, embroiderer 0
3592135 1865158 1865158 plaintiff Fraunceys John mercer 585936 585936 Fraunceys, John, of Norwich, mercer 0
3592138 1865159 1865159 plaintiff Fraunceys John mercer 585936 585936 Fraunceys, John, of Norwich, mercer 0
3592140 1865160 1865160 plaintiff Fraunceys John mercer 585936 585936 Fraunceys, John, of Norwich, mercer 0
3592146 1865163 1865163 plaintiff Fraunceys Thomas mercer 585936 585936 Fraunceys, Thomas, of Norwich, mercer 0
3592261 1865194 1865194 defendant Brown John, junior butcher 585936 585936 Brown, John, junior, of Norwich, butcher 0
3592262 1865194 1865194 defendant Brown Robert butcher 585936 585936 Brown, Robert, of Norwich, butcher 1
3592418 1865245 1865245 plaintiff Geffrey Elizabeth (legal representative) 585936 585936 Geffrey, Elizabeth, of Norwich, widow, executrix of Geffrey, Walter, of Norwich, alderman, executors of 0
3592425 1865246 1865246 plaintiff Geffrey Elizabeth (legal representative) 585936 585936 Geffrey, Elizabeth, of Norwich, widow, executrix of Geffrey, Walter, of Norwich, alderman, executors of 0
3592458 1865256 1865256 defendant Fyssher Robert butcher 585936 585936 Fyssher, Robert, of Norwich, butcher 0
3592459 1865256 1865256 defendant Rysyng Richard butcher 585936 585936 Rysyng, Richard, of Norwich, butcher 1
3592929 1865408 1865408 plaintiff Gybson William tailor 585936 585936 Gybson, William, of Norwich, tailor 0
3592931 1865409 1865409 plaintiff Gybson William tailor 585936 585936 Gybson, William, of Norwich, tailor 0
3593316 1865541 1865541 plaintiff Hayne John beer brewer 585936 585936 Hayne, John, of Norwich, beer brewer 0
3593319 1865542 1865542 plaintiff Hayne John beer brewer 585936 585936 Hayne, John, of Norwich, beer brewer 0
3593322 1865543 1865543 plaintiff Hayne John beer brewer 585936 585936 Hayne, John, of Norwich, beer brewer 0
3593324 1865544 1865544 plaintiff Hayne John beer brewer 585936 585936 Hayne, John, of Norwich, beer brewer 0
3593326 1865545 1865545 plaintiff Hayne John beer brewer 585936 585936 Hayne, John, of Norwich, beer brewer 0
3593816 1865706 1865706 defendant Salter Robert butcher 585936 585936 Salter, Robert, of Norwich, butcher 2
3594098 1865795 1865795 defendant Smert Thomas cordwainer 585936 585936 Smert, Thomas, of Norwich, cordwainer 1
3594140 1865811 1865811 plaintiff Jermy John, senior (legal representative) 585936 585936 Jermy, John, senior, of Norwich, esq, executors of 0
3594204 1865829 1865829 plaintiff Jowell John   585936 585936 Jowell, John, of Norwich 0
3594213 1865831 1865831 defendant Marham William   585936 585936 Marham, William, of Norwich, mason 2
3594378 1865874 1865874 defendant Broun John, junior bucther 585936 585936 Broun, John, junior, of Norwich, bucther 0
3594810 1866006 1866006 plaintiff Lenot ot Levot John   585936 585936 Lenot ot Levot, John, of Norwich 0
3594873 1866026 1866026 defendant Cullyng John yeoman 585936 585936 Cullyng, John, of Norwich, yeoman 2
3594937 1866045 1866045 plaintiff London William alderman 585936 585936 London, William, of Norwich, alderman 0
3595132 1866109 1866109 plaintiff Hoo Robert   585936 585936 Hoo, Robert, of Norwich 1
3595804 1866322 1866322 defendant Noble Nicholas fishmonger 585936 585936 Noble, Nicholas, of Norwich, fishmonger 0
3596038 1866388 1866388 defendant Fyssher John yeoman 585936 585936 Fyssher, John, of Norwich, yeoman 3
3596168 1866432 1866432 plaintiff Osbern Robert baker 585936 585936 Osbern, Robert, of Norwich, baker 0
3596170 1866433 1866433 plaintiff Osbern Robert baker 585936 585936 Osbern, Robert, of Norwich, baker 0
3596173 1866434 1866434 plaintiff Osbern Robert baker 585936 585936 Osbern, Robert, of Norwich, baker 0
3596508 1866541 1866541 plaintiff Peterson John merchant 585936 585936 Peterson, John, of Norwich, merchant 0
3596936 1866674 1866674 defendant Shorde Thomas tailor 585936 585936 Shorde, Thomas, of Norwich, tailor 0
3596937 1866674 1866674 defendant Baldwyn Thomas cooper 585936 585936 Baldwyn, Thomas, of Norwich, cooper 1
3597277 1866768 1866768 plaintiff Rightwys John mercer 585936 585936 Rightwys, John, of Norwich, mercer 0
3597279 1866769 1866769 plaintiff Rightwys John mercer 585936 585936 Rightwys, John, of Norwich, mercer 0
3597414 1866812 1866812 defendant Bemond Christopher vintner 585936 585936 Bemond, Christopher, of Norwich, vintner 0
3597753 1866917 1866917 defendant Cayster Thomas laborer 585936 585936 Cayster, Thomas, of Norwich, laborer 0
3597836 1866941 1866941 defendant Wyld John husbandman 585936 585936 Wyld, John, of Norwich, husbandman 0
3597903 1866965 1866965 defendant Cullyng Edmund yeoman 585936 585936 Cullyng, Edmund, of Norwich, yeoman 2
3598156 1867052 1867052 defendant Oby or Ovy Nicholas pedder 585936 585936 Oby or Ovy, Nicholas, of Norwich, pedder 0
3598377 1867122 1867122 defendant Malburgh John esq 585936 585936 Malburgh, John, of Norwich, esq 0
3598393 1867128 1867128 plaintiff Spencer John (legal representative) 585936 585936 Spencer, John, of Norwich, draper, executors of 0
3598418 1867134 1867134 plaintiff Spenser John (legal representative) 585936 585936 Spenser, John, of Norwich, executors of 0
3598420 1867134 1867134 plaintiff Spenser Leonard scrivener 585936 585936 Spenser, Leonard, of Norwich, scrivener 2
3598422 1867135 1867135 plaintiff Sperlyng Geoffrey court holder 585936 585936 Sperlyng Geoffrey, of Norwich, court holder 0
3599623 1867521 1867521 defendant Bemond Christopher vintner 585936 585936 Bemond, Christopher, of Norwich, vintner 0
3599770 1867571 1867571 defendant Belward William raffman 585936 585936 Belward, William, of Norwich, raffman 1
3600054 1867670 1867670 defendant Tabard Simon (legal representative) 585936 585936 Tabard, Simon, of Norwich, carpenter, executor of 0
3600389 1867767 1867767 defendant Lone or Love Edmund draper 585936 585936 Lone or Love, Edmund, of Norwich, draper 0
3600395 1867768 1867768 defendant Lone or Love Edmund draper 585936 585936 Lone or Love, Edmund, of Norwich, draper 0
3600537 1867815 1867815 defendant Kerby Roger yeoman 585936 585936 Kerby, Roger, of Norwich, yeoman 0
3600538 1867815 1867815 defendant Rede John   585936 585936 Rede, John, of Norwich, yeoman, warden of Norwich castle 1
3600541 1867816 1867816 defendant Broun John, senior butcher 585936 585936 Broun, John, senior, of Norwich, butcher 0
3600575 1867826 1867826 defendant Lesyngham Adam husbandman 585936 585936 Lesyngham, Adam, of Norwich, 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);