names

79 rows where place_id = 616939

✎ 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
3716927 1931582 1931582 plaintiff Croft William yeoman 616939 616939 Croft, William, of Wendlyngburgh, yeoman 0
3756812 1944103 1944103 plaintiff Ball John groner or grover 616939 616939 Ball, John, of Wendlyngburgh, groner or grover 0
3775604 1950115 1950115 defendant Ball Thomas husbandman 616939 616939 Ball, Thomas, of Wendlyngburgh, husbandman 2
3778301 1950925 1950925 plaintiff Crofte William yeoman 616939 616939 Crofte, William, of Wendlyngburgh, yeoman 0
3778303 1950926 1950926 plaintiff Crofte William yeoman 616939 616939 Crofte, William, of Wendlyngburgh, yeoman 0
3799286 1957692 1957692 defendant Holand John clerk 616939 616939 Holand, John, of Wendlyngburgh, clerk 0
3854048 1974901 1974901 defendant Burges Henry whitawer 616939 616939 Burges, Henry, of Wendlyngburgh, whitawer 0
3864038 1978155 1978155 defendant Ball John glover 616939 616939 Ball, John, of Wendlyngburgh, glover 0
3888344 1986363 1986363 defendant Gloucettur William shoemaker 616939 616939 Gloucettur, William, of Wendlyngburgh, shoemaker 0
3939239 2003427 2003427 defendant Kellett John   616939 616939 Kellett, John, of Wendlyngburgh, tallow chandler 0
3948349 2006485 2006485 plaintiff Curson Ralph innholder 616939 616939 Curson, Ralph, of Wendlyngburgh, innholder 0
3967124 2013127 2013127 defendant Weston John smith 616939 616939 Weston, John, of Wendlyngburgh, smith 0
4421658 2171663 2171663 defendant Keten Robert de   616939 616939 Keten, Robert de, of Wendlyngburgh, son of Richard 0
4458196 2187602 2187602 defendant Webster Roger   616939 616939 Webster, Roger, of Wendlyngburgh 0
4524909 2208135 2208135 plaintiff Hunt John   616939 616939 Hunt, John, of Wendlyngburgh 0
4524910 2208135 2208135 defendant Webester Roger   616939 616939 Webester, Roger, of Wendlyngburgh 0
4524911 2208136 2208136 plaintiff Hunt John   616939 616939 Hunt, John, of Wendlyngburgh 0
4524912 2208136 2208136 defendant Webester Roger   616939 616939 Webester, Roger, of Wendlyngburgh 0
4527306 2208822 2208822 defendant Burton John   616939 616939 Burton, John, of Wendlyngburgh 0
4542156 2213438 2213438 defendant Burton John   616939 616939 Burton, John, of Wendlyngburgh 1
4542157 2213438 2213438 defendant Toppyng John   616939 616939 Toppyng, John, of Wendlyngburgh 2
4542158 2213438 2213438 defendant Waldegrave John   616939 616939 Waldegrave, John, of Wendlyngburgh 3
4566043 2220936 2220936 defendant Deyster John   616939 616939 Deyster, John, of Wendlyngburgh 2
4580000 2225232 2225232 defendant Pote John   616939 616939 Pote, John, of Wendlyngburgh, son of John 0
4587394 2227467 2227467 plaintiff Hunt John (legal representative) 616939 616939 Hunt, John, of Wendlyngburgh, executors of 0
4624209 2238554 2238554 defendant Toppyng John   616939 616939 Toppyng, John, of Wendlyngburgh 0
4629666 2240201 2240201 plaintiff Spencer William   616939 616939 Spencer, William, of Wendlyngburgh 0
4629668 2240201 2240201 defendant Elyot Henry   616939 616939 Elyot, Henry, of Wendlyngburgh 0
4629669 2240201 2240201 defendant Elyot William   616939 616939 Elyot, William, of Wendlyngburgh 1
4633730 2241400 2241400 defendant Semour John   616939 616939 Semour, John, of Wendlyngburgh 1
4654384 2247244 2247244 defendant Worlyche John laborer 616939 616939 Worlyche, John, of Wendlyngburgh, laborer 2
4661646 2249480 2249480 defendant Couper John cooper 616939 616939 Couper, John, of Wendlyngburgh, cooper 0
4665196 2250599 2250599 defendant atte Tounesende Nicholas   616939 616939 atte Tounesende, Nicholas, of Wendlyngburgh, mason 0
4822973 2303268 2303268 defendant Clerk John, junior husbandman 616939 616939 Clerk, John, junior, of Wendlyngburgh, husbandman 3
4850974 2311753 2311753 defendant Kyrke John butcher 616939 616939 Kyrke, John, of Wendlyngburgh, butcher 6
4968867 2347653 2347653 defendant Gybon John husbandman 616939 616939 Gybon, John, of Wendlyngburgh, husbandman 3
4968869 2347653 2347653 defendant Worlich William singleman 616939 616939 Worlich, William, of Wendlyngburgh, singleman 5
4984687 2352346 2352346 plaintiff Worlich John   616939 616939 Worlich, John, of Wendlyngburgh 2
5022320 2363423 2363423 defendant Burton William husbandman 616939 616939 Burton, William, of Wendlyngburgh, husbandman 0
5022321 2363423 2363423 defendant Gybon John husbandman 616939 616939 Gybon, John, of Wendlyngburgh, husbandman 1
5043842 2369785 2369785 defendant Staple John husbandman 616939 616939 Staple, John, of Wendlyngburgh, husbandman 0
5049579 2371504 2371504 defendant Breton John husbandman 616939 616939 Breton, John, of Wendlyngburgh, husbandman 0
5049580 2371504 2371504 defendant Breton William husbandman 616939 616939 Breton, William, of Wendlyngburgh, husbandman 1
5057898 2373933 2373933 defendant Ingram Joan widow 616939 616939 Ingram, Joan, of Wendlyngburgh, widow 1
5062666 2375392 2375392 defendant Bullok Walter yeoman 616939 616939 Bullok, Walter, of Wendlyngburgh, yeoman 0
5062668 2375393 2375393 defendant Bullok Walter yeoman 616939 616939 Bullok, Walter, of Wendlyngburgh, yeoman 0
5077590 2379796 2379796 defendant Elyotte William husbandman 616939 616939 Elyotte, William, of Wendlyngburgh, husbandman 1
5077591 2379796 2379796 defendant Elyotte Thomas husbandman 616939 616939 Elyotte, Thomas, of Wendlyngburgh, husbandman 2
5077592 2379796 2379796 defendant Hurluston Stephen husbandman 616939 616939 Hurluston, Stephen, of Wendlyngburgh, husbandman 3
5077593 2379796 2379796 defendant Idelote Thomas   616939 616939 Idelote, Thomas, of Wendlyngburgh, wright 4
5077594 2379796 2379796 defendant Magot Henry roper 616939 616939 Magot, Henry, of Wendlyngburgh, roper 5
5077595 2379796 2379796 defendant Willy John fuller 616939 616939 Willy, John, of Wendlyngburgh, fuller 6
5077596 2379796 2379796 defendant Willy Ralph fuller 616939 616939 Willy, Ralph, of Wendlyngburgh, fuller 7
5077597 2379796 2379796 defendant Wodeland John husbandman 616939 616939 Wodeland, John, of Wendlyngburgh, husbandman 8
5077598 2379796 2379796 defendant Bele Richard   616939 616939 Bele, Richard, of Wendlyngburgh, "peytour" or painter 9
5077599 2379796 2379796 defendant Umfray Robert smith 616939 616939 Umfray, Robert, of Wendlyngburgh, smith 10
5077600 2379796 2379796 defendant Crowley John weaver 616939 616939 Crowley, John, of Wendlyngburgh, weaver 11
5098786 2386075 2386075 defendant Sexteyn William barber 616939 616939 Sexteyn, William, of Wendlyngburgh, barber 1
5234840 2425774 2425774 defendant Mosse John husbandman 616939 616939 Mosse, John, of Wendlyngburgh, husbandman 0
5347766 2459454 2459454 defendant Idelet Richard butcher 616939 616939 Idelet, Richard, of Wendlyngburgh, butcher 0
5347767 2459454 2459454 defendant Shepard Robert husbandman 616939 616939 Shepard, Robert, of Wendlyngburgh, husbandman 1
5347768 2459454 2459454 defendant Smyth Richard husbandman 616939 616939 Smyth, Richard, of Wendlyngburgh, husbandman 2
5347769 2459454 2459454 defendant Sywell Richard husbandman 616939 616939 Sywell, Richard, of Wendlyngburgh, husbandman 3
5354959 2461623 2461623 defendant Frenell or Frevell John   616939 616939 Frenell or Frevell, John, of Wendlyngburgh, mason 1
5354960 2461623 2461623 defendant Makesey John husbandman 616939 616939 Makesey, John, of Wendlyngburgh, husbandman 2
5354962 2461623 2461623 defendant Reynold Robert husbandman 616939 616939 (Reynold, Robert, of Wendlyngburgh, husbandman 4
5354963 2461623 2461623 defendant Est Alice widow 616939 616939 Est, Alice, of Wendlyngburgh, widow 5
5358954 2462850 2462850 defendant Blowefeld Thomas laborer 616939 616939 Blowefeld, Thomas, of Wendlyngburgh, laborer 2
5381940 2469890 2469890 defendant Blofeld Thomas husbandman 616939 616939 Blofeld, Thomas, of Wendlyngburgh, husbandman 0
5390142 2472242 2472242 defendant Blofeld Thomas husbandman 616939 616939 Blofeld, Thomas, of Wendlyngburgh, husbandman 0
5395631 2473831 2473831 defendant Miles John husbandman 616939 616939 Miles, John, of Wendlyngburgh, shepherd, son & heir of William, Miles, of Wendlyngburgh, husbandman 0
5408924 2477629 2477629 defendant Miles John   616939 616939 Miles, John, of Wendlyngburgh, shepherd, son & heir of William Miles 0
5456212 2491771 2491771 defendant Bluet Simon yeoman 616939 616939 Bluet, Simon, of Wendlyngburgh, yeoman 0
5484424 2500258 2500258 defendant Buklond William mercer 616939 616939 Buklond, William, of Wendlyngburgh, mercer 1
5620482 2550264 2550264 defendant Webstere Roger   616939 616939 Webstere, Roger, of Wendlyngburgh 0
5626761 2552342 2552342 defendant Barret John yeoman 616939 616939 Barret, John, of Wendlyngburgh, yeoman 0
5634153 2554667 2554667 defendant Shelton John husbandman 616939 616939 Shelton, John, of Wendlyngburgh, husbandman 4
5634705 2554851 2554851 defendant Stodvyle John husbandman 616939 616939 Stodvyle, John, of Wendlyngburgh, husbandman 3
5634706 2554851 2554851 defendant atte Gotere Thomas weaver 616939 616939 atte Gotere, Thomas, of Wendlyngburgh, weaver 4

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