names

14 rows where place_id = 610051

✎ 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
3681716 1920379 1920379 defendant Morcok John husbandman 610051 610051 Morcok, John, of Ardelegh, husbandman 0
3753917 1943173 1943173 defendant Weye Thomas weaver 610051 610051 Weye, Thomas, of Ardelegh, weaver 0
3873789 1981454 1981454 defendant Starlyng James clothmaker 610051 610051 Starlyng, James, of Ardelegh, clothmaker 0
4433452 2175223 2175223 defendant Warde John   610051 610051 Warde, John, of Ardelegh 1
4493633 2198707 2198707 defendant Swyke John   610051 610051 Swyke, John, of Ardelegh 6
4657472 2248229 2248229 defendant Wayte John weaver 610051 610051 Wayte, John, of Ardelegh, weaver 2
4667527 2255564 2255564 defendant Frost Roger fuller 610051 610051 Frost, Roger, of Ardelegh, fuller 0
4678770 2258964 2258964 defendant Clerk James fuller 610051 610051 Clerk, James, of Ardelegh, fuller 0
4678775 2258965 2258965 defendant Cole John weaver 610051 610051 Cole, John, of Ardelegh, weaver 0
4712852 2269330 2269330 defendant Cook Thomas yeoman 610051 610051 Cook, Thomas, of Ardelegh, yeoman 2
4748803 2280136 2280136 plaintiff Mont William   610051 610051 Mont, William, of Ardelegh 0
4748804 2280136 2280136 defendant Bode Thomas yeoman 610051 610051 Bode, Thomas, of Ardelegh, yeoman 0
4770226 2286663 2286663 plaintiff Pychard William   610051 610051 Pychard, William, of Ardelegh 0
5565503 2524505 2524505 defendant Aleyn John husbandman 610051 610051 Aleyn, John, of Ardelegh, 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);