names

132 rows where place_id = 638375

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3842123 1971087 1971087 plaintiff Bradshawe Roger   638375 638375 Bradshawe, Roger, of Ludlow 0
3858530 1976333 1976333 plaintiff Dyer Margaret widow 638375 638375 Dyer, Margaret, of Ludlow, widow 1
3874255 1981609 1981609 defendant Hoke Walter chaplain 638375 638375 Hoke, Walter, of Ludlow, chaplain 0
3915376 1995511 1995511 plaintiff Crowther Lewis merchant 638375 638375 Crowther, Lewis, of Ludlow, merchant 0
3940635 2003874 2003874 defendant ap Howell Mathew cooper 638375 638375 ap Howell, Mathew, of Ludlow, cooper 0
3980611 2017829 2017829 defendant Rawlyns John saddler 638375 638375 Rawlyns, John, of Ludlow, saddler 0
4105180 2062126 2062126 defendant Rawlyns William weaver 638375 638375 Rawlyns, William, of Ludlow, weaver 0
4166783 2083877 2083877 defendant Mynton Howell tailor 638375 638375 Mynton, Howell, of Ludlow, tailor 0
4289210 2126196 2126196 defendant Bayley Richard mercer 638375 638375 Bayley, Richard, of Ludlow, mercer 1
4319037 2136774 2136774 defendant Phyllyps William (legal representative) 638375 638375 Phyllyps, William, of Ludlow ,gent, executors of 0
4356936 2149659 2149659 defendant Shrawley Thomas chapman 638375 638375 Shrawley, Thomas, of Ludlow, chapman 0
4414224 2169358 2169358 plaintiff Cordewaner John le   638375 638375 Cordewaner, John le, of Ludlow, son of Reginald 0
4414225 2169358 2169358 defendant Cleo William de la (legal representative) 638375 638375 Cleo, William de la, of Ludlow, merchant, executrix of 0
4414226 2169358 2169358 defendant Cleo Agnes de la   638375 638375 Cleo, Agnes de la, of Ludlow, formerly wife of William 1
4416816 2170129 2170129 defendant Sawyere Richard le   638375 638375 Sawyere, Richard le, of Ludlow 0
4416818 2170129 2170129 defendant Goldsmyth Emma le   638375 638375 Goldsmyth, Emma le, of Ludlow, formerly wife of Richard 2
4417242 2170274 2170274 defendant Saleburs John de merchant 638375 638375 Saleburs, John de, of Ludlow, merchant 0
4420832 2171411 2171411 defendant Shrosebury John   638375 638375 together with Shrosebury, John, of Ludlow 2
4425175 2172703 2172703 defendant Orleton William de, senior   638375 638375 Orleton, William de, senior, of Ludlow 0
4426400 2173066 2173066 plaintiff Orm John   638375 638375 Orm, John, of Ludlow 0
4427089 2173293 2173293 plaintiff Qorne Richard de   638375 638375 Qorne, Richard de, of Ludlow 0
4427468 2173427 2173427 plaintiff Salop John de   638375 638375 Salop, John de, of Ludlow 0
4427471 2173428 2173428 defendant Deyere Roger   638375 638375 Deyere, Roger, of Ludlow, son of Agnes, formerly wife of Roger le Deyere 0
4446992 2183974 2183974 defendant Boorton William   638375 638375 Boorton, William, of Ludlow 3
4453835 2186208 2186208 defendant Goldsmyth Henry   638375 638375 Goldsmyth, Henry, of Ludlow 0
4498430 2200159 2200159 defendant Malmeshull John   638375 638375 Malmeshull, John, of Ludlow 0
4498431 2200159 2200159 defendant Malmershull Richard   638375 638375 Malmershull, Richard, of Ludlow 1
4518571 2206181 2206181 defendant Kyngeyn Philip   638375 638375 Kyngeyn, Philip, of Ludlow 0
4518572 2206181 2206181 defendant Broke William   638375 638375 Broke, William, of Ludlow 1
4518575 2206182 2206182 defendant Orleton Thomas   638375 638375 Orleton, Thomas, of Ludlow 0
4518576 2206182 2206182 defendant Dyare Richard   638375 638375 Dyare, Richard, of Ludlow 1
4518707 2206225 2206225 plaintiff Dorewey John   638375 638375 Dorewey, John, of Ludlow 0
4518708 2206225 2206225 defendant Cogges William   638375 638375 Cogges, William, of Ludlow 0
4521820 2207160 2207160 plaintiff Girrus John   638375 638375 Girrus, John, of Ludlow 0
4521821 2207160 2207160 defendant Metyngham John   638375 638375 Metyngham, John, of Ludlow 0
4522018 2207226 2207226 plaintiff Glover William   638375 638375 Glover, William, of Ludlow 0
4531165 2210022 2210022 plaintiff Parys William   638375 638375 Parys, William, of Ludlow 0
4544099 2214069 2214069 plaintiff Barbour Robert   638375 638375 Barbour, Robert, of Ludlow 0
4544100 2214069 2214069 defendant Thongeland Thomas   638375 638375 Thongeland, Thomas, of Ludlow 0
4544102 2214069 2214069 defendant Cogges Willliam butcher 638375 638375 Cogges, Willliam, of Ludlow, butcher 2
4559455 2218906 2218906 plaintiff Mere Thomas   638375 638375 Mere, Thomas, of Ludlow 0
4562068 2219700 2219700 plaintiff Pyrfeld John   638375 638375 Pyrfeld, John, of Ludlow 1
4566730 2221167 2221167 plaintiff Sumnour Roger   638375 638375 Sumnour, Roger, of Ludlow 0
4575010 2223707 2223707 plaintiff Bodenham John   638375 638375 Bodenham, John, of Ludlow 0
4587442 2227475 2227475 defendant Cachepoll Geoffrey skinner 638375 638375 Cachepoll, Geoffrey, of Ludlow, skinner 2
4595369 2229804 2229804 defendant Boraston William   638375 638375 Boraston, William, of Ludlow 0
4599132 2230942 2230942 plaintiff Steventon Isabel   638375 638375 Steventon, Isabel, of Ludlow, formerly wife of Thomas 0
4603065 2232170 2232170 defendant Typper Thomas   638375 638375 Typper, Thomas, of Ludlow 1
4603303 2232233 2232233 defendant Wynde Nicholas   638375 638375 Wynde, Nicholas, of Ludlow 0
4611032 2234521 2234521 plaintiff Sibbeton Richard   638375 638375 Sibbeton, Richard, of Ludlow 1
4611037 2234521 2234521 defendant Shakyll Richard baker 638375 638375 (Shakyll, Richard, of Ludlow, baker 4
4612954 2235110 2235110 defendant Orleton Thomas   638375 638375 Orleton, Thomas, of Ludlow 5
4616040 2236018 2236018 defendant Tyler David   638375 638375 Tyler, David, of Ludlow 0
4622351 2237970 2237970 plaintiff Lourence John, sen draper 638375 638375 Lourence, John, sen, of Ludlow, draper 0
4622352 2237970 2237970 plaintiff Cockus Thomas draper 638375 638375 Cockus, Thomas, of Ludlow, draper 1
4623492 2238323 2238323 plaintiff Merwall Roger   638375 638375 Merwall, Roger, of Ludlow 0
4623493 2238323 2238323 defendant Metyngham John dyer 638375 638375 Metyngham, John, of Ludlow, dyer 0
4626810 2239326 2239326 plaintiff Radenore John   638375 638375 Radenore, John, of Ludlow 0
4628235 2239758 2239758 defendant Herdeley Henry   638375 638375 Herdeley, Henry, of Ludlow 0
4639541 2243076 2243076 defendant Metyngham John dyer 638375 638375 Metyngham, John, of Ludlow, dyer 0
4639720 2243128 2243128 defendant Glovere Wilaim merchant 638375 638375 Glovere, Wilaim, of Ludlow, merchant 0
4640121 2243227 2243227 defendant Clove John shoemaker 638375 638375 Clove, John, of Ludlow, shoemaker 3
4640122 2243227 2243227 defendant Baker John   638375 638375 Baker, John, of Ludlow 4
4645069 2244627 2244627 defendant Bedeston John   638375 638375 Bedeston, John, of Ludlow 0
4645931 2244883 2244883 plaintiff Parys William   638375 638375 Parys, William, of Ludlow 0
4649194 2245815 2245815 defendant Tukke Richard   638375 638375 Tukke, Richard, of Ludlow 0
4671610 2256768 2256768 defendant Mere Robert vintner 638375 638375 Mere, Robert, of Ludlow, vintner 0
4696637 2264426 2264426 plaintiff Chamberleyn John   638375 638375 Chamberleyn, John, of Ludlow 0
4696638 2264426 2264426 defendant More Robert vintner 638375 638375 More, Robert, of Ludlow, vintner 0
4700579 2265591 2265591 defendant (not given) Hugh prior of Ferour 638375 638375 Ferour, Hugh, of Ludlow, prior of St John's hospital 0
4706394 2267382 2267382 defendant Glovere William husbandman 638375 638375 Glovere, William, of Ludlow, husbandman 0
4706395 2267382 2267382 defendant Bedeston John baker 638375 638375 Bedeston, John, of Ludlow, baker 1
4715132 2270059 2270059 defendant Vawer John weaver 638375 638375 Vawer, John, of Ludlow, weaver 0
4719692 2271506 2271506 plaintiff Bolleston Thomas   638375 638375 Bolleston, Thomas, of Ludlow 0
4719693 2271506 2271506 defendant Sybedon John (legal representative) 638375 638375 Sybedon, John, of Ludlow, executors of 0
4719694 2271506 2271506 defendant Tope Thomas butcher 638375 638375 (Tope, Thomas, of Ludlow, butcher 1
4719695 2271506 2271506 defendant Bury William butcher 638375 638375 Bury, William, of Ludlow, butcher 2
4724514 2272965 2272965 defendant Bridewode Thomas gardeman 638375 638375 Bridewode, Thomas, of Ludlow, gardeman 0
4727586 2273868 2273868 defendant Heyton John yeoman 638375 638375 Heyton, John, of Ludlow, yeoman 0
4742687 2278370 2278370 defendant Mere Robert taverner 638375 638375 Mere, Robert, of Ludlow, taverner 0
4756479 2282395 2282395 defendant Herdley Henry gent 638375 638375 Herdley, Henry, of Ludlow, gent 1
4756501 2282400 2282400 defendant Skynner John skinner 638375 638375 Skynner, John, of Ludlow, skinner 3
4757013 2282563 2282563 defendant Brouderer John embroiderer 638375 638375 Brouderer, John, of Ludlow, embroiderer 0
4757014 2282563 2282563 defendant Breyghnok John weaver 638375 638375 Breyghnok, John, of Ludlow, weaver 1
4760205 2283543 2283543 defendant Colewall John vintner 638375 638375 Colewall, John, of Ludlow, vintner 0
4762245 2284172 2284172 defendant Hatton William gent 638375 638375 Hatton, William, of Ludlow, gent 0
4762246 2284172 2284172 defendant Cole Thomas weaver 638375 638375 Cole, Thomas, of Ludlow, weaver 1
4762247 2284172 2284172 defendant Chamburleyn Thomas walker 638375 638375 Chamburleyn, Thomas, of Ludlow, walker 2
4762248 2284172 2284172 defendant Broun John butcher 638375 638375 Broun, John, of Ludlow, butcher 3
4764245 2284809 2284809 plaintiff Hatton John   638375 638375 Hatton, John, of Ludlow 0
4764246 2284809 2284809 defendant Tippe William mercer 638375 638375 Tippe, William, of Ludlow, mercer 0
4764247 2284810 2284810 plaintiff Hatton John   638375 638375 Hatton, John, of Ludlow 0
4766361 2285469 2285469 defendant Gardyner Geoffrey tailor 638375 638375 Gardyner, Geoffrey, of Ludlow, tailor 2
4767873 2285926 2285926 plaintiff Merewall Walter walker 638375 638375 Merewall, Walter, of Ludlow, walker 0
4768147 2286010 2286010 plaintiff More John mercer 638375 638375 More, John, of Ludlow, mercer 0
4768207 2286028 2286028 plaintiff Morewall Walter walker 638375 638375 Morewall, Walter, of Ludlow, walker 0
4774233 2287922 2287922 defendant Hatton John butcher 638375 638375 Hatton, John, of Ludlow, butcher 0
4774922 2288152 2288152 defendant Cole Thomas weaver 638375 638375 Cole, Thomas, of Ludlow, weaver 0
4774923 2288152 2288152 defendant Meriwale Walter walker 638375 638375 Meriwale, Walter, of Ludlow, walker 1
4774924 2288152 2288152 defendant Langford John waler 638375 638375 Langford, John, of Ludlow, waler 2

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