names

24 rows where place_id = 637216

✎ 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
3835147 1968933 1968933 defendant Pryst Hugh yeoman 637216 637216 Pryst, Hugh, of Hartlond, yeoman 0
3842246 1971119 1971119 defendant Prust Hugh merchant 637216 637216 Prust, Hugh, of Hartlond, merchant 3
3846826 1972559 1972559 defendant Thorne alias Duke John husbandman 637216 637216 Thorne alias Duke, John, of Hartlond, husbandman 0
3851567 1974078 1974078 defendant Prust Hugh yeoman 637216 637216 Prust, Hugh, of Hartlond, yeoman 0
3874940 1981841 1981841 defendant Cupper Gregory husbandman 637216 637216 Cupper, Gregory, of Hartlond, husbandman 1
3889313 1986662 1986662 defendant Pruste Hugh merchant 637216 637216 Pruste, Hugh, of Hartlond, merchant 0
3890190 1986959 1986959 defendant Pruste Hugh merchant 637216 637216 Pruste, Hugh, of Hartlond, merchant 0
3893855 1988167 1988167 plaintiff Prust Hugh merchant 637216 637216 Prust, Hugh, of Hartlond, merchant 0
3893863 1988170 1988170 plaintiff Pryst Hugh owner of ship Mary Bolen of barstable 637216 637216 Pryst, Hugh, of Hartlond, merchant, owner of ship Mary Bolen of barstable 0
3903445 1991378 1991378 defendant Prust Hugh merchant 637216 637216 Prust, Hugh, of Hartlond, merchant 0
3908059 1992991 1992991 plaintiff Prist Hugh merchant 637216 637216 Prist, Hugh, of Hartlond, merchant 0
3908084 1993001 1993001 defendant Cupper Gregory husbandman 637216 637216 Cupper, Gregory, of Hartlond, husbandman 0
3908100 1993008 1993008 defendant Tryke David husbandman 637216 637216 Tryke, David, of Hartlond, husbandman 0
3908101 1993008 1993008 defendant Roundell John, senior husbandman 637216 637216 Roundell, John, senior, of Hartlond, husbandman 1
3908102 1993008 1993008 defendant Roundell John, junior husbandman 637216 637216 Roundell, John, junior, of Hartlond, husbandman 2
3908103 1993008 1993008 defendant Pryst Hugh husbandman 637216 637216 Pryst, Hugh, of Hartlond, husbandman 3
3917857 1996332 1996332 defendant Nycoll Thomas laborer 637216 637216 Nycoll, Thomas, of Hartlond, laborer 0
3920567 1997227 1997227 defendant Blakdon Thomas yeoman 637216 637216 Blakdon, Thomas, of Hartlond, yeoman 0
3964906 2012331 2012331 plaintiff Bagyshele Isabel widow 637216 637216 Bagyshele, Isabel, of Hartlond, widow 0
4116619 2066236 2066236 defendant Couke or Conke Nettanus draper 637216 637216 Couke or Conke, Nettanus, of Hartlond, draper 0
4204409 2097089 2097089 defendant Buse Richard husbandman 637216 637216 Buse, Richard, of Hartlond, husbandman 1
4206992 2097990 2097990 defendant Metherell alias Combe John husbandman 637216 637216 Metherell alias Combe, John, of Hartlond, husbandman 0
4225485 2104381 2104381 defendant Packarde John husbandman 637216 637216 Packarde, John, of Hartlond, husbandman 0
5571581 2526244 2526244 defendant Prust Hugh yeoman 637216 637216 Prust, Hugh, of Hartlond, yeoman 1

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