names

12 rows where place_id = 606548

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3665632 1915201 1915201 defendant Reynold William yeoman 606548 606548 Reynold, William, of Ticehurst, yeoman 0
4705072 2266958 2266958 defendant Bereworth John thatcher 606548 606548 Bereworth, John, of Ticehurst, thatcher 0
4707763 2267796 2267796 defendant Harlesey Robert husbandman 606548 606548 Harlesey, Robert, of Ticehurst, husbandman 0
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
4760789 2283712 2283712 defendant Kychyinman John tailor 606548 606548 Kychyinman, John, of Ticehurst, tailor 12
4764979 2285022 2285022 plaintiff Holmane John, sen   606548 606548 Holmane, John, sen, of Ticehurst 0
4828510 2304957 2304957 defendant Keneward William butcher 606548 606548 Keneward, William, of Ticehurst, butcher 2
4828967 2305103 2305103 defendant Belse_ Stephen husbandman 606548 606548 Belse_, Stephen, of Ticehurst, husbandman 0
4830942 2305702 2305702 defendant Waterere John   606548 606548 Waterere, John, of Ticehurst 1
4840143 2308467 2308467 defendant Bereword John tanner 606548 606548 Bereword, John, of Ticehurst, tanner 0

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