names

32 rows where place_id = 598603

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3633271 1905223 1905223 defendant Salfall or Salsall Thomas husbandman 598603 598603 Salfall or Salsall, Thomas, of Hanley Castell, husbandman 0
3687340 1922219 1922219 defendant Savage John, senior   598603 598603 Savage, John, senior, of Hanley Castell, knight 0
3687341 1922219 1922219 defendant Savage Roger clerk 598603 598603 Savage, Roger, of Hanley Castell, clerk 1
3692115 1923703 1923703 defendant Lawton John, junior husbandman 598603 598603 Lawton, John, junior, of Hanley Castell, husbandman 0
3702921 1927182 1927182 defendant Lawton John husbandman 598603 598603 Lawton, John, of Hanley Castell, husbandman 12
3703148 1927257 1927257 defendant Lawton John husbandman 598603 598603 Lawton, John, of Hanley Castell, husbandman 0
3716168 1931348 1931348 defendant Jefferys Henry husbandman 598603 598603 Jefferys, Henry, of Hanley Castell, husbandman 0
3737445 1937951 1937951 defendant Savage John, junior   598603 598603 Savage, John, junior, of Hanley Castell, knight 0
3737447 1937951 1937951 defendant Bryked Tocher gent 598603 598603 Bryked, Tocher, of Hanley Castell, gent 2
3737450 1937952 1937952 defendant Savage John, junior   598603 598603 Savage, John, junior, of Hanley Castell, knight 1
3737452 1937952 1937952 defendant Bryked Tocher gent 598603 598603 Bryked, Tocher, of Hanley Castell, gent 3
3738574 1938275 1938275 defendant Lawghton John, junior yeoman 598603 598603 Lawghton, John, junior, of Hanley Castell, yeoman 0
3752235 1942621 1942621 defendant Lawton John yeoman 598603 598603 Lawton, John, of Hanley Castell, yeoman 0
3801698 1958426 1958426 defendant Lawghton John husbandman 598603 598603 Lawghton, John, of Hanley Castell, husbandman 4
3812680 1961856 1961856 defendant Turnour John butcher 598603 598603 Turnour, John, of Hanley Castell, butcher 2
3840933 1970732 1970732 defendant Frewen Richard yeoman 598603 598603 Frewen, Richard, of Hanley Castell, yeoman 0
3840934 1970732 1970732 defendant Frewen John laborer 598603 598603 Frewen, John, of Hanley Castell, laborer 1
3840937 1970733 1970733 defendant Turnour John butcher 598603 598603 Turnour, John, of Hanley Castell, butcher 1
3905125 1991979 1991979 defendant Mochell William laborer 598603 598603 Mochell, William, of Hanley Castell, laborer 0
4093572 2058019 2058019 defendant Whyte John husbandman 598603 598603 Whyte, John, of Hanley Castell, husbandman 0
4106656 2062671 2062671 defendant Lathewood Richard butcher 598603 598603 Lathewood, Richard, of Hanley Castell, butcher 2
4202887 2096554 2096554 defendant Stocke John yeoman 598603 598603 Stocke, John, of Hanley Castell, yeoman 0
4240444 2109782 2109782 defendant Frewen Giles yeoman 598603 598603 Frewen, Giles, of Hanley Castell, yeoman 0
4245215 2111384 2111384 defendant Moore John, senior husbandman 598603 598603 Moore, John, senior, of Hanley Castell, husbandman 2
4245216 2111384 2111384 defendant Moore John, senior yeoman 598603 598603 Moore, John, senior, of Hanley Castell, yeoman 3
4289204 2126194 2126194 defendant Madoxe Richard (legal representative) 598603 598603 Madoxe, Richard, of Hanley Castell, gent, administratrix of 0
4293462 2127725 2127725 defendant Hudson Peter woodman 598603 598603 Hudson, Peter, of Hanley Castell, woodman 0
4296271 2128765 2128765 defendant Coles John yeoman 598603 598603 Coles John, of Hanley Castell, yeoman 1
4296979 2129018 2129018 defendant Toole Thomas yeoman 598603 598603 Toole, Thomas, of Hanley Castell, yeoman 0
4296980 2129018 2129018 defendant Chomslore or Chomflore John husbandman 598603 598603 Chomslore or Chomflore, John, of Hanley Castell, husbandman 1
4406291 2166670 2166670 defendant Salford Thomas husbandman 598603 598603 Salford, Thomas, of Hanley Castell, or of Collwall, Herefs, husbandman 0
4406354 2166690 2166690 defendant Salforde Thomas husbandman 598603 598603 Salforde, Thomas, of Hanley Castell, or of Colwall, Herefs, husbandman 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);