names

21 rows where place_id = 625826

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3716017 1931295 1931295 defendant Laws Eustace   625826 625826 Laws, Eustace, of Matsall, wool chapman 0
3731622 1936118 1936118 defendant Lawes Eustace   625826 625826 Lawes, Eustace, of Matsall, wool chapman 0
3766596 1947217 1947217 defendant Savage Robert husbandman 625826 625826 Savage, Robert, of Matsall, husbandman 0
3832026 1967914 1967914 defendant Hall Edward   625826 625826 Hall, Edward, of Matsall, wool chapman 1
3869661 1980096 1980096 plaintiff Wattys William (legal representative) 625826 625826 Wattys, William, of Matsall, executor of 0
3886847 1985864 1985864 defendant Harleston Robert yeoman 625826 625826 Harleston, Robert, of Matsall, yeoman 0
3893962 1988204 1988204 defendant Adams Thomas blacksmith 625826 625826 Adams, Thomas, of Matsall, blacksmith 0
3962250 2011379 2011379 plaintiff Wattes John yeoman 625826 625826 Wattes, John, of Matsall, yeoman 0
3962254 2011380 2011380 plaintiff Wattes Roger yeoman or wool seller 625826 625826 Wattes, Roger, of Matsall, yeoman or wool seller 0
4012329 2029131 2029131 defendant Hendrye Richard cordwainer 625826 625826 Hendrye, Richard, of Matsall, cordwainer 0
4042523 2039794 2039794 plaintiff Partricke William yeoman 625826 625826 Partricke, William, of Matsall, yeoman 0
4059128 2045664 2045664 defendant Elvye John butcher 625826 625826 Elvye, John, of Matsall, butcher 0
4093131 2057862 2057862 defendant Elvye Katherine spinster 625826 625826 Elvye, Katherine, of Matsall, spinster 0
4099783 2060243 2060243 defendant Watt Thomas   625826 625826 Watt, Thomas, of Matsall, wool chapman 2
4185457 2090422 2090422 defendant Dabbes Thomas yeoman 625826 625826 Dabbes, Thomas, of Matsall, or of Newton juxta Castellacre, yeoman 0
4192625 2092977 2092977 defendant Spylman Godfrey husbandman 625826 625826 Spylman, Godfrey, of Matsall, or of Hensteade, Suff, husbandman 0
4199004 2095208 2095208 defendant Ryghtuppe Thomas husbandman 625826 625826 Ryghtuppe, Thomas, of Matsall, husbandman 2
4199005 2095208 2095208 defendant Denton John   625826 625826 Denton, John, of Matsall, linen draper 3
4328880 2139971 2139971 defendant Crosseld Henry grocer 625826 625826 Crosseld, Henry, of Matsall, grocer 1
4391424 2161748 2161748 defendant Crossold or Crosfold Henry chapman 625826 625826 Crossold or Crosfold, Henry, of Matsall, chapman 2
5591557 2532338 2532338 defendant Lans or Laus Eustace yeoman 625826 625826 Lans or Laus, Eustace, of Matsall, yeoman 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);