names

14 rows where case_id = 2441649

✎ 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
5288485 2441649 2441649 plaintiff Lomnore William     Lomnore, William 0
5288486 2441649 2441649 defendant Roos Richard esq 585936 585936 Roos, Richard, of Norwich, esq 0
5288487 2441649 2441649 defendant Richardys Thomas yeoman 588583 588583 Richardys, Thomas, of Caston, yeoman 1
5288488 2441649 2441649 defendant Dunham William pedder 590484 590484 Dunham, William, of Watton, pedder 2
5288489 2441649 2441649 defendant Davy Alexander husbandman 594908 594908 Davy, Alexander, of Ovyngton, husbandman 3
5288490 2441649 2441649 defendant Wryght William husbandman 585900 585900 Wryght, William, of Saham Tony, husbandman 4
5288491 2441649 2441649 defendant Selby John husbandman 586523 586523 Selby, John, of Cley juxta Mare, husbandman 5
5288492 2441649 2441649 defendant Too John husbandman 592344 592344 Too, John, of Holt, husbandman 6
5288493 2441649 2441649 defendant Chambyr Thomas yeoman 592344 592344 Chambyr, Thomas, of Holt, yeoman 7
5288494 2441649 2441649 defendant Atkynson Thomas mariner 586523 586523 Atkynson, Thomas, of Cley juxta Mare, mariner 8
5288495 2441649 2441649 defendant Hervy Michael carpenter 586523 586523 Hervy, Michael, of Cley juxta Mare, carpenter 9
5288496 2441649 2441649 defendant Pyrt Robert raffman 592344 592344 Pyrt, Robert, of Holt, raffman 10
5288497 2441649 2441649 defendant Hunte John yeoman 592344 592344 Hunte, John, of Holt, yeoman 11
5288498 2441649 2441649 defendant York Richard tailor 586523 586523 York, Richard, of Cley juxta Mare, tailor 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);