names

16 rows where case_id = 2311047

✎ 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
4848634 2311047 2311047 plaintiff Sidesterne Richard     Sidesterne, Richard 0
4848635 2311047 2311047 defendant Lamkyn John yeoman 595491 595491 Lamkyn, John, of Longham, yeoman 0
4848636 2311047 2311047 defendant Whitfote Henry yeoman 772679 772679 Whitfote, Henry, of Great Beteryng, yeoman 1
4848637 2311047 2311047 defendant Gyllyng Thomas thatcher 586882 586882 Gyllyng, Thomas, of Betele, thatcher 2
4848638 2311047 2311047 defendant Hokeryng Henry   772679 772679 Hokeryng, Henry, of Great Beteryng, shepherd 3
4848639 2311047 2311047 defendant Horne Alice widow 772679 772679 Horne, Alice, of Great Beteryng, widow 4
4848640 2311047 2311047 defendant Reymond Robert yeoman 772679 772679 Reymond, Robert, of Great Beteryng, yeoman 5
4848641 2311047 2311047 defendant Hopton John yeoman 586882 586882 Hopton, John, of Betele, yeoman 6
4848642 2311047 2311047 defendant Michell William yeoman 595491 595491 Michell, William, of Longham, yeoman 7
4848643 2311047 2311047 defendant Gotte Letitia widow 788005 788005 Gotte, Letitia, of Gressenale, widow 8
4848644 2311047 2311047 defendant Wolvy John yeoman 812225 812225 Wolvy, John, of Getele, yeoman 9
4848645 2311047 2311047 defendant Farewele Robert yeoman 812226 812226 Farewele, Robert, of Beterle, yeoman 10
4848646 2311047 2311047 defendant Yole Thomas yeoman 772679 772679 Yole, Thomas, of Great Beteryng, yeoman 11
4848647 2311047 2311047 defendant Egate John husbandman 586882 586882 Egate, John, of Betele, husbandman 12
4848648 2311047 2311047 defendant Large John yeoman 586882 586882 Large, John, of Betele, yeoman 13
4848649 2311047 2311047 defendant Fulthehous Maud widow 586882 586882 Fulthehous, Maud, of Betele, widow 14

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