names

45 rows where place_id = 598357

✎ 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
3632126 1904863 1904863 defendant Sothern Thomas husbandman 598357 598357 Sothern, Thomas, of Bukton, husbandman 0
3638186 1906760 1906760 defendant Chapman John husbandman 598357 598357 Chapman, John, of Bukton, husbandman 0
3710654 1929652 1929652 defendant Cley Walter yeoman 598357 598357 Cley, Walter, of Bukton, yeoman 0
3765943 1947015 1947015 defendant Smalley Thomas husbandman 598357 598357 Smalley, Thomas, of Bukton, husbandman 0
3774247 1949665 1949665 defendant Aylmer Thomas yeoman 598357 598357 Aylmer, Thomas, of Bukton, yeoman 1
3800141 1957968 1957968 defendant Clyfford Robert gent 598357 598357 Clyfford, Robert, of Bukton, gent 0
3817671 1963429 1963429 defendant Clyfford Robert gent 598357 598357 Clyfford, Robert, of Bukton, gent 0
3905185 1991998 1991998 defendant Starky Richard butcher 598357 598357 Starky, Richard, of Bukton, butcher 1
3918007 1996390 1996390 defendant Ingylbright Thomas husbandman 598357 598357 Ingylbright, Thomas, of Bukton, husbandman 0
4608690 2233823 2233823 defendant Palgrave Robert   598357 598357 Palgrave, Robert, of Bukton 0
4647942 2245466 2245466 defendant Plantrose John   598357 598357 Plantrose, John, of Bukton 3
4700919 2265690 2265690 defendant Smyth Thomas smith 598357 598357 Smyth, Thomas, of Bukton, smith 4
4741892 2278126 2278126 defendant Sledmer John yeoman 598357 598357 Sledmer, John, of Bukton, yeoman 2
4751745 2280999 2280999 plaintiff Squyer John   598357 598357 Squyer, John, of bukton, parson, on his own account 0
4751747 2281000 2281000 plaintiff Squyer John   598357 598357 Squyer, John, of Bukton, parson, on his own account 0
4753610 2281500 2281500 defendant Bukton Peter gent 598357 598357 Bukton, Peter, of Bukton, gent 1
4753795 2281559 2281559 defendant Sledmere John husbandman 598357 598357 Sledmere, John, of Bukton, husbandman 4
4761920 2284072 2284072 defendant Bercok Robert yeoman 598357 598357 Bercok, Robert, of Bukton, yeoman 2
4762397 2284223 2284223 defendant Bukton Peter gent 598357 598357 Bukton, Peter, of Bukton, gent 0
4763296 2284509 2284509 defendant Wolpyt Thomas yeoman 598357 598357 Wolpyt, Thomas, of Bukton, yeoman 0
4763297 2284509 2284509 defendant Catisson William yeoman 598357 598357 Catisson, William, of Bukton, yeoman 1
4763298 2284509 2284509 defendant Walpole John yeoman 598357 598357 Walpole, John, of Bukton, yeoman 2
4885117 2322236 2322236 defendant Kervyle John yeoman 598357 598357 Kervyle, John, of Bukton, yeoman 0
4911604 2330130 2330130 defendant Lety Robert   598357 598357 Lety, Robert, of Bukton, parson 1
4936761 2337875 2337875 defendant Chylderhous Stephen yeoman 598357 598357 Chylderhous, Stephen, of Bukton, yeoman 2
4947263 2341133 2341133 defendant Reed Richard (legal representative) 598357 598357 Reed, Richard, of Bukton, executrix of 0
4956710 2343961 2343961 plaintiff Veylle John   598357 598357 Veylle, John, of Bukton 0
4962310 2345628 2345628 defendant Bullok Thomas gent 598357 598357 Bullok, Thomas, of Bukton, gent 2
4971336 2348359 2348359 defendant Wallker Philip husbandman 598357 598357 Wallker, Philip, of Bukton, husbandman 9
4996723 2355879 2355879 defendant Kyrkeby William husbandman 598357 598357 Kyrkeby, William, of Bukton, husbandman 0
5004877 2358324 2358324 defendant Wright Thomas husbandman 598357 598357 Wright, Thomas, of Bukton, husbandman 2
5038539 2368168 2368168 defendant Bonkkes or Boukkes Thomas husbandman 598357 598357 Bonkkes or Boukkes, Thomas, of Bukton, husbandman 1
5038540 2368168 2368168 defendant Walles Thomas husbandman 598357 598357 Walles, Thomas, of Bukton, husbandman 2
5040351 2368717 2368717 defendant Lolle William yeoman 598357 598357 Lolle, William, of Bukton, yeoman 0
5046940 2370707 2370707 defendant Manger Henry husbandman 598357 598357 Manger, Henry, of Bukton, husbandman 1
5046941 2370707 2370707 defendant Saunderson John husbandman 598357 598357 Saunderson, John, of Bukton, husbandman 2
5334784 2455471 2455471 defendant Bukton Robert gent 598357 598357 Bukton, Robert, of Bukton, gent 0
5375621 2467964 2467964 plaintiff Rawelyns Thomas   598357 598357 Rawelyns, Thomas, of Bukton, Rector 0
5420257 2480981 2480981 defendant Byschope William clerk 598357 598357 Byschope, William, of Bukton, clerk 0
5439033 2486595 2486595 defendant Byschoppe William clerk 598357 598357 Byschoppe, William, of Bukton, clerk 0
5444199 2488172 2488172 defendant Foumaye Stephen yeoman 598357 598357 Foumaye, Stephen, of Bukton, yeoman 0
5581013 2529135 2529135 plaintiff Clarell John   598357 598357 Clarell, John, of Bukton 0
5581014 2529135 2529135 defendant Clarell James gent 598357 598357 Clarell, James, of Bukton, gent 0
5599142 2534613 2534613 defendant Smalley Thomas husbandman 598357 598357 Smalley, Thomas, of Bukton, husbandman 9
5632935 2554307 2554307 defendant Davy John esq 598357 598357 Davy, John, of Bukton, esq 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);