names

73 rows where place_id = 589517

✎ 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
3597843 1866944 1866944 defendant Heweson John gent 589517 589517 Heweson, John, of Wyntryngham, gent 0
3632596 1905013 1905013 defendant Hogeson William fuller 589517 589517 Hogeson, William, of Wyntryngham, fuller 2
3675217 1918283 1918283 defendant Baldyng John yeoman 589517 589517 Baldyng, John, of Wyntryngham, yeoman 0
3723223 1933532 1933532 defendant Langley Peter yeoman 589517 589517 Langley, Peter, of Wyntryngham, yeoman 0
3758007 1944487 1944487 defendant Vaugsy or Vangsy Leonard weaver 589517 589517 Vaugsy or Vangsy, Leonard, of Wyntryngham, weaver 0
3810647 1961228 1961228 defendant Blakston Peter husbandman 589517 589517 Blakston, Peter, of Wyntryngham, husbandman 1
3853020 1974564 1974564 defendant Williamson Robert husbandman 589517 589517 Williamson, Robert, of Wyntryngham, husbandman 2
3928649 1999921 1999921 defendant Bawdewyne William yeoman 589517 589517 Bawdewyne, William, of Wyntryngham, yeoman 0
3943404 2004808 2004808 defendant Hatley Philip husbandman 589517 589517 Hatley, Philip, of Wyntryngham, husbandman 0
4067819 2048802 2048802 defendant Preston alias Cooke William husbandman 589517 589517 Preston alias Cooke, William, of Wyntryngham, husbandman 0
4147951 2077417 2077417 defendant Preston William laborer 589517 589517 Preston, William, of Wyntryngham, laborer 1
4447674 2184195 2184195 plaintiff Dalton Robert de   589517 589517 (Dalton, Robert de, of Wyntryngham, parson 1
4447680 2184196 2184196 plaintiff Dalton Robert de   589517 589517 (Dalton, Robert de, of Wyntryngham, parson 1
4525705 2208339 2208339 plaintiff Mikaell William   589517 589517 Mikaell, William, of Wyntryngham 2
4526533 2208582 2208582 defendant Pasegode Robert   589517 589517 Pasegode, Robert, of Wyntryngham 0
4557284 2218216 2218216 defendant Farley William   589517 589517 Farley, William, of Wyntryngham 0
4579073 2224935 2224935 defendant Croos William   589517 589517 Croos, William, of Wyntryngham 0
4622311 2237958 2237958 defendant Paysgode Robert   589517 589517 Paysgode, Robert, of Wyntryngham 0
4637569 2242539 2242539 plaintiff Bret John   589517 589517 Bret, John, of Wyntryngham 0
4641674 2243667 2243667 defendant Clerk Geoffrey   589517 589517 Clerk, Geoffrey, of Wyntryngham 0
4641675 2243667 2243667 defendant Gisburgh John   589517 589517 Gisburgh, John, of Wyntryngham 1
4641677 2243668 2243668 defendant Kendale William   589517 589517 Kendale, William, of Wyntryngham 0
4661090 2249292 2249292 defendant Kendale William husbandman 589517 589517 Kendale, William, of Wyntryngham, husbandman 2
4684360 2260714 2260714 defendant Kendale William yeoman 589517 589517 Kendale, William, of Wyntryngham, yeoman 0
4684361 2260714 2260714 defendant Whyttekirke Thomas husbandman 589517 589517 Whyttekirke, Thomas, of Wyntryngham, husbandman 1
4718689 2271185 2271185 defendant Akke Robert husbandman 589517 589517 Akke, Robert, of Wyntryngham, husbandman 0
4718690 2271185 2271185 defendant Whitekirk Thomas husbandman 589517 589517 Whitekirk, Thomas, of Wyntryngham, husbandman 1
4718692 2271185 2271185 defendant Spenser Thomas husbandman 589517 589517 Spenser, Thomas, of Wyntryngham, husbandman 3
4724955 2273098 2273098 defendant Pert William chaplain 589517 589517 Pert, William, of Wyntryngham, chaplain 0
4736539 2276559 2276559 plaintiff Tebbeson John   589517 589517 Tebbeson, John, of Wyntryngham 0
4779533 2289579 2289579 defendant Hamlyne Thomas husbandman 589517 589517 Hamlyne, Thomas, of Wyntryngham, husbandman 0
4810831 2299512 2299512 defendant Kaa Peter husbandman 589517 589517 Kaa, Peter, of Wyntryngham, husbandman 1
4810832 2299512 2299512 defendant Skelton Thomas tailor 589517 589517 Skelton, Thomas, of Wyntryngham, tailor 2
4827150 2304537 2304537 defendant Hamelyn John husbandman 589517 589517 Hamelyn, John, of Wyntryngham, husbandman 0
4889100 2323381 2323381 defendant Perys John husbandman 589517 589517 Perys, John, of Wyntryngham, husbandman 1
4897455 2325866 2325866 defendant Bolston Gilbert husbandman 589517 589517 Bolston, Gilbert, of Wyntryngham, husbandman 0
4906127 2328508 2328508 defendant Peers John husbandman 589517 589517 Peers, John, of Wyntryngham, husbandman 0
4908632 2329253 2329253 defendant Maille William husbandman 589517 589517 Maille, William, of Wyntryngham, husbandman 2
4940519 2339059 2339059 defendant Aky Richard husbandman 589517 589517 Aky, Richard, of Wyntryngham, husbandman 1
4955369 2343563 2343563 defendant Dryng John husbandman 589517 589517 Dryng, John, of Wyntryngham, husbandman 0
5008462 2359368 2359368 defendant Dryng John husbandman 589517 589517 Dryng, John, of Wyntryngham, husbandman 0
5014022 2360955 2360955 defendant Waterman John husbandman 589517 589517 Waterman, John, of Wyntryngham, husbandman 1
5016393 2361687 2361687 defendant Dryng Thomas husbandman 589517 589517 Dryng, Thomas, of Wyntryngham, husbandman 3
5087048 2382592 2382592 defendant Baldyng John merchant 589517 589517 Baldyng, John, of Wyntryngham, merchant 1
5088385 2382978 2382978 defendant Baldyng John merchant of the staple 589517 589517 Baldyng, John, of Wyntryngham, merchant of the staple 0
5091874 2384004 2384004 defendant Nebard William merchant 589517 589517 Nebard, William, of Wyntryngham, merchant 1
5091875 2384004 2384004 defendant Asheby Robert merchant 589517 589517 Asheby, Robert, of Wyntryngham, merchant 2
5101272 2386781 2386781 defendant Waterman John husbandman 589517 589517 Waterman, John, of Wyntryngham, husbandman 2
5112113 2389926 2389926 defendant Male William yeoman 589517 589517 Male, William, of Wyntryngham, yeoman 0
5125853 2394048 2394048 plaintiff Bellerby John clerk & parson 589517 589517 Bellerby, John, of Wyntryngham, clerk & parson 0
5144457 2399539 2399539 plaintiff Bellerby John clerk & parson 589517 589517 Bellerby, John, of Wyntryngham, clerk & parson 0
5165297 2405595 2405595 plaintiff Bellerby John clerk & parson 589517 589517 Bellerby, John, of Wyntryngham, clerk & parson 0
5179188 2409649 2409649 plaintiff Bellerby John clerk & parson 589517 589517 Bellerby, John, of Wyntryngham, clerk & parson 0
5198397 2415284 2415284 defendant Mayll William husbandman 589517 589517 Mayll, William, of Wyntryngham, husbandman 0
5234210 2425594 2425594 defendant Norman Alexander (legal representative) 589517 589517 Norman, Alexander, of Wyntryngham, executors of 1
5283930 2440331 2440331 defendant Petyte Thomas yeoman 589517 589517 Petyte, Thomas, of Wyntryngham, yeoman 0
5283931 2440331 2440331 defendant Spenythorn John yeoman 589517 589517 Spenythorn, John, of Wyntryngham, yeoman 1
5283932 2440331 2440331 defendant Cartwrite John yeoman 589517 589517 Cartwrite, John, of Wyntryngham, yeoman 2
5283933 2440331 2440331 defendant Pyburn Thomas yeoman 589517 589517 Pyburn, Thomas, of Wyntryngham, yeoman 3
5283934 2440331 2440331 defendant Trougton William yeoman 589517 589517 Trougton, William, of Wyntryngham, yeoman 4
5321810 2451598 2451598 defendant Jamys John laborer 589517 589517 Jamys, John, of Wyntryngham, laborer 0
5348765 2459740 2459740 defendant Troughton William yeoman 589517 589517 Troughton, William, of Wyntryngham, yeoman 1
5348769 2459741 2459741 defendant Troughton William yeoman 589517 589517 Troughton, William, of Wyntryngham, yeoman 1
5348773 2459742 2459742 defendant Troughton William yeoman 589517 589517 Troughton, William, of Wyntryngham, yeoman 1
5367370 2465451 2465451 defendant Yonge John mariner 589517 589517 Yonge, John, of Wyntryngham, mariner 1
5411954 2478531 2478531 defendant Baldyng John husbandman 589517 589517 Baldyng, John, of Wyntryngham, husbandman 0
5411955 2478531 2478531 defendant Robynson Thomas husbandman 589517 589517 Robynson, Thomas, of Wyntryngham, husbandman 1
5412537 2478695 2478695 defendant Pete Thomas yeoman 589517 589517 Pete, Thomas, of Wyntryngham, yeoman 0
5427366 2483128 2483128 defendant Pete Thomas yeoman 589517 589517 Pete, Thomas, of Wyntryngham, yeoman 0
5445163 2488442 2488442 defendant Pete Thomas yeoman 589517 589517 Pete, Thomas, of Wyntryngham, yeoman 0
5457829 2492238 2492238 defendant Pete Thomas yeoman 589517 589517 Pete, Thomas, of Wyntryngham, yeoman 0
5548698 2519664 2519664 defendant Wryght Richard carpenter 589517 589517 Wryght, Richard, of Wyntryngham, carpenter 0
5550596 2520199 2520199 defendant Pety Richard husbandman 589517 589517 Pety, Richard, of Wyntryngham, husbandman 3

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