names

350 rows where place_id = 597124

✎ 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
3627391 1903421 1903421 defendant Marley Thomas husbandman 597124 597124 Marley, Thomas, of Waynflete, husbandman 0
3627703 1903525 1903525 defendant Westerdale Robert   597124 597124 Westerdale, Robert, of Waynflete, salt weller 0
3638827 1906965 1906965 defendant Julyan John cooper 597124 597124 Julyan, John, of Waynflete, cooper 0
3655031 1911837 1911837 defendant Johnson Robert weaver 597124 597124 Johnson, Robert, of Waynflete, weaver 0
3657378 1912566 1912566 defendant Johnson Robert weaver 597124 597124 Johnson, Robert, of Waynflete, weaver 0
3659240 1913146 1913146 defendant Johnson Robert weaver 597124 597124 Johnson, Robert, of Waynflete, weaver 0
3676800 1918780 1918780 defendant Barett Robert merchant 597124 597124 Barett, Robert, of Waynflete, merchant 0
3676802 1918781 1918781 defendant Tirwhit Richard clerk 597124 597124 Tirwhit, Richard, of Waynflete, clerk 0
3789976 1954691 1954691 defendant Pynder Robert laborer 597124 597124 Pynder, Robert, of Waynflete, laborer 0
3789977 1954691 1954691 defendant Pert William laborer 597124 597124 Pert, William, of Waynflete, laborer 1
3834848 1968838 1968838 defendant Kyggys Thomas fisher 597124 597124 Kyggys, Thomas, of Waynflete, fisher 1
3852334 1974331 1974331 defendant Crake William merchant 597124 597124 Crake, William, of Waynflete, merchant 0
3869961 1980195 1980195 defendant Symson Thomas husbandman 597124 597124 Symson, Thomas, of Waynflete, husbandman 0
3906881 1992589 1992589 defendant Srubby Simon husbandman 597124 597124 Srubby, Simon, of Waynflete, husbandman 1
3915631 1995598 1995598 defendant Hatclyff John gent 597124 597124 Hatclyff, John, of Waynflete, gent 0
3922467 1997831 1997831 defendant Creke William mariner 597124 597124 Creke, William, of Waynflete, mariner 0
3956948 2009497 2009497 defendant Dandyson John fisherman 597124 597124 Dandyson, John, of Waynflete, fisherman 0
4078708 2052680 2052680 defendant Magnus William husbandman 597124 597124 Magnus, William, of Waynflete, or of Baston, husbandman 0
4129984 2071028 2071028 defendant Marrys Robert yeoman 597124 597124 Marrys, Robert, of Waynflete, yeoman 0
4139969 2074660 2074660 defendant Grene Simon husbandman 597124 597124 Grene, Simon, of Waynflete, husbandman 0
4139972 2074660 2074660 defendant Ellys Stephen yeoman 597124 597124 Ellys, Stephen, of Waynflete, yeoman 3
4146190 2076818 2076818 defendant Walker Thomas clerk 597124 597124 Walker, Thomas, of Waynflete, clerk 1
4171665 2085556 2085556 defendant Lowes John yeoman 597124 597124 Lowes, John, of Waynflete, yeoman 0
4171667 2085556 2085556 defendant Davison John yeoman 597124 597124 Davison, John, of Waynflete, yeoman 2
4419901 2171127 2171127 defendant Eggefeld Ralph de   597124 597124 Eggefeld, Ralph de, of Waynflete 0
4427412 2173413 2173413 defendant Elriker Walter   597124 597124 Elriker, Walter, of Waynflete 0
4438770 2181419 2181419 plaintiff atte Hall John   597124 597124 atte Hall, John, of Waynflete 0
4438787 2181423 2181423 plaintiff atte Halle John   597124 597124 atte Halle, John, of Waynflete 0
4449517 2184796 2184796 plaintiff Godfrey Margaret   597124 597124 Godfrey, Margaret, of Waynflete 0
4453853 2186217 2186217 defendant Isakelson Peter tanner 597124 597124 Isakelson, Peter, of Waynflete, tanner 0
4456008 2186901 2186901 plaintiff Mychel Simon   597124 597124 Mychel, Simon, of Waynflete 0
4456009 2186901 2186901 defendant Donesday John   597124 597124 Donesday, John, of Waynflete 0
4459436 2188002 2188002 plaintiff Ryngot John   597124 597124 Ryngot, John, of Waynflete 0
4459437 2188002 2188002 defendant atte Kirke John   597124 597124 atte Kirke, John, of Waynflete, son of Thomas 0
4464162 2189461 2189461 defendant Coke Thomas   597124 597124 Coke, Thomas, of Waynflete 0
4481158 2194789 2194789 defendant Wace John   597124 597124 (Wace, John, of Waynflete 1
4485406 2196139 2196139 defendant Smyth John   597124 597124 Smyth, John, of Waynflete 0
4505328 2202196 2202196 defendant Othe Tymmes Henry   597124 597124 Othe Tymmes, Henry, of Waynflete 0
4509689 2203512 2203512 defendant Poupe Ralph   597124 597124 Poupe, Ralph, of Waynflete 0
4514322 2204897 2204897 defendant Broune William   597124 597124 Broune, William, of Waynflete 1
4522293 2207317 2207317 defendant Bakester Walter   597124 597124 Bakester, Walter, of Waynflete 0
4526457 2208554 2208554 defendant Buntyng Walter   597124 597124 Buntyng, Walter, of Waynflete 1
4529067 2209363 2209363 plaintiff Meweson Simon   597124 597124 Meweson, Simon, of Waynflete 0
4532957 2210580 2210580 plaintiff Randson Walter   597124 597124 Randson, Walter, of Waynflete 0
4532959 2210580 2210580 defendant Ryngot William   597124 597124 Ryngot, William, of Waynflete 1
4540087 2212806 2212806 defendant Buntyng John   597124 597124 Buntyng, John, of Waynflete 1
4554493 2217339 2217339 plaintiff Gunny John   597124 597124 Gunny, John, of Waynflete 0
4554495 2217339 2217339 defendant Abbot William   597124 597124 Abbot, William, of Waynflete 1
4557369 2218246 2218246 plaintiff Kyngesson John   597124 597124 Kyngesson, John, of Waynflete 0
4559584 2218950 2218950 plaintiff Michall Simon   597124 597124 Michall, Simon, of Waynflete 0
4569790 2222128 2222128 defendant Randson Walter   597124 597124 Randson, Walter, of Waynflete 1
4570544 2222360 2222360 defendant Ryngot William   597124 597124 Ryngot, William, of Waynflete 1
4573298 2223182 2223182 plaintiff Barbour Roger   597124 597124 Barbour, Roger, of Waynflete 0
4574122 2223430 2223430 plaintiff Beke Alan   597124 597124 Beke, Alan, of Waynflete 0
4574123 2223430 2223430 defendant Tumby William   597124 597124 Tumby, William, of Waynflete 0
4574124 2223430 2223430 defendant Plattys Robert   597124 597124 Plattys, Robert, of Waynflete 1
4574126 2223430 2223430 defendant Houlynson or Honlynson William   597124 597124 Houlynson or Honlynson, William, of Waynflete 3
4574127 2223430 2223430 defendant Peresson Wyotson Hugh   597124 597124 Peresson Wyotson, Hugh, of Waynflete 4
4584529 2226576 2226576 plaintiff Godfray John   597124 597124 Godfray, John, of Waynflete 0
4585320 2226830 2226830 defendant Spycer John   597124 597124 Spycer, John, of Waynflete 2
4588316 2227737 2227737 defendant Ryngold William   597124 597124 Ryngold, William, of Waynflete 2
4590471 2228379 2228379 defendant Graa John   597124 597124 Graa, John, of Waynflete 0
4591601 2228732 2228732 plaintiff More John   597124 597124 More, John, of Waynflete 0
4596178 2230058 2230058 defendant Bury John   597124 597124 Bury, John, of Waynflete 0
4597713 2230534 2230534 defendant Cosyn Walter butcher 597124 597124 Cosyn, Walter, of Waynflete, butcher 0
4605065 2232744 2232744 defendant Rughton John de   597124 597124 Rughton, John de, of Waynflete 0
4605532 2232851 2232851 defendant Lytster Robert   597124 597124 Lytster, Robert, of Waynflete, son of John 3
4605801 2232928 2232928 defendant atte Halle John   597124 597124 atte Halle, John, of Waynflete, son of Walter 0
4614429 2235521 2235521 defendant Huchunson Randolf   597124 597124 Huchunson, Randolf, of Waynflete 1
4616092 2236038 2236038 defendant Michell John   597124 597124 Michell, John, of Waynflete 0
4618087 2236668 2236668 defendant Spycer John   597124 597124 Spycer, John, of Waynflete 0
4629049 2240011 2240011 defendant Hall Walter de   597124 597124 Hall, Walter de, of Waynflete 1
4632647 2241096 2241096 defendant Michell John   597124 597124 Michell, John, of Waynflete 0
4632652 2241097 2241097 plaintiff Mewsone Simon   597124 597124 Mewsone, Simon, of Waynflete 4
4639203 2242986 2242986 defendant Manslot Robert   597124 597124 Manslot, Robert, of Waynflete 3
4639885 2243168 2243168 defendant Kyngesson John   597124 597124 Kyngesson, John, of Waynflete 1
4641762 2243690 2243690 defendant Milya Simon   597124 597124 Milya, Simon, of Waynflete 0
4642201 2243836 2243836 defendant Spycer John   597124 597124 Spycer, John, of Waynflete 0
4645020 2244617 2244617 defendant Plattes Robert   597124 597124 Plattes, Robert, of Waynflete 1
4648303 2245564 2245564 defendant Hurrey John   597124 597124 Hurrey, John, of Waynflete 4
4665343 2250649 2250649 defendant Stretton John   597124 597124 Stretton, John, of Waynflete, groom 6
4667327 2255508 2255508 defendant Chaumberlayn John husbandman 597124 597124 Chaumberlayn, John, of Waynflete, husbandman 5
4683489 2260436 2260436 defendant Jonson Walter husbandman 597124 597124 Jonson, Walter, of Waynflete, husbandman 0
4700923 2265692 2265692 plaintiff Forthyngton John   597124 597124 Forthyngton, John, of Waynflete 0
4705191 2266992 2266992 defendant Michell John husbandman 597124 597124 Michell, John, of Waynflete, husbandman 3
4705298 2267030 2267030 plaintiff Forthyngton John   597124 597124 Forthyngton, John, of Waynflete 1
4711871 2269044 2269044 defendant atte Halle Walter gent 597124 597124 atte Halle, Walter, of Waynflete, gent 0
4721377 2272019 2272019 defendant Urry William husbandman 597124 597124 Urry, William, of Waynflete, husbandman 0
4721378 2272019 2272019 defendant Cokke Simon husbandman 597124 597124 Cokke, Simon, of Waynflete, husbandman 1
4721380 2272020 2272020 defendant Urry William husbandman 597124 597124 Urry, William, of Waynflete, husbandman 0
4721381 2272020 2272020 defendant Cokke Simon husbandman 597124 597124 Cokke, Simon, of Waynflete, husbandman 1
4723169 2272559 2272559 defendant atte Halle Walter husbandman 597124 597124 atte Halle, Walter, of Waynflete, husbandman 1
4731161 2274946 2274946 defendant Aunghefyn Roger shipman 597124 597124 Aunghefyn, Roger, of Waynflete, shipman 0
4736850 2276654 2276654 defendant Dandyson Thomas husbandman 597124 597124 Dandyson, Thomas, of Waynflete, husbandman 1
4738046 2277000 2277000 defendant Haliday Richard   597124 597124 Haliday, Richard, of Waynflete, bailiff 2
4738066 2277008 2277008 defendant Kygges Walter   597124 597124 Kygges, Walter, of Waynflete, turf graver or turf digger 0
4740180 2277642 2277642 defendant Halyday Richard   597124 597124 Halyday, Richard, of Waynflete, bailiff 1
4742906 2278434 2278434 defendant Brakon John fisher 597124 597124 Brakon, John, of Waynflete, fisher 0
4742907 2278434 2278434 defendant Braken Emma   597124 597124 Braken, Emma, of Waynflete, servant 1
4752404 2281162 2281162 defendant goderylkson John laborer 597124 597124 goderylkson, John, of Waynflete, laborer 1

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