names

26 rows where place_id = 607549

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3669749 1916486 1916486 defendant Ingill Thomas husbandman 607549 607549 Ingill, Thomas, of Keswyk, husbandman 1
4497034 2199736 2199736 defendant Jakson Thomas   607549 607549 Jakson, Thomas, of Keswyk 0
4518260 2206086 2206086 plaintiff del West Robert   607549 607549 del West, Robert, of Keswyk 0
4526543 2208585 2208585 defendant Thomson Adam   607549 607549 Thomson, Adam, of Keswyk 0
4591317 2228640 2228640 defendant Scot John   607549 607549 Scot, John, of Keswyk 2
4591331 2228646 2228646 defendant Scot John   607549 607549 Scot, John, of Keswyk 0
4621640 2237752 2237752 defendant Thomson Adam   607549 607549 Thomson, Adam, of Keswyk 10
4621641 2237752 2237752 defendant Thomson John   607549 607549 Thomson, John, of Keswyk 11
4818611 2301903 2301903 defendant Berwyk John yeoman 607549 607549 Berwyk, John, of Keswyk, yeoman 0
4818614 2301903 2301903 defendant Douthwayt Thomas   607549 607549 Douthwayt, Thomas, of Keswyk, servant 3
4818615 2301903 2301903 defendant West Richard de   607549 607549 West, Richard de, of Keswyk, servant 4
4860830 2314749 2314749 defendant Metton Robert clerk 607549 607549 Metton, Robert, of Keswyk, clerk 0
4896672 2325621 2325621 defendant Magotson John husbandman 607549 607549 Magotson, John, of Keswyk, husbandman 0
4949126 2341717 2341717 defendant Jonson William yeoman 607549 607549 Jonson, William, of Keswyk, yeoman 2
4951633 2342468 2342468 defendant Alanson William cardmaker 607549 607549 Alanson, William, of Keswyk, cardmaker 0
5105674 2388107 2388107 defendant Burndholme Nicholas chapman 607549 607549 Burndholme, Nicholas, of Keswyk, Cumber, chapman 0
5118112 2391732 2391732 defendant Hudson John yeoman 607549 607549 Hudson, John, of Keswyk, yeoman 0
5150453 2401267 2401267 defendant Fyssher Robert yeoman 607549 607549 Fyssher, Robert, of Keswyk, yeoman 0
5150454 2401267 2401267 defendant Fyssher Thomas yeoman 607549 607549 Fyssher, Thomas, of Keswyk, yeoman 1
5220967 2421831 2421831 defendant Lenthorp John husbandman 607549 607549 Lenthorp, John, of Keswyk, husbandman 0
5220968 2421831 2421831 defendant Lenthorp Oliver laborer 607549 607549 Lenthorp, Oliver, of Keswyk, laborer 1
5220971 2421832 2421832 defendant Lenthorp John husbandman 607549 607549 Lenthorp, John, of Keswyk, husbandman 0
5220972 2421832 2421832 defendant Lenthorp Oliver laborer 607549 607549 Lenthorp, Oliver, of Keswyk, laborer 1
5220974 2421832 2421832 defendant Boket John husbandman 607549 607549 Boket, John, of Keswyk, husbandman 3
5220975 2421832 2421832 defendant Dyconson Thomas husbandman 607549 607549 Dyconson, Thomas, of Keswyk, husbandman 4
5272483 2437026 2437026 defendant Wellys Roger husbandman 607549 607549 Wellys, Roger, of Keswyk, husbandman 3

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);