names

19 rows where place_id = 820035

✎ 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
4907202 2328816 2328816 defendant Lothe Thomas clerk 820035 820035 Lothe, Thomas, of Eythorn, clerk 4
4912791 2330495 2330495 defendant Wrenhorn Thomas   820035 820035 with Wrenhorn, Thomas, of Eythorn, servant 1
4972940 2348830 2348830 defendant Pypere Richard husbandman 820035 820035 Pypere, Richard, of Eythorn, husbandman 2
5359953 2463152 2463152 defendant Pyper Thomas husbandman 820035 820035 Pyper, Thomas, of Eythorn, husbandman 0
5359954 2463152 2463152 defendant Staunton Henry husbandman 820035 820035 Staunton, Henry, of Eythorn, husbandman 1
5366176 2465082 2465082 defendant Pyper Thomas husbandman 820035 820035 Pyper, Thomas, of Eythorn, husbandman 11
5366177 2465082 2465082 defendant Staunton Henry husbandman 820035 820035 Staunton, Henry, of Eythorn, husbandman 12
5374846 2467728 2467728 defendant Prentyce John, junior carpenter 820035 820035 Prentyce, John, junior, of Eythorn, carpenter 0
5384853 2470741 2470741 defendant Pyper Thomas husbandman 820035 820035 Pyper, Thomas, of Eythorn, husbandman 6
5384854 2470741 2470741 defendant Staunton Henry husbandman 820035 820035 Staunton, Henry, of Eythorn, husbandman 7
5396870 2474188 2474188 defendant Staunton Henry husbandman 820035 820035 Staunton, Henry, of Eythorn, husbandman 5
5410096 2477979 2477979 defendant Stennton Henry husbandman 820035 820035 Stennton, Henry, of Eythorn, husbandman 3
5410137 2477985 2477985 defendant Stannton Henry husbandman 820035 820035 Stannton, Henry, of Eythorn, husbandman 5
5435571 2485578 2485578 plaintiff Pyper Thomas husbandman 820035 820035 Pyper, Thomas, of Eythorn, husbandman 0
5450568 2490052 2490052 plaintiff Pyper Thomas husbandman 820035 820035 Pyper, Thomas, of Eythorn, husbandman 0
5450570 2490052 2490052 defendant Preyntyse John, junior carpenter 820035 820035 Preyntyse, John, junior, of Eythorn, carpenter 0
5450572 2490053 2490053 plaintiff Pyper Thomas husbandman 820035 820035 Pyper, Thomas, of Eythorn, husbandman 0
5482220 2499625 2499625 defendant Pyper Thomas husbandman 820035 820035 Pyper, Thomas, of Eythorn, husbandman 3
5542437 2517757 2517757 defendant Wylmyngton John husbandman 820035 820035 Wylmyngton, John, of Eythorn, 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);