names

95 rows where place_id = 593245

✎ 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
3611048 1871132 1871132 defendant Frecchevyle Ankero gent 593245 593245 Frecchevyle, Ankero, of Hanley, gent 6
3611078 1871140 1871140 defendant Smyth John husbandman 593245 593245 Smyth, John, of Hanley, husbandman 4
3644303 1908642 1908642 defendant Smyth Thomas yeoman 593245 593245 Smyth, Thomas, of Hanley, yeoman 12
3716660 1931507 1931507 defendant Garde John   593245 593245 Garde, John, of Hanley, "trowman" 3
3730880 1935885 1935885 defendant Lawton John yeoman 593245 593245 Lawton, John, of Hanley, yeoman 0
3730916 1935896 1935896 defendant Savage John, senior   593245 593245 Savage, John, senior, of Hanley, knight 0
3746803 1940919 1940919 defendant Beston Thomas husbandman 593245 593245 Beston, Thomas, of Hanley, husbandman 0
3780170 1951522 1951522 defendant Salsall Thomas husbandman 593245 593245 Salsall, Thomas, of Hanley, husbandman 0
3780171 1951522 1951522 defendant Shele Richard husbandman 593245 593245 Shele, Richard, of Hanley, husbandman 1
3813301 1962072 1962072 defendant Amys Richard yeoman 593245 593245 Amys, Richard, of Hanley, yeoman 0
3813302 1962072 1962072 defendant Amys Elizabeth spinster 593245 593245 Amys, Elizabeth, of Hanley, spinster 1
3849716 1973497 1973497 defendant Bowman Richard husbandman 593245 593245 Bowman, Richard, of Hanley, husbandman 0
3877747 1982796 1982796 defendant Fysshepole Lewis husbandman 593245 593245 Fysshepole, Lewis, of Hanley, husbandman 0
3885288 1985332 1985332 defendant Badyer Roger (legal representative) 593245 593245 Badyer, Roger, of Hanley, yeoman, executors of 0
3885292 1985333 1985333 defendant Badger Roger (legal representative) 593245 593245 Badger, Roger, of Hanley, yeoman, executors of 0
3909134 1993352 1993352 defendant Howton John husbandman 593245 593245 Howton, John, of Hanley, husbandman 1
3927875 1999662 1999662 defendant Morgan Thomas yeoman 593245 593245 Morgan, Thomas, of Hanley, yeoman 0
3964880 2012320 2012320 defendant Whytby James husbandman 593245 593245 Whytby, James, of Hanley, husbandman 0
3964881 2012320 2012320 defendant Sheffeld George husbandman 593245 593245 Sheffeld, George, of Hanley, husbandman 1
3964882 2012320 2012320 defendant Powell William husbandman 593245 593245 Powell, William, of Hanley, husbandman 2
4045536 2040854 2040854 defendant Hardyman William husbandman 593245 593245 Hardyman, William, of Hanley, husbandman 1
4045537 2040854 2040854 defendant Laurens alias Collens John husbandman 593245 593245 Laurens alias Collens, John, of Hanley, husbandman 2
4045538 2040854 2040854 defendant Tovye William husbandman 593245 593245 Tovye, William, of Hanley, husbandman 3
4045539 2040854 2040854 defendant Thorne Thomas husbandman 593245 593245 Thorne, Thomas, of Hanley, husbandman 4
4046109 2041046 2041046 defendant Etches John husbandman 593245 593245 Etches, John, of Hanley, husbandman 1
4046113 2041047 2041047 defendant Etches John husbandman 593245 593245 Etches, John, of Hanley, husbandman 1
4081989 2053859 2053859 defendant Dryver William yeoman 593245 593245 Dryver, William, of Hanley, yeoman 0
4147033 2077107 2077107 defendant Gayley John joiner 593245 593245 Gayley, John, of Hanley, joiner 0
4149841 2078071 2078071 defendant Hanley Thomas yeoman 593245 593245 Hanley, Thomas, of Hanley, yeoman 1
4171994 2085667 2085667 defendant Gayley or Gayle John joiner 593245 593245 Gayley or Gayle, John, of Hanley, joiner 0
4171996 2085668 2085668 defendant Gayley John joiner 593245 593245 Gayley, John, of Hanley, joiner 0
4182187 2089250 2089250 defendant Tuston John husbandman 593245 593245 Tuston, John, of Hanley, husbandman 0
4182188 2089250 2089250 defendant Cale Thomas yeoman 593245 593245 Cale, Thomas, of Hanley, yeoman 1
4182189 2089250 2089250 defendant Lathwood Richard butcher 593245 593245 Lathwood, Richard, of Hanley, butcher 2
4242182 2110378 2110378 defendant Saunders Ralph tailor 593245 593245 Saunders, Ralph, of Hanley, tailor 2
4243540 2110827 2110827 defendant Thorne John husbandman 593245 593245 Thorne, John, of Hanley, husbandman 2
4246805 2111907 2111907 defendant Dyngeley Henry gent 593245 593245 Dyngeley, Henry, of Hanley, gent 0
4379416 2157717 2157717 defendant Butler John gent 593245 593245 Butler, John, of Hanley, gent 3
4396462 2163391 2163391 defendant Dyngley Henry gent 593245 593245 Dyngley, Henry, of Hanley, gent 1
4396463 2163391 2163391 defendant Hunt John yeoman 593245 593245 Hunt, John, of Hanley, yeoman 2
4554833 2217437 2217437 defendant Penne Robert   593245 593245 Penne, Robert, of Hanley 0
4648692 2245672 2245672 defendant Peresson John grobber 593245 593245 Peresson, John, of Hanley, grobber 0
4662304 2249684 2249684 plaintiff Forster Nicholas chaplain 593245 593245 Forster, Nicholas, of Hanley, chaplain 0
4662305 2249684 2249684 defendant Hugges Henry, senior husbandman 593245 593245 Hugges, Henry, senior, of Hanley, husbandman 0
4662306 2249684 2249684 defendant Hugges Henry, junior husbandman 593245 593245 Hugges, Henry, junior, of Hanley, husbandman 1
4672551 2257061 2257061 defendant Hardeman John clothmaker 593245 593245 Hardeman, John, of Hanley, clothmaker 0
4681343 2259787 2259787 defendant Lyly John husbandman 593245 593245 Lyly, John, of Hanley, husbandman 7
4681344 2259787 2259787 defendant Lyly Thomas   593245 593245 Lyly, Thomas, of Hanley, cartwright 8
4681345 2259787 2259787 defendant Willeson Roger husbandman 593245 593245 Willeson, Roger, of Hanley, husbandman 9
4734593 2275983 2275983 defendant Benet William   593245 593245 Benet, William, of Hanley 1
4784175 2291050 2291050 defendant Hotot Geoffrey baker 593245 593245 Hotot, Geoffrey, of Hanley, baker 0
4794898 2294550 2294550 defendant Hardyman John husbandman 593245 593245 Hardyman, John, of Hanley, husbandman 3
4794903 2294551 2294551 defendant Hardyman John husbandman 593245 593245 Hardyman, John, of Hanley, husbandman 3
4813174 2300235 2300235 defendant Fowere John yeoman 593245 593245 Fowere, John, of Hanley, yeoman 1
4855978 2313243 2313243 defendant Cokkys John husbandman 593245 593245 Cokkys, John, of Hanley, husbandman 0
4855980 2313243 2313243 defendant Wodeman William laborer 593245 593245 Wodeman, William, of Hanley, laborer 2
4855982 2313243 2313243 defendant Peyntour Robert painter 593245 593245 Peyntour, Robert, of Hanley, painter 4
4857097 2313599 2313599 defendant Cornyssh John   593245 593245 Cornyssh, John, of Hanley, servant 2
4954326 2343264 2343264 defendant Wilson Thomas husbandman 593245 593245 Wilson, Thomas, of Hanley, husbandman 2
5025845 2364458 2364458 defendant Whetecroft William husbandman 593245 593245 Whetecroft, William, of Hanley, husbandman 6
5050195 2371681 2371681 defendant Blake William   593245 593245 Blake, William, of Hanley, groom 1
5050199 2371681 2371681 defendant Bonde John husbandman 593245 593245 Bonde, John, of Hanley, husbandman 5
5054677 2372975 2372975 defendant Wolwaye John husbandman 593245 593245 Wolwaye, John, of Hanley, husbandman 3
5089955 2383443 2383443 defendant Amys Richard husbandman 593245 593245 Amys, Richard, of Hanley, husbandman 4
5096259 2385343 2385343 defendant Fyssher William yeoman 593245 593245 Fyssher, William, of Hanley, yeoman 1
5129832 2395212 2395212 defendant Sexteyn Richard yeoman 593245 593245 Sexteyn, Richard, of Hanley, yeoman 2
5131748 2395769 2395769 defendant Moresby Richard gent 593245 593245 Moresby, Richard, of Hanley, gent 2
5140008 2398180 2398180 defendant Edmondes John yeoman 593245 593245 Edmondes, John, of Hanley, yeoman 0
5140012 2398182 2398182 defendant Edmondes John yeoman 593245 593245 Edmondes, John, of Hanley, yeoman 0
5146694 2400171 2400171 defendant Payn Richard husbandman 593245 593245 Payn, Richard, of Hanley, husbandman 0
5146696 2400171 2400171 defendant Wolley John (legal representative) 593245 593245 Wolley, John, of Hanley, husbandman, executors of 2
5166705 2405986 2405986 defendant Payn Richard husbandman 593245 593245 Payn, Richard, of Hanley, husbandman 0
5183934 2411037 2411037 defendant Sexteyn Richard yeoman 593245 593245 Sexteyn, Richard, of Hanley, yeoman 2
5216147 2420452 2420452 defendant Claye William husbandman 593245 593245 Claye, William, of Hanley, husbandman 1
5240706 2427492 2427492 defendant Peyntour Robert painter 593245 593245 Peyntour, Robert, of Hanley, painter 0
5240714 2427495 2427495 defendant Peyntour Robert painter 593245 593245 Peyntour, Robert, of Hanley, painter 0
5296645 2444005 2444005 defendant Crosland John husbandman 593245 593245 Crosland, John, of Hanley, husbandman 1
5296646 2444005 2444005 defendant Stoon Richard husbandman 593245 593245 Stoon, Richard, of Hanley, husbandman 2
5297813 2444367 2444367 defendant Laweton John husbandman 593245 593245 Laweton, John, of Hanley, husbandman 0
5306244 2446851 2446851 defendant Hale John   593245 593245 Hale, John, of Hanley 0
5309064 2447746 2447746 defendant Purch_ Thomas smith 593245 593245 Purch_, Thomas, of Hanley, smith 4
5314425 2449341 2449341 defendant Turnour William smith 593245 593245 Turnour, William, of Hanley, smith 2
5390573 2472367 2472367 defendant Crosseland Thomas husbandman 593245 593245 Crosseland, Thomas, of Hanley, husbandman 1
5393799 2473285 2473285 defendant Bodyll John husbandman 593245 593245 Bodyll, John, of Hanley, husbandman 0
5409476 2477799 2477799 defendant Cornewayll Roger laborer 593245 593245 Cornewayll, Roger, of Hanley, laborer 2
5409477 2477799 2477799 defendant Webbe Roger laborer 593245 593245 Webbe, Roger, of Hanley, laborer 3
5409481 2477800 2477800 defendant Cornewell Roger laborer 593245 593245 Cornewell, Roger, of Hanley, laborer 2
5409482 2477800 2477800 defendant Webbe Roger laborer 593245 593245 Webbe, Roger, of Hanley, laborer 3
5480143 2499043 2499043 defendant Lechemer Richard yeoman 593245 593245 Lechemer, Richard, of Hanley, yeoman 3
5483979 2500143 2500143 defendant Frewyn Roger yeoman 593245 593245 (Frewyn, Roger, of Hanley, yeoman 4
5518962 2510771 2510771 defendant Rowley Thomas yeoman 593245 593245 Rowley, Thomas, of Hanley, yeoman 0
5577085 2527881 2527881 defendant Garde Thomas husbandman 593245 593245 Garde, Thomas, of Hanley, husbandman 0
5591569 2532342 2532342 defendant Wager Richard carver 593245 593245 Wager, Richard, of Hanley, carver 0
5593326 2532890 2532890 defendant Heldey Lawrence husbandman 593245 593245 Heldey, Lawrence, of Hanley, husbandman 1
5605794 2536701 2536701 defendant Savage John   593245 593245 Savage, John, of Hanley, knight 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);