names

47 rows where place_id = 631736

✎ 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
3802448 1958662 1958662 defendant Chapman Thomas chaplain 631736 631736 Chapman, Thomas, of Haburgh, chaplain 1
4452734 2185866 2185866 defendant Crayne Robert   631736 631736 Crayne, Robert, of Haburgh, son of Henry 0
4480910 2194700 2194700 defendant Trippok John   631736 631736 Trippok, John, of Haburgh 0
4488486 2197119 2197119 defendant Trippok John   631736 631736 Trippok, John, of Haburgh 0
4497939 2200003 2200003 defendant Trippokes John   631736 631736 Trippokes, John, of Haburgh 0
4502677 2201420 2201420 defendant Goushyll Richard de   631736 631736 Goushyll, Richard de, of Haburgh 0
4505426 2202226 2202226 defendant Gonsoll Richard de   631736 631736 Gonsoll, Richard de, of Haburgh 0
4537583 2212027 2212027 defendant Trippok John   631736 631736 Trippok, John, of Haburgh 5
4569259 2221972 2221972 defendant Trippok John   631736 631736 Trippok, John, of Haburgh 1
4569261 2221973 2221973 defendant Trippok John   631736 631736 Trippok, John, of Haburgh 0
4597657 2230518 2230518 plaintiff Skippewyth William esq 631736 631736 Skippewyth, William, of Haburgh, esq 0
4625717 2239004 2239004 defendant Baron Stephen   631736 631736 Baron, Stephen, of Haburgh 1
4625718 2239004 2239004 defendant Gresseby John   631736 631736 Gresseby, John, of Haburgh 2
4625720 2239004 2239004 defendant Gowesyll Richard   631736 631736 Gowesyll, Richard, of Haburgh 4
4645693 2244808 2244808 defendant Gouxhill Richard   631736 631736 Gouxhill, Richard, of Haburgh 0
4645700 2244809 2244809 defendant Trippok John   631736 631736 Trippok, John, of Haburgh 3
4660955 2249250 2249250 defendant Couper Thomas husbandman 631736 631736 Couper, Thomas, of Haburgh, husbandman 0
4677071 2258445 2258445 defendant Drewery Walter husbandman 631736 631736 Drewery, Walter, of Haburgh, husbandman 0
4677072 2258445 2258445 defendant Lebande John laborer 631736 631736 Lebande, John, of Haburgh, laborer 1
4688560 2261987 2261987 defendant Barneby John husbandman 631736 631736 Barneby, John, of Haburgh, husbandman 0
4688562 2261987 2261987 defendant Spillesby Robert husbandman 631736 631736 Spillesby, Robert, of Haburgh, husbandman 2
4726438 2273552 2273552 defendant Drowery Walter husbandman 631736 631736 Drowery, Walter, of Haburgh, husbandman 0
4726737 2273631 2273631 defendant Chaumberlayn Thomas yeoman 631736 631736 Chaumberlayn, Thomas, of Haburgh, yeoman 0
4727043 2273721 2273721 defendant Baron Stephen husbandman 631736 631736 Baron, Stephen, of Haburgh, husbandman 2
4757391 2282683 2282683 defendant Cornelys Richard husbandman 631736 631736 Cornelys, Richard, of Haburgh, husbandman 0
4821087 2302674 2302674 defendant Goushill Richard   631736 631736 Goushill, Richard, of Haburgh, bailiff 1
4828434 2304938 2304938 defendant Grysby Margaret widow 631736 631736 Grysby, Margaret, of Haburgh, widow 0
4835861 2307202 2307202 defendant Gonshill William husbandman 631736 631736 together with Gonshill, William, of Haburgh, husbandman 4
4878065 2320091 2320091 defendant Gouxhill Richard husbandman 631736 631736 Gouxhill, Richard, of Haburgh, husbandman 4
4891403 2324040 2324040 defendant Barker William husbandman 631736 631736 Barker, William, of Haburgh, husbandman 0
4904962 2328155 2328155 defendant Corneles Robert husbandman 631736 631736 Corneles, Robert, of Haburgh, husbandman 0
4969045 2347705 2347705 plaintiff Gonsell or Gousell William husbandman 631736 631736 Gonsell or Gousell, William, of Haburgh, husbandman 0
4969991 2347976 2347976 defendant Cokke John glover 631736 631736 Cokke, John, of Haburgh, glover 0
5007030 2358953 2358953 defendant Cornelys Robert husbandman 631736 631736 Cornelys, Robert, of Haburgh, husbandman 1
5007031 2358953 2358953 defendant Cokke John husbandman 631736 631736 Cokke, John, of Haburgh, husbandman 2
5007032 2358953 2358953 defendant Smyth John chaplain 631736 631736 Smyth, John, of Haburgh, chaplain 3
5020325 2362830 2362830 defendant Gowesyll John husbandman 631736 631736 Gowesyll, John, of Haburgh, husbandman 12
5115887 2391074 2391074 defendant Faukonner William husbandman 631736 631736 Faukonner, William, of Haburgh, husbandman 2
5115888 2391074 2391074 defendant Rednes Thomas weaver 631736 631736 Rednes, Thomas, of Haburgh, weaver 3
5421563 2481384 2481384 defendant Hudson William husbandman 631736 631736 Hudson, William, of Haburgh, husbandman 0
5430916 2484193 2484193 defendant Hudson William husbandman 631736 631736 Hudson, William, of Haburgh, husbandman 0
5447506 2489141 2489141 defendant Hudson William husbandman 631736 631736 Hudson, William, of Haburgh, husbandman 0
5459972 2492912 2492912 defendant Hudson William husbandman 631736 631736 Hudson, William, of Haburgh, husbandman 0
5459974 2492913 2492913 defendant Hudson William husbandman 631736 631736 Hudson, William, of Haburgh, husbandman 0
5459976 2492914 2492914 defendant Hudson William husbandman 631736 631736 Hudson, William, of Haburgh, husbandman 0
5502307 2505646 2505646 defendant Cosen John husbandman 631736 631736 Cosen, John, of Haburgh, husbandman 0
5502308 2505646 2505646 defendant Gillesley Nicholas husbandman 631736 631736 Gillesley, Nicholas, of Haburgh, husbandman 1

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