names

124 rows where place_id = 592221

✎ 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
3606979 1869846 1869846 plaintiff Pounfrette John   592221 592221 Pounfrette, John, of Westacre 0
3615579 1872512 1872512 defendant Bateman Roger   592221 592221 Bateman, Roger, of Westacre, shepherd 3
3628316 1903717 1903717 defendant Heye Robert husbandman 592221 592221 Heye, Robert, of Westacre, husbandman 4
3661695 1913935 1913935 defendant Batman Roger   592221 592221 Batman, Roger, of Westacre, shepherd 1
3682315 1920569 1920569 defendant Mannyng Thomas fuller 592221 592221 Mannyng, Thomas, of Westacre, fuller 1
3786387 1953529 1953529 defendant Burton Thomas husbandman 592221 592221 Burton, Thomas, of Westacre, husbandman 0
3846590 1972486 1972486 defendant Smyth Robert warrener 592221 592221 Smyth, Robert, of Westacre, warrener 2
3867577 1979392 1979392 defendant Davy John carpenter 592221 592221 Davy, John, of Westacre, carpenter 0
3881530 1984084 1984084 defendant Davy John carpenter 592221 592221 Davy, John, of Westacre, carpenter 0
3919765 1996949 1996949 defendant Beckham Thomas yeoman 592221 592221 Beckham, Thomas, of Westacre, yeoman 3
4013493 2029560 2029560 defendant Prest John   592221 592221 Prest, John, of Westacre, shepherd 0
4035673 2037437 2037437 defendant Johnson Robert clerk 592221 592221 Johnson, Robert, of Westacre, clerk 1
4035678 2037438 2037438 defendant Johnson Robert clerk 592221 592221 Johnson, Robert, of Westacre, clerk 1
4063953 2047387 2047387 defendant Kewe William husbandman 592221 592221 Kewe, William, of Westacre, husbandman 2
4084372 2054681 2054681 defendant Cheyney Thomas   592221 592221 Cheyney, Thomas, of Westacre, shepherd 2
4125158 2069285 2069285 defendant Forbye John yeoman 592221 592221 Forbye, John, of Westacre, yeoman 0
4125159 2069285 2069285 defendant Day Henry husbandman 592221 592221 Day, Henry, of Westacre, husbandman 1
4125503 2069403 2069403 defendant Forby John husbandman 592221 592221 Forby, John, of Westacre, husbandman 0
4128169 2070363 2070363 defendant Forbye John yeoman 592221 592221 Forbye, John, of Westacre, yeoman 0
4140867 2074970 2074970 defendant Forbye John yeoman 592221 592221 Forbye, John, of Westacre, yeoman 0
4148309 2077539 2077539 defendant Prest Andrew husbandman 592221 592221 Prest, Andrew, of Westacre, husbandman 1
4158412 2081013 2081013 defendant Forby John yeoman 592221 592221 Forby, John, of Westacre, yeoman 0
4182529 2089368 2089368 defendant Prest Andrew (legal representative) 592221 592221 Prest, Andrew, of Westacre, yeoman, executor of 0
4222051 2103203 2103203 defendant Atcocke John yeoman 592221 592221 Atcocke, John, of Westacre, yeoman 2
4243768 2110896 2110896 defendant Odell William gent 592221 592221 Odell, William, of Westacre, gent 1
4247686 2112206 2112206 defendant Atcocke John yeoman 592221 592221 Atcocke, John, of Westacre, yeoman 2
4251176 2113370 2113370 defendant Danbye John yeoman 592221 592221 Danbye, John, of Westacre, yeoman 2
4271633 2120096 2120096 defendant Rame or Raine William yeoman 592221 592221 Rame or Raine, William, of Westacre, yeoman 0
4290445 2126642 2126642 defendant Ram or Rain William yeoman 592221 592221 Ram or Rain, William, of Westacre, yeoman 0
4292080 2127241 2127241 defendant Nurse Geoffrey yeoman 592221 592221 Nurse, Geoffrey, of Westacre, yeoman 0
4327573 2139545 2139545 defendant Rame or Raine William yeoman 592221 592221 Rame or Raine, William, of Westacre, yeoman 0
4349180 2146974 2146974 defendant Rame or Raine William yeoman 592221 592221 Rame or Raine, William, of Westacre, yeoman 2
4387889 2160582 2160582 defendant Dey Henry yeoman 592221 592221 Dey, Henry, of Westacre, yeoman 0
4393216 2162338 2162338 defendant Baker Edmund husbandman 592221 592221 Baker, Edmund, of Westacre, husbandman 0
4393217 2162338 2162338 defendant Danky Thomas, junior husbandman 592221 592221 Danky, Thomas, junior, of Westacre, husbandman 1
4393218 2162338 2162338 defendant Phillipson William husbandman 592221 592221 Phillipson, William, of Westacre, husbandman 2
4399210 2164322 2164322 defendant Rame or Raine William yeoman 592221 592221 Rame or Raine, William, of Westacre, yeoman 1
4403622 2165789 2165789 defendant Danby John yeoman 592221 592221 Danby, John, of Westacre, yeoman 0
4502883 2201476 2201476 plaintiff Wills Margery   592221 592221 Wills, Margery, of Westacre 4
4507506 2202807 2202807 defendant Spark Thomas   592221 592221 Spark, Thomas, of Westacre 0
4563054 2220012 2220012 defendant Skynnere Thomas   592221 592221 Skynnere, Thomas, of Westacre 1
4570566 2222368 2222368 defendant Smyth John   592221 592221 Smyth, John, of Westacre 1
4602462 2231990 2231990 defendant Marham Henry   592221 592221 Marham, Henry, of Westacre 0
4625633 2238977 2238977 defendant Mason Walter   592221 592221 Mason, Walter, of Westacre 0
4642432 2243910 2243910 defendant Barker Thomas   592221 592221 Barker, Thomas, of Westacre 0
4652813 2246813 2246813 defendant Baker Thomas yeoman 592221 592221 Baker, Thomas, of Westacre, yeoman 0
4662048 2249605 2249605 defendant Barker Thomas husbandman 592221 592221 Barker, Thomas, of Westacre, husbandman 1
4677176 2258479 2258479 defendant Osteler Ralphd husbandman 592221 592221 Osteler, Ralphd, of Westacre, husbandman 1
4689821 2262375 2262375 defendant Bakere Thomas husbandman 592221 592221 Bakere, Thomas, of Westacre, husbandman 4
4693167 2263365 2263365 defendant Barker Thomas yeoman 592221 592221 Barker, Thomas, of Westacre, yeoman 0
4702540 2266207 2266207 defendant Osteler Ralph husbandman 592221 592221 Osteler, Ralph, of Westacre, husbandman 0
4716132 2270352 2270352 defendant Stroute Simon yeoman 592221 592221 Stroute, Simon, of Westacre, yeoman 0
4753857 2281585 2281585 defendant Smyth Henry smith 592221 592221 Smyth, Henry, of Westacre, smith 0
4754243 2281706 2281706 plaintiff Wryght Thomas fuller 592221 592221 Wryght, Thomas, of Westacre, fuller, on his own account 0
4754244 2281706 2281706 defendant Cook John fuller 592221 592221 Cook, John, of Westacre, fuller 0
4762520 2284260 2284260 defendant Prest Nicholas husbandman 592221 592221 Prest, Nicholas, of Westacre, husbandman 2
4798751 2295788 2295788 defendant Fermory Richard yeoman 592221 592221 Fermory, Richard, of Westacre, yeoman 0
4807312 2298482 2298482 defendant Barker Thomas husbandman 592221 592221 Barker, Thomas, of Westacre, husbandman 2
4809475 2299137 2299137 defendant Barkere William yeoman 592221 592221 Barkere, William, of Westacre, yeoman 1
4833419 2306459 2306459 defendant Alday Geoffrey husbandman 592221 592221 Alday, Geoffrey, of Westacre, husbandman 0
4845055 2309970 2309970 defendant Claghton John husbandman 592221 592221 Claghton, John, of Westacre, husbandman 1
4874522 2318974 2318974 defendant Barkere Thomas yeoman 592221 592221 Barkere, Thomas, of Westacre, yeoman 3
4881518 2321123 2321123 plaintiff Wryght William   592221 592221 Wryght, William, of Westacre 0
4930105 2335823 2335823 defendant of Hoo Robert shoemaker 592221 592221 of Hoo, Robert, of Westacre, shoemaker 0
4945525 2340579 2340579 defendant Lucy Richard husbandman 592221 592221 Lucy, Richard, of Westacre, husbandman 0
5011166 2360119 2360119 defendant Yonge Adam shoemaker 592221 592221 Yonge, Adam, of Westacre, shoemaker 0
5011168 2360119 2360119 defendant Wrenche John laborer 592221 592221 Wrenche, John, of Westacre, laborer 2
5094515 2384803 2384803 defendant Pye John husbandman 592221 592221 Pye, John, of Westacre, husbandman 3
5102564 2387157 2387157 defendant Clubbe William husbandman 592221 592221 Clubbe, William, of Westacre, husbandman 0
5121571 2392741 2392741 defendant Smyth Walter smith 592221 592221 Smyth, Walter, of Westacre, smith 0
5136739 2397267 2397267 defendant Carleton Richard yeoman 592221 592221 Carleton, Richard, of Westacre, yeoman 0
5159426 2403874 2403874 defendant Pye John yeoman 592221 592221 Pye, John, of Westacre, yeoman 1
5177421 2409093 2409093 defendant Farewell Nicholas yeoman 592221 592221 Farewell, Nicholas, of Westacre, yeoman 1
5198094 2415186 2415186 defendant Smyth Walter smith 592221 592221 Smyth, Walter, of Westacre, smith 1
5211207 2419007 2419007 defendant Farewell Nicholas husbandman 592221 592221 Farewell, Nicholas, of Westacre, husbandman 0
5211210 2419007 2419007 defendant Smyth Walter smith 592221 592221 Smyth, Walter, of Westacre, smith 3
5232351 2425036 2425036 defendant Smyth Walter husbandman 592221 592221 Smyth, Walter, of Westacre, husbandman 4
5232366 2425038 2425038 defendant Smyth Walter husbandman 592221 592221 Smyth, Walter, of Westacre, husbandman 4
5244597 2428602 2428602 defendant Clubbe William yeoman or bailiff 592221 592221 Clubbe, William, of Westacre, yeoman or bailiff 0
5246090 2429021 2429021 defendant Reynham William fuller 592221 592221 Reynham, William, of Westacre, fuller 3
5265678 2435019 2435019 plaintiff Tempyl Alan   592221 592221 Tempyl, Alan, of Westacre 0
5265692 2435023 2435023 plaintiff Tempyll Alan   592221 592221 Tempyll, Alan, of Westacre 0
5294816 2443469 2443469 plaintiff Temple Alan   592221 592221 Temple, Alan, of Westacre 0
5294819 2443470 2443470 plaintiff Temple Alan   592221 592221 Temple, Alan, of Westacre 0
5294822 2443471 2443471 plaintiff Temple Alan husbandman 592221 592221 Temple, Alan, of Westacre, husbandman 0
5294825 2443472 2443472 plaintiff Temple Alan husbandman 592221 592221 Temple, Alan, of Westacre, husbandman 0
5307189 2447151 2447151 plaintiff Palle Richard   592221 592221 Palle, Richard, of Westacre, prior 0
5307191 2447152 2447152 plaintiff (not given) Richard prior of Palle 592221 592221 Palle, Richard, of Westacre, prior of the house & church of the BM and all Saints 0
5309773 2447957 2447957 plaintiff Temple Alan   592221 592221 Temple, Alan, of Westacre 0
5326961 2453138 2453138 plaintiff Temple Alan   592221 592221 Temple, Alan, of Westacre 0
5343267 2458088 2458088 defendant Yong Adam yeoman 592221 592221 Yong, Adam, of Westacre, yeoman 2
5343268 2458088 2458088 defendant Candeler Simon husbandman 592221 592221 Candeler, Simon, of Westacre, husbandman 3
5345411 2458736 2458736 defendant Faxwell John miller 592221 592221 Faxwell, John, of Westacre, miller 0
5353959 2461301 2461301 defendant Farwell Nicholas weaver 592221 592221 Farwell, Nicholas, of Westacre, weaver 0
5374508 2467631 2467631 plaintiff Palle Richard   592221 592221 Palle, Richard, of Westacre, prior 0
5374511 2467632 2467632 plaintiff (not given) Richard prior of Palle 592221 592221 Palle, Richard, of Westacre, prior of the church of the Blessed Mary & All Saints 0
5374513 2467633 2467633 plaintiff (not given) Richard prior of Palle 592221 592221 Palle, Richard, of Westacre, prior of the church of the Blessed Mary & All saints 0
5374516 2467633 2467633 defendant Batemen John husbandman 592221 592221 Batemen, John, of Westacre, husbandman 2
5374517 2467634 2467634 plaintiff (not given) Richard prior of Palle 592221 592221 Palle, Richard, of Westacre, prior of the church of the Blessed Mary & All Saints 0
5374520 2467635 2467635 plaintiff (not given) Richard prior of Palle 592221 592221 Palle, Richard, of Westacre, prior of the church of the Blessed Mary & All Saints 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);