names

90 rows where place_id = 603924

✎ 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
3656244 1912200 1912200 defendant Elkyn Thomas laborer 603924 603924 Elkyn, Thomas, of Henham, laborer 1
3656245 1912200 1912200 defendant spycer John husbandman 603924 603924 spycer, John, of Henham, husbandman 2
3656246 1912200 1912200 defendant Hichman John husbandman 603924 603924 Hichman, John, of Henham, husbandman 3
3658507 1912912 1912912 defendant Spycer John husbandman 603924 603924 Spycer, John, of Henham, husbandman 2
3668732 1916155 1916155 defendant Glascok Henry butcher 603924 603924 Glascok, Henry, of Henham, butcher 0
3694495 1924484 1924484 defendant Hawe Christopher gent 603924 603924 Hawe, Christopher, of Henham, gent 0
3700902 1926528 1926528 defendant Turnour Richard carpenter 603924 603924 Turnour, Richard, of Henham, carpenter 1
3700906 1926529 1926529 defendant Turnour Richard carpenter 603924 603924 Turnour, Richard, of Henham, carpenter 1
3718805 1932162 1932162 defendant Woodley William husbandman 603924 603924 Woodley, William, of Henham, husbandman 0
3730960 1935915 1935915 defendant Kyng Thomas clerk 603924 603924 Kyng, Thomas, of Henham, clerk 0
3734548 1937051 1937051 defendant Want John yeoman 603924 603924 Want, John, of Henham, yeoman 0
3734549 1937051 1937051 defendant Rawley John husbandman 603924 603924 Rawley, John, of Henham, husbandman 1
3739770 1938651 1938651 defendant Brandon Robert (legal representative) 603924 603924 Brandon, Robert, of Henham, knight, executors of 0
3739774 1938652 1938652 defendant Inglous or Inglons John esq 603924 603924 (Inglous or Inglons, John, of Henham, esq 1
3741838 1939312 1939312 defendant Tunbredge John husbandman 603924 603924 Tunbredge, John, of Henham, husbandman 0
3758820 1944746 1944746 defendant Glascok Henry butcher 603924 603924 Glascok, Henry, of Henham, butcher 2
3761468 1945599 1945599 defendant Leke Reginald husbandman 603924 603924 Leke, Reginald, of Henham, husbandman 0
3762462 1945902 1945902 defendant Wodley William husbandman 603924 603924 Wodley, William, of Henham, husbandman 0
3762463 1945903 1945903 plaintiff Glascok Henry husbandman 603924 603924 Glascok, Henry, of Henham, husbandman 0
3762464 1945903 1945903 defendant Woodley William husbandman 603924 603924 Woodley, William, of Henham, husbandman 0
3773961 1949572 1949572 defendant Clerke Thomas husbandman 603924 603924 Clerke, Thomas, of Henham, husbandman 1
3779340 1951260 1951260 defendant Barker Thomas husbandman 603924 603924 Barker, Thomas, of Henham, husbandman 2
3787324 1953827 1953827 defendant Symonde John butcher 603924 603924 Symonde, John, of Henham, butcher 0
3789117 1954404 1954404 defendant Mannesfeld Robert yeoman 603924 603924 Mannesfeld, Robert, of Henham, yeoman 1
3802224 1958589 1958589 defendant Hechym John miller 603924 603924 Hechym, John, of Henham, miller 1
3811538 1961504 1961504 defendant More William mercer 603924 603924 More, William, of Henham, mercer 0
3878641 1983102 1983102 defendant Wodley Richard, junior husbandman 603924 603924 Wodley, Richard, junior, of Henham, husbandman 0
3889353 1986670 1986670 defendant Glascok John butcher 603924 603924 Glascok, John, of Henham, butcher 1
3889354 1986670 1986670 defendant Spycer John butcher 603924 603924 Spycer, John, of Henham, butcher 2
3910207 1993728 1993728 defendant Glascok John butcher 603924 603924 Glascok, John, of Henham, butcher 0
3913306 1994783 1994783 defendant Woodley Richard husbandman 603924 603924 Woodley, Richard, of Henham, husbandman 1
3935675 2002243 2002243 defendant Colbarne John smith 603924 603924 Colbarne, John, of Henham, smith 0
3994438 2022764 2022764 defendant Stannard Thomas husbandman 603924 603924 Stannard, Thomas, of Henham, husbandman 2
4007302 2027392 2027392 defendant Wylby John husbandman 603924 603924 Wylby, John, of Henham, husbandman 1
4317587 2136266 2136266 defendant Wilson Robert tailor 603924 603924 Wilson, Robert, of Henham, tailor 2
4479730 2194321 2194321 defendant Bermond William   603924 603924 Bermond, William, of Henham 0
4571840 2222778 2222778 plaintiff Cravene Thomas   603924 603924 Cravene, Thomas, of Henham 2
4683462 2260429 2260429 defendant Baltrip Roger husbandman 603924 603924 Baltrip, Roger, of Henham, husbandman 1
4722958 2272496 2272496 plaintiff Cravene Thomas (legal representative) 603924 603924 Cravene, Thomas, of Henham, executors of 0
4732111 2275225 2275225 defendant Wormed Thomas husbandman 603924 603924 Wormed, Thomas, of Henham, husbandman 0
4765388 2285158 2285158 defendant Baker William husbandman 603924 603924 Baker, William, of Henham, husbandman 0
4765715 2285272 2285272 defendant Mellet John, sen chandler 603924 603924 Mellet, John, sen, of Henham, chandler 3
4772065 2287239 2287239 defendant Pynsthorp Robert husbandman 603924 603924 Pynsthorp, Robert, of Henham, husbandman 1
4777129 2288827 2288827 plaintiff atte Boure Thomas   603924 603924 atte Boure, Thomas, of Henham, son of atte Boure, Thomas, of Wodeham Watier 0
4797249 2295312 2295312 defendant Pynsthorp Robert husbandman 603924 603924 Pynsthorp, Robert, of Henham, husbandman 1
4801453 2296636 2296636 defendant Baltrip Roger husbandman 603924 603924 Baltrip, Roger, of Henham, husbandman 1
4801454 2296636 2296636 defendant Baltrip William husbandman 603924 603924 Baltrip, William, of Henham, husbandman 2
4811090 2299578 2299578 defendant Skaunt John husbandman 603924 603924 Skaunt, John, of Henham, husbandman 0
4815265 2300885 2300885 defendant fitz Wauter Walter   603924 603924 fitz Wauter, Walter, of Henham, knight 0
4815269 2300886 2300886 defendant fitz Wauter Walter   603924 603924 fitz Wauter, Walter, of Henham, knight 0
4837770 2307746 2307746 defendant Wynde John yeoman 603924 603924 Wynde, John, of Henham, yeoman 0
4843728 2309561 2309561 defendant Neweman Richard   603924 603924 Neweman, Richard, of Henham, servant 1
4865126 2316066 2316066 defendant Grege William cordwainer 603924 603924 Grege, William, of Henham, cordwainer 2
4871666 2318101 2318101 defendant Bauny of Banny John husbandman 603924 603924 Bauny of Banny, John, of Henham, husbandman 0
4893671 2324715 2324715 defendant Marche William pedder 603924 603924 Marche, William, of Henham, pedder 0
4910658 2329843 2329843 defendant Wynd Robert yeoman 603924 603924 Wynd, Robert, of Henham, yeoman 1
4936210 2337727 2337727 defendant Wynd Robert yeoman 603924 603924 Wynd, Robert, of Henham, yeoman 1
4936211 2337727 2337727 defendant Cotewan Nicholas yeoman 603924 603924 Cotewan, Nicholas, of Henham, yeoman 2
4983593 2352013 2352013 defendant Coupere John cooper 603924 603924 Coupere, John, of Henham, cooper 0
4983594 2352013 2352013 defendant Wryghte Richard husbandman 603924 603924 Wryghte, Richard, of Henham, husbandman 1
5039589 2368489 2368489 defendant Hopton John   603924 603924 Hopton, John, of Henham, shepherd 0
5063208 2375529 2375529 defendant Ulveston John esq 603924 603924 Ulveston, John, of Henham, esq 0
5064861 2376023 2376023 defendant Scotte John husbandman 603924 603924 Scotte, John, of Henham, husbandman 3
5097432 2385680 2385680 defendant Cady John yeoman 603924 603924 Cady, John, of Henham, yeoman 0
5098644 2386035 2386035 defendant Smyth John   603924 603924 Smyth, John, of Henham, fan maker 0
5098645 2386035 2386035 defendant Wryght Thomas   603924 603924 Wryght, Thomas, of Henham, fan maker 1
5098646 2386035 2386035 defendant Crabbe William pulter 603924 603924 Crabbe, William, of Henham, pulter 2
5098647 2386035 2386035 defendant Benet Thomas husbandman 603924 603924 Benet, Thomas, of Henham, husbandman 3
5102778 2387230 2387230 defendant Wodecok Thomas yeoman 603924 603924 Wodecok, Thomas, of Henham, yeoman 1
5108910 2389026 2389026 defendant Ulveston John esq 603924 603924 Ulveston, John, of Henham, esq 0
5117449 2391537 2391537 defendant Wysman John yeoman 603924 603924 Wysman, John, of Henham, yeoman 2
5117455 2391538 2391538 defendant Wysman John yeoman 603924 603924 Wysman, John, of Henham, yeoman 2
5130955 2395536 2395536 defendant Ulveston John esq 603924 603924 Ulveston, John, of Henham, esq 0
5152883 2401984 2401984 defendant Sket Thomas yeoman 603924 603924 Sket, Thomas, of Henham, yeoman 1
5170477 2407093 2407093 defendant Sket Thomas yeoman 603924 603924 Sket, Thomas, of Henham, yeoman 1
5170478 2407093 2407093 defendant Sket Roger yeoman 603924 603924 Sket, Roger, of Henham, yeoman 2
5221529 2421993 2421993 defendant Marchall William husbandman 603924 603924 Marchall, William, of Henham, husbandman 1
5221540 2421996 2421996 defendant Marchall William husbandman 603924 603924 Marchall, William, of Henham, husbandman 1
5248794 2429766 2429766 defendant Sket Roger husbandman 603924 603924 Sket, Roger, of Henham, husbandman 1
5254104 2431403 2431403 defendant Hale Thomas husbandman 603924 603924 Hale, Thomas, of Henham, husbandman 0
5254112 2431407 2431407 defendant Hale Thomas husbandman 603924 603924 Hale, Thomas, of Henham, husbandman 0
5257570 2432486 2432486 defendant Ulneston or Ulveston Richard esq 603924 603924 Ulneston or Ulveston, Richard, of Henham, esq 0
5264625 2434690 2434690 defendant Waterden John shoemaker 603924 603924 Waterden, John, of Henham, shoemaker 0
5468733 2495576 2495576 defendant Miller John yeoman 603924 603924 Miller, John, of Henham, yeoman 0
5520366 2511190 2511190 defendant Lese Thomas laborer 603924 603924 Lese, Thomas, of Henham, laborer 4
5543463 2518073 2518073 defendant Motte John husbandman 603924 603924 Motte, John, of Henham, husbandman 0
5588495 2531406 2531406 defendant Glascok Henry butcher 603924 603924 Glascok, Henry, of Henham, butcher 3
5601500 2535360 2535360 defendant Lenthorp Robert gent 603924 603924 Lenthorp, Robert, of Henham, gent 0
5601501 2535360 2535360 defendant Barcok Walter gent 603924 603924 Barcok, Walter, of Henham, gent 1
5613489 2548009 2548009 defendant Palmere Roger   603924 603924 Palmere, Roger, of Henham 3

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