names

19 rows where place_id = 781694

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4673935 2257465 2257465 defendant Nicolson Walter yeoman 781694 781694 Nicolson, Walter, of Temple Soureby, yeoman 0
4759765 2283392 2283392 defendant Dikson John yeoman 781694 781694 Dikson, John, of Temple Soureby, yeoman 2
4780437 2289880 2289880 defendant del Hall Richard husbandman 781694 781694 del Hall, Richard, of Temple Soureby, husbandman 1
4781915 2290353 2290353 defendant Dykson John yeoman 781694 781694 Dykson, John, of Temple Soureby, yeoman 1
4886700 2322701 2322701 defendant Soureby Richard yeoman 781694 781694 together with Soureby, Richard, of Temple Soureby, yeoman 5
5018746 2362376 2362376 defendant Burcy John smith 781694 781694 Burcy, John, of Temple Soureby, smith 0
5018747 2362376 2362376 defendant Gayle William husbandman 781694 781694 Gayle, William, of Temple Soureby, husbandman 1
5018748 2362376 2362376 defendant Blamyre Richard yeoman 781694 781694 Blamyre, Richard, of Temple Soureby, yeoman 2
5018749 2362376 2362376 defendant Staple John yeoman 781694 781694 Staple, John, of Temple Soureby, yeoman 3
5018750 2362376 2362376 defendant Lonson William yeoman 781694 781694 Lonson, William, of Temple Soureby, yeoman 4
5018751 2362376 2362376 defendant Wylson John yeoman 781694 781694 Wylson, John, of Temple Soureby, yeoman 5
5018752 2362376 2362376 defendant Johnson William yeoman 781694 781694 Johnson, William, of Temple Soureby, yeoman 6
5018753 2362376 2362376 defendant Soureby Richard yeoman 781694 781694 Soureby, Richard, of Temple Soureby, yeoman 7
5018754 2362376 2362376 defendant Soureby William yeoman 781694 781694 Soureby, William, of Temple Soureby, yeoman 8
5018755 2362376 2362376 defendant Hall Richard yeoman 781694 781694 Hall, Richard, of Temple Soureby, yeoman 9
5018756 2362376 2362376 defendant Soureby John yeoman 781694 781694 Soureby, John, of Temple Soureby, yeoman 10
5018757 2362376 2362376 defendant Hertlay William yeoman 781694 781694 Hertlay, William, of Temple Soureby, yeoman 11
5018758 2362376 2362376 defendant Hall Robert yeoman 781694 781694 Hall, Robert, of Temple Soureby, yeoman 12
5633195 2554387 2554387 defendant de Bate Henry yeoman 781694 781694 de Bate, Henry, of Temple Soureby, yeoman 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);