names

20 rows where place_id = 607924

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3671492 1917066 1917066 defendant Lorkyn Thomas husbandman 607924 607924 Lorkyn, Thomas, of Horsemonden, husbandman 1
3688924 1922696 1922696 defendant Paynter John clothman 607924 607924 Paynter, John, of Horsemonden, clothman 0
3717986 1931922 1931922 defendant Harknappe Thomas clothier 607924 607924 Harknappe, Thomas, of Horsemonden, clothier 0
3719910 1932497 1932497 defendant Menge John butcher 607924 607924 Menge, John, of Horsemonden, butcher 0
3778385 1950954 1950954 defendant Sampson Henry gent 607924 607924 Sampson, Henry, of Horsemonden, gent 0
3887182 1985977 1985977 defendant Sampson Henry gent 607924 607924 Sampson, Henry, of Horsemonden, gent 0
3995340 2023074 2023074 defendant Brattell John yeoman 607924 607924 Brattell, John, of Horsemonden, yeoman 1
4035872 2037501 2037501 defendant Patne Richard esq 607924 607924 Patne, Richard, of Horsemonden, esq 0
4054736 2044082 2044082 defendant Reader John clothmaker 607924 607924 Reader, John, of Horsemonden, clothmaker 0
4062026 2046703 2046703 defendant Besbyche Thomas yeoman 607924 607924 Besbyche, Thomas, of Horsemonden, yeoman 0
4083836 2054492 2054492 defendant Baldock Edward yeoman 607924 607924 Baldock, Edward, of Horsemonden, yeoman 0
4083838 2054492 2054492 defendant Budd John husbandman 607924 607924 Budd, John, of Horsemonden, husbandman 2
4083839 2054492 2054492 defendant Hope John husbandman 607924 607924 Hope, John, of Horsemonden, husbandman 3
4145124 2076455 2076455 defendant Everenden William weaver 607924 607924 Everenden, William, of Horsemonden, weaver 0
4160807 2081856 2081856 defendant Reader John clothier 607924 607924 Reader, John, of Horsemonden, clothier 2
4166725 2083857 2083857 defendant Hylles Thomas yeoman 607924 607924 Hylles, Thomas, of Horsemonden, yeoman 2
4703764 2266557 2266557 defendant Jurdan John laborer 607924 607924 Jurdan, John, of Horsemonden, laborer 4
5241348 2427666 2427666 defendant Sampson John   607924 607924 Sampson, John, of Horsemonden 10
5241364 2427667 2427667 defendant Sampson John gent 607924 607924 Sampson, John, of Horsemonden, gent 10
5558266 2522368 2522368 plaintiff Patenden John   607924 607924 Patenden, John, of Horsemonden, administrators of 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);