names

68 rows where place_id = 589581

✎ 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
3598052 1867014 1867014 defendant Sheppherde William husbandman 589581 589581 Sheppherde, William, of Ryngmere, husbandman 4
3625499 1875515 1875515 defendant West John yeoman 589581 589581 West, John, of Ryngmere, yeoman 0
3642557 1908115 1908115 defendant Aptot Thomas husbandman 589581 589581 Aptot, Thomas, of Ryngmere, husbandman 0
3642558 1908115 1908115 defendant Shypherd Thomas laborer 589581 589581 Shypherd, Thomas, of Ryngmere, laborer 1
3642559 1908115 1908115 defendant Butler Richard yeoman 589581 589581 Butler, Richard, of Ryngmere, yeoman 2
3668484 1916097 1916097 plaintiff Austen John   589581 589581 Austen, John, of Ryngmere 0
3675301 1918316 1918316 defendant Terry John yeoman 589581 589581 Terry, John, of Ryngmere, yeoman 0
3679374 1919612 1919612 defendant Rede John yeoman 589581 589581 Rede, John, of Ryngmere, yeoman 1
3679375 1919612 1919612 defendant FitzHerber Nicholas yeoman 589581 589581 FitzHerber, Nicholas, of Ryngmere, yeoman 2
3679378 1919613 1919613 defendant Rede John yeoman 589581 589581 Rede, John, of Ryngmere, yeoman 1
3679379 1919613 1919613 defendant FitzHerber Nicholas yeoman 589581 589581 FitzHerber, Nicholas, of Ryngmere, yeoman 2
3698610 1925779 1925779 defendant Sharpe Martin yeoman 589581 589581 Sharpe, Martin, of Ryngmere, yeoman 6
3698611 1925779 1925779 defendant Rooper Robert husbandman 589581 589581 Rooper, Robert, of Ryngmere, husbandman 7
3727387 1934839 1934839 defendant Lydyng John yeoman 589581 589581 Lydyng, John, of Ryngmere, yeoman 0
3733629 1936759 1936759 defendant Musterden Thomas yeoman 589581 589581 Musterden, Thomas, of Ryngmere, yeoman 2
3778642 1951031 1951031 defendant Levyng John yeoman 589581 589581 Levyng, John, of Ryngmere, yeoman 0
3778643 1951031 1951031 defendant Levyng Nicholas yeoman 589581 589581 Levyng, Nicholas, of Ryngmere, yeoman 1
3791799 1955280 1955280 defendant Thaccher Thomas gent 589581 589581 Thaccher, Thomas, of Ryngmere, gent 0
3803958 1959153 1959153 defendant Levyng Nicholas husbandman 589581 589581 Levyng, Nicholas, of Ryngmere, husbandman 0
3806535 1959958 1959958 defendant Fytzherbert Henry yeoman 589581 589581 Fytzherbert, Henry, of Ryngmere, yeoman 1
3806537 1959958 1959958 defendant Webbe John yeoman 589581 589581 Webbe, John, of Ryngmere, yeoman 3
3808321 1960476 1960476 defendant Thatcher Thomas gent 589581 589581 Thatcher, Thomas, of Ryngmere, gent 0
3816638 1963105 1963105 defendant Okyngton William husbandman 589581 589581 Okyngton, William, of Ryngmere, husbandman 1
3943074 2004696 2004696 defendant Burgdys Henry husbandman 589581 589581 Burgdys, Henry, of Ryngmere, husbandman 1
3946086 2005707 2005707 plaintiff Bucke John (legal representative) 589581 589581 Bucke, John, of Ryngmere, yeoman, executors of 0
4501097 2200948 2200948 plaintiff Langton John   589581 589581 Langton, John, of Ryngmere, vicar 0
4503815 2201757 2201757 defendant atte Rede Simon   589581 589581 atte Rede, Simon, of Ryngmere 0
4503824 2201758 2201758 defendant Smyth Nicholas   589581 589581 Smyth, Nicholas, of Ryngmere 0
4503825 2201758 2201758 defendant (illegible) Thomas   589581 589581 ---, Thomas, of Ryngmere 1
4503826 2201758 2201758 defendant atte Hothe Geoffrey   589581 589581 atte Hothe, Geoffrey, of Ryngmere 2
4503827 2201758 2201758 defendant Cotexoxe Thomas   589581 589581 Cotexoxe, Thomas, of Ryngmere 3
4503828 2201758 2201758 defendant Cotoxoxe Denis   589581 589581 Cotoxoxe, Denis, of Ryngmere 4
4587142 2227382 2227382 defendant Helyer John   589581 589581 Helyer, John, of Ryngmere 3
4605626 2232879 2232879 defendant Cartere John   589581 589581 Cartere, John, of Ryngmere 1
4651841 2246514 2246514 defendant Frensshe Robert husbandman 589581 589581 Frensshe, Robert, of Ryngmere, husbandman 1
4678851 2258986 2258986 defendant Peltebeme John husbandman 589581 589581 with Peltebeme, John, of Ryngmere, husbandman 3
4678940 2259017 2259017 defendant atte Rede Simon   589581 589581 atte Rede, Simon, of Ryngmere, mustard maker 0
4722612 2272388 2272388 defendant Delve John gent 589581 589581 Delve, John, of Ryngmere, gent 0
4743487 2278624 2278624 defendant Kelly John esq 589581 589581 Kelly, John, of Ryngmere, esq 2
4786427 2291800 2291800 defendant Hycche John clerk 589581 589581 Hycche, John, of Ryngmere, clerk 0
4812479 2300016 2300016 defendant Deneman John smith 589581 589581 Deneman, John, of Ryngmere, smith 1
4826988 2304482 2304482 defendant Cony or Covy Thomas husbandman 589581 589581 Cony or Covy, Thomas, of Ryngmere, husbandman 0
4894443 2324937 2324937 defendant Mallyng William husbandman 589581 589581 Mallyng, William, of Ryngmere, husbandman 3
4895240 2325171 2325171 defendant Deneman Simon potter 589581 589581 Deneman, Simon, of Ryngmere, potter 0
4998729 2356507 2356507 defendant Daly Thomas   589581 589581 Daly, Thomas, of Ryngmere, holy water clerk 3
5003706 2357977 2357977 defendant Bust Thomas husbandman 589581 589581 Bust, Thomas, of Ryngmere, husbandman 0
5082168 2381162 2381162 defendant Uphous John laborer 589581 589581 Uphous, John, of Ryngmere, laborer 0
5187780 2412146 2412146 defendant Passemere Robert clerk 589581 589581 Passemere, Robert, of Ryngmere, clerk 0
5205716 2417416 2417416 defendant Passemere Robert clerk 589581 589581 Passemere, Robert, of Ryngmere, clerk 0
5219997 2421559 2421559 defendant Lucas Andrew laborer 589581 589581 Lucas, Andrew, of Ryngmere, laborer 0
5231530 2424805 2424805 defendant Delve Thomas   589581 589581 Delve, Thomas, of Ryngmere 0
5231531 2424805 2424805 defendant Poterne John   589581 589581 Poterne, John, of Ryngmere 1
5271144 2436655 2436655 defendant Goodyer John husbandman 589581 589581 Goodyer, John, of Ryngmere, husbandman 0
5277842 2438604 2438604 defendant Seger Richard smith 589581 589581 Seger, Richard, of Ryngmere, smith 1
5319414 2450899 2450899 defendant Delve Thomas yeoman 589581 589581 Delve, Thomas, of Ryngmere, yeoman 0
5319415 2450899 2450899 defendant Aptot William drover 589581 589581 Aptot, William, of Ryngmere, drover 1
5326986 2453148 2453148 defendant Aptot William drover 589581 589581 Aptot, William, of Ryngmere, drover 0
5326993 2453151 2453151 defendant Aptot William drover 589581 589581 Aptot, William, of Ryngmere, drover 0
5334163 2455285 2455285 defendant Goodyer Andrew husbandman 589581 589581 Goodyer, Andrew, of Ryngmere, husbandman 2
5334165 2455286 2455286 defendant Goodyer Andrew husbandman 589581 589581 Goodyer, Andrew, of Ryngmere, husbandman 0
5341416 2457510 2457510 defendant Puppe John, senior husbandman 589581 589581 Puppe, John, senior, of Ryngmere, husbandman 0
5341417 2457510 2457510 defendant Puppe Peter laborer 589581 589581 Puppe, Peter, of Ryngmere, laborer 1
5341418 2457510 2457510 defendant Carpenter John laborer 589581 589581 Carpenter, John, of Ryngmere, laborer 2
5341419 2457510 2457510 defendant Testard Richard laborer 589581 589581 Testard, Richard, of Ryngmere, laborer 3
5341420 2457510 2457510 defendant Cower John laborer 589581 589581 Cower, John, of Ryngmere, laborer 4
5341421 2457510 2457510 defendant Austyn John laborer 589581 589581 Austyn, John, of Ryngmere, laborer 5
5426825 2482966 2482966 defendant Fermor John, sen yeoman 589581 589581 Fermor, John, sen, of Ryngmere, yeoman 1
5507115 2507134 2507134 defendant Curde Mathew husbandman 589581 589581 Curde, Mathew, of Ryngmere, husbandman 1

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