names

142 rows where place_id = 632055

✎ 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
3804362 1959300 1959300 defendant Hall Ralph gent 632055 632055 Hall, Ralph, of Shirborn, gent 1
3804365 1959301 1959301 defendant Hall Ralph gent 632055 632055 Hall, Ralph, of Shirborn, gent 1
4441520 2182285 2182285 defendant Wynterborn John   632055 632055 Wynterborn, John, of Shirborn 0
4443109 2182806 2182806 defendant Shoyer Peter   632055 632055 Shoyer, Peter, of Shirborn 1
4445457 2183534 2183534 defendant Somenour William   632055 632055 Somenour, William, of Shirborn 0
4445458 2183534 2183534 defendant Showyere Peter   632055 632055 Showyere, Peter, of Shirborn 1
4446789 2183912 2183912 defendant Godfray Richard   632055 632055 Godfray, Richard, of Shirborn 0
4453055 2185964 2185964 defendant Fyssher Walter   632055 632055 Fyssher, Walter, of Shirborn 1
4453060 2185965 2185965 defendant fysshere Walter   632055 632055 fysshere, Walter, of Shirborn 1
4455073 2186589 2186589 defendant Fisshere Walter   632055 632055 Fisshere, Walter, of Shirborn 0
4465987 2190021 2190021 defendant Combe John   632055 632055 Combe, John, of Shirborn 0
4465989 2190022 2190022 defendant Combe John   632055 632055 Combe, John, of Shirborn 0
4467583 2190542 2190542 defendant Dalton William   632055 632055 Dalton, William, of Shirborn 0
4467595 2190542 2190542 defendant Parchementmaker John   632055 632055 Parchementmaker, John, of Shirborn 12
4471519 2191753 2191753 defendant Pauter Henry   632055 632055 Pauter, Henry, of Shirborn 0
4487121 2196697 2196697 defendant Vanne Robert   632055 632055 Vanne, Robert, of Shirborn 0
4496978 2199719 2199719 defendant Brocas Oliver   632055 632055 Brocas, Oliver, of Shirborn 2
4514437 2204931 2204931 defendant Lodewill Walter   632055 632055 Lodewill, Walter, of Shirborn 6
4543170 2213746 2213746 defendant Glovere Walter   632055 632055 Glovere, Walter, of Shirborn 0
4547995 2215305 2215305 defendant Seman John   632055 632055 Seman, John, of Shirborn 1
4561537 2219543 2219543 defendant Noblet John   632055 632055 Noblet, John, of Shirborn 0
4565878 2220884 2220884 defendant Combe Henry   632055 632055 Combe, Henry, of Shirborn 2
4566793 2221182 2221182 defendant Tyler Richard   632055 632055 Tyler, Richard, of Shirborn 0
4576353 2224113 2224113 defendant Scryven John   632055 632055 Scryven, John, of Shirborn 0
4588838 2227884 2227884 defendant Lolyf Robert   632055 632055 Lolyf, Robert, of Shirborn 0
4612544 2234991 2234991 plaintiff Coute William   632055 632055 Coute, William, of Shirborn 0
4615534 2235859 2235859 plaintiff Taillour Reginald   632055 632055 Taillour, Reginald, of Shirborn 2
4625048 2238797 2238797 defendant Gourneys John   632055 632055 Gourneys, John, of Shirborn 2
4638640 2242837 2242837 defendant Baret John   632055 632055 Baret, John, of Shirborn 0
4641157 2243505 2243505 plaintiff Taillour Reginald   632055 632055 Taillour, Reginald, of Shirborn 2
4652558 2246754 2246754 defendant Neuton John baker 632055 632055 Neuton, John, of Shirborn, baker 0
4652559 2246754 2246754 defendant Dunpayn Hugh dyer 632055 632055 Dunpayn, Hugh, of Shirborn, dyer 1
4656896 2248052 2248052 defendant Smyth John, junior   632055 632055 Smyth, John, junior, of Shirborn 10
4658496 2248535 2248535 defendant Ilberd John   632055 632055 Ilberd John, of Shirborn 0
4661897 2249568 2249568 plaintiff Taillour Reginald   632055 632055 Taillour, Reginald, of Shirborn 2
4670985 2256594 2256594 defendant Dunpayn Hugh dyer 632055 632055 Dunpayn, Hugh, of Shirborn, dyer 0
4675219 2257862 2257862 plaintiff Landemote Richard   632055 632055 Landemote, Richard, of Shirborn 1
4675433 2257926 2257926 defendant Draper John draper 632055 632055 Draper, John, of Shirborn, draper 0
4680221 2259424 2259424 plaintiff Legger John (legal representative) 632055 632055 Legger, John, of Shirborn, vicar, executor of 0
4685069 2260930 2260930 defendant Langrygge John yeoman 632055 632055 Langrygge, John, of Shirborn, yeoman 0
4724252 2272880 2272880 defendant Merell Thomas husbandman 632055 632055 Merell, Thomas, of Shirborn, husbandman 0
4724642 2273007 2273007 plaintiff Taillour Reginald   632055 632055 Taillour, Reginald, of Shirborn 2
4724648 2273008 2273008 plaintiff Taillour Reginald   632055 632055 Taillour, Reginald, of Shirborn 2
4731166 2274948 2274948 defendant Preston John chapman 632055 632055 Preston, John, of Shirborn, chapman 0
4735080 2276120 2276120 plaintiff Smyth John   632055 632055 Smyth, John, of Shirborn 0
4735088 2276124 2276124 plaintiff Smyth John, sen   632055 632055 Smyth, John, sen, of Shirborn 0
4735091 2276125 2276125 plaintiff Smyth John, sen   632055 632055 Smyth, John, sen, of Shirborn 0
4735093 2276125 2276125 defendant Langrygg John merchant 632055 632055 Langrygg, John, of Shirborn, merchant 0
4762115 2284133 2284133 defendant Ganeler William butcher 632055 632055 Ganeler, William, of Shirborn, butcher 0
4762117 2284133 2284133 defendant Metford Thomas buther 632055 632055 Metford, Thomas, of Shirborn, buther 2
4763775 2284658 2284658 defendant Cole Robert   632055 632055 Cole, Robert, of Shirborn, bow maker 0
4767390 2285786 2285786 defendant Smyth John smith 632055 632055 Smyth, John, of Shirborn, smith 0
4768636 2286169 2286169 defendant Langrygg John merchant 632055 632055 Langrygg, John, of Shirborn, merchant 0
4771968 2287206 2287206 plaintiff Smyth John, sen   632055 632055 Smyth, John, sen, of Shirborn 0
4771970 2287206 2287206 defendant Palmer Thomas ostler 632055 632055 Palmer, Thomas, of Shirborn, ostler 0
4776103 2288521 2288521 defendant Ilberd John gent 632055 632055 Ilberd, John, of Shirborn, gent 0
4778423 2289231 2289231 defendant Draper Alice   632055 632055 Draper, Alice, of Shirborn, widow of Draper, John 1
4780604 2289931 2289931 defendant Osteler Richard   632055 632055 Osteler, Richard, of Shirborn 0
4780850 2290009 2290009 defendant Hokes William husbandman 632055 632055 Hokes, William, of Shirborn, husbandman 0
4780851 2290009 2290009 defendant Daunce Thomas butcher 632055 632055 Daunce Thomas, of Shirborn, butcher 1
4784488 2291152 2291152 defendant Baily John tanner 632055 632055 Baily, John, of Shirborn, tanner 2
4785577 2291515 2291515 defendant Gaveler William butcher 632055 632055 Gaveler, William, of Shirborn, butcher 0
4785586 2291517 2291517 defendant Metford Thomas butcher 632055 632055 Metford, Thomas, of Shirborn, butcher 0
4787499 2292162 2292162 defendant Cole Robert bowyer 632055 632055 Cole, Robert, of Shirborn, bowyer 0
4791785 2293529 2293529 defendant Stodherd Thomas yeoman 632055 632055 Stodherd, Thomas, of Shirborn, yeoman 0
4791790 2293529 2293529 defendant Cheseman Ralph yeoman 632055 632055 together with Cheseman, Ralph, of Shirborn, yeoman 5
4797168 2295286 2295286 plaintiff Smyth John, senior   632055 632055 Smyth, John, senior, of Shirborn 0
4797170 2295286 2295286 defendant Palmer Thomas ostler 632055 632055 Palmer, Thomas, of Shirborn, ostler 0
4817746 2301635 2301635 defendant Morton William tailor 632055 632055 Morton, William, of Shirborn, tailor 2
4819510 2302180 2302180 defendant Lovell John weaver 632055 632055 Lovell, John, of Shirborn, weaver 0
4831664 2305933 2305933 defendant Draper John draper 632055 632055 Draper, John, of Shirborn, draper 0
4846568 2310436 2310436 defendant Treweman William husbandman 632055 632055 Treweman, William, of Shirborn, husbandman 0
4861379 2314928 2314928 defendant Caylleway John husbandman 632055 632055 Caylleway, John, of Shirborn, husbandman 0
4872546 2318370 2318370 defendant Milward John   632055 632055 Milward, John, of Shirborn, millward 0
4889294 2323438 2323438 defendant Faunteleroy Richard   632055 632055 Faunteleroy, Richard, of Shirborn, franklin 0
4897697 2325946 2325946 defendant Trybell John   632055 632055 Trybell, John, of Shirborn, bailiff 0
4915945 2331483 2331483 defendant Scryveyner John   632055 632055 Scryveyner, John, of Shirborn, parish clerk 0
4919121 2332492 2332492 defendant Pyke John laborer 632055 632055 Pyke, John, of Shirborn, laborer 0
4978542 2350534 2350534 defendant Hastyng John butcher 632055 632055 Hastyng, John, of Shirborn, butcher 0
4979128 2350714 2350714 defendant Rich John husbandman 632055 632055 Rich, John, of Shirborn, husbandman 1
4979129 2350714 2350714 defendant Peny Nicholas husbandman 632055 632055 Peny, Nicholas, of Shirborn, husbandman 2
4994743 2355286 2355286 plaintiff Fowell Richard (legal representative) 632055 632055 Fowell, Richard, of Shirborn, executors of 0
5002756 2357713 2357713 defendant Fowell Richard (legal representative) 632055 632055 Fowell, Richard, of Shirborn, executrix of 4
5087584 2382750 2382750 defendant Derneford John baker 632055 632055 Derneford, John, of Shirborn, baker 0
5089125 2383194 2383194 defendant Myles J- carpenter 632055 632055 Myles, J-, of Shirborn, carpenter 0
5089126 2383194 2383194 defendant Warrewyk William husbandman 632055 632055 Warrewyk, William, of Shirborn, husbandman 1
5089127 2383194 2383194 defendant Doneton J- husbandman 632055 632055 Doneton, J-, of Shirborn, husbandman 2
5089128 2383194 2383194 defendant Merell Thomas husbandman 632055 632055 Merell, Thomas, of Shirborn, husbandman 3
5089132 2383195 2383195 defendant Myles John carpenter 632055 632055 Myles, John, of Shirborn, carpenter 0
5089133 2383195 2383195 defendant Warrewyk William husbandman 632055 632055 Warrewyk, William, of Shirborn, husbandman 1
5089134 2383195 2383195 defendant Boveton or Boneton John husbandman 632055 632055 Boveton or Boneton, John, of Shirborn, husbandman 2
5089135 2383195 2383195 defendant Merell Thomas husbandman 632055 632055 Merell, Thomas, of Shirborn, husbandman 3
5095583 2385132 2385132 defendant Store John cordwainer 632055 632055 Store, John, of Shirborn, cordwainer 0
5123576 2393351 2393351 defendant Brasyer John   632055 632055 Brasyer, John, of Shirborn, millward 0
5123577 2393351 2393351 defendant Knyght William laborer 632055 632055 Knyght, William, of Shirborn, laborer 1
5123578 2393351 2393351 defendant Taillour Robert laborer 632055 632055 Taillour, Robert, of Shirborn, laborer 2
5216514 2420558 2420558 defendant Forax Elias merchant 632055 632055 Forax, Elias, of Shirborn, merchant 0
5225059 2423000 2423000 defendant Hawekyns William (legal representative) 632055 632055 Hawekyns, William, of Shirborn, yeoman, executrix of 0
5225060 2423000 2423000 defendant Hawekyns Alice widow 632055 632055 Hawekyns, Alice, of Shirborn, widow 1
5235250 2425887 2425887 defendant Raake Robert merchant 632055 632055 Raake, Robert, of Shirborn, merchant 4

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