names

227 rows where place_id = 587594

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591869 1865076 1865076 defendant Leylond Henry gent 587594 587594 Leylond, Henry, of Manchester, Lancs, gent 4
3654011 1911518 1911518 defendant Tomkynson Thomas clothman 587594 587594 Tomkynson, Thomas, of Manchester, Lancs, clothman 1
3657645 1912651 1912651 defendant Bexwyke Thomas chapman 587594 587594 Bexwyke, Thomas, of Manchester, Lancs, chapman 0
3657659 1912653 1912653 defendant Fell George chapman 587594 587594 Fell, George, of Manchester, Lancs, chapman 1
3660061 1913410 1913410 defendant Bexwyke Thomas mercer 587594 587594 Bexwyke, Thomas, of Manchester, Lancs, mercer 0
3660078 1913414 1913414 defendant Bexwyke Thomas mercer 587594 587594 Bexwyke, Thomas, of Manchester, Lancs, mercer 0
3669801 1916500 1916500 defendant Laverey Robert yeoman of the crown 587594 587594 Laverey, Robert, of Manchester, Lancs, yeoman of the crown 0
3669806 1916501 1916501 defendant Lavery Robert yeoman of the crown 587594 587594 Lavery, Robert, of Manchester, Lancs, yeoman of the crown 0
3669811 1916502 1916502 defendant Lavery Robert yeoman of the crown 587594 587594 Lavery, Robert, of Manchester, Lancs, yeoman of the crown 0
3716251 1931375 1931375 defendant Hulme Stephen   587594 587594 Hulme, Stephen, of Manchester,Lancs, gent, son of Hulme, Ralph 0
3760386 1945253 1945253 defendant Galey John chapman 587594 587594 Galey, John, of Manchester, Lancs, chapman 0
3767101 1947365 1947365 defendant Hulme Stephen gent 587594 587594 Hulme, Stephen, of Manchester, Lancs, gent 3
3789177 1954428 1954428 defendant Bek Edward merchant 587594 587594 Bek, Edward, of Manchester, Lancs, merchant 0
3795448 1956453 1956453 defendant Barker Thomas chapman 587594 587594 Barker, Thomas, of Manchester, Lancs, chapman 0
3809982 1961008 1961008 defendant Froster John merchant 587594 587594 Froster, John, of Manchester, Lancs, merchant 0
3822214 1964851 1964851 defendant Fidler John husbandman 587594 587594 Fidler, John, of Manchester, Lancs, husbandman 0
3822223 1964854 1964854 defendant Fidler John husbandman 587594 587594 Fidler, John, of Manchester, Lancs, husbandman 0
3823478 1965245 1965245 defendant Legh George gent 587594 587594 Legh, George, of Manchester, Lancs, gent 0
3852846 1974498 1974498 defendant Wylde Alexander mercer 587594 587594 Wylde, Alexander, of Manchester, Lancs, mercer 3
3870927 1980525 1980525 defendant Janne Edward draper 587594 587594 Janne, Edward, of Manchester, Lancs, draper 0
3870929 1980526 1980526 defendant Jenne Edmund draper 587594 587594 Jenne, Edmund, of Manchester, Lancs, draper 0
3877881 1982845 1982845 defendant Travys John chapman 587594 587594 (Travys, John, of Manchester, Lancs, chapman 1
3883102 1984609 1984609 defendant Shelmerdyne Elizabeth widow 587594 587594 Shelmerdyne, Elizabeth, of Manchester, Lancs, widow 0
3891470 1987414 1987414 defendant Bek Edward merchant 587594 587594 Bek, Edward, of Manchester, Lancs, merchant 2
3927054 1999387 1999387 defendant Penketh William clerk 587594 587594 Penketh, William, of Manchester, Lancs, clerk 0
3927453 1999528 1999528 defendant Holland Adam draper 587594 587594 Holland, Adam, of Manchester, Lancs, draper 0
3927459 1999529 1999529 defendant Browne Ralph merchant 587594 587594 Browne, Ralph, of Manchester, Lancs, merchant 0
3928898 2000004 2000004 defendant Tetla Gervase chapman 587594 587594 Tetla, Gervase, of Manchester, Lancs, chapman 0
3930212 2000453 2000453 defendant Asshen John mercer 587594 587594 Asshen, John, of Manchester, Lancs, mercer 0
3930856 2000660 2000660 defendant Traves John draper 587594 587594 Traves, John, of Manchester, Lancs, draper 1
3932108 2001043 2001043 defendant Strangwiche William gent 587594 587594 Strangwiche, William, of Manchester, Lancs, gent 3
3932261 2001095 2001095 defendant Nevyle John gent 587594 587594 Nevyle, John, of Manchester, Lancs, gent 2
3932989 2001327 2001327 defendant Adlyngton James   587594 587594 Adlyngton, James, of Manchester, Lancs, point maker 0
3933179 2001392 2001392 defendant Nevyll John gent 587594 587594 Nevyll, John, of Manchester, Lancs, gent 2
3934681 2001894 2001894 defendant Tetlowe Jarvis draper 587594 587594 Tetlowe, Jarvis, of Manchester, Lancs, draper 0
3934973 2002000 2002000 defendant Byswyke Roger chapman 587594 587594 Byswyke, Roger, of Manchester, Lancs, chapman 0
3937780 2002967 2002967 defendant Webstar James chapman 587594 587594 Webstar, James, of Manchester, Lancs, chapman 0
3938480 2003213 2003213 defendant Webster James yeoman 587594 587594 Webster, James, of Manchester, Lancs, yeoman 2
3938484 2003214 2003214 defendant Webster James yeoman 587594 587594 Webster, James, of Manchester, Lancs, yeoman 2
3950510 2007257 2007257 defendant Gee or Gey Ralph chapman 587594 587594 Gee or Gey, Ralph, of Manchester, Lancs, chapman 1
3962881 2011610 2011610 plaintiff Wilson Miles clothier 587594 587594 Wilson, Miles, of Manchester, Lancs, clothier 0
3973723 2015384 2015384 plaintiff Haghton Humphrey clothier 587594 587594 Haghton, Humphrey, of Manchester, Lancs, clothier 0
3973757 2015398 2015398 plaintiff Hall Elias   587594 587594 Hall, Elias, of Manchester, Lancs, merchant, administrators of 0
3973764 2015399 2015399 plaintiff Hall Elias   587594 587594 Hall, Elias, of Manchester, Lancs, merchant, administrators of 0
3973771 2015400 2015400 plaintiff Hall Elias   587594 587594 Hall, Elias, of Manchester, Lancs, merchant, administrators of 0
3973778 2015401 2015401 plaintiff Hall Elias   587594 587594 Hall, Elias, of Manchester, Lancs, merchant, administrators of 0
3975043 2015833 2015833 defendant Janny Edward (legal representative) 587594 587594 Janny, Edward, of Manchester, Lancs, merchant, executor of 0
3975306 2015931 2015931 defendant Smythe George husbandman 587594 587594 Smythe, George, of Manchester, Lancs, husbandman 3
3984493 2019211 2019211 defendant Dodge Ralph chapman 587594 587594 Dodge, Ralph, of Manchester, Lancs, chapman 0
3984504 2019215 2019215 defendant Dodd Ralph chapman 587594 587594 Dodd, Ralph, of Manchester, Lancs, chapman 0
3990417 2021328 2021328 plaintiff Bexwycke Randolph goldsmith 587594 587594 Bexwycke, Randolph, of Manchester, Lancs, goldsmith 0
3991717 2021795 2021795 defendant Radecliff William gent 587594 587594 Radecliff, William, of Manchester, Lancs, gent 0
3992779 2022168 2022168 defendant Howorthe Edmund sherman 587594 587594 Howorthe, Edmund, of Manchester, Lancs, sherman 2
3995879 2023275 2023275 defendant Radclyffe William gent 587594 587594 Radclyffe, William, of Manchester, Lancs, gent 0
4002032 2025506 2025506 defendant Beche George   587594 587594 Beche, George, of Manchester, Lancs, yeoman, son of Stephen Beche 0
4003575 2026042 2026042 plaintiff Howghton John draper 587594 587594 Howghton, John, of Manchester, Lancs, draper 0
4003579 2026044 2026044 plaintiff Howgton John draper 587594 587594 Howgton, John, of Manchester, Lancs, draper 0
4010128 2028390 2028390 defendant Sorricolde Thomas yeoman 587594 587594 Sorricolde, Thomas, of Manchester, Lancs, yeoman 0
4010130 2028391 2028391 defendant Gregorye John gent 587594 587594 Gregorye, John, of Manchester, Lancs, gent 0
4015184 2030122 2030122 defendant Dodge Otwell draper 587594 587594 Dodge, Otwell, of Manchester, Lancs, draper 0
4017882 2031107 2031107 defendant Kendricke or Kendrige George chapman 587594 587594 Kendricke or Kendrige, George, of Manchester, Lancs, chapman 0
4024374 2033396 2033396 defendant Beck Nicholas draper 587594 587594 Beck, Nicholas, of Manchester, Lancs, draper 0
4024378 2033397 2033397 defendant Webster Richard yeoman 587594 587594 Webster, Richard, of Manchester, Lancs, yeoman 0
4026437 2034099 2034099 defendant Beck Nicholas draper 587594 587594 Beck, Nicholas, of Manchester, Lancs, draper 0
4026441 2034100 2034100 defendant Webster Richard yeoman 587594 587594 Webster, Richard, of Manchester, Lancs, yeoman 0
4026444 2034101 2034101 plaintiff Byrche George   587594 587594 Byrche, George, of Manchester, Lancs 0
4028307 2034779 2034779 defendant Lyes Robert carrier 587594 587594 Lyes, Robert, of Manchester, Lancs, carrier 0
4028340 2034787 2034787 defendant Lyes Robert carrier 587594 587594 Lyes, Robert, of Manchester, Lancs, carrier 0
4033844 2036756 2036756 defendant Wright George husbandman 587594 587594 Wright, George, of Manchester, Lancs, husbandman 1
4033847 2036757 2036757 defendant Wryght George husbandman 587594 587594 Wryght, George, of Manchester, Lancs, husbandman 1
4034310 2036939 2036939 defendant Costerdyne Elias shoemaker 587594 587594 Costerdyne, Elias, of Manchester, Lancs, shoemaker 0
4056388 2044668 2044668 plaintiff Bramoll John   587594 587594 Bramoll, John, of Manchester, Lancs, linen draper 0
4058809 2045545 2045545 defendant Aynesworthe Thomas, senior saddler 587594 587594 Aynesworthe, Thomas, senior, of Manchester, Lancs, saddler 0
4066854 2048441 2048441 defendant Prowdelove George chapman 587594 587594 Prowdelove, George, of Manchester, Lancs, chapman 0
4067867 2048818 2048818 defendant Bowker Ralph yeoman 587594 587594 Bowker, Ralph, of Manchester, Lancs, yeoman 0
4070119 2049601 2049601 defendant Buckley Robert gent 587594 587594 Buckley, Robert, of Manchester, Lancs, gent 1
4082137 2053917 2053917 defendant Porter Richard yeoman 587594 587594 Porter, Richard, of Manchester, Lancs, yeoman 0
4085700 2055156 2055156 defendant Barlowe Ralph husbandman 587594 587594 Barlowe, Ralph, of Manchester, Lancs, husbandman 1
4090483 2056878 2056878 defendant Prowdelowghe George chapman 587594 587594 Prowdelowghe, George, of Manchester, Lancs, chapman 3
4095001 2058541 2058541 defendant Byrche Ralph chapman 587594 587594 Byrche, Ralph, of Manchester, Lancs, chapman 1
4096266 2058994 2058994 defendant Proudluffe George mercer 587594 587594 Proudluffe, George, of Manchester, Lancs, mercer 0
4098738 2059880 2059880 defendant Buckley Robert gent 587594 587594 Buckley, Robert, of Manchester, Lancs, gent 0
4101898 2060989 2060989 defendant Prowdloffe George chapman 587594 587594 Prowdloffe, George, of Manchester, Lancs, chapman 0
4111276 2064282 2064282 defendant Prowdlowe George chapman 587594 587594 Prowdlowe, George, of Manchester, Lancs, chapman 1
4117600 2066590 2066590 defendant Prowdluff George chapman 587594 587594 Prowdluff, George, of Manchester, Lancs, chapman 0
4129065 2070697 2070697 defendant Goodyer Thomas draper 587594 587594 Goodyer, Thomas, of Manchester, Lancs, draper 0
4129851 2070986 2070986 defendant Handson Richard chapman 587594 587594 Handson, Richard, of Manchester, Lancs, chapman 0
4130544 2071235 2071235 defendant Reynshall Richard (legal representative) 587594 587594 Reynshall, Richard, of Manchester, Lancs, yeoman, executors of 0
4130610 2071258 2071258 defendant Reynshall John   587594 587594 Reynshall, John, of Manchester, Lancs, yeoman, son of Richard 0
4135038 2072855 2072855 defendant Radcliff William gent 587594 587594 Radcliff, William, of Manchester, Lancs, gent 0
4137328 2073700 2073700 defendant Trafforde Alexander   587594 587594 Trafforde, Alexander, of Manchester, Lancs, esq, brother of Edmund Trafforde, of Trafforde, Lancs, knight 0
4145872 2076712 2076712 defendant Hanson Richard chapman 587594 587594 Hanson, Richard, of Manchester, Lancs, chapman 0
4148992 2077766 2077766 defendant Clegge John   587594 587594 Clegge, John, of Manchester, Lancs, cotton man 0
4154253 2079585 2079585 defendant Reynshall Richard (legal representative) 587594 587594 Reynshall, Richard, of Manchester, Lancs, yeoman, executors of 0
4161637 2082138 2082138 defendant Massey Ralph   587594 587594 Massey, Ralph, of Manchester, Lancs, "juggemaker" 0
4161670 2082150 2082150 defendant Prowdlowe Anne widow 587594 587594 Prowdlowe, Anne, of Manchester, Lancs, widow 1
4163168 2082648 2082648 defendant Ratclyff William gent 587594 587594 Ratclyff, William, of Manchester, Lancs, gent 0
4183389 2089670 2089670 defendant Boswycke James weaver 587594 587594 (Boswycke, James, of Manchester, Lancs, weaver 2
4189115 2091684 2091684 defendant Marlett James saddler 587594 587594 Marlett, James, of Manchester, Lancs, saddler 1
4190494 2092232 2092232 defendant Langley Robert gent 587594 587594 Langley, Robert, of Manchester, Lancs, gent 1

Next page

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