names

16 rows where case_id = 2535988

✎ 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
5603544 2535988 2535988 plaintiff Payn John     Payn, John 0
5603545 2535988 2535988 defendant Cannok Thomas butcher 588755 588755 Cannok, Thomas, of Teryngton, butcher 0
5603546 2535988 2535988 defendant Elwarde Simon butcher 586057 586057 Elwarde, Simon, of Walpole, butcher 1
5603547 2535988 2535988 defendant Cheles John tanner 586057 586057 Cheles, John, of Walpole, tanner 2
5603548 2535988 2535988 defendant Thompson Thomas husbandman 586057 586057 Thompson, Thomas, of Walpole, husbandman 3
5603549 2535988 2535988 defendant Meye Matilda widow 586057 586057 Meye, Matilda, of Walpole, widow 4
5603550 2535988 2535988 defendant Bek John laborer 588755 588755 Bek, John, of Teryngton, laborer 5
5603551 2535988 2535988 defendant Baldyng John husbandman 588755 588755 Baldyng, John, of Teryngton, husbandman 6
5603552 2535988 2535988 defendant Saye Katherine widow 588755 588755 Saye, Katherine, of Teryngton, widow 7
5603553 2535988 2535988 defendant Lacy Augustine   588755 588755 Lacy, Augustine, of Teryngton, woollen weaver 8
5603554 2535988 2535988 defendant Redesam Alice widow 588755 588755 Redesam, Alice, of Teryngton, widow 9
5603555 2535988 2535988 defendant Saye John carpenter 588755 588755 Saye, John, of Teryngton, carpenter 10
5603556 2535988 2535988 defendant Hardy John, senior husbandman 588755 588755 Hardy, John, senior, of Teryngton, husbandman 11
5603557 2535988 2535988 defendant Archar Walter husbandman 595396 595396 Archar, Walter, of Emneth, husbandman 12
5603558 2535988 2535988 defendant Colt Henry laborer 828776 828776 Colt, Henry, of Elm, Cams, laborer 13
5603559 2535988 2535988 defendant Barker John husbandman 775670 775670 Barker, John, of Elm, husbandman 14

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