names

58 rows where place_id = 601721

✎ 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
3646710 1909372 1909372 defendant Wake Thomas chaplain 601721 601721 Wake, Thomas, of Buxston, chaplain 5
3680438 1919963 1919963 defendant Roo John husbandman 601721 601721 Roo, John, of Buxston, husbandman 4
3680803 1920077 1920077 defendant Roo William carpenter 601721 601721 Roo, William, of Buxston, carpenter 2
3682439 1920609 1920609 defendant Roo William carpenter 601721 601721 Roo, William, of Buxston, carpenter 0
3699720 1926140 1926140 defendant Funhale John raffman 601721 601721 Funhale, John, of Buxston, raffman 0
3699828 1926171 1926171 plaintiff Abbys Thomas, senior   601721 601721 Abbys, Thomas, senior, of Buxston 0
3699830 1926172 1926172 plaintiff Abbys Thomas, senior   601721 601721 Abbys, Thomas, senior, of Buxston 0
3758999 1944802 1944802 defendant Thyrkell James smith 601721 601721 Thyrkell, James, of Buxston, smith 0
3834867 1968846 1968846 defendant Thykke Richard   601721 601721 Thykke, Richard, of Buxston, worsted weaver 0
3985282 2019495 2019495 defendant Defe or Delfe Robert miller 601721 601721 Defe or Delfe, Robert, of Buxston, miller 0
4013346 2029506 2029506 defendant Stubbes John (legal representative) 601721 601721 Stubbes, John, of Buxston, gent, executrix of 0
4013347 2029506 2029506 defendant Stubbes Ela widow 601721 601721 Stubbes, Ela, of Buxston, widow 1
4207565 2098206 2098206 defendant Toll Robert cordwainer 601721 601721 Toll, Robert, of Buxston, cordwainer 0
4207566 2098206 2098206 defendant Chamberlyn William cordwainer 601721 601721 Chamberlyn, William, of Buxston, cordwainer 1
4572470 2222930 2222930 defendant Hobbys John   601721 601721 Hobbys, John, of Buxston 1
4623875 2238444 2238444 defendant Heddys William   601721 601721 Heddys, William, of Buxston 0
4628684 2239895 2239895 defendant Howes Richard   601721 601721 Howes, Richard, of Buxston 0
4662925 2249867 2249867 defendant Hawes John gent 601721 601721 Hawes, John, of Buxston, gent 0
4680843 2259629 2259629 defendant Lone or Love Thomas yeoman 601721 601721 Lone or Love, Thomas, of Buxston, yeoman 7
4736197 2276456 2276456 defendant Skelehous John   601721 601721 Skelehous, John, of Buxston 2
4736198 2276456 2276456 defendant Warmal John yeoman 601721 601721 Warmal, John, of Buxston, yeoman 3
4746671 2279517 2279517 plaintiff Hoddes William   601721 601721 Hoddes, William, of Buxston, on his own account 0
4765173 2285088 2285088 plaintiff Howys William   601721 601721 Howys, William, of Buxston 0
4791673 2293494 2293494 defendant Padley Thomas   601721 601721 Padley, Thomas, of Buxston, bailiff 0
4827609 2304686 2304686 defendant Peytre Henry   601721 601721 Peytre, Henry, of Buxston, worsted weaver 0
4829188 2305171 2305171 defendant Peye William butcher 601721 601721 Peye, William, of Buxston, butcher 1
4831213 2305793 2305793 defendant Love or Lone Thomas yeoman 601721 601721 Love or Lone, Thomas, of Buxston, yeoman 3
4838654 2308015 2308015 defendant Hawys John gent 601721 601721 Hawys, John, of Buxston, gent 0
4838656 2308016 2308016 defendant Hawys John gent 601721 601721 Hawys, John, of Buxston, gent 0
4841099 2308750 2308750 defendant Stones Nicholas shoemaker 601721 601721 Stones, Nicholas, of Buxston, shoemaker 0
4865837 2316284 2316284 defendant Haweys John gent 601721 601721 Haweys, John, of Buxston, gent 0
4866891 2316606 2316606 defendant Morley Thomas   601721 601721 Morley, Thomas, of Buxston, knight 0
4872469 2318348 2318348 defendant Pye William husbandman 601721 601721 Pye, William, of Buxston, husbandman 5
4888074 2323073 2323073 defendant Hawes John gent 601721 601721 Hawes, John, of Buxston, gent 0
4897889 2325999 2325999 defendant Lone or Love Thomas yeoman 601721 601721 Lone or Love, Thomas, of Buxston, yeoman 0
4962137 2345578 2345578 defendant Love Thomas, senior yeoman 601721 601721 Love, Thomas, senior, of Buxston, yeoman 4
5016891 2361831 2361831 defendant Woderove John miller 601721 601721 Woderove, John, of Buxston, miller 0
5077400 2379741 2379741 defendant Smyth John husbandman 601721 601721 Smyth, John, of Buxston, husbandman 0
5313250 2448999 2448999 defendant Abbes or Abbot John husbandman 601721 601721 Abbes or Abbot, John, of Buxston, husbandman 3
5315528 2449711 2449711 defendant Bully Robert husbandman 601721 601721 Bully, Robert, of Buxston, husbandman 2
5337075 2456165 2456165 defendant Roo Robert husbandman 601721 601721 Roo, Robert, of Buxston, husbandman 1
5393245 2473119 2473119 defendant Howechyn Richard shoemaker 601721 601721 Howechyn, Richard, of Buxston, shoemaker 3
5456681 2491921 2491921 defendant Oter William husbandman 601721 601721 Oter, William, of Buxston, husbandman 2
5514196 2509284 2509284 plaintiff Pyktoo John clerk 601721 601721 Pyktoo, John, of Buxston, clerk 0
5514198 2509285 2509285 plaintiff Pyktoo John clerk 601721 601721 Pyktoo, John, of Buxston, clerk 0
5542713 2517840 2517840 defendant Roo William carpenter 601721 601721 Roo, William, of Buxston, carpenter 1
5544915 2518516 2518516 defendant Buxston Henry husbandman 601721 601721 Buxston, Henry, of Buxston, husbandman 0
5557790 2522230 2522230 defendant Hawes Henry   601721 601721 Hawes, Henry, of Buxston, worsted weaver 0
5562580 2523658 2523658 defendant Thakwere Ralph tailor 601721 601721 Thakwere, Ralph, of Buxston, tailor 0
5594789 2533343 2533343 defendant Goodyn Richard yeoman 601721 601721 Goodyn, Richard, of Buxston, yeoman 0
5594790 2533343 2533343 defendant Nedeham Christopher yeoman 601721 601721 Nedeham, Christopher, of Buxston, yeoman 1
5594791 2533343 2533343 defendant Henshaa Ralph husbandman 601721 601721 Henshaa, Ralph, of Buxston, husbandman 2
5594792 2533343 2533343 defendant Jakson John husbandman 601721 601721 Jakson, John, of Buxston, husbandman 3
5594793 2533343 2533343 defendant Toore John husbandman 601721 601721 Toore, John, of Buxston, husbandman 4
5594794 2533343 2533343 defendant Wyndell John smith 601721 601721 Wyndell, John, of Buxston, smith 5
5594795 2533343 2533343 defendant Clayton Edward husbandman 601721 601721 Clayton, Edward, of Buxston, husbandman 6
5594796 2533343 2533343 defendant Matheweson Thomas husbandman 601721 601721 Matheweson, Thomas, of Buxston, husbandman 7
5594797 2533343 2533343 defendant Buxston Henry husbandman 601721 601721 Buxston, Henry, of Buxston, husbandman 8

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