names

22 rows where place_id = 588005

✎ 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
3593077 1865463 1865463 defendant Roberdys Robert butcher 588005 588005 Roberdys, Robert, of St John Strete, Middx, butcher 0
3609069 1870493 1870493 defendant Pasmere Thomas, junior gent 588005 588005 Pasmere, Thomas, junior, of St John Strete, Middx, gent 3
3638159 1906752 1906752 defendant Darsett Elizabeth widow 588005 588005 Darsett, Elizabeth, of St John Strete, Middx, widow 0
3706408 1928292 1928292 defendant Molson Richard baker 588005 588005 Molson, Richard, of St John Strete, Middx, baker 0
3730827 1935868 1935868 defendant Tong Thomas   588005 588005 Tong, Thomas, of St John Strete, Middx, gent, Norrey Herald 3
3758178 1944546 1944546 defendant Orpit Walter butcher 588005 588005 Orpit, Walter, of St John Strete, Middx, butcher 0
3798111 1957306 1957306 defendant Tayllour John grocer 588005 588005 Tayllour, John, of St John Strete, Middx, grocer 4
3843974 1971657 1971657 plaintiff Cordall William gent 588005 588005 Cordall, William, of St John Strete, Middx, gent 0
3846069 1972329 1972329 defendant grey Elizabeth widow 588005 588005 grey, Elizabeth, of St John Strete, Middx, widow 2
3912859 1994632 1994632 plaintiff Awdeley Henry (legal representative) 588005 588005 Awdeley, Henry, of St John Strete, Middx, gent, executors of 0
3965719 2012626 2012626 plaintiff Bennet Constance merchant 588005 588005 Bennet, Constance, of St John Strete, Middx, merchant 0
3982150 2018377 2018377 plaintiff Russell Henry gent 588005 588005 Russell, Henry, of St John Strete, Middx, gent 0
3991663 2021775 2021775 defendant Payton Christopher gent 588005 588005 Payton, Christopher, of St John Strete, Middx, gent 0
4023044 2032961 2032961 defendant Sparkehouse William tailor 588005 588005 Sparkehouse, William, of St John Strete, Middx, tailor 2
4023049 2032962 2032962 defendant Sparkehouse William tailor 588005 588005 Sparkehouse, William, of St John Strete, Middx, tailor 2
4060756 2046253 2046253 plaintiff Denney Robert tailor 588005 588005 Denney, Robert, of St John Strete, Middx, tailor 0
4155379 2079975 2079975 defendant Cuttes Edward butcher 588005 588005 Cuttes, Edward, of St John Strete, Middx, butcher 0
4155390 2079977 2079977 defendant Walton James butcher 588005 588005 Walton, James, of St John Strete, Middx, butcher 1
5058665 2374153 2374153 defendant Forster Robert gent 588005 588005 Forster, Robert, of St John Strete, Middx, gent 2
5058669 2374154 2374154 defendant Forster Robert gent 588005 588005 Forster, Robert, of St John Strete, Middx, gent 2
5517141 2510197 2510197 defendant Bulbek William baker 588005 588005 Bulbek, William, of St John Strete, Middx, baker 0
5574658 2527148 2527148 defendant Bayly Richard yeoman 588005 588005 Bayly, Richard, of St John Strete, Middx, yeoman 2

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