names

7 rows where case_id = 2357860

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5003293 2357860 2357860 plaintiff Paraunt John (legal representative) 833551 833551 Paraunt, John, of Stanstede Mount Fychett, executors of 0
5003294 2357860 2357860 plaintiff Paraunt Beatrice formerly wife of John   (Paraunt, Beatrice, formerly wife of John 1
5003295 2357860 2357860 plaintiff Hunt Richard     Hunt, Richard 2
5003296 2357860 2357860 defendant Forde John smith 833552 833552 Forde, John, of Little Halyngbury, smith 0
5003297 2357860 2357860 defendant Crabbe William husbandman 768843 768843 Crabbe, William, of Uggele, husbandman 1
5003298 2357860 2357860 defendant Mucheman James husbandman 833553 833553 Mucheman, James, of Rikelyng, husbandman 2
5003299 2357860 2357860 defendant Styward John husbandman 833554 833554 Styward, John, of Stanstede Mountfychett, husbandman 3

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