names

16 rows where place_id = 648093

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3899863 1990166 1990166 defendant Whalley John husbandman 648093 648093 Whalley, John, of Marnham, husbandman 0
4456528 2187062 2187062 defendant Prynce Thomas   648093 648093 Prynce, Thomas, of Marnham, vicar 0
4456530 2187063 2187063 defendant Prynt or Pryvot Thomas   648093 648093 Prynt or Pryvot, Thomas, of Marnham, vicar 0
4493088 2198538 2198538 plaintiff atte Halle John   648093 648093 atte Halle, John, of Marnham 0
4537442 2211978 2211978 plaintiff Sybson John   648093 648093 Sybson, John, of Marnham 0
4591484 2228691 2228691 defendant Carter Robert   648093 648093 Carter, Robert, of Marnham 2
4596443 2230135 2230135 defendant Carter Robert   648093 648093 Carter, Robert, of Marnham 2
4849434 2311297 2311297 defendant Groucok William   648093 648093 Groucok, William, of Marnham, vicar 0
4947679 2341261 2341261 defendant Cropher Robert   648093 648093 Cropher, Robert, of Marnham, wright 2
4947683 2341262 2341262 defendant Cheffeld Robert butcher 648093 648093 Cheffeld, Robert, of Marnham, butcher 1
5017794 2362084 2362084 defendant Shefeld Robert husbandman 648093 648093 Shefeld, Robert, of Marnham, husbandman 2
5246486 2429134 2429134 defendant Halle John husbandman 648093 648093 Halle, John, of Marnham, husbandman 7
5311041 2448334 2448334 defendant Yatys John yeoman 648093 648093 Yatys, John, of Marnham, yeoman 1
5311042 2448334 2448334 defendant Yatys Robert, sen husbandman 648093 648093 Yatys, Robert, sen, of Marnham, husbandman 2
5529377 2513702 2513702 defendant Flyntham William husbandman 648093 648093 Flyntham, William, of Marnham, husbandman 0
5629724 2553289 2553289 defendant atte Nelles Richard husbandman 648093 648093 atte Nelles, Richard, of Marnham, husbandman 1

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