names

13 rows where case_id = 2510617

✎ 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
5518490 2510617 2510617 plaintiff Zouche William esq   Zouche, William, esq 0
5518491 2510617 2510617 defendant Gell John husbandman 776633 776633 Gell, John, of Kerston, husbandman 0
5518492 2510617 2510617 defendant Ston Ralph husbandman 776633 776633 Ston, Ralph, of Kerston, husbandman 1
5518493 2510617 2510617 defendant Knowle Richard husbandman 776633 776633 Knowle, Richard, of Kerston, husbandman 2
5518494 2510617 2510617 defendant Coughyn Walter husbandman 586406 586406 Coughyn, Walter, of Hopton, husbandman 3
5518495 2510617 2510617 defendant Balydon John husbandman 586406 586406 Balydon, John, of Hopton, husbandman 4
5518496 2510617 2510617 defendant Eton Thomas husbandman 586406 586406 Eton, Thomas, of Hopton, husbandman 5
5518497 2510617 2510617 defendant Fletcher Roger weaver 586406 586406 Fletcher, Roger, of Hopton, weaver 6
5518498 2510617 2510617 defendant Syle John barker 591514 591514 Syle, John, of Worsworth, barker 7
5518499 2510617 2510617 defendant Harvy John walker 591514 591514 Harvy, John, of Worsworth, walker 8
5518500 2510617 2510617 defendant Dey John husbandman 588411 588411 Dey, John, of Irton, husbandman 9
5518501 2510617 2510617 defendant Gratton Robert husbandman 588411 588411 Gratton, Robert, of Irton, husbandman 10
5518502 2510617 2510617 defendant Markham Joan spinster 776633 776633 Markham, Joan, of Kerston, spinster 11

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