names

12 rows where place_id = 637118

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3834556 1968743 1968743 defendant Hogges John, senior husbandman 637118 637118 Hogges, John, senior, of Alampton, husbandman 0
3834557 1968743 1968743 defendant Hogges John, junior laborer 637118 637118 Hogges, John, junior, of Alampton, laborer 1
3834558 1968743 1968743 defendant Hogges Robert laborer 637118 637118 Hogges, Robert, of Alampton, laborer 2
4487215 2196724 2196724 defendant Wyke John   637118 637118 Wyke, John, of Alampton 0
4491987 2198182 2198182 plaintiff Wyke John   637118 637118 Wyke, John, of Alampton 0
4491989 2198183 2198183 plaintiff Wyke John   637118 637118 Wyke, John, of Alampton 0
4494965 2199113 2199113 defendant Wyke John   637118 637118 Wyke, John, of Alampton 1
4494968 2199114 2199114 defendant Wyke John   637118 637118 Wyke, John, of Alampton 1
4524394 2207968 2207968 defendant Bucke William   637118 637118 Bucke, William, of Alampton 0
4622634 2238056 2238056 defendant Bukke Thomas   637118 637118 Bukke, Thomas, of Alampton 4
4622635 2238056 2238056 defendant Colman William   637118 637118 Colman, William, of Alampton 5
5508991 2507669 2507669 defendant Woky William husbandman 637118 637118 Woky, William, of Alampton, husbandman 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);