names

93 rows where place_id = 592732

✎ 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
3608667 1870371 1870371 defendant Webbe Thomas tailor 592732 592732 Webbe, Thomas, of Balsham, tailor 0
3625148 1875399 1875399 defendant Mersshe John, senior husbandman 592732 592732 Mersshe, John, senior, of Balsham, husbandman 1
3628074 1903635 1903635 defendant Cornell John smith 592732 592732 Cornell, John, of Balsham, smith 0
3628077 1903636 1903636 defendant Frere John, senior mercer 592732 592732 Frere, John, senior, of Balsham, mercer 0
3631428 1904642 1904642 defendant Dysse Thomas husbandman 592732 592732 Dysse, Thomas, of Balsham, or of West Wrattyng, husbandman 0
3631429 1904642 1904642 defendant Nayler John husbandman 592732 592732 Nayler, John, of Balsham, husbandman 1
3631430 1904642 1904642 defendant Webe Thomas tailor 592732 592732 Webe, Thomas, of Balsham, tailor 2
3631432 1904643 1904643 defendant Webe Thomas tailor 592732 592732 Webe, Thomas, of Balsham, tailor 0
3640393 1907426 1907426 defendant Flakke John husbandman 592732 592732 Flakke, John, of Balsham, husbandman 0
3640394 1907426 1907426 defendant Nayller John husbandman 592732 592732 Nayller, John, of Balsham, husbandman 1
3640395 1907426 1907426 defendant Barton John gent 592732 592732 Barton, John, of Balsham, gent 2
3651894 1910942 1910942 defendant Naylour Richard yeoman 592732 592732 Naylour, Richard, of Balsham, yeoman 0
3652251 1911043 1911043 defendant Webbe Thomas tailor 592732 592732 Webbe, Thomas, of Balsham, tailor 2
3659150 1913118 1913118 defendant Horn Ralph   592732 592732 Horn, Ralph, of Balsham, shoe maker 1
3666940 1915606 1915606 defendant Nayler William   592732 592732 Nayler, William, of Balsham, tallow chandler 0
3666943 1915606 1915606 defendant Flak John husbandman 592732 592732 Flak, John, of Balsham, husbandman 3
3682619 1920670 1920670 defendant Flakke John husbandman 592732 592732 Flakke, John, of Balsham, husbandman 1
3706167 1928221 1928221 plaintiff Horne Ralph   592732 592732 Horne, Ralph, of Balsham 0
3720275 1932620 1932620 plaintiff Horn Ralph yeoman 592732 592732 Horn, Ralph, of Balsham, yeoman 0
3731605 1936112 1936112 defendant Jorden Richard husbandman 592732 592732 Jorden, Richard, of Balsham, husbandman 0
3731608 1936112 1936112 defendant Cornell Richard husbandman 592732 592732 Cornell, Richard, of Balsham, husbandman 3
3756891 1944130 1944130 defendant Flakk John husbandman 592732 592732 Flakk, John, of Balsham, husbandman 0
3784214 1952850 1952850 defendant Algood John husbandman 592732 592732 Algood, John, of Balsham, husbandman 0
3784215 1952850 1952850 defendant Flak John husbandman 592732 592732 Flak, John, of Balsham, husbandman 1
3812616 1961834 1961834 defendant Cokerton John butcher 592732 592732 Cokerton, John, of Balsham, butcher 0
3812617 1961834 1961834 defendant Taversham Thomas shoemaker 592732 592732 Taversham, Thomas, of Balsham, shoemaker 1
3820211 1964202 1964202 defendant Garner William carpenter 592732 592732 Garner, William, of Balsham, carpenter 2
3906967 1992618 1992618 defendant Flacke John yeoman 592732 592732 Flacke, John, of Balsham, yeoman 0
3928414 1999840 1999840 defendant Browne Henry   592732 592732 Browne, Henry, of Balsham, pedlar 0
3928415 1999840 1999840 defendant Gardener John husbandman 592732 592732 Gardener, John, of Balsham, husbandman 1
3945080 2005372 2005372 defendant Lorkyn William carpenter 592732 592732 Lorkyn, William, of Balsham, carpenter 0
3945081 2005372 2005372 defendant Haylocke Richard (legal representative) 592732 592732 Haylocke, Richard, of Balsham, administrator of 1
3948929 2006692 2006692 defendant Cokerton William butcher 592732 592732 Cokerton, William, of Balsham, butcher 0
4005506 2026745 2026745 defendant Haylok Edmund   592732 592732 Haylok, Edmund, of Balsham, husbandman, shepherd 0
4005508 2026746 2026746 defendant Teversham Mathew   592732 592732 Teversham, Mathew, of Balsham, husbandman, woodward 0
4019603 2031738 2031738 plaintiff Webbe Thomas   592732 592732 Webbe, Thomas, of Balsham, shepherd 0
4019604 2031738 2031738 defendant Perne John yeoman 592732 592732 Perne, John, of Balsham, yeoman 0
4021984 2032590 2032590 defendant Page Henry yeoman 592732 592732 Page, Henry, of Balsham, yeoman 0
4028762 2034935 2034935 plaintiff Cowle John husbandman 592732 592732 Cowle, John, of Balsham, husbandman 0
4049637 2042310 2042310 defendant Page Henry yeoman 592732 592732 Page, Henry, of Balsham, yeoman 0
4068318 2048969 2048969 defendant Tayler William husbandman 592732 592732 Tayler, William, of Balsham, husbandman 2
4088393 2056143 2056143 defendant Cornell Richard husbandman 592732 592732 Cornell, Richard, of Balsham, husbandman 1
4127510 2070133 2070133 defendant Cockerton John butcher 592732 592732 Cockerton, John, of Balsham, butcher 1
4176789 2087351 2087351 defendant Funston John husbandman 592732 592732 Funston, John, of Balsham, husbandman 0
4176790 2087351 2087351 defendant Grygge John husbandman 592732 592732 Grygge, John, of Balsham, husbandman 1
4298769 2129659 2129659 defendant Benbrooke John tailor 592732 592732 Benbrooke, John, of Balsham, tailor 2
4298770 2129659 2129659 defendant Minott Edward yeoman 592732 592732 Minott, Edward, of Balsham, yeoman 3
4460648 2188389 2188389 plaintiff Sleford John de   592732 592732 Sleford, John de, of Balsham, parson 0
4460651 2188390 2188390 plaintiff Sleford John de   592732 592732 Sleford, John de, of Balsham, parson 0
4487364 2196762 2196762 plaintiff Sleford John   592732 592732 Sleford, John, of Balsham, parson 0
4487366 2196763 2196763 plaintiff Sleford Jonn   592732 592732 Sleford, Jonn, of Balsham, parson 0
4489836 2197527 2197527 plaintiff Trippe William   592732 592732 Trippe, William, of Balsham 0
4503557 2201686 2201686 defendant Meysaunt Simon   592732 592732 Meysaunt, Simon, of Balsham 0
4503561 2201687 2201687 defendant Revyll John smith 592732 592732 Revyll, John, of Balsham, smith 0
4515923 2205403 2205403 defendant Rape Robert weaver 592732 592732 Rape, Robert, of Balsham, weaver 0
4515925 2205404 2205404 defendant Rape Robert weaver 592732 592732 Rape, Robert, of Balsham, weaver 0
4532428 2210408 2210408 defendant Syre William   592732 592732 Syre, William, of Balsham 0
4615189 2235759 2235759 defendant Webbe John   592732 592732 Webbe, John, of Balsham 0
4625397 2238909 2238909 defendant Howel Robert   592732 592732 Howel, Robert, of Balsham 1
4644874 2244567 2244567 defendant Revyll John   592732 592732 Revyll, John, of Balsham 0
4671926 2256866 2256866 defendant Mersshe Robert   592732 592732 Mersshe, Robert, of Balsham, shepherd 2
4674748 2257713 2257713 defendant Howell Robert husbandman 592732 592732 Howell, Robert, of Balsham, husbandman 0
4683353 2260397 2260397 defendant Revyll John husbandman 592732 592732 Revyll, John, of Balsham, husbandman 0
4683355 2260397 2260397 defendant Pryour William husbandman 592732 592732 Pryour, William, of Balsham, husbandman 2
4683356 2260397 2260397 defendant Spylleman William husbandman 592732 592732 Spylleman, William, of Balsham, husbandman 3
4684908 2260874 2260874 plaintiff repyngton William   592732 592732 repyngton, William, of Balsham, parson 0
4732463 2275327 2275327 defendant Dawe John, sen husbandman 592732 592732 Dawe, John, sen, of Balsham, husbandman 0
4739936 2277569 2277569 defendant Hewys Nicholas   592732 592732 Hewys, Nicholas, of Balsham 3
4742796 2278400 2278400 defendant Cole John husbandman 592732 592732 Cole, John, of Balsham, husbandman 5
4746747 2279545 2279545 plaintiff Holt Richard   592732 592732 Holt, Richard, of Balsham, parson, on his own account 0
4750928 2280754 2280754 defendant Webbe John husbandman 592732 592732 Webbe, John, of Balsham, husbandman 0
4891371 2324031 2324031 plaintiff Bysshop John   592732 592732 Bysshop, John, of Balsham, senior 0
4891372 2324031 2324031 plaintiff Bysshop John   592732 592732 Bysshop, John, of Balsham, junior, his son 1
4904258 2327945 2327945 plaintiff Bysshop John, senior   592732 592732 Bysshop, John, senior, of Balsham 0
4904259 2327945 2327945 plaintiff Bysshop John, junior   592732 592732 Bysshop, John, junior, of Balsham, his son 1
4919510 2332607 2332607 defendant Webbe John, senior yeoman 592732 592732 Webbe, John, senior, of Balsham, yeoman 0
4919511 2332607 2332607 defendant Webbe John, junior pedder 592732 592732 Webbe, John, junior, of Balsham, pedder 1
5201709 2416265 2416265 defendant Hunt Thomas gent 592732 592732 Hunt, Thomas, of Balsham, gent 0
5218033 2421010 2421010 defendant Laker Thomas butcher 592732 592732 Laker, Thomas, of Balsham, butcher 0
5253091 2431072 2431072 defendant Norton John, senior smith 592732 592732 Norton, John, senior, of Balsham, smith 0
5253092 2431072 2431072 defendant Norton John, junior smith 592732 592732 Norton, John, junior, of Balsham, smith 1
5253093 2431072 2431072 defendant Norton Thomas laborer 592732 592732 Norton, Thomas, of Balsham, laborer 2
5253094 2431072 2431072 defendant Howell Robert laborer 592732 592732 Howell, Robert, of Balsham, laborer 3
5265299 2434906 2434906 plaintiff Blodwell Geoffrey   592732 592732 Blodwell, Geoffrey, of Balsham 2
5499503 2504796 2504796 defendant Vyncent John tailor 592732 592732 Vyncent, John, of Balsham, tailor 0
5499504 2504796 2504796 defendant Cotton Henry tailor 592732 592732 Cotton, Henry, of Balsham, tailor 1
5499508 2504798 2504798 defendant Vyncent John tailor 592732 592732 Vyncent, John, of Balsham, tailor 0
5499509 2504798 2504798 defendant Cotton Henry tailor 592732 592732 Cotton, Henry, of Balsham, tailor 1
5574858 2527217 2527217 defendant Webbe Thomas tailor 592732 592732 Webbe, Thomas, of Balsham, tailor 0
5626011 2552098 2552098 defendant Revyll John husbandman 592732 592732 Revyll, John, of Balsham, husbandman 0
5629506 2553214 2553214 defendant Tryp Thomas, junior husbandman 592732 592732 Tryp, Thomas, junior, of Balsham, husbandman 0
5635248 2554992 2554992 defendant Balle William tailor 592732 592732 Balle, William, of Balsham, tailor 2
5635249 2554992 2554992 defendant Bocher Stephen   592732 592732 Bocher, Stephen, of Balsham, cook 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);