names

62 rows where place_id = 599294

✎ 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
3636143 1906096 1906096 defendant Wyrald William husbandman 599294 599294 Wyrald, William, of Harlyngdon, husbandman 1
3677834 1919120 1919120 defendant Cranwell John yeoman 599294 599294 Cranwell, John, of Harlyngdon, yeoman 0
3679945 1919793 1919793 defendant Fynche John husbandman 599294 599294 Fynche, John, of Harlyngdon, husbandman 1
3681588 1920332 1920332 defendant Fynche John husbandman 599294 599294 Fynche, John, of Harlyngdon, husbandman 0
3682242 1920544 1920544 defendant Belyngham John husbandman 599294 599294 Belyngham, John, of Harlyngdon, husbandman 1
3688612 1922596 1922596 defendant Toky William maltman 599294 599294 Toky, William, of Harlyngdon, maltman 0
3755959 1943817 1943817 defendant Tukke William maltman 599294 599294 Tukke, William, of Harlyngdon, maltman 1
3760630 1945324 1945324 defendant Alynson William laborer 599294 599294 Alynson, William, of Harlyngdon, laborer 0
3761093 1945470 1945470 defendant Helbourne Thomas laborer 599294 599294 Helbourne, Thomas, of Harlyngdon, laborer 1
3766374 1947138 1947138 defendant Cleydon William yeoman 599294 599294 Cleydon, William, of Harlyngdon, yeoman 1
3771726 1948858 1948858 defendant Clayton William laborer 599294 599294 Clayton, William, of Harlyngdon, laborer 0
3774804 1949847 1949847 defendant Dymby Robert husbandman 599294 599294 Dymby, Robert, of Harlyngdon, husbandman 2
3788320 1954145 1954145 defendant Ederiche John husbandman 599294 599294 Ederiche, John, of Harlyngdon, husbandman 3
3792437 1955497 1955497 defendant Whytlok Richard husbandman 599294 599294 Whytlok, Richard, of Harlyngdon, husbandman 1
3796552 1956795 1956795 defendant Jemys Thomas clerk 599294 599294 Jemys, Thomas, of Harlyngdon, clerk 0
3803054 1958857 1958857 defendant Tucke William husbandman 599294 599294 Tucke, William, of Harlyngdon, husbandman 2
3817855 1963499 1963499 defendant Marten John maltman 599294 599294 Marten, John, of Harlyngdon, maltman 0
3817856 1963499 1963499 defendant Ryngsted John tailor 599294 599294 Ryngsted, John, of Harlyngdon, tailor 1
3895266 1988624 1988624 defendant Elborn Richard husbandman 599294 599294 Elborn, Richard, of Harlyngdon, husbandman 0
3898137 1989585 1989585 defendant Tuckey William husbandman 599294 599294 Tuckey, William, of Harlyngdon, husbandman 0
3949237 2006804 2006804 defendant Horner John husbandman 599294 599294 Horner, John, of Harlyngdon, husbandman 0
4691966 2263022 2263022 defendant Nasshe John butcher 599294 599294 Nasshe, John, of Harlyngdon, butcher 0
4808692 2298886 2298886 defendant Mathew John husbandman 599294 599294 Mathew, John, of Harlyngdon, husbandman 0
4816276 2301174 2301174 defendant Blondell John husbandman 599294 599294 Blondell, John, of Harlyngdon, husbandman 0
4835003 2306950 2306950 defendant Matheu John husbandman 599294 599294 Matheu, John, of Harlyngdon, husbandman 0
4870392 2317717 2317717 plaintiff Lyncolle Richard husbandman 599294 599294 Lyncolle, Richard, of Harlyngdon, husbandman 0
4915904 2331468 2331468 defendant Bern Joan widow 599294 599294 Bern, Joan, of Harlyngdon, widow 1
4935968 2337646 2337646 defendant atte Wode John husbandman 599294 599294 atte Wode, John, of Harlyngdon, husbandman 0
4959709 2344864 2344864 defendant Benet John clerk 599294 599294 Benet, John, of Harlyngdon, clerk 0
5014277 2361028 2361028 defendant Blundell John husbandman 599294 599294 Blundell, John, of Harlyngdon, husbandman 0
5014987 2361262 2361262 defendant Lyncoln Richard husbandman 599294 599294 Lyncoln, Richard, of Harlyngdon, husbandman 0
5022539 2363492 2363492 defendant Berne John widow 599294 599294 Berne, John, of Harlyngdon, widow 0
5025928 2364478 2364478 defendant Pepyr Thomas butcher 599294 599294 Pepyr, Thomas, of Harlyngdon, butcher 0
5180044 2409898 2409898 defendant Coste Edmund husbandman 599294 599294 Coste, Edmund, of Harlyngdon, husbandman 1
5202202 2416407 2416407 defendant Coste Edmund husbandman 599294 599294 Coste, Edmund, of Harlyngdon, husbandman 1
5213521 2419687 2419687 defendant Coste Edmund husbandman 599294 599294 Coste, Edmund, of Harlyngdon, husbandman 1
5248127 2429588 2429588 defendant Bugby John husbandman 599294 599294 Bugby, John, of Harlyngdon, husbandman 0
5268698 2435960 2435960 defendant Blundell John husbandman 599294 599294 Blundell, John, of Harlyngdon, husbandman 4
5274834 2437719 2437719 defendant Blondell Edmund husbandman 599294 599294 Blondell, Edmund, of Harlyngdon, husbandman 0
5275291 2437846 2437846 defendant Blundell Edmund husbandman 599294 599294 Blundell, Edmund, of Harlyngdon, husbandman 0
5282737 2440010 2440010 defendant Blundell John, senior husbandman 599294 599294 Blundell, John, senior, of Harlyngdon, husbandman 0
5282738 2440010 2440010 defendant Blundell John, junior husbandman 599294 599294 Blundell, John, junior, of Harlyngdon, husbandman 1
5289867 2442046 2442046 defendant Blundell Edmund husbandman 599294 599294 Blundell, Edmund, of Harlyngdon, husbandman 0
5289871 2442047 2442047 defendant Blundell Edmund husbandman 599294 599294 Blundell, Edmund, of Harlyngdon, husbandman 0
5342510 2457857 2457857 defendant Blyndell John husbandman 599294 599294 Blyndell, John, of Harlyngdon, husbandman 0
5375966 2468075 2468075 defendant Scogyn William laborer 599294 599294 Scogyn, William, of Harlyngdon, laborer 0
5375967 2468075 2468075 defendant Dunne Thomas laborer 599294 599294 Dunne, Thomas, of Harlyngdon, laborer 1
5379628 2469216 2469216 defendant Nasshe Thomas hsubandman 599294 599294 Nasshe, Thomas, of Harlyngdon, hsubandman 0
5453903 2491057 2491057 defendant Nasshe Thomas   599294 599294 Nasshe, Thomas, of Harlyngdon 0
5453904 2491057 2491057 defendant Nasshe Edmund husbandman 599294 599294 Nasshe, Edmund, of Harlyngdon, husbandman 1
5465796 2494685 2494685 defendant Nasshe Thomas husbandman 599294 599294 Nasshe, Thomas, of Harlyngdon, husbandman 0
5465797 2494685 2494685 defendant Nasshe Edmund husbandman 599294 599294 Nasshe, Edmund, of Harlyngdon, husbandman 1
5477268 2498212 2498212 defendant Nasshe Edmund husbandman 599294 599294 Nasshe, Edmund, of Harlyngdon, husbandman 1
5477269 2498212 2498212 defendant Blundell John husbandman 599294 599294 Blundell, John, of Harlyngdon, husbandman 2
5477271 2498213 2498213 defendant Nasshe Thomas husbandman 599294 599294 Nasshe, Thomas, of Harlyngdon, husbandman 0
5477272 2498213 2498213 defendant Nasshe Edmund husbandman 599294 599294 Nasshe, Edmund, of Harlyngdon, husbandman 1
5477273 2498213 2498213 defendant Blundell John husbandman 599294 599294 Blundell, John, of Harlyngdon, husbandman 2
5550211 2520093 2520093 defendant Lyncoln John husbandman 599294 599294 Lyncoln, John, of Harlyngdon, husbandman 0
5551972 2520618 2520618 defendant Daldron John laborer 599294 599294 Daldron, John, of Harlyngdon, laborer 2
5553546 2521068 2521068 defendant Lyncolne John husbandman 599294 599294 Lyncolne, John, of Harlyngdon, husbandman 0
5556190 2521806 2521806 defendant Acle Robert (legal representative) 599294 599294 Acle, Robert, of Harlyngdon, husbandman, executrix of 1
5556191 2521806 2521806 defendant Acle Alice widow 599294 599294 Acle, Alice, of Harlyngdon, widow 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);