names

17 rows where case_id = 2393540

✎ 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
5124216 2393540 2393540 plaintiff Yates John     Yates, John 0
5124217 2393540 2393540 defendant Otryngham Richard clerk 763746 763746 Otryngham, Richard, of Thirnyng, clerk 0
5124218 2393540 2393540 defendant Crouland of Osmindeston husbandman   Crouland, of Osmindeston, husbandman 1
5124219 2393540 2393540 defendant Yonge Adam   849161 849161 Yonge, Adam, of Westacre, husbandan 2
5124220 2393540 2393540 defendant Pers John husbandman 757115 757115 Pers, John, of Iteryngham, husbandman 3
5124221 2393540 2393540 defendant Fuller John husandman 754703 754703 Fuller, John, of Aldebergh, husandman 4
5124222 2393540 2393540 defendant Brethenham Roger husbandman 757115 757115 Brethenham, Roger, of Iteryngham, husbandman 5
5124223 2393540 2393540 defendant Avenaunt Robert laborer 586933 586933 Avenaunt, Robert, of Barford, laborer 6
5124224 2393540 2393540 defendant Bertram William smith 595314 595314 Bertram, William, of Sweynesthorp, smith 7
5124225 2393540 2393540 defendant Alford Thomas clerk 586572 586572 Alford, Thomas, of Berford, clerk 8
5124226 2393540 2393540 defendant Davy John yeoman 586102 586102 Davy, John, of Hengham, yeoman 9
5124227 2393540 2393540 defendant Warde Richard clerk 639783 639783 Warde, Richard, of Geldeston, clerk 10
5124228 2393540 2393540 defendant Wyndham Beatrice widow 587414 587414 Wyndham, Beatrice, of Thetford, widow 11
5124229 2393540 2393540 defendant Lynsted Edmund yeoman 594410 594410 Lynsted, Edmund, of Happesburgh, yeoman 12
5124230 2393540 2393540 defendant Brasyer Katherine (legal representative) 585936 585936 Brasyer, Katherine, of Norwich, widow, executors of 13
5124231 2393540 2393540 defendant Same Walter brasier 585936 585936 (Same, Walter, of Norwich, brasier 14
5124232 2393540 2393540 defendant Kyngessey Thomas   585936 585936 Kyngessey, Thomas, of Norwich, notary 15

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