names

10 rows where case_id = 1985486

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3885741 1985486 1985486 plaintiff Blakwall Richard     Blakwall, Richard 0
3885742 1985486 1985486 defendant Pott Reginald husbandman 607120 607120 Pott, Reginald, of Bowden, husbandman 0
3885743 1985486 1985486 defendant Hayhe John husbandman 645482 645482 Hayhe, John, of Mowseley Bothom, husbandman 1
3885744 1985486 1985486 defendant Berde Ralph yeoman 645483 645483 Berde, Ralph, of Jollehole, yeoman 2
3885745 1985486 1985486 defendant Melour Ralph husbandman 645484 645484 Melour, Ralph, of Halotthey, husbandman 3
3885746 1985486 1985486 defendant Swyndellys Edward husbandman 645485 645485 Swyndellys, Edward, of Shydyard, husbandman 4
3885747 1985486 1985486 defendant Hyde Joan widow 607120 607120 Hyde, Joan, of Bowden, widow 5
3885748 1985486 1985486 defendant Hadfeld William laborer 606594 606594 Hadfeld, William, of Heyfeld, laborer 6
3885749 1985486 1985486 defendant Dewsnop William husbandman 645486 645486 Dewsnop, William, of Holenworth Heede, husbandman 7
3885750 1985486 1985486 defendant Waryngton John husbandman 622835 622835 Waryngton, John, of Newmyll, husbandman 8

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