names

16 rows where place_id = 609049

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3676735 1918757 1918757 defendant Tomlyns Richard tailor 609049 609049 Tomlyns, Richard, of Cradley, Herefs, tailor 0
3875620 1982087 1982087 defendant Pytchard Richard gent 609049 609049 Pytchard, Richard, of Cradley, Herefs, gent 1
3921102 1997408 1997408 defendant Metrugge John gent 609049 609049 Metrugge, John, of Cradley, Herefs, gent 0
4135598 2073056 2073056 defendant Trovell Richard gent 609049 609049 Trovell, Richard, of Cradley, Herefs, gent 3
4167959 2084279 2084279 defendant Trovell Richard gent 609049 609049 Trovell, Richard, of Cradley, Herefs, gent 1
4236537 2108352 2108352 defendant Yate William yeoman 609049 609049 Yate, William, of Cradley, Herefs, yeoman 0
4245086 2111341 2111341 defendant Yate or Yeate William baker 609049 609049 Yate or Yeate, William, of Cradley, Herefs, yeoman, baker 0
4297734 2129294 2129294 defendant Pychard William gent 609049 609049 Pychard, William, of Cradley, Herefs, gent 0
4308997 2133301 2133301 defendant Pychard William gent 609049 609049 Pychard, William, of Cradley, Herefs, gent 0
4330827 2140609 2140609 defendant Hall William yeoman 609049 609049 Hall, William, of Cradley, Herefs, yeoman 1
4350591 2147470 2147470 defendant Pitchard William gent 609049 609049 Pitchard, William, of Cradley, Herefs, gent 1
4387188 2160368 2160368 defendant Pitchard Joseph gent 609049 609049 Pitchard, Joseph, of Cradley, Herefs, gent 0
5344206 2458365 2458365 defendant Chapman William clerk 609049 609049 Chapman, William, of Cradley, Herefs, clerk 0
5411047 2478258 2478258 defendant Whelar William husbandman 609049 609049 Whelar, William, of Cradley, Herefs, husbandman 0
5425204 2482506 2482506 defendant Whelar William husbandman 609049 609049 Whelar, William, of Cradley, Herefs, husbandman 0
5425208 2482508 2482508 defendant Wheler William husbandman 609049 609049 Wheler, William, of Cradley, Herefs, husbandman 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);