names

127 rows where place_id = 588038

✎ 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
3593165 1865492 1865492 defendant Neweport John weaver 588038 588038 Neweport, John, of Newebury, weaver 0
3617617 1873132 1873132 plaintiff Frere Nicholas (legal representative) 588038 588038 Frere, Nicholas, of Newebury, Verks, clothier, executors of 0
4447103 2184003 2184003 defendant Frence John   588038 588038 Frence, John, of Newebury 3
4447104 2184003 2184003 defendant Bathe John   588038 588038 Bathe, John, of Newebury 4
4455758 2186816 2186816 defendant Mygham William   588038 588038 Mygham, William, of Newebury 0
4455760 2186817 2186817 defendant Sparwe John   588038 588038 Sparwe, John, of Newebury 0
4475540 2193032 2193032 defendant Moth John dyer 588038 588038 Moth, John, of Newebury, dyer 0
4505021 2202105 2202105 defendant Mack John   588038 588038 Mack, John, of Newebury 0
4523947 2207824 2207824 defendant Costrell John   588038 588038 Costrell, John, of Newebury 1
4535672 2211434 2211434 plaintiff Smyth Roger   588038 588038 Smyth, Roger, of Newebury 0
4538980 2212458 2212458 defendant Fissher John   588038 588038 Fissher, John, of Newebury 3
4540734 2213007 2213007 defendant Hayword John   588038 588038 Hayword, John, of Newebury 5
4540766 2213014 2213014 defendant Hayword John   588038 588038 Hayword, John, of Newebury 5
4546329 2214788 2214788 defendant Heyward John fishmonger 588038 588038 Heyward, John, of Newebury, fishmonger 0
4549092 2215651 2215651 defendant Deneman Robert   588038 588038 Deneman, Robert, of Newebury 0
4550718 2216169 2216169 plaintiff Deneman Robert   588038 588038 Deneman, Robert, of Newebury 0
4553171 2216926 2216926 plaintiff Fyssher John   588038 588038 Fyssher, John, of Newebury 0
4556397 2217939 2217939 defendant Motthede Philip or John   588038 588038 Motthede, Philip or John, of Newebury 0
4576376 2224123 2224123 defendant Mothe John   588038 588038 Mothe, John, of Newebury 0
4577931 2224602 2224602 plaintiff Chaump Reginald   588038 588038 Chaump, Reginald, of Newebury 0
4582352 2225923 2225923 defendant Townesende Edward   588038 588038 Townesende, Edward, of Newebury 1
4582353 2225923 2225923 defendant Boure John   588038 588038 Boure, John, of Newebury 2
4606520 2233151 2233151 defendant Bathe John   588038 588038 Bathe, John, of Newebury 0
4606525 2233153 2233153 defendant Tylere Henry   588038 588038 Tylere, Henry, of Newebury 0
4612350 2234932 2234932 plaintiff Coton John   588038 588038 Coton, John, of Newebury 0
4612351 2234932 2234932 defendant Kyppyng William   588038 588038 Kyppyng, William, of Newebury 0
4626472 2239227 2239227 defendant Couper John   588038 588038 Couper, John, of Newebury 5
4629896 2240271 2240271 defendant Hunte John tanner 588038 588038 Hunte, John, of Newebury, tanner 0
4631077 2240615 2240615 defendant Denman John   588038 588038 Denman, John, of Newebury 0
4631078 2240615 2240615 defendant Megge William   588038 588038 Megge, William, of Newebury 1
4640162 2243237 2243237 plaintiff Deneman Robert   588038 588038 Deneman, Robert, of Newebury 0
4640169 2243238 2243238 plaintiff Deneman Robert   588038 588038 Deneman, Robert, of Newebury 0
4640170 2243238 2243238 defendant Wollewynder William   588038 588038 Wollewynder, William, of Newebury 0
4641386 2243574 2243574 defendant Brey Edith   588038 588038 Brey, Edith, of Newebury 3
4660568 2249131 2249131 defendant Crowelond John husbandman 588038 588038 Crowelond, John, of Newebury, husbandman 0
4661660 2249485 2249485 defendant Deneman Thomas merchant 588038 588038 Deneman, Thomas, of Newebury, merchant 0
4668106 2255731 2255731 defendant Goolde John husbandman 588038 588038 Goolde, John, of Newebury, husbandman 0
4676323 2258206 2258206 defendant Goolde John husbandman 588038 588038 Goolde, John, of Newebury, husbandman 0
4678729 2258954 2258954 defendant Goolde John husbandman 588038 588038 Goolde, John, of Newebury, husbandman 0
4687067 2261561 2261561 defendant Irysshe John   588038 588038 Irysshe, John, of Newebury, shepherd 2
4723446 2272643 2272643 plaintiff Deneman Robert (legal representative) 588038 588038 Deneman, Robert, of Newebury, executor of 0
4726246 2273495 2273495 defendant Kyppyng William tanner 588038 588038 Kyppyng, William, of Newebury, tanner 0
4739156 2277339 2277339 defendant Crooke Robert dyer 588038 588038 Crooke, Robert, of Newebury, dyer 0
4739157 2277339 2277339 defendant atte Tounesende Edward husbandman 588038 588038 atte Tounesende, Edward, of Newebury, husbandman 1
4760957 2283770 2283770 plaintiff Deneman Robert (legal representative) 588038 588038 Deneman, Robert, of Newebury, executor of 0
4760960 2283771 2283771 plaintiff Deneman Robert (legal representative) 588038 588038 Deneman, Robert, of Newebury, executor of 0
4784238 2291069 2291069 plaintiff Deneman Robert (legal representative) 588038 588038 Deneman, Robert, of Newebury, executor of 0
4786507 2291825 2291825 defendant Fayrefax Nicholas yeoman 588038 588038 Fayrefax, Nicholas, of Newebury, yeoman 0
4798882 2295824 2295824 defendant Mothe Agnes widow 588038 588038 Mothe, Agnes, of Newebury, widow 2
4819438 2302156 2302156 defendant Smyth John gent 588038 588038 Smyth, John, of Newebury, gent 0
4821212 2302715 2302715 defendant Boldsmyth John yeoman 588038 588038 Boldsmyth, John, of Newebury, yeoman 0
4821213 2302715 2302715 defendant Aston John husbandman 588038 588038 Aston, John, of Newebury, husbandman 1
4822090 2302986 2302986 defendant Hill Thomas fuller 588038 588038 Hill, Thomas, of Newebury, fuller 0
4822091 2302986 2302986 defendant Vyntener John husbandman 588038 588038 Vyntener, John, of Newebury, husbandman 1
4823333 2303383 2303383 defendant Clerk Thomas smith 588038 588038 Clerk, Thomas, of Newebury, smith 0
4853686 2312569 2312569 defendant Tayllour Simon tailor 588038 588038 Tayllour, Simon, of Newebury, tailor 0
4892380 2324354 2324354 defendant Chaundeler Simon chandler 588038 588038 Chaundeler, Simon, of Newebury, chandler 0
4892382 2324355 2324355 defendant Halle William skinner 588038 588038 Halle, William, of Newebury, skinner 0
4892396 2324361 2324361 defendant Chaundeler Simon chandler 588038 588038 Chaundeler, Simon, of Newebury, chandler 0
4940955 2339195 2339195 defendant Halle William skinner 588038 588038 Halle, William, of Newebury, skinner 0
4960716 2345165 2345165 defendant Coteler Thomas mercer 588038 588038 Coteler, Thomas, of Newebury, mercer 0
4970207 2348041 2348041 defendant Hardyng John, junior butcher 588038 588038 Hardyng, John, junior, of Newebury, butcher 4
4981665 2351431 2351431 defendant Fyssher William fisher 588038 588038 Fyssher, William, of Newebury, fisher 0
4986586 2352916 2352916 defendant Haddam john   588038 588038 Haddam, john, of Newebury 0
4999407 2356693 2356693 defendant Bailly Thomas fuller 588038 588038 Bailly, Thomas, of Newebury, fuller 0
5031073 2365961 2365961 defendant Bocher John butcher 588038 588038 Bocher, John, of Newebury, butcher 0
5052683 2372397 2372397 defendant Waldry alias Wevere Vincent husbandman 588038 588038 Waldry alias Wevere, Vincent, of Newebury, husbandman 0
5054864 2373021 2373021 defendant Farman William fuller 588038 588038 Farman, William, of Newebury, fuller 1
5056463 2373513 2373513 plaintiff Catelyn Robert   588038 588038 Catelyn, Robert, of Newebury 0
5061608 2375062 2375062 defendant Cokkes Richard husbandman 588038 588038 Cokkes, Richard, of Newebury, husbandman 0
5069704 2377436 2377436 defendant Adderbury Richard gent 588038 588038 Adderbury, Richard, of Newebury, gent 0
5072882 2378375 2378375 defendant Bradburgh Richard yeoman 588038 588038 Bradburgh, Richard, of Newebury, yeoman 0
5123623 2393367 2393367 defendant Doket John chapman 588038 588038 Doket, John, of Newebury, chapman 4
5125652 2393992 2393992 defendant Kynge John dyer 588038 588038 Kynge, John, of Newebury, dyer 0
5137757 2397553 2397553 defendant Robyns Thomas   588038 588038 Robyns, Thomas, of Newebury 3
5158462 2403595 2403595 defendant Robyns Thomas husbandman 588038 588038 Robyns, Thomas, of Newebury, husbandman 0
5208885 2418323 2418323 defendant Benette Thomas husbandman 588038 588038 Benette, Thomas, of Newebury, husbandman 0
5247384 2429392 2429392 defendant Hasilden Roger husbandman 588038 588038 Hasilden, Roger, of Newebury, husbandman 0
5247385 2429392 2429392 defendant Everyngton Nicholas tanner 588038 588038 Everyngton, Nicholas, of Newebury, tanner 1
5249134 2429867 2429867 defendant Laurens Nicholas fuller 588038 588038 Laurens, Nicholas, of Newebury, fuller 2
5249203 2429890 2429890 defendant Okham Alice widow 588038 588038 Okham, Alice, of Newebury, widow 0
5249205 2429890 2429890 defendant Laurens Nicholas fuller 588038 588038 Laurens, Nicholas, of Newebury, fuller 2
5249206 2429890 2429890 defendant Bayly Thomas fuller 588038 588038 Bayly, Thomas, of Newebury, fuller 3
5259358 2433048 2433048 defendant Forster John fuller 588038 588038 Forster, John, of Newebury, fuller 0
5259359 2433048 2433048 defendant Prentys Richard weaver 588038 588038 Prentys, Richard, of Newebury, weaver 1
5278328 2438765 2438765 plaintiff Bedford John clothmaker 588038 588038 Bedford, John, of Newebury, clothmaker 0
5278330 2438766 2438766 plaintiff Bedford John clothmaker 588038 588038 Bedford, John, of Newebury, clothmaker 0
5288511 2441654 2441654 defendant Smyth John mercer 588038 588038 Smyth, John, of Newebury, mercer 0
5295984 2443812 2443812 defendant Bowyer John miller 588038 588038 Bowyer, John, of Newebury, miller 0
5296729 2444032 2444032 defendant Scathelok Thomas pewterer 588038 588038 Scathelok, Thomas, of Newebury, fuller;Edwar, Richard, of Abendon, pewterer 1
5303210 2445954 2445954 defendant Browene (illegible) chapman 588038 588038 Browene, _, of Newebury, chapman 0
5305694 2446711 2446711 plaintiff Love Thomas   588038 588038 Love, Thomas, of Newebury, kersey man 0
5312923 2448898 2448898 defendant Mason William yeoman 588038 588038 Mason, William, of Newebury, yeoman 1
5322544 2451821 2451821 defendant Kyng John dyer 588038 588038 Kyng, John, of Newebury, dyer 0
5322546 2451821 2451821 defendant Sager William chapman 588038 588038 Sager, William, of Newebury, chapman 2
5351116 2460454 2460454 defendant Mylys Richard weaver 588038 588038 Mylys, Richard, of Newebury, weaver 3
5354269 2461402 2461402 plaintiff Harre Robert draper 588038 588038 Harre, Robert, of Newebury, draper 0
5356343 2462054 2462054 defendant Patryk William smith 588038 588038 Patryk, William, of Newebury, smith 2
5362491 2463921 2463921 defendant Bocher Richard butcher 588038 588038 Bocher, Richard, of Newebury, butcher 1
5395088 2473663 2473663 plaintiff (illegible) Richard mercer 588038 588038 --, Richard, of Newebury, mercer 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);