names

20 rows where place_id = 607190

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3668068 1915954 1915954 defendant Thompson Nicholas roper 607190 607190 Thompson, Nicholas, of Donnyngton, roper 0
3669764 1916489 1916489 defendant Johnson John husbandman 607190 607190 Johnson, John, of Donnyngton, husbandman 0
3676990 1918840 1918840 defendant Greve Robert tanner 607190 607190 Greve, Robert, of Donnyngton, tanner 0
3676991 1918840 1918840 defendant Storkes John butcher 607190 607190 Storkes, John, of Donnyngton, butcher 1
3680599 1920012 1920012 defendant Hylton Roger gent 607190 607190 Hylton, Roger, of Donnyngton, gent 0
3849710 1973494 1973494 defendant Elyet John yeoman 607190 607190 Elyet, John, of Donnyngton, yeoman 0
3934846 2001956 2001956 defendant Harteley John yeoman 607190 607190 Harteley, John, of Donnyngton, yeoman 0
3982731 2018593 2018593 plaintiff Sewger Thomas butcher 607190 607190 Sewger, Thomas, of Donnyngton, butcher 0
3989347 2020932 2020932 plaintiff Fowler Robert   607190 607190 Fowler, Robert, of Donnyngton 1
4077361 2052187 2052187 defendant Bryce Hugh gent 607190 607190 Bryce, Hugh, of Donnyngton, gent 0
4151150 2078528 2078528 defendant Haywarde Richard husbandman 607190 607190 Haywarde, Richard, of Donnyngton, husbandman 0
4192074 2092789 2092789 defendant Brandon William mercer 607190 607190 Brandon, William, of Donnyngton, mercer 0
4235582 2108013 2108013 defendant Pewtres John yeoman 607190 607190 Pewtres, John, of Donnyngton, yeoman 1
4281066 2123275 2123275 defendant Colly Edward yeoman 607190 607190 Colly, Edward, of Donnyngton, yeoman 2
4750479 2280622 2280622 defendant Langwath rooger yeoman 607190 607190 Langwath, rooger, of Donnyngton, yeoman 4
5040999 2368932 2368932 plaintiff Chapman William   607190 607190 Chapman, William, of Donnyngton 0
5390313 2472295 2472295 defendant Hype William husbandman 607190 607190 Hype, William, of Donnyngton, husbandman 0
5488777 2501518 2501518 defendant Johnson Thurstan husbandman 607190 607190 Johnson, Thurstan, of Donnyngton, husbandman 1
5497266 2504121 2504121 defendant Marshall Thomas yeoman 607190 607190 Marshall, Thomas, of Donnyngton, yeoman 0
5599624 2534774 2534774 defendant Yepe John husbandman 607190 607190 Yepe, John, of Donnyngton, husbandman 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);