names

23 rows where place_id = 603399

✎ 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
3654410 1911640 1911640 defendant as Hothe Thomas husbandman 603399 603399 as Hothe, Thomas, of Marsfeld, husbandman 0
3666828 1915567 1915567 defendant Rotes Reginald gent 603399 603399 Rotes, Reginald, of Marsfeld, gent 1
3699342 1926011 1926011 defendant Rogers Henry husbandman 603399 603399 Rogers, Henry, of Marsfeld, husbandman 3
3702489 1927043 1927043 defendant Rogers Robert butcher 603399 603399 Rogers, Robert, of Marsfeld, butcher 0
3843247 1971421 1971421 defendant Mascall Edward yeoman 603399 603399 Mascall, Edward, of Marsfeld, yeoman 0
3893057 1987926 1987926 defendant Harfford Richard maltman 603399 603399 Harfford, Richard, of Marsfeld, maltman 0
3893058 1987926 1987926 defendant Gostelett John yeoman 603399 603399 Gostelett, John, of Marsfeld, yeoman 1
3893060 1987926 1987926 defendant Bull alias Myller Henry miller 603399 603399 Bull alias Myller, Henry, of Marsfeld, miller 3
3904125 1991623 1991623 defendant Chamber John maltman 603399 603399 Chamber, John, of Marsfeld, maltman 0
3904126 1991623 1991623 defendant Gostlett John yeoman 603399 603399 Gostlett, John, of Marsfeld, yeoman 1
3907396 1992765 1992765 defendant Ball alias Miller Henry miller 603399 603399 Ball alias Miller, Henry, of Marsfeld, miller 2
4080589 2053373 2053373 plaintiff Waterhows Robert sherman 603399 603399 Waterhows, Robert, of Marsfeld, sherman 0
4532015 2210278 2210278 defendant Carpenter William   603399 603399 Carpenter, William, of Marsfeld 0
4553213 2216937 2216937 defendant Martyn John, sen   603399 603399 Martyn, John, sen, of Marsfeld 0
4667511 2255559 2255559 defendant Batte William   603399 603399 Batte, William, of Marsfeld 0
4668319 2255806 2255806 plaintiff Bat William   603399 603399 Bat, William, of Marsfeld 0
4713054 2269405 2269405 defendant Snayth Walter butcher 603399 603399 Snayth, Walter, of Marsfeld, butcher 0
4726632 2273601 2273601 defendant Halle Richard bagger 603399 603399 Halle, Richard, of Marsfeld, bagger 0
4813965 2300478 2300478 plaintiff Horte Richard   603399 603399 Horte, Richard, of Marsfeld 0
4866757 2316564 2316564 defendant Colchestre William baker 603399 603399 Colchestre, William, of Marsfeld, baker 0
4907826 2329010 2329010 defendant Fysche William maltman 603399 603399 Fysche, William, of Marsfeld, maltman 0
5113217 2390258 2390258 defendant Freke John clerk 603399 603399 Freke, John, of Marsfeld, clerk 16
5610468 2546990 2546990 plaintiff Bakere John   603399 603399 Bakere, John, of Marsfeld 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);