names

15 rows where place_id = 595197

✎ 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
3619343 1873643 1873643 defendant Laysell Richard gent 595197 595197 Laysell, Richard, of Sturton, Notts, gent 33
3780323 1951578 1951578 defendant Sturton Thomas yeoman 595197 595197 Sturton, Thomas, of Sturton, Notts, yeoman 0
4006048 2026933 2026933 defendant Thorney John gent 595197 595197 Thorney, John, of Sturton, Notts, gent 0
4052669 2043383 2043383 defendant Shacklocke Anthony husbandman 595197 595197 Shacklocke, Anthony, of Sturton, Notts, husbandman 1
4056222 2044610 2044610 defendant Sturton George gent 595197 595197 (Sturton, George, of Sturton, Notts, gent 1
4078014 2052439 2052439 defendant Wakefeild James sherman 595197 595197 Wakefeild, James, of Sturton, Notts, sherman 2
4101015 2060679 2060679 defendant Sturton George gent 595197 595197 Sturton, George, of Sturton, Notts, gent 0
4233142 2107100 2107100 defendant Fitzwilliams Robert gent 595197 595197 Fitzwilliams, Robert, of Sturton, Notts, gent 1
4276421 2121697 2121697 defendant Sacker Anthony yeoman 595197 595197 Sacker, Anthony, of Sturton, Notts, yeoman 0
4277758 2122145 2122145 defendant Fenton Nicholas gent 595197 595197 Fenton, Nicholas, of Sturton, Notts, gent 0
4361314 2151208 2151208 defendant Sturton Roger gent 595197 595197 Sturton, Roger, of Sturton, Notts, gent 2
4364336 2152306 2152306 defendant Trippet Richard tailor 595197 595197 Trippet, Richard, of Sturton, Notts, tailor 1
4382016 2158671 2158671 defendant Lassells George gent 595197 595197 Lassells, George, of Sturton, Notts, gent 2
4388379 2160746 2160746 defendant Sturton Roger gent 595197 595197 Sturton, Roger, of Sturton, Notts, gent 1
5544065 2518253 2518253 defendant Thornay Alvered gent 595197 595197 Thornay, Alvered, of Sturton, Notts, gent 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);