names

13 rows where place_id = 674381

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4013767 2029655 2029655 defendant Pytt John yeoman 674381 674381 Pytt, John, of Colwall, Herefs, yeoman 1
4237536 2108720 2108720 defendant Hartland Robert yeoman 674381 674381 Hartland, Robert, of Colwall, Herefs, yeoman 0
4240132 2109669 2109669 defendant Trevell Charles gent 674381 674381 Trevell, Charles, of Colwall, Herefs, gent 2
4252638 2113873 2113873 defendant Bradford Edmund yeoman 674381 674381 Bradford, Edmund, of Colwall, Herefs, yeoman 2
4252642 2113874 2113874 defendant Bradford Edmund yeoman 674381 674381 Bradford, Edmund, of Colwall, Herefs, yeoman 2
4300942 2130438 2130438 defendant Salford Thomas husbandman 674381 674381 Salford, Thomas, of Colwall, Herefs, husbandman 0
4300943 2130438 2130438 defendant Cubberley William glover 674381 674381 Cubberley, William, of Colwall, Herefs, glover 1
4314348 2135129 2135129 defendant Pitt George husbandman 674381 674381 Pitt, George, of Colwall, Herefs, husbandman 0
4372116 2155093 2155093 defendant Pytt John butcher 674381 674381 Pytt, John, of Colwall, Herefs, butcher 0
4400306 2164694 2164694 defendant Trovell Charles gent 674381 674381 Trovell, Charles, of Colwall, Herefs, gent 0
5019669 2362636 2362636 defendant Coweley William yeoman 674381 674381 Coweley, William, of Colwall, Herefs, yeoman 0
5157628 2403359 2403359 defendant Paty John husbandman 674381 674381 Paty, John, of Colwall, Herefs, husbandman 3
5432597 2484718 2484718 defendant Appathe John husbandman 674381 674381 Appathe, John, of Colwall, Herefs, husbandman 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);