names

77 rows where place_id = 655953

✎ 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
3938190 2003111 2003111 defendant Brokebancke Philip gent 655953 655953 Brokebancke, Philip, of Huntingdon, Hunts, gent 0
3940034 2003684 2003684 defendant Oldemall John gent 655953 655953 Oldemall, John, of Huntingdon, Hunts, gent 5
3942352 2004456 2004456 defendant Browne Thomas draper 655953 655953 Browne, Thomas, of Huntingdon, Hunts, draper 0
3970737 2014356 2014356 defendant Smyth Gilbert yeoman 655953 655953 Smyth, Gilbert, of Huntingdon, Hunts, yeoman 0
3988900 2020773 2020773 defendant Burde Robert chapman 655953 655953 Burde, Robert, of Huntingdon, Hunts, chapman 2
3989271 2020904 2020904 defendant Leylman Thomas glasier 655953 655953 Leylman, Thomas, of Huntingdon, Hunts, glasier 0
3990025 2021185 2021185 defendant Smyth Gilbert yeoman 655953 655953 Smyth, Gilbert, of Huntingdon, Hunts, yeoman 0
3990087 2021208 2021208 defendant Cotsmore Henry vintner 655953 655953 Cotsmore, Henry, of Huntingdon, Hunts, vintner 0
3990533 2021366 2021366 defendant Fetherbye John chapman 655953 655953 Fetherbye, John, of Huntingdon, Hunts, chapman 0
3993915 2022575 2022575 plaintiff Clampe Richard gent 655953 655953 Clampe, Richard, of Huntingdon, Hunts, gent 0
3995454 2023118 2023118 plaintiff Cowper William haberdasher 655953 655953 Cowper, William, of Huntingdon, Hunts, haberdasher 0
3997690 2023929 2023929 defendant Keiche or Keithe John gent 655953 655953 Keiche or Keithe, John, of Huntingdon, Hunts, gent 0
4004961 2026556 2026556 defendant Fetherbye John chapman 655953 655953 Fetherbye, John, of Huntingdon, Hunts, chapman 0
4007357 2027411 2027411 defendant Lamkyn William yeoman or pewterer 655953 655953 Lamkyn, William, of Huntingdon, Hunts, yeoman or pewterer 0
4015104 2030092 2030092 defendant Horwood Walter yeoman 655953 655953 Horwood, Walter, of Huntingdon, Hunts, yeoman 0
4023489 2033111 2033111 plaintiff Barton Stephen tailor 655953 655953 Barton, Stephen, of Huntingdon, Hunts, tailor 0
4023491 2033112 2033112 plaintiff Barton Stephen tailor 655953 655953 Barton, Stephen, of Huntingdon, Hunts, tailor 0
4030532 2035577 2035577 defendant Smyth Gilbert brewer 655953 655953 Smyth, Gilbert, of Huntingdon, Hunts, yeoman, brewer 0
4037531 2038085 2038085 plaintiff Keyche John gent 655953 655953 Keyche, John, of Huntingdon, Hunts, gent 0
4037533 2038086 2038086 plaintiff Keyche John gent 655953 655953 Keyche, John, of Huntingdon, Hunts, gent 0
4099649 2060198 2060198 defendant Rychard John gent 655953 655953 Rychard, John, of Huntingdon, Hunts, gent 2
4106462 2062602 2062602 defendant Lamkyn William pewterer 655953 655953 Lamkyn, William, of Huntingdon, Hunts, pewterer 1
4123220 2068606 2068606 defendant Edward William chapman 655953 655953 Edward, William, of Huntingdon, Hunts, chapman 0
4145869 2076711 2076711 defendant Edward William   655953 655953 Edward, William, of Huntingdon, Hunts 0
4192253 2092853 2092853 defendant Cottesmore Henry vintner 655953 655953 Cottesmore, Henry, of Huntingdon, Hunts, vintner 0
4198792 2095138 2095138 defendant Levens William yeoman 655953 655953 Levens, William, of Huntingdon, Hunts, yeoman 1
4241349 2110092 2110092 defendant Canne John weaver 655953 655953 Canne, John, of Huntingdon, Hunts, weaver 0
4241353 2110093 2110093 defendant Canne John weaver 655953 655953 Canne, John, of Huntingdon, Hunts, weaver 0
4340533 2143954 2143954 defendant Slade Isabel widow 655953 655953 Slade, Isabel, of Huntingdon, Hunts, widow 1
4344023 2145188 2145188 defendant Wylk William clothier 655953 655953 Wylk, William, of Huntingdon, Hunts, or of Coventry, clothier 0
4365584 2152756 2152756 defendant Johnson Thomas chapman 655953 655953 Johnson, Thomas, of Huntingdon, Hunts, chapman 2
4380356 2158080 2158080 defendant Bellingham Nicholas vintner 655953 655953 Bellingham, Nicholas, of Huntingdon, Hunts, or of Peterborough, vintner 0
4651504 2246474 2246474 defendant Lauerens Robert gent 655953 655953 Lauerens, Robert, of Huntingdon, Hunts, gent 0
4651506 2246475 2246475 defendant Lauerens Robert gent 655953 655953 Lauerens, Robert, of Huntingdon, Hunts, gent 0
4690049 2262440 2262440 defendant Bikkele John drover 655953 655953 Bikkele, John, of Huntingdon, Hunts, drover 1
4691741 2262949 2262949 defendant Chaumberlayn Roger gent 655953 655953 Chaumberlayn, Roger, of Huntingdon, Hunts, gent 0
4693377 2263431 2263431 defendant Stokesley Thomas hostler 655953 655953 Stokesley, Thomas, of Huntingdon, Hunts, hostler 1
4702664 2266237 2266237 defendant Chambirleyn Roger ostler 655953 655953 Chambirleyn, Roger, of Huntingdon, Hunts, ostler 1
4702679 2266239 2266239 defendant Chambirleyn Roger ostler 655953 655953 Chambirleyn, Roger, of Huntingdon, Hunts, ostler 1
4708633 2268075 2268075 defendant Gregory Margaret widow 655953 655953 Gregory, Margaret, of Huntingdon, Hunts, widow 0
4712362 2269182 2269182 defendant Goche William yeoman 655953 655953 Goche, William, of Huntingdon, Hunts, yeoman 1
4713652 2269592 2269592 defendant Delhay Peter yeoman 655953 655953 Delhay, Peter, of Huntingdon, Hunts, yeoman 0
4715549 2270193 2270193 defendant Bron Thomas   655953 655953 Bron, Thomas, of Huntingdon, Hunts, school master 1
4720966 2271889 2271889 defendant Colet Richard hosteller 655953 655953 Colet, Richard, of Huntingdon, Hunts, hosteller 0
4732901 2275468 2275468 defendant Holgrave Thomas yeoman 655953 655953 Holgrave, Thomas, of Huntingdon, Hunts, yeoman 0
4741184 2277923 2277923 defendant Gregory John spicer 655953 655953 Gregory, John, of Huntingdon, Hunts, spicer 0
4753192 2281381 2281381 defendant Forster Thomas yeoman 655953 655953 (Forster, Thomas, of Huntingdon, Hunts, yeoman 8
4805232 2297836 2297836 defendant Pekke Robert gent 655953 655953 Pekke, Robert, of Huntingdon, Hunts, gent 0
4813768 2300417 2300417 defendant Pekke Robert   655953 655953 Pekke, Robert, of Huntingdon, Hunts, burgess & ostler 0
4814262 2300565 2300565 defendant Pekke Robert gent 655953 655953 Pekke, Robert, of Huntingdon, Hunts, gent 0
4823001 2303275 2303275 defendant Pecke Robert gent 655953 655953 Pecke, Robert, of Huntingdon, Hunts, gent 0
4824853 2303810 2303810 defendant Charwalten Thomas gent 655953 655953 Charwalten, Thomas, of Huntingdon, Hunts, gent 0
4829778 2305360 2305360 defendant Chapman John master & notary 655953 655953 Chapman, John, of Huntingdon, Hunts, master & notary 1
4832148 2306084 2306084 defendant Charwalton Thomas gent 655953 655953 Charwalton, Thomas, of Huntingdon, Hunts, gent 0
4834683 2306850 2306850 defendant Smyth Roger smith 655953 655953 Smyth, Roger, of Huntingdon, Hunts, smith 0
4840451 2308551 2308551 defendant Pekke John gent 655953 655953 Pekke, John, of Huntingdon, Hunts, gent 0
4849640 2311367 2311367 defendant Smyth William smith 655953 655953 Smyth, William, of Huntingdon, Hunts, smith 0
4908118 2329097 2329097 plaintiff Andrewe John   655953 655953 Andrewe, John, of Huntingdon, Hunts, notary 0
4919249 2332531 2332531 defendant Teuslond or Tonslond John chapman 655953 655953 Teuslond or Tonslond, John, of Huntingdon, Hunts, chapman 0
4993245 2354858 2354858 defendant Oklay Edmund   655953 655953 Oklay, Edmund, of Huntingdon, Hunts, holy water clerk 5
4999503 2356724 2356724 defendant Westwyk John hosteler 655953 655953 Westwyk, John, of Huntingdon, Hunts, hosteler 0
5100765 2386648 2386648 defendant Bagley Edmund butcher 655953 655953 Bagley, Edmund, of Huntingdon, Hunts, butcher 1
5145684 2399880 2399880 defendant Oswestyr Peter draper & hosier 655953 655953 Oswestyr, Peter, of Huntingdon, Hunts, draper & hosier 2
5161477 2404457 2404457 defendant Raad William smith 655953 655953 Raad, William, of Huntingdon, Hunts, smith 0
5165956 2405787 2405787 defendant Cholny William tailor 655953 655953 Cholny, William, of Huntingdon, Hunts, tailor 1
5302490 2445714 2445714 defendant Morton Robert clerk 655953 655953 Morton, Robert, of Huntingdon, Hunts, clerk 0
5375495 2467924 2467924 defendant Mott Richard husbandman 655953 655953 Mott, Richard, of Huntingdon, Hunts, husbandman 1
5399456 2474922 2474922 defendant Wodesared John baker 655953 655953 Wodesared, John, of Huntingdon, Hunts, baker 0
5403731 2476139 2476139 defendant Frelave Thomas yeoman 655953 655953 Frelave, Thomas, of Huntingdon, Hunts, yeoman 1
5406728 2476990 2476990 defendant Smyth William tailor 655953 655953 Smyth, William, of Huntingdon, Hunts, tailor 4
5420735 2481127 2481127 defendant (illegible) John innholder 655953 655953 _, John, of Huntingdon, Hunts, innholder 2
5433547 2484997 2484997 defendant Wodward John baker 655953 655953 Wodward, John, of Huntingdon, Hunts, baker 0
5433790 2485074 2485074 defendant Frelove Thomas yeoman 655953 655953 Frelove, Thomas, of Huntingdon, Hunts, yeoman 1
5439671 2486806 2486806 defendant _gh John innholder 655953 655953 _gh, John, of Huntingdon, Hunts, innholder 2
5476775 2498056 2498056 defendant Chixsam Richard innholder 655953 655953 Chixsam, Richard, of Huntingdon, Hunts, innholder 1
5562348 2523588 2523588 defendant Horwod John saddler 655953 655953 Horwod, John, of Huntingdon, Hunts, saddler 0
5562703 2523682 2523682 defendant Horwod John saddler 655953 655953 Horwod, John, of Huntingdon, Hunts, saddler 0

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