names

177 rows where place_id = 590892

✎ 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
3602632 1868486 1868486 defendant Bratford Thomas husbandman 590892 590892 Bratford, Thomas, of Bloxham, husbandman 1
3602633 1868486 1868486 defendant Nicollys William husbandman 590892 590892 Nicollys, William, of Bloxham, husbandman 2
3602634 1868486 1868486 defendant Moos Menry yeoman 590892 590892 Moos, Menry, of Bloxham, yeoman 3
3610708 1871013 1871013 defendant Smyth Robert husbandman 590892 590892 Smyth, Robert, of Bloxham, husbandman 0
3647218 1909517 1909517 defendant Mayho Richard laborer 590892 590892 Mayho, Richard, of Bloxham, laborer 5
3659875 1913343 1913343 defendant Mose Henry husbandman 590892 590892 Mose, Henry, of Bloxham, husbandman 2
3674018 1917914 1917914 defendant Clever John husbandman 590892 590892 Clever, John, of Bloxham, husbandman 0
3722560 1933316 1933316 defendant Clever John husbandman 590892 590892 Clever, John, of Bloxham, husbandman 0
3749358 1941720 1941720 defendant Frenche William husbandman 590892 590892 Frenche, William, of Bloxham, husbandman 2
3760008 1945126 1945126 defendant Fryer John husbandman 590892 590892 Fryer, John, of Bloxham, husbandman 0
3804217 1959252 1959252 defendant Warde Richard husbandman 590892 590892 Warde, Richard, of Bloxham, husbandman 0
3834115 1968611 1968611 defendant Teynton Ralph tailor 590892 590892 Teynton, Ralph, of Bloxham, tailor 0
3842899 1971313 1971313 defendant Counser Edward gent 590892 590892 Counser, Edward, of Bloxham, gent 0
3842901 1971314 1971314 defendant Counser Edward gent 590892 590892 Counser, Edward, of Bloxham, gent 0
3842903 1971314 1971314 defendant White Ralph chaplain 590892 590892 (White, Ralph, of Bloxham, chaplain 2
3842904 1971314 1971314 defendant Geffray Thomas husbandman 590892 590892 Geffray, Thomas, of Bloxham, husbandman 3
4132087 2071786 2071786 defendant Busbye William laborer 590892 590892 Busbye, William, of Bloxham, laborer 2
4197140 2094552 2094552 defendant Hytchman John husbandman 590892 590892 Hytchman, John, of Bloxham, husbandman 0
4216389 2101226 2101226 defendant Hilton John husbandman 590892 590892 Hilton, John, of Bloxham, husbandman 0
4298690 2129630 2129630 defendant Dalby John, junior yeoman 590892 590892 Dalby, John, junior, of Bloxham, yeoman 0
4356521 2149514 2149514 defendant Dalby John, senior   590892 590892 Dalby, John, senior, of Bloxham 0
4356522 2149514 2149514 defendant Dalby John, junior yeoman 590892 590892 Dalby, John, junior, of Bloxham, yeoman 1
4356523 2149514 2149514 defendant Bloxham Robert gent 590892 590892 Bloxham, Robert, of Bloxham, gent 2
4515032 2205110 2205110 defendant Hanley Richard   590892 590892 Hanley, Richard, of Bloxham 0
4515721 2205343 2205343 defendant Matheu Henry   590892 590892 Matheu, Henry, of Bloxham 0
4516032 2205429 2205429 defendant Matheu Henry   590892 590892 Matheu, Henry, of Bloxham 2
4535428 2211353 2211353 defendant Mathue Henry   590892 590892 Mathue, Henry, of Bloxham 0
4552750 2216810 2216810 defendant Pitte John   590892 590892 Pitte, John, of Bloxham 1
4552761 2216812 2216812 defendant Pitte John   590892 590892 Pitte, John, of Bloxham 2
4555292 2217590 2217590 plaintiff Helmeden Nicholas   590892 590892 Helmeden, Nicholas, of Bloxham 0
4555293 2217590 2217590 defendant Merston John   590892 590892 Merston, John, of Bloxham 0
4557821 2218376 2218376 defendant Haule Richard   590892 590892 Haule, Richard, of Bloxham 0
4566407 2221064 2221064 plaintiff Steton William de   590892 590892 Steton, William de, of Bloxham 0
4567049 2221250 2221250 defendant Borstall Robert   590892 590892 Borstall, Robert, of Bloxham 0
4582383 2225931 2225931 defendant Gegge alias Box Agnes   590892 590892 Gegge alias Box, Agnes, of Bloxham 0
4582385 2225932 2225932 defendant Gegge alias Boy Agnes   590892 590892 Gegge alias Boy, Agnes, of Bloxham 0
4602543 2232014 2232014 defendant Belgrave John   590892 590892 Belgrave, John, of Bloxham, formerly parson 0
4611090 2234533 2234533 plaintiff Chichon John   590892 590892 Chichon, John, of Bloxham 0
4613454 2235223 2235223 defendant Putte John   590892 590892 Putte, John, of Bloxham 1
4613458 2235223 2235223 defendant Chauntecleere Richard   590892 590892 Chauntecleere, Richard, of Bloxham 5
4617964 2236625 2236625 plaintiff Gybbes William   590892 590892 Gybbes, William, of Bloxham 0
4661358 2249375 2249375 defendant Scolas Thomas husbandman 590892 590892 Scolas, Thomas, of Bloxham, husbandman 0
4661360 2249376 2249376 defendant Scolas Thomas husbandman 590892 590892 Scolas, Thomas, of Bloxham, husbandman 0
4661730 2249510 2249510 defendant Cadelyn Roger husbandman 590892 590892 Cadelyn, Roger, of Bloxham, husbandman 0
4664752 2250455 2250455 defendant Baret John shoemaker 590892 590892 Baret, John, of Bloxham, shoemaker 0
4664754 2250456 2250456 defendant Baret John shoemaker 590892 590892 Baret, John, of Bloxham, shoemaker 0
4689886 2262391 2262391 defendant Chambre Richard hosteler 590892 590892 Chambre, Richard, of Bloxham, hosteler 0
4747547 2279786 2279786 defendant Betonson Robert husbandman 590892 590892 Betonson, Robert, of Bloxham, husbandman 1
4806239 2298159 2298159 defendant Dandy John (legal representative) 590892 590892 Dandy, John, of Bloxham, draper, executor of 5
4831700 2305942 2305942 defendant Wescote John carpenter 590892 590892 Wescote, John, of Bloxham, carpenter 2
4832681 2306241 2306241 defendant Palmer wm husbandman 590892 590892 Palmer, wm, of Bloxham, husbandman 0
4834397 2306764 2306764 defendant Tymmes Thomas husbandman 590892 590892 Tymmes, Thomas, of Bloxham, husbandman 0
4835012 2306953 2306953 plaintiff Stanes Richard mercer 590892 590892 Stanes, Richard, of Bloxham, mercer 1
4837818 2307761 2307761 defendant Algar Maron smith 590892 590892 Algar, Maron, of Bloxham, smith 2
4852042 2312071 2312071 plaintiff Large John   590892 590892 (Large, John, of Bloxham 1
4856190 2313311 2313311 defendant Burton William chaplain 590892 590892 Burton, William, of Bloxham, chaplain 0
4857077 2313594 2313594 defendant Dandy William Oxon, chandler 590892 590892 Dandy William, of Bloxham, Oxon, chandler 0
4866936 2316620 2316620 defendant Tymmes John husbandman 590892 590892 Tymmes, John, of Bloxham, husbandman 0
4902608 2327436 2327436 defendant Broun John butcher 590892 590892 Broun, John, of Bloxham, butcher 1
4928580 2335370 2335370 plaintiff Smyth William   590892 590892 Smyth, William, of Bloxham 0
4928583 2335371 2335371 plaintiff Smyth William   590892 590892 Smyth, William, of Bloxham 0
4928586 2335372 2335372 plaintiff Smyth William   590892 590892 Smyth, William, of Bloxham 0
4932996 2336710 2336710 defendant Fyssk Thomas clerk & vicar 590892 590892 Fyssk, Thomas, of Bloxham, clerk & vicar 0
4934554 2337201 2337201 defendant Dorsete Roger husbandman 590892 590892 Dorsete, Roger, of Bloxham, husbandman 2
4958352 2344465 2344465 defendant Dandy William chapman 590892 590892 Dandy, William, of Bloxham, chapman 0
4958354 2344466 2344466 defendant Hickes John husbandman 590892 590892 Hickes, John, of Bloxham, husbandman 0
4962647 2345736 2345736 defendant Juster or Inster Walter (legal representative) 590892 590892 Juster or Inster, Walter, of Bloxham, administratrix of 0
4962648 2345736 2345736 defendant Juster or Inster Alice widow 590892 590892 Juster or Inster, Alice, of Bloxham, widow 1
4962650 2345737 2345737 defendant Juster Walter (legal representative) 590892 590892 Juster, Walter, of Bloxham, administratrix of 0
4962651 2345737 2345737 defendant Juster Alice widow 590892 590892 Juster, Alice, of Bloxham, widow 1
4968960 2347681 2347681 defendant Latymer John husbandman 590892 590892 Latymer, John, of Bloxham, husbandman 0
4968961 2347681 2347681 defendant Garsgoyne Thomas husbandman 590892 590892 Garsgoyne, Thomas, of Bloxham, husbandman 1
4968962 2347681 2347681 defendant Helmeden John husbandman 590892 590892 together with Helmeden, John, of Bloxham, husbandman 2
4980081 2350993 2350993 defendant Symmes William   590892 590892 Symmes, William, of Bloxham, ploughwright 2
4993110 2354821 2354821 defendant Palmer William husbandman 590892 590892 Palmer, William, of Bloxham, husbandman 0
4993111 2354821 2354821 defendant Webbe Miles weaver 590892 590892 Webbe, Miles, of Bloxham, weaver 1
4994328 2355178 2355178 defendant Napton William husbandman 590892 590892 Napton, William, of Bloxham, husbandman 0
5002882 2357747 2357747 defendant Dandy William husbandman 590892 590892 Dandy, William, of Bloxham, husbandman 0
5002883 2357747 2357747 defendant Palmer William husbandman 590892 590892 Palmer, William, of Bloxham, husbandman 1
5004956 2358345 2358345 defendant More   yeoman 590892 590892 _, More, of Bloxham, yeoman 2
5013478 2360779 2360779 defendant Knyght William yeoman 590892 590892 Knyght, William, of Bloxham, yeoman 1
5013480 2360779 2360779 defendant Asshe Richard butcher 590892 590892 Asshe, Richard, of Bloxham, butcher 3
5025310 2364293 2364293 defendant Dandy William chapman 590892 590892 Dandy, William, of Bloxham, chapman 4
5029241 2365433 2365433 defendant Helmeden John husbandman 590892 590892 Helmeden, John, of Bloxham, husbandman 3
5029242 2365433 2365433 defendant Wescote John   590892 590892 Wescote, John, of Bloxham, holy water clerk 4
5029243 2365433 2365433 defendant Bailly Thomas   590892 590892 Bailly, Thomas, of Bloxham, servant 5
5033493 2366679 2366679 defendant Shelton John husbandman 590892 590892 Shelton, John, of Bloxham, husbandman 0
5033494 2366679 2366679 defendant Dene Thomas yeoman 590892 590892 Dene, Thomas, of Bloxham, yeoman 1
5050994 2371910 2371910 defendant Napton William husbandman 590892 590892 Napton, William, of Bloxham, husbandman 1
5054434 2372900 2372900 defendant Sheldon John husbandman 590892 590892 Sheldon, John, of Bloxham, husbandman 1
5067541 2376789 2376789 defendant Pleystowe John husbandman 590892 590892 Pleystowe, John, of Bloxham, husbandman 3
5073908 2378688 2378688 defendant Frebody Henry gent 590892 590892 Frebody, Henry, of Bloxham, gent 1
5073909 2378688 2378688 defendant Averey Thomas gent 590892 590892 Averey, Thomas, of Bloxham, gent 2
5073910 2378688 2378688 defendant Middelton John yeoman 590892 590892 Middelton, John, of Bloxham, yeoman 3
5073911 2378688 2378688 defendant Dene Thomas baker 590892 590892 Dene, Thomas, of Bloxham, baker 4
5073912 2378688 2378688 defendant Knyght William yeoman 590892 590892 Knyght, William, of Bloxham, yeoman 5
5073913 2378688 2378688 defendant Westcote John husbandman 590892 590892 Westcote, John, of Bloxham, husbandman 6
5073914 2378688 2378688 defendant Palmer William husbandman 590892 590892 Palmer, William, of Bloxham, husbandman 7
5073915 2378688 2378688 defendant Shelton John husbandman 590892 590892 Shelton, John, of Bloxham, husbandman 8
5073916 2378688 2378688 defendant Freman Miles weaver 590892 590892 Freman, Miles, of Bloxham, weaver 9

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