names

53 rows where place_id = 753645

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4414892 2169556 2169556 defendant atte Putte William   753645 753645 atte Putte, William, of Berkhamstede 0
4415928 2169866 2169866 plaintiff Kynebelle Robert de   753645 753645 Kynebelle, Robert de, of Berkhamstede 0
4422998 2172050 2172050 defendant atte Putte William   753645 753645 atte Putte, William, of Berkhamstede 0
4435863 2175965 2175965 defendant Shephirde Roger   753645 753645 Shephirde, Roger, of Berkhamstede 0
4444809 2183349 2183349 plaintiff Cook Henry   753645 753645 Cook, Henry, of Berkhamstede, on his own account 0
4468854 2190934 2190934 plaintiff Berkhamstede Henry Master 753645 753645 Berkhamstede, Henry, of Berkhamstede, Master 0
4471558 2191766 2191766 plaintiff Chalfounte John   753645 753645 Chalfounte, John, of Berkhamstede 0
4478027 2193797 2193797 defendant Chaumbre Nicholas de   753645 753645 Chaumbre, Nicholas de, of Berkhamstede 0
4492128 2198225 2198225 defendant Barbour Thomas   753645 753645 Barbour, Thomas, of Berkhamstede 0
4500611 2200813 2200813 defendant Clerk Henry smith 753645 753645 Clerk, Henry, of Berkhamstede, smith 5
4504624 2201993 2201993 defendant Cook Edmund   753645 753645 Cook, Edmund, of Berkhamstede 5
4514131 2204839 2204839 defendant Cok William   753645 753645 Cok, William, of Berkhamstede 0
4514133 2204839 2204839 defendant Croke John   753645 753645 Croke, John, of Berkhamstede 2
4514136 2204840 2204840 defendant Cook William   753645 753645 Cook, William, of Berkhamstede 0
4514138 2204840 2204840 defendant Croke John   753645 753645 Croke, John, of Berkhamstede 2
4522024 2207228 2207228 defendant Cook William   753645 753645 Cook, William, of Berkhamstede 0
4522026 2207229 2207229 defendant Cookes William   753645 753645 Cookes, William, of Berkhamstede 0
4522028 2207230 2207230 defendant Cookes William   753645 753645 Cookes, William, of Berkhamstede 0
4523289 2207608 2207608 defendant atte Chamber Nicholas   753645 753645 atte Chamber, Nicholas, of Berkhamstede 0
4523295 2207609 2207609 defendant atte Chambre Nicholas   753645 753645 atte Chambre, Nicholas, of Berkhamstede 0
4577984 2224621 2224621 defendant Heymond John skinner 753645 753645 Heymond, John, of Berkhamstede, skinner 0
4610360 2234322 2234322 defendant Sewale Richard   753645 753645 Sewale, Richard, of Berkhamstede 4
4653050 2246886 2246886 defendant Swanley Hugh yeoman 753645 753645 Swanley, Hugh, of Berkhamstede, yeoman 0
4701984 2266029 2266029 defendant Bette William laboroer 753645 753645 Bette, William, of Berkhamstede, laboroer 0
4702034 2266047 2266047 defendant Herthonge Thomas husbandman 753645 753645 Herthonge, Thomas, of Berkhamstede, husbandman 3
4710300 2268576 2268576 defendant Coke William woolman 753645 753645 Coke, William, of Berkhamstede, woolman 0
4710301 2268576 2268576 defendant Lord William butcher 753645 753645 Lord, William, of Berkhamstede, butcher 1
4710302 2268576 2268576 defendant Haymond John skinner 753645 753645 Haymond, John, of Berkhamstede, skinner 2
4805526 2297941 2297941 defendant Skalle Richard (legal representative) 753645 753645 Skalle, Richard, of Berkhamstede, yeoman, executrix of 0
4805527 2297941 2297941 defendant Skalle Alice widow 753645 753645 Skalle, Alice, of Berkhamstede, widow 1
4854837 2312863 2312863 defendant Hudnale John smith 753645 753645 Hudnale, John, of Berkhamstede, smith 2
4859995 2314496 2314496 defendant Mylward William tanner 753645 753645 Mylward, William, of Berkhamstede, tanner 0
4898407 2326157 2326157 defendant Hodenhale John husbandman 753645 753645 Hodenhale, John, of Berkhamstede, husbandman 0
4898408 2326157 2326157 defendant Stratton William   753645 753645 Stratton, William, of Berkhamstede, bailiff 1
4899044 2326343 2326343 defendant Vyall William hosteler 753645 753645 Vyall, William, of Berkhamstede, hosteler 0
4899045 2326343 2326343 defendant Taillour Henry tailor 753645 753645 Taillour, Henry, of Berkhamstede, tailor 1
4904153 2327911 2327911 defendant Hodenhale John husbandman 753645 753645 Hodenhale, John, of Berkhamstede, husbandman 0
4904154 2327911 2327911 defendant Stratton William   753645 753645 Stratton, William, of Berkhamstede, bailiff 1
4949305 2341769 2341769 defendant Hore John collier 753645 753645 Hore, John, of Berkhamstede, collier 0
4969660 2347871 2347871 defendant Huddenhale John smith 753645 753645 Huddenhale, John, of Berkhamstede, smith 3
5095429 2385084 2385084 defendant of Fentham Denise widow 753645 753645 of Fentham, Denise, of Berkhamstede, widow 0
5095430 2385084 2385084 defendant Partrych John, junior husbandman 753645 753645 Partrych, John, junior, of Berkhamstede, husbandman 1
5095431 2385084 2385084 defendant Cok William husbandman 753645 753645 Cok, William, of Berkhamstede, husbandman 2
5095432 2385084 2385084 defendant Lok Richard husbandman 753645 753645 Lok, Richard, of Berkhamstede, husbandman 3
5095433 2385084 2385084 defendant Fentham Thomas laborer 753645 753645 Fentham, Thomas, of Berkhamstede, laborer 4
5128489 2394804 2394804 defendant Boteler Thomas butcher 753645 753645 Boteler, Thomas, of Berkhamstede, butcher 0
5166556 2405937 2405937 defendant Tyler John yeoman 753645 753645 Tyler, John, of Berkhamstede, yeoman 2
5187976 2412191 2412191 defendant Man Thomas yeoman 753645 753645 Man, Thomas, of Berkhamstede, yeoman 0
5251519 2430580 2430580 defendant Louther Hugh, junior gent 753645 753645 Louther, Hugh, junior, of Berkhamstede, gent 7
5265433 2434947 2434947 defendant Pycot Robert husbandman 753645 753645 Pycot, Robert, of Berkhamstede, husbandman 0
5401035 2475359 2475359 plaintiff Gunne William (legal representative) 753645 753645 Gunne, William, of Berkhamstede, inn holder, executor of 0
5433443 2484961 2484961 plaintiff Molder John yeoman 753645 753645 Molder, John, of Berkhamstede, yeoman 0
5433445 2484962 2484962 plaintiff Molder John yeoman 753645 753645 Molder, John, of Berkhamstede, yeoman 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);