names

71 rows where place_id = 599278

✎ 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
3636088 1906078 1906078 defendant Seresent John husbandman 599278 599278 Seresent, John, of Boyton, husbandman 0
3655235 1911894 1911894 defendant Gersent John husbandman 599278 599278 Gersent, John, of Boyton, husbandman 0
3659280 1913157 1913157 defendant Dauntecy John gent 599278 599278 Dauntecy, John, of Boyton, gent 0
3663890 1914646 1914646 defendant Sersent John husbandman 599278 599278 Sersent, John, of Boyton, husbandman 0
3748346 1941413 1941413 defendant Odams William husbandman 599278 599278 Odams, William, of Boyton, husbandman 2
3752038 1942558 1942558 defendant Sylver George husbandman 599278 599278 Sylver, George, of Boyton, husbandman 2
3775522 1950087 1950087 defendant Bonam Leonard husbandman 599278 599278 Bonam, Leonard, of Boyton, husbandman 1
3789362 1954494 1954494 plaintiff Thirkyll John   599278 599278 Thirkyll, John, of Boyton 0
3791513 1955185 1955185 defendant Barfote William husbandman 599278 599278 Barfote, William, of Boyton, husbandman 2
3886349 1985689 1985689 defendant Randale Robert   599278 599278 Randale, Robert, of Boyton, yeoman, bailiff of Cawden amd Cadworth Hundred 0
3904443 1991732 1991732 defendant Kyrby William (legal representative) 599278 599278 Kyrby, William, of Boyton, yeoman, executors of 0
3904444 1991732 1991732 defendant Brande William husbandman 599278 599278 (Brande, William, of Boyton, husbandman 1
3942931 2004641 2004641 defendant Cowper Nicholas husbandman 599278 599278 Cowper, Nicholas, of Boyton, husbandman 0
3954492 2008640 2008640 defendant Pystor Tristram gent 599278 599278 Pystor, Tristram, of Boyton, gent 0
3965722 2012627 2012627 defendant Pystor Tristram gent 599278 599278 Pystor, Tristram, of Boyton, gent 0
3966624 2012962 2012962 defendant Sallerman Hugh   599278 599278 Sallerman, Hugh, of Boyton husbandman 1
3970351 2014228 2014228 defendant Pyster Tristram gent 599278 599278 Pyster, Tristram, of Boyton, gent 0
3978515 2017063 2017063 defendant Crowche Robert yeoman 599278 599278 Crowche, Robert, of Boyton, yeoman 2
4032664 2036333 2036333 defendant Browne Richard husbandman 599278 599278 Browne, Richard, of Boyton, husbandman 0
4032665 2036333 2036333 defendant Browne Nicholas husbandman 599278 599278 Browne, Nicholas, of Boyton, husbandman 1
4032666 2036333 2036333 defendant Browne Roger   599278 599278 Browne, Roger, of Boyton, groom 2
4038624 2038452 2038452 defendant Veale William yeoman 599278 599278 Veale, William, of Boyton, yeoman 2
4046601 2041236 2041236 defendant Croke John carpenter 599278 599278 Croke, John, of Boyton, carpenter 0
4092086 2057465 2057465 defendant Towyll Richard weaver 599278 599278 Towyll, Richard, of Boyton, weaver 2
4092090 2057466 2057466 defendant Tovyll Richard weaver 599278 599278 Tovyll, Richard, of Boyton, weaver 2
4184242 2089986 2089986 defendant Escott Thomas smith 599278 599278 Escott, Thomas, of Boyton, smith 0
4190252 2092097 2092097 defendant Haynes Simon husbandman 599278 599278 Haynes, Simon, of Boyton, husbandman 0
4275005 2121211 2121211 defendant Thorne John, junior husbandman 599278 599278 Thorne, John, junior, of Boyton, husbandman 0
4322640 2137986 2137986 defendant Parson Hugh gent 599278 599278 Parson, Hugh, of Boyton, gent 0
4327802 2139622 2139622 defendant Gronell or Grovell Thomas husbandman 599278 599278 Gronell or Grovell, Thomas, of Boyton, husbandman 2
4332687 2141217 2141217 defendant Fowler Richard husbandman 599278 599278 Fowler, Richard, of Boyton, husbandman 0
4332689 2141217 2141217 defendant Diccon Thomas, junior husbandman 599278 599278 Diccon, Thomas, junior, of Boyton, husbandman 2
4332690 2141217 2141217 defendant Bunting Christopher   599278 599278 Bunting, Christopher, of Boyton, shepherd 3
4385001 2159675 2159675 defendant Warren John husbandman 599278 599278 Warren, John, of Boyton, husbandman 1
4442797 2182704 2182704 defendant Aldham John   599278 599278 Aldham, John, of Boyton 0
4442799 2182705 2182705 defendant Aldham John   599278 599278 Aldham, John, of Boyton 0
4554859 2217447 2217447 defendant Draper Richard   599278 599278 Draper, Richard, of Boyton 2
4554868 2217450 2217450 defendant Draper Richard   599278 599278 Draper, Richard, of Boyton 2
4593250 2229185 2229185 plaintiff Palmere William chaplain 599278 599278 Palmere, William, of Boyton, chaplain 0
4630959 2240575 2240575 plaintiff Swyft John   599278 599278 Swyft, John, of Boyton, parson 0
4657876 2248349 2248349 defendant Mouse Richard yeoman 599278 599278 Mouse, Richard, of Boyton, yeoman 0
4737027 2276710 2276710 defendant Mathy John chaplain 599278 599278 Mathy, John, of Boyton, chaplain 0
4752352 2281147 2281147 defendant Tropenell John husbandman 599278 599278 Tropenell, John, of Boyton, husbandman 0
4758558 2283055 2283055 defendant Courteys Thomas husbandman 599278 599278 Courteys, Thomas, of Boyton, husbandman 0
4800267 2296262 2296262 defendant Talbot John husbandman 599278 599278 Talbot, John, of Boyton, husbandman 0
4834837 2306899 2306899 defendant Claydon John husbandman 599278 599278 Claydon, John, of Boyton, husbandman 1
4959979 2344946 2344946 defendant Hode Thomas chaplain 599278 599278 Hode, Thomas, of Boyton, chaplain 0
5054972 2373050 2373050 defendant Hanke or Hauke Thomas laborer 599278 599278 Hanke or Hauke, Thomas, of Boyton, laborer 1
5145943 2399940 2399940 plaintiff Brygon William   599278 599278 Brygon, William, of Boyton, parson 0
5166253 2405851 2405851 plaintiff Brygon William   599278 599278 Brygon, William, of Boyton, parson 0
5177433 2409095 2409095 defendant Wandre Roger yeoman 599278 599278 Wandre, Roger, of Boyton, yeoman 1
5181013 2410186 2410186 plaintiff Brygon William   599278 599278 Brygon, William, of Boyton, parson 0
5211492 2419098 2419098 defendant Wandre Roger yeoman 599278 599278 Wandre, Roger, of Boyton, yeoman 1
5235447 2425946 2425946 defendant Burwell Thomas   599278 599278 Burwell, Thomas, of Boyton, mason 1
5242736 2428081 2428081 defendant Somer William clothier 599278 599278 Somer, William, of Boyton, clothier 5
5319706 2450989 2450989 defendant Vela Thomas chaplain 599278 599278 Vela, Thomas, of Boyton, chaplain 3
5319707 2450989 2450989 defendant Pedeler John laborer 599278 599278 Pedeler, John, of Boyton, laborer 4
5319708 2450989 2450989 defendant Sutton Thomas laborer 599278 599278 Sutton, Thomas, of Boyton, laborer 5
5320363 2451176 2451176 defendant Burwell Thomas   599278 599278 Burwell, Thomas, of Boyton, mason 2
5373956 2467451 2467451 defendant Estcote William husbandman 599278 599278 Estcote, William, of Boyton, husbandman 0
5402014 2475639 2475639 defendant Plummer John chaplain 599278 599278 Plummer, John, of Boyton, chaplain 0
5414947 2479402 2479402 defendant Plummer John chaplain 599278 599278 Plummer, John, of Boyton, chaplain 0
5422602 2481712 2481712 defendant Plomer John, sen clerk & parson 599278 599278 Plomer, John, sen, of Boyton, clerk & parson 0
5441914 2487511 2487511 defendant Mose Henry husbandman 599278 599278 Mose, Henry, of Boyton, husbandman 0
5442200 2487588 2487588 defendant Plomer John clerk 599278 599278 Plomer, John, of Boyton, senior, clerk 0
5454714 2491332 2491332 defendant Mose Henry husbandman 599278 599278 Mose, Henry, of Boyton, husbandman 0
5466559 2494938 2494938 defendant Mose Henry husbandman 599278 599278 Mose, Henry, of Boyton, husbandman 0
5489659 2501788 2501788 defendant Plomer John clerk 599278 599278 Plomer, John, of Boyton, clerk 0
5543826 2518177 2518177 defendant Peck Ralph husbandman 599278 599278 Peck, Ralph, of Boyton, husbandman 1
5543827 2518177 2518177 defendant Dounyng Robert husbandman 599278 599278 Dounyng, Robert, of Boyton, husbandman 2
5580319 2528927 2528927 defendant Gyldern Edmund mariner 599278 599278 Gyldern, Edmund, of Boyton, mariner 0

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