names

14 rows where case_id = 1963627

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3818266 1963627 1963627 plaintiff Manners Thomas Earl of Rutland   Manners, Thomas, Earl of Rutland 0
3818267 1963627 1963627 defendant Crawe William fisher 634334 634334 Crawe, William, of Honytoft, fisher 0
3818268 1963627 1963627 defendant Rumforth Roger fisher 634335 634335 Rumforth, Roger, of Freeston, fisher 1
3818269 1963627 1963627 defendant Gybson John fisher 623455 623455 Gybson, John, of Fysshetoft, fisher 2
3818270 1963627 1963627 defendant Bustard Thomas fisher 623455 623455 Bustard, Thomas, of Fysshetoft, fisher 3
3818271 1963627 1963627 defendant Benne John fisher 634336 634336 Benne, John, of Kyndam, fisher 4
3818272 1963627 1963627 defendant Crosseley William husbandman 634335 634335 Crosseley, William, of Freeston, husbandman 5
3818273 1963627 1963627 defendant Harryson Thomas fisher 634335 634335 Harryson, Thomas, of Freeston, fisher 6
3818274 1963627 1963627 defendant Gilson Thomas fisher 634335 634335 Gilson, Thomas, of Freeston, fisher 7
3818275 1963627 1963627 defendant Pakhernes William, senior fisher 634335 634335 Pakhernes, William, senior, of Freeston, fisher 8
3818276 1963627 1963627 defendant Cley Richard husbandman 634335 634335 Cley, Richard, of Freeston, husbandman 9
3818277 1963627 1963627 defendant Wade John husbandman 634335 634335 Wade, John, of Freeston, husbandman 10
3818278 1963627 1963627 defendant Bysshop Thomas weaver 634335 634335 Bysshop, Thomas, of Freeston, weaver 11
3818279 1963627 1963627 defendant Pakhernes William, junior fisher 634335 634335 Pakhernes, William, junior, of Freeston, fisher 12

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