names

13 rows where case_id = 2426249

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5236430 2426249 2426249 plaintiff Etton Robert     Etton, Robert 0
5236431 2426249 2426249 defendant Palmer Stephen yeoman 611344 611344 Palmer, Stephen, of Alvyngham, yeoman 0
5236432 2426249 2426249 defendant Reyney John husbandman 587643 587643 Reyney, John, of Ingoldmels, husbandman 1
5236433 2426249 2426249 defendant Grouse John husbandman 598487 598487 Grouse, John, of Marum, husbandman 2
5236434 2426249 2426249 defendant Walsoken Thomas husbandman 862635 862635 Walsoken, Thomas, of Welton juxta Wyllughby, husbandman 3
5236435 2426249 2426249 defendant Wolleby William husbandman 591949 591949 Wolleby, William, of Thorp, husbandman 4
5236436 2426249 2426249 defendant Fyssher Henry clerk 594818 594818 Fyssher, Henry, of Byker, clerk 5
5236437 2426249 2426249 defendant Beveryche Robert laborer 862636 862636 Beveryche, Robert, of Burgh in the Mersh, laborer 6
5236438 2426249 2426249 defendant Fokes Robert husbandman 597185 597185 Fokes, Robert, of Freston, husbandman 7
5236439 2426249 2426249 defendant Roos John husbandman 769804 769804 Roos, John, of Kelecotes, husbandman 8
5236440 2426249 2426249 defendant Begge Robert fisher 597124 597124 Begge, Robert, of Waynflete, fisher 9
5236441 2426249 2426249 defendant Deye Robert husbandman 830518 830518 Deye, Robert, of Claxby juxta Wylughby, husbandman 10
5236442 2426249 2426249 defendant Walley Robert walker 666197 666197 Walley, Robert, of Totyll, walker 11

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