names

19 rows where place_id = 593427

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611779 1871350 1871350 defendant Smyth William husbandman 593427 593427 Smyth, William, of Old Malton, husbandman 0
3611780 1871350 1871350 defendant Jurdan Robert husbandman 593427 593427 Jurdan, Robert, of Old Malton, husbandman 1
3836196 1969234 1969234 defendant Percy Robert gent 593427 593427 Percy, Robert, of Old Malton, gent 0
3846474 1972450 1972450 defendant Clappham John laborer 593427 593427 Clappham, John, of Old Malton, laborer 1
4053834 2043749 2043749 defendant Bell Robert yeoman 593427 593427 Bell, Robert, of Old Malton, yeoman 0
4081257 2053605 2053605 defendant Todde Ralph yeoman 593427 593427 Todde, Ralph, of Old Malton, yeoman 0
4165048 2083281 2083281 defendant Bell Robert yeoman 593427 593427 Bell, Robert, of Old Malton, yeoman 1
4262216 2117035 2117035 defendant Atkinson John yeoman 593427 593427 Atkinson, John, of Old Malton, yeoman 3
4262221 2117036 2117036 defendant Atkynson John yeoman 593427 593427 Atkynson, John, of Old Malton, yeoman 3
4277800 2122160 2122160 defendant Yowerte Thomas draper 593427 593427 Yowerte, Thomas, of Old Malton, draper 0
4277801 2122160 2122160 defendant Hardwick John   593427 593427 Hardwick, John, of Old Malton 1
4278659 2122470 2122470 defendant Wardell Richard yeoman 593427 593427 Wardell, Richard, of Old Malton, yeoman 0
4278661 2122470 2122470 defendant Medd Richard yeoman 593427 593427 Medd, Richard, of Old Malton, yeoman 2
4278662 2122470 2122470 defendant Edwardes Robert yeoman 593427 593427 Edwardes, Robert, of Old Malton, yeoman 3
4314545 2135200 2135200 defendant Hardwick John draper 593427 593427 Hardwick, John, of Old Malton, draper 1
5004078 2358079 2358079 defendant Cartwright John laborer 593427 593427 Cartwright, John, of Old Malton, laborer 0
5130455 2395395 2395395 defendant Mason Edmund tailor 593427 593427 Mason, Edmund, of Old Malton, tailor 7
5149857 2401091 2401091 defendant Mason Edmund tailor 593427 593427 Mason, Edmund, of Old Malton, tailor 6
5622477 2550955 2550955 plaintiff Wald Richard clerk 593427 593427 Wald, Richard, of Old Malton, formerly servant of William de Sadford, clerk 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);