names

84 rows where place_id = 597430

✎ 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
3628533 1903794 1903794 defendant Morgyn John laborer 597430 597430 Morgyn, John, of Osprenge, laborer 0
3630449 1904357 1904357 defendant Lott Richard husbandman 597430 597430 Lott, Richard, of Osprenge, husbandman 0
3634513 1905597 1905597 defendant Hewet William husbandman 597430 597430 Hewet, William, of Osprenge, husbandman 0
3634514 1905597 1905597 defendant Carter Roger husbandman 597430 597430 Carter, Roger, of Osprenge, husbandman 1
3634516 1905598 1905598 defendant Hewet William husbandman 597430 597430 Hewet, William, of Osprenge, husbandman 0
3634517 1905598 1905598 defendant Carter Roger husbandman 597430 597430 Carter, Roger, of Osprenge, husbandman 1
3651744 1910898 1910898 defendant Weldysshe Thomas husbandman 597430 597430 Weldysshe, Thomas, of Osprenge, husbandman 3
3652315 1911064 1911064 defendant Jekyn Richard carpenter 597430 597430 Jekyn, Richard, of Osprenge, carpenter 0
3652317 1911065 1911065 defendant Partriche Thomas innholder 597430 597430 Partriche, Thomas, of Osprenge, innholder 0
3653194 1911334 1911334 defendant Wyse Thomas husbandman 597430 597430 Wyse, Thomas, of Osprenge, husbandman 1
3653195 1911334 1911334 defendant Taylor Stephen husbandman 597430 597430 Taylor, Stephen, of Osprenge, husbandman 2
3673422 1917707 1917707 defendant Feest William laborer 597430 597430 Feest, William, of Osprenge, laborer 2
3675214 1918282 1918282 defendant Spynke John bricklayer 597430 597430 Spynke, John, of Osprenge, bricklayer 0
3675215 1918282 1918282 defendant Foster John carpenter 597430 597430 Foster, John, of Osprenge, carpenter 1
3679355 1919604 1919604 defendant Lyeng Maurice   597430 597430 Lyeng, Maurice, of Osprenge, surgeon 1
3679544 1919671 1919671 defendant Draydon Richard husbandman 597430 597430 Draydon, Richard, of Osprenge, husbandman 0
3704016 1927543 1927543 defendant Massam or Masse John chaplain 597430 597430 Massam or Masse, John, of Osprenge, chaplain 1
3743700 1939911 1939911 defendant Botell William husbandman 597430 597430 Botell, William, of Osprenge, husbandman 2
3756520 1944016 1944016 defendant Atlese Lawrence husbandman 597430 597430 Atlese, Lawrence, of Osprenge, husbandman 0
3920109 1997059 1997059 defendant Baker Robert husbandman 597430 597430 Baker, Robert, of Osprenge, husbandman 3
4456803 2187135 2187135 defendant Fysshere John   597430 597430 Fysshere, John, of Osprenge 0
4464199 2189474 2189474 defendant Furnenger John   597430 597430 Furnenger, John, of Osprenge 1
4553377 2216990 2216990 defendant Taylour William (legal representative) 597430 597430 Taylour, William, of Osprenge, son of Adam, administrator of 0
4620652 2237448 2237448 defendant Poteman Thomas   597430 597430 Poteman, Thomas, of Osprenge 0
4627538 2239545 2239545 plaintiff Rolf Thomas   597430 597430 Rolf, Thomas, of Osprenge 0
4661845 2249552 2249552 defendant Smyth John laborer 597430 597430 Smyth, John, of Osprenge, laborer 1
4664108 2250262 2250262 defendant Broun Thomas ostler 597430 597430 Broun, Thomas, of Osprenge, ostler 0
4680809 2259618 2259618 defendant Deye Nicholas taverner 597430 597430 Deye, Nicholas, of Osprenge, taverner 0
4723873 2272768 2272768 defendant Bokelond Stephen husbandman 597430 597430 Bokelond, Stephen, of Osprenge, husbandman 2
4737876 2276950 2276950 defendant Wade John hosteller 597430 597430 Wade, John, of Osprenge, hosteller 0
4776701 2288703 2288703 defendant Kyng Thomas thatcher 597430 597430 Kyng, Thomas, of Osprenge, thatcher 0
4783239 2290775 2290775 defendant Wade John hosteler 597430 597430 Wade, John, of Osprenge, hosteler 1
4800005 2296184 2296184 defendant Fullere Thomas fuller 597430 597430 Fullere, Thomas, of Osprenge, fuller 3
4816792 2301351 2301351 defendant Rogger Richard husbandman 597430 597430 Rogger, Richard, of Osprenge, husbandman 1
4823045 2303290 2303290 defendant Terysersshe alias Sterysersshe William husbandman 597430 597430 Terysersshe alias Sterysersshe, William, of Osprenge, husbandman 0
4861046 2314813 2314813 defendant Foule Robert laborer 597430 597430 Foule, Robert, of Osprenge, laborer 1
4897302 2325813 2325813 defendant Poteman Thomas husbandman 597430 597430 Poteman, Thomas, of Osprenge, husbandman 0
4923013 2333615 2333615 defendant Dancastre William yeoman 597430 597430 Dancastre, William, of Osprenge, yeoman 0
4934423 2337158 2337158 plaintiff atte Sole Seman   597430 597430 atte Sole, Seman, of Osprenge 0
4935769 2337579 2337579 defendant atte Sole Seman yeoman 597430 597430 atte Sole, Seman, of Osprenge, yeoman 0
4939290 2338670 2338670 defendant Fox Robert laborer 597430 597430 Fox, Robert, of Osprenge, laborer 3
4961156 2345299 2345299 defendant Wade John   597430 597430 Wade, John, of Osprenge 0
4985938 2352712 2352712 defendant Benet William butcher 597430 597430 Benet, William, of Osprenge, butcher 2
4985939 2352712 2352712 defendant Benet Richard butcher 597430 597430 Benet, Richard, of Osprenge, butcher 3
4990876 2354163 2354163 defendant atte Sole Seamus husbandman 597430 597430 atte Sole, Seamus, of Osprenge, husbandman 0
4991284 2354278 2354278 defendant Wade John husbandman 597430 597430 Wade, John, of Osprenge, husbandman 0
4991687 2354398 2354398 defendant Fox Robert laborer 597430 597430 Fox, Robert, of Osprenge, laborer 0
4991690 2354399 2354399 defendant Kete William husbandman 597430 597430 Kete, William, of Osprenge, husbandman 0
5005338 2358464 2358464 defendant Exbrigge John gent 597430 597430 Exbrigge, John, of Osprenge, gent 1
5005339 2358464 2358464 defendant Wade John yeoman 597430 597430 Wade, John, of Osprenge, yeoman 2
5005872 2358618 2358618 defendant atte Sole Seamus yeoman 597430 597430 atte Sole, Seamus, of Osprenge, yeoman 0
5006217 2358710 2358710 defendant Dancastre William ostler 597430 597430 Dancastre, William, of Osprenge, ostler 0
5020429 2362860 2362860 defendant Bocher William husbandman 597430 597430 Bocher, William, of Osprenge, husbandman 1
5029541 2365509 2365509 defendant atte Sole Seman yeoman 597430 597430 atte Sole, Seman, of Osprenge, yeoman 0
5052277 2372287 2372287 defendant atte Sole Seman yeoman 597430 597430 atte Sole, Seman, of Osprenge, yeoman 2
5052278 2372287 2372287 defendant Adam Alexander yeoman 597430 597430 Adam, Alexander, of Osprenge, yeoman 3
5052279 2372287 2372287 defendant atte Sethe Stephen yeoman 597430 597430 atte Sethe, Stephen, of Osprenge, yeoman 4
5067331 2376737 2376737 defendant atte Sole Seman husbandman 597430 597430 atte Sole, Seman, of Osprenge, husbandman 0
5112565 2390056 2390056 defendant Bacheler John clerk 597430 597430 Bacheler, John, of Osprenge, clerk 0
5266384 2435235 2435235 defendant Dernale or Dervale John husbandman 597430 597430 Dernale or Dervale, John, of Osprenge, husbandman 4
5303271 2445975 2445975 defendant Beche Alice widow 597430 597430 Beche, Alice, of Osprenge, widow 0
5305655 2446698 2446698 defendant Betys Roger (legal representative) 597430 597430 Betys, Roger, of Osprenge, shoemaker, administratrix of 0
5305656 2446698 2446698 defendant Betys Alice widow 597430 597430 Betys, Alice, of Osprenge, widow 1
5335615 2455724 2455724 defendant Exbregge John innholder 597430 597430 Exbregge, John, of Osprenge, innholder 0
5335616 2455724 2455724 defendant Potyn William husbandman 597430 597430 Potyn, William, of Osprenge, husbandman 1
5335618 2455725 2455725 defendant Exbregge John innholder 597430 597430 Exbregge, John, of Osprenge, innholder 0
5341449 2457520 2457520 defendant Nicoll Thomas husbandman 597430 597430 Nicoll, Thomas, of Osprenge, husbandman 0
5359010 2462868 2462868 defendant Barkeford Thomas smith 597430 597430 Barkeford, Thomas, of Osprenge, smith 0
5482224 2499625 2499625 defendant Feysaunt John husbandman 597430 597430 Feysaunt, John, of Osprenge, husbandman 7
5490840 2502156 2502156 defendant Exbregge John innholder 597430 597430 Exbregge, John, of Osprenge, innholder 3
5505149 2506519 2506519 defendant Sterisasshe Thomas husbandman 597430 597430 Sterisasshe, Thomas, of Osprenge, husbandman 0
5536285 2515839 2515839 plaintiff Byngley Agnes   597430 597430 Byngley, Agnes, of Osprenge 0
5577668 2528084 2528084 defendant Clarke Thomas carpenter 597430 597430 Clarke, Thomas, of Osprenge, carpenter 0
5578510 2528349 2528349 defendant Cadman Peter husbandman 597430 597430 Cadman, Peter, of Osprenge, husbandman 0
5588528 2531417 2531417 defendant Morgan John yeoman 597430 597430 Morgan, John, of Osprenge, yeoman 2
5598409 2534385 2534385 defendant Randalfe John yeoman 597430 597430 Randalfe, John, of Osprenge, yeoman 0
5598411 2534386 2534386 defendant Randalfe John yeoman 597430 597430 Randalfe, John, of Osprenge, yeoman 0
5598413 2534387 2534387 defendant Randolfe John yeoman 597430 597430 Randolfe, John, of Osprenge, yeoman 0
5598415 2534388 2534388 defendant Randolfe John yeoman 597430 597430 Randolfe, John, of Osprenge, yeoman 0
5599346 2534679 2534679 defendant at Seth Peter husbandman 597430 597430 at Seth, Peter, of Osprenge, husbandman 0
5606774 2537004 2537004 defendant Howlet John husbandman 597430 597430 Howlet, John, of Osprenge, husbandman 0
5626846 2552371 2552371 plaintiff Napleton Peter   597430 597430 Napleton, Peter, of Osprenge 0
5626848 2552372 2552372 plaintiff Napleton Peter   597430 597430 Napleton, Peter, of Osprenge 0
5628796 2552973 2552973 defendant atte Lese Simon carpenter 597430 597430 atte Lese, Simon, of Osprenge, carpenter 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);