names

17 rows where place_id = 617560

✎ 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
3720138 1932575 1932575 defendant Dalaper John   617560 617560 Dalaper, John, of Lenton, Notts 1
3735845 1937449 1937449 defendant Delapere John   617560 617560 Delapere, John, of Lenton, Notts, physician 0
3775457 1950066 1950066 defendant Delapyer alias Drapyer John   617560 617560 Delapyer alias Drapyer, John, of Lenton, Notts, physician 3
3793040 1955682 1955682 defendant Delapier alias Drapier John   617560 617560 Delapier alias Drapier, John, of Lenton, Notts, physician 0
4047456 2041541 2041541 defendant Johnson John yeoman 617560 617560 Johnson, John, of Lenton, Notts, yeoman 1
4047518 2041565 2041565 defendant Johnson John yeoman 617560 617560 Johnson, John, of Lenton, Notts, yeoman 1
4235006 2107794 2107794 defendant Dolphin William yeoman 617560 617560 Dolphin, William, of Lenton, Notts, yeoman 0
4278055 2122258 2122258 defendant Leicester James gent 617560 617560 Leicester, James, of Lenton, Notts, gent 0
4330544 2140513 2140513 defendant Barton William gent 617560 617560 Barton, William, of Lenton, Notts, gent 0
4682393 2260112 2260112 defendant Kynggele alias Palfrayman Robert yeoman 617560 617560 Kynggele alias Palfrayman, Robert, of Lenton, Notts, yeoman 1
4689765 2262360 2262360 defendant Palfreyman Robert husbandman 617560 617560 Palfreyman, Robert, of Lenton, Notts, husbandman 0
5148689 2400741 2400741 defendant Shawe Charles gent 617560 617560 Shawe, Charles, of Lenton, Notts, gent 0
5167897 2406323 2406323 defendant Shewe Charles gent 617560 617560 Shewe, Charles, of Lenton, Notts, gent 0
5183597 2410938 2410938 defendant Shawe Charles gent 617560 617560 Shawe, Charles, of Lenton, Notts, gent 0
5372324 2466935 2466935 defendant Rysle Henry husbandman 617560 617560 Rysle, Henry, of Lenton, Notts, husbandman 3
5596257 2533743 2533743 defendant Wodcoke William yeoman 617560 617560 Wodcoke, William, of Lenton, Notts, yeoman 3
5596262 2533744 2533744 defendant Wodcok William yeoman 617560 617560 Wodcok, William, of Lenton, Notts, yeoman 3

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