names

19 rows where place_id = 645716

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3887019 1985921 1985921 defendant Preston Robert laborer 645716 645716 Preston, Robert, of Woodchurche, laborer 1
3887020 1985921 1985921 defendant Lam Peter carpenter 645716 645716 Lam, Peter, of Woodchurche, carpenter 2
3948754 2006632 2006632 defendant Lyrkyn alias Edward James tailor 645716 645716 Lyrkyn alias Edward, James, of Woodchurche, tailor 0
3954818 2008754 2008754 defendant Denton Christopher husbandman 645716 645716 Denton, Christopher, of Woodchurche, husbandman 0
3980631 2017838 2017838 defendant Kyrbye Francis singleman clothier 645716 645716 Kyrbye, Francis, of Woodchurche, clothier, or of Speldhurst, singleman clothier 0
4027246 2034392 2034392 defendant Edden or Iden Robert glover 645716 645716 Edden or Iden, Robert, of Woodchurche, glover 2
4032647 2036327 2036327 defendant Bygge Jervase shoemaker 645716 645716 Bygge, Jervase, of Woodchurche, shoemaker 1
4041399 2039416 2039416 defendant Bygge Gervase shoemaker 645716 645716 Bygge, Gervase, of Woodchurche, shoemaker 1
4068424 2049004 2049004 defendant Edward James tailor 645716 645716 Edward, James, of Woodchurche, tailor 0
4068425 2049004 2049004 defendant Swaffer James laborer 645716 645716 Swaffer, James, of Woodchurche, laborer 1
4104839 2062006 2062006 defendant Ryche Thomas yeoman 645716 645716 Ryche, Thomas, of Woodchurche, yeoman 0
4144834 2076352 2076352 defendant Ritche Thomas glover 645716 645716 Ritche, Thomas, of Woodchurche, glover 0
4202772 2096513 2096513 defendant Baycott Philip tanner 645716 645716 Baycott, Philip, of Woodchurche, tanner 1
4224608 2104083 2104083 defendant Waterhowse Edward (legal representative) 645716 645716 Waterhowse, Edward, of Woodchurche, knight, executrix of 0
4250759 2113230 2113230 defendant Waterhouse Edward (legal representative) 645716 645716 Waterhouse, Edward, of Woodchurche, knight, executrix of 0
4250762 2113231 2113231 defendant Waterhowse Edward (legal representative) 645716 645716 Waterhowse, Edward, of Woodchurche, knight, executrix of 0
4270206 2119619 2119619 defendant Howlt William carpenter 645716 645716 Howlt, William, of Woodchurche, carpenter 0
4369935 2154300 2154300 defendant Usmer Stephen husbandman 645716 645716 Usmer, Stephen, of Woodchurche, husbandman 0
4374337 2155888 2155888 defendant Latt John yeoman 645716 645716 Latt, John, of Woodchurche, yeoman 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);