names

147 rows where place_id = 590026

✎ 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
3599620 1867520 1867520 defendant Danyell Richard butcher 590026 590026 Danyell, Richard, of Higham, butcher 2
3604600 1869103 1869103 defendant Thorne John butcher 590026 590026 Thorne, John, of Higham, butcher 0
3608934 1870452 1870452 defendant Hawkyns Thomas yeoman 590026 590026 Hawkyns, Thomas, of Higham, yeoman 0
3631489 1904662 1904662 plaintiff Grene John   590026 590026 Grene, John, of Higham 3
3638121 1906740 1906740 defendant Elys William husbandman 590026 590026 Elys, William, of Higham, husbandman 0
3660456 1913530 1913530 defendant Fuller John husbandman 590026 590026 Fuller, John, of Higham, husbandman 0
3666574 1915483 1915483 plaintiff (not given) Anchoreta prioress of Ungothorpe 590026 590026 Ungothorpe, Anchoreta, of Higham, prioress of the priory & convent 0
3699836 1926173 1926173 defendant Gedge John butcher 590026 590026 Gedge, John, of Higham, butcher 2
3704757 1927776 1927776 defendant Wryght John   590026 590026 Wryght, John, of Higham, freemason 1
3710601 1929639 1929639 defendant Brygeman Richard sherman 590026 590026 Brygeman, Richard, of Higham, sherman 1
3725969 1934392 1934392 defendant Henkell Richard husbandman 590026 590026 Henkell, Richard, of Higham, husbandman 2
3726850 1934666 1934666 defendant Garlyke Thomas husbandman 590026 590026 Garlyke, Thomas, of Higham, husbandman 0
3736384 1937622 1937622 plaintiff Hylton Elias   590026 590026 Hylton, Elias, of Higham 0
3742961 1939647 1939647 defendant Shyrwode John fuller 590026 590026 Shyrwode, John, of Higham, fuller 3
3758995 1944801 1944801 defendant Cappe John butcher 590026 590026 Cappe, John, of Higham, butcher 2
3765649 1946921 1946921 defendant Gage John husbandman 590026 590026 Gage, John, of Higham, husbandman 0
3771958 1948922 1948922 defendant Cole Andrew clothmaker 590026 590026 Cole, Andrew, of Higham, clothmaker 2
3794404 1956126 1956126 defendant Cappe John butcher 590026 590026 Cappe, John, of Higham, butcher 1
3801849 1958474 1958474 defendant Higham Thomas esq 590026 590026 Higham, Thomas, of Higham, esq 1
3845789 1972232 1972232 defendant Cole Andrew clothmaker 590026 590026 Cole, Andrew, of Higham, clothmaker 0
3874861 1981812 1981812 defendant Barret William gent 590026 590026 Barret, William, of Higham, gent 0
3874914 1981835 1981835 defendant Bennett Thomas, senior yeoman 590026 590026 Bennett, Thomas, senior, of Higham, yeoman 0
3896789 1989137 1989137 defendant Perott John yeoman 590026 590026 Perott, John, of Higham, yeoman 3
3897374 1989338 1989338 defendant Peratt John husbandman 590026 590026 Peratt, John, of Higham, husbandman 0
3908105 1993009 1993009 defendant Jenkyns George miller 590026 590026 Jenkyns, George, of Higham Ferer, miller 0
3908106 1993009 1993009 defendant Carter Robert butcher 590026 590026 Carter, Robert, of Higham Ferer, butcher 1
3908989 1993300 1993300 defendant Pytman Ralph butcher 590026 590026 Pytman, Ralph, of Higham Ferer, butcher 1
3911925 1994312 1994312 defendant Bore Alexander husbandman 590026 590026 Bore, Alexander, of Higham, husbandman 2
3915132 1995420 1995420 defendant Boyes Walter yeoman 590026 590026 Boyes, Walter, of Higham Potter, yeoman 1
3923622 1998210 1998210 defendant Gilbert Alexander husbandman 590026 590026 Gilbert, Alexander, of Higham, husbandman 4
3951347 2007540 2007540 plaintiff Gryffyn alias Peryn John yeoman 590026 590026 Gryffyn alias Peryn, John, of Higham, yeoman 0
3995112 2022999 2022999 defendant Gyney William husbandman 590026 590026 Gyney, William, of Higham, husbandman 1
4015416 2030208 2030208 defendant Spyre Williaam clothier 590026 590026 Spyre, Williaam, of Higham, clothier 0
4016807 2030708 2030708 defendant Speare William clothier 590026 590026 Speare, William, of Higham, clothier 0
4016808 2030708 2030708 defendant Walker Christopher carpenter 590026 590026 Walker, Christopher, of Higham, carpenter 1
4058519 2045436 2045436 defendant Walton Anne widow 590026 590026 Walton, Anne, of Higham, widow 2
4094393 2058335 2058335 defendant Cobham Thomas gent 590026 590026 Cobham, Thomas, of Higham, gent 0
4139183 2074380 2074380 defendant Browne George yeoman 590026 590026 Browne, George, of Higham, yeoman 0
4139184 2074380 2074380 defendant Welye Randolph yeoman 590026 590026 Welye, Randolph, of Higham, yeoman 1
4139185 2074380 2074380 defendant Bridges Robert husbandman 590026 590026 Bridges, Robert, of Higham, husbandman 2
4142110 2075416 2075416 defendant Johnson John, senior husbandman 590026 590026 Johnson, John, senior, of Higham, husbandman 0
4161336 2082045 2082045 defendant Fenner Edmund blacksmith 590026 590026 Fenner, Edmund, of Higham, blacksmith 1
4183630 2089759 2089759 defendant Weleigh Randolph yeoman 590026 590026 Weleigh, Randolph, of Higham, yeoman 0
4186068 2090615 2090615 defendant Wallys Edward yeoman 590026 590026 Wallys, Edward, of Higham, yeoman 0
4186932 2090917 2090917 defendant Goole John husbandman 590026 590026 Goole, John, of Higham, husbandman 0
4193527 2093304 2093304 defendant Swayne Robert yeoman 590026 590026 Swayne, Robert, of Higham, yeoman 0
4205418 2097448 2097448 defendant Wallys Edward yeoman 590026 590026 Wallys, Edward, of Higham, yeoman 0
4209853 2099007 2099007 defendant Wallys Edward yeoman 590026 590026 Wallys, Edward, of Higham, yeoman 0
4324000 2138436 2138436 defendant Smyth alias Ball William laborer 590026 590026 Smyth alias Ball, William, of Higham, laborer 0
4331292 2140761 2140761 defendant Smyth alias Ball John laborer 590026 590026 Smyth alias Ball, John, of Higham, laborer 0
4336142 2142372 2142372 defendant Awbrye John yeoman 590026 590026 Awbrye, John, of Higham, yeoman 0
4383941 2159334 2159334 defendant Smyth William laborer 590026 590026 Smyth, William, of Higham, laborer 0
4411398 2168402 2168402 defendant Colley John husbandman 590026 590026 Colley, John, of Higham, husbandman 1
4561693 2219593 2219593 defendant Wyghtemore John   590026 590026 Wyghtemore, John, of Higham 0
4597410 2230433 2230433 defendant Smyth Simon   590026 590026 Smyth, Simon, of Higham 3
4650782 2246248 2246248 defendant Souter John   590026 590026 Souter, John, of Higham 4
4685334 2261009 2261009 defendant Bere William   590026 590026 Bere, William, of Higham, mustard maker 3
4685335 2261009 2261009 defendant Bocher Thomas butcher 590026 590026 Bocher, Thomas, of Higham, butcher 4
4685336 2261009 2261009 defendant Smyth John smith 590026 590026 Smyth, John, of Higham, smith 5
4703654 2266521 2266521 defendant Anmener Thomas   590026 590026 Anmener, Thomas, of Higham, plough man 1
4703657 2266522 2266522 defendant Aumomer Thomas   590026 590026 Aumomer, Thomas, of Higham, plough man 1
4740046 2277604 2277604 defendant Bonde Henry husbandman 590026 590026 Bonde, Henry, of Higham, husbandman 0
4740048 2277604 2277604 defendant Power John, junior husbandman 590026 590026 Power, John, junior, of Higham, husbandman 2
4743349 2278583 2278583 defendant Meleward John husbandman 590026 590026 Meleward, John, of Higham, husbandman 1
4743350 2278583 2278583 defendant Totegos John husbandman 590026 590026 Totegos, John, of Higham, husbandman 2
4881430 2321092 2321092 defendant Stevenson William husbandman 590026 590026 Stevenson, William, of Higham, husbandman 2
4915369 2331315 2331315 defendant Reymes John (legal representative) 590026 590026 Reymes, John, of Higham, gent, executrix of 1
4944095 2340121 2340121 defendant Peke William   590026 590026 Peke, William, of Higham, franklin 0
4996293 2355750 2355750 defendant Peke William   590026 590026 Peke, William, of Higham, franklin 0
5019860 2362687 2362687 defendant Strout John yeoman 590026 590026 Strout, John, of Higham, yeoman 0
5019861 2362687 2362687 defendant Page John yeoman 590026 590026 Page, John, of Higham, yeoman 1
5030571 2365813 2365813 defendant Broungyng Ralph baker 590026 590026 Broungyng, Ralph, of Higham, baker 3
5075957 2379302 2379302 defendant atte Rede Benedict butcher 590026 590026 atte Rede, Benedict, of Higham, butcher 0
5081373 2380935 2380935 defendant Page William weaver 590026 590026 Page, William, of Higham, weaver 1
5093003 2384343 2384343 defendant Page John smith 590026 590026 Page, John, of Higham, smith 1
5093005 2384343 2384343 defendant Page William weaver 590026 590026 Page, William, of Higham, weaver 3
5095128 2384991 2384991 defendant Hacon Robert yeoman 590026 590026 Hacon, Robert, of Higham, yeoman 0
5118405 2391820 2391820 plaintiff Robyns William   590026 590026 Robyns, William, of Higham Ferrer 0
5165449 2405639 2405639 defendant Hakon Robert fuller 590026 590026 Hakon, Robert, of Higham, fuller 1
5168042 2406364 2406364 defendant Skynner John husbandman 590026 590026 Skynner, John, of Higham, husbandman 0
5168043 2406364 2406364 defendant Peke Nicholas husbandman 590026 590026 Peke, Nicholas, of Higham, husbandman 1
5179528 2409745 2409745 defendant Hakon Robert fuller 590026 590026 Hakon, Robert, of Higham, fuller 1
5203235 2416711 2416711 defendant Cobold Thomas husbandman 590026 590026 Cobold, Thomas, of Higham, husbandman 0
5203236 2416711 2416711 defendant Pell Christopher husbandman 590026 590026 Pell, Christopher, of Higham, husbandman 1
5203237 2416711 2416711 defendant Pell Thomas husbandman 590026 590026 Pell, Thomas, of Higham, husbandman 2
5203238 2416711 2416711 defendant Burgeaunt Henry husbandman 590026 590026 Burgeaunt, Henry, of Higham, husbandman 3
5221413 2421961 2421961 defendant Mellys Robert fuller 590026 590026 Mellys, Robert,of Higham, fuller 3
5233493 2425388 2425388 defendant Cobold Thomas husbandman 590026 590026 Cobold, Thomas, of Higham, husbandman 0
5233494 2425388 2425388 defendant Pell Christopher husbandman 590026 590026 Pell, Christopher, of Higham, husbandman 1
5233495 2425388 2425388 defendant Pell Thomas husbandman 590026 590026 Pell, Thomas, of Higham, husbandman 2
5233496 2425388 2425388 defendant Burgeaunt Henry husbandman 590026 590026 Burgeaunt, Henry, of Higham, husbandman 3
5258698 2432840 2432840 defendant Bonde Henry husbandman 590026 590026 Bonde, Henry, of Higham, husbandman 0
5258699 2432840 2432840 defendant Edeson Thomas husbandman 590026 590026 Edeson, Thomas, of Higham, husbandman 1
5258700 2432840 2432840 defendant Chacombe John husbandman 590026 590026 Chacombe, John, of Higham, husbandman 2
5258701 2432840 2432840 defendant Chacombe Richard husbandman 590026 590026 Chacombe, Richard, of Higham, husbandman 3
5258703 2432841 2432841 defendant Bonde Henry husbandman 590026 590026 Bonde, Henry, of Higham, husbandman 0
5258704 2432841 2432841 defendant Edeson Thomas husbandman 590026 590026 Edeson, Thomas, of Higham, husbandman 1
5258705 2432841 2432841 defendant Chacombe John husbandman 590026 590026 Chacombe, John, of Higham, husbandman 2
5258706 2432841 2432841 defendant Chacombe Richard husbandman 590026 590026 Chacombe, Richard, of Higham, husbandman 3
5269271 2436113 2436113 defendant Peke Nicholas yeoman 590026 590026 Peke, Nicholas, of Higham, yeoman 5

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