names

24 rows where place_id = 623535

✎ 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
3631409 1904636 1904636 defendant Choppyn Edward   623535 623535 Choppyn, Edward, of Esterford, wax chandler 0
3631472 1904657 1904657 defendant Choppyn Edward   623535 623535 Choppyn, Edward, of Esterford, wax chandler 0
3752996 1942869 1942869 defendant Coppyn John laborer 623535 623535 Coppyn, John, of Esterford, laborer 1
3755300 1943612 1943612 defendant Fyrote John fuller 623535 623535 Fyrote, John, of Esterford, fuller 4
3873727 1981431 1981431 defendant Wood alias Mathew John innholder 623535 623535 Wood alias Mathew, John, of Esterford, innholder 0
3883040 1984594 1984594 defendant Beston John innholder 623535 623535 Beston, John, of Esterford, innholder 1
3883043 1984595 1984595 defendant Beston John innholder 623535 623535 Beston, John, of Esterford, innholder 1
4607569 2233476 2233476 defendant Russell John   623535 623535 Russell, John, of Esterford 1
4734496 2275956 2275956 defendant Typ Henry shoemaker 623535 623535 Typ, Henry, of Esterford, shoemaker 0
4882123 2321309 2321309 defendant Vys Richard hosteler 623535 623535 Vys, Richard, of Esterford, hosteler 1
4900007 2326640 2326640 defendant Saycok John yeoman 623535 623535 Saycok, John, of Esterford, yeoman 2
4903578 2327731 2327731 defendant Vys Richard hosteler 623535 623535 Vys, Richard, of Esterford, hosteler 1
4916426 2331636 2331636 defendant Russell Thomas fuller 623535 623535 Russell, Thomas, of Esterford, fuller 2
4922115 2333329 2333329 defendant Bedford Henry gent 623535 623535 Bedford, Henry, of Esterford, gent 0
5079066 2380226 2380226 defendant Roger Richard butcher 623535 623535 Roger, Richard, of Esterford, butcher 3
5087792 2382812 2382812 defendant Clerk John husbandman 623535 623535 Clerk, John, of Esterford, husbandman 0
5093919 2384620 2384620 defendant Clerk John yeoman 623535 623535 Clerk, John, of Esterford, yeoman 2
5187352 2412026 2412026 defendant Norfolk Margaret widow 623535 623535 Norfolk, Margaret, of Esterford, widow 3
5323159 2452009 2452009 defendant Copdok John carpenter 623535 623535 Copdok, John, of Esterford, carpenter 1
5378009 2468700 2468700 defendant Chamber John yeoman 623535 623535 Chamber, John, of Esterford, yeoman 3
5388535 2471775 2471775 defendant Berebrewer Gerard beer brewer 623535 623535 Berebrewer, Gerard, of Esterford, beer brewer 0
5393658 2473247 2473247 defendant Chamber John yeoman 623535 623535 Chamber, John, of Esterford, yeoman 3
5393774 2473277 2473277 defendant Chamber John yeoman 623535 623535 Chamber, John, of Esterford, yeoman 3
5510088 2507991 2507991 defendant Cade Robert yeoman 623535 623535 Cade, Robert, of Esterford, yeoman 2

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