names

105 rows where place_id = 595280

✎ 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
3619798 1873765 1873765 defendant Squyer John husbandman or yeoman 595280 595280 Squyer, John, of Ocle, husbandman or yeoman 0
3659560 1913250 1913250 defendant ap Thomas John husbandman 595280 595280 ap Thomas, John, of Ocle, husbandman 4
3766379 1947139 1947139 defendant Bondys Thomas glover 595280 595280 Bondys, Thomas, of Ocle, glover 0
3834365 1968691 1968691 defendant Clere Thomas esq 595280 595280 Clere, Thomas, of Ocle, esq 1
3843446 1971488 1971488 plaintiff Clere Thomas gent 595280 595280 Clere, Thomas, of Ocle, gent 0
3922312 1997776 1997776 defendant Travys Margaret widow 595280 595280 Travys, Margaret, of Ocle, widow 0
3956095 2009201 2009201 defendant Wood Richard smith 595280 595280 Wood, Richard, of Ocle, smith 0
3993979 2022598 2022598 plaintiff Clarke John sherman 595280 595280 Clarke, John, of Ocle, sherman 0
4020684 2032124 2032124 defendant Boll Robert butcher 595280 595280 Boll, Robert, of Ocle, butcher 3
4086333 2055388 2055388 defendant Moore Philip (legal representative) 595280 595280 Moore, Philip, of Ocle Pycher, husbandman, executor of 0
4091634 2057301 2057301 defendant Phelpott Humphrey yeoman 595280 595280 Phelpott, Humphrey, of Ocle Pycher, yeoman 0
4091636 2057302 2057302 defendant Phelpott Joyce widow 595280 595280 Phelpott, Joyce, of Ocle Pycher, widow 0
4092270 2057537 2057537 defendant Exham John yeoman 595280 595280 Exham, John, of Ocle, yeoman 0
4207600 2098217 2098217 defendant Croke John husbandman 595280 595280 Croke, John, of Ocle, husbandman 2
4448064 2184316 2184316 defendant Clere William   595280 595280 Clere, William, of Ocle 0
4486220 2196396 2196396 defendant Lyteman William   595280 595280 Lyteman, William, of Ocle 0
4547304 2215089 2215089 defendant Smyth Adam   595280 595280 Smyth, Adam, of Ocle 4
4549065 2215642 2215642 defendant Hale William   595280 595280 Hale, William, of Ocle 0
4549067 2215642 2215642 defendant Skypper Henry   595280 595280 Skypper, Henry, of Ocle 2
4572316 2222884 2222884 defendant Smyth Adam   595280 595280 Smyth, Adam, of Ocle 2
4587642 2227540 2227540 defendant Kyrte Thomas   595280 595280 Kyrte, Thomas, of Ocle 0
4595597 2229887 2229887 plaintiff Reyner William   595280 595280 Reyner, William, of Ocle 0
4608104 2233648 2233648 defendant Trymman Simon   595280 595280 together with Trymman, Simon, of Ocle 1
4616946 2236306 2236306 defendant Rothes Roger de   595280 595280 Rothes, Roger de, of Ocle, pedlar 0
4645644 2244790 2244790 defendant Smyth Adam   595280 595280 Smyth, Adam, of Ocle 1
4654377 2247242 2247242 defendant Salkyn Robert laborer 595280 595280 Salkyn, Robert, of Ocle, laborer 0
4660446 2249093 2249093 defendant Balle Nicholas spicer 595280 595280 Balle, Nicholas, of Ocle, spicer 1
4660451 2249094 2249094 defendant Balle Nicholas spicer 595280 595280 Balle, Nicholas, of Ocle, spicer 1
4665073 2250555 2250555 defendant atte Howe Thomas woolman 595280 595280 atte Howe, Thomas, of Ocle, woolman 0
4690355 2262541 2262541 plaintiff Hendy Robert   595280 595280 Hendy, Robert, of Ocle 2
4690357 2262541 2262541 defendant Morfile William   595280 595280 Morfile, William, of Ocle, holy water clerk, not another holy water clerk, surely ! 1
4690360 2262542 2262542 plaintiff Hendy Robert   595280 595280 Hendy, Robert, of Ocle 2
4690364 2262543 2262543 plaintiff Hendy Robert   595280 595280 Hendy, Robert, of Ocle 2
4690365 2262543 2262543 defendant Morsile or Morfile William   595280 595280 Morsile or Morfile, William, of Ocle, holy water clerk 0
4703169 2266371 2266371 defendant Cukke William husbandman 595280 595280 Cukke, William, of Ocle, husbandman 0
4707209 2267634 2267634 defendant Clerk Adam husbandman 595280 595280 Clerk, Adam, of Ocle, husbandman 3
4744854 2279013 2279013 defendant Hee-dy John yeoman 595280 595280 Hee-dy, John, of Ocle, yeoman 2
4750817 2280721 2280721 defendant Perkyns Thomas husbandman 595280 595280 Perkyns, Thomas, of Ocle, husbandman 0
4750818 2280721 2280721 defendant Davyes Philip husbandman 595280 595280 Davyes, Philip, of Ocle, husbandman 1
4757651 2282769 2282769 defendant Davy Thomas mercer 595280 595280 Davy, Thomas, of Ocle, mercer 0
4759778 2283394 2283394 defendant atte Lane Warren   595280 595280 atte Lane, Warren, of Ocle, bailiff 4
4765446 2285179 2285179 defendant Legge Robert butcher 595280 595280 Legge, Robert, of Ocle, butcher 0
4776433 2288623 2288623 defendant Hert Henry   595280 595280 Hert, Henry, of Ocle, bailiff 1
4780065 2289770 2289770 defendant Crede William yeoman 595280 595280 Crede, William, of Ocle, yeoman 0
4800269 2296262 2296262 defendant Leeg Robert butcher 595280 595280 Leeg, Robert, of Ocle, butcher 2
4804315 2297536 2297536 defendant Werte alias Ducheman Henry weaver 595280 595280 Werte alias Ducheman, Henry, of Ocle, weaver 0
4807793 2298623 2298623 defendant Collewall James husbandman 595280 595280 Collewall, James, of Ocle, husbandman 0
4818339 2301819 2301819 defendant Leeg Robert butcher 595280 595280 Leeg, Robert, of Ocle, butcher 1
4818871 2301985 2301985 defendant Jebbes Richard laborer 595280 595280 Jebbes, Richard, of Ocle, laborer 0
4830004 2305429 2305429 defendant atte Welle John   595280 595280 atte Welle, John, of Ocle 0
4835524 2307102 2307102 defendant Rogeris Thomas husbandman 595280 595280 Rogeris, Thomas, of Ocle, husbandman 0
4835977 2307233 2307233 defendant Blount John husbandman & glasier 595280 595280 Blount, John, of Ocle, husbandman & glasier 0
4841203 2308787 2308787 defendant Toryton John   595280 595280 Toryton, John, of Ocle, vicar 0
4858158 2313921 2313921 defendant Roger Thomas husbandman 595280 595280 Roger, Thomas, of Ocle, husbandman 1
4861758 2315049 2315049 defendant Heynes John husbandman 595280 595280 Heynes, John, of Ocle, husbandman 0
4868912 2317252 2317252 defendant Gandy John yeoman 595280 595280 Gandy, John, of Ocle, yeoman 1
4870804 2317849 2317849 defendant Westwode John yeoman 595280 595280 Westwode, John, of Ocle, yeoman 0
4875489 2319288 2319288 defendant Berdy John, junior tailor 595280 595280 Berdy, John, junior, of Ocle, tailor 0
4875490 2319288 2319288 defendant atte Welle alias Welles John husbandman 595280 595280 atte Welle alias Welles, John, of Ocle, husbandman 1
4888407 2323174 2323174 defendant Gebbes Richard husbandman 595280 595280 Gebbes, Richard, of Ocle, husbandman 1
4888408 2323174 2323174 defendant Talbot John husbandman 595280 595280 Talbot, John, of Ocle, husbandman 2
4889837 2323612 2323612 defendant Bernard John husbandman 595280 595280 Bernard, John, of Ocle, husbandman 1
4892333 2324337 2324337 defendant Haynes John butcher 595280 595280 Haynes, John, of Ocle, butcher 0
4894075 2324845 2324845 defendant Bernard John husbandman 595280 595280 Bernard, John, of Ocle, husbandman 1
4900859 2326899 2326899 defendant Mome John husbandman 595280 595280 Mome, John, of Ocle, husbandman 0
4924519 2334106 2334106 defendant Otyr Margaret widow 595280 595280 with Otyr, Margaret, of Ocle, widow 7
4949159 2341727 2341727 defendant Hendy Robert husbandman 595280 595280 Hendy, Robert, of Ocle, husbandman 0
4950713 2342190 2342190 defendant Toryngton John clerk 595280 595280 Toryngton, John, of Ocle, clerk 0
4981922 2351512 2351512 defendant Blount Robert clerk 595280 595280 Blount, Robert, of Ocle, clerk 3
4981926 2351513 2351513 defendant Blount Robert clerk 595280 595280 Blount, Robert, of Ocle, clerk 2
5018540 2362304 2362304 defendant Cartere Thomas carpenter 595280 595280 Cartere, Thomas, of Ocle, carpenter 0
5028980 2365344 2365344 defendant Horsemon William husbandman 595280 595280 Horsemon, William, of Ocle, husbandman 0
5029707 2365559 2365559 defendant Kyngesey John husbandman 595280 595280 Kyngesey, John, of Ocle, husbandman 0
5029708 2365559 2365559 defendant Kyngesey Richard baker 595280 595280 Kyngesey, Richard, of Ocle, baker 1
5047123 2370761 2370761 defendant Seyne William   595280 595280 Seyne, William, of Ocle 6
5085658 2382204 2382204 defendant Sergeaunt John husbandman 595280 595280 Sergeaunt, John, of Ocle, husbandman 0
5085659 2382204 2382204 defendant Croulond John, senior husbandman 595280 595280 Croulond, John, senior, of Ocle, husbandman 1
5086801 2382536 2382536 plaintiff Hoberd John (legal representative) 595280 595280 Hoberd, John, of Ocle, chaplain, executor of 0
5091010 2383768 2383768 defendant Hendy Roger laborer 595280 595280 Hendy, Roger, of Ocle, laborer 1
5128836 2394919 2394919 defendant Stonham Thomas yeoman 595280 595280 Stonham, Thomas, of Ocle, yeoman 2
5128837 2394919 2394919 defendant Drynkmylk William yeoman 595280 595280 Drynkmylk, William, of Ocle, yeoman 3
5230591 2424560 2424560 defendant Therle John husbandman 595280 595280 Therle, John, of Ocle Lyner, husbandman 0
5284523 2440484 2440484 defendant Bayows John smith 595280 595280 Bayows, John, of Ocle, smith 3
5329115 2453787 2453787 defendant Harvy John husbandman 595280 595280 together with Harvy, John, of Ocle, husbandman 1
5329116 2453787 2453787 defendant Steynes Thomas husbandman 595280 595280 Steynes, Thomas, of Ocle, husbandman 2
5329117 2453787 2453787 defendant Rykkys William husbandman 595280 595280 Rykkys, William, of Ocle, husbandman 3
5329124 2453789 2453789 defendant Harvy John husbandman 595280 595280 Harvy, John, of Ocle, husbandman 0
5329125 2453789 2453789 defendant Rykkys William husbandman 595280 595280 Rykkys, William, of Ocle, husbandman 1
5329127 2453789 2453789 defendant Steynes Thomas husbandman 595280 595280 Steynes, Thomas, of Ocle, husbandman 3
5329129 2453790 2453790 defendant Steynes Thomas husbandman 595280 595280 Steynes, Thomas, of Ocle, husbandman 0
5346374 2459011 2459011 defendant Steynes Thomas husbandman 595280 595280 Steynes, Thomas, of Ocle, husbandman 0
5346376 2459011 2459011 defendant Harvy John husbandman 595280 595280 Harvy, John, of Ocle, husbandman 2
5346377 2459011 2459011 defendant Rykkys William husbandman 595280 595280 Rykkys, William, of Ocle, husbandman 3
5368103 2465651 2465651 defendant Shepherd William Suff, drover 595280 595280 Shepherd William, of Ocle, Suff, drover 0
5371340 2466614 2466614 defendant Harold John clerk 595280 595280 Harold, John, of Ocle, clerk 0
5427114 2483048 2483048 defendant Cl_ William husbandman 595280 595280 Cl_, William, of Ocle, husbandman 1
5433514 2484986 2484986 plaintiff Moors John   595280 595280 Moors, John, of Ocle 0
5529137 2513627 2513627 defendant Spark John husbandman 595280 595280 Spark, John, of Ocle, husbandman 1
5531342 2514323 2514323 defendant Auncell Richard pedder 595280 595280 Auncell, Richard, of Ocle, pedder 2
5626754 2552340 2552340 defendant Warde Thomas husbandman 595280 595280 Warde, Thomas, of Ocle, husbandman 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);