names

13 rows where place_id = 596660

✎ 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
3625656 1875560 1875560 defendant Wyles John husbandman 596660 596660 Wyles, John, of Whitwell, Derbs, husbandman 0
3903087 1991262 1991262 defendant Rye Brian gent 596660 596660 Rye, Brian, of Whitwell, Derbs, gent 0
4011503 2028871 2028871 defendant Slater Alexander yeoman 596660 596660 Slater, Alexander, of Whitwell, Derbs, yeoman 9
4077390 2052200 2052200 defendant Mylnes Robert yeoman 596660 596660 Mylnes, Robert, of Whitwell, Derbs, yeoman 0
4751374 2280880 2280880 defendant Shirokes Lambert   596660 596660 Shirokes, Lambert, of Whitwell, Derbs 0
4765917 2285336 2285336 defendant Shireokes Lambert yeoman 596660 596660 Shireokes, Lambert, of Whitwell, Derbs, yeoman 2
4767257 2285746 2285746 defendant shirokes Lambert   596660 596660 shirokes, Lambert, of Whitwell, Derbs, bailiff 1
4790346 2293065 2293065 defendant Shireokes Lambert yeoman 596660 596660 Shireokes, Lambert, of Whitwell, Derbs, yeoman 1
4791683 2293497 2293497 defendant Shirokes Lambert   596660 596660 Shirokes, Lambert, of Whitwell, Derbs, bailiff 1
5128039 2394676 2394676 defendant Stevenson William husbandman 596660 596660 Stevenson, William, of Whitwell, Derbs, husbandman 0
5248769 2429761 2429761 defendant Mychell John husbandman 596660 596660 Mychell, John, of Whitwell, Derbs, husbandman 10
5256527 2432162 2432162 defendant Rye Robert husbandman 596660 596660 Rye, Robert, of Whitwell, Derbs, husbandman 2
5265569 2434987 2434987 defendant Michel John husbandman 596660 596660 Michel, John, of Whitwell, Derbs, husbandman 5

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