names

8 rows where place_id = 592889

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3609289 1870563 1870563 defendant Frevyle John gent 592889 592889 Frevyle, John, of Shelford, Cams, gent 4
3730032 1935634 1935634 defendant Sawston William gent 592889 592889 Sawston, William, of Shelford, Cams, gent 1
4201802 2096171 2096171 defendant Ratclyf Robert gent 592889 592889 Ratclyf, Robert, of Shelford, Cams, gent 19
4863408 2315524 2315524 defendant Charite Robert husbandman 592889 592889 Charite, Robert, of Shelford, Cams, husbandman 2
4941787 2339441 2339441 defendant Vaus or Vans William esq 592889 592889 Vaus or Vans, William, of Shelford, Cams, esq 1
4967018 2347068 2347068 defendant Morton William clerk 592889 592889 Morton, William, of Shelford, Cams, clerk 0
5318004 2450473 2450473 defendant Cooke Thomas carter 592889 592889 Cooke, Thomas, of Shelford, Cams, carter 1
5631537 2553875 2553875 defendant Speed John   592889 592889 Speed, John, of Shelford, Cams, corn buyer 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);