names

104 rows where place_id = 590513

✎ 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
3601429 1868106 1868106 defendant Jamys John smith 590513 590513 Jamys, John, of Honyngton, smith 2
3614893 1872312 1872312 defendant Semer John merchant 590513 590513 Semer, John, of Honyngton, merchant 0
3643647 1908441 1908441 defendant Hewys William husbandman 590513 590513 Hewys, William, of Honyngton, husbandman 0
3643648 1908441 1908441 defendant Trowbefeld John merchant 590513 590513 Trowbefeld, John, of Honyngton, merchant 1
3660712 1913615 1913615 defendant Gybson Robert   590513 590513 Gybson, Robert, of Honyngton, free mason 0
3662069 1914065 1914065 defendant Hardy Thomas husbandman 590513 590513 Hardy, Thomas, of Honyngton, husbandman 11
3662089 1914066 1914066 defendant Hardy Thomas husbandman 590513 590513 Hardy, Thomas, of Honyngton, husbandman 12
3673297 1917664 1917664 defendant Gybson Robert   590513 590513 Gybson, Robert, of Honyngton, freemason 0
3673298 1917664 1917664 defendant Sutton John husbandman 590513 590513 Sutton, John, of Honyngton, husbandman 1
3673302 1917665 1917665 defendant Gybson Robert   590513 590513 Gybson, Robert, of Honyngton, freemason 0
3673303 1917665 1917665 defendant Sutton John husbandman 590513 590513 Sutton, John, of Honyngton, husbandman 1
3686681 1921989 1921989 defendant Gybson Robert   590513 590513 Gybson, Robert, of Honyngton, freemason 0
3689215 1922793 1922793 defendant Gybson Robert   590513 590513 Gybson, Robert, of Honyngton, freemason 0
3689216 1922793 1922793 defendant Sutton John husbandman 590513 590513 Sutton, John, of Honyngton, husbandman 1
3713362 1930493 1930493 defendant Voyse Thomas husbandman 590513 590513 Voyse, Thomas, of Honyngton, husbandman 1
3743775 1939938 1939938 defendant Gybbes Robert yeoman 590513 590513 Gybbes, Robert, of Honyngton, yeoman 0
3743776 1939938 1939938 defendant Hamlen Robert laborer 590513 590513 Hamlen, Robert, of Honyngton, laborer 1
3743777 1939938 1939938 defendant Lucas Richard laborer 590513 590513 Lucas, Richard, of Honyngton, laborer 2
3743778 1939938 1939938 defendant Phelyppes Thomas laborer 590513 590513 Phelyppes, Thomas, of Honyngton, laborer 3
3743779 1939938 1939938 defendant Gybbes Thomas laborer 590513 590513 Gybbes, Thomas, of Honyngton, laborer 4
3748030 1941304 1941304 defendant Manfeld John husbandman 590513 590513 Manfeld, John, of Honyngton, husbandman 1
3787236 1953801 1953801 defendant Davy Thomas husbandman 590513 590513 Davy, Thomas, of Honyngton, husbandman 0
3812642 1961843 1961843 defendant Gybson Robert   590513 590513 Gybson, Robert, of Honyngton, freemason 0
3827994 1966621 1966621 defendant Villers Edward gent 590513 590513 Villers, Edward, of Honyngton, gent 0
3828459 1966774 1966774 defendant Symmes Richard innholder 590513 590513 Symmes, Richard, of Honyngton, innholder 2
3835344 1968992 1968992 defendant Syms Richard innholder 590513 590513 Syms, Richard, of Honyngton, innholder 0
3855202 1975259 1975259 defendant Bransby Richard draper 590513 590513 Bransby, Richard, of Honyngton, draper 0
3876594 1982418 1982418 defendant Kylbrygge Robert miller 590513 590513 Kylbrygge, Robert, of Honyngton, miller 0
3881839 1984179 1984179 plaintiff Smyth Thomas   590513 590513 Smyth, Thomas, of Honyngton 0
3881840 1984179 1984179 defendant Gybbes Robert husbandman 590513 590513 Gybbes, Robert, of Honyngton, husbandman 0
3922568 1997863 1997863 defendant Playford John, senior husbandman 590513 590513 Playford, John, senior, of Honyngton, husbandman 0
3978742 2017142 2017142 defendant Curteis Augustine gent 590513 590513 Curteis, Augustine, of Honyngton, gent 0
4029243 2035103 2035103 defendant Doo Richard, senior husbandman 590513 590513 Doo, Richard, senior, of Honyngton, husbandman 1
4029244 2035103 2035103 defendant Bryant John yeoman 590513 590513 together with Bryant, John, of Honyngton, yeoman 2
4029246 2035104 2035104 defendant (not given) Edmund rector of Nune or Nunne 590513 590513 Nune or Nunne, Edmund, of Honyngton, rector of Heggesett 0
4070510 2049745 2049745 plaintiff Mason alias Jones Hugh   590513 590513 Mason alias Jones, Hugh, of Honyngton, servant of Robert Gibb 0
4102600 2061229 2061229 defendant Doo Richard yeoman 590513 590513 Doo, Richard, of Honyngton, yeoman 0
4105911 2062406 2062406 defendant Doo Richard yeoman 590513 590513 Doo, Richard, of Honyngton, yeoman 0
4107985 2063129 2063129 defendant Bevington Nicholas yeoman 590513 590513 Bevington, Nicholas, of Honyngton, yeoman 0
4107987 2063130 2063130 defendant Bevington Nicholas yeoman 590513 590513 Bevington, Nicholas, of Honyngton, yeoman 0
4132555 2071960 2071960 defendant Jurdane Robert husbandman 590513 590513 Jurdane, Robert, of Honyngton, husbandman 0
4148902 2077735 2077735 defendant Smythe William gent 590513 590513 Smythe, William, of Honyngton, gent 7
4180489 2088657 2088657 defendant Jurdane Robert husbandman 590513 590513 Jurdane, Robert, of Honyngton, husbandman 0
4225164 2104271 2104271 defendant Cutteris Thomas yeoman 590513 590513 Cutteris, Thomas, of Honyngton, yeoman 0
4235381 2107943 2107943 defendant Howlett Robert yeoman 590513 590513 Howlett, Robert, of Honyngton, yeoman 0
4244025 2110984 2110984 defendant Howlett Robert yeoman 590513 590513 Howlett, Robert, of Honyngton, yeoman 0
4303217 2131251 2131251 defendant Cutteris Thomas yeoman 590513 590513 Cutteris, Thomas, of Honyngton, yeoman 0
4313007 2134672 2134672 defendant Axford Henry innholder 590513 590513 Axford, Henry, of Honyngton, yeoman, or of Salisbury, innholder 0
4353124 2148321 2148321 defendant Doe Richard yeoman 590513 590513 Doe, Richard, of Honyngton, yeoman 2
4357823 2149977 2149977 defendant Rowth Gabriel gent 590513 590513 Rowth, Gabriel, of Honyngton, gent 0
4473134 2192259 2192259 defendant Budell William   590513 590513 Budell, William, of Honyngton, formerly bailiff 0
4484480 2195836 2195836 defendant Arburn Thomas   590513 590513 Arburn Thomas, of Honyngton 1
4549264 2215707 2215707 defendant Bouley Philip   590513 590513 Bouley, Philip, of Honyngton 0
4592315 2228946 2228946 defendant Bromston John   590513 590513 Bromston, John, of Honyngton 0
4595694 2229913 2229913 defendant Joy Richard   590513 590513 Joy, Richard, of Honyngton 0
4665352 2250650 2250650 defendant Pratte John yeoman 590513 590513 Pratte, John, of Honyngton, yeoman 5
4668268 2255790 2255790 plaintiff Barton John   590513 590513 Barton, John, of Honyngton 0
4762399 2284224 2284224 defendant Trove John tanner 590513 590513 Trove, John, of Honyngton, tanner 0
4816083 2301122 2301122 defendant Martyn John gent 590513 590513 Martyn, John, of Honyngton, gent 0
4857327 2313676 2313676 defendant Bayly Walter husbandman 590513 590513 Bayly, Walter, of Honyngton, husbandman 0
4868728 2317187 2317187 defendant Davy John husbandman 590513 590513 Davy, John, of Honyngton, husbandman 1
4868741 2317193 2317193 defendant Davy John husbandman 590513 590513 Davy, John, of Honyngton, husbandman 1
4889354 2323463 2323463 defendant Bretyn John tucker 590513 590513 Bretyn, John, of Honyngton, tucker 0
4889355 2323463 2323463 defendant Herward John cordwainer 590513 590513 Herward, John, of Honyngton, cordwainer 1
4889356 2323463 2323463 defendant Gaskyn Thomas   590513 590513 Gaskyn, Thomas, of Honyngton, "cornehokker" 2
4889357 2323463 2323463 defendant Proute or Pronte John husbandman 590513 590513 Proute or Pronte, John, of Honyngton, husbandman 3
4902900 2327522 2327522 defendant Grigge Robert butcher 590513 590513 Grigge, Robert, of Honyngton, butcher 0
4935406 2337469 2337469 defendant Skate Thomas laborer 590513 590513 Skate, Thomas, of Honyngton, laborer 0
4939686 2338797 2338797 defendant Bele John husbandman 590513 590513 Bele, John, of Honyngton, husbandman 0
4971732 2348471 2348471 defendant Gybbe Richard butcher 590513 590513 Gybbe, Richard, of Honyngton, butcher 1
4992010 2354498 2354498 plaintiff Cowelygh John   590513 590513 Cowelygh, John, of Honyngton 0
5025885 2364467 2364467 defendant Quarier John husbandman 590513 590513 Quarier, John, of Honyngton, husbandman 1
5034662 2366996 2366996 defendant Smyth John smith 590513 590513 Smyth, John, of Honyngton, smith 0
5034663 2366996 2366996 defendant Quyntyn John husbandman 590513 590513 Quyntyn, John, of Honyngton, husbandman 1
5034664 2366996 2366996 defendant Symson John laborer 590513 590513 Symson, John, of Honyngton, laborer 2
5089683 2383356 2383356 defendant Daylisford Peter husbandman 590513 590513 Daylisford, Peter, of Honyngton, husbandman 0
5221395 2421958 2421958 defendant Carpenter John weaver 590513 590513 Carpenter, John, of Honyngton, weaver 2
5247085 2429305 2429305 defendant atte Tounende Robert husbandman 590513 590513 atte Tounende, Robert, of Honyngton, husbandman 0
5266479 2435264 2435264 defendant Crosse William tucker 590513 590513 Crosse, William, of Honyngton, tucker 1
5285189 2440690 2440690 defendant Halle John husbandman 590513 590513 Halle, John, of Honyngton, husbandman 0
5290295 2442166 2442166 defendant Hunt John yeoman 590513 590513 Hunt, John, of Honyngton, yeoman 0
5337920 2456425 2456425 defendant Godde William husbandman 590513 590513 Godde, William, of Honyngton, husbandman 2
5348689 2459720 2459720 defendant Qwyntyn John husbandman 590513 590513 Qwyntyn, John, of Honyngton, husbandman 1
5348690 2459720 2459720 defendant Graunt John husbandman 590513 590513 Graunt, John, of Honyngton, husbandman 2
5348693 2459721 2459721 defendant Quyntyn John husbandman 590513 590513 Quyntyn, John, of Honyngton, husbandman 1
5348694 2459721 2459721 defendant Graunt John husbandman 590513 590513 Graunt, John, of Honyngton, husbandman 2
5363620 2464278 2464278 defendant Soper Nicholas husbandman 590513 590513 Soper, Nicholas, of Honyngton, husbandman 0
5363621 2464278 2464278 defendant Flete Thomas husbandman 590513 590513 Flete, Thomas, of Honyngton, husbandman 1
5395532 2473803 2473803 defendant God William merchant 590513 590513 God, William, of Honyngton, merchant 0
5402378 2475755 2475755 defendant Quyntyn John husbandman 590513 590513 Quyntyn, John, of Honyngton, husbandman 1
5408796 2477591 2477591 defendant God William merchant 590513 590513 God, William, of Honyngton, merchant 0
5415322 2479520 2479520 defendant Guym John husbandman 590513 590513 Guym, John, of Honyngton, husbandman 2
5422165 2481576 2481576 defendant God William merchant 590513 590513 God, William, of Honyngton, merchant 0
5431489 2484375 2484375 defendant (illegible) John husbandman 590513 590513 _, John, of Honyngton, husbandman 2
5447931 2489265 2489265 defendant Quyntyn John husbandman 590513 590513 Quyntyn, John, of Honyngton, husbandman 1
5461226 2493305 2493305 defendant Graunte John husbandman 590513 590513 Graunte, John, of Honyngton, husbandman 1
5484363 2500243 2500243 defendant Graunte John husbandman 590513 590513 Graunte, John, of Honyngton, husbandman 1
5511254 2508362 2508362 defendant Benet John husbandman 590513 590513 Benet, John, of Honyngton, husbandman 2
5528741 2513508 2513508 defendant Nekke William yeoman 590513 590513 Nekke, William, of Honyngton, yeoman 2
5552222 2520694 2520694 defendant Neell Richard husbandman 590513 590513 Neell, Richard, of Honyngton, husbandman 4

Next page

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