names

247 rows where place_id = 589186

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596837 1866646 1866646 defendant Hayward William yeoman 589186 589186 Hayward, William, of Halstede, yeoman 1
3601375 1868093 1868093 defendant Bragge William husbandman 589186 589186 Bragge, William, of Halstede, husbandman 0
3601376 1868093 1868093 defendant Hychecok John husbandman 589186 589186 Hychecok, John, of Halstede, husbandman 1
3602251 1868368 1868368 defendant Ussher Thomas husbandman 589186 589186 Ussher, Thomas, of Halstede, husbandman 1
3603949 1868904 1868904 defendant Hichekok John husbandman 589186 589186 Hichekok, John, of Halstede, husbandman 0
3620456 1873974 1873974 defendant White Robert panier maker 589186 589186 White, Robert, of Halstede, panier maker 0
3740850 1938996 1938996 defendant Letyll John yeoman 589186 589186 Letyll, John, of Halstede, yeoman 1
3740851 1938996 1938996 defendant Humfrey Richard husbandman 589186 589186 Humfrey, Richard, of Halstede, husbandman 2
3740852 1938996 1938996 defendant Redesdale Robert husbandman 589186 589186 Redesdale, Robert, of Halstede, husbandman 3
4431053 2174470 2174470 defendant Tanner John   589186 589186 Tanner, John, of Halstede 2
4441201 2182177 2182177 defendant Stynt John esq 589186 589186 Stynt, John, of Halstede, esq 1
4441205 2182178 2182178 defendant Stynt John esq 589186 589186 Stynt, John, of Halstede, esq 1
4441209 2182179 2182179 defendant Stynt John   589186 589186 Stynt, John, of Halstede, esquire 1
4475281 2192950 2192950 defendant Cosham William   589186 589186 Cosham, William, of Halstede 1
4482069 2195104 2195104 plaintiff Martyn Robert clerk 589186 589186 Martyn, Robert, of Halstede, son of Horeham, Amy Horeham, sister of John Horsham, clerk 0
4492704 2198419 2198419 defendant Dyere John   589186 589186 Dyere, John, of Halstede 0
4497725 2199931 2199931 plaintiff Edmond William   589186 589186 Edmond, William, of Halstede 0
4505293 2202185 2202185 defendant Flexher Richard   589186 589186 Flexher, Richard, of Halstede, son of Robert 0
4511168 2203943 2203943 defendant Childe William   589186 589186 Childe, William, of Halstede 0
4511176 2203944 2203944 defendant Childe William   589186 589186 Childe, William, of Halstede 0
4515443 2205245 2205245 defendant Anncel John   589186 589186 Anncel, John, of Halstede 0
4515903 2205396 2205396 defendant Clerk John   589186 589186 Clerk, John, of Halstede 0
4520401 2206724 2206724 plaintiff fitz Nichole John   589186 589186 fitz Nichole, John, of Halstede 0
4520518 2206767 2206767 defendant Cokes Rose   589186 589186 Cokes, Rose, of Halstede 0
4532345 2210384 2210384 plaintiff Prentys John   589186 589186 Prentys, John, of Halstede 0
4542082 2213416 2213416 defendant Goldsmyth John   589186 589186 Goldsmyth, John, of Halstede 1
4551108 2216289 2216289 defendant Blamester John   589186 589186 Blamester, John, of Halstede 0
4561003 2219394 2219394 defendant Sewale John   589186 589186 Sewale, John, of Halstede 1
4562854 2219943 2219943 plaintiff Pycot Alice   589186 589186 Pycot, Alice, of Halstede 0
4562855 2219943 2219943 defendant Edmond William   589186 589186 Edmond, William, of Halstede 0
4579253 2224994 2224994 plaintiff Cook Peter   589186 589186 Cook, Peter, of Halstede 0
4587444 2227476 2227476 defendant Crowland Thomas   589186 589186 Crowland, Thomas, of Halstede 0
4587832 2227597 2227597 defendant Dyn William   589186 589186 Dyn, William, of Halstede 1
4598556 2230785 2230785 defendant Myulnere Richard   589186 589186 Myulnere, Richard, of Halstede 2
4601942 2231832 2231832 defendant Seuall John   589186 589186 Seuall, John, of Halstede 2
4607573 2233476 2233476 defendant Gose John   589186 589186 Gose, John, of Halstede 5
4616991 2236321 2236321 plaintiff Gernon John   589186 589186 Gernon, John, of Halstede 0
4616992 2236321 2236321 defendant Webbe John   589186 589186 Webbe, John, of Halstede 0
4629376 2240116 2240116 defendant Crouland Agnes   589186 589186 Crouland, Agnes, of Halstede 3
4631329 2240689 2240689 plaintiff Taverner John   589186 589186 Taverner, John, of Halstede 0
4632234 2240966 2240966 defendant atte Grove Andrew   589186 589186 atte Grove, Andrew, of Halstede 0
4637062 2242397 2242397 defendant Jegon Robert   589186 589186 Jegon, Robert, of Halstede 0
4639790 2243141 2243141 defendant Skilfull John   589186 589186 Skilfull, John, of Halstede 3
4643283 2244142 2244142 plaintiff Idgon or Jegon John   589186 589186 Idgon or Jegon, John, of Halstede 0
4643286 2244142 2244142 defendant atte Wode Walter   589186 589186 atte Wode, Walter, of Halstede 2
4647715 2245389 2245389 defendant Bedell John   589186 589186 Bedell, John, of Halstede 3
4648209 2245541 2245541 defendant Sewall John   589186 589186 Sewall, John, of Halstede 5
4652179 2246621 2246621 plaintiff atte Ree Richard   589186 589186 atte Ree, Richard, of Halstede 0
4652180 2246621 2246621 defendant Baynard Thomas, senior chapman 589186 589186 Baynard, Thomas, senior, of Halstede, chapman 0
4652182 2246622 2246622 plaintiff atte Ree Richard   589186 589186 atte Ree, Richard, of Halstede 0
4652184 2246623 2246623 plaintiff atte Ree Richard   589186 589186 atte Ree, Richard, of Halstede 0
4655842 2247706 2247706 plaintiff Bures William   589186 589186 Bures, William, of Halstede 0
4658690 2248591 2248591 defendant Hervy Ivo fuller 589186 589186 Hervy, Ivo, of Halstede, fuller 0
4658692 2248591 2248591 defendant Page John husbandman 589186 589186 Page, John, of junior, of Halstede, husbandman 2
4661204 2249329 2249329 defendant Noble Thomas draper 589186 589186 Noble, Thomas, of Halstede, draper 3
4664977 2250527 2250527 defendant Legat Silvester fuller 589186 589186 Legat, Silvester, of Halstede, fuller 0
4668134 2255741 2255741 defendant Pygton John fuller 589186 589186 Pygton, John, of Halstede, fuller 0
4668135 2255741 2255741 defendant Skilful John husbandman 589186 589186 Skilful, John, of Halstede, husbandman 1
4668136 2255741 2255741 defendant Gauge or Gange John fuller 589186 589186 Gauge or Gange, John, of Halstede, fuller 2
4668137 2255741 2255741 defendant Yon John fuller 589186 589186 Yon, John, of Halstede, fuller 3
4673279 2257283 2257283 defendant Gauge John fuller 589186 589186 Gauge, John, of Halstede, fuller 3
4679705 2259269 2259269 defendant Bekyngton William   589186 589186 Bekyngton, William, of Halstede, parson 0
4692821 2263264 2263264 defendant Clouyere Robert husbandman 589186 589186 Clouyere, Robert, of Halstede, husbandman 3
4693593 2263497 2263497 plaintiff fitz Nichole Richard   589186 589186 fitz Nichole, Richard, of Halstede 1
4694351 2263733 2263733 defendant Cook Peter yeoman 589186 589186 Cook, Peter, of Halstede, yeoman 2
4697738 2264786 2264786 defendant atte Ree Richard chapman 589186 589186 atte Ree, Richard, of Halstede, chapman 0
4698211 2264926 2264926 defendant Gauge John fuller 589186 589186 Gauge, John, of Halstede, fuller 2
4698766 2265096 2265096 defendant fitz Nichole Richard   589186 589186 fitz Nichole, Richard, of Halstede. gent 0
4700733 2265629 2265629 plaintiff fitz Nichole Ricard   589186 589186 fitz Nichole, Ricard, of Halstede 0
4700735 2265630 2265630 plaintiff fitz Nichole Richard   589186 589186 fitz Nichole, Richard, of Halstede 0
4700739 2265631 2265631 plaintiff fitz Nichole Richard   589186 589186 fitz Nichole, Richard, of Halstede 0
4705012 2266942 2266942 defendant Melle Thomas   589186 589186 Melle, Thomas, of Halstede, shoe maker 1
4709066 2268203 2268203 defendant Skylful John husbandman 589186 589186 Skylful, John, of Halstede, husbandman 1
4712431 2269203 2269203 defendant Whelpsted Thomas husbandman 589186 589186 Whelpsted, Thomas, of Halstede, husbandman 2
4713322 2269492 2269492 defendant Gosse John husbandman 589186 589186 Gosse, John, of Halstede, husbandman 0
4713324 2269492 2269492 defendant Taverner John yeoman 589186 589186 Taverner, John, of Halstede, yeoman 2
4713325 2269492 2269492 defendant atte Ree Richard husbandman 589186 589186 atte Ree, Richard, of Halstede, husbandman 3
4713334 2269493 2269493 defendant Gosse John, sen husbandman 589186 589186 Gosse, John, sen, of Halstede, husbandman 1
4715292 2270116 2270116 defendant Dyere William dyer 589186 589186 Dyere, William, of Halstede, dyer 0
4722521 2272359 2272359 defendant Stoure Adam gent 589186 589186 Stoure, Adam, of Halstede, gent 0
4723257 2272584 2272584 defendant Pychard John yeoman 589186 589186 Pychard, John, of Halstede, yeoman 0
4723259 2272585 2272585 defendant Pychard John yeoman 589186 589186 Pychard, John, of Halstede, yeoman 0
4727853 2273953 2273953 defendant Stoure Adam gent 589186 589186 Stoure, Adam, of Halstede, gent 2
4743710 2278690 2278690 defendant Burys William esq 589186 589186 Burys, William, of Halstede, esq 0
4747852 2279877 2279877 defendant Whepstede Thomas yeoman 589186 589186 Whepstede, Thomas, of Halstede, yeoman 0
4749562 2280354 2280354 defendant Pichard John yeoman 589186 589186 Pichard, John, of Halstede, yeoman 0
4749563 2280354 2280354 defendant Skiful John husbandman 589186 589186 Skiful, John, of Halstede, husbandman 1
4751444 2280904 2280904 defendant Symond John, senior weaver 589186 589186 Symond, John, senior, of Halstede, weaver 0
4751445 2280904 2280904 defendant Symond John, junior weaver 589186 589186 Symond, John, junior, of Halstede, weaver 1
4756431 2282376 2282376 defendant Peldon John barber 589186 589186 Peldon, John, of Halstede, barber 0
4758007 2282879 2282879 defendant Pykston John fuller 589186 589186 Pykston, John, of Halstede, fuller 3
4758008 2282879 2282879 defendant Knyton Robert yeoman 589186 589186 Knyton, Robert, of Halstede, yeoman 4
4761200 2283853 2283853 defendant Pykston John yeoman 589186 589186 Pykston, John, of Halstede, yeoman 1
4761888 2284062 2284062 defendant Clerk John yeoman 589186 589186 Clerk, John, of Halstede, yeoman 0
4762290 2284186 2284186 plaintiff fitz Nichole Richard   589186 589186 fitz Nichole, Richard, of Halstede 0
4763255 2284497 2284497 defendant Page John yeoman 589186 589186 Page, John, of Halstede, yeoman 0
4766542 2285525 2285525 defendant Whepstede Thomas yeoman 589186 589186 Whepstede, Thomas, of Halstede, yeoman 0
4767143 2285710 2285710 defendant Whepstede Thomas husbandman 589186 589186 Whepstede, Thomas, of Halstede, husbandman 0
4771465 2287056 2287056 defendant Taverner John yeoman 589186 589186 Taverner, John, of Halstede, yeoman 1
4771466 2287056 2287056 defendant Bed_ John yeoman 589186 589186 Bed_, John, of Halstede, yeoman 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);