names

11 rows where place_id = 847269

✎ 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
5108116 2388813 2388813 defendant Norton William husbandman 847269 847269 Norton, William, of Hederset, husbandman 0
5130196 2395316 2395316 defendant Miller Richard laborer 847269 847269 Miller, Richard, of Hederset, laborer 1
5168561 2406522 2406522 defendant Seman Thomas yeoman 847269 847269 Seman, Thomas, of Hederset, yeoman 0
5214508 2419973 2419973 defendant Pryce William gent 847269 847269 Pryce, William, of Hederset, gent 0
5250990 2430417 2430417 defendant Palmer Robert gent 847269 847269 Palmer, Robert, of Hederset, gent 1
5255717 2431904 2431904 defendant Eyre John yeoman 847269 847269 Eyre, John, of Hederset, yeoman 1
5481620 2499433 2499433 defendant Pagrave John gent 847269 847269 Pagrave, John, of Hederset, gent 3
5509287 2507758 2507758 defendant Flouredewe Thomas yeoman 847269 847269 Flouredewe, Thomas, of Hederset, yeoman 5
5562885 2523736 2523736 defendant Bette William smith 847269 847269 Bette, William, of Hederset, smith 0
5562889 2523737 2523737 defendant Bettys William smith 847269 847269 Bettys, William, of Hederset, smith 2
5598768 2534491 2534491 defendant Munteley Emma widow 847269 847269 Munteley, Emma, of Hederset, widow 3

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