names

15 rows where case_id = 2442055

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5289900 2442055 2442055 plaintiff Morten Elizabeth     Morten, Elizabeth 0
5289901 2442055 2442055 defendant Barnes William gent 597438 597438 Barnes, William, of Colston Basset, gent 0
5289902 2442055 2442055 defendant Barnes Richard gent 597438 597438 Barnes, Richard, of Colston Basset, gent 1
5289903 2442055 2442055 defendant Smyth John carpenter 597438 597438 Smyth, John, of Colston Basset, carpenter 2
5289904 2442055 2442055 defendant Nedeham William laborer 597438 597438 Nedeham, William, of Colston Basset, laborer 3
5289905 2442055 2442055 defendant Bayly Richard husbandman 597438 597438 Bayly, Richard, of Colston Basset, husbandman 4
5289906 2442055 2442055 defendant Doughty Robert laborer 597438 597438 Doughty, Robert, of Colston Basset, laborer 5
5289907 2442055 2442055 defendant Bankes Hugh barker 586901 586901 Bankes, Hugh, of Nottingham, barker 6
5289908 2442055 2442055 defendant Bankes Thomas barker 586901 586901 Bankes, Thomas, of Nottingham, barker 7
5289909 2442055 2442055 defendant Lowe Lawrence yeoman 610386 610386 Lowe, Lawrence, of Owthorp, yeoman 8
5289910 2442055 2442055 defendant Pagyngham William husbandman 869166 869166 Pagyngham, William, of Coston Basset, husbandman 9
5289911 2442055 2442055 defendant Lowe Nicholas yeoman 590424 590424 Lowe, Nicholas, of Outhorp, yeoman 10
5289912 2442055 2442055 defendant Broun William husbandman 589445 589445 Broun, William, of Arnall, husbandman 11
5289913 2442055 2442055 defendant Rouse Robert husbandman 869167 869167 Rouse, Robert, of Hoose, husbandman 12
5289914 2442055 2442055 defendant Gower Richard glover 586901 586901 Gower, Richard, of Nottingham, glover 13

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