names

82 rows where place_id = 607883

✎ 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
3671248 1916982 1916982 defendant Bilond Henry yeoman 607883 607883 Bilond, Henry, of Towcester, yeoman 0
3762628 1945947 1945947 defendant Davy Benedict yeoman 607883 607883 Davy, Benedict, of Towcester, yeoman 0
3762629 1945947 1945947 defendant Waren Robert sherman 607883 607883 Waren, Robert, of Towcester, sherman 1
3771411 1948750 1948750 defendant Gossoppys Richard   607883 607883 Gossoppys, Richard, of Towcester, cook 1
3872311 1980964 1980964 defendant Moxen Robert glover 607883 607883 Moxen, Robert, of Towcester, glover 0
3872312 1980964 1980964 defendant Margettes Nicholas butcher 607883 607883 Margettes, Nicholas, of Towcester, butcher 1
3966853 2013041 2013041 plaintiff Broke Simon baker 607883 607883 Broke, Simon, of Towcester, baker 0
3966876 2013047 2013047 plaintiff Brokes Simon baker 607883 607883 Brokes, Simon, of Towcester, baker 0
3966877 2013047 2013047 defendant Hytcheman William husbandman 607883 607883 Hytcheman, William, of Towcester, husbandman 0
3966878 2013047 2013047 defendant Pynckerd John tanner 607883 607883 Pynckerd, John, of Towcester, tanner 1
3966879 2013048 2013048 plaintiff Brokes Simon baker 607883 607883 Brokes, Simon, of Towcester, baker 0
3966880 2013048 2013048 defendant Marshall Richard glover 607883 607883 Marshall, Richard, of Towcester, yeoman, glover 0
4009494 2028161 2028161 defendant Capern Richard mercer 607883 607883 Capern, Richard, of Towcester, mercer 0
4025450 2033763 2033763 plaintiff Brokeg or Brok Simon salter 607883 607883 Brokeg or Brok, Simon, of Towcester, salter 0
4025451 2033763 2033763 defendant Heathe Richard husbandman 607883 607883 Heathe, Richard, of Towcester, husbandman 0
4086804 2055570 2055570 defendant Osborn John baker 607883 607883 Osborn, John, of Towcester, baker 0
4212589 2099945 2099945 defendant Russell Firmun yeoman 607883 607883 Russell, Firmun, of Towcester, yeoman 0
4254851 2114612 2114612 defendant Blundell John yeoman 607883 607883 Blundell, John, of Towcester, yeoman 3
4267445 2118747 2118747 defendant Wincles Griffin mercer 607883 607883 Wincles, Griffin, of Towcester, mercer 2
4344345 2145302 2145302 defendant Lee William tailor 607883 607883 Lee, William, of Towcester, tailor 1
4344347 2145302 2145302 defendant Pulen Richard butcher 607883 607883 Pulen, Richard, of Towcester, butcher 3
4418092 2170537 2170537 defendant Straunge John le   607883 607883 Straunge, John le, of Towcester 0
4531513 2210134 2210134 defendant Sely William   607883 607883 Sely, William, of Towcester 0
4540862 2213047 2213047 defendant Glover Lawrence (legal representative) 607883 607883 Glover, Lawrence, of Towcester, executors of 0
4558691 2218671 2218671 defendant Stegge John   607883 607883 Stegge, John, of Towcester 0
4609397 2234039 2234039 plaintiff Brynkele Richard   607883 607883 Brynkele, Richard, of Towcester, parson 0
4609400 2234040 2234040 plaintiff Brynkele Richard   607883 607883 Brynkele, Richard, of Towcester, parson 0
4612462 2234964 2234964 defendant Osteler Walter   607883 607883 Osteler, Walter, of Towcester 0
4617082 2236351 2236351 defendant Sprentham Richard smith 607883 607883 Sprentham, Richard, of Towcester, smith 0
4628052 2239695 2239695 defendant Cook John   607883 607883 Cook, John, of Towcester 2
4633927 2241462 2241462 defendant Warner John   607883 607883 Warner, John, of Towcester 0
4640366 2243297 2243297 plaintiff Draper Robert   607883 607883 Draper, Robert, of Towcester 0
4640367 2243297 2243297 defendant Glover Nicholas   607883 607883 Glover, Nicholas, of Towcester 0
4646836 2245138 2245138 defendant Glover Nicholas   607883 607883 Glover, Nicholas, of Towcester 0
4701999 2266035 2266035 defendant Gregory Richard smith 607883 607883 Gregory, Richard, of Towcester, smith 0
4704777 2266872 2266872 defendant Machon Hugh butcher 607883 607883 Machon, Hugh, of Towcester, butcher 0
4719177 2271346 2271346 defendant Calverton Thomas mercer 607883 607883 Calverton, Thomas, of Towcester, mercer 0
4720018 2271608 2271608 defendant Toucestre John husbandman 607883 607883 Toucestre, John, of Towcester, husbandman 0
4720020 2271609 2271609 defendant Toucestre John husbandman 607883 607883 Toucestre, John, of Towcester, husbandman 0
4727140 2273748 2273748 defendant Beket John (legal representative) 607883 607883 Beket, John, of Towcester, executors of 2
4775807 2288432 2288432 plaintiff Wykyn John   607883 607883 Wykyn, John, of Towcester, "honyman" 0
4822994 2303273 2303273 defendant Morymer Lawrence esq 607883 607883 Morymer, Lawrence, of Towcester, esq 0
4845478 2310100 2310100 defendant Haversham Richard yeoman 607883 607883 Haversham, Richard, of Towcester, yeoman 1
4851856 2312016 2312016 plaintiff Wale Robert   607883 607883 Wale, Robert, of Towcester 0
4851857 2312016 2312016 defendant Boirell John ostler 607883 607883 Boirell, John, of Towcester, ostler 0
4918041 2332158 2332158 defendant Wyghton John (legal representative) 607883 607883 Wyghton, John, of Towcester, administratrix of 5
4928671 2335393 2335393 defendant Couper Joan widow 607883 607883 Couper, Joan, of Towcester, widow 3
4990407 2354043 2354043 plaintiff Machon Agnes   607883 607883 Machon, Agnes, of Towcester 1
5001028 2357178 2357178 defendant Wighton Eleanor   607883 607883 Wighton, Eleanor, of Towcester, widow, fomerly wife of John 3
5008308 2359318 2359318 defendant Wale Robert gent 607883 607883 Wale, Robert, of Towcester, gent 0
5008309 2359318 2359318 defendant Sand_ Henry gent 607883 607883 Sand_, Henry, of Towcester, gent 1
5047178 2370778 2370778 plaintiff Nynehide Thomas Master & parson 607883 607883 Nynehide, Thomas, of Towcester, Master & parson 0
5047179 2370778 2370778 defendant Holte John gent 607883 607883 Holte, John, of Towcester, gent 0
5047181 2370778 2370778 defendant Bultham alias Baker William baker 607883 607883 Bultham alias Baker, William, of Towcester, baker 2
5047182 2370778 2370778 defendant Latermer Lawrence tanner 607883 607883 Latermer, Lawrence, of Towcester, tanner 3
5047183 2370778 2370778 defendant Tolby John shoemaker 607883 607883 Tolby, John, of Towcester, shoemaker 4
5049453 2371473 2371473 plaintiff Sponne William (legal representative) 607883 607883 Sponne, William, of Towcester, parson and archdeacon of Norfolk, executors of 0
5049462 2371474 2371474 plaintiff Spoune William (legal representative) 607883 607883 Spoune, William, of Towcester, clerk & formerly archdeacon of Norfolk, executors of 0
5125554 2393961 2393961 plaintiff Baron William   607883 607883 Baron, William, of Towcester 0
5144214 2399459 2399459 plaintiff Baron William   607883 607883 Baron, William, of Towcester 0
5153894 2402294 2402294 defendant Faxton Thomas hosier 607883 607883 Faxton, Thomas, of Towcester, hosier 0
5165123 2405544 2405544 plaintiff Baron William   607883 607883 Baron, William, of Towcester 0
5171161 2407286 2407286 defendant Faxton Thomas hosier 607883 607883 Faxton, Thomas, of Towcester, hosier 0
5189405 2412637 2412637 defendant Faxton Thomas hosier 607883 607883 Faxton, Thomas, of Towcester, hosier 0
5189407 2412638 2412638 defendant Faxton Thomas hosier 607883 607883 Faxton, Thomas, of Towcester, hosier 0
5200303 2415848 2415848 defendant Person John weaver 607883 607883 Person, John, of Towcester, weaver 1
5200307 2415849 2415849 defendant Person John weaver 607883 607883 Person, John, of Towcester, weaver 1
5275813 2437995 2437995 defendant Basyng Thomas fisher 607883 607883 Basyng, Thomas, of Towcester, fisher 0
5306456 2446920 2446920 defendant Chapman John butcher 607883 607883 Chapman, John, of Towcester, butcher 0
5373553 2467327 2467327 defendant Story Thomas husbandman 607883 607883 Story, Thomas, of Towcester, husbandman 1
5373554 2467327 2467327 defendant Wakernell or Wakervell Thomas husbandman 607883 607883 Wakernell or Wakervell, Thomas, of Towcester, husbandman 2
5390500 2472346 2472346 defendant Latymer Lawrence tanner 607883 607883 Latymer, Lawrence, of Towcester, tanner 0
5390501 2472346 2472346 defendant Chase Henry tanner 607883 607883 Chase, Henry, of Towcester, tanner 1
5406429 2476911 2476911 defendant Smyth Richard butcher 607883 607883 Smyth, Richard, of Towcester, butcher 2
5419442 2480733 2480733 defendant Norton William yeoman 607883 607883 Norton, William, of Towcester, yeoman 2
5419532 2480761 2480761 defendant Smyth Richard butcher 607883 607883 Smyth, Richard, of Towcester, butcher 1
5432321 2484639 2484639 defendant Baxster Thomas yeoman 607883 607883 Baxster, Thomas, of Towcester, yeoman 1
5437750 2486229 2486229 defendant Nocton William yeoman 607883 607883 Nocton, William, of Towcester, yeoman 2
5437914 2486275 2486275 defendant Smyth Richard butcher 607883 607883 Smyth, Richard, of Towcester, butcher 1
5437917 2486276 2486276 defendant Smyth Richard butcher 607883 607883 Smyth, Richard, of Towcester, butcher 1
5597724 2534185 2534185 defendant Wydderley William butcher 607883 607883 Wydderley, William, of Towcester, butcher 0
5597726 2534186 2534186 defendant Wydderley William butcher 607883 607883 Wydderley, William, of Towcester, butcher 0

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