names

16 rows where case_id = 2283712

✎ 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
4760776 2283712 2283712 plaintiff Darell John esq   Darell, John, esq 0
4760777 2283712 2283712 defendant Netter Richard   766472 766472 Netter, Richard, of Combwell, Kent, prior 0
4760778 2283712 2283712 defendant Pende Robert yoeman 766470 766470 Pende, Robert, of Combwell, Kent, yoeman 1
4760779 2283712 2283712 defendant atte Wode Simon husbandman 700043 700043 atte Wode, Simon, of Goudhurst, Kent, husbandman 2
4760780 2283712 2283712 defendant atte Stone Walter laborer 770318 770318 atte Stone, Walter, of Goudhurst, laborer 3
4760781 2283712 2283712 defendant atte Stone Thomas laborer 770318 770318 atte Stone, Thomas, of Goudhurst, laborer 4
4760782 2283712 2283712 defendant Beche Thomas husbandman   Beche, Thomas, husbandman 5
4760783 2283712 2283712 defendant Wygge Simon husbandman 770318 770318 Wygge, Simon, of Goudhurst, husbandman 6
4760784 2283712 2283712 defendant Baker William husbandman 787641 787641 Baker, William, of Ticehurst, Sussex, husbandman 7
4760785 2283712 2283712 defendant Haselhersh Gabriel husbandman 606548 606548 Haselhersh, Gabriel, of Ticehurst, husbandman 8
4760786 2283712 2283712 defendant Haselhersh John husbandman 606548 606548 Haselhersh, John, of Ticehurst, husbandman 9
4760787 2283712 2283712 defendant Wyllyam John husbandman 606548 606548 Wyllyam, John, of Ticehurst, husbandman 10
4760788 2283712 2283712 defendant Kyneward Geoffrey husbandman 636100 636100 Kyneward, Geoffrey, of Sussex, husbandman 11
4760789 2283712 2283712 defendant Kychyinman John tailor 606548 606548 Kychyinman, John, of Ticehurst, tailor 12
4760790 2283712 2283712 defendant Smyth John husbandman 766472 766472 Smyth, John, of Combwell, husbandman 13
4760791 2283712 2283712 defendant Harlesey William husbandman 637687 637687 Harlesey, William, of Lamberhurst, Sussex, 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);