names

10 rows where place_id = 601978

✎ 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
3647889 1909735 1909735 defendant Bronde Henry clerk 601978 601978 Bronde, Henry, of Skornston, clerk 0
3775577 1950107 1950107 plaintiff Bolt Stephen   601978 601978 Bolt, Stephen, of Skornston 0
3990005 2021178 2021178 defendant Postell Ralph   601978 601978 Postell, Ralph, of Skornston, worsted weaver 0
3990006 2021178 2021178 defendant Postle Christopher   601978 601978 Postle, Christopher, of Skornston, worsted weaver 1
3992698 2022138 2022138 defendant Postell Ralph   601978 601978 Postell, Ralph, of Skornston, worsted weaver 0
4015035 2030074 2030074 defendant Warner John yeoman 601978 601978 (Warner, John, of Skornston, yeoman 11
4046231 2041093 2041093 plaintiff Shrewe or Shreve John husbandman 601978 601978 Shrewe or Shreve, John, of Skornston, husbandman 0
4046232 2041093 2041093 defendant Postell Ralph   601978 601978 Postell, Ralph, of Skornston, worsted weaver 0
4252979 2113989 2113989 defendant Worsted Nicholas laborer 601978 601978 Worsted, Nicholas, of Skornston, laborer 1
4252980 2113989 2113989 defendant Decker Stephen husbandman 601978 601978 Decker, Stephen, of Skornston, husbandman 2

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