names

17 rows where place_id = 597406

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628443 1903763 1903763 defendant Sexsten John yeoman 597406 597406 Sexsten, John, of Lanam, Suff, yeoman 2
3645838 1909103 1909103 defendant Williammot John yeoman 597406 597406 Williammot, John, of Lanam, Suff, yeoman 1
3650935 1910663 1910663 defendant Wyllymott John clothmaker 597406 597406 Wyllymott, John, of Lanam, Suff, clothmaker 1
3650938 1910664 1910664 defendant Wyllymot John clothmaker 597406 597406 Wyllymot, John,of Lanam, Suff, clothmaker 0
3678504 1919335 1919335 defendant Sprenge Robert clothman 597406 597406 Sprenge, Robert, of Lanam, Suff, clothman 0
3868062 1979552 1979552 plaintiff Sprynge Robert clothier 597406 597406 Sprynge, Robert,of Lanam, Suff, clothier 0
3953519 2008303 2008303 defendant Byrd William clothier 597406 597406 Byrd, William, of Lanam, Suff, clothier 0
3956119 2009211 2009211 defendant Marten John mercer 597406 597406 Marten, John, of Lanam, Suff, mercer 0
4388241 2160696 2160696 defendant Payne Thomas chapman 597406 597406 Payne, Thomas, of Lanam, Suff, chapman 0
4890571 2323810 2323810 defendant Sprynge Thomas chapman 597406 597406 Sprynge, Thomas, of Lanam, Suff, chapman 1
4897273 2325806 2325806 defendant Sprynge Thomas chapman 597406 597406 Sprynge, Thomas, of Lanam, Suff, chapman 1
5037774 2367924 2367924 defendant Bere John fuller 597406 597406 Bere, John, of Lanam, Suff, fuller 0
5437527 2486162 2486162 defendant Byrde John clothman 597406 597406 Byrde, John, of Lanam, Suff, clothman 3
5489582 2501764 2501764 defendant Bonyfaunt Thomas painter 597406 597406 Bonyfaunt, Thomas, of Lanam, Suff, painter 3
5516158 2509897 2509897 defendant Barbour Thomas barber 597406 597406 (Barbour, Thomas, of Lanam, Suff, barber 4
5529535 2513736 2513736 defendant Warburton Thomas yeoman 597406 597406 Warburton, Thomas, of Lanam, Suff, yeoman 0
5580467 2528977 2528977 defendant Barbor John clerk 597406 597406 Barbor, John, of Lanam, Suff, clerk 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);