names

11 rows where place_id = 691700

✎ 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
4091217 2057147 2057147 defendant Hawghfen John clerk 691700 691700 Hawghfen, John, of Bromeswall, clerk 2
4276431 2121700 2121700 defendant Waylond Thomas yeoman 691700 691700 Waylond, Thomas, of Bromeswall, yeoman 0
4279730 2122828 2122828 defendant Sharpe George husbandman 691700 691700 Sharpe, George, of Bromeswall, husbandman 1
4311046 2134010 2134010 defendant Rogers Edmund husbandman 691700 691700 Rogers, Edmund, of Bromeswall, husbandman 0
4356067 2149343 2149343 plaintiff Wade Joan singlewoman 691700 691700 Joan his wife, formerly Joan Reynoldes, of Bromeswall, singlewoman 1
4671396 2256702 2256702 defendant Gyn William husbandman 691700 691700 Gyn, William, of Bromeswall, husbandman 1
4712890 2269343 2269343 defendant Gyn William   691700 691700 Gyn, William, of Bromeswall, pedlar 2
4720936 2271880 2271880 defendant Gyn William potter 691700 691700 Gyn, William, of Bromeswall, potter 1
4746542 2279482 2279482 defendant Gyn John pedder 691700 691700 Gyn, John, of Bromeswall, pedder 0
4746621 2279502 2279502 defendant Pertriche John carpenter 691700 691700 Pertriche, John, of Bromeswall, carpenter 0
4884060 2321926 2321926 defendant Legg John husbandman 691700 691700 Legg, John, of Bromeswall, 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);