names

75 rows where place_id = 599731

✎ 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
3638018 1906707 1906707 defendant Jurdan Oliver butcher 599731 599731 Jurdan, Oliver, of Eccleshall, butcher 1
3693018 1924020 1924020 defendant Bagger Robert yeoman 599731 599731 Bagger, Robert, of Eccleshall, yeoman 0
3710939 1929738 1929738 defendant Jerveys James gent 599731 599731 Jerveys, James, of Eccleshall, gent 0
3710941 1929739 1929739 defendant Jerveys James gent 599731 599731 Jerveys, James, of Eccleshall, gent 0
3716771 1931536 1931536 defendant Meverell Nicholas gent 599731 599731 Meverell, Nicholas, of Eccleshall, gent 3
3743310 1939779 1939779 defendant Meverell Nicholas gent 599731 599731 Meverell, Nicholas, of Eccleshall, gent 0
3746699 1940879 1940879 defendant Menerell Nicholas gent 599731 599731 Menerell, Nicholas, of Eccleshall, gent 0
3775812 1950184 1950184 defendant Perton Thomas shoemaker 599731 599731 Perton, Thomas, of Eccleshall, shoemaker 0
3775813 1950184 1950184 defendant Tagg John tailor 599731 599731 Tagg, John, of Eccleshall, tailor 1
3775814 1950184 1950184 defendant Wyldblode Hugh laborer 599731 599731 Wyldblode, Hugh, of Eccleshall, laborer 2
3775815 1950184 1950184 defendant Bysshop Humphrey shoemaker 599731 599731 Bysshop, Humphrey, of Eccleshall, shoemaker 3
3793382 1955792 1955792 defendant Parton Thomas shoemaker 599731 599731 Parton, Thomas, of Eccleshall, shoemaker 0
3793383 1955792 1955792 defendant Tagge John tailor 599731 599731 Tagge, John, of Eccleshall, tailor 1
3793384 1955792 1955792 defendant Wildeblode Hugh laborer 599731 599731 Wildeblode, Hugh, of Eccleshall, laborer 2
3793385 1955792 1955792 defendant Bysshop Humphrey shoemaker 599731 599731 Bysshop, Humphrey, of Eccleshall, shoemaker 3
3804428 1959323 1959323 defendant Swancote Thomas butcher 599731 599731 Swancote, Thomas, of Eccleshall, butcher 0
3821121 1964501 1964501 defendant Bysshop Henry yeoman 599731 599731 Bysshop, Henry, of Eccleshall, yeoman 0
3849838 1973534 1973534 defendant Jonys Roger husbandman 599731 599731 Jonys, Roger, of Eccleshall, husbandman 0
3851059 1973923 1973923 defendant Hudson Ralph husbandman 599731 599731 Hudson, Ralph, of Eccleshall, husbandman 0
3851060 1973923 1973923 defendant Ian or Jan Katherine widow 599731 599731 Ian or Jan, Katherine, of Eccleshall, widow 1
3867271 1979288 1979288 defendant Blest Christopher husbandman 599731 599731 Blest, Christopher, of Eccleshall, husbandman 0
3869472 1980031 1980031 plaintiff Walter Richard, junior   599731 599731 Walter, Richard, junior, of Eccleshall 0
3895194 1988600 1988600 defendant Swancoyte Thomas yeoman 599731 599731 Swancoyte, Thomas, of Eccleshall, yeoman 0
3949688 2006968 2006968 defendant Jerves Thomas gent 599731 599731 Jerves, Thomas, of Eccleshall, gent 0
3949689 2006968 2006968 defendant Cotton Joan widow 599731 599731 Cotton, Joan, of Eccleshall, widow 1
3966219 2012814 2012814 defendant Swynnerton Edward gent 599731 599731 Swynnerton, Edward, of Eccleshall, gent 0
3968904 2013751 2013751 defendant Walter Agnes widow 599731 599731 Walter, Agnes, of Eccleshall, widow 1
3968921 2013753 2013753 defendant Walter Agnes widow 599731 599731 Walter, Agnes, of Eccleshall, widow 1
3970762 2014365 2014365 defendant Walter Thomas smith 599731 599731 Walter, Thomas, of Eccleshall, smith 0
3977927 2016852 2016852 plaintiff Magnoll Gilbert clerk 599731 599731 Magnoll, Gilbert, of Eccleshall, clerk 0
4025351 2033729 2033729 defendant Walsyngham John (legal representative) 599731 599731 Walsyngham, John, of Eccleshall, gent, administratrix of 0
4025558 2033797 2033797 defendant Walsyngham John (legal representative) 599731 599731 Walsyngham, John, of Eccleshall, gent, administratrix of 0
4066590 2048346 2048346 defendant Snelson Robert yeoman 599731 599731 Snelson, Robert, of Eccleshall, yeoman 0
4090865 2057023 2057023 defendant Swynnerton Hugh gent 599731 599731 Swynnerton, Hugh, of Eccleshall, gent 0
4098751 2059885 2059885 defendant Swynnerton Hugh gent 599731 599731 Swynnerton, Hugh, of Eccleshall, gent 1
4098754 2059886 2059886 defendant Swynnerton Hugh gent 599731 599731 Swynnerton, Hugh, of Eccleshall, gent 1
4142787 2075650 2075650 defendant Cragge Ralph gent 599731 599731 Cragge, Ralph, of Eccleshall, gent 0
4156106 2080211 2080211 defendant Machen Randolph blacksmith 599731 599731 Machen, Randolph, of Eccleshall, blacksmith 0
4158240 2080954 2080954 defendant Swynnerton Hugh gent 599731 599731 Swynnerton, Hugh, of Eccleshall, gent 0
4163231 2082670 2082670 defendant Awton Thomas laborer 599731 599731 Awton, Thomas, of Eccleshall, laborer 0
4163233 2082670 2082670 defendant Backhowse Gilbert sherman 599731 599731 Backhowse, Gilbert, of Eccleshall, sherman 2
4163234 2082670 2082670 defendant Weilde Margaret widow 599731 599731 Weilde, Margaret, of Eccleshall, widow 3
4167127 2084008 2084008 defendant Swynerton Hugh gent 599731 599731 Swynerton, Hugh, of Eccleshall, gent 1
4173368 2086142 2086142 defendant Olyver Humphrey mercer 599731 599731 Olyver, Humphrey, of Eccleshall, mercer 0
4190701 2092310 2092310 defendant Swynnerton Hugh gent 599731 599731 Swynnerton, Hugh, of Eccleshall, gent 1
4193900 2093429 2093429 defendant Awlkyns or Awkyns Michael yeoman 599731 599731 Awlkyns or Awkyns, Michael, of Eccleshall, yeoman 0
4205437 2097455 2097455 defendant Dodde John innholder 599731 599731 Dodde, John, of Eccleshall, innholder 0
4214121 2100457 2100457 defendant Hewes Thomas yeoman 599731 599731 Hewes, Thomas, of Eccleshall, yeoman 2
4223472 2103699 2103699 defendant Freakley Robert butcher 599731 599731 Freakley, Robert, of Eccleshall, butcher 1
4234125 2107464 2107464 defendant Swynerton Hugh gent 599731 599731 Swynerton, Hugh, of Eccleshall, gent 0
4299978 2130088 2130088 defendant Swynnerton John gent 599731 599731 Swynnerton, John, of Eccleshall, gent 1
4325610 2138941 2138941 defendant Cokeclyff or Colcloughe Thomas laborer 599731 599731 Cokeclyff or Colcloughe, Thomas, of Eccleshall, laborer 0
4331533 2140842 2140842 defendant Bate William yeoman 599731 599731 Bate, William, of Eccleshall, yeoman 1
4332023 2141007 2141007 defendant Howell Thomas sherman 599731 599731 Howell, Thomas, of Eccleshall, sherman 0
4333490 2141481 2141481 defendant Turner Thomas butcher 599731 599731 Turner, Thomas, of Eccleshall, butcher 2
4334550 2141828 2141828 defendant Mosse William yeoman 599731 599731 Mosse, William, of Eccleshall, yeoman 0
4334551 2141828 2141828 defendant Heughes or Hughes Thomas yeoman 599731 599731 Heughes or Hughes, Thomas, of Eccleshall, yeoman 1
4334552 2141828 2141828 defendant Machyn Randolph innholder 599731 599731 Machyn, Randolph, of Eccleshall, yeoman, innholder 2
4334553 2141828 2141828 defendant Brockston John yeoman or husbandman 599731 599731 Brockston, John, of Eccleshall, yeoman or husbandman 3
4345971 2145852 2145852 defendant Cooke George yeoman 599731 599731 Cooke, George, of Eccleshall, yeoman 2
4346498 2146024 2146024 defendant Swenerton Hugh gent 599731 599731 Swenerton, Hugh, of Eccleshall, gent 0
4349828 2147197 2147197 defendant Litleton Walter gent 599731 599731 Litleton, Walter, of Eccleshall, or of Badnall, gent 1
4390120 2161316 2161316 defendant ap Oliver Humphrey mercer 599731 599731 ap Oliver, Humphrey, of Eccleshall, mercer 0
4390862 2161557 2161557 defendant Whiston James carpenter 599731 599731 Whiston, James, of Eccleshall, carpenter 0
4390863 2161557 2161557 defendant Turnor Thomas butcher 599731 599731 Turnor, Thomas, of Eccleshall, butcher 1
4390864 2161557 2161557 defendant Freekley Robert butcher 599731 599731 Freekley, Robert, of Eccleshall, butcher 2
4394250 2162678 2162678 defendant Frackley Robert   599731 599731 Frackley, Robert, of Eccleshall butcher 0
4402290 2165351 2165351 defendant Freakley Robert butcher 599731 599731 Freakley, Robert, of Eccleshall, butcher 1
4410038 2167964 2167964 defendant Barker Francis weaver 599731 599731 Barker, Francis, of Eccleshall, weaver 0
4410039 2167964 2167964 defendant Barker John   599731 599731 Barker, John, of Eccleshall, weaver, his son 1
5408383 2477477 2477477 defendant Swynnerton John   599731 599731 Swynnerton, John, of Eccleshall 1
5547004 2519129 2519129 defendant Bedull John gent 599731 599731 Bedull, John, of Eccleshall, gent 4
5547009 2519130 2519130 defendant Bedull John gent 599731 599731 Bedull, John, of Eccleshall, gent 3
5568414 2525308 2525308 defendant Alat Katherine widow 599731 599731 Alat, Katherine, of Eccleshall, widow 1
5607214 2537144 2537144 defendant Gerves James gent 599731 599731 Gerves, James, of Eccleshall, gent 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);