names

81 rows where place_id = 602417

✎ 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
3650048 1910384 1910384 defendant Nicholas Richard yeoman 602417 602417 Nicholas, Richard, of Estham, yeoman 0
3650050 1910384 1910384 defendant Nicholas John yeoman 602417 602417 Nicholas, John, of Estham, yeoman 2
3679026 1919514 1919514 defendant Nicholas John yeoman 602417 602417 Nicholas, John, of Estham, yeoman 0
3679030 1919515 1919515 defendant Nicholas John yeoman 602417 602417 Nicholas, John, of Estham, yeoman 0
3680113 1919848 1919848 defendant Camberleyn Christopher yeoman 602417 602417 Camberleyn, Christopher, of Estham, yeoman 0
3680426 1919960 1919960 defendant Delwyn Richard husbandman 602417 602417 Delwyn, Richard, of Estham, husbandman 0
3680428 1919961 1919961 defendant Delwyn Richard husbandman 602417 602417 Delwyn, Richard, of Estham, husbandman 0
3689281 1922810 1922810 defendant Symmys John laborer 602417 602417 Symmys, John, of Estham, laborer 0
3689283 1922811 1922811 defendant Symmys John laborer 602417 602417 Symmys, John, of Estham, laborer 0
3706605 1928350 1928350 defendant Kyrton Joan widow 602417 602417 Kyrton, Joan, of Estham, widow 0
3706606 1928350 1928350 defendant More William laborer 602417 602417 More, William, of Estham, laborer 1
3709812 1929385 1929385 defendant Dylwyn Richard carpenter 602417 602417 Dylwyn, Richard, of Estham, carpenter 1
3719579 1932388 1932388 defendant Yeryngton Robert husbandman 602417 602417 Yeryngton, Robert, of Estham, husbandman 0
3749750 1941832 1941832 defendant Kyrton Joan widow 602417 602417 Kyrton, Joan, of Estham, widow 0
3749751 1941832 1941832 defendant More William laborer 602417 602417 More, William, of Estham, laborer 1
3755718 1943749 1943749 defendant Nyxson Thomas husbandman 602417 602417 Nyxson, Thomas, of Estham, husbandman 0
3759098 1944831 1944831 defendant Hatton Thomas husbandman 602417 602417 Hatton, Thomas, of Estham, husbandman 0
3759100 1944832 1944832 defendant Hatton Thomas husbandman 602417 602417 Hatton, Thomas, of Estham, husbandman 0
3763622 1946261 1946261 defendant Barton Richard laborer 602417 602417 Barton, Richard, of Estham, laborer 0
3763623 1946261 1946261 defendant Wylson Thomas laborer 602417 602417 Wylson, Thomas, of Estham, laborer 1
3763624 1946261 1946261 defendant Dey Thomas laborer 602417 602417 Dey, Thomas, of Estham, laborer 2
3771016 1948622 1948622 defendant Gouge Nicholas husbandman 602417 602417 (Gouge, Nicholas, of Estham, husbandman 1
3771017 1948622 1948622 defendant Gouge Richard husbandman 602417 602417 Gouge, Richard, of Estham, husbandman 2
3778738 1951066 1951066 defendant Whytehede John husbandman 602417 602417 Whytehede, John, of Estham, husbandman 0
3785292 1953187 1953187 defendant Cornwall Richard esq 602417 602417 Cornwall, Richard, of Estham, esq 0
3785293 1953187 1953187 defendant Walker John yeoman 602417 602417 Walker, John, of Estham, yeoman 1
3785294 1953187 1953187 defendant Sparre Robert clerk 602417 602417 Sparre, Robert, of Estham, clerk 2
3794852 1956258 1956258 defendant Nycholett JOhn yeoman 602417 602417 Nycholett, JOhn, of Estham, yeoman 6
3797370 1957064 1957064 defendant Gowge Richard yeoman 602417 602417 Gowge, Richard, of Estham, yeoman 0
3812252 1961734 1961734 defendant Pycholett John yeoman 602417 602417 Pycholett, John, of Estham, yeoman 1
3814629 1962485 1962485 defendant Gowge Richard yeoman 602417 602417 Gowge, Richard, of Estham, yeoman 0
3818804 1963789 1963789 defendant Walker John yeoman 602417 602417 Walker, John, of Estham, yeoman 0
3818805 1963789 1963789 defendant Nicholettys John yeoman 602417 602417 Nicholettys, John, of Estham, yeoman 1
3830101 1967314 1967314 defendant Roo Humphrey yeoman 602417 602417 Roo, Humphrey, of Estham, yeoman 0
3839321 1970225 1970225 defendant Pagge John laborer 602417 602417 Pagge, John, of Estham, laborer 2
3839322 1970225 1970225 defendant Pagge Thomas laborer 602417 602417 Pagge, Thomas, of Estham, laborer 3
3875967 1982213 1982213 defendant Nyclette James yeoman 602417 602417 Nyclette, James, of Estham, yeoman 0
3875968 1982213 1982213 defendant Walker John husbandman 602417 602417 Walker, John, of Estham, husbandman 1
3882804 1984513 1984513 defendant Gowge Henry gent 602417 602417 Gowge, Henry, of Estham, gent 1
3893011 1987907 1987907 defendant Coke Thomas yeoman 602417 602417 Coke, Thomas, of Estham, yeoman 0
3903681 1991463 1991463 defendant Walker John yeoman 602417 602417 Walker, John, of Estham, yeoman 0
3903682 1991463 1991463 defendant Calohyll John, senior husbandman 602417 602417 Calohyll, John, senior, of Estham, husbandman 1
3903683 1991463 1991463 defendant Calohyll John, junior husbandman 602417 602417 Calohyll, John, junior, of Estham, husbandman 2
3903684 1991463 1991463 defendant Former Richard laborer 602417 602417 Former, Richard, of Estham, laborer 3
3903685 1991463 1991463 defendant Calohyll Richard weaver 602417 602417 Calohyll, Richard, of Estham, weaver 4
3910171 1993715 1993715 defendant Colyns John butcher 602417 602417 Colyns, John, of Estham, butcher 0
3921903 1997672 1997672 defendant Nycolett John husbandman 602417 602417 Nycolett, John, of Estham, husbandman 0
3982168 2018384 2018384 defendant Downe John husbandman 602417 602417 Downe, John, of Estham, husbandman 0
4009303 2028091 2028091 defendant Pennell Richard yeoman 602417 602417 Pennell, Richard, of Estham, yeoman 1
4043947 2040285 2040285 plaintiff Pullmer Thomas yeoman 602417 602417 Pullmer, Thomas, of Estham, yeoman 0
4157682 2080761 2080761 defendant Waters alias Lucas Thomas yeoman 602417 602417 Waters alias Lucas, Thomas, of Estham, yeoman 2
4157696 2080766 2080766 defendant Whetston John laborer 602417 602417 Whetston, John, of Estham, laborer 1
4157941 2080847 2080847 defendant Waters alias Lucas Thomas weaver 602417 602417 Waters alias Lucas, Thomas, of Estham, weaver 0
4244592 2111174 2111174 defendant Peynter alias Smyth William husbandman 602417 602417 Peynter alias Smyth, William, of Estham, husbandman 0
4387172 2160362 2160362 defendant Perkyns Thomas, junior husbandman 602417 602417 Perkyns, Thomas, junior, of Estham, or of Hanley Cholde, husbandman 0
4397128 2163609 2163609 defendant Buston thomas husbandman 602417 602417 Buston, thomas, of Estham, husbandman 1
4413389 2169066 2169066 defendant Portere Ralph le   602417 602417 Portere, Ralph le, of Estham, parson 1
4419475 2170976 2170976 defendant Pelier Ralph   602417 602417 Pelier, Ralph, of Estham, parson 1
4426972 2173260 2173260 defendant Child Richard le   602417 602417 Child, Richard le, of Estham 0
4426974 2173261 2173261 defendant Child Richard le   602417 602417 Child, Richard le, of Estham 0
4490745 2197806 2197806 defendant Frenyhalg Richard   602417 602417 Frenyhalg, Richard, of Estham, parson 0
4528274 2209121 2209121 defendant Semgclere John   602417 602417 Semgclere, John, of Estham 0
4654787 2247374 2247374 defendant Sencler John   602417 602417 Sencler, John, of Estham, franklin 6
4720655 2271794 2271794 defendant St Cler John gent 602417 602417 St Cler, John, of Estham, gent 0
4809740 2299209 2299209 defendant Coyne William yeoman 602417 602417 Coyne, William, of Estham, yeoman 1
4904777 2328098 2328098 defendant Hopton William husbandman 602417 602417 Hopton, William, of Estham, husbandman 1
5230001 2424388 2424388 defendant Halman John fisher 602417 602417 Halman, John, of Estham, fisher 1
5235276 2425894 2425894 defendant Samkyn Roger fysher 602417 602417 Samkyn, Roger, of Estham, fysher 0
5238608 2426885 2426885 defendant Broun John fisher 602417 602417 Broun, John, of Estham, fisher 1
5285052 2440653 2440653 defendant Hall John yeoman 602417 602417 Hall, John, of Estham, yeoman 0
5510225 2508035 2508035 defendant Walker John husbandman 602417 602417 Walker, John, of Estham, husbandman 0
5516892 2510107 2510107 defendant Wode William pulter 602417 602417 Wode, William, of Estham, pulter 0
5519496 2510939 2510939 defendant at Wode William pulter 602417 602417 at Wode, William, of Estham, pulter 3
5521694 2511601 2511601 defendant Kellowe Richard laborer 602417 602417 Kellowe, Richard, of Estham, laborer 0
5522264 2511781 2511781 defendant Redehede John husbandman 602417 602417 Redehede, John, of Estham, husbandman 0
5525143 2512455 2512455 defendant Gudge Nicholas husbandman 602417 602417 Gudge, Nicholas, of Estham, husbandman 0
5534332 2515275 2515275 defendant Symmys John, junior husbandman 602417 602417 Symmys, John, junior, of Estham, husbandman 1
5534333 2515275 2515275 defendant Wode William husbandman 602417 602417 Wode, William, of Estham, husbandman 2
5556002 2521749 2521749 defendant Pontiffex William chaplain 602417 602417 Pontiffex, William, of Estham, chaplain 0
5625904 2552052 2552052 defendant Senclere John, senior gent 602417 602417 Senclere, John, senior, of Estham, gent 0
5625905 2552052 2552052 defendant Senclere John, junior gent 602417 602417 Senclere, John, junior, of Estham, gent 1

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