names

86 rows where place_id = 588824

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595713 1866288 1866288 defendant West John yeoman 588824 588824 West, John, of Ryngmer, yeoman 0
3686754 1922011 1922011 defendant Walker Richard butcher 588824 588824 Walker, Richard, of Ryngmer, butcher 0
3756064 1943852 1943852 defendant Thatcher Thomas gent 588824 588824 Thatcher, Thomas, of Ryngmer, gent 0
3806534 1959958 1959958 defendant Thetcher Thomas gent 588824 588824 Thetcher, Thomas, of Ryngmer, gent 0
3914214 1995099 1995099 defendant Pupp John husbandman 588824 588824 Pupp, John, of Ryngmer, husbandman 2
3914448 1995176 1995176 defendant Dunton John husbandman 588824 588824 Dunton, John, of Ryngmer, husbandman 0
3914449 1995176 1995176 defendant Pupe John husbandman 588824 588824 Pupe, John, of Ryngmer, husbandman 1
4009070 2028010 2028010 defendant Fuller Roger smith 588824 588824 Fuller, Roger, of Ryngmer, smith 0
4032007 2036115 2036115 defendant Carpenter William yeoman 588824 588824 Carpenter, William, of Ryngmer, yeoman 2
4037832 2038183 2038183 defendant Rede Richard yeoman 588824 588824 Rede, Richard, of Ryngmer, yeoman 0
4053708 2043704 2043704 defendant Bengeman Thomas husbandman 588824 588824 Bengeman, Thomas, of Ryngmer, husbandman 0
4053709 2043704 2043704 defendant Weston Simon sawyer 588824 588824 Weston, Simon, of Ryngmer, sawyer 1
4053973 2043799 2043799 defendant Fuller Roger smith 588824 588824 Fuller, Roger, of Ryngmer, smith 0
4053974 2043799 2043799 defendant Corneforde John yeoman 588824 588824 Corneforde, John, of Ryngmer, yeoman 1
4062203 2046770 2046770 defendant Rede Richard yeoman 588824 588824 Rede, Richard, of Ryngmer, yeoman 0
4078676 2052669 2052669 defendant Corneford John yeoman 588824 588824 Corneford, John, of Ryngmer, yeoman 0
4092605 2057663 2057663 defendant Wyncketon John carpenter 588824 588824 Wyncketon, John, of Ryngmer, carpenter 1
4107048 2062817 2062817 defendant Chauntler Edward yeoman 588824 588824 Chauntler, Edward, of Ryngmer, yeoman 0
4119814 2067375 2067375 defendant Sharpe John husbandman 588824 588824 Sharpe, John, of Ryngmer, husbandman 2
4121823 2068104 2068104 defendant Wynckton John carpenter 588824 588824 Wynckton, John, of Ryngmer, carpenter 2
4128973 2070662 2070662 defendant Page John, junior Ryngmer 588824 588824 Page, John, junior, of Ryngmer, yeoman, son of John Page, of Wellyngham, Ryngmer 0
4128975 2070663 2070663 defendant Page John, senior yeoman 588824 588824 Page, John, senior, of Ryngmer, or of Wellingham, yeoman 0
4132102 2071792 2071792 defendant Page John yeoman 588824 588824 Page, John, of Ryngmer, or of Wellington, yeoman 0
4138387 2074095 2074095 defendant Austen Robert, junior yeoman 588824 588824 Austen, Robert, junior, of Ryngmer, yeoman 1
4138818 2074256 2074256 defendant Levyng John yeoman 588824 588824 Levyng, John, of Ryngmer, yeoman 0
4154838 2079786 2079786 defendant Austen Robert, senior yeoman 588824 588824 Austen, Robert, senior, of Ryngmer, yeoman 0
4167776 2084219 2084219 defendant Edward Thomas yeoman 588824 588824 Edward, Thomas, of Ryngmer, yeoman 0
4170097 2085035 2085035 defendant Martyn Robert husbandman 588824 588824 Martyn, Robert, of Ryngmer, husbandman 0
4170099 2085035 2085035 defendant Copernett Thomas husbandman 588824 588824 Copernett, Thomas, of Ryngmer, husbandman 2
4171579 2085526 2085526 defendant Carpenter William yeoman 588824 588824 Carpenter, William, of Ryngmer, yeoman 1
4171582 2085527 2085527 defendant Carpenter William yeoman 588824 588824 Carpenter, William, of Ryngmer, yeoman 1
4174586 2086582 2086582 defendant Edward Thomas husbandman 588824 588824 Edward, Thomas, of Ryngmer, husbandman 1
4179462 2088293 2088293 defendant Carpenter William yeoman 588824 588824 Carpenter, William, of Ryngmer, yeoman 0
4182109 2089220 2089220 defendant Testor Gilbert yeoman 588824 588824 (Testor, Gilbert, of Ryngmer, yeoman 1
4186145 2090642 2090642 defendant Fludd John tailor 588824 588824 Fludd, John, of Ryngmer, tailor 2
4186172 2090648 2090648 defendant Paye Nicholas yeoman 588824 588824 Paye, Nicholas, of Ryngmer, yeoman 2
4186177 2090649 2090649 defendant Coppernatt Edward yeoman 588824 588824 Coppernatt, Edward, of Ryngmer, yeoman 2
4189670 2091884 2091884 defendant Chele Richard husbandman 588824 588824 Chele, Richard, of Ryngmer, husbandman 0
4221105 2102876 2102876 defendant Salter Roger yeoman 588824 588824 Salter, Roger, of Ryngmer, yeoman 0
4229328 2105738 2105738 defendant Page Thomas yeoman 588824 588824 Page, Thomas, of Ryngmer, yeoman 1
4230721 2106242 2106242 defendant Blackman Samuel tailor 588824 588824 Blackman, Samuel, of Ryngmer, tailor 0
4230723 2106243 2106243 defendant Ca--ll Thomas husbandman 588824 588824 Ca--ll, Thomas, of Ryngmer, husbandman 0
4230826 2106279 2106279 defendant Salter Roger yeoman 588824 588824 Salter, Roger, of Ryngmer, yeoman 0
4237383 2108666 2108666 defendant Adams Simon yeoman 588824 588824 Adams, Simon, of Ryngmer, yeoman 0
4260182 2116369 2116369 defendant Salter Roger yeoman 588824 588824 Salter, Roger, of Ryngmer, yeoman 0
4298105 2129427 2129427 defendant Salter Roger yeoman 588824 588824 Salter, Roger, of Ryngmer, yeoman 0
4313593 2134860 2134860 defendant Harte John husbandman 588824 588824 Harte, John, of Ryngmer, husbandman 1
4315676 2135594 2135594 defendant Harte John yeoman 588824 588824 Harte, John, of Ryngmer, yeoman 1
4318270 2136498 2136498 defendant Harte John yeoman 588824 588824 Harte, John, of Ryngmer, yeoman 1
4319877 2137058 2137058 defendant Tull John yeoman 588824 588824 Tull, John, of Ryngmer, yeoman 1
4367323 2153369 2153369 defendant Harte John yeoman 588824 588824 Harte, John, of Ryngmer, yeoman 0
4367324 2153369 2153369 defendant Woodden Stephen tailor 588824 588824 Woodden, Stephen, of Ryngmer, tailor 1
4370343 2154446 2154446 defendant Page Nicholas yeoman 588824 588824 Page, Nicholas, of Ryngmer, yeoman 1
4370843 2154626 2154626 defendant Gavell Thomas husbandman 588824 588824 Gavell, Thomas, of Ryngmer, husbandman 1
4372033 2155061 2155061 defendant Salter Roger yeoman 588824 588824 Salter, Roger, of Ryngmer, yeoman 0
4375578 2156322 2156322 defendant Towner Edward yeoman 588824 588824 Towner, Edward, of Ryngmer, yeoman 0
4378265 2157292 2157292 defendant Pupp Thomas husbandman 588824 588824 Pupp, Thomas, of Ryngmer, or of Wellingham, husbandman 0
4378694 2157452 2157452 defendant Tester John yeoman 588824 588824 Tester, John, of Ryngmer, yeoman 0
4383930 2159329 2159329 defendant Langworth Arthur esq 588824 588824 Langworth, Arthur, of Ryngmer, esq 0
4395517 2163083 2163083 defendant Salter Roger yeoman 588824 588824 Salter, Roger, of Ryngmer, yeoman 0
4398829 2164189 2164189 defendant Frye Nicholas yeoman 588824 588824 Frye, Nicholas, of Ryngmer, yeoman 0
4678938 2259016 2259016 defendant atte Rede Simon   588824 588824 atte Rede, Simon, of Ryngmer, mustard maker 0
4743485 2278624 2278624 defendant Kelly Joan   588824 588824 Kelly, Joan, of Ryngmer, widow, formerly wife of Mathew Kelly 0
4842436 2309170 2309170 defendant Delve William yeoman 588824 588824 Delve, William, of Ryngmer, yeoman 0
4960425 2345082 2345082 defendant Daby or Davy Thomas   588824 588824 Daby or Davy, Thomas, of Ryngmer, parish clerk 0
5001910 2357458 2357458 defendant Burgh Robert husbandman 588824 588824 Burgh, Robert, of Ryngmer, husbandman 0
5004407 2358185 2358185 defendant Levyng John husbandman 588824 588824 Levyng, John, of Ryngmer, husbandman 0
5088364 2382970 2382970 defendant Levyng John husbandman 588824 588824 Levyng, John, of Ryngmer, husbandman 4
5137775 2397559 2397559 defendant Godyer John smith 588824 588824 Godyer, John, of Ryngmer, smith 3
5157988 2403460 2403460 defendant Todyer John smith 588824 588824 Todyer, John, of Ryngmer, smith 3
5185623 2411547 2411547 defendant Goodyar John husbandman 588824 588824 Goodyar, John, of Ryngmer, husbandman 1
5214424 2419951 2419951 defendant Deccher Andrew yeoman 588824 588824 Deccher, Andrew, of Ryngmer, yeoman 0
5214425 2419951 2419951 defendant Aptot Nicholas yeoman 588824 588824 Aptot, Nicholas, of Ryngmer, yeoman 1
5245170 2428747 2428747 defendant Carpenter John laborer 588824 588824 Carpenter, John, of Ryngmer, laborer 2
5272830 2437128 2437128 defendant Cormyle John potter 588824 588824 Cormyle, John, of Ryngmer, potter 0
5336696 2456044 2456044 defendant Fermour John yeoman 588824 588824 Fermour, John, of Ryngmer, yeoman 1
5354450 2461462 2461462 defendant Goodyer Andrew yeoman 588824 588824 Goodyer, Andrew, of Ryngmer, yeoman 0
5354451 2461462 2461462 defendant Goodyer Thomas, junior husbandman 588824 588824 Goodyer, Thomas, junior, of Ryngmer, husbandman 1
5354452 2461462 2461462 defendant Puppe John, junior sawyer 588824 588824 Puppe, John, junior, of Ryngmer, sawyer 2
5392772 2473001 2473001 defendant Dalne Thomas yeoman 588824 588824 Dalne, Thomas, of Ryngmer, yeoman 1
5405871 2476752 2476752 defendant Delne or Delve Thomas yeoman 588824 588824 Delne or Delve, Thomas, of Ryngmer, yeoman 1
5418908 2480578 2480578 defendant Delve Thomas yeoman 588824 588824 Delve, Thomas, of Ryngmer, yeoman 0
5561850 2523454 2523454 defendant Puppe Peter yeoman 588824 588824 Puppe, Peter, of Ryngmer, yeoman 0
5579552 2528683 2528683 defendant Fermor William yeoman 588824 588824 Fermor, William, of Ryngmer, yeoman 1
5601991 2535520 2535520 defendant Boxe John husbandman 588824 588824 Boxe, John, of Ryngmer, husbandman 0
5601992 2535520 2535520 defendant Shepard Thomas laborer 588824 588824 Shepard, Thomas, of Ryngmer, laborer 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);