names

19 rows where place_id = 645897

✎ 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
3888000 1986236 1986236 defendant Hamond Stephen gent 645897 645897 Hamond, Stephen, of Romesey, Hants, gent 2
3978253 2016977 2016977 defendant Colle Richard mercer 645897 645897 Colle, Richard, of Romesey, Hants, mercer 1
3978837 2017179 2017179 defendant Raynold William tanner 645897 645897 Raynold, William, of Romesey, Hants, tanner 0
4034598 2037048 2037048 plaintiff Harveye Richard yeoman 645897 645897 Harveye, Richard, of Romesey, Hants, yeoman 0
4034600 2037049 2037049 plaintiff Harveye Richard yeoman 645897 645897 Harveye, Richard, of Romesey, Hants, yeoman 0
4212701 2099982 2099982 defendant Gauntlott John clothier 645897 645897 Gauntlott, John, of Romesey, Hants, clothier 0
4512788 2204434 2204434 defendant Chambirleyn John   645897 645897 Chambirleyn, John, of Romesey, Hants 1
4696631 2264424 2264424 defendant Person John dyer 645897 645897 Person, John, of Romesey, Hants, dyer 1
4784621 2291197 2291197 defendant Kirkeby Alice widow 645897 645897 (Kirkeby, Alice, of Romesey, Hants, widow 1
4790155 2293003 2293003 defendant Fayrle John husbandman 645897 645897 Fayrle, John, of Romesey, Hants, husbandman 0
4849403 2311289 2311289 defendant Beyr John husbandman 645897 645897 Beyr, John, of Romesey, Hants, husbandman 2
4899140 2326373 2326373 defendant Carre John cutler 645897 645897 Carre, John, of Romesey, Hants, cutler 1
4914093 2330918 2330918 defendant Wodeleaf John yeoman 645897 645897 Wodeleaf, John, of Romesey, Hants, yeoman 0
4931091 2336115 2336115 defendant Berewyk Henry carpenter 645897 645897 Berewyk, Henry, of Romesey, Hants, carpenter 0
5269033 2436044 2436044 defendant Gaterygge John husbandman 645897 645897 Gaterygge, John, of Romesey, Hants, husbandman 0
5296539 2443977 2443977 defendant Algare Thomas miller 645897 645897 Algare, Thomas, of Romesey, Hants, miller 0
5347878 2459480 2459480 defendant Browne John   645897 645897 Browne, John, of Romesey, Hants, tallow chandler 2
5573564 2526833 2526833 defendant Kyrkeby John gent 645897 645897 Kyrkeby, John, of Romesey, Hants, gent 0
5588718 2531483 2531483 defendant Kyrkeby John esq 645897 645897 Kyrkeby, John, of Romesey, Hants, esq 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);