names

79 rows where place_id = 628156

✎ 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
3780777 1951723 1951723 defendant Akeherst John husbandman 628156 628156 Akeherst, John, of Herstmounceux, husbandman 0
4091795 2057359 2057359 defendant Baker John tanner 628156 628156 Baker, John, of Herstmounceux, tanner 0
4128608 2070523 2070523 defendant Gregorye Richard yeoman 628156 628156 Gregorye, Richard, of Herstmounceux, yeoman 0
4132008 2071761 2071761 defendant Hemsley Edward yeoman 628156 628156 Hemsley, Edward, of Herstmounceux, yeoman 0
4132010 2071762 2071762 defendant Parker Simon yeoman 628156 628156 Parker, Simon, of Herstmounceux, yeoman 0
4141417 2075155 2075155 defendant Messant Henry husbandman 628156 628156 Messant, Henry, of Herstmounceux, husbandman 0
4141419 2075155 2075155 defendant Dockyng John husbandman 628156 628156 Dockyng, John, of Herstmounceux, husbandman 2
4141420 2075155 2075155 defendant Forde Richard, junior husbandman 628156 628156 Forde, Richard, junior, of Herstmounceux, husbandman 3
4141851 2075315 2075315 defendant Hemsley Edward yeoman 628156 628156 Hemsley, Edward, of Herstmounceux, yeoman 0
4141853 2075316 2075316 defendant Parker Simon yeoman 628156 628156 Parker, Simon, of Herstmounceux, yeoman 0
4141855 2075317 2075317 defendant Fawcett Miles yeoman 628156 628156 Fawcett, Miles, of Herstmounceux, yeoman 0
4171399 2085461 2085461 defendant Bromeham John husbandman 628156 628156 Bromeham, John, of Herstmounceux, husbandman 0
4181418 2088977 2088977 defendant Hutchyn Thomas husbandman 628156 628156 Hutchyn, Thomas, of Herstmounceux, husbandman 1
4189757 2091912 2091912 defendant Fyrmynger Francis yeoman 628156 628156 Fyrmynger, Francis, of Herstmounceux, yeoman 0
4223921 2103853 2103853 defendant Myller Thomas shoemaker 628156 628156 Myller, Thomas, of Herstmounceux, shoemaker 0
4227305 2105031 2105031 defendant Salter Thomas yeoman 628156 628156 Salter, Thomas, of Herstmounceux, yeoman 2
4228505 2105453 2105453 defendant Somner Andrew yeoman 628156 628156 Somner, Andrew, of Herstmounceux, yeoman 2
4229693 2105866 2105866 defendant Brytten alias Journold John husbandman 628156 628156 Brytten alias Journold, John, of Herstmounceux, husbandman 1
4230412 2106130 2106130 defendant Frenche thomas yeoman 628156 628156 Frenche, thomas, of Herstmounceux, yeoman 2
4234648 2107665 2107665 defendant Roberd John husbandman 628156 628156 Roberd, John, of Herstmounceux, husbandman 0
4236886 2108477 2108477 defendant Woldridge Edward husbandman 628156 628156 Woldridge, Edward, of Herstmounceux, husbandman 0
4249412 2112789 2112789 defendant Fassett Elizabeth widow 628156 628156 Fassett, Elizabeth, of Herstmounceux, widow 0
4253096 2114032 2114032 defendant Hemsley Edward yeoman 628156 628156 Hemsley, Edward, of Herstmounceux, yeoman 0
4253097 2114032 2114032 defendant Whyte Mathew husbandman 628156 628156 Whyte, Mathew, of Herstmounceux, husbandman 1
4253098 2114032 2114032 defendant Wynter John yeoman 628156 628156 Wynter, John, of Herstmounceux, yeoman 2
4255406 2114804 2114804 defendant Salter Thomas yeoman 628156 628156 Salter, Thomas, of Herstmounceux, yeoman 2
4266984 2118598 2118598 defendant Landes William (legal representative) 628156 628156 Landes, William, of Herstmounceux, yeoman, executrix of 0
4266985 2118598 2118598 defendant Landes Elizabeth widow 628156 628156 Landes, Elizabeth, of Herstmounceux, widow 1
4272330 2120318 2120318 defendant Franche Thomas yeoman 628156 628156 Franche, Thomas, of Herstmounceux, yeoman 2
4286619 2125260 2125260 defendant Smyth Samuel yeoman 628156 628156 (Smyth, Samuel, of Herstmounceux, yeoman 1
4317502 2136237 2136237 defendant Parker Simon yeoman 628156 628156 Parker, Simon, of Herstmounceux, yeoman 0
4317503 2136237 2136237 defendant Tree or A Tree John schoolmaster 628156 628156 Tree or A Tree, John, of Herstmounceux, yeoman, schoolmaster 1
4318714 2136655 2136655 defendant Asselden Thomas yeoman 628156 628156 Asselden, Thomas, of Herstmounceux, yeoman 0
4318965 2136747 2136747 defendant Lusted Gregory husbandman 628156 628156 Lusted, Gregory, of Herstmounceux, husbandman 0
4322620 2137980 2137980 defendant Rogers alias Masters Richard husbandman 628156 628156 Rogers alias Masters, Richard, of Herstmounceux, husbandman 1
4323352 2138228 2138228 defendant Somner John tailor 628156 628156 Somner, John, of Herstmounceux, tailor 2
4323353 2138228 2138228 defendant Chilley John yeoman 628156 628156 Chilley, John, of Herstmounceux, yeoman 3
4327106 2139399 2139399 defendant Hemsley Edward yeoman 628156 628156 Hemsley, Edward, of Herstmounceux, yeoman 0
4328616 2139885 2139885 defendant Feilde or Afelde Robert husbandman 628156 628156 Feilde or Afelde, Robert, of Herstmounceux, husbandman 0
4330455 2140484 2140484 defendant Hemsley Edward yeoman 628156 628156 Hemsley, Edward, of Herstmounceux, yeoman 0
4331110 2140704 2140704 defendant Hemsley Edward yeoman 628156 628156 Hemsley, Edward, of Herstmounceux, yeoman 0
4359076 2150409 2150409 defendant Rogers alias Masters Richard yeoman 628156 628156 Rogers alias Masters, Richard, of Herstmounceux, yeoman 0
4359588 2150591 2150591 defendant Rogers alias Masters Richard yeoman 628156 628156 Rogers alias Masters, Richard, of Herstmounceux, yeoman 0
4364651 2152416 2152416 defendant Affelde Robert husbandman 628156 628156 Affelde, Robert, of Herstmounceux, husbandman 0
4364652 2152416 2152416 defendant Knobbe Stephen yeoman 628156 628156 Knobbe, Stephen, of Herstmounceux, yeoman 1
4365328 2152664 2152664 defendant Taylor James yeoman 628156 628156 Taylor, James, of Herstmounceux, yeoman 0
4366709 2153142 2153142 defendant Knabb Stephen tanner 628156 628156 Knabb, Stephen, of Herstmounceux, tanner 0
4366711 2153143 2153143 defendant Knabb Stephen tanner 628156 628156 Knabb, Stephen, of Herstmounceux, tanner 0
4366712 2153143 2153143 defendant Cheley or Chillie John yeoman 628156 628156 Cheley or Chillie, John, of Herstmounceux, yeoman 1
4366713 2153143 2153143 defendant Moyse Giles husbandman 628156 628156 Moyse, Giles, of Herstmounceux, husbandman 2
4366718 2153144 2153144 defendant Feild or Affeild Robert yeoman 628156 628156 Feild or Affeild, Robert, of Herstmounceux, yeoman 1
4369995 2154324 2154324 defendant Smyth John laborer 628156 628156 Smyth, John, of Herstmounceux, laborer 0
4371117 2154730 2154730 defendant Hopkyns William husbandman 628156 628156 Hopkyns, William, of Herstmounceux, husbandman 1
4373132 2155458 2155458 defendant Hollocke William yeoman 628156 628156 Hollocke, William, of Herstmounceux, yeoman 0
4374076 2155799 2155799 defendant Waters Nicholas tanner 628156 628156 Waters, Nicholas, of Herstmounceux, tanner 0
4376319 2156600 2156600 defendant Knall Stephem tanner 628156 628156 Knall, Stephem, of Herstmounceux, tanner 0
4376320 2156600 2156600 defendant Woodland John butcher 628156 628156 Woodland, John, of Herstmounceux, butcher 1
4376321 2156600 2156600 defendant Clyfton Thomas tanner 628156 628156 Clyfton, Thomas, of Herstmounceux, tanner 2
4376788 2156768 2156768 defendant Hempslie Edward yeoman 628156 628156 Hempslie, Edward, of Herstmounceux, yeoman 0
4391894 2161914 2161914 defendant Fielde Robert yeoman 628156 628156 Fielde, Robert, of Herstmounceux, yeoman 0
4401449 2165080 2165080 defendant Hollock William yeoman 628156 628156 Hollock, William, of Herstmounceux, yeoman 0
4401450 2165080 2165080 defendant Parrott John tanner 628156 628156 Parrott, John, of Herstmounceux, tanner 1
4401451 2165080 2165080 defendant Hayward Richard husbandman 628156 628156 Hayward, Richard, of Herstmounceux, husbandman 2
4402591 2165452 2165452 defendant Farmor John butcher 628156 628156 Farmor, John, of Herstmounceux, butcher 0
4406035 2166587 2166587 defendant Colbrond Alice widow 628156 628156 Colbrond, Alice, of Herstmounceux, widow 0
4864256 2315797 2315797 defendant Adam Richard laborer 628156 628156 Adam, Richard, of Herstmounceux, laborer 3
4864257 2315797 2315797 defendant Pull Thomas husbandman 628156 628156 Pull, Thomas, of Herstmounceux, husbandman 4
4864258 2315797 2315797 defendant Wanmer or Waumer William laborer 628156 628156 Wanmer or Waumer, William, of Herstmounceux, laborer 5
4980908 2351226 2351226 defendant Adam Richard husbandman 628156 628156 Adam, Richard, of Herstmounceux, husbandman 0
5032392 2366352 2366352 defendant Gildregge Robert husbandman 628156 628156 Gildregge, Robert, of Herstmounceux, husbandman 2
5048020 2371028 2371028 defendant Adam Richard husbandman 628156 628156 Adam, Richard, of Herstmounceux, husbandman 0
5048021 2371028 2371028 defendant Croucher John husbandman 628156 628156 Croucher, John, of Herstmounceux, husbandman 1
5068416 2377051 2377051 defendant Fenys Robert esq 628156 628156 Fenys, Robert, of Herstmounceux, esq 2
5084856 2381974 2381974 defendant Fenys Richard   628156 628156 Fenys, Richard, of Herstmounceux, knight 1
5092908 2384309 2384309 defendant Fenys Robert esq 628156 628156 Fenys, Robert, of Herstmounceux, esq 2
5208576 2418237 2418237 defendant Fenys Richard   628156 628156 Fenys, Richard, of Herstmounceux, knight 0
5224335 2422793 2422793 defendant Fenys Richard   628156 628156 Fenys, Richard, of Herstmounceux, knight 0
5399923 2475070 2475070 plaintiff Fenys Richard esq 628156 628156 Fenys, Richard, of Herstmounceux, esq 0
5399924 2475070 2475070 plaintiff Lynche John yeoman 628156 628156 Lynche, John, of Herstmounceux, 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);