names

89 rows where place_id = 602707

✎ 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
3651357 1910790 1910790 defendant Okeley Thomas   602707 602707 Okeley, Thomas, of Kyngesclere, shingle maker 0
3651358 1910790 1910790 defendant Pyson Alice widow 602707 602707 Pyson, Alice, of Kyngesclere, widow 1
3651360 1910791 1910791 defendant Okeley Thomas   602707 602707 Okeley, Thomas, of Kyngesclere, shingle maker 0
3651361 1910791 1910791 defendant Pyson Alice widow 602707 602707 Pyson, Alice, of Kyngesclere, widow 1
3712031 1930082 1930082 defendant Wigmore William yeoman 602707 602707 Wigmore, William, of Kyngesclere, yeoman 0
3714458 1930816 1930816 defendant Wayte William husbandman 602707 602707 Wayte, William, of Kyngesclere, husbandman 0
3714459 1930816 1930816 defendant Wygmore William husbandman 602707 602707 Wygmore, William, of Kyngesclere, husbandman 1
3739594 1938597 1938597 defendant Myllet Thomas husbandman 602707 602707 Myllet, Thomas, of Kyngesclere, husbandman 0
3772109 1948968 1948968 defendant Wygmore Thomas innholder 602707 602707 Wygmore, Thomas, of Kyngesclere, innholder 0
3772110 1948968 1948968 defendant Wygmore William husbandman 602707 602707 Wygmore, William, of Kyngesclere, husbandman 1
3775419 1950057 1950057 defendant Wygmer William husbandman 602707 602707 Wygmer, William, of Kyngesclere, husbandman 0
3775420 1950057 1950057 defendant Nutt John husbandman 602707 602707 Nutt, John, of Kyngesclere, husbandman 1
3779649 1951365 1951365 defendant Wigmore William husbandman 602707 602707 Wigmore, William, of Kyngesclere, husbandman 0
3793024 1955677 1955677 defendant Nutt John husbandman 602707 602707 Nutt, John, of Kyngesclere, husbandman 0
3808479 1960530 1960530 defendant Bener or Bever John yeoman 602707 602707 Bener or Bever, John, of Kyngesclere, yeoman 0
3836334 1969271 1969271 defendant Mychell alias Bacheler Ingelram yeoman 602707 602707 Mychell alias Bacheler, Ingelram, of Kyngesclere, yeoman 0
3836335 1969271 1969271 defendant West John innholder 602707 602707 West, John, of Kyngesclere, innholder 1
3836337 1969271 1969271 defendant Provest John cordwainer 602707 602707 Provest, John, of Kyngesclere, cordwainer 3
3836340 1969272 1969272 defendant West John innholder 602707 602707 West, John, of Kyngesclere, innholder 1
3836341 1969272 1969272 defendant Toby Simon yeoman 602707 602707 Toby, Simon, of Kyngesclere, yeoman 2
3836342 1969272 1969272 defendant Provest John cordwainer 602707 602707 Provest, John, of Kyngesclere, cordwainer 3
3880705 1983810 1983810 defendant Boxhed Stephen husbandman 602707 602707 Boxhed, Stephen, of Kyngesclere, husbandman 0
3901564 1990747 1990747 defendant Atfyld John husbandman 602707 602707 Atfyld, John, of Kyngesclere, husbandman 0
3974994 2015816 2015816 defendant Holloway Richard innholder 602707 602707 Holloway, Richard, of Kyngesclere, innholder 0
3988624 2020673 2020673 defendant Myllett William chapman 602707 602707 Myllett, William, of Kyngesclere, chapman 0
3988717 2020709 2020709 defendant Baker William yeoman 602707 602707 Baker, William, of Kyngesclere, yeoman 0
4469689 2191188 2191188 plaintiff Boteller John   602707 602707 Boteller, John, of Kyngesclere 0
4484383 2195810 2195810 defendant Byghenham Godfrey   602707 602707 Byghenham, Godfrey, of Kyngesclere 6
4486459 2196475 2196475 defendant Esse John   602707 602707 Esse, John, of Kyngesclere 2
4578862 2224870 2224870 defendant Byenham Philip   602707 602707 Byenham, Philip, of Kyngesclere 0
4656866 2248044 2248044 defendant Kachefrenshe William husbandman 602707 602707 Kachefrenshe, William, of Kyngesclere, husbandman 0
4657028 2248088 2248088 defendant Smyth Simon husbandman 602707 602707 Smyth, Simon, of Kyngesclere, husbandman 0
4657029 2248088 2248088 defendant Alcestre Thomas cordwainer 602707 602707 Alcestre, Thomas, of Kyngesclere, cordwainer 1
4675091 2257820 2257820 defendant Troney or Trovey John husbandman 602707 602707 Troney or Trovey, John, of Kyngesclere, husbandman 0
4790557 2293138 2293138 defendant Pacy Thomas   602707 602707 Pacy, Thomas, of Kyngesclere 0
4795737 2294817 2294817 defendant Seman John husbandman 602707 602707 Seman, John, of Kyngesclere, husbandman 0
4800037 2296195 2296195 defendant Wheler Thomas wheeler 602707 602707 Wheler, Thomas, of Kyngesclere, wheeler 0
4859827 2314444 2314444 defendant Lane Robert weaver 602707 602707 Lane, Robert, of Kyngesclere, weaver 0
4863450 2315538 2315538 defendant Huberd Thomas weaver 602707 602707 Huberd, Thomas, of Kyngesclere, weaver 0
4864141 2315759 2315759 defendant Merman William husbandman 602707 602707 Merman, William, of Kyngesclere, husbandman 6
4864142 2315759 2315759 defendant Bailly John husbandman 602707 602707 Bailly, John, of Kyngesclere, husbandman 7
4864143 2315759 2315759 defendant Badecok William chapman 602707 602707 Badecok, William, of Kyngesclere, chapman 8
4864144 2315759 2315759 defendant Coteman John Nicholasservant   602707 602707 Coteman, John Nicholasservant, of Kyngesclere, servant 9
4886871 2322746 2322746 defendant Badcok John weaver & chapman 602707 602707 Badcok, John, of Kyngesclere, weaver & chapman 0
4900585 2326825 2326825 defendant Badecok William husbandman 602707 602707 Badecok, William, of Kyngesclere, husbandman 0
4900586 2326825 2326825 defendant Bryggerr William chapman 602707 602707 Bryggerr, William, of Kyngesclere, chapman 1
4955078 2343471 2343471 defendant Baddecok William weaver 602707 602707 Baddecok, William, of Kyngesclere, weaver 1
4955079 2343471 2343471 defendant Briggere William yeoman 602707 602707 Briggere, William, of Kyngesclere, yeoman 2
5013300 2360727 2360727 defendant Hastynges William chaplain 602707 602707 Hastynges, William, of Kyngesclere, chaplain 0
5021116 2363071 2363071 defendant Gylle John husbandman 602707 602707 Gylle, John, of Kyngesclere, husbandman 0
5023988 2363927 2363927 defendant Peion or Peron Simon husbandman 602707 602707 Peion or Peron, Simon, of Kyngesclere, husbandman 0
5030358 2365753 2365753 defendant Seman Thomas (legal representative) 602707 602707 Seman, Thomas, of Kyngesclere, forester, executrix of 0
5031084 2365964 2365964 defendant Turnour John butcher 602707 602707 Turnour, John, of Kyngesclere, butcher 2
5031085 2365964 2365964 defendant Holdepe John laborer 602707 602707 Holdepe, John, of Kyngesclere, laborer 3
5031086 2365964 2365964 defendant Erly Thomas laborer 602707 602707 Erly, Thomas, of Kyngesclere, laborer 4
5031491 2366069 2366069 defendant Turnour John butcher 602707 602707 Turnour, John, of Kyngesclere, butcher 1
5059863 2374516 2374516 defendant Cave Nicholas yeoman 602707 602707 Cave, Nicholas, of Kyngesclere, yeoman 0
5065887 2376319 2376319 defendant Carter John husbandman 602707 602707 Carter, John, of Kyngesclere, husbandman 0
5071167 2377870 2377870 defendant Carter John husbandman 602707 602707 Carter, John, of Kyngesclere, husbandman 0
5081086 2380847 2380847 defendant Smyth Thomas laborer 602707 602707 Smyth, Thomas, of Kyngesclere, laborer 0
5083456 2381549 2381549 defendant West Robert miller 602707 602707 West, Robert, of Kyngesclere, miller 0
5121101 2392602 2392602 defendant Palmer Hugh chapman 602707 602707 Palmer, Hugh, of Kyngesclere, chapman 0
5230014 2424392 2424392 defendant Sterkers Alice widow 602707 602707 Sterkers, Alice, of Kyngesclere, widow 0
5230016 2424392 2424392 defendant Frye John yeoman 602707 602707 Frye, John, of Kyngesclere, yeoman 2
5230017 2424392 2424392 defendant atte Feld John husbandman 602707 602707 atte Feld, John, of Kyngesclere, husbandman 3
5237513 2426555 2426555 defendant Seman Richard smith 602707 602707 Seman, Richard, of Kyngesclere, smith 0
5279598 2439110 2439110 plaintiff Brondesden John   602707 602707 Brondesden, John, of Kyngesclere 0
5290860 2442334 2442334 defendant Swaunton Nicholas   602707 602707 Swaunton, Nicholas, of Kyngesclere 0
5313649 2449109 2449109 defendant Saundyr Robert carpenter 602707 602707 Saundyr, Robert, of Kyngesclere, carpenter 0
5313650 2449109 2449109 defendant Weskham William husbandman 602707 602707 Weskham, William, of Kyngesclere, husbandman 1
5313651 2449109 2449109 defendant Punston John barber 602707 602707 Punston, John, of Kyngesclere, barber 2
5337084 2456167 2456167 defendant Cupper Thomas clerk 602707 602707 Cupper, Thomas, of Kyngesclere, clerk 0
5344510 2458456 2458456 defendant Ronne or Roune Thomas   602707 602707 Ronne or Roune, Thomas, of Kyngesclere, mason 4
5357279 2462339 2462339 defendant Frolbury William smith 602707 602707 Frolbury, William, of Kyngesclere, smith 2
5373844 2467416 2467416 defendant Loveleke Thomas yeoman 602707 602707 Loveleke, Thomas, of Kyngesclere, yeoman 2
5411589 2478422 2478422 defendant Mayewe John mercer 602707 602707 Mayewe, John, of Kyngesclere, mercer 0
5491840 2502466 2502466 defendant Spenser Thomas cordwainer 602707 602707 Spenser, Thomas, of Kyngesclere, cordwainer 0
5495262 2503478 2503478 defendant Edward John butcher 602707 602707 Edward, John, of Kyngesclere, butcher 0
5505485 2506632 2506632 defendant Holdepe John husbandman 602707 602707 Holdepe, John, of Kyngesclere, husbandman 0
5505486 2506632 2506632 defendant Edwardys John husbandman 602707 602707 Edwardys, John, of Kyngesclere, husbandman 1
5518514 2510620 2510620 defendant Holden Nicholas husbandman 602707 602707 Holden, Nicholas, of Kyngesclere, husbandman 3
5520110 2511113 2511113 defendant Felde William yeoman 602707 602707 Felde, William, of Kyngesclere, yeoman 0
5528949 2513575 2513575 defendant Clapham William butcher 602707 602707 Clapham, William, of Kyngesclere, butcher 0
5566646 2524838 2524838 defendant Wyllys William husbandman 602707 602707 Wyllys, William, of Kyngesclere, husbandman 0
5582217 2529511 2529511 defendant Holdepe John innholder 602707 602707 Holdepe, John, of Kyngesclere, innholder 0
5582218 2529511 2529511 defendant Swanton Simon husbandman 602707 602707 Swanton, Simon, of Kyngesclere, husbandman 1
5624895 2551720 2551720 defendant White John weaver 602707 602707 White, John, of Kyngesclere, weaver 2
5628855 2552995 2552995 plaintiff Preest Thomas   602707 602707 Preest, Thomas, of Kyngesclere 0
5629368 2553165 2553165 defendant atte Newelond John husbandman 602707 602707 atte Newelond, John, of Kyngesclere, husbandman 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);