names

64 rows where place_id = 586596

✎ 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
3589141 1864247 1864247 defendant Chalfunt Walter husbandman 586596 586596 Chalfunt, Walter, of Flamsted, husbandman 1
3589142 1864247 1864247 defendant Warner John husbandman 586596 586596 Warner, John, of Flamsted, husbandman 2
3589143 1864247 1864247 defendant Chalfunt John husbandman 586596 586596 Chalfunt, John, of Flamsted, husbandman 3
3589144 1864247 1864247 defendant Grygge John, junior husbandman 586596 586596 Grygge, John, junior, of Flamsted, husbandman 4
3589146 1864247 1864247 defendant Grygge Agnes widow 586596 586596 (Grygge, Agnes, of Flamsted,widow 6
3592228 1865185 1865185 defendant Grygge John husbandman 586596 586596 Grygge, John, of Flamsted, husbandman 0
3648367 1909889 1909889 defendant Wotton John laborer 586596 586596 Wotton, John, of Flamsted, laborer 1
3699563 1926095 1926095 defendant Orme Thomas clerk 586596 586596 Orme, Thomas, of Flamsted, clerk 0
3704349 1927663 1927663 defendant Grygge Robert husbandman 586596 586596 Grygge, Robert, of Flamsted, husbandman 0
3749086 1941643 1941643 defendant Chalffhunt Thomas husbandman 586596 586596 Chalffhunt, Thomas, of Flamsted, husbandman 0
3755878 1943791 1943791 defendant Belgrave Ralph husbandman 586596 586596 Belgrave, Ralph, of Flamsted, husbandman 0
3755879 1943791 1943791 defendant Hill Thomas laborer 586596 586596 Hill, Thomas, of Flamsted, laborer 1
3755880 1943791 1943791 defendant Dyer John yeoman 586596 586596 Dyer, John, of Flamsted, yeoman 2
3764471 1946550 1946550 defendant Belgrave Ralph husbandman 586596 586596 Belgrave, Ralph, of Flamsted, husbandman 0
3785886 1953376 1953376 defendant Hunt Richard laborer 586596 586596 Hunt, Richard, of Flamsted, laborer 1
3799921 1957891 1957891 defendant Smyth John husbandman 586596 586596 Smyth, John , of Flamsted, husbandman 0
3888952 1986548 1986548 defendant Coke Thomas husbandman 586596 586596 Coke, Thomas, of Flamsted, husbandman 1
3920678 1997266 1997266 defendant Coke alias Lee Thomas husbandman 586596 586596 Coke alias Lee, Thomas, of Flamsted, husbandman 0
3929756 2000292 2000292 defendant Payne John husbandman 586596 586596 Payne, John, of Flamsted, husbandman 0
3929757 2000292 2000292 defendant Lepar Edward husbandman 586596 586596 Lepar, Edward, of Flamsted, husbandman 1
3950375 2007213 2007213 plaintiff Fynche Walter yeoman 586596 586596 Fynche, Walter, of Flamsted, yeoman 0
3950377 2007214 2007214 plaintiff Fynche Walter yeoman 586596 586596 Fynche, Walter, of Flamsted, yeoman 0
4068521 2049031 2049031 plaintiff Kylbye William   586596 586596 Kylbye, William, of Flamsted 0
4170159 2085058 2085058 defendant Doggatt Robert yeoman 586596 586596 Doggatt, Robert, of Flamsted, yeoman 0
4217961 2101775 2101775 defendant Hog Nicholas gent 586596 586596 Hog, Nicholas, of Flamsted, gent 0
4217963 2101776 2101776 defendant Hoo Nicholas gent 586596 586596 Hoo, Nicholas, of Flamsted, gent 0
4237645 2108759 2108759 defendant Adowne George husbandman 586596 586596 Adowne, George, of Flamsted, husbandman 0
4274147 2120900 2120900 defendant Goodhan Edward yeoman 586596 586596 Goodhan, Edward, of Flamsted, yeoman 0
4324902 2138713 2138713 defendant Hooper Thomas gent 586596 586596 Hooper, Thomas, of Flamsted, or of Wiggington, Herts, gent 2
4365105 2152574 2152574 defendant Hoo Nicholas gent 586596 586596 Hoo, Nicholas, of Flamsted, gent 0
4365452 2152711 2152711 defendant Adowne George laborer 586596 586596 Adowne, George, of Flamsted, laborer 0
4369500 2154152 2154152 defendant Smyth John husbandman 586596 586596 Smyth, John, of Flamsted, husbandman 0
4377751 2157115 2157115 defendant Pays Richard miller 586596 586596 Pays, Richard, of Flamsted, miller 0
4382696 2158919 2158919 defendant Belgrave Richard (legal representative) 586596 586596 Belgrave, Richard, of Flamsted, husbandman, executor of 0
4382697 2158919 2158919 defendant Belgrave Thomas husbandman 586596 586596 Belgrave, Thomas, of Flamsted, husbandman 1
4397325 2163685 2163685 defendant Higdon Walter yeoman 586596 586596 Higdon, Walter, of Flamsted, yeoman 0
4407400 2167037 2167037 defendant Pays Richard miller 586596 586596 Pays, Richard, of Flamsted, miller 0
4440481 2181933 2181933 defendant Sextayn John   586596 586596 Sextayn, John, of Flamsted 3
4967684 2347279 2347279 defendant Osberne Thomas (legal representative) 586596 586596 Osberne, Thomas, of Flamsted, executrix of 0
4967685 2347279 2347279 defendant Osberne Agnes widow 586596 586596 Osberne, Agnes, of Flamsted, widow 1
4991758 2354418 2354418 defendant Baker John husbandman 586596 586596 Baker, John, of Flamsted, husbandman 1
5021229 2363109 2363109 defendant Osbern Agnes widow 586596 586596 Osbern, Agnes, of Flamsted, widow 1
5115117 2390842 2390842 defendant Chopyn William husbandman 586596 586596 Chopyn, William, of Flamsted, husbandman 1
5228739 2424016 2424016 defendant Wannesforth Thomas clerk 586596 586596 Wannesforth, Thomas, of Flamsted, clerk 0
5326053 2452885 2452885 defendant Hill John (legal representative) 586596 586596 Hill, John, of Flamsted, executors of 0
5340286 2457170 2457170 defendant Bostok Richard   586596 586596 Bostok, Richard, of Flamsted, parish clerk 0
5340287 2457170 2457170 defendant Mudd John yeoman 586596 586596 Mudd, John, of Flamsted, yeoman 1
5340288 2457170 2457170 defendant Carpenter William, junior husbandman 586596 586596 Carpenter, William, junior, of Flamsted, husbandman 2
5340289 2457170 2457170 defendant Swan Robert husbandman 586596 586596 Swan, Robert, of Flamsted, husbandman 3
5340290 2457170 2457170 defendant Netmaker John laborer 586596 586596 Netmaker, John, of Flamsted, laborer 4
5346768 2459148 2459148 plaintiff Austyn John yeoman 586596 586596 Austyn, John, of Flamsted, yeoman 0
5348537 2459678 2459678 defendant Terre John husbandman 586596 586596 Terre, John, of Flamsted, husbandman 2
5348555 2459683 2459683 defendant Chalfhunt Walter husbandman 586596 586596 Chalfhunt, Walter, of Flamsted, husbandman 1
5348556 2459683 2459683 defendant Grigge John, senior pulter 586596 586596 Grigge, John, senior, of Flamsted, pulter 2
5348557 2459683 2459683 defendant Grigge John, junior husbandman 586596 586596 Grigge, John, junior, of Flamsted, husbandman 3
5456324 2491811 2491811 defendant Belgrave Hugh husbandman 586596 586596 Belgrave, Hugh, of Flamsted, husbandman 0
5545028 2518550 2518550 defendant Spenser William chaplain 586596 586596 Spenser, William, of Flamsted, chaplain 1
5547302 2519222 2519222 defendant Messenger John husbandman 586596 586596 Messenger, John, of Flamsted, husbandman 1
5547303 2519222 2519222 defendant Grigge Robert husbandman 586596 586596 Grigge, Robert, of Flamsted, husbandman 2
5595521 2533549 2533549 defendant Whitmershe Nicholas laborer 586596 586596 Whitmershe, Nicholas, of Flamsted, laborer 0
5595522 2533549 2533549 defendant Mershe John husbandman 586596 586596 Mershe, John, of Flamsted, husbandman 1
5595525 2533549 2533549 defendant Salwode William husbandman 586596 586596 Salwode, William, of Flamsted, husbandman 4
5605806 2536707 2536707 defendant Hyll Thomas butcher 586596 586596 Hyll, Thomas, of Flamsted, butcher 0
5608090 2537437 2537437 defendant Hille Thomas butcher 586596 586596 Hille, Thomas, of Flamsted, butcher 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);