names

19 rows where place_id = 622918

✎ 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
3749650 1941802 1941802 defendant Husdun Simon laborer 622918 622918 Husdun, Simon, of Parva Cotes, laborer 9
3749651 1941802 1941802 defendant Calverley William laborer 622918 622918 Calverley, William, of Parva Cotes, laborer 10
3749653 1941802 1941802 defendant Jobson William husbandman 622918 622918 Jobson, William, of Parva Cotes, husbandman 12
4660094 2249001 2249001 plaintiff de See Brian   622918 622918 de See, Brian, of Parva Cotes 0
4666513 2251008 2251008 defendant Cotes John   622918 622918 Cotes, John, of Parva Cotes 0
5052253 2372281 2372281 defendant Cee Patrick   622918 622918 Cee, Patrick, of Parva Cotes 0
5052254 2372281 2372281 defendant Cee Stephen   622918 622918 Cee, Stephen, of Parva Cotes, franklin 1
5057595 2373841 2373841 defendant Thornton Richard   622918 622918 Thornton, Richard, of Parva Cotes, franklin 1
5057643 2373852 2373852 defendant Thornton Richard   622918 622918 Thornton, Richard, of Parva Cotes, franklin 1
5060531 2374729 2374729 defendant Cee Stephen   622918 622918 Cee, Stephen, of Parva Cotes, franklin 0
5060532 2374729 2374729 defendant Cee Brian, junior   622918 622918 Cee, Brian, junior, of Parva Cotes, franklin 1
5060533 2374729 2374729 defendant Cee Patrick   622918 622918 together with Cee, Patrick, of Parva Cotes, franklin 2
5061603 2375060 2375060 defendant Cee Brian, junior gent 622918 622918 Cee, Brian, junior, of Parva Cotes, gent 0
5061604 2375060 2375060 defendant Cee John gent 622918 622918 Cee, John, of Parva Cotes, gent 1
5072480 2378254 2378254 defendant Thornton Richard   622918 622918 Thornton, Richard, of Parva Cotes, franklin 1
5080861 2380766 2380766 defendant Thornton Richard   622918 622918 Thornton, Richard, of Parva Cotes, franklin 1
5096920 2385529 2385529 defendant Taleor Thomas husbandman 622918 622918 Taleor, Thomas, of Parva Cotes, husbandman 1
5340088 2457108 2457108 defendant Swalowe John husbandman 622918 622918 Swalowe, John, of Parva Cotes, husbandman 0
5343038 2458009 2458009 defendant Smyth John husbandman 622918 622918 Smyth, John, of Parva Cotes, 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);