names

51 rows where place_id = 630847

✎ 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
3796987 1956936 1956936 defendant Hogeson Thomas yeoman 630847 630847 Hogeson, Thomas, of Keton, yeoman 0
3798327 1957376 1957376 defendant Hogeson Thomas yeoman 630847 630847 Hogeson, Thomas, of Keton, yeoman 0
3998159 2024088 2024088 plaintiff Eyer Anthony esq 630847 630847 Eyer, Anthony, of Keton, esq 0
4030977 2035749 2035749 plaintiff Eyre Anthony esq 630847 630847 Eyre, Anthony, of Keton, esq 0
4030979 2035750 2035750 plaintiff Eyre Anthony esq 630847 630847 Eyre, Anthony, of Keton, esq 0
4468733 2190896 2190896 plaintiff Benet Alice   630847 630847 Benet, Alice, of Keton, formerly wife of Simon Benet 0
4468734 2190896 2190896 defendant Skefynton Lawrence turner 630847 630847 Skefynton, Lawrence, of Keton, turner 0
4527796 2208969 2208969 plaintiff Lovet Ralph chaplain 630847 630847 Lovet, Ralph, of Keton, chaplain 0
4527798 2208970 2208970 plaintiff Lovet Ralph chaplain 630847 630847 Lovet, Ralph, of Keton, chaplain 0
4533523 2210756 2210756 defendant Willeson John   630847 630847 Willeson, John, of Keton 1
4536214 2211603 2211603 defendant Lovet Ralph clerk 630847 630847 Lovet, Ralph, of Keton, clerk 0
4635272 2241870 2241870 defendant German John   630847 630847 German, John, of Keton 0
4639088 2242952 2242952 plaintiff Clerk William   630847 630847 Clerk, William, of Keton 0
4650433 2246146 2246146 defendant Berman John   630847 630847 Berman, John, of Keton 0
4675401 2257916 2257916 defendant Dilcok John gent 630847 630847 Dilcok, John, of Keton, gent 0
4686636 2261431 2261431 defendant Smyth William smith 630847 630847 Smyth, William, of Keton, smith 0
4693684 2263523 2263523 defendant Warre William esq 630847 630847 Warre, William, of Keton, esq 0
4759592 2283343 2283343 defendant Dagge John   630847 630847 Dagge, John, of Keton, lock smith 0
4803084 2297150 2297150 defendant Taillor Walter tailor 630847 630847 Taillor, Walter, of Keton, tailor 0
4819610 2302204 2302204 defendant Wynnemere John husbandman 630847 630847 Wynnemere, John, of Keton, husbandman 1
4868970 2317268 2317268 defendant Braywell John husbandman 630847 630847 Braywell, John, of Keton, husbandman 0
4883462 2321747 2321747 defendant Sapcote Joan widow 630847 630847 (Sapcote, Joan, of Keton, widow 2
4883466 2321747 2321747 defendant Tylton William merchant 630847 630847 Tylton, William, of Keton, merchant 6
4894754 2325030 2325030 defendant Sapcote Joan widow 630847 630847 (Sapcote, Joan, of Keton, widow 2
4904729 2328084 2328084 defendant Lombe Thomas yeoman 630847 630847 Lombe, Thomas, of Keton, yeoman 2
4918545 2332317 2332317 defendant Keton Nicholas gent 630847 630847 Keton, Nicholas, of Keton, gent 0
4934498 2337184 2337184 defendant Sapcot Richard merchant 630847 630847 Sapcot, Richard, of Keton, merchant 0
4953949 2343144 2343144 defendant Bonde John husbandman 630847 630847 Bonde, John, of Keton, husbandman 0
4967863 2347333 2347333 defendant Oxendon John chapman 630847 630847 Oxendon, John, of Keton, chapman 1
4980849 2351203 2351203 defendant Bonde John husbandman 630847 630847 Bonde, John, of Keton, husbandman 0
5061802 2375125 2375125 defendant Spenythorn John yeoman 630847 630847 Spenythorn, John, of Keton, yeoman 1
5078579 2380088 2380088 defendant Keton James gent 630847 630847 Keton, James, of Keton, gent 0
5079998 2380497 2380497 defendant Oxdon John merchant 630847 630847 Oxdon, John, of Keton, merchant 0
5081576 2380993 2380993 defendant Oxondon John merchant 630847 630847 Oxondon, John, of Keton, merchant 0
5082460 2381254 2381254 defendant Keton James gent 630847 630847 Keton, James, of Keton, gent 0
5115590 2390989 2390989 plaintiff Scherman John husbandman 630847 630847 Scherman, John, of Keton, husbandman 1
5121092 2392599 2392599 defendant Breton Robert husbandman 630847 630847 Breton, Robert,of Keton, husbandman 0
5222904 2422411 2422411 defendant Sherman John husbandman 630847 630847 Sherman, John, of Keton, husbandman 4
5325209 2452629 2452629 defendant Armeston Richard gent 630847 630847 Armeston, Richard, of Keton, gent 0
5476160 2497874 2497874 defendant Turnour Robert husbandman 630847 630847 Turnour, Robert, of Keton, husbandman 0
5512892 2508887 2508887 defendant Greneham Thomas esq 630847 630847 Greneham, Thomas, of Keton, esq 0
5528701 2513493 2513493 defendant Keton Nicholas gent 630847 630847 Keton, Nicholas, of Keton, gent 0
5528703 2513494 2513494 defendant Keton Nicholas gent 630847 630847 Keton, Nicholas, of Keton, gent 0
5557559 2522165 2522165 defendant Keton Nicholas (legal representative) 630847 630847 Keton, Nicholas, of Keton, gent, executors of 0
5557560 2522165 2522165 defendant Keton Matilda widow 630847 630847 (Keton, Matilda, of Keton, widow 1
5557561 2522165 2522165 defendant Keton John gent 630847 630847 Keton, John, of Keton, gent 2
5590058 2531875 2531875 defendant Keton John gent 630847 630847 Keton, John, of Keton, gent 1
5590067 2531875 2531875 defendant Woderouffe Thomas laborer 630847 630847 Woderouffe, Thomas, of Keton, laborer 10
5623561 2551303 2551303 defendant Germayn John husbandman 630847 630847 Germayn, John, of Keton, husbandman 2
5635829 2555161 2555161 defendant Wright John wright 630847 630847 Wright John, of Keton, wright 1
5635830 2555161 2555161 defendant Wright Richard wright 630847 630847 Wright Richard, of Keton, wright 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);