names

120 rows where place_id = 587786

✎ 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
3592423 1865245 1865245 defendant Mendham John yeoman 587786 587786 Mendham, John, of Rynglond, yeoman 1
3592430 1865246 1865246 defendant Mendham John yeoman 587786 587786 Mendham, John, of Rynglond, yeoman 1
3600109 1867686 1867686 defendant Frostall John husbandman 587786 587786 Frostall, John, of Rynglond, husbandman 0
3609258 1870558 1870558 defendant Gybbon John laborer 587786 587786 Gybbon, John, of Rynglond, laborer 2
3613175 1871775 1871775 defendant Western Roger butcher 587786 587786 Western, Roger, of Rynglond, butcher 0
3616370 1872759 1872759 defendant Penyston Godfrey clerk 587786 587786 Penyston, Godfrey, of Rynglond, clerk 0
3625257 1875434 1875434 defendant Attemere John   587786 587786 Attemere, John, of Rynglond, hair man 0
3705763 1928083 1928083 plaintiff Haylle John, senior   587786 587786 Haylle, John, senior, of Rynglond 0
3749590 1941784 1941784 defendant Alyson John shoemaker 587786 587786 Alyson, John, of Rynglond, shoemaker 2
3770383 1948412 1948412 defendant Wasenott Robert butcher 587786 587786 Wasenott, Robert, of Rynglond, butcher 2
3770384 1948412 1948412 defendant Cayster John laborer 587786 587786 Cayster, John, of Rynglond, laborer 3
3780938 1951772 1951772 defendant Neve Peter hairman 587786 587786 Neve, Peter, of Rynglond, hairman 0
3830300 1967371 1967371 defendant Same Thomas clerk 587786 587786 Same, Thomas, of Rynglond, clerk 0
3843053 1971354 1971354 defendant Parson John baker 587786 587786 Parson, John, of Rynglond, baker 0
3850800 1973845 1973845 plaintiff Neve Robert   587786 587786 Neve, Robert, of Rynglond 0
3873641 1981398 1981398 defendant Alyson John shoemaker 587786 587786 Alyson, John, of Rynglond, shoemaker 4
4015015 2030073 2030073 defendant Creke William   587786 587786 Creke, William, of Rynglond, shepherd 7
4129263 2070764 2070764 defendant Osborne William husbandman 587786 587786 Osborne, William, of Rynglond, husbandman 1
4180734 2088743 2088743 defendant Martes or Martyn Robert husbandman 587786 587786 Martes or Martyn, Robert, of Rynglond, husbandman 1
4192273 2092858 2092858 defendant Lavercote William yeoman 587786 587786 Lavercote, William, of Rynglond, yeoman 2
4449009 2184632 2184632 defendant Smyth Geoffrey   587786 587786 Smyth, Geoffrey, of Rynglond 4
4449013 2184633 2184633 defendant Smyth Geoffrey   587786 587786 Smyth, Geoffrey, of Rynglond 2
4502542 2201381 2201381 defendant Topyas John   587786 587786 Topyas, John, of Rynglond, junior 0
4580264 2225312 2225312 defendant Frostell Nicholas   587786 587786 Frostell, Nicholas, of Rynglond 0
4580267 2225312 2225312 defendant atte More John   587786 587786 atte More, John, of Rynglond 3
4696536 2264392 2264392 defendant Fostell Nicholas husbandman 587786 587786 Fostell, Nicholas, of Rynglond, husbandman 3
4711185 2268850 2268850 plaintiff Roughe John   587786 587786 Roughe, John, of Rynglond 0
4743278 2278561 2278561 defendant Topyas John yeoman 587786 587786 Topyas, John, of rynglond, yeoman 0
4751973 2281071 2281071 defendant Fostell John yeoman 587786 587786 Fostell, John, of Rynglond, yeoman 0
4768696 2286187 2286187 defendant Tobyas William laborer 587786 587786 Tobyas, William, of Rynglond, laborer 0
4817568 2301585 2301585 defendant Kyng William yeoman 587786 587786 Kyng, William, of Rynglond, yeoman 0
4818802 2301966 2301966 defendant Spark John yeoman 587786 587786 Spark, John, of Rynglond, yeoman 0
4844153 2309681 2309681 defendant Hanley Cecily widow 587786 587786 Hanley, Cecily, of Rynglond, widow 2
4847485 2310713 2310713 defendant atte Mep John yeoman 587786 587786 atte Mep, John, of Rynglond, yeoman 0
4941601 2339392 2339392 defendant Bekham Richard husbandman 587786 587786 Bekham, Richard, of Rynglond, husbandman 2
4942128 2339522 2339522 defendant Drake William husbandman 587786 587786 Drake, William, of Rynglond, husbandman 0
4942129 2339522 2339522 defendant Becham Richard butcher 587786 587786 Becham, Richard, of Rynglond, butcher 1
4960848 2345204 2345204 defendant Bekham Robert yeoman 587786 587786 Bekham, Robert, of Rynglond, yeoman 3
4963063 2345860 2345860 plaintiff Mendham John   587786 587786 Mendham, John, of Rynglond 1
4967397 2347190 2347190 defendant Spark Thomas husbandman 587786 587786 Spark, Thomas, of Rynglond, husbandman 2
4974611 2349374 2349374 plaintiff Mendham John   587786 587786 Mendham, John, of Rynglond 0
4974612 2349374 2349374 defendant Spark Thomas husbandman 587786 587786 Spark, Thomas, of Rynglond, husbandman 0
4985418 2352562 2352562 defendant Bekham Richard butcher 587786 587786 Bekham, Richard, of Rynglond, butcher 1
4993122 2354823 2354823 defendant Spark Thomas husbandman 587786 587786 Spark, Thomas, of Rynglond, husbandman 2
5001305 2357262 2357262 defendant Norman Thomas husbandman 587786 587786 Norman, Thomas, of Rynglond, husbandman 1
5002351 2357595 2357595 defendant Sparke Thomas husbandman 587786 587786 Sparke, Thomas, of Rynglond, husbandman 0
5004282 2358144 2358144 defendant Bekham Richard butcher 587786 587786 Bekham, Richard, of Rynglond, butcher 1
5007248 2359012 2359012 defendant Hayreman Geoffrey   587786 587786 Hayreman, Geoffrey, of Rynglond, hair maker 1
5023490 2363779 2363779 defendant Sampson John carpenter 587786 587786 Sampson, John, of Rynglond, carpenter 2
5027854 2365027 2365027 plaintiff Mendham John   587786 587786 Mendham, John, of Rynglond 0
5037400 2367808 2367808 defendant Kyng Nicholas husbandman 587786 587786 Kyng, Nicholas, of Rynglond, husbandman 0
5037401 2367808 2367808 defendant Tounesend Hugh husbandman 587786 587786 Tounesend, Hugh, of Rynglond, husbandman 1
5047064 2370746 2370746 defendant Bekham Richard butcher 587786 587786 Bekham, Richard, of Rynglond, butcher 0
5047066 2370746 2370746 defendant Stowe John   587786 587786 Stowe, John, of Rynglond, mason 2
5049622 2371511 2371511 defendant Spark Thomas husbandman 587786 587786 Spark, Thomas, of Rynglond, husbandman 3
5074049 2378728 2378728 defendant Spark Thomas husbandman 587786 587786 Spark, Thomas, of Rynglond, husbandman 0
5074145 2378754 2378754 defendant Warwyk William husbandman 587786 587786 Warwyk, William, of Rynglond, husbandman 0
5074146 2378754 2378754 defendant Spark Thomas husbandman 587786 587786 Spark, Thomas, of Rynglond, husbandman 1
5074147 2378754 2378754 defendant Bekham Richard husbandman 587786 587786 Bekham, Richard, of Rynglond, husbandman 2
5074148 2378754 2378754 defendant Mayhewe John husbandman 587786 587786 Mayhewe, John, of Rynglond, husbandman 3
5074830 2378976 2378976 defendant Sparke Thomas husbandman 587786 587786 Sparke, Thomas, of Rynglond, husbandman 0
5074831 2378976 2378976 defendant Bekham Richard husbandman 587786 587786 Bekham, Richard, of Rynglond, husbandman 1
5115019 2390808 2390808 plaintiff Mendham John   587786 587786 Mendham, John, of Rynglond 0
5116039 2391119 2391119 defendant Spark Thomas husbandman 587786 587786 Spark, Thomas, of Rynglond, husbandman 0
5123170 2393211 2393211 defendant Norman John esq 587786 587786 Norman, John, of Rynglond, esq 0
5123171 2393211 2393211 defendant Spark Thomas yeoman 587786 587786 Spark, Thomas, of Rynglond, yeoman 1
5155723 2402833 2402833 plaintiff Mendham John   587786 587786 Mendham, John, of Rynglond 0
5192578 2413562 2413562 defendant St John John   587786 587786 St John, John, of Rynglond, wright 0
5192579 2413562 2413562 defendant Drake William husbandman 587786 587786 Drake, William, of Rynglond, husbandman 1
5192581 2413563 2413563 defendant St John John   587786 587786 St John, John, of Rynglond, wright 0
5192582 2413563 2413563 defendant Drake William husbandman 587786 587786 Drake, William, of Rynglond, husbandman 1
5207347 2417890 2417890 plaintiff Mendham John   587786 587786 Mendham, John, of Rynglond 0
5207779 2418016 2418016 defendant St John John   587786 587786 St John, John, of Rynglond, wright 0
5207780 2418016 2418016 defendant Drake William husbandman 587786 587786 Drake, William, of Rynglond, husbandman 1
5232928 2425214 2425214 defendant Mendham John yeoman 587786 587786 Mendham, John, of Rynglond, yeoman 0
5234243 2425603 2425603 defendant Mendham John yeoman 587786 587786 Mendham, John, of Rynglond, yeoman 2
5263158 2434222 2434222 plaintiff Pratte Robert   587786 587786 Pratte, Robert, of Rynglond 0
5266835 2435379 2435379 defendant Spark Thomas husbandman 587786 587786 Spark, Thomas, of Rynglond, husbandman 1
5273141 2437216 2437216 defendant Tobeas Wilfred (legal representative) 587786 587786 Tobeas, Wilfred, of Rynglond, hairman, executrix of 0
5279377 2439055 2439055 defendant Frostell John husbandman 587786 587786 Frostell, John, of Rynglond, husbandman 3
5291047 2442383 2442383 defendant Bekham Richard butcher 587786 587786 Bekham, Richard, of Rynglond, butcher 0
5293669 2443112 2443112 defendant Bekham Robert husbandman 587786 587786 Bekham, Robert, of Rynglond, husbandman 2
5293670 2443112 2443112 defendant Bekham Richard husbandman 587786 587786 Bekham, Richard, of Rynglond, husbandman 3
5295154 2443572 2443572 defendant Bekham Richard butcher 587786 587786 Bekham, Richard, of Rynglond, butcher 0
5295155 2443572 2443572 defendant Bekham Robert husbandman 587786 587786 Bekham, Robert, of Rynglond, husbandman 1
5301310 2445345 2445345 plaintiff Croke John husbandman 587786 587786 Croke, John, of Rynglond, husbandman 0
5313849 2449166 2449166 defendant Pratte Robert husbandman 587786 587786 Pratte, Robert, of Rynglond, husbandman 2
5325250 2452641 2452641 defendant Bekham Richard butcher 587786 587786 Bekham, Richard, of Rynglond, butcher 0
5325251 2452641 2452641 defendant Stowe Thomas thatcher 587786 587786 Stowe, Thomas, of Rynglond, thatcher 1
5362364 2463886 2463886 defendant Bokham Richard butcher 587786 587786 Bokham, Richard, of Rynglond, butcher 2
5385641 2470964 2470964 defendant Spynk Thomas husbandman 587786 587786 Spynk, Thomas, of Rynglond, husbandman 1
5449567 2489759 2489759 defendant Stowe John   587786 587786 Stowe, John, of Rynglond, mason 1
5449569 2489759 2489759 defendant Payn Richard laborer 587786 587786 Payn, Richard, of Rynglond, laborer 3
5461716 2493444 2493444 defendant Stoke John   587786 587786 Stoke, John, of Rynglond, mason 1
5461718 2493444 2493444 defendant Payn Richard laborer 587786 587786 Payn, Richard, of Rynglond, laborer 3
5461722 2493445 2493445 defendant Stowe John   587786 587786 Stowe, John, of Rynglond, mason 1
5461724 2493445 2493445 defendant Payn Richard laborer 587786 587786 Payn, Richard, of Rynglond, laborer 3
5465710 2494659 2494659 defendant Western Roger butcher 587786 587786 Western, Roger, of Rynglond, butcher 3
5465716 2494660 2494660 defendant Wester_ Roger butcher 587786 587786 Wester_, Roger, of Rynglond, butcher 3
5473248 2496960 2496960 defendant Stowe John   587786 587786 Stowe, John, of Rynglond, mason 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);