names

97 rows where place_id = 614697

✎ 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
3705013 1927860 1927860 defendant Fynche Hugh husbandman 614697 614697 Fynche, Hugh, of Stanford Ryvers, husbandman 3
3726858 1934669 1934669 defendant Walys Thomas husbandman 614697 614697 Walys, Thomas, of Stanford Ryvers, husbandman 0
3726861 1934671 1934671 plaintiff Tyng William   614697 614697 Tyng, William, of Stanford Ryvers 0
3744448 1940166 1940166 defendant Kyng Thomas husbandman 614697 614697 Kyng, Thomas, of Stanford Ryvers, husbandman 0
3748443 1941447 1941447 defendant Grey John husbandman 614697 614697 Grey, John, of Stanford Ryvers, husbandman 2
3752654 1942760 1942760 defendant Kyng Thomas husbandman 614697 614697 Kyng, Thomas, of Stanford Ryvers, husbandman 0
3755621 1943716 1943716 defendant Herd Thomas yeoman 614697 614697 Herd, Thomas, of Stanford Ryvers, yeoman 1
3774730 1949826 1949826 defendant Graye John yeoman 614697 614697 Graye, John, of Stanford Ryvers, yeoman 0
3780966 1951780 1951780 defendant Brewer Thomas carpenter 614697 614697 Brewer, Thomas, of Stanford Ryvers, carpenter 1
3780967 1951780 1951780 defendant Salyng William yeoman 614697 614697 Salyng, William, of Stanford Ryvers, yeoman 2
3780968 1951780 1951780 defendant Greye Thomas summoner 614697 614697 Greye, Thomas, of Stanford Ryvers, summoner 3
3800878 1958184 1958184 defendant Lee John carpenter 614697 614697 Lee, John, of Stanford Ryvers, carpenter 0
3819567 1963996 1963996 defendant Bette Thomas husbandman 614697 614697 Bette, Thomas, of Stanford Ryvers, husbandman 0
3832998 1968239 1968239 defendant Griffe Robert chaplain 614697 614697 Griffe, Robert, of Stanford Ryvers, chaplain 0
3848760 1973197 1973197 defendant Groffe Robert chaplain 614697 614697 Groffe, Robert, of Stanford Ryvers, chaplain 0
3863990 1978136 1978136 defendant Griffe Robert chaplain 614697 614697 Griffe, Robert, of Stanford Ryvers, chaplain 0
3866429 1979004 1979004 defendant Graunt George yeoman 614697 614697 Graunt, George, of Stanford Ryvers, yeoman 0
3866430 1979004 1979004 defendant Graunt William laborer 614697 614697 Graunt, William, of Stanford Ryvers, laborer 1
3866431 1979004 1979004 defendant Graunt Richard laborer 614697 614697 Graunt, Richard, of Stanford Ryvers, laborer 2
3889358 1986671 1986671 defendant Salyng Augustine gent 614697 614697 Salyng, Augustine, of Stanford Ryvers, gent 0
3903485 1991392 1991392 defendant Salyng Augustine gent 614697 614697 Salyng, Augustine, of Stanford Ryvers, gent 0
4413809 2169216 2169216 defendant Olyve John   614697 614697 Olyve, John, of Stanford Ryvers 0
4413810 2169216 2169216 defendant atte Bregge Alice   614697 614697 atte Bregge, Alice, of Stanford Ryvers, formerly wife of John 1
4413811 2169216 2169216 defendant Gras Richard   614697 614697 Gras, Richard, of Stanford Ryvers 2
4413812 2169216 2169216 defendant Bal John   614697 614697 Bal, John, of Stanford Ryvers 3
4425990 2172932 2172932 plaintiff Mounteny John de   614697 614697 Mounteny, John de, of Stanford Ryvers 0
4560311 2219164 2219164 defendant Lane John   614697 614697 Lane, John, of Stanford Ryvers 0
4687137 2261582 2261582 plaintiff Stacy Roger   614697 614697 Stacy, Roger, of Stanford Ryvers 0
4687138 2261582 2261582 defendant Clerk John husbandman 614697 614697 Clerk, John, of Stanford Ryvers, husbandman 0
4744380 2278881 2278881 defendant Berneman John husbandman 614697 614697 Berneman, John, of Stanford Ryvers, husbandman 1
4770772 2286838 2286838 defendant Berneman John husbandman 614697 614697 Berneman, John, of Stanford Ryvers, husbandman 0
4788785 2292549 2292549 defendant Berneman John husbandman 614697 614697 Berneman, John, of Stanford Ryvers, husbandman 3
4793481 2294070 2294070 defendant Seyntlowe Hugh laborer 614697 614697 Seyntlowe, Hugh, of Stanford Ryvers, laborer 1
4809850 2299243 2299243 defendant Wormele John husbandman 614697 614697 with Wormele, John, of Stanford Ryvers, husbandman 1
4809853 2299243 2299243 defendant Passelewe Roger husbandman 614697 614697 Passelewe, Roger, of Stanford Ryvers, husbandman 4
4809856 2299244 2299244 defendant Passelowe Roger husbadman 614697 614697 Passelowe, Roger, of Stanford Ryvers, husbadman 1
4809860 2299246 2299246 defendant Wormele John husbandman 614697 614697 Wormele, John, of Stanford Ryvers, husbandman 0
4818518 2301871 2301871 defendant Passelewe Roger husbandman 614697 614697 Passelewe, Roger, of Stanford Ryvers, husbandman 4
4841707 2308942 2308942 defendant Neweman John husbandman 614697 614697 Neweman, John, of Stanford Ryvers, husbandman 0
4842703 2309256 2309256 defendant Ferrour William husbandman 614697 614697 Ferrour, William, of Stanford Ryvers, husbandman 0
4850534 2311629 2311629 defendant Chaumberleyn Thomas husbandman 614697 614697 Chaumberleyn, Thomas, of Stanford Ryvers, husbandman 1
4855569 2313105 2313105 defendant Fycche John husbandman 614697 614697 Fycche, John, of Stanford Ryvers, husbandman 1
4855572 2313106 2313106 defendant Fycche John husbandman 614697 614697 Fycche, John, of Stanford Ryvers, husbandman 1
4857062 2313590 2313590 defendant Passelowe Roger husbandman 614697 614697 Passelowe, Roger, of Stanford Ryvers, husbandman 0
4939537 2338752 2338752 plaintiff Couper Richard   614697 614697 Couper, Richard, of Stanford Ryvers 0
4939538 2338752 2338752 defendant Smyth John   614697 614697 Smyth, John, of Stanford Ryvers 0
4949347 2341782 2341782 defendant Lyvedon Richard laborer 614697 614697 Lyvedon, Richard, of Stanford Ryvers, laborer 0
4961061 2345271 2345271 defendant Cowper Richard husbandman 614697 614697 Cowper, Richard, of Stanford Ryvers, husbandman 0
4963066 2345861 2345861 defendant Passhelewe Roger yeoman 614697 614697 Passhelewe, Roger, of Stanford Ryvers, yeoman 0
4976447 2349919 2349919 defendant Mylys Simon chaplain 614697 614697 Mylys, Simon, of Stanford Ryvers, chaplain 1
4976448 2349919 2349919 defendant Styward William husbandman 614697 614697 together with Styward, William, of Stanford Ryvers, husbandman 2
4976449 2349919 2349919 defendant Shepherde John husbandman 614697 614697 Shepherde, John, of Stanford Ryvers, husbandman 3
4976452 2349920 2349920 defendant Mylys Simon chaplain 614697 614697 Mylys, Simon, of Stanford Ryvers, chaplain 1
4976453 2349920 2349920 defendant Styward William husbandman 614697 614697 together with Styward, William, of Stanford Ryvers, husbandman 2
4976454 2349920 2349920 defendant Shepherde John husbandman 614697 614697 Shepherde, John, of Stanford Ryvers, husbandman 3
4976456 2349921 2349921 defendant Styward William husbandman 614697 614697 Styward, William, of Stanford Ryvers, husbandman 0
4976457 2349921 2349921 defendant Shepherde John husbandman 614697 614697 Shepherde, John, of Stanford Ryvers, husbandman 1
4976459 2349921 2349921 defendant Mylys Simon chaplain 614697 614697 Mylys, Simon, of Stanford Ryvers, chaplain 3
4989802 2353867 2353867 defendant Balard John husbandman 614697 614697 Balard, John, of Stanford Ryvers, husbandman 0
5033212 2366595 2366595 defendant Styward William husbandman 614697 614697 Styward, William, of Stanford Ryvers, husbandman 1
5038603 2368190 2368190 defendant Styward John laborer 614697 614697 Styward, John, of Stanford Ryvers, laborer 0
5038604 2368190 2368190 defendant Heyward John husbandman 614697 614697 Heyward, John, of Stanford Ryvers, husbandman 1
5050009 2371623 2371623 defendant Wormeley John yeoman 614697 614697 Wormeley, John, of Stanford Ryvers, yeoman 0
5098158 2385893 2385893 defendant Heyward John husbandman 614697 614697 Heyward, John, of Stanford Ryvers, husbandman 2
5139897 2398150 2398150 defendant Ballard John husbandman 614697 614697 Ballard, John, of Stanford Ryvers, husbandman 0
5142814 2399027 2399027 defendant Heyward John husbandman 614697 614697 Heyward, John, of Stanford Ryvers, husbandman 2
5160756 2404243 2404243 defendant Tynge William yeoman 614697 614697 Tynge, William, of Stanford Ryvers, yeoman 1
5160912 2404295 2404295 defendant Ballard John husbandman 614697 614697 Ballard, John, of Stanford Ryvers, husbandman 0
5175468 2408513 2408513 defendant Tynge William yeoman 614697 614697 Tynge, William, of Stanford Ryvers, yeoman 1
5196825 2414823 2414823 defendant Ballard John husbandman 614697 614697 Ballard, John, of Stanford Ryvers, husbandman 0
5214276 2419907 2419907 defendant Smyth John yeoman 614697 614697 Smyth, John, of Stanford Ryvers, yeoman 2
5222974 2422437 2422437 defendant Cressy John husbandman 614697 614697 Cressy, John, of Stanford Ryvers, husbandman 0
5222976 2422438 2422438 defendant Cressy John husbandman 614697 614697 Cressy, John, of Stanford Ryvers, husbandman 0
5242508 2428013 2428013 defendant Bury Francis husbandman 614697 614697 Bury, Francis, of Stanford Ryvers, husbandman 0
5254435 2431512 2431512 defendant Smyth John husbandman 614697 614697 Smyth, John, of Stanford Ryvers, husbandman 0
5280111 2439257 2439257 defendant Lane John laborer 614697 614697 Lane, John, of Stanford Ryvers, laborer 0
5280113 2439257 2439257 defendant Lane Joan widow 614697 614697 Lane, Joan, of Stanford Ryvers, widow 2
5280116 2439257 2439257 defendant Fynche Nicholas husbandman 614697 614697 Fynche, Nicholas, of Stanford Ryvers, husbandman 5
5292460 2442792 2442792 defendant Bury Francis husbandman 614697 614697 Bury, Francis, of Stanford Ryvers, husbandman 0
5300625 2445149 2445149 defendant Abury Francis yeoman 614697 614697 Abury, Francis, of Stanford Ryvers, yeoman 0
5300962 2445239 2445239 defendant Abury Francis yeoman 614697 614697 Abury, Francis, of Stanford Ryvers, yeoman 0
5325336 2452665 2452665 defendant Waleys Thomas yeoman 614697 614697 Waleys, Thomas, of Stanford Ryvers, yeoman 0
5330689 2454256 2454256 defendant Mathewe Thomas laborer 614697 614697 Mathewe, Thomas, of Stanford Ryvers, laborer 0
5331613 2454536 2454536 defendant Tapster Robert husbandman 614697 614697 Tapster, Robert, of Stanford Ryvers, husbandman 1
5337926 2456427 2456427 defendant Monk John collier 614697 614697 Monk, John, of Stanford Ryvers, collier 0
5341905 2457667 2457667 defendant Burgh Robert gent 614697 614697 Burgh, Robert, of Stanford Ryvers, gent 0
5358292 2462647 2462647 defendant Styward Robert husbandman 614697 614697 Styward, Robert, of Stanford Ryvers, husbandman 1
5405117 2476544 2476544 defendant Batell John esq 614697 614697 Batell, John, of Stanford Ryvers, esq 0
5467899 2495341 2495341 defendant Bury Francis de husbandman 614697 614697 Bury, Francis de, of Stanford Ryvers, husbandman 0
5470299 2496036 2496036 defendant Hyll Robert collier 614697 614697 Hyll, Robert, of Stanford Ryvers, collier 1
5515836 2509799 2509799 defendant Glascok John   614697 614697 Glascok, John, of Stanford Ryvers 0
5536058 2515774 2515774 defendant Heere William, senior husbandman 614697 614697 Heere, William, senior, of Stanford Ryvers, husbandman 1
5536060 2515774 2515774 defendant Grymmesby Robert husbandman 614697 614697 Grymmesby, Robert, of Stanford Ryvers, husbandman 3
5536061 2515774 2515774 defendant Huberd John husbandman 614697 614697 Huberd, John, of Stanford Ryvers, husbandman 4
5547554 2519303 2519303 defendant Ferne John gent 614697 614697 Ferne, John, of Stanford Ryvers, gent 1
5593950 2533099 2533099 defendant Waleys Thomas laborer 614697 614697 Waleys, Thomas, of Stanford Ryvers, laborer 1
5599573 2534758 2534758 defendant Here John husbandman 614697 614697 Here, John, of Stanford Ryvers, husbandman 3

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