names

13 rows where place_id = 768958

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4553760 2217098 2217098 defendant atte Dam Henry tanner 768958 768958 atte Dam, Henry, of Heigham by Norwich, tanner 0
4730186 2274641 2274641 plaintiff Lynstede John tanner 768958 768958 Lynstede, John, of Heigham by Norwich, tanner 0
4742347 2278254 2278254 defendant Joweler John   768958 768958 Joweler, John, of Heigham by Norwich, fuller & son of John, of Costesey 0
5126947 2394360 2394360 defendant Courle John   768958 768958 Courle, John, of Heigham by Norwich 0
5137768 2397557 2397557 defendant Stalon Thomas husbandman 768958 768958 Stalon, Thomas, of Heigham by Norwich, husbandman 2
5145672 2399876 2399876 defendant Courle John tanner 768958 768958 Courle, John, of Heigham by Norwich, tanner 0
5158472 2403597 2403597 defendant Stalon Thomas husbandman 768958 768958 Stalon, Thomas, of Heigham by Norwich, husbandman 2
5158761 2403683 2403683 defendant Aleyn John yeoman 768958 768958 Aleyn, John, of Heigham by Norwich, yeoman 0
5208904 2418328 2418328 defendant Aleyn Edmund yeoman 768958 768958 Aleyn, Edmund, of Heigham by Norwich, yeoman 0
5272042 2436904 2436904 defendant Aleyn John tanner 768958 768958 Aleyn, John, of Heigham by Norwich, tanner 3
5394379 2473459 2473459 defendant Courby Robert carrier 768958 768958 Courby, Robert, of Heigham by Norwich, carrier 1
5407584 2477239 2477239 defendant Courby Robert carrier 768958 768958 Courby, Robert, of Heigham by Norwich, carrier 0
5407614 2477247 2477247 defendant Stalon William yeoman 768958 768958 Stalon, William, of Heigham by Norwich, yeoman 2

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