names

82 rows where place_id = 594578

✎ 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
3590641 1864715 1864715 defendant Cole Benedict   594578 594578 Cole, Benedict, of Oulton, mason 0
3616657 1872840 1872840 defendant Willyams James clerk 594578 594578 Willyams, James, of Oulton, clerk 0
3616694 1872851 1872851 defendant Wyllyams James clerk 594578 594578 Wyllyams, James, of Oulton, clerk 0
3660142 1913433 1913433 plaintiff Harvy John gent & son of Master John Harvy 594578 594578 Harvy, John, of Oulton, gent & son of Master John Harvy 0
3738424 1938225 1938225 defendant Borne John husbandman 594578 594578 Borne, John, of Oulton, husbandman 0
3748986 1941614 1941614 plaintiff Harvy John gent 594578 594578 Harvy, John, of Oulton, gent 0
3831318 1967682 1967682 defendant Catton Edmund husbandman 594578 594578 Catton, Edmund, of Oulton, husbandman 2
3836754 1969394 1969394 plaintiff Rump Edward   594578 594578 Rump, Edward, of Oulton, worsted weaver 0
3836756 1969395 1969395 plaintiff Rump Edward   594578 594578 Rump, Edward, of Oulton, worsted weaver 0
3841084 1970785 1970785 defendant Dyxe John laborer 594578 594578 Dyxe, John, of Oulton, laborer 0
3867182 1979261 1979261 plaintiff Rumpe Edward   594578 594578 Rumpe, Edward, of Oulton, worsted weaver 0
3913491 1994850 1994850 defendant Brymley Robert   594578 594578 Brymley, Robert, of Oulton, worsted weaver 0
3920931 1997347 1997347 defendant Woode Richard laborer 594578 594578 Woode, Richard, of Oulton, laborer 1
3935150 2002066 2002066 defendant Barfote John laobrer 594578 594578 Barfote, John, of Oulton, laobrer 1
3935152 2002066 2002066 defendant Crowmer Richard thatcher 594578 594578 Crowmer, Richard, of Oulton, thatcher 3
3941111 2004029 2004029 defendant Kent William husbandman 594578 594578 Kent, William, of Oulton, husbandman 2
3980246 2017700 2017700 defendant Swetyn Richard tailor 594578 594578 Swetyn, Richard, of Oulton, tailor 2
4023077 2032970 2032970 defendant Hocker William   594578 594578 Hocker, William, of Oulton, tailor, administrators of 2
4023078 2032970 2032970 defendant Tybbyngton Thomas husbandman 594578 594578 (Tybbyngton, Thomas, of Oulton, husbandman 3
4026807 2034234 2034234 defendant Dyx Martin tailor 594578 594578 Dyx, Martin, of Oulton, tailor 1
4026808 2034234 2034234 defendant Brease John husbandman 594578 594578 Brease, John, of Oulton, husbandman 2
4029407 2035154 2035154 defendant Tybbyngton Thomas husbandman 594578 594578 (Tybbyngton, Thomas, of Oulton, husbandman 3
4033124 2036496 2036496 plaintiff Goodman Robert (legal representative) 594578 594578 Goodman, Robert, of Oulton, executors of 0
4033128 2036497 2036497 plaintiff Goodman Robert (legal representative) 594578 594578 Goodman, Robert, of Oulton, executors of 0
4075454 2051523 2051523 defendant Faukes Thomas husbandman 594578 594578 Faukes, Thomas, of Oulton, husbandman 0
4075458 2051524 2051524 defendant Faukes Thomas husbandman 594578 594578 Faukes, Thomas, of Oulton, husbandman 0
4141407 2075151 2075151 defendant Wysdome John husbandman 594578 594578 Wysdome, John, of Oulton, husbandman 0
4182900 2089503 2089503 defendant Bell Nicholas yeoman 594578 594578 Bell, Nicholas, of Oulton, yeoman 0
4224004 2103881 2103881 defendant Whitehead John   594578 594578 Whitehead, John, of Oulton, husbandman, oatmeal maker 1
4281243 2123349 2123349 defendant Devies Christopher husbandman 594578 594578 Devies, Christopher, of Oulton, husbandman 1
4286235 2125131 2125131 defendant Wysdome Richard laborer 594578 594578 Wysdome, Richard, of Oulton, or of Heydone, laborer 3
4319696 2137001 2137001 defendant Devies Christopher husbandman 594578 594578 Devies, Christopher, of Oulton, husbandman 1
4478869 2194062 2194062 defendant atte Halle Henry   594578 594578 atte Halle, Henry, of Oulton 0
4533755 2210824 2210824 defendant Dickes John   594578 594578 Dickes, John, of Oulton 2
4533756 2210824 2210824 defendant Davy John   594578 594578 Davy, John, of Oulton 3
4653660 2247073 2247073 defendant Tetyshale Geoffrey husbandman 594578 594578 Tetyshale, Geoffrey, of Oulton, husbandman 0
4707997 2267873 2267873 defendant atte Style Roger yeoman 594578 594578 atte Style, Roger, of Oulton, yeoman 1
4721359 2272012 2272012 defendant Bacon Stephen gent 594578 594578 Bacon, Stephen, of Oulton, formerly staying in Heydon, gent 0
4915615 2331384 2331384 defendant Nicholl John yeoman 594578 594578 Nicholl, John, of Oulton, yeoman 0
4952108 2342600 2342600 defendant Nicoll John yeoman 594578 594578 Nicoll, John, of Oulton, yeoman 0
5008770 2359456 2359456 defendant Bettys Roger yeoman 594578 594578 Bettys, Roger, of Oulton, yeoman 0
5008771 2359456 2359456 defendant Dykkys Ralph husbandman 594578 594578 Dykkys, Ralph, of Oulton, husbandman 1
5016208 2361625 2361625 defendant Styward William gent 594578 594578 Styward, William, of Oulton, gent 0
5016353 2361676 2361676 defendant Broun William husbandman 594578 594578 Broun, William, of Oulton, husbandman 0
5039573 2368483 2368483 defendant Styward William gent 594578 594578 Styward, William, of Oulton, gent 0
5054357 2372882 2372882 defendant Styward William gent 594578 594578 Styward, William, of Oulton, gent 0
5054468 2372911 2372911 defendant Styward William gent 594578 594578 Styward, William, of Oulton, gent 0
5069444 2377359 2377359 defendant Styward William gent 594578 594578 Styward, William, of Oulton, gent 1
5077449 2379753 2379753 defendant Styward William gent 594578 594578 Styward, William, of Oulton, gent 0
5080265 2380587 2380587 defendant Neweman John baker 594578 594578 Neweman, John, of Oulton, baker 1
5082237 2381179 2381179 defendant Styward William gent 594578 594578 Styward, William, of Oulton, gent 3
5093645 2384537 2384537 defendant Styward William gent 594578 594578 Styward, William, of Oulton, gent 0
5102780 2387231 2387231 defendant Bettys John husbandman 594578 594578 Bettys, John, of Oulton, husbandman 0
5106480 2388328 2388328 defendant Styward William gent 594578 594578 Styward, William, of Oulton, gent 0
5197534 2415017 2415017 plaintiff Styward William   594578 594578 Styward, William, of Oulton 0
5197535 2415017 2415017 plaintiff Thomys John   594578 594578 Thomys, John, of Oulton 1
5210189 2418706 2418706 plaintiff Thomys John   594578 594578 Thomys, John, of Oulton 1
5212963 2419526 2419526 defendant Bettys John, junior husbandman 594578 594578 Bettys, John, junior, of Oulton, husbandman 2
5234954 2425803 2425803 defendant Styward William gent 594578 594578 Styward, William, of Oulton, gent 0
5314608 2449402 2449402 defendant Dokkyng John gent 594578 594578 Dokkyng, John, of Oulton, gent 0
5329912 2454017 2454017 defendant Hunworth Roger husbandman 594578 594578 Hunworth, Roger, of Oulton, husbandman 1
5330482 2454198 2454198 plaintiff Ingelotte Edmund   594578 594578 Ingelotte, Edmund, of Oulton 1
5360121 2463206 2463206 defendant Pekeryng William husbandman 594578 594578 Pekeryng, William, of Oulton, husbandman 1
5372014 2466839 2466839 defendant Deryng Richard laborer 594578 594578 Deryng, Richard, of Oulton, laborer 2
5389108 2471934 2471934 defendant Sampson Simon gent 594578 594578 Sampson, Simon, of Oulton, gent 0
5389109 2471934 2471934 defendant Whyte John husbandman 594578 594578 Whyte, John, of Oulton, husbandman 1
5401811 2475580 2475580 defendant Sampson Simon gent 594578 594578 Sampson, Simon, of Oulton, gent 0
5401812 2475580 2475580 defendant Whyte John husbandman 594578 594578 Whyte, John, of Oulton, husbandman 1
5406439 2476914 2476914 defendant Sarys Richard husbandman 594578 594578 Sarys, Richard, of Oulton, husbandman 1
5415134 2479466 2479466 defendant Deryn Richard laborer 594578 594578 Deryn, Richard, of Oulton, laborer 3
5419570 2480774 2480774 defendant Sarys Richard husbandman 594578 594578 Sarys, Richard, of Oulton, husbandman 1
5431256 2484293 2484293 defendant Deryng Richard laborer 594578 594578 Deryng, Richard, of Oulton, laborer 3
5437949 2486285 2486285 defendant Sarys Richard husbandman 594578 594578 Sarys, Richard, of Oulton, husbandman 1
5448887 2489559 2489559 defendant Fastolf Katherine (legal representative) 594578 594578 Fastolf, Katherine, of Oulton, widow, executors of 0
5448889 2489559 2489559 defendant Bedyngfeld Thomas clerk 594578 594578 Bedyngfeld, Thomas, of Oulton, clerk 2
5461059 2493257 2493257 defendant Fastolf Katherine (legal representative) 594578 594578 Fastolf, Katherine, of Oulton, widow, executors of 0
5461061 2493257 2493257 defendant Bedyngfeld Thomas clerk 594578 594578 Bedyngfeld, Thomas, of Oulton, clerk 2
5461089 2493261 2493261 defendant Fastolff Katherine (legal representative) 594578 594578 Fastolff, Katherine, of Oulton, widow, executor of 0
5461090 2493261 2493261 defendant Bedyngfeld Thomas clerk 594578 594578 (Bedyngfeld, Thomas, of Oulton, clerk 1
5496482 2503857 2503857 defendant Herman William husbandman 594578 594578 Herman, William, of Oulton, husbandman 0
5511437 2508423 2508423 defendant Herman William husbandman 594578 594578 Herman, William, of Oulton, husbandman 0
5511442 2508424 2508424 defendant Herman William husbandman 594578 594578 Herman, William, of Oulton, husbandman 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);