names

13 rows where place_id = 600033

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3639422 1907138 1907138 defendant Boughton Henry gent 600033 600033 Boughton, Henry, of Hylmorton, Warks, gent 1
3687960 1922395 1922395 defendant Grene William carrier 600033 600033 Grene, William, of Hylmorton, Warks, carrier 0
3698369 1925709 1925709 defendant Isod Thomas   600033 600033 Isod, Thomas, of Hylmorton, Warks, clerk, administrators of 0
3780091 1951497 1951497 defendant Brege Thomas husbandman 600033 600033 Brege, Thomas, of Hylmorton, Warks, husbandman 0
3844396 1971797 1971797 defendant Compton John husbandman 600033 600033 Compton, John, of Hylmorton, Warks, husbandman 0
3844399 1971798 1971798 defendant Compton John husbandman 600033 600033 Compton, John, of Hylmorton, Warks, husbandman 0
3875826 1982169 1982169 defendant Freman William drover 600033 600033 Freman, William, of Hylmorton, Warks, drover 0
3878014 1982890 1982890 defendant Cobbe George husbandman 600033 600033 Cobbe, George, of Hylmorton, Warks, husbandman 0
4028258 2034757 2034757 defendant Smythe alias Rauffe John yeoman 600033 600033 Smythe alias Rauffe, John, of Hylmorton, Warks, yeoman 0
5212774 2419483 2419483 defendant Dorset Hugh gent 600033 600033 Dorset, Hugh, of Hylmorton, Warks, gent 0
5246550 2429153 2429153 defendant Dosset William yeoman 600033 600033 Dosset, William, of Hylmorton, Warks, yeoman 1
5246554 2429154 2429154 defendant Dosset William yeoman 600033 600033 Dosset, William, of Hylmorton, Warks, yeoman 1
5247593 2429453 2429453 defendant Wattys Richard miller 600033 600033 Wattys, Richard, of Hylmorton, Warks, miller 2

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