names

7 rows where place_id = 603346

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654244 1911586 1911586 defendant Portelatt Robert husbandman 603346 603346 Portelatt, Robert, of latton, Wilts, husbandman 1
4107519 2062976 2062976 defendant Prater Nicholas gent 603346 603346 Prater, Nicholas, of Latton, Wilts, gent 1
4188447 2091438 2091438 defendant Prater John gent 603346 603346 Prater, John, of Latton, Wilts, gent 17
4265281 2118031 2118031 defendant Prater Bartholomew gent 603346 603346 Prater, Bartholomew, of Latton, Wilts, gent 0
4824321 2303670 2303670 defendant Baron Walter husbandman 603346 603346 Baron, Walter, of Latton, Wilts, husbandman 2
5192554 2413555 2413555 defendant Saye Walter clerk 603346 603346 Saye, Walter, of Latton, Wilts, clerk 4
5374365 2467586 2467586 defendant Llamier or Llanner John   603346 603346 Llamier or Llanner, John, of Latton, Wilts, parson 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);