names

128 rows where place_id = 588862

✎ 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
3595820 1866329 1866329 defendant Domet John husbandman 588862 588862 Domet, John, of Wellyngton, husbandman 0
3626718 1903202 1903202 defendant Bartelett John yeoman 588862 588862 Bartelett, John, of Wellyngton, yeoman 0
3631613 1904702 1904702 defendant Morwan Hugh yeoman 588862 588862 Morwan, Hugh, of Wellyngton, yeoman 0
3634375 1905550 1905550 defendant Colwyll William smith 588862 588862 Colwyll, William, of Wellyngton, smith 1
3640104 1907350 1907350 defendant Seyngler John yeoman 588862 588862 Seyngler, John, of Wellyngton, yeoman 0
3640106 1907351 1907351 defendant Seyngler John yeoman 588862 588862 Seyngler, John, of Wellyngton, yeoman 0
3651726 1910895 1910895 defendant Lyffe William husbandman 588862 588862 Lyffe, William, of Wellyngton, husbandman 0
3653158 1911322 1911322 defendant Gefford John husbandman 588862 588862 Gefford, John, of Wellyngton, husbandman 0
3653159 1911322 1911322 defendant Gefford William, senior husbandman 588862 588862 Gefford, William, senior, of Wellyngton, husbandman 1
3667851 1915886 1915886 defendant Broun James yeoman 588862 588862 Broun, James, of Wellyngton, yeoman 0
3681446 1920284 1920284 defendant Senckeley John yeoman 588862 588862 Senckeley, John, of Wellyngton, yeoman 4
3684147 1921177 1921177 defendant Jennys William husbandman 588862 588862 Jennys, William, of Wellyngton, husbandman 3
3692564 1923861 1923861 defendant Coke William husbandman 588862 588862 Coke, William, of Wellyngton, husbandman 0
3695274 1924741 1924741 defendant Forster John, junior mercer 588862 588862 Forster, John, junior, of Wellyngton, mercer 0
3698728 1925818 1925818 defendant Yong John mercer 588862 588862 Yong, John, of Wellyngton, mercer 0
3714892 1930954 1930954 defendant Squyer William clerk 588862 588862 Squyer, William, of Wellyngton, clerk 0
3714895 1930954 1930954 defendant Colwyll William smith 588862 588862 Colwyll, William, of Wellyngton, smith 3
3715853 1931243 1931243 defendant Isot John   588862 588862 Isot, John, of Wellyngton, "skoser" 1
3723712 1933691 1933691 defendant Cade John yeoman 588862 588862 Cade, John, of Wellyngton, yeoman 2
3730859 1935878 1935878 plaintiff Budde John husbandman 588862 588862 Budde, John, of Wellyngton, husbandman 0
3730861 1935878 1935878 defendant Hamowde William (legal representative) 588862 588862 Hamowde, William, of Wellyngton, husbandman, executrix of 0
3730862 1935878 1935878 defendant Hamowde Agnes widow 588862 588862 Hamowde, Agnes, of Wellyngton, widow 1
3740065 1938747 1938747 defendant att Lee John husbandman 588862 588862 att Lee, John, of Wellyngton, husbandman 0
3743027 1939666 1939666 defendant Chate Nicholas smith 588862 588862 Chate, Nicholas, of Wellyngton, smith 0
3743089 1939691 1939691 defendant Gregory John husbandman 588862 588862 Gregory, John, of Wellyngton, husbandman 0
3743345 1939790 1939790 defendant Ley John husbandman 588862 588862 Ley, John, of Wellyngton, husbandman 0
3751595 1942413 1942413 defendant Rox John barker 588862 588862 Rox, John, of Wellyngton, barker 1
3752897 1942831 1942831 defendant Baskervyle William gent 588862 588862 Baskervyle, William, of Wellyngton, gent 0
3764236 1946470 1946470 defendant Bud William merchant 588862 588862 Bud, William, of Wellyngton, merchant 0
3764237 1946470 1946470 defendant Yong John mercer 588862 588862 Yong, John, of Wellyngton, mercer 1
3764240 1946471 1946471 defendant Ball Hugh yeoman 588862 588862 Ball, Hugh, of Wellyngton, yeoman 1
3769791 1948206 1948206 defendant Baskervyle William gent 588862 588862 Baskervyle, William, of Wellyngton, gent 0
3782139 1952165 1952165 defendant Yong John mercer 588862 588862 Yong, John, of Wellyngton, mercer 0
3789017 1954377 1954377 defendant Baker Thomas laborer 588862 588862 Baker, Thomas, of Wellyngton, laborer 0
3790835 1954961 1954961 defendant Chydley John painter 588862 588862 Chydley, John, of Wellyngton, painter 0
3791654 1955233 1955233 plaintiff Yorke Roger gent 588862 588862 Yorke, Roger, of Wellyngton, gent 0
3791830 1955291 1955291 defendant Coldwyll William smith 588862 588862 Coldwyll, William, of Wellyngton, smith 1
3791831 1955291 1955291 defendant Waren William tucker 588862 588862 Waren, William, of Wellyngton, tucker 2
3806821 1960038 1960038 defendant Towne William yeoman 588862 588862 Towne, William, of Wellyngton, yeoman 0
3806824 1960038 1960038 defendant Gisham or Eisham Edmund husbandman 588862 588862 Gisham or Eisham, Edmund, of Wellyngton, husbandman 3
3814713 1962514 1962514 defendant Coldwill William smith 588862 588862 Coldwill, William, of Wellyngton, smith 0
3819232 1963902 1963902 defendant Yong John mercer 588862 588862 Yong, John, of Wellyngton, mercer 0
3828405 1966755 1966755 defendant Coldwyll William smith 588862 588862 Coldwyll, William, of Wellyngton, smith 0
3829246 1967029 1967029 defendant Paynter alias Chudley John painter 588862 588862 Paynter alias Chudley, John, of Wellyngton, painter 0
3859596 1976703 1976703 defendant Coke William husbandman 588862 588862 Coke, William, of Wellyngton, husbandman 0
3875117 1981911 1981911 defendant Yevance Alice widow 588862 588862 Yevance, Alice, of Wellyngton, widow 2
3879364 1983352 1983352 plaintiff Calveley James   588862 588862 Calveley, James, of Wellyngton 3
3893258 1987976 1987976 defendant Farley John yeoman 588862 588862 Farley, John, of Wellyngton, yeoman 0
3896695 1989104 1989104 defendant Waryn William, senior clothier 588862 588862 Waryn, William, senior, of Wellyngton, clothier 0
3898315 1989646 1989646 defendant Cape Thomas husbandman 588862 588862 Cape, Thomas, of Wellyngton, husbandman 1
3899149 1989922 1989922 defendant Smyth James clerk 588862 588862 Smyth, James, of Wellyngton, clerk 0
3911057 1994026 1994026 defendant Boole Robert husbandman 588862 588862 Boole, Robert, of Wellyngton, husbandman 2
3911058 1994026 1994026 defendant Collyns Walter husbandman 588862 588862 Collyns, Walter, of Wellyngton, husbandman 3
3911077 1994030 1994030 defendant Frye William husbandman 588862 588862 Frye, William, of Wellyngton, husbandman 1
3911078 1994030 1994030 defendant Lamprey John husbandman 588862 588862 Lamprey, John, of Wellyngton, husbandman 2
3915785 1995657 1995657 defendant Stere William husbandman 588862 588862 Stere, William, of Wellyngton, husbandman 0
3923763 1998253 1998253 defendant Teryll alias Peerse John husbandman 588862 588862 Teryll alias Peerse, John, of Wellyngton, husbandman 1
3924785 1998607 1998607 defendant Warren William, senior clothier 588862 588862 Warren, William, senior, of Wellyngton, clothier 1
3925440 1998822 1998822 defendant Colwyll William smith 588862 588862 Colwyll, William, of Wellyngton, smith 0
3925441 1998822 1998822 defendant Oterey Walter husbandman 588862 588862 Oterey, Walter, of Wellyngton, husbandman 1
3925442 1998822 1998822 defendant Cranmer George husbandman 588862 588862 Cranmer, George, of Wellyngton, husbandman 2
3925443 1998822 1998822 defendant Whytknyght William husbandman 588862 588862 Whytknyght, William, of Wellyngton, husbandman 3
3937932 2003019 2003019 defendant Lone John laborer 588862 588862 Lone, John, of Wellyngton, laborer 2
3945265 2005429 2005429 defendant Stone Henry smith 588862 588862 Stone, Henry, of Wellyngton, smith 0
3945350 2005457 2005457 defendant Scere William yeoman 588862 588862 Scere, William, of Wellyngton, yeoman 0
3946146 2005729 2005729 defendant Pers William weaver 588862 588862 Pers, William, of Wellyngton, weaver 0
3946425 2005820 2005820 defendant Corfyld Richard husbandman 588862 588862 Corfyld, Richard, of Wellyngton, husbandman 0
3946426 2005820 2005820 defendant Gronowe Ralph laborer 588862 588862 Gronowe, Ralph, of Wellyngton, laborer 1
3968084 2013461 2013461 defendant Norman Edward yeoman 588862 588862 Norman, Edward, of Wellyngton, yeoman 0
3970666 2014328 2014328 defendant Corfield Richard husbandman 588862 588862 Corfield, Richard, of Wellyngton, husbandman 0
4026056 2033966 2033966 defendant Haworth alias Saunders John yeoman 588862 588862 Haworth alias Saunders, John, of Wellyngton, yeoman 0
4026058 2033967 2033967 defendant Haworth alias Saunders John yeoman 588862 588862 Haworth alias Saunders, John, of Wellyngton, yeoman 0
4056880 2044841 2044841 defendant Wheler Walter yeoman 588862 588862 Wheler, Walter, of Wellyngton, yeoman 1
4069903 2049519 2049519 defendant Evisham William yeoman 588862 588862 Evisham, William, of Wellyngton, yeoman 0
4070076 2049587 2049587 defendant Woloon Robert clothier 588862 588862 Woloon, Robert, of Wellyngton, clothier 1
4073046 2050655 2050655 defendant Lee Thomas innholder 588862 588862 Lee, Thomas, of Wellyngton, innholder 0
4085411 2055058 2055058 defendant Evens George husbandman 588862 588862 Evens, George, of Wellyngton, husbandman 0
4087016 2055648 2055648 defendant Barbor William laborer 588862 588862 Barbor, William, of Wellyngton, laborer 3
4143334 2075832 2075832 defendant Wootton Henry clerk 588862 588862 Wootton, Henry, of Wellyngton, or of Canon Pewne, clerk 3
4157861 2080825 2080825 defendant Barboure William husbandman 588862 588862 Barboure, William, of Wellyngton, husbandman 0
4190219 2092085 2092085 defendant Webb Lewis husbandman 588862 588862 Webb, Lewis, of Wellyngton, husbandman 2
4213121 2100114 2100114 defendant Haworthe John gent 588862 588862 Haworthe, John, of Wellyngton, gent 0
4294291 2128035 2128035 defendant Wootton Henry clerk 588862 588862 Wootton, Henry, of Wellyngton, clerk 0
4301495 2130638 2130638 defendant Wootton Henry clerk 588862 588862 Wootton, Henry, of Wellyngton, clerk 1
4302809 2131103 2131103 defendant Wootton Henry clerk 588862 588862 Wootton, Henry, of Wellyngton, clerk 0
4342709 2144724 2144724 defendant Pirrye Thomas gent 588862 588862 Pirrye, Thomas, of Wellyngton, gent 0
4369552 2154168 2154168 defendant Oldys Dorothy spinster 588862 588862 Oldys, Dorothy, of Wellyngton, spinster 4
4551894 2216540 2216540 defendant Newechurche John   588862 588862 Newechurche, John, of Wellyngton 0
4620841 2237498 2237498 defendant Taillour John   588862 588862 Taillour, John, of Wellyngton 0
4765267 2285119 2285119 defendant Hunt Robert gent 588862 588862 Hunt, Robert, of Wellyngton, gent 0
4789447 2292765 2292765 defendant Hunt Robert gent 588862 588862 Hunt, Robert, of Wellyngton, gent 0
4858789 2314124 2314124 defendant Moubray John laborer 588862 588862 Moubray, John, of Wellyngton, laborer 0
4862897 2315381 2315381 defendant Knyght John butcher 588862 588862 Knyght, John, of Wellyngton, butcher 0
4862898 2315381 2315381 defendant Cancy John shoemaker 588862 588862 Cancy, John, of Wellyngton, shoemaker 1
4911484 2330093 2330093 defendant Lene or Leve John baker 588862 588862 Lene or Leve, John, of Wellyngton, baker 0
4911485 2330093 2330093 defendant Sely Walter husbandman 588862 588862 Sely, Walter, of Wellyngton, husbandman 1
4911488 2330094 2330094 defendant Seby Walter husbandman 588862 588862 Seby, Walter, of Wellyngton, husbandman 1
4994867 2355317 2355317 defendant Cock Richard husbandman 588862 588862 Cock, Richard, of Wellyngton, husbandman 1
5087275 2382659 2382659 defendant Touker Andrew tucker 588862 588862 Touker, Andrew, of Wellyngton, tucker 0
5232312 2425030 2425030 defendant Appelyn Geoffrey husbandman 588862 588862 Appelyn, Geoffrey, of Wellyngton, husbandman 1

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