names

149 rows where place_id = 585988

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587633 1863776 1863776 defendant Bunserssh William butcher 585988 585988 Bunserssh, William, of Hethfeld, butcher 1
3587637 1863777 1863777 defendant Bunserssh William butcher 585988 585988 Bunserssh, William, of Hethfeld, butcher 1
3598881 1867275 1867275 defendant Andrewe John husbandman 585988 585988 Andrewe, John, of Hethfeld, husbandman 0
3598884 1867276 1867276 defendant Andrewe John husbandman 585988 585988 Andrewe, John, of Hethfeld, husbandman 0
3599123 1867363 1867363 plaintiff Thomkyn John, junior (legal representative) 585988 585988 Thomkyn, John, junior, of Hethfeld, executors of 0
3601230 1868047 1868047 defendant Bunserch William butcher 585988 585988 Bunserch, William, of Hethfeld, butcher 0
3627396 1903423 1903423 defendant Lover Thomas wheeler 585988 585988 Lover, Thomas, of Hethfeld, wheeler 0
3640754 1907554 1907554 defendant Putland Richard husbandman 585988 585988 Putland, Richard, of Hethfeld, husbandman 0
3640755 1907554 1907554 defendant Awode John husbandman 585988 585988 Awode, John, of Hethfeld, husbandman 1
3646101 1909180 1909180 defendant Hersey Richard clerk 585988 585988 Hersey, Richard, of Hethfeld, clerk 1
3646102 1909180 1909180 defendant Wyllard John, senior wheeler 585988 585988 Wyllard, John, senior, of Hethfeld, wheeler 2
3646103 1909180 1909180 defendant Wanmere Thomas husbandman 585988 585988 Wanmere, Thomas, of Hethfeld, husbandman 3
3649218 1910144 1910144 defendant Godfrey John yeoman 585988 585988 Godfrey, John, of Hethfeld, yeoman 0
3654486 1911662 1911662 defendant Awode John, senior husbandman 585988 585988 Awode, John, senior, of Hethfeld, husbandman 0
3657838 1912701 1912701 defendant Bocher Richard husbandman 585988 585988 Bocher, Richard, of Hethfeld, husbandman 1
3658565 1912931 1912931 defendant Catte Peter husbandman 585988 585988 Catte, Peter, of Hethfeld, husbandman 3
3679864 1919767 1919767 defendant Cate Peter laborer 585988 585988 Cate, Peter, of Hethfeld, laborer 0
3679865 1919767 1919767 defendant Holbeme Thomas, senior laborer 585988 585988 Holbeme, Thomas, senior, of Hethfeld, laborer 1
3679867 1919768 1919768 defendant Holbeme Thomas, junior laborer 585988 585988 Holbeme, Thomas, junior, of Hethfeld, laborer 0
3679868 1919768 1919768 defendant Holbeme John laborer 585988 585988 Holbeme, John, of Hethfeld, laborer 1
3679870 1919769 1919769 defendant Holbeme John laborer 585988 585988 Holbeme, John, of Hethfeld, laborer 0
3679871 1919769 1919769 defendant Holbeme Thomas, junior laborer 585988 585988 Holbeme, Thomas, junior, of Hethfeld, laborer 1
3679873 1919770 1919770 defendant Holbeme Thomas, senior laborer 585988 585988 Holbeme, Thomas, senior, of Hethfeld, laborer 0
3681289 1920235 1920235 defendant Penhurst Roger gent 585988 585988 Penhurst, Roger, of Hethfeld, gent 1
3695422 1924791 1924791 defendant Holbeme John laborer 585988 585988 Holbeme, John, of Hethfeld, laborer 0
3706030 1928177 1928177 defendant Walsted John husbandman 585988 585988 Walsted, John, of Hethfeld, husbandman 1
3716458 1931441 1931441 defendant Awode John husbandman 585988 585988 Awode, John, of Hethfeld, husbandman 0
3720129 1932572 1932572 defendant Pryour John yeoman 585988 585988 Pryour, John, of Hethfeld, yeoman 0
3720679 1932757 1932757 defendant Grenfeld Richard husbandman 585988 585988 Grenfeld, Richard, of Hethfeld, husbandman 1
3726562 1934565 1934565 defendant Pryor John yeoman 585988 585988 Pryor, John, of Hethfeld, yeoman 0
3727412 1934845 1934845 defendant Watlyn alias Warter Thomas husbandman 585988 585988 Watlyn alias Warter, Thomas, of Hethfeld, husbandman 0
3743061 1939678 1939678 defendant Watkyn Thomas husbandman 585988 585988 Watkyn, Thomas, of Hethfeld, husbandman 0
3766981 1947340 1947340 defendant Northe William sawyer 585988 585988 Northe, William, of Hethfeld, sawyer 0
3768439 1947776 1947776 defendant Bocher Richard shingler 585988 585988 Bocher, Richard, of Hethfeld, shingler 1
3770296 1948380 1948380 defendant Holbem Robert husbandman 585988 585988 Holbem, Robert, of Hethfeld, husbandman 1
3819991 1964133 1964133 defendant Bocher Richard shingler 585988 585988 Bocher, Richard, of Hethfeld, shingler 1
3824402 1965502 1965502 defendant Turke Thomas husbandman 585988 585988 Turke, Thomas, of Hethfeld, husbandman 1
3825677 1965884 1965884 defendant Holbeme Robert husbandman 585988 585988 Holbeme, Robert, of Hethfeld, husbandman 0
3825678 1965884 1965884 defendant Gurde Nicholas husbandman 585988 585988 Gurde, Nicholas, of Hethfeld, husbandman 1
3861587 1977335 1977335 defendant Jakeson John carpenter 585988 585988 Jakeson, John, of Hethfeld, carpenter 2
3865826 1978800 1978800 defendant Love Thomas laborer 585988 585988 Love, Thomas, of Hethfeld, laborer 1
3891752 1987497 1987497 defendant Whyte William clothier 585988 585988 Whyte, William, of Hethfeld, clothier 0
3900451 1990380 1990380 defendant Champne Richard mercer 585988 585988 Champne, Richard, of Hethfeld, mercer 0
3942626 2004542 2004542 plaintiff Woodman Thomas   585988 585988 Woodman, Thomas, of Hethfeld, forge master 0
3960326 2010708 2010708 defendant Woodman Thomas yeoman 585988 585988 Woodman, Thomas, of Hethfeld, yeoman 0
3960426 2010745 2010745 plaintiff Stullyon John   585988 585988 Stullyon, John, of Hethfeld 0
3960429 2010746 2010746 plaintiff Stullyon John   585988 585988 Stullyon, John, of Hethfeld 0
3960430 2010746 2010746 defendant Lewcas alias Tyceherst Richard husbandman 585988 585988 Lewcas alias Tyceherst, Richard, of Hethfeld, husbandman 0
3967757 2013355 2013355 plaintiff Calfe Richard   585988 585988 Calfe, Richard, of Hethfeld 0
3968352 2013563 2013563 defendant Cade Robert husbandman 585988 585988 Cade, Robert, of Hethfeld, husbandman 0
4051423 2042930 2042930 defendant Collyn Nicholas founder 585988 585988 Collyn, Nicholas, of Hethfeld, founder 0
4051424 2042930 2042930 defendant Jurden Nicholas laborer 585988 585988 Jurden, Nicholas, of Hethfeld, laborer 1
4051425 2042930 2042930 defendant Akehurst Bartholomew laborer 585988 585988 Akehurst, Bartholomew, of Hethfeld, laborer 2
4052178 2043199 2043199 defendant Collyn Nicholas founder 585988 585988 Collyn, Nicholas, of Hethfeld, founder 0
4052179 2043199 2043199 defendant Jurden Nicholas laborer 585988 585988 Jurden, Nicholas, of Hethfeld, laborer 1
4052180 2043199 2043199 defendant Akehurst Bartholomew laborer 585988 585988 Akehurst, Bartholomew, of Hethfeld, laborer 2
4055810 2044458 2044458 defendant Akeherst John husbandman 585988 585988 Akeherst, John, of Hethfeld, husbandman 3
4060755 2046252 2046252 defendant Cogger Simon yeoman 585988 585988 Cogger, Simon, of Hethfeld, yeoman 0
4095206 2058608 2058608 defendant Smyth Robert yeoman 585988 585988 Smyth, Robert, of Hethfeld, yeoman 2
4103288 2061457 2061457 defendant Cosham Thomas husbandman 585988 585988 Cosham, Thomas, of Hethfeld, husbandman 0
4167186 2084027 2084027 defendant Hobeme John yeoman 585988 585988 Hobeme, John, of Hethfeld, yeoman 0
4227275 2105022 2105022 defendant Benjamyn John yeoman 585988 585988 Benjamyn, John, of Hethfeld, yeoman 0
4234840 2107737 2107737 defendant Rose Robert husbandman 585988 585988 Rose, Robert, of Hethfeld, husbandman 0
4250836 2113255 2113255 defendant Benjamin John yeoman 585988 585988 Benjamin, John, of Hethfeld, yeoman 0
4369846 2154270 2154270 defendant Browne Robert yeoman 585988 585988 Browne, Robert, of Hethfeld, yeoman 0
4419411 2170955 2170955 defendant Smyth John le   585988 585988 Smyth, John le, of Hethfeld 0
4462079 2188841 2188841 defendant Ive William   585988 585988 Ive, William, of Hethfeld 0
4524074 2207862 2207862 defendant Taillour William   585988 585988 Taillour, William, of Hethfeld 1
4531802 2210208 2210208 defendant Shode John   585988 585988 Shode, John, of Hethfeld 1
4543643 2213907 2213907 plaintiff atte Wode John   585988 585988 atte Wode, John, of Hethfeld 0
4639185 2242979 2242979 defendant Tayllour Thomas   585988 585988 Tayllour, Thomas, of Hethfeld 0
4703715 2266539 2266539 defendant Borham William laborer 585988 585988 Borham, William, of Hethfeld, laborer 0
4730064 2274603 2274603 defendant Symmys Thomas   585988 585988 Symmys, Thomas, of Hethfeld, horse dealer 0
4759892 2283427 2283427 defendant Pengherst (illegible) husbandman 585988 585988 Pengherst, _, of Hethfeld, husbandman 1
4761574 2283964 2283964 defendant Berworth John yeoman 585988 585988 Berworth, John, of Hethfeld, yeoman 0
4770072 2286610 2286610 defendant Hoget Richard turner 585988 585988 Hoget, Richard, of Hethfeld, turner 3
4794713 2294485 2294485 defendant Hoget Richard turner 585988 585988 Hoget, Richard, of Hethfeld, turner 2
4825954 2304150 2304150 defendant Hobbe Roger smith 585988 585988 Hobbe, Roger, of Hethfeld, smith 0
4827330 2304595 2304595 defendant Coweden Joan widow 585988 585988 Coweden, Joan, of Hethfeld, widow 1
4828888 2305075 2305075 defendant atte Forde William husbandman 585988 585988 atte Forde, William, of Hethfeld, husbandman 0
4840321 2308520 2308520 defendant Carpenter Thomas collier 585988 585988 Carpenter, Thomas, of Hethfeld, collier 1
4850474 2311606 2311606 defendant Pryour John whyler or wheel wright 585988 585988 Pryour, John, of Hethfeld, whyler or wheel wright 0
4855624 2313126 2313126 defendant atte Forde William husbandman 585988 585988 atte Forde, William, of Hethfeld, husbandman 0
4855626 2313127 2313127 defendant atte Forde William husbandman 585988 585988 atte Forde, William, of Hethfeld, husbandman 0
4857554 2313751 2313751 defendant Cheseman Walter husbandman 585988 585988 Cheseman, Walter, of Hethfeld, husbandman 0
4867615 2316842 2316842 defendant Hethfeld William husbandman 585988 585988 Hethfeld, William, of Hethfeld, husbandman 0
4906562 2328637 2328637 defendant Stolyon Thomas husbandman 585988 585988 Stolyon, Thomas, of Hethfeld, husbandman 1
4908596 2329243 2329243 defendant atte Forde William husbandman 585988 585988 atte Forde, William, of Hethfeld, husbandman 2
4934396 2337149 2337149 defendant Tok Thomas carpenter 585988 585988 Tok, Thomas, of Hethfeld, carpenter 4
4953403 2342983 2342983 defendant Holbeme William husbandman 585988 585988 Holbeme, William, of Hethfeld, husbandman 0
4959652 2344848 2344848 defendant Mone Robert husbandman 585988 585988 Mone, Robert, of Hethfeld, husbandman 0
4959653 2344848 2344848 defendant Cok Thomas carpenter 585988 585988 Cok, Thomas, of Hethfeld, carpenter 1
4995815 2355594 2355594 defendant Harmer Thomas butcher 585988 585988 Harmer, Thomas, of Hethfeld, butcher 0
4996464 2355799 2355799 defendant atte Forde William laborer 585988 585988 atte Forde, William, of Hethfeld, laborer 0
5000507 2357020 2357020 defendant atte Forde William husbandman 585988 585988 atte Forde, William, of Hethfeld, husbandman 0
5001523 2357338 2357338 defendant Holbeme William husbandman 585988 585988 Holbeme, William, of Hethfeld, husbandman 0
5003110 2357814 2357814 defendant Holbeme William husbandman 585988 585988 Holbeme, William, of Hethfeld, husbandman 0
5008768 2359455 2359455 defendant atte Forde William laborer 585988 585988 atte Forde, William, of Hethfeld, laborer 1
5009071 2359535 2359535 defendant Holbeme John husbandman 585988 585988 Holbeme, John, of Hethfeld, husbandman 0
5009076 2359536 2359536 defendant Holbeme John husbandman 585988 585988 Holbeme, John, of Hethfeld, 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);