names

23 rows where place_id = 628396

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3782063 1952143 1952143 defendant Mychell John husbandman 628396 628396 Mychell, John, of Hartwell, husbandman 0
3830467 1967406 1967406 defendant Benet John husbandman 628396 628396 Benet, John, of Hartwell, husbandman 3
3843822 1971606 1971606 defendant Hayll Robert husbandman 628396 628396 Hayll, Robert, of Hartwell, husbandman 2
3894992 1988533 1988533 defendant Hayll William husbandman 628396 628396 Hayll, William, of Hartwell, husbandman 0
3909222 1993379 1993379 defendant Hayll William husbandman 628396 628396 Hayll, William, of Hartwell, husbandman 0
3951773 2007681 2007681 plaintiff Hampden Michael esq 628396 628396 Hampden, Michael, of Hartwell, esq 0
3951775 2007682 2007682 plaintiff Hampden Michael esq 628396 628396 Hampden, Michael, of Hartwell, esq 0
3966289 2012838 2012838 defendant Hampden Michael esq 628396 628396 Hampden, Michael, of Hartwell, esq 0
4093588 2058025 2058025 defendant Wake Richard esq 628396 628396 Wake, Richard, of Hartwell, esq 0
4755244 2282029 2282029 defendant Lymbury John clerk 628396 628396 Lymbury, John, of Hartwell, clerk 0
4755245 2282029 2282029 defendant Wort John husbandman 628396 628396 Wort, John, of Hartwell, husbandman 1
4755246 2282029 2282029 defendant Maryot Henry husbandman 628396 628396 Maryot, Henry, of Hartwell, husbandman 2
4836132 2307281 2307281 defendant Stokes Thomas gent 628396 628396 Stokes, Thomas, of Hartwell, gent 0
5148085 2400586 2400586 defendant Petyt Henry yeoman 628396 628396 Petyt, Henry, of Hartwell, yeoman 0
5148093 2400587 2400587 defendant Petyt Henry yeoman 628396 628396 together with Petyt, Henry, of Hartwell, yeoman 3
5151781 2401682 2401682 defendant Jenyn William husbandman 628396 628396 Jenyn, William, of Hartwell, husbandman 0
5151784 2401683 2401683 defendant Jenyn William husbandman 628396 628396 Jenyn, William, of Hartwell, husbandman 0
5151787 2401684 2401684 defendant Pardon William yeoman 628396 628396 Pardon, William, of Hartwell, yeoman 0
5188606 2412387 2412387 defendant Dey Richard husbandman 628396 628396 Dey, Richard, of Hartwell, husbandman 0
5206139 2417527 2417527 defendant Dey Richard husbandman 628396 628396 Dey, Richard, of Hartwell, husbandman 0
5320090 2451099 2451099 defendant Whiteley William husbandman 628396 628396 Whiteley, William, of Hartwell, husbandman 4
5506060 2506819 2506819 defendant Shurley Thomas grasier 628396 628396 Shurley, Thomas, of Hartwell, grasier 0
5558324 2522384 2522384 defendant Grave Lawrence husbandman 628396 628396 Grave, Lawrence, of Hartwell, 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);