names

105 rows where place_id = 604476

✎ 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
3658116 1912796 1912796 defendant Wagge John husbandman 604476 604476 Wagge, John, of Haverhill, husbandman 0
3658117 1912796 1912796 defendant Barker Nicholas   604476 604476 Barker, Nicholas, of Haverhill, wax chandler 1
3680279 1919906 1919906 defendant Stubbyng Robert tanner 604476 604476 Stubbyng, Robert, of Haverhill, tanner 0
3680281 1919907 1919907 defendant Stubbyng Robert tanner 604476 604476 Stubbyng, Robert, of Haverhill, tanner 0
3695665 1924876 1924876 defendant Tebold William husbandman 604476 604476 Tebold, William, of Haverhill, husbandman 1
3695669 1924877 1924877 defendant Tebold William innholder 604476 604476 Tebold, William, of Haverhill, innholder 0
3732617 1936432 1936432 defendant Rydnall James husbandman 604476 604476 Rydnall, James, of Haverhill, husbandman 2
3752608 1942746 1942746 defendant Benstall John husbandman 604476 604476 Benstall, John, of Haverhill, husbandman 1
3752609 1942746 1942746 defendant Smyth Thomas showmaker 604476 604476 Smyth, Thomas, of Haverhill, showmaker 2
3761053 1945458 1945458 defendant Grene John gent 604476 604476 Grene, John, of Haverhill, gent 0
3770813 1948562 1948562 defendant Stanston James smith 604476 604476 Stanston, James, of Haverhill, smith 0
3770814 1948562 1948562 defendant Fayer John husbandman 604476 604476 Fayer, John, of Haverhill, husbandman 1
3772582 1949117 1949117 defendant Covyn or Cobyn John husbandman 604476 604476 Covyn or Cobyn, John, of Haverhill, husbandman 2
3772583 1949117 1949117 defendant Pyngyll Thomas tailor 604476 604476 Pyngyll, Thomas, of Haverhill, tailor 3
3787224 1953799 1953799 plaintiff Reve John clothmaker 604476 604476 Reve, John, of Haverhill, clothmaker 0
3787225 1953799 1953799 defendant Man James tanner 604476 604476 Man, James, of Haverhill, tanner 0
3787226 1953799 1953799 defendant Burton Leonard gent 604476 604476 Burton, Leonard, of Haverhill, gent 1
3802625 1958716 1958716 defendant Stanton William tailor 604476 604476 Stanton, William, of Haverhill, tailor 2
3802626 1958716 1958716 defendant Smyth Thomas shoemaker 604476 604476 Smyth, Thomas, of Haverhill, shoemaker 3
3814120 1962320 1962320 defendant Fybes Henry miller 604476 604476 Fybes, Henry, of Haverhill, miller 0
3814121 1962320 1962320 defendant Grene Robert shoemaker 604476 604476 Grene, Robert, of Haverhill, shoemaker 1
3871480 1980704 1980704 defendant Large Richard husbandman 604476 604476 Large, Richard, of Haverhill, husbandman 2
4275058 2121228 2121228 defendant Cannon Paul husbandman 604476 604476 Cannon, Paul, of Haverhill, husbandman 0
4275060 2121229 2121229 defendant Edgley Henry laborer 604476 604476 Edgley, Henry, of Haverhill, laborer 0
4280536 2123100 2123100 defendant Kynge Alice widow 604476 604476 Kynge, Alice, of Haverhill, widow 0
4302818 2131105 2131105 defendant Browne William glover 604476 604476 Browne, William, of Haverhill, glover 2
4331581 2140859 2140859 defendant Bowes Richard miller 604476 604476 Bowes, Richard, of Haverhill, miller 0
4389476 2161105 2161105 defendant Curteis Reginald   604476 604476 Curteis, Reginald, of Haverhill yeoman 1
4401443 2165078 2165078 defendant Ratclyff William gent 604476 604476 Ratclyff, William, of Haverhill, gent 0
4403345 2165687 2165687 defendant Cannam Paul yeoman 604476 604476 Cannam, Paul, of Haverhill, yeoman 0
4405180 2166309 2166309 defendant Miller Nicholas yeoman 604476 604476 Miller, Nicholas, of Haverhill, yeoman 1
4408152 2167296 2167296 defendant Mortlock William haberdasher 604476 604476 Mortlock, William, of Haverhill, haberdasher 0
4408828 2167551 2167551 defendant Fayercloughe Lawrence clerk 604476 604476 Fayercloughe, Lawrence, of Haverhill, clerk 0
4451383 2185404 2185404 plaintiff Hilton John de   604476 604476 Hilton, John de, of Haverhill, parson 0
4451386 2185404 2185404 defendant Fullere Geoffrey   604476 604476 Fullere, Geoffrey, of Haverhill 2
4511534 2204056 2204056 plaintiff Berners Margaret (legal representative) 604476 604476 Berners, Margaret, of Haverhill, formerly wife of William, executors of 0
4557190 2218183 2218183 defendant Page William   604476 604476 Page, William, of Haverhill 0
4644873 2244567 2244567 plaintiff Mayster Roger   604476 604476 Mayster, Roger, of Haverhill 0
4654386 2247245 2247245 plaintiff Bocher John   604476 604476 Bocher, John, of Haverhill 0
4669163 2256061 2256061 defendant Pepry John tanner 604476 604476 Pepry, John, of Haverhill, tanner 3
4671097 2256625 2256625 plaintiff Perye John   604476 604476 Perye, John, of Haverhill 1
4671098 2256625 2256625 defendant Patryk John tailor 604476 604476 Patryk, John, of Haverhill, tailor 0
4683402 2260411 2260411 plaintiff Payn John   604476 604476 Payn, John, of Haverhill 0
4712483 2269221 2269221 plaintiff Cleydon John   604476 604476 Cleydon, John, of Haverhill 1
4732542 2275352 2275352 plaintiff Payn John   604476 604476 Payn, John, of Haverhill 0
4735424 2276224 2276224 plaintiff Spyser William   604476 604476 Spyser, William, of Haverhill 0
4744131 2278810 2278810 defendant Becher John husbandman 604476 604476 Becher, John, of Haverhill, husbandman 0
4749606 2280369 2280369 plaintiff Payn John   604476 604476 Payn, John, of Haverhill 0
4749608 2280369 2280369 defendant Hegge John yeoman 604476 604476 Hegge, John, of Haverhill, yeoman 1
4766203 2285421 2285421 defendant Cote William smith 604476 604476 Cote, William, of Haverhill, smith 0
4767059 2285685 2285685 defendant Payn John husbandman 604476 604476 Payn, John, of Haverhill, husbandman 0
4769595 2286467 2286467 defendant Fraunseys Walter butcher 604476 604476 Fraunseys, Walter, of Haverhill, butcher 1
4771484 2287061 2287061 defendant Page John baker 604476 604476 Page, John, of Haverhill, baker 0
4810465 2299418 2299418 defendant Tomson John   604476 604476 Tomson, John, of Haverhill 0
4810467 2299418 2299418 defendant Edward John   604476 604476 Edward, John, of Haverhill 2
4811459 2299694 2299694 plaintiff Payn John, junior   604476 604476 Payn, John, junior, of Haverhill, on his own account 1
4817287 2301498 2301498 defendant Hegge John husbandman 604476 604476 Hegge, John, of Haverhill, husbandman 4
4819036 2302035 2302035 defendant Couper Thomas husbandman 604476 604476 Couper, Thomas, of Haverhill, husbandman 0
4841994 2309034 2309034 defendant Reven John   604476 604476 Reven, John, of Haverhill, shoe maker 0
4843891 2309607 2309607 defendant Castelwode James yeoman 604476 604476 Castelwode, James, of Haverhill, yeoman 0
4843901 2309610 2309610 defendant Tyrold John fuller 604476 604476 Tyrold, John, of Haverhill, fuller 4
4845309 2310045 2310045 plaintiff Page William   604476 604476 Page, William, of Haverhill 0
4848545 2311019 2311019 defendant Lawesell John husbandman 604476 604476 Lawesell, John, of Haverhill, husbandman 0
4869437 2317409 2317409 plaintiff Lane William   604476 604476 Lane, William, of Haverhill 1
4891855 2324188 2324188 defendant Lansell or Lausell John husbandman 604476 604476 Lansell or Lausell, John, of Haverhill, husbandman 2
4908977 2329353 2329353 defendant Crabbe Ralph   604476 604476 Crabbe, Ralph, of Haverhill, wheel wright 1
4908978 2329353 2329353 defendant Walkelyn Thomas dyer 604476 604476 Walkelyn, Thomas, of Haverhill, dyer 2
4909199 2329422 2329422 defendant Walkleyn Thomas dyer 604476 604476 Walkleyn, Thomas, of Haverhill, dyer 1
4909201 2329422 2329422 defendant Payn John chapman 604476 604476 Payn, John, of Haverhill, chapman 3
4978548 2350535 2350535 defendant Glover John husbandman 604476 604476 Glover, John, of Haverhill, husbandman 3
5030707 2365850 2365850 defendant Odye John smith 604476 604476 Odye, John, of Haverhill, smith 0
5055566 2373241 2373241 defendant Parker William yeoman 604476 604476 (Parker, William, of Haverhill, yeoman 1
5055567 2373241 2373241 defendant Newelond William yeoman 604476 604476 Newelond, William, of Haverhill, yeoman 2
5063698 2375675 2375675 defendant Fen Hugh shoemaker 604476 604476 Fen, Hugh, of Haverhill, shoemaker 0
5073110 2378443 2378443 defendant Peryman John dyer 604476 604476 Peryman, John, of Haverhill, dyer 0
5084082 2381742 2381742 defendant Turnour Henry   604476 604476 Turnour, Henry, of Haverhill 0
5098924 2386114 2386114 plaintiff Mayster Thomas   604476 604476 Mayster, Thomas,of Haverhill 1
5098925 2386114 2386114 plaintiff Lane John barker 604476 604476 Lane, John, of Haverhill, barker 2
5098926 2386114 2386114 defendant Lee William husbandman 604476 604476 Lee, William, of Haverhill, husbandman 0
5098927 2386114 2386114 defendant Kene William chandler 604476 604476 Kene, William, of Haverhill, chandler 1
5102248 2387076 2387076 defendant Cornewayle John (legal representative) 604476 604476 Cornewayle, John, of Haverhill, executors of 0
5102251 2387076 2387076 defendant Kelyng John schoolmaster 604476 604476 Kelyng, John, of Haverhill, schoolmaster 3
5118241 2391774 2391774 defendant Reson Thomas barker 604476 604476 Reson, Thomas, of Haverhill, barker 1
5122166 2392903 2392903 defendant Skorton Henry butcher 604476 604476 Skorton, Henry, of Haverhill, butcher 4
5122167 2392903 2392903 defendant Kane John yeoman 604476 604476 Kane, John, of Haverhill, yeoman 5
5122168 2392903 2392903 defendant atte Fen Hugh shoemaker 604476 604476 atte Fen, Hugh, of Haverhill, shoemaker 6
5262358 2433975 2433975 defendant Kempe Thomas thatcher 604476 604476 Kempe, Thomas, of Haverhill, thatcher 1
5266318 2435218 2435218 defendant Cornewayll Thomas gent 604476 604476 Cornewayll, Thomas, of Haverhill, gent 0
5266319 2435218 2435218 defendant Stallon John, senior tanner 604476 604476 Stallon, John, senior, of Haverhill, tanner 1
5266320 2435218 2435218 defendant Stallon John (legal representative) 604476 604476 Stallon, John, of Haverhill, executrix of 2
5266321 2435218 2435218 defendant Stallon Katherine widow 604476 604476 Stallon, Katherine, of Haverhill, widow 3
5278746 2438891 2438891 defendant Baker alias Baxster Henry yeoman 604476 604476 Baker alias Baxster, Henry, of Haverhill, yeoman 0
5324009 2452267 2452267 defendant Stalon John husbandman 604476 604476 Stalon, John, of Haverhill, husbandman 1
5362625 2463959 2463959 defendant Cagh Thomas yeoman 604476 604476 Cagh, Thomas, of Haverhill, yeoman 2
5378390 2468822 2468822 plaintiff Turnour Henry esq 604476 604476 Turnour, Henry, of Haverhill, esq 0
5434522 2485267 2485267 defendant Parker John fuller 604476 604476 Parker, John, of Haverhill, fuller 3
5434643 2485299 2485299 defendant Couper William husbandman 604476 604476 Couper, William, of Haverhill, husbandman 0
5502720 2505767 2505767 plaintiff Turnor Henry   604476 604476 Turnor, Henry, of Haverhill 0
5506771 2507039 2507039 defendant Batell John, junior husbandman 604476 604476 Batell, John, junior, of Haverhill, husbandman 0
5589759 2531791 2531791 defendant Sharp John dyer 604476 604476 Sharp, John, of Haverhill, dyer 1

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);