names

29 rows where place_id = 589937

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599312 1867429 1867429 defendant Hoigge William clothmaker 589937 589937 Hoigge, William, of Benenden, Kent, clothmaker 0
3730572 1935798 1935798 defendant Hobard John clothier 589937 589937 Hobard, John, of Benenden, Kent, clothier 0
3812369 1961760 1961760 defendant Guldeford George esq 589937 589937 Guldeford, George, of Benenden, Kent, esq 2
3821463 1964606 1964606 defendant Guldeford George esq 589937 589937 Guldeford, George, of Benenden, Kent, esq 0
3829117 1966988 1966988 defendant Alford William clothmaker 589937 589937 Alford, William, of Benenden, Kent, clothmaker 1
3841901 1971038 1971038 defendant Guldeford John esq 589937 589937 Guldeford, John, of Benenden, Kent, esq 1
3871245 1980635 1980635 defendant Guldeford John esq 589937 589937 Guldeford, John, of Benenden, Kent, esq 3
3877635 1982760 1982760 defendant More William clothier 589937 589937 More, William, of Benenden, Kent, clothier 0
3900345 1990350 1990350 defendant Ramysden John clothman 589937 589937 Ramysden, John, of Benenden, Kent, clothman 0
4024212 2033363 2033363 defendant Fowle James yeoman 589937 589937 Fowle, James, of Benenden, Kent, yeoman 0
4329100 2140043 2140043 defendant Tomlyn Robert clothier 589937 589937 Tomlyn, Robert, of Benenden, Kent, clothier 0
4332314 2141100 2141100 defendant Ramesden William tailor 589937 589937 Ramesden, William, of Benenden, Kent, tailor 0
4680729 2259589 2259589 defendant Brynchesle John dyer 589937 589937 Brynchesle, John, of Benenden, Kent, dyer 0
4680733 2259591 2259591 defendant Brynchesle John husbandman 589937 589937 Brynchesle, John, of Benenden, Kent, husbandman 0
4703640 2266517 2266517 defendant Crotehole Simon   589937 589937 Crotehole, Simon, of Benenden, Kent, plough maker 0
4934394 2337149 2337149 defendant Lede John wooder 589937 589937 Lede, John, of Benenden, Kent, wooder 2
4996555 2355824 2355824 defendant Brenchesle Margery widow 589937 589937 (Brenchesle, Margery, of Benenden, Kent, widow 1
5019938 2362712 2362712 defendant Bygge Roger husbandman 589937 589937 Bygge, Roger, of Benenden, Kent, husbandman 1
5049054 2371352 2371352 defendant Baret William butcher 589937 589937 Baret, William, of Benenden, Kent, butcher 1
5279823 2439180 2439180 defendant Morley John clothman 589937 589937 Morley, John, of Benenden, Kent, clothman 2
5279882 2439194 2439194 defendant Morley John clothman 589937 589937 Morley, John, of Benenden, Kent, clothman 0
5308798 2447670 2447670 defendant Morle John dyer 589937 589937 Morle, John, of Benenden, Kent, dyer 0
5448949 2489580 2489580 defendant Godyng Edward chapman 589937 589937 Godyng, Edward, of Benenden, Kent, chapman 0
5449455 2489726 2489726 defendant Golyng Edward mercer 589937 589937 Golyng, Edward, of Benenden, Kent, mercer 1
5449460 2489727 2489727 defendant Goldyng Edward mercer 589937 589937 Goldyng, Edward, of Benenden, Kent, mercer 1
5449849 2489845 2489845 defendant Lede William husbandman 589937 589937 Lede, William, of Benenden, Kent, husbandman 1
5482234 2499628 2499628 defendant Hogge William draper 589937 589937 Hogge, William, of Benenden, Kent, draper 0
5529543 2513738 2513738 defendant Broun James clothmaker 589937 589937 Broun, James, of Benenden, Kent, clothmaker 2
5625177 2551814 2551814 defendant Brynchesle John dyer 589937 589937 Brynchesle, John, of Benenden, Kent, dyer 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);