names

14 rows where case_id = 2456877

✎ 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
5339330 2456877 2456877 plaintiff Mauntell Walter knight   Mauntell, Walter, knight 0
5339331 2456877 2456877 defendant Heythley John laborer 606860 606860 Heythley, John, of Flore, laborer 0
5339332 2456877 2456877 defendant Preston John laborer 606860 606860 Preston, John, of Flore, laborer 1
5339333 2456877 2456877 defendant Bastoke Ralph laborer 606860 606860 Bastoke, Ralph, of Flore, laborer 2
5339334 2456877 2456877 defendant Wheler John laborer 606860 606860 Wheler, John, of Flore, laborer 3
5339335 2456877 2456877 defendant Myles John husbandman 837154 837154 Myles, John, of Magna Everdon, husbandman 4
5339336 2456877 2456877 defendant Whelpdale Ralph ostler 586237 586237 Whelpdale, Ralph, of Daventre, ostler 5
5339337 2456877 2456877 defendant Smyth William smith 586237 586237 Smyth, William, of Daventre, smith 6
5339338 2456877 2456877 defendant Burgeys James laborer 606860 606860 Burgeys, James, of Flore, laborer 7
5339339 2456877 2456877 defendant Brodurs William laborer 874742 874742 Brodurs, William, of Nethyr Wedonbeke, laborer 8
5339340 2456877 2456877 defendant Brodurs Henry laborer 874742 874742 Brodurs, Henry, of Nethyr Wedonbeke, laborer 9
5339341 2456877 2456877 defendant Bradfeld John smith 874742 874742 Bradfeld, John, of Nethyr Wedonbeke, smith 10
5339342 2456877 2456877 defendant Stevenson William husbandman 874742 874742 Stevenson, William, of Nethyr Wedonbeke, husbandman 11
5339343 2456877 2456877 defendant Hogkyns John husbandman 598669 598669 Hogkyns, John, of Newenham, husbandman 12

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