names

36 rows where place_id = 623735

✎ 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
3754056 1943215 1943215 defendant Scotte William clerk 623735 623735 Scotte, William, of Longford, Derbs, clerk 0
3872921 1981160 1981160 defendant Longford Ralph   623735 623735 Longford, Ralph, of Longford, Derbs, knight 2
3907942 1992947 1992947 defendant Tatton Nicholas gent 623735 623735 Tatton, Nicholas, of Longford, Derbs, gent 0
4975380 2349596 2349596 defendant Longford George gent 623735 623735 Longford, George, of Longford, Derbs, gent 0
4989163 2353696 2353696 defendant Stokkes Henry yeoman 623735 623735 Stokkes, Henry, of Longford, Derbs, yeoman 2
4991223 2354259 2354259 defendant Longford Nicholas   623735 623735 Longford, Nicholas, of Longford, Derbs, knight, formerly esquire 1
5002540 2357655 2357655 defendant Halley Hugh yeoman 623735 623735 Halley, Hugh, of Longford, Derbs, yeoman 2
5003651 2357959 2357959 defendant Mable Edmund yeoman 623735 623735 Mable, Edmund, of Longford, Derbs, yeoman 1
5057232 2373735 2373735 defendant Longford John esq 623735 623735 Longford, John, of Longford, Derbs, esq 1
5074932 2379009 2379009 defendant Aungers John yeoman 623735 623735 Aungers, John, of Longford, Derbs, yeoman 0
5074970 2379022 2379022 defendant Aungeres John yeoman 623735 623735 Aungeres, John, of Longford, Derbs, yeoman 0
5081545 2380982 2380982 defendant Halley Hugh yeoman 623735 623735 Halley, Hugh, of Longford, Derbs, yeoman 2
5142412 2398905 2398905 defendant Hall Hugh yeoman 623735 623735 Hall, Hugh, of Longford, Derbs, yeoman 0
5163706 2405121 2405121 defendant Halley Hugh yeoman 623735 623735 Halley, Hugh, of Longford, Derbs, yeoman 0
5177229 2409035 2409035 defendant Halley Hugh yeoman 623735 623735 Halley, Hugh, of Longford, Derbs, yeoman 0
5183267 2410849 2410849 defendant Halle Hugh yeoman 623735 623735 Halle, Hugh, of Longford, Derbs, yeoman 1
5183272 2410850 2410850 defendant Halle Hugh yeoman 623735 623735 Halle, Hugh, of Longford, Derbs, yeoman 1
5183277 2410851 2410851 defendant Halle Hugh yeoman 623735 623735 Halle, Hugh, of Longford, Derbs, yeoman 1
5183282 2410852 2410852 defendant Halle Hugh yeoman 623735 623735 Halle, Hugh, of Longford, Derbs, yeoman 1
5200138 2415796 2415796 defendant Halley Hugh yeoman 623735 623735 Halley, Hugh, of Longford, Derbs, yeoman 0
5203804 2416864 2416864 defendant Halle Hugh yeoman 623735 623735 Halle, Hugh, of Longford, Derbs, yeoman 1
5203805 2416864 2416864 defendant Robynson Nicholas yeoman 623735 623735 Robynson, Nicholas, of Longford, Derbs, yeoman 2
5203809 2416865 2416865 defendant Halle Hugh yeoman 623735 623735 Halle, Hugh, of Longford, Derbs, yeoman 1
5203810 2416865 2416865 defendant Robynson Nicholas yeoman 623735 623735 Robynson, Nicholas, of Longford, Derbs, yeoman 2
5228875 2424052 2424052 defendant Halley Hugh yeoman 623735 623735 Halley, Hugh, of Longford, Derbs, yeoman 1
5296736 2444034 2444034 defendant Longford Nicholas esq 623735 623735 Longford, Nicholas, of Longford, Derbs, esq 0
5301618 2445439 2445439 defendant Longford Nicholas   623735 623735 Longford, Nicholas, of Longford, Derbs, knight 0
5301627 2445440 2445440 defendant Longford Nicholas   623735 623735 Longford, Nicholas, of Longford, Derbs, knight 0
5301629 2445440 2445440 defendant Tatton Oliver yeoman 623735 623735 Tatton, Oliver, of Longford, Derbs, yeoman 2
5316395 2449984 2449984 defendant Longford Nicholas   623735 623735 Longford, Nicholas, of Longford, Derbs, knight 0
5368751 2465818 2465818 defendant Robynson Nicholas yeoman 623735 623735 Robynson, Nicholas, of Longford, Derbs,yeoman 0
5393896 2473315 2473315 defendant Knyveton Mathew   623735 623735 Knyveton, Mathew, of Longford, Derbs, parson, in the Coventry & Lichfield dioceses 0
5407076 2477085 2477085 defendant Knyveton Mathew   623735 623735 Knyveton, Mathew, of Longford, Derbs, parson 0
5420271 2480987 2480987 defendant Knyneston Mathew   623735 623735 Knyneston, Mathew, of Longford, Derbs, parson 0
5528176 2513376 2513376 defendant Milner John yeoman 623735 623735 Milner, John, of Longford, Derbs, yeoman 2
5556091 2521776 2521776 defendant Longford Ralph   623735 623735 Longford, Ralph, of Longford, Derbs, knight 1

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