names

6 rows where place_id = 753943

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4416995 2170185 2170185 defendant Caleys Alan   753943 753943 Caleys, Alan, of Little Grymesby 0
4733685 2275713 2275713 defendant Parys William laborer 753943 753943 Parys, William, of Little Grymesby, laborer 0
4733686 2275713 2275713 defendant Parys Ralph husbandman 753943 753943 Parys, Ralph, of Little Grymesby, husbandman 1
5003190 2357834 2357834 defendant Pygot Robert husbandman 753943 753943 Pygot, Robert, of Little Grymesby, husbandman 0
5425584 2482630 2482630 defendant Grose William husbandman 753943 753943 Grose, William, of Little Grymesby, husbandman 0
5425585 2482630 2482630 defendant Ireland Thomas husbandman 753943 753943 Ireland, Thomas, of Little Grymesby, husbandman 1

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