names

27 rows where place_id = 601552

✎ 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
3645812 1909093 1909093 defendant Warcop Leonard gent 601552 601552 (Warcop, Leonard, of Richemond, Yorks, gent 1
3730594 1935804 1935804 defendant Thristram John merchant 601552 601552 Thristram, John, of Richemond, Yorks, merchant 0
3746234 1940731 1940731 defendant Warcop George gent 601552 601552 Warcop, George, of Richemond, Yorks, gent 0
3769563 1948141 1948141 defendant Sawer Richard (legal representative) 601552 601552 Sawer, Richard, of Richemond, Yorks, mercer, administrator of 0
3859979 1976839 1976839 defendant Johnson Charles merchant 601552 601552 Johnson, Charles, of Richemond, Yorks, merchant 0
3932852 2001278 2001278 defendant Wharton William gent 601552 601552 Wharton, William, of Richemond, Yorks, gent 0
3961601 2011157 2011157 defendant Wharton William gent 601552 601552 Wharton, William, of Richemond, Yorks, gent 0
3975100 2015853 2015853 defendant Burres William yeoman 601552 601552 Burres, William, of Richemond, Yorks, yeoman 0
3977502 2016702 2016702 plaintiff Lightfote Francis yeoman 601552 601552 Lightfote, Francis, of Richemond, Yorks, yeoman 0
3996281 2023419 2023419 defendant Metcalfe Oswald gent 601552 601552 Metcalfe, Oswald, of Richemond, Yorks, gent 0
4041000 2039271 2039271 defendant Mylner Richard chapman 601552 601552 Mylner, Richard, of Richemond, Yorks, chapman 0
4163377 2082717 2082717 defendant Burrowes William yeoman 601552 601552 Burrowes, William, of Richemond, Yorks, yeoman 0
4207067 2098017 2098017 defendant Wallesse Adam   601552 601552 Wallesse, Adam, of Richemond, Yorks, yeoman, his son 1
4269701 2119456 2119456 defendant Williams Richard draper 601552 601552 Williams, Richard, of Richemond, Yorks, draper 0
4269711 2119459 2119459 defendant Williams Richard draper 601552 601552 Williams, Richard, of Richemond, Yorks, draper 0
4669297 2256106 2256106 defendant Pennye Robert yeoman 601552 601552 Pennye, Robert, of Richemond, Yorks, yeoman 0
4809312 2299086 2299086 defendant Bowet Henry   601552 601552 Bowet, Henry, of Richemond, Yorks, archdeacon 0
4841594 2308905 2308905 defendant Bowet Henry   601552 601552 Bowet, Henry, of Richemond, Yorks, archdeacon 0
4926040 2334572 2334572 defendant Kirkeby Robert chapman 601552 601552 Kirkeby, Robert, of Richemond, Yorks, chapman 3
4958209 2344423 2344423 defendant Penny William mercer 601552 601552 Penny, William, of Richemond, Yorks, mercer 2
5112204 2389951 2389951 defendant Asby Thomas chapman 601552 601552 Asby, Thomas, of Richemond, Yorks, chapman 1
5136089 2397065 2397065 defendant Bellerby Thomas smith 601552 601552 Bellerby, Thomas, of Richemond, Yorks, smith 0
5155385 2402725 2402725 defendant Gaynesford John chapman 601552 601552 Gaynesford, John, of Richemond, Yorks, chapman 3
5165938 2405783 2405783 defendant Gaynesford John   601552 601552 Gaynesford, John, of Richemond, Yorks, card maker 1
5225628 2423167 2423167 defendant Goodjohn William chapman 601552 601552 Goodjohn, William, of Richemond, Yorks, chapman 3
5556559 2521873 2521873 defendant Lee William gent 601552 601552 Lee, William, of Richemond, Yorks, gent 4
5567045 2524949 2524949 defendant Lee William gent 601552 601552 Lee, William, of Richemond, Yorks, gent 12

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