names

33 rows where place_id = 603962

✎ 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
3621030 1874135 1874135 defendant Kene William yeoman 603962 603962 Kene, William, of Horsmonden, Kent, or of London, yeoman 1
3656399 1912247 1912247 defendant Sampson Henry gent 603962 603962 Sampson, Henry, of Horsmonden, Kent, gent 0
3659136 1913115 1913115 defendant Haynes Ralph mercer 603962 603962 Haynes, Ralph, of Horsmonden, Kent, mercer 0
3665069 1915023 1915023 defendant Pave William   603962 603962 Pave, William, of Horsmonden, Kent, cloth maker 0
3668507 1916106 1916106 defendant Payntour Alexander yeoman 603962 603962 Payntour, Alexander, of Horsmonden, Kent, yeoman 0
3680034 1919819 1919819 defendant Patte William clothmaker 603962 603962 Patte, William, of Horsmonden, Kent, clothmaker 2
3697394 1925403 1925403 defendant Akok John laborer 603962 603962 Akok, John, of Horsmonden, Kent, laborer 0
3781088 1951822 1951822 defendant Grygby William clothman 603962 603962 Grygby, William, of Horsmonden, Kent, clothman 0
3837810 1969737 1969737 defendant Ledde John shoemaker 603962 603962 Ledde, John, of Horsmonden, Kent, shoemaker 4
3910821 1993942 1993942 defendant Weyllard Richard husbandman 603962 603962 Weyllard, Richard, of Horsmonden, Kent, husbandman 0
3910865 1993957 1993957 defendant Wyllard Richard husbandman 603962 603962 Wyllard, Richard, of Horsmonden, Kent, husbandman 0
4029142 2035065 2035065 defendant Sudar Stephen clothier 603962 603962 Sudar, Stephen, of Horsmonden, Kent, clothier 0
4106334 2062555 2062555 defendant Reader John clothier 603962 603962 Reader, John, of Horsmonden, Kent, clothier 0
4129335 2070795 2070795 defendant Bathurst Edward clothier 603962 603962 Bathurst, Edward, of Horsmonden, Kent, clothier 1
4160821 2081859 2081859 defendant Cradocke Richard clothier 603962 603962 Cradocke, Richard, of Horsmonden, Kent, clothier 4
4160826 2081860 2081860 defendant Fyshenden John clothier 603962 603962 Fyshenden, John, of Horsmonden, Kent, clothier 3
4304130 2131577 2131577 defendant Graye John mercer 603962 603962 Graye, John, of Horsmonden, Kent, mercer 1
4603398 2232253 2232253 defendant Greneherst Richard   603962 603962 Greneherst, Richard, of Horsmonden, Kent 2
4603405 2232254 2232254 defendant Greneherst Richard   603962 603962 Greneherst, Richard, of Horsmonden, Kent 2
4603406 2232254 2232254 defendant atte Wode Robert   603962 603962 atte Wode, Robert, of Horsmonden, Kent 3
4793638 2294123 2294123 defendant Tilere Richard laborer 603962 603962 Tilere, Richard, of Horsmonden, Kent, laborer 0
4877832 2320029 2320029 defendant Hogson Stephen chapman 603962 603962 Hogson, Stephen, of Horsmonden, Kent, chapman 2
4877839 2320030 2320030 defendant Hogson Stephen chapman 603962 603962 Hogson, Stephen, of Horsmonden, Kent, chapman 2
4991258 2354268 2354268 defendant Potter William chaplain 603962 603962 Potter, William, of Horsmonden, Kent, chaplain 2
5083140 2381462 2381462 defendant Brechelond Richard husbandman 603962 603962 Brechelond, Richard, of Horsmonden, Kent, husbandman 15
5273760 2437406 2437406 defendant Sampson John gent 603962 603962 Sampson, John, of Horsmonden, Kent, gent 1
5273763 2437407 2437407 defendant Samson John gent 603962 603962 Samson, John, of Horsmonden, Kent, gent 1
5290261 2442155 2442155 defendant Samson John gent 603962 603962 Samson, John, of Horsmonden, Kent, gent 0
5302581 2445747 2445747 defendant atte Hope Henry yeoman 603962 603962 atte Hope, Henry, of Horsmonden, Kent, yeoman 0
5370708 2466429 2466429 defendant Mynge Henry skinner 603962 603962 Mynge, Henry, of Horsmonden, Kent, skinner 1
5375907 2468055 2468055 defendant Sampson John gent 603962 603962 Sampson, John, of Horsmonden, Kent, gent 3
5583590 2529943 2529943 defendant Haymys Ralph chapman 603962 603962 Haymys, Ralph, of Horsmonden, Kent, chapman 0
5609386 2537837 2537837 defendant Sampson John gent 603962 603962 Sampson, John, of Horsmonden, Kent, gent 2

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