names

489 rows where place_id = 586819

✎ 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
3589730 1864427 1864427 defendant Chambyr Edmund husbandman 586819 586819 Chambyr, Edmund, of Worsted, husbandman 0
3589732 1864427 1864427 defendant Savare or Sanare Simon husbandman 586819 586819 Savare or Sanare, Simon, of Worsted, husbandman 2
3590038 1864524 1864524 defendant Knapton Simon   586819 586819 Knapton, Simon, of Worsted, worsted weaver 1
3596463 1866522 1866522 defendant Bateman William smith 586819 586819 Bateman, William, of Worsted, smith 0
3598842 1867263 1867263 defendant Pynnyng Henry chaplain 586819 586819 Pynnyng, Henry, of Worsted, chaplain 2
3619991 1873823 1873823 defendant Wattys alias Turnour Richard yeoman 586819 586819 Wattys alias Turnour, Richard, of Worsted, yeoman 2
3627610 1903496 1903496 defendant Howchyns Edward weaver 586819 586819 Howchyns, Edward, of Worsted, weaver 0
3628839 1903895 1903895 defendant Phylippes Henry husbandman 586819 586819 Phylippes, Henry, of Worsted, husbandman 0
3630575 1904392 1904392 defendant Penteney John   586819 586819 Penteney, John, of Worsted, shepherd 0
3634842 1905697 1905697 plaintiff Narke Thomas (legal representative) 586819 586819 Narke, Thomas, of Worsted, worsted weaver, executors of 0
3634845 1905697 1905697 defendant Hemmysby Thomas   586819 586819 Hemmysby, Thomas, of Worsted, worsted weaver 0
3634847 1905697 1905697 defendant Dokkyng Thomas   586819 586819 Dokkyng, Thomas, of Worsted, thick woollen weaver 2
3639848 1907277 1907277 defendant Carman Robert mercer 586819 586819 Carman, Robert, of Worsted, mercer 0
3641207 1907700 1907700 defendant Dey Geoffrey husbandman 586819 586819 Dey, Geoffrey, of Worsted, husbandman 3
3646711 1909372 1909372 defendant Horsley William tailor 586819 586819 Horsley, William, of Worsted, tailor 6
3648416 1909905 1909905 plaintiff Nark Adam   586819 586819 Nark, Adam, of Worsted, worsted weaver 0
3648417 1909905 1909905 defendant Smyth John   586819 586819 Smyth, John, of Worsted, worsted weaver 0
3649850 1910316 1910316 defendant Howchyn Edmund   586819 586819 Howchyn, Edmund, of Worsted, worsted weaver 3
3649855 1910317 1910317 defendant Howchyn Edmund   586819 586819 Howchyn, Edmund, of Worsted, worsted weaver 3
3654567 1911690 1911690 defendant Braunche John draper 586819 586819 Braunche, John, of Worsted, draper 0
3654830 1911770 1911770 defendant Kevytt Robert   586819 586819 Kevytt, Robert, of Worsted, worsted weaver 1
3662179 1914087 1914087 defendant Wattys John   586819 586819 Wattys, John, of Worsted, worsted weaver 3
3662821 1914287 1914287 plaintiff Nark Thomas (legal representative) 586819 586819 Nark, Thomas, of Worsted, executors of 0
3662827 1914287 1914287 defendant Dix John   586819 586819 Dix, John, of Worsted, worsted weaver 3
3664139 1914734 1914734 defendant Wattys John   586819 586819 Wattys, John, of Worsted, worsted weaver 1
3664141 1914735 1914735 defendant Wattys William   586819 586819 Wattys, William, of Worsted, worsted weaver 0
3670984 1916899 1916899 plaintiff Carman John (legal representative) 586819 586819 Carman, John, of Worsted, executor of 0
3677223 1918921 1918921 defendant Smyth John   586819 586819 Smyth, John, of Worsted, worsted weaver 0
3691980 1923655 1923655 defendant Wodroff Peter cooper 586819 586819 Wodroff, Peter, of Worsted, cooper 1
3695752 1924901 1924901 defendant Hochyns Edward   586819 586819 Hochyns, Edward, of Worsted, worsted weaver 0
3708356 1928907 1928907 defendant Beteson William   586819 586819 Beteson, William, of Worsted, worsted weaver 2
3709632 1929320 1929320 defendant Howchyns Edward   586819 586819 Howchyns, Edward, of Worsted, worsted weaver 0
3723894 1933752 1933752 defendant Brownyng Edmund husbandman 586819 586819 Brownyng, Edmund, of Worsted, husbandman 3
3724157 1933840 1933840 plaintiff Rante Christopher   586819 586819 Rante, Christopher, of Worsted 0
3732968 1936533 1936533 defendant Brownyng Robert husbandman 586819 586819 Brownyng, Robert, of Worsted, husbandman 2
3732969 1936533 1936533 defendant Palmer John chaplain 586819 586819 Palmer, John, of Worsted, chaplain 3
3740121 1938767 1938767 defendant Newman Robert husbandman 586819 586819 Newman, Robert, of Worsted, husbandman 4
3740176 1938786 1938786 defendant Howchyn Edward   586819 586819 Howchyn, Edward, of Worsted, worsted weaver 2
3740198 1938791 1938791 defendant Newman Richard draper 586819 586819 Newman, Richard, of Worsted, draper 0
3741869 1939321 1939321 defendant Beamond John husbandman 586819 586819 Beamond, John, of Worsted, husbandman 1
3741870 1939321 1939321 defendant Burgeny Edmund fletcher 586819 586819 Burgeny, Edmund, of Worsted, fletcher 2
3744029 1940026 1940026 plaintiff Alblaster John (legal representative) 586819 586819 Alblaster, John, of Worsted, executors of 0
3749044 1941632 1941632 plaintiff Wattys Agnes widow 586819 586819 Wattys, Agnes, of Worsted, widow 1
3749047 1941633 1941633 plaintiff Wattys Agnes widow 586819 586819 Wattys, Agnes, of Worsted, widow 1
3750310 1942013 1942013 plaintiff Leny William   586819 586819 (Leny, William, of Worsted 1
3752454 1942690 1942690 defendant Barne Edward   586819 586819 Barne, Edward, of Worsted, mason 1
3762951 1946044 1946044 defendant Watt Thomas   586819 586819 Watt, Thomas, of Worsted, worsted weaver 2
3763981 1946375 1946375 defendant Clerke William tailor 586819 586819 Clerke, William, of Worsted, tailor 0
3764823 1946665 1946665 defendant Thirkell John smith 586819 586819 Thirkell, John, of Worsted, smith 0
3764827 1946665 1946665 defendant Newman Richard tailor 586819 586819 Newman, Richard, of Worsted, tailor 4
3768286 1947722 1947722 defendant Newman Richard yeoman 586819 586819 Newman, Richard, of Worsted, yeoman 2
3771835 1948882 1948882 defendant Benet John baker 586819 586819 Benet, John, of Worsted, baker 0
3774032 1949594 1949594 plaintiff Alblaster John (legal representative) 586819 586819 Alblaster, John, of Worsted, executor of 0
3780930 1951769 1951769 defendant Lynys William slaymaker 586819 586819 Lynys, William, of Worsted, slaymaker 0
3780932 1951770 1951770 defendant Lynys William slaymaker 586819 586819 Lynys, William, of Worsted, slaymaker 0
3781073 1951815 1951815 defendant Watte Thomas   586819 586819 Watte, Thomas, of Worsted, worsted weaver 0
3782831 1952381 1952381 defendant Thyrkell John smith 586819 586819 Thyrkell, John, of Worsted, smith 0
3782834 1952381 1952381 defendant Newman Ralph tailor 586819 586819 Newman, Ralph, of Worsted, tailor 3
3787416 1953858 1953858 defendant Paston John mercer 586819 586819 Paston, John, of Worsted, mercer 1
3803386 1958960 1958960 defendant Dynne Robert   586819 586819 Dynne, Robert, of Worsted, worsted weaver 0
3803387 1958960 1958960 defendant Howchyns Edward   586819 586819 Howchyns, Edward, of Worsted, worsted weaver 1
3803440 1958978 1958978 defendant Newman Richard tailor 586819 586819 Newman, Richard, of Worsted, tailor 1
3803442 1958979 1958979 defendant Poston or Paston John (legal representative) 586819 586819 Poston or Paston, John, of Worsted, executors of 0
3803443 1958979 1958979 defendant Philipps Robert baker 586819 586819 (Philipps, Robert, of Worsted, baker 1
3804503 1959348 1959348 defendant Doughty William baker 586819 586819 Doughty, William, of Worsted, baker 1
3805826 1959762 1959762 defendant Fyleppes Robert baker 586819 586819 (Fyleppes, Robert, of Worsted, baker 2
3807588 1960278 1960278 defendant Paston Agnes widow 586819 586819 Paston, Agnes, of Worsted, widow 3
3820775 1964388 1964388 defendant Dynne Robert   586819 586819 Dynne, Robert, of Worsted, worsted weaver 0
3820787 1964392 1964392 defendant Howchyns Edward   586819 586819 Howchyns, Edward, of Worsted, worsted weaver 0
3823023 1965109 1965109 defendant Doughty William baker 586819 586819 Doughty, William, of Worsted, baker 0
3823314 1965205 1965205 defendant Thurston Mathew   586819 586819 Thurston, Mathew, of Worsted, worsted weaver 1
3823897 1965345 1965345 defendant Fraunces Robert sherman 586819 586819 Fraunces, Robert, of Worsted, sherman 0
3825003 1965693 1965693 defendant Thurston Mathew   586819 586819 Thurston, Mathew, of Worsted, worsted weaver 2
3827411 1966438 1966438 defendant Newman Richard draper 586819 586819 Newman, Richard, of Worsted, draper 1
3827454 1966454 1966454 defendant Ponyett alias Pownett Thomas rafman 586819 586819 Ponyett alias Pownett, Thomas, of Worsted, rafman 0
3835371 1969001 1969001 defendant Clerke Robert baker 586819 586819 Clerke, Robert, of worsted, baker 1
3835372 1969001 1969001 defendant Bolte Richard   586819 586819 Bolte, Richard, of Worsted, worsted weaver 2
3835373 1969001 1969001 defendant Wynne John smith 586819 586819 Wynne, John, of Worsted, smith 3
3835374 1969001 1969001 defendant Woode William baker 586819 586819 Woode, William, of Worsted, baker 4
3835449 1969026 1969026 defendant Purdy William raffman 586819 586819 Purdy, William, of Worsted, raffman 0
3836043 1969186 1969186 defendant Ponyet Thomas husbandman 586819 586819 Ponyet, Thomas, of Worsted, husbandman 0
3836045 1969186 1969186 defendant Facett Henry husbandman 586819 586819 Facett, Henry, of Worsted, husbandman 2
3838205 1969865 1969865 defendant Phylyppes Robert baker 586819 586819 Phylyppes, Robert, of Worsted, baker 0
3840082 1970470 1970470 defendant Newman Richard draper 586819 586819 Newman, Richard, of Worsted, draper 0
3840083 1970470 1970470 defendant Phillippys Robert baker 586819 586819 Phillippys, Robert, of Worsted, baker 1
3840245 1970517 1970517 defendant Phillipys Robert baker 586819 586819 Phillipys, Robert, of Worsted, baker 0
3840247 1970518 1970518 defendant Newman Richard draper 586819 586819 Newman, Richard, of Worsted, draper 0
3857721 1976051 1976051 defendant Philyps Robert baker 586819 586819 Philyps, Robert, of Worsted, baker 0
3861075 1977187 1977187 defendant Barne Edward husbandman 586819 586819 Barne, Edward, of Worsted, husbandman 0
3861076 1977187 1977187 defendant Flye Ralph   586819 586819 Flye, Ralph, of Worsted, worsted weaver 1
3861079 1977188 1977188 defendant Bartylmewes William husbandman 586819 586819 Bartylmewes, William, of Worsted, husbandman 1
3861080 1977188 1977188 defendant Tolle Robert shoemaker 586819 586819 Tolle, Robert, of Worsted, shoemaker 2
3863841 1978081 1978081 defendant Gunne Robert   586819 586819 Gunne, Robert, of Worsted, worsted weaver 2
3868040 1979544 1979544 defendant Philippes Robert baker 586819 586819 Philippes, Robert, of Worsted, baker 0
3868041 1979544 1979544 defendant Baron Edward husbandman 586819 586819 Baron, Edward, of Worsted, husbandman 1
3868042 1979544 1979544 defendant Fleye Ralph   586819 586819 Fleye, Ralph, of Worsted, worsted weaver 2
3868045 1979545 1979545 defendant Warne Edward husbandman 586819 586819 Warne, Edward, of Worsted, husbandman 0
3868046 1979545 1979545 defendant Flege Robert   586819 586819 Flege, Robert, of Worsted, worsted weaver 1
3870964 1980540 1980540 defendant Bache John   586819 586819 Bache, John, of Worsted, worsted weaver 1
3879992 1983567 1983567 defendant Newman Richard tailor 586819 586819 Newman, Richard, of Worsted, tailor 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);