names

12 rows where place_id = 589520

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597853 1866947 1866947 defendant Wode William husbandman 589520 589520 Wode, William, of Pecham, husbandman 2
3785137 1953139 1953139 plaintiff Muschampe William gent 589520 589520 Muschampe, William, of Pecham, gent 0
3855867 1975463 1975463 defendant Bredon John yeoman 589520 589520 Bredon, John, of Pecham, yeoman 1
4028212 2034739 2034739 defendant Pattenden Henry yeoman 589520 589520 Pattenden, Henry, of Pecham, yeoman 0
4652706 2246783 2246783 defendant atte Helle Simon husbandman 589520 589520 atte Helle, Simon, of Pecham, husbandman 21
4652708 2246783 2246783 defendant Wade Thomas husbandman 589520 589520 Wade, Thomas, of Pecham, husbandman 23
4749184 2280242 2280242 defendant Cage Richard tailor 589520 589520 Cage, Richard, of Pecham, tailor 0
4749185 2280242 2280242 defendant Caisere Alice widow 589520 589520 Caisere, Alice, of Pecham, widow 1
4760733 2283697 2283697 defendant Webbe John husbandman 589520 589520 Webbe, John, of Pecham, husbandman 1
4787866 2292270 2292270 defendant Carpenter Thomas husbandman 589520 589520 Carpenter, Thomas, of Pecham, husbandman 0
4813006 2300184 2300184 defendant Aleyn Robert laborer 589520 589520 Aleyn, Robert, of Pecham, laborer 0
4940569 2339075 2339075 defendant Halker Robert husbandman 589520 589520 Halker, Robert, of Pecham, husbandman 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);