names

22 rows where place_id = 761628

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4480488 2194560 2194560 defendant Haymond Thomas   761628 761628 Haymond, Thomas, of Berkhamstede, Herts 1
4663538 2250075 2250075 defendant Daunser Henry goldsmith 761628 761628 Daunser, Henry, of Berkhamstede, Herts, goldsmith 0
4699020 2265165 2265165 defendant Scalle John victualler 761628 761628 Scalle, John, of Berkhamstede, Herts, victualler 1
4699023 2265166 2265166 defendant Scalle John victualler 761628 761628 Scalle, John, of Berkhamstede, Herts, victualler 1
4705405 2267058 2267058 defendant Porcas John gent 761628 761628 Porcas, John, of Berkhamstede, Herts, gent 0
4735036 2276105 2276105 defendant Frende Thomas miller 761628 761628 Frende, Thomas, of Berkhamstede, Herts, miller 0
4848523 2311014 2311014 defendant E_ John chapman 761628 761628 E_, John, of Berkhamstede, Herts, chapman 3
4848583 2311031 2311031 defendant Banage John chapman 761628 761628 Banage, John, of Berkhamstede, Herts, chapman 2
4854836 2312863 2312863 defendant Hardewyk John husbandman 761628 761628 Hardewyk, John, of Berkhamstede, Herts, husbandman 1
4863125 2315443 2315443 defendant More Richard smith 761628 761628 More, Richard, of Berkhamstede, Herts, smith 4
4879518 2320522 2320522 defendant Lyfe John dyer 761628 761628 Lyfe, John, of Berkhamstede, Herts, dyer 0
4905968 2328466 2328466 defendant Asshell John yeoman 761628 761628 Asshell, John, of Berkhamstede, Herts, yeoman 4
5030948 2365923 2365923 defendant Martyn William laborer 761628 761628 Martyn, William, of Berkhamstede, Herts, laborer 0
5078265 2379987 2379987 defendant Ryche John smith 761628 761628 Ryche, John, of Berkhamstede, Herts, smith 1
5258242 2432697 2432697 defendant Draughton Stephen chapman 761628 761628 Draughton, Stephen, of Berkhamstede, Herts, chapman 0
5284510 2440482 2440482 defendant Gonne William husbabndman 761628 761628 Gonne, William, of Berkhamstede, Herts, husbabndman 0
5324555 2452427 2452427 defendant Gonne John yeoman 761628 761628 Gonne, John, of Berkhamstede, Herts, yeoman 2
5369009 2465899 2465899 defendant Moldere Henry   761628 761628 Moldere, Henry, of Berkhamstede, Herts, shovel maker 0
5435615 2485590 2485590 defendant Cony Robert chapman 761628 761628 Cony, Robert, of Berkhamstede, Herts, chapman 0
5495222 2503466 2503466 defendant Rutlond William husbandman 761628 761628 Rutlond, William, of Berkhamstede, Herts, husbandman 0
5516564 2510010 2510010 plaintiff Talbot Nicholas   761628 761628 Talbot, Nicholas, of Berkhamstede, Herts 0
5556246 2521822 2521822 defendant de la Hay Edward gent 761628 761628 de la Hay, Edward, of Berkhamstede, Herts, gent 4

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