names

53 rows where place_id = 593489

✎ 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
3612076 1871421 1871421 defendant Arnold Henry gent 593489 593489 Arnold, Henry, of Gelyngham, gent 0
3622036 1874433 1874433 defendant Stannefeld Richard yeoman 593489 593489 Stannefeld, Richard, of Gelyngham, yeoman 0
3698225 1925667 1925667 defendant Polhyll John   593489 593489 Polhyll, John, of Gelyngham 1
3711865 1930026 1930026 defendant Polhyll John   593489 593489 Polhyll, John, of Gelyngham 1
3723635 1933666 1933666 defendant Maunser William yeoman 593489 593489 Maunser, William, of Gelyngham, yeoman 0
3746179 1940712 1940712 defendant Holbowe John husbandman 593489 593489 Holbowe, John, of Gelyngham, husbandman 1
3752574 1942733 1942733 defendant Kyppyng Nicholas husbandman 593489 593489 Kyppyng, Nicholas, of Gelyngham, husbandman 0
3752708 1942775 1942775 defendant Kyppyng Nicholas husbandman 593489 593489 (Kyppyng, Nicholas, of Gelyngham, husbandman 1
3778888 1951112 1951112 defendant Underwode William tailor 593489 593489 Underwode, William, of Gelyngham, tailor 0
3794334 1956104 1956104 defendant Johnson John husbandman 593489 593489 Johnson, John, of Gelyngham, husbandman 0
3795975 1956604 1956604 defendant Underwode William husbandman 593489 593489 Underwode, William, of Gelyngham, husbandman 0
3849521 1973448 1973448 defendant Bryggys Thomas husbandman 593489 593489 Bryggys, Thomas, of Gelyngham, husbandman 2
3872315 1980966 1980966 plaintiff Bettys John   593489 593489 Bettys, John, of Gelyngham 0
3899716 1990118 1990118 defendant Clerke William husbandman 593489 593489 Clerke, William, of Gelyngham, husbandman 4
4519463 2206446 2206446 defendant Bonde William   593489 593489 (Bonde, William, of Gelyngham 1
4519469 2206447 2206447 defendant Bonde William   593489 593489 (Bonde, William, of Gelyngham 1
4660737 2249182 2249182 defendant Moune or Monne Edmund clerk 593489 593489 Moune or Monne, Edmund, of Gelyngham, clerk 0
4721354 2272010 2272010 defendant Bonde William husbandman 593489 593489 Bonde, William, of Gelyngham, husbandman 1
4916685 2331726 2331726 defendant Lasebond John   593489 593489 Lasebond, John, of Gelyngham 11
4916701 2331727 2331727 defendant Laseblond John   593489 593489 Laseblond, John, of Gelyngham 11
4963460 2345985 2345985 defendant Kymworth William laborer 593489 593489 Kymworth, William, of Gelyngham, laborer 0
4999679 2356781 2356781 defendant Trenchemere Nicholas husbandman 593489 593489 Trenchemere, Nicholas, of Gelyngham, husbandman 1
5067462 2376768 2376768 defendant Treweman John husbandman 593489 593489 Treweman, John, of Gelyngham, husbandman 1
5067463 2376768 2376768 defendant Ferry John yeoman 593489 593489 Ferry, John, of Gelyngham, yeoman 2
5067468 2376769 2376769 defendant Godfrey Gilbert husbandman 593489 593489 Godfrey, Gilbert, of Gelyngham, husbandman 0
5078988 2380199 2380199 defendant Bregeman John husbandman 593489 593489 Bregeman, John, of Gelyngham, husbandman 0
5105741 2388128 2388128 defendant Harry John laborer 593489 593489 Harry, John, of Gelyngham, laborer 4
5105980 2388188 2388188 defendant Harry John laborer 593489 593489 Harry, John, of Gelyngham, laborer 1
5111153 2389650 2389650 defendant Fylle John husbandman 593489 593489 Fylle, John, of Gelyngham, husbandman 3
5117973 2391686 2391686 defendant Ferry John laborer 593489 593489 Ferry, John, of Gelyngham, laborer 0
5127676 2394577 2394577 defendant Wynchild Robert butcher 593489 593489 Wynchild, Robert, of Gelyngham, butcher 1
5235199 2425873 2425873 plaintiff Darlond Richard gent 593489 593489 Darlond, Richard, of Gelyngham, gent 0
5261612 2433740 2433740 defendant Bamme John esq 593489 593489 Bamme, John, of Gelyngham, esq 0
5266374 2435234 2435234 defendant Thorp Nicholas husbandman 593489 593489 Thorp, Nicholas, of Gelyngham, husbandman 0
5266382 2435235 2435235 defendant Thorp Nicholas husbandman 593489 593489 Thorp, Nicholas, of Gelyngham, husbandman 2
5357155 2462301 2462301 defendant Trunchemer Richard husbandman 593489 593489 Trunchemer, Richard, of Gelyngham, husbandman 1
5378199 2468756 2468756 defendant Grygges John smith 593489 593489 Grygges, John, of Gelyngham, smith 0
5413845 2479065 2479065 defendant Sheryff Richard smith 593489 593489 Sheryff, Richard, of Gelyngham, smith 0
5489730 2501810 2501810 defendant Stanfeld Richard husbandman 593489 593489 Stanfeld, Richard, of Gelyngham, husbandman 0
5504587 2506354 2506354 defendant Stanfeld Richard husbandman 593489 593489 (Stanfeld, Richard, of Gelyngham, husbandman 1
5511020 2508286 2508286 defendant Wode John husbandman 593489 593489 Wode, John, of Gelyngham, husbandman 2
5512531 2508779 2508779 defendant Wode John husbandman 593489 593489 Wode, John, of Gelyngham, husbandman 1
5512532 2508779 2508779 defendant Barton John husbandman 593489 593489 Barton, John, of Gelyngham, husbandman 2
5515494 2509688 2509688 defendant Philippes Richard husbandman 593489 593489 Philippes, Richard, of Gelyngham, husbandman 0
5530762 2514138 2514138 defendant Wode John yeoman 593489 593489 Wode, John, of Gelyngham, yeoman 1
5540338 2517107 2517107 defendant Fynche John laborer 593489 593489 Fynche, John, of Gelyngham, laborer 0
5559033 2522602 2522602 defendant Grenehyll Thomas husbandman 593489 593489 Grenehyll, Thomas, of Gelyngham, husbandman 0
5580414 2528959 2528959 defendant Coksegge Edmund gent 593489 593489 Coksegge, Edmund, of Gelyngham, gent 0
5580415 2528959 2528959 defendant Coksegge John husbandman 593489 593489 Coksegge, John, of Gelyngham, husbandman 1
5580416 2528959 2528959 defendant Grenehill John husbandman 593489 593489 Grenehill, John, of Gelyngham, husbandman 2
5582905 2529721 2529721 defendant Broun William yeoman 593489 593489 Broun, William, of Gelyngham, yeoman 0
5599314 2534667 2534667 plaintiff Godfrey William yeoman 593489 593489 Godfrey, William, of Gelyngham, yeoman 0
5630679 2553601 2553601 defendant Mome Edmund clerk 593489 593489 Mome, Edmund, of Gelyngham, clerk 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);