names

16 rows where place_id = 603806

✎ 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
3655837 1912081 1912081 defendant Johnson Henry husbandman 603806 603806 Johnson, Henry, of Padyngton, Middx, husbandman 0
3704001 1927536 1927536 defendant Kempe Thomas gent 603806 603806 Kempe, Thomas, of Padyngton, Middx, gent 0
3704003 1927537 1927537 defendant Kempe Thomas gent 603806 603806 Kempe, Thomas, of Padyngton, Middx, gent 0
3727665 1934925 1934925 defendant Cowper William gent 603806 603806 Cowper, William, of Padyngton, Middx, gent 5
3743275 1939764 1939764 defendant Cowper William gent 603806 603806 Cowper, William, of Padyngton, Middx, gent 0
3851327 1974013 1974013 defendant Hulle William smith 603806 603806 Hulle, William, of Padyngton, Middx, smith 2
3854616 1975088 1975088 defendant Goodyere Nicholas gent 603806 603806 Goodyere, Nicholas, of Padyngton, Middx, gent 0
3994545 2022796 2022796 defendant Waters John gent 603806 603806 Waters, John, of Padyngton, Middx, gent 0
4948084 2341375 2341375 defendant Gylle Margaret widow 603806 603806 Gylle, Margaret, of Padyngton, Middx, widow 0
4948089 2341376 2341376 defendant Hille Margaret widow 603806 603806 Hille, Margaret, of Padyngton, Middx, widow 0
4948094 2341377 2341377 defendant Hylle Margaret widow 603806 603806 Hylle, Margaret, of Padyngton, Middx, widow 0
5046157 2370478 2370478 defendant Gerveys John   603806 603806 Gerveys, John, of Padyngton, Middx, vicar 4
5273080 2437200 2437200 defendant Baker John yeoman 603806 603806 Baker, John, of Padyngton, Middx, yeoman 4
5304324 2446296 2446296 defendant Andreweson John gent 603806 603806 Andreweson, John, of Padyngton, Middx, gent 0
5468615 2495553 2495553 defendant Conton John gent 603806 603806 (Conton, John, of Padyngton, Middx, gent 1
5602001 2535522 2535522 defendant Cowper John brewer 603806 603806 Cowper, John, of Padyngton, Middx, brewer 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);