names

140 rows where place_id = 590255

✎ 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
3600394 1867768 1867768 plaintiff Wryghte John   590255 590255 Wryghte, John, of Est Ryston 0
3668356 1916049 1916049 defendant Curteys Richard butcher 590255 590255 Curteys, Richard, of Est Ryston, butcher 5
3717095 1931631 1931631 plaintiff Skynner Roger   590255 590255 Skynner, Roger, of Est Ryston 2
3717096 1931631 1931631 plaintiff Skynner Robert   590255 590255 Skynner, Robert, of Est Ryston 3
3742388 1939491 1939491 defendant Hamshyer Anthony yeoman 590255 590255 Hamshyer, Anthony, of Est Ryston, yeoman 0
3742389 1939491 1939491 defendant Awfyn Robert tailor 590255 590255 Awfyn, Robert, of Est Ryston, tailor 1
3756393 1943970 1943970 defendant Curteys Richard butcher 590255 590255 Curteys, Richard, of Est Ryston, butcher 3
3759609 1944994 1944994 defendant Curteys Richard butcher 590255 590255 Curteys, Richard, of Est Ryston, butcher 1
3846052 1972325 1972325 defendant Curtes Richard   590255 590255 Curtes, Richard, of Est Ryston, worsted weaver 0
3846053 1972325 1972325 defendant Ryall Robert laborer 590255 590255 Ryall, Robert, of Est Ryston, laborer 1
3950492 2007249 2007249 defendant Redberd Henry husbandman 590255 590255 Redberd, Henry, of Est Ryston, husbandman 0
3988802 2020743 2020743 plaintiff Aunsell John (legal representative) 590255 590255 Aunsell, John, of Est Ryston, executors of 0
3988804 2020743 2020743 defendant Alphyn Edmund yeoman 590255 590255 Alphyn, Edmund, of Est Ryston, yeoman 0
3988806 2020743 2020743 defendant Sutton Robert husbandman 590255 590255 Sutton, Robert, of Est Ryston, husbandman 2
3988808 2020744 2020744 plaintiff Aunsell John (legal representative) 590255 590255 Aunsell, John, of Est Ryston, executors of 0
4086291 2055370 2055370 defendant Turcock John tailor 590255 590255 Turcock, John, of Est Ryston, tailor 2
4276455 2121708 2121708 defendant Cooke John husbandman 590255 590255 Cooke, John, of East Ryston, husbandman 1
4329466 2140162 2140162 defendant Cocke John husbandman 590255 590255 Cocke, John, of Est Ryston, husbandman 0
4349612 2147126 2147126 defendant Delffe alias Dell Robert miller 590255 590255 Delffe alias Dell, Robert, of Est Ryston, miller 0
4454369 2186381 2186381 defendant Smyth John   590255 590255 Smyth, John, of East Ryston 8
4454370 2186381 2186381 defendant Person Thomas   590255 590255 Person, Thomas, of East Ryston 9
4470489 2191416 2191416 defendant Persoun William   590255 590255 Persoun, William, of East Ryston 0
4470491 2191416 2191416 defendant Persoun Roger   590255 590255 Persoun, Roger, of East Ryston 2
4611864 2234773 2234773 defendant Arale William   590255 590255 Arale, William, of East Ryston 2
4658614 2248571 2248571 defendant Person Richard   590255 590255 Person, Richard, of Est Ryston 1
4723729 2272725 2272725 defendant Coo Simon laborer 590255 590255 Coo, Simon, of East Ryston, laborer 3
4726266 2273500 2273500 defendant Deye Richard husbandman 590255 590255 Deye, Richard, of East Ryston, husbandman 0
4745878 2279299 2279299 defendant Deye Richard husbandman 590255 590255 Deye, Richard, of Est Ryston, husbandman 0
4768823 2286226 2286226 defendant Cok Richard barker or tanner 590255 590255 Cok, Richard, of East Ryston, barker or tanner 2
4820607 2302518 2302518 defendant Newehouse Henry butcher 590255 590255 Newehouse, Henry, of East Ryston, butcher 0
4820953 2302639 2302639 defendant Deye John butcher 590255 590255 Deye, John, of East Ryston, butcher 1
4820954 2302639 2302639 defendant atte Newys Clement butcher 590255 590255 atte Newys, Clement, of East Ryston, butcher 2
4820955 2302639 2302639 defendant Carles John thatcher 590255 590255 Carles, John, of East Ryston, thatcher 3
4824394 2303688 2303688 defendant Reyner Thomas yeoman 590255 590255 Reyner, Thomas, of East Ryston, yeoman 7
4840867 2308680 2308680 defendant Quy John husbandman 590255 590255 Quy, John, of East Ryston, husbandman 1
4840869 2308681 2308681 defendant Ony John husbandman 590255 590255 Ony, John, of East Ryston, husbandman 0
4844862 2309918 2309918 defendant atte Newhous Henry butcher 590255 590255 atte Newhous, Henry, of East Ryston, butcher 2
4845009 2309956 2309956 defendant Reyner Thomas yeoman 590255 590255 Reyner, Thomas, of East Ryston, yeoman 0
4845014 2309956 2309956 defendant Dey John butcher 590255 590255 Dey, John, of East Ryston, butcher 5
4889711 2323576 2323576 defendant Sutton Edmund, junior husbandman 590255 590255 Sutton, Edmund, junior, of Est Ryston, husbandman 0
4920332 2332874 2332874 defendant Fraunceys Roger husbandman 590255 590255 Fraunceys, Roger, of Est Ryston, husbandman 0
4920333 2332874 2332874 defendant Wryght Edmund husbandman 590255 590255 Wryght, Edmund, of Est Ryston, husbandman 1
4922571 2333475 2333475 defendant Newehous Geoffrey husbandman 590255 590255 Newehous, Geoffrey, of East Ryston, husbandman 0
4935987 2337655 2337655 defendant Cok Richard husbandman 590255 590255 Cok, Richard, of Est Ryston, husbandman 0
4942659 2339675 2339675 defendant Reyner Agnes widow 590255 590255 Reyner, Agnes, of Est Ryston, widow 5
4961385 2345374 2345374 defendant Cok Richard (legal representative) 590255 590255 Cok, Richard, of Est Ryston, husbandman, executors of 0
4961386 2345374 2345374 defendant Grene Robert husbandman 590255 590255 (Grene, Robert, of Est Ryston, husbandman 1
4972318 2348660 2348660 defendant Fraunceys Roger husbandman 590255 590255 Fraunceys, Roger, of Est Ryston, husbandman 2
4975789 2349725 2349725 defendant Lynsted Henry butcher 590255 590255 Lynsted, Henry, of Est Ryston, butcher 0
5000451 2357001 2357001 defendant Deye John husbandman 590255 590255 Deye, John, of East Ryston, husbandman 0
5002627 2357682 2357682 defendant Smyth Richard husbandman 590255 590255 Smyth, Richard, of East Ryston, husbandman 0
5016004 2361566 2361566 defendant Smyth Richard husbandman 590255 590255 Smyth, Richard, of Est Ryston, husbandman 0
5024062 2363947 2363947 defendant Levedy John husbandman 590255 590255 Levedy, John, of Est Ryston, husbandman 2
5024063 2363947 2363947 defendant Broun Rotheland husbandman 590255 590255 Broun, Rotheland, of Est Ryston, husbandman 3
5024715 2364149 2364149 defendant Red John husbandman 590255 590255 Red, John, of Est Ryston, husbandman 3
5025121 2364246 2364246 defendant Ovy John husbandman 590255 590255 Ovy, John, of Est Ryston, husbandman 0
5031502 2366073 2366073 defendant Smyth Richard husbandman 590255 590255 Smyth, Richard, of Est Ryston, husbandman 0
5031503 2366073 2366073 defendant Smyth Robert husbandman 590255 590255 Smyth, Robert, of Est Ryston, husbandman 1
5043214 2369590 2369590 defendant Deye John husbandman 590255 590255 Deye, John, of East Ryston, husbandman 2
5048238 2371107 2371107 defendant Radbode Robert butcher 590255 590255 Radbode, Robert, of East Ryston, butcher 0
5067348 2376741 2376741 defendant Lynsted Henry (legal representative) 590255 590255 Lynsted, Henry, of Est Ryston, administratrix of 3
5067349 2376741 2376741 defendant Lynsted Isabel widow 590255 590255 Lynsted, Isabel, of Est Ryston, widow 4
5080193 2380565 2380565 defendant Chapell William yeoman 590255 590255 Chapell, William, of Est Ryston, yeoman 1
5092239 2384112 2384112 defendant Lynsted Henry (legal representative) 590255 590255 Lynsted, Henry, of Est Ryston, administratrix of 0
5092240 2384112 2384112 defendant Lynsted Isabel widow 590255 590255 Lynsted, Isabel, of Est Ryston, widow 1
5106264 2388269 2388269 defendant Redbode Robert husbandman 590255 590255 Redbode, Robert, of Est Ryston, husbandman 0
5120910 2392546 2392546 defendant Wavery Roger husbandman 590255 590255 Wavery, Roger, of Est Ryston, husbandman 1
5136798 2397282 2397282 defendant Maddur Edmund caudeler or candeler 590255 590255 Maddur, Edmund, of Est Ryston, caudeler or candeler 2
5137513 2397483 2397483 defendant Bosse John   590255 590255 Bosse, John, of Est Ryston, perpetual vicar 0
5148329 2400648 2400648 defendant Redbede Robert husbandman 590255 590255 Redbede, Robert, of East Ryston, husbandman 0
5157223 2403253 2403253 defendant Helewyse Alice widow 590255 590255 Helewyse, Alice, of East Ryston, widow 3
5158163 2403505 2403505 defendant Bosse John   590255 590255 Bosse, John, of East Ryston, formerly perpetual vicar & clerk 0
5167657 2406263 2406263 defendant Redbode Robert   590255 590255 Redbode, Robert, of East Ryston, husbandman, Norfolk 0
5167687 2406270 2406270 defendant Redebode Robert yeoman 590255 590255 Redebode, Robert, of East Ryston, yeoman 0
5173101 2407840 2407840 defendant Helewyse Alice widow 590255 590255 Helewyse, Alice, of East Ryston, widow 3
5196674 2414778 2414778 defendant Rycheman Thomas mercer 590255 590255 Rycheman, Thomas, of East Ryston, mercer 3
5207657 2417979 2417979 defendant Reedbode Robert husbandman 590255 590255 Reedbode, Robert, of East Ryston, husbandman 1
5207658 2417979 2417979 defendant Madour Edmund   590255 590255 Madour, Edmund, of East Ryston, rope maker 2
5209748 2418588 2418588 defendant Rycheman Thomas mercer 590255 590255 Rycheman, Thomas, of East Ryston, mercer 3
5213859 2419783 2419783 defendant Richeman Thomas mercer 590255 590255 Richeman, Thomas, of Est Ryston, mercer 0
5213860 2419783 2419783 defendant Auncell Thomas, junior husbandman 590255 590255 Auncell, Thomas, junior, of Est Ryston, husbandman 1
5213861 2419783 2419783 defendant Bateman Robert shomaker 590255 590255 Bateman, Robert, of Est Ryston, shomaker 2
5217770 2420927 2420927 defendant Reedbode Robert butcher 590255 590255 Reedbode, Robert, of Est Ryston, butcher 1
5217771 2420927 2420927 defendant Marham Peter   590255 590255 Marham, Peter, of Est Ryston, mason 2
5220535 2421704 2421704 defendant Belotte Richard husbandman 590255 590255 Belotte, Richard, of Est Ryston, husbandman 0
5223597 2422588 2422588 defendant Acke Simon husbandman 590255 590255 Acke, Simon, of Est Ryston, husbandman 0
5223598 2422588 2422588 defendant Acke Thomas husbandman 590255 590255 Acke, Thomas, of Est Ryston, husbandman 1
5223599 2422588 2422588 defendant Marham Peter   590255 590255 Marham, Peter, of Est Ryston, mason 2
5223600 2422588 2422588 defendant Bateman Robert shoemaker 590255 590255 Bateman, Robert, of Est Ryston, shoemaker 3
5223601 2422588 2422588 defendant Marham Edmund husbandman 590255 590255 Marham, Edmund, of Est Ryston, mason, Arcale, Geoffrey, of Est Ryston, husbandman 4
5223602 2422588 2422588 defendant Baron Edmund laborer 590255 590255 Baron, Edmund, of Est Ryston, laborer 5
5230940 2424658 2424658 defendant Redbode Robert butcher 590255 590255 Redbode, Robert, of Est Ryston, butcher 0
5230943 2424658 2424658 defendant Madour Edmund chandler 590255 590255 Madour, Edmund, of Est Ryston, chandler 3
5232512 2425089 2425089 defendant Redbode Robert butcher 590255 590255 Redbode, Robert, of Est Ryston, butcher 2
5234673 2425729 2425729 defendant Cokke Robert yeoman 590255 590255 Cokke, Robert, of Est Ryston, yeoman 0
5234674 2425729 2425729 defendant atte Heyth John yeoman 590255 590255 atte Heyth, John, of Est Ryston, yeoman 1
5241606 2427747 2427747 defendant Love John   590255 590255 Love, John, of Est Ryston, cartwright 0
5244000 2428433 2428433 defendant Wryght William laborer 590255 590255 Wryght, William, of Est Ryston, laborer 0
5252447 2430875 2430875 defendant Wavery Robert husbandman 590255 590255 Wavery, Robert, of Est Ryston, yeoman, son of Wavery, Roger, of Est Ryston, husbandman 0
5253631 2431247 2431247 defendant Redbode Robert butcher 590255 590255 Redbode, Robert, of Est Ryston, butcher 0

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