names

38 rows where place_id = 611082

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3686701 1921993 1921993 defendant Godsall William husbandman 611082 611082 Godsall, William, of Castle Frome, husbandman 3
3696994 1925286 1925286 defendant Morgan John husbandman 611082 611082 Morgan, John, of Castle Frome, husbandman 2
3696995 1925286 1925286 defendant Roke John husbandman 611082 611082 Roke, John, of Castle Frome, husbandman 3
3701330 1926660 1926660 defendant Dymoke John husbandman 611082 611082 Dymoke, John, of Castle Frome, husbandman 2
3701331 1926660 1926660 defendant Baily Thomas husbandman 611082 611082 Baily, Thomas, of Castle Frome, husbandman 3
3706466 1928308 1928308 defendant Daubeney Robert husbandman 611082 611082 Daubeney, Robert, of Castle Frome, husbandman 1
3706469 1928308 1928308 defendant Baker Roland tailor 611082 611082 Baker, Roland, of Castle Frome, tailor 4
3711948 1930052 1930052 defendant Halfeyld William husbandman 611082 611082 Halfeyld, William, of Castle Frome, husbandman 0
3711949 1930052 1930052 defendant Freman Joan spinster 611082 611082 Freman, Joan, of Castle Frome, spinster 1
3711950 1930052 1930052 defendant Wade John husbandman 611082 611082 Wade, John, of Castle Frome, husbandman 2
3742626 1939562 1939562 defendant Bayly Thomas husbandman 611082 611082 Bayly, Thomas, of Castle Frome, husbandman 0
3742664 1939575 1939575 defendant Bayly Thomas husbandman 611082 611082 Bayly, Thomas, of Castle Frome, husbandman 0
3936098 2002395 2002395 defendant Haylewyn John laborer 611082 611082 Haylewyn, John, of Castle Frome, laborer 0
3936099 2002395 2002395 defendant Haylewyn William laborer 611082 611082 Haylewyn, William, of Castle Frome, laborer 1
3950570 2007275 2007275 defendant Androws Christopher clerk 611082 611082 Androws, Christopher, of Castle Frome, clerk 1
3964888 2012323 2012323 defendant Pery Thomas shoemaker 611082 611082 Pery, Thomas, of Castle Frome, shoemaker 0
3983823 2018986 2018986 defendant Baggett Roger husbandman 611082 611082 Baggett, Roger, of Castle Frome, husbandman 3
4039027 2038580 2038580 defendant Jones William, junior husbandman 611082 611082 Jones, William, junior, of Castle Frome, husbandman 2
4101034 2060685 2060685 defendant Pyrry Thomas, junior cordwainer 611082 611082 Pyrry, Thomas, junior, of Castle Frome, cordwainer 0
4101035 2060685 2060685 defendant Pyrry William cordwainer 611082 611082 Pyrry, William, of Castle Frome, cordwainer 1
4101036 2060685 2060685 defendant Richard Hugh weaver 611082 611082 Richard, Hugh, of Castle Frome, weaver 2
4112703 2064804 2064804 defendant Baylye William carpenter 611082 611082 Baylye, William, of Castle Frome, carpenter 0
4112704 2064804 2064804 defendant Baylye Alice spinster 611082 611082 Baylye, Alice, of Castle Frome, spinster 1
4112705 2064804 2064804 defendant Baylye Margery spinster 611082 611082 Baylye, Margery, of Castle Frome, spinster 2
4146436 2076902 2076902 defendant Pyrrye Thomas, junior shoemaker 611082 611082 Pyrrye, Thomas, junior, of Castle Frome, shoemaker 2
4165210 2083340 2083340 defendant Stallard Robert gent 611082 611082 Stallard, Robert, of Castle Frome, gent 1
4202680 2096479 2096479 defendant Pytcher Robert gent 611082 611082 Pytcher, Robert, of Castle Frome, gent 2
4218725 2102051 2102051 defendant Smythe John smith 611082 611082 Smythe, John, of Castle Frome, smith 0
4222513 2103367 2103367 defendant Mathewes Thomas butcher 611082 611082 Mathewes, Thomas, of Castle Frome, butcher 0
4222514 2103367 2103367 defendant Sawyer William yeoman 611082 611082 Sawyer, William, of Castle Frome, yeoman 1
4227848 2105221 2105221 defendant Smythe John smith 611082 611082 Smythe, John, of Castle Frome, smith 0
4230791 2106269 2106269 defendant Mathewes Thomas butcher 611082 611082 Mathewes, Thomas, of Castle Frome, butcher 0
4230793 2106269 2106269 defendant Sawyer William yeoman 611082 611082 Sawyer, William, of Castle Frome, yeoman 2
4243286 2110745 2110745 defendant Downinge Francis yeoman 611082 611082 Downinge, Francis, of Castle Frome, yeoman 1
4298082 2129417 2129417 defendant Mathewes Thomas butcher 611082 611082 Mathewes, Thomas, of Castle Frome, butcher 3
4331212 2140736 2140736 defendant Mathewes Thomas butcher 611082 611082 Mathewes, Thomas, of Castle Frome, butcher 3
4332635 2141202 2141202 defendant Freman John yeoman 611082 611082 Freman, John, of Castle Frome, yeoman 1
4994866 2355317 2355317 defendant Warener Thomas husbandman 611082 611082 Warener, Thomas, of Castle Frome, 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);