names

66 rows where place_id = 658453

✎ 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
3948490 2006537 2006537 defendant Clerkson John tanner 658453 658453 Clerkson, John, of Northallerton, tanner 0
3948491 2006537 2006537 defendant Skarlett Edmund yeoman 658453 658453 Skarlett, Edmund, of Northallerton, yeoman 1
3948492 2006537 2006537 defendant Clarkson Thomas smith 658453 658453 Clarkson, Thomas, of Northallerton, smith 2
4023952 2033272 2033272 defendant Clarkson John yeoman 658453 658453 Clarkson, John, of Northallerton, yeoman 2
4024647 2033493 2033493 defendant Smeton Robert yeoman 658453 658453 Smeton, Robert, of Northallerton, yeoman 1
4024648 2033493 2033493 defendant Clerkson John yeoman 658453 658453 Clerkson, John, of Northallerton, yeoman 2
4040388 2039063 2039063 defendant Wylkynson Ralph yeoman 658453 658453 Wylkynson, Ralph, of Northallerton, yeoman 1
4040401 2039064 2039064 defendant Wylkynson Ralph yeoman 658453 658453 Wylkynson, Ralph, of Northallerton, yeoman 1
4101934 2061005 2061005 defendant Smeaton or Smyton Robert gent 658453 658453 Smeaton or Smyton, Robert, of Northallerton, gent 0
4114434 2065446 2065446 defendant Jackson Francis gent 658453 658453 Jackson, Francis, of Northallerton, gent 0
4114435 2065446 2065446 defendant Close Alice spinster 658453 658453 Close, Alice, of Northallerton, spinster 1
4114438 2065447 2065447 defendant Jackson Francis gent 658453 658453 Jackson, Francis, of Northallerton, gent 0
4114439 2065447 2065447 defendant Close Alice spinster 658453 658453 Close, Alice, of Northallerton, spinster 1
4114440 2065447 2065447 defendant Charter Alice spinster 658453 658453 together with Charter, Alice, of Northallerton, spinster 2
4117275 2066481 2066481 defendant Marshall Richard husbandman 658453 658453 Marshall, Richard, of Northallerton, husbandman 0
4311559 2134182 2134182 defendant Carter Thomas cordwainer 658453 658453 Carter, Thomas, of Northallerton, cordwainer 0
4313515 2134835 2134835 defendant Carver Robert butcher 658453 658453 Carver, Robert, of Northallerton, butcher 0
4313516 2134835 2134835 defendant Lodge Richard tanner 658453 658453 Lodge, Richard, of Northallerton, tanner 1
4317718 2136310 2136310 defendant Gowld Richard chapman 658453 658453 Gowld, Richard, of Northallerton, chapman 0
4318583 2136612 2136612 defendant Reynolde Arthur vintner 658453 658453 Reynolde, Arthur, of Northallerton, vintner 0
4372649 2155293 2155293 defendant Scarlett Anthony yeoman 658453 658453 Scarlett, Anthony, of Northallerton, yeoman 0
4388165 2160669 2160669 defendant Browne James tailor 658453 658453 Browne, James, of Northallerton, tailor 0
4394427 2162733 2162733 defendant Carverm Robert butcher 658453 658453 Carverm Robert, of Northallerton, butcher 1
4400528 2164769 2164769 defendant Carver Robert butcher 658453 658453 Carver, Robert, of Northallerton, butcher 0
4408761 2167526 2167526 defendant Rymer Michael yeoman 658453 658453 Rymer, Michael, of Northallerton, yeoman 1
4498981 2200321 2200321 defendant Halbarne John   658453 658453 Halbarne, John, of Northallerton 0
4556002 2217819 2217819 defendant Gibson Julia   658453 658453 Gibson, Julia, of Northallerton, formerly wife of Henry 0
4574184 2223451 2223451 defendant Carter William   658453 658453 Carter, William, of Northallerton 0
4587860 2227604 2227604 defendant Elisson John walker 658453 658453 Elisson, John, of Northallerton, walker 0
4663775 2250156 2250156 defendant Danby William butcher 658453 658453 Danby, William, of Northallerton, butcher 0
4663777 2250156 2250156 defendant Thexton John smith 658453 658453 Thexton, John, of Northallerton, smith 2
4667072 2255432 2255432 defendant Dese Richard   658453 658453 Dese, Richard, of Northallerton, shepherd 0
4707332 2267671 2267671 defendant Dyghton Thomas weaver 658453 658453 Dyghton, Thomas, of Northallerton, weaver 0
4749735 2280402 2280402 defendant Freres Adam del butcher 658453 658453 Freres, Adam del, of Northallerton, butcher 0
4798980 2295853 2295853 defendant Silton John yeoman 658453 658453 Silton, John, of Northallerton, yeoman 0
4822372 2303078 2303078 defendant Danby John butcher 658453 658453 Danby, John, of Northallerton, butcher 1
4822373 2303078 2303078 defendant Bernyngham Richard yeoman 658453 658453 Bernyngham, Richard, of Northallerton, yeoman 2
4859442 2314330 2314330 defendant Carter John butcher 658453 658453 Carter, John, of Northallerton, butcher 0
4859443 2314330 2314330 defendant Danby Richard butcher 658453 658453 Danby, Richard, of Northallerton, butcher 1
4862490 2315263 2315263 defendant Roungton John smith 658453 658453 Roungton, John, of Northallerton, smith 0
4862494 2315263 2315263 defendant Lyng Thomas yeoman 658453 658453 Lyng, Thomas, of Northallerton, yeoman 4
4883131 2321649 2321649 defendant Leget William yeoman 658453 658453 Leget, William, of Northallerton, yeoman 0
4888630 2323237 2323237 defendant Arondale John barker 658453 658453 Arondale, John, of Northallerton, barker 0
4910546 2329809 2329809 defendant Richemond John chaplain 658453 658453 with Richemond, John, of Northallerton, chaplain 2
4923832 2333896 2333896 defendant Scotte John smith 658453 658453 Scotte, John, of Northallerton, smith 0
4990087 2353944 2353944 defendant Wryght Thomas shoemaker 658453 658453 Wryght, Thomas, of Northallerton, shoemaker 1
4991185 2354251 2354251 defendant Wryght Walter cooper 658453 658453 Wryght, Walter, of Northallerton, cooper 1
4995946 2355636 2355636 defendant Foxton John gent 658453 658453 Foxton, John, of Northallerton, gent 0
5012499 2360502 2360502 defendant Cutler Thomas mercer 658453 658453 Cutler, Thomas, of Northallerton, mercer 1
5050953 2371899 2371899 defendant Hart John shoemaker 658453 658453 Hart, John, of Northallerton, shoemaker 1
5052160 2372257 2372257 defendant Radcliff John master of the Hospital of St James 658453 658453 Radcliff, John, of Northallerton, master of the Hospital of St James 3
5080853 2380764 2380764 defendant Hobson John husbandman 658453 658453 Hobson, John, of Northallerton, husbandman 0
5081670 2381025 2381025 defendant Lonkan or Loukan John yeoman 658453 658453 Lonkan or Loukan, John, of Northallerton, yeoman 1
5081671 2381025 2381025 defendant Carter John flesshewer or butcher 658453 658453 Carter, John, of Northallerton, flesshewer or butcher 2
5289603 2441960 2441960 defendant Vicars William barker 658453 658453 Vicars, William, of Northallerton, barker 0
5290224 2442144 2442144 defendant Witton William saddler 658453 658453 Witton William, of Northallerton, saddler 2
5327742 2453365 2453365 defendant Vycars William shoemaker 658453 658453 Vycars, William, of Northallerton, shoemaker 0
5375792 2468022 2468022 defendant Knolle Robert yeoman 658453 658453 Knolle, Robert, of Northallerton, yeoman 0
5377805 2468643 2468643 plaintiff Symson Robert Master of the Hospital of St James 658453 658453 Symson, Robert, of Northallerton, Master of the Hospital of St James 0
5382999 2470205 2470205 defendant Blythe John baker 658453 658453 Blythe, John, of Northallerton, baker 4
5394231 2473411 2473411 defendant Crosley Thomas yeoman 658453 658453 Crosley, Thomas, of Northallerton, yeoman 2
5394233 2473411 2473411 defendant Blyth John baker 658453 658453 Blyth, John, of Northallerton, baker 4
5511615 2508480 2508480 defendant Halyman Richard yeoman 658453 658453 Halyman, Richard, of Northallerton, yeoman 3
5515510 2509695 2509695 defendant Hopperton John yeoman 658453 658453 Hopperton, John, of Northallerton, yeoman 0
5515512 2509695 2509695 defendant Yntson or Yutson Joan widow 658453 658453 Yntson or Yutson, Joan, of Northallerton, widow 2
5633964 2554605 2554605 defendant Sadeler Thomas yeoman 658453 658453 together with Sadeler, Thomas, of Northallerton, yeoman 1

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