names

66 rows where place_id = 593579

✎ 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
3612425 1871514 1871514 defendant Gybson Thomas husbandman 593579 593579 Gybson, Thomas, of Staveley, husbandman 0
3737773 1938035 1938035 defendant Warde Isabel gentlewoman 593579 593579 Warde, Isabel, of Staveley, gentlewoman 2
3783727 1952674 1952674 defendant Leynfete Thomas mercer 593579 593579 Leynfete, Thomas, of Staveley, mercer 1
3821118 1964500 1964500 plaintiff Rodes Richard husbandman 593579 593579 Rodes, Richard, of Staveley, husbandman 0
3861882 1977433 1977433 defendant Oxley Henry yeoman 593579 593579 Oxley, Henry, of Staveley, yeoman 0
3880274 1983656 1983656 defendant Jopson Matthew sherman 593579 593579 Jopson, Matthew, of Staveley, sherman 2
3880278 1983657 1983657 defendant Jopson Matthew sherman 593579 593579 Jopson, Matthew, of Staveley, sherman 2
3891419 1987397 1987397 defendant Hey John husbandman 593579 593579 Hey, John, of Staveley, husbandman 0
3891422 1987398 1987398 defendant Bromehed Thomas chaplain 593579 593579 Bromehed, Thomas, of Staveley, chaplain 0
3921472 1997525 1997525 defendant Hey John yeoman 593579 593579 Hey, John, of Staveley, yeoman 0
3921473 1997525 1997525 defendant Smyth Henry laborer 593579 593579 Smyth, Henry, of Staveley, laborer 1
3921479 1997526 1997526 defendant Hey John yeoman 593579 593579 Hey, John, of Staveley, yeoman 0
3921480 1997526 1997526 defendant Smyth Henry laborer 593579 593579 Smyth, Henry, of Staveley, laborer 1
3946460 2005829 2005829 defendant Bateman John sherman 593579 593579 Bateman, John, of Staveley, sherman 1
3985611 2019618 2019618 defendant Jepson Renginald or Randle husbandman 593579 593579 Jepson, Renginald or Randle, of Staveley, husbandman 2
3990452 2021337 2021337 plaintiff Birkhed Nicholas yeoman 593579 593579 Birkhed, Nicholas, of Staveley, yeoman 0
3990455 2021338 2021338 plaintiff Birkhed Nicholas yeoman 593579 593579 Birkhed, Nicholas, of Staveley, yeoman 0
4064480 2047576 2047576 plaintiff Gybson Edward gent 593579 593579 Gybson, Edward, of Staveley, gent 1
4101926 2061001 2061001 defendant Calowe Francis yeoman 593579 593579 Calowe, Francis, of Staveley, or of Sutton in le Deale, yeoman 0
4114501 2065473 2065473 defendant Bateman Nicholas yeoman 593579 593579 Bateman, Nicholas, of Staveley, yeoman 1
4156743 2080436 2080436 defendant Thornelley Richard carpenter 593579 593579 Thornelley, Richard, of Staveley, carpenter 3
4164224 2083012 2083012 defendant Thornelley Richard carpenter 593579 593579 Thornelley, Richard, of Staveley, carpenter 2
4182259 2089272 2089272 defendant Smyth George sherman 593579 593579 Smyth, George, of Staveley, sherman 1
4293481 2127731 2127731 defendant Hitche Robert yeoman 593579 593579 Hitche, Robert, of Staveley, yeoman 1
4341974 2144474 2144474 defendant Cryton Richard husbandman 593579 593579 Cryton, Richard, of Staveley, husbandman 0
4342159 2144539 2144539 defendant Noble Richard husbandman 593579 593579 Noble, Richard, of Staveley, husbandman 1
4345051 2145544 2145544 defendant Jopson John husbandman 593579 593579 Jopson, John, of Staveley, husbandman 1
4392334 2162063 2162063 defendant Potter Christopher husbandman 593579 593579 Potter, Christopher, of Staveley, husbandman 2
4462698 2189035 2189035 plaintiff Thomasson John   593579 593579 Thomasson, John, of Staveley 0
4513586 2204674 2204674 defendant Souter Henry   593579 593579 Souter, Henry, of Staveley 0
4539094 2212498 2212498 defendant Bateman John   593579 593579 Bateman, John, of Staveley 1
4539095 2212498 2212498 defendant Bateman William   593579 593579 Bateman, William, of Staveley 2
4564155 2220360 2220360 defendant Capper John   593579 593579 Capper, John, of Staveley 2
4587936 2227626 2227626 defendant Selby Thomas, sen   593579 593579 Selby, Thomas, sen, of Staveley 3
4619350 2237046 2237046 defendant Hanson Robert   593579 593579 Hanson, Robert, of Staveley 0
4625306 2238882 2238882 defendant Norton Ankerus   593579 593579 Norton, Ankerus, of Staveley 0
4650066 2246033 2246033 defendant Innocent Richard   593579 593579 Innocent, Richard, of Staveley 3
4698734 2265087 2265087 defendant G_ John laborer 593579 593579 G_, John, of Staveley, laborer 1
4729345 2274396 2274396 defendant Taylboys John   593579 593579 Taylboys, John, of Staveley, parson 0
4760349 2283590 2283590 defendant Jonson Jopson Robert yeoman 593579 593579 Jonson Jopson, Robert, of Staveley, yeoman 0
4760350 2283590 2283590 defendant Jonson Jopson John yeoman 593579 593579 Jonson Jopson, John, of Staveley, yeoman 1
4788209 2292383 2292383 defendant Rook John yeoman 593579 593579 Rook, John, of Staveley, yeoman 2
4835697 2307161 2307161 plaintiff Dowe Richard   593579 593579 Dowe, Richard, of Staveley, parson of half the church 0
4943688 2339992 2339992 defendant Forman William husbandman 593579 593579 Forman, William, of Staveley, husbandman 16
4954295 2343256 2343256 defendant Burnet Thomas husbandman 593579 593579 Burnet, Thomas, of Staveley, husbandman 0
5047443 2370857 2370857 defendant Byrkehed Robert, senior yeoman 593579 593579 Byrkehed, Robert, senior, of Staveley, yeoman 0
5094267 2384729 2384729 defendant Webster John husbandman 593579 593579 Webster, John, of Staveley, husbandman 1
5112715 2390108 2390108 defendant Brykhede Hugh husbandman 593579 593579 Brykhede, Hugh, of Staveley, husbandman 0
5185758 2411582 2411582 defendant Myrfeld Thomas clerk 593579 593579 Myrfeld, Thomas, of Staveley, clerk 0
5236860 2426363 2426363 defendant Whitehede Richard husbandman 593579 593579 Whitehede, Richard, of Staveley, husbandman 0
5236861 2426363 2426363 defendant Whitehede Robert laborer 593579 593579 Whitehede, Robert, of Staveley, laborer 1
5237156 2426452 2426452 defendant Whitehed Richard husbandman 593579 593579 Whitehed, Richard, of Staveley, husbandman 0
5237157 2426452 2426452 defendant Whitehed Robert laborer 593579 593579 Whitehed, Robert, of Staveley, laborer 1
5237159 2426452 2426452 defendant Whitehed Alice widow 593579 593579 Whitehed, Alice, of Staveley, widow 3
5308676 2447630 2447630 defendant Myrfeld Thomas clerk & parson 593579 593579 Myrfeld, Thomas, of Staveley, clerk & parson 0
5352894 2460991 2460991 defendant Sulkholme Edmund laborer 593579 593579 Sulkholme, Edmund, of Staveley, weaver;Plates, Nicholas, of Sutton in le Dale, laborer 2
5387757 2471562 2471562 defendant Mercer William yeoman 593579 593579 Mercer, William, of Staveley, yeoman 0
5509313 2507765 2507765 defendant Marten John, senior husbandman 593579 593579 Marten, John, senior, of Staveley, husbandman 0
5509314 2507765 2507765 defendant Roger Thomas husbandman 593579 593579 Roger, Thomas, of Staveley, husbandman 1
5509315 2507765 2507765 defendant Marten John, junior   593579 593579 Marten, John, junior, of Staveley, cartwright 2
5509316 2507765 2507765 defendant Smyth Robert husbandman 593579 593579 Smyth, Robert, of Staveley, husbandman 3
5536550 2515915 2515915 defendant Chapman Robert husbandman 593579 593579 Chapman, Robert, of Staveley, husbandman 0
5568594 2525365 2525365 defendant Stafford John smithman 593579 593579 Stafford, John, of Staveley, smithman 1
5568595 2525365 2525365 defendant Shentall Robert smithman 593579 593579 Shentall, Robert, of Staveley, smithman 2
5568596 2525365 2525365 defendant Shentall William smithman 593579 593579 Shentall, William, of Staveley, smithman 3
5568597 2525365 2525365 defendant Hasilherst George smithman 593579 593579 Hasilherst, George, of Staveley, smithman 4

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