names

19 rows where place_id = 622988

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3750107 1941947 1941947 defendant Fleccher William gent 622988 622988 Fleccher, William, of Merton, Surrey, gent 2
3775573 1950105 1950105 plaintiff Bollys George clerk 622988 622988 Bollys, George, of Merton, Surrey, clerk 0
3793158 1955719 1955719 plaintiff Bollys George clerk 622988 622988 Bollys, George, of Merton, Surrey, clerk 0
4692365 2263130 2263130 defendant Bull Roger husbandman 622988 622988 Bull, Roger, of Merton, Surrey, husbandman atte Hacche, Thomas, of Willesdon, Middx, husbandman 0
4692371 2263131 2263131 defendant Bull Roger husbandman 622988 622988 Bull, Roger, of Merton, Surrey, husbandman 0
4894139 2324863 2324863 plaintiff Hayton Beatrice (legal representative) 622988 622988 Hayton, Beatrice, of Merton, Surrey, widow, executors of 0
4901733 2327147 2327147 defendant Cornarde George gent 622988 622988 Cornarde, George, of Merton, Surrey, gent 3
4903694 2327773 2327773 plaintiff Hayton Beatrice (legal representative) 622988 622988 Hayton, Beatrice, of Merton, Surrey, widow, executors of 0
5006828 2358897 2358897 defendant Overton Thomas (legal representative) 622988 622988 Overton, Thomas, of Merton, Surrey, gent, executors of 2
5013039 2360642 2360642 defendant Lovelace William gent 622988 622988 Lovelace, William, of Merton, Surrey, gent 4
5013045 2360643 2360643 defendant Lovelace William gent 622988 622988 Lovelace, William, of Merton, Surrey, gent 4
5102290 2387087 2387087 defendant Salynge John, junior husbandman 622988 622988 Salynge, John, junior, of Merton, Surrey, husbandman 2
5119177 2392038 2392038 defendant Salyng Roger husbandman 622988 622988 Salyng, Roger, of Merton, Surrey, husbandman 0
5119182 2392039 2392039 defendant Salyng Roger husbandman 622988 622988 Salyng, Roger, of Merton, Surrey, husbandman 0
5304327 2446296 2446296 defendant Shirley William gent 622988 622988 Shirley, William, of Merton, Surrey, gent 3
5342266 2457777 2457777 defendant Luton Thomas husbandman 622988 622988 Luton, Thomas, of Merton, Surrey, husbandman 1
5510952 2508263 2508263 defendant Shepherd John smith 622988 622988 Shepherd, John, of Merton, Surrey, smith 4
5549197 2519812 2519812 defendant Galawey William smith 622988 622988 Galawey, William, of Merton, Surrey, smith 0
5609068 2537741 2537741 plaintiff (not given) John prior of Kingston 622988 622988 Kingston, John, of Merton, Surrey, prior of the priory of the BM 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);