names

156 rows where place_id = 586306

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588395 1864019 1864019 defendant Dey Henry husbandman 586306 586306 Dey, Henry, of Ixworth, husbandman 2
3599005 1867323 1867323 defendant Lopham John gent 586306 586306 Lopham, John, of Ixworth, gent 0
3599006 1867323 1867323 defendant Lopham Thomas yeoman 586306 586306 Lopham, Thomas, of Ixworth, yeoman 1
3600522 1867810 1867810 defendant Brame or Braine Thomas mercer 586306 586306 Brame or Braine, Thomas, of Ixworth, mercer 3
3613814 1871978 1871978 plaintiff Berwham Geoffrey yeoman 586306 586306 Berwham, Geoffrey, of Ixworth, yeoman 0
3613815 1871978 1871978 defendant Dey Henry husbandman 586306 586306 Dey, Henry, of Ixworth, husbandman 0
3613817 1871978 1871978 defendant Dalton John, senior pedder 586306 586306 Dalton, John, senior, of Ixworth, pedder 2
3623615 1874919 1874919 defendant Bettys Henry shoemaker 586306 586306 Bettys, Henry, of Ixworth, shoemaker 0
3627605 1903494 1903494 defendant Balle Elizabeth spinster 586306 586306 Balle, Elizabeth, of Ixworth, spinster 0
3627606 1903494 1903494 defendant Ewyn William   586306 586306 Ewyn, William, of Ixworth, surgeon 1
3629994 1904233 1904233 defendant Ocley Henry (legal representative) 586306 586306 Ocley, Henry, of Ixworth, yeoman, administratrix of 0
3629995 1904233 1904233 defendant Ocley John widow 586306 586306 Ocley, John, of Ixworth, widow 1
3648793 1910013 1910013 defendant Benet William husbandman 586306 586306 Benet, William, of Ixworth, husbandman 0
3656195 1912185 1912185 defendant Lopham Thomas gent 586306 586306 Lopham, Thomas, of Ixworth, gent 0
3707068 1928499 1928499 defendant Russhebroke John clothmaker 586306 586306 Russhebroke, John, of Ixworth, clothmaker 0
3709821 1929387 1929387 defendant Russhbroke John dyer 586306 586306 Russhbroke, John, of Ixworth, dyer 3
3709827 1929388 1929388 defendant Russhbroke John dyer 586306 586306 Russhbroke, John, of Ixworth, dyer 3
3710361 1929559 1929559 defendant Heynon Robert husbandman 586306 586306 Heynon, Robert, of Ixworth, husbandman 3
3725073 1934128 1934128 defendant Heynon Robert husbandman 586306 586306 Heynon, Robert, of Ixworth, husbandman 2
3730587 1935802 1935802 defendant Reysebroke John dyer 586306 586306 Reysebroke, John, of Ixworth, dyer 1
3755492 1943672 1943672 plaintiff Woode John   586306 586306 Woode, John, of Ixworth 0
3755493 1943672 1943672 plaintiff Amys John   586306 586306 Amys, John, of Ixworth 1
3759058 1944818 1944818 defendant Horne John, senior husbandman 586306 586306 Horne, John, senior, of Ixworth, husbandman 1
3759102 1944833 1944833 defendant Banok Edmund   586306 586306 Banok, Edmund, of Ixworth, rough mason 0
3762281 1945848 1945848 defendant Maund Thomas carpenter 586306 586306 Maund, Thomas, of Ixworth, carpenter 0
3767673 1947526 1947526 defendant Bannok Edmund bricklayer 586306 586306 Bannok, Edmund, of Ixworth, bricklayer 4
3770213 1948351 1948351 defendant Man Nicholas tailor 586306 586306 Man, Nicholas, of Ixworth, tailor 0
3770215 1948351 1948351 defendant Blome Robert miller 586306 586306 Blome, Robert, of Ixworth, miller 2
3773860 1949536 1949536 defendant Howchyn Agnes widow 586306 586306 Howchyn, Agnes, of Ixworth, widow 0
3773861 1949536 1949536 defendant Lopham Margaret widow 586306 586306 Lopham, Margaret, of Ixworth, widow 1
3775728 1950158 1950158 defendant Amy Nicholas tailor 586306 586306 Amy, Nicholas, of Ixworth, tailor 0
3775729 1950158 1950158 defendant Amy john tailor 586306 586306 Amy, john, of Ixworth, tailor 1
3779388 1951275 1951275 defendant Laurence alias Smyth William smith 586306 586306 Laurence alias Smyth, William, of Ixworth, smith 1
3780549 1951647 1951647 defendant West Richard butcher 586306 586306 West, Richard, of Ixworth, butcher 0
3822173 1964832 1964832 defendant Bullock John carpenter 586306 586306 Bullock, John, of Ixworth, carpenter 3
3886911 1985883 1985883 plaintiff Cheston Robert tanner 586306 586306 Cheston, Robert, of Ixworth, tanner 0
3916499 1995895 1995895 defendant Nelsyng William yeoman 586306 586306 Nelsyng, William, of Ixworth, yeoman 1
3950778 2007344 2007344 plaintiff Gillye Martin pedder 586306 586306 Gillye, Martin, of Ixworth, pedder 0
3956889 2009480 2009480 plaintiff Parker John yeoman 586306 586306 Parker, John, of Ixworth, yeoman 0
3962326 2011406 2011406 defendant Turnor Avice widow 586306 586306 Turnor, Avice, of Ixworth, widow 1
4015840 2030351 2030351 plaintiff Sowter George (legal representative) 586306 586306 Sowter, George, of Ixworth, yeoman, executrix of 0
4019597 2031735 2031735 plaintiff Webbe Richard yeoman 586306 586306 Webbe, Richard, of Ixworth, yeoman 0
4019599 2031736 2031736 plaintiff Webbe Richard yeoman 586306 586306 Webbe, Richard, of Ixworth, yeoman 0
4019601 2031737 2031737 plaintiff Webbe Richard yeoman 586306 586306 Webbe, Richard, of Ixworth, yeoman 0
4102605 2061231 2061231 defendant Raker John butcher 586306 586306 Raker, John, of Ixworth, butcher 0
4128405 2070451 2070451 defendant Higham Edmund gent 586306 586306 Higham, Edmund, of Ixworth, gent 0
4160904 2081886 2081886 defendant Raker or Baker John butcher 586306 586306 Raker or Baker, John, of Ixworth, butcher 0
4208879 2098652 2098652 defendant Ussher William miller 586306 586306 Ussher, William, of Ixworth, miller 0
4247003 2111973 2111973 defendant Galle Edmund tailor 586306 586306 Galle, Edmund, of Ixworth, tailor 0
4247004 2111973 2111973 defendant Doe Robert innholder 586306 586306 Doe, Robert, of Ixworth, innholder 1
4247566 2112171 2112171 defendant Sowter Thomas husbandman 586306 586306 Sowter, Thomas, of Ixworth, husbandman 8
4262361 2117081 2117081 defendant Sawyer John maltster 586306 586306 Sawyer, John, of Ixworth, maltster 1
4304179 2131594 2131594 defendant Parker William yeoman 586306 586306 Parker, William, of Ixworth, yeoman 0
4333627 2141529 2141529 defendant Lucas John joiner 586306 586306 Lucas, John, of Ixworth, joiner 0
4333628 2141529 2141529 defendant Warren George yeoman 586306 586306 Warren, George, of Ixworth, yeoman 1
4340192 2143831 2143831 defendant Ullett or Ullyett Robert innholder 586306 586306 Ullett or Ullyett, Robert, of Ixworth, yeoman, or of Bury St Edmunds, innholder 0
4344159 2145237 2145237 defendant Gyllye Robert yeoman 586306 586306 Gyllye, Robert, of Ixworth, yeoman 0
4394084 2162623 2162623 defendant Dale Philip butcher 586306 586306 Dale, Philip, of Ixworth, butcher 1
4399893 2164553 2164553 defendant Watson John yeoman 586306 586306 Watson, John, of Ixworth, yeoman 1
4409729 2167855 2167855 defendant Page Andrew clothier 586306 586306 Page, Andrew, of Ixworth, clothier 0
4409730 2167855 2167855 defendant Warren George baker 586306 586306 Warren, George, of Ixworth, baker 1
4419497 2170984 2170984 defendant Gardener William   586306 586306 Gardener, William, of Ixworth 0
4440713 2182008 2182008 defendant Aspelond George de   586306 586306 Aspelond, George de, of Ixworth 1
4446920 2183953 2183953 defendant atte Chyrche William   586306 586306 atte Chyrche, William, of Ixworth 0
4563926 2220289 2220289 defendant Austyn Thomas   586306 586306 Austyn, Thomas, of Ixworth 0
4579052 2224927 2224927 defendant Austyn Thomas   586306 586306 Austyn, Thomas, of Ixworth 2
4579445 2225048 2225048 defendant Austyn Thomas   586306 586306 Austyn, Thomas, of Ixworth 2
4581281 2225613 2225613 defendant Umfrey Walter   586306 586306 Umfrey, Walter, of Ixworth 1
4581282 2225613 2225613 defendant Barbour Robert   586306 586306 Barbour, Robert, of Ixworth 2
4581283 2225613 2225613 defendant Quarre John   586306 586306 Quarre, John, of Ixworth 3
4581284 2225613 2225613 defendant Ketell John   586306 586306 Ketell, John, of Ixworth 4
4581285 2225613 2225613 defendant Benet John   586306 586306 Benet, John, of Ixworth 5
4622881 2238137 2238137 defendant Bocher Peter   586306 586306 Bocher, Peter, of Ixworth 2
4640445 2243317 2243317 defendant Fraas John   586306 586306 Fraas, John, of Ixworth 0
4670742 2256527 2256527 defendant Kichene Robert of the yeoman 586306 586306 Kichene, Robert of the, of Ixworth, yeoman 0
4676596 2258298 2258298 defendant Kechon Robert of the yeoman 586306 586306 Kechon, Robert of the, of Ixworth, yeoman 0
4762103 2284129 2284129 defendant del Kechen Robert husbandman 586306 586306 del Kechen, Robert, of Ixworth, husbandman 12
4836127 2307280 2307280 plaintiff Edward William chaplain 586306 586306 Edward, William, of Ixworth, chaplain 0
4836128 2307280 2307280 plaintiff Howard John baker 586306 586306 Howard, John, of Ixworth, baker 1
4836130 2307280 2307280 defendant Manfeld Geoffrey chandler 586306 586306 Manfeld, Geoffrey, of Ixworth, chandler 0
4847463 2310707 2310707 defendant Welle Simon husbandman 586306 586306 Welle, Simon, of Ixworth, husbandman 0
4847465 2310707 2310707 defendant Garlyngge Robert husbandman 586306 586306 Garlyngge, Robert, of Ixworth, husbandman 2
4888448 2323186 2323186 plaintiff Goos John   586306 586306 Goos, John, of Ixworth 0
4890451 2323779 2323779 defendant Kechyn William yeoman 586306 586306 Kechyn, William, of Ixworth, yeoman 9
4891087 2323951 2323951 defendant Kechyn William yeoman 586306 586306 Kechyn, William, of Ixworth, yeoman 9
4898492 2326179 2326179 defendant Syre John yeoman 586306 586306 Syre, John, of Ixworth, yeoman 0
4902285 2327325 2327325 defendant Blome Richard hosier 586306 586306 Blome, Richard, of Ixworth, hosier 0
4902286 2327325 2327325 defendant Wallok John tailor 586306 586306 Wallok, John, of Ixworth, tailor 1
4906412 2328593 2328593 defendant Gruggeman John husbandman 586306 586306 Gruggeman, John, of Ixworth, husbandman 1
4960922 2345229 2345229 defendant Kechyn Robert husbandman 586306 586306 Kechyn, Robert, of Ixworth, husbandman 0
5022360 2363436 2363436 plaintiff Goce John (legal representative) 586306 586306 Goce, John, of Ixworth, executor of 0
5022364 2363436 2363436 defendant Brame or Braym John   586306 586306 Brame or Braym, John, of Ixworth, linen mercer 2
5022366 2363436 2363436 defendant Wellyng Simon thatcher 586306 586306 Wellyng, Simon, of Ixworth, thatcher 4
5077425 2379747 2379747 plaintiff Blome John chaplain 586306 586306 Blome, John, of Ixworth, chaplain 0
5083577 2381590 2381590 plaintiff Howard William   586306 586306 Howard, William, of Ixworth 1
5103424 2387427 2387427 defendant Goos John (legal representative) 586306 586306 Goos, John, of Ixworth, gent, executor of 5
5254166 2431423 2431423 defendant Braham John mercer 586306 586306 Braham, John, of Ixworth, mercer 0
5277587 2438522 2438522 defendant Heyhowe John barber 586306 586306 Heyhowe, John, of Ixworth, barber 1
5277588 2438522 2438522 defendant Nicolas William pedder 586306 586306 Nicolas, William, of Ixworth, pedder 2
5289006 2441791 2441791 defendant Beaucher Robert yeoman 586306 586306 Beaucher, Robert, of Ixworth, yeoman 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);