names

64 rows where place_id = 601709

✎ 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
3646636 1909353 1909353 defendant Bukkenham Richard tailor 601709 601709 Bukkenham, Richard, of Kelsale, tailor 2
3709711 1929348 1929348 defendant Heymond John butcher 601709 601709 Heymond, John, of Kelsale, butcher 1
3709716 1929349 1929349 defendant Heymond John butcher 601709 601709 Heymond, John, of Kelsale, butcher 1
3743024 1939665 1939665 defendant Manfeld John husbandman 601709 601709 Manfeld, John, of Kelsale, husbandman 1
3799349 1957717 1957717 defendant Robardys Richard clerk 601709 601709 Robardys, Richard, of Kelsale, clerk 0
3799353 1957719 1957719 defendant Robardys Richard clerk 601709 601709 Robardys, Richard, of Kelsale, clerk 0
3828397 1966753 1966753 defendant Thurston Robert yeoman 601709 601709 Thurston, Robert, of Kelsale, yeoman 0
3846158 1972354 1972354 plaintiff Gede William, junior   601709 601709 Gede, William, junior, of Kelsale 0
3846159 1972354 1972354 defendant Hale Reginald yeoman 601709 601709 Hale, Reginald, of Kelsale, yeoman 0
3855266 1975283 1975283 defendant Shanke Robert husbandman 601709 601709 Shanke, Robert, of Kelsale, husbandman 0
3859416 1976638 1976638 defendant Thurston Robert yeoman 601709 601709 Thurston, Robert, of Kelsale, yeoman 0
3863158 1977881 1977881 defendant Ede Margery spinster 601709 601709 Ede, Margery, of Kelsale, spinster 0
3886949 1985899 1985899 defendant Shanke Robert husbandman 601709 601709 Shanke, Robert, of Kelsale, husbandman 0
3890036 1986903 1986903 defendant Crowe John husbandman 601709 601709 Crowe, John, of Kelsale, husbandman 0
3890841 1987204 1987204 defendant Kenry Stephen husbandman 601709 601709 Kenry, Stephen, of Kelsale, husbandman 2
3891899 1987543 1987543 defendant Lynde William mariner 601709 601709 Lynde, William, of Kelsale, mariner 1
3901953 1990881 1990881 defendant Shank Robert husbandman 601709 601709 Shank, Robert, of Kelsale, husbandman 0
3904157 1991634 1991634 defendant Crowe John husbandman 601709 601709 Crowe, John, of Kelsale, husbandman 0
3943268 2004768 2004768 defendant Dedy Thomas laborer 601709 601709 Dedy, Thomas, of Kelsale, laborer 1
3956899 2009483 2009483 plaintiff Parker Mildred gentlewoman 601709 601709 Parker, Mildred, of Kelsale, widow, gentlewoman 0
3958107 2009905 2009905 plaintiff Raynolde William husbandman 601709 601709 Raynolde, William, of Kelsale, husbandman 0
3960497 2010771 2010771 defendant Sudbury alias Game William yeoman 601709 601709 Sudbury alias Game, William, of Kelsale, yeoman 0
3973405 2015269 2015269 plaintiff Grosse William   601709 601709 Grosse, William, of Kelsale 0
3973407 2015270 2015270 plaintiff Grosse William   601709 601709 Grosse, William, of Kelsale 0
3993192 2022310 2022310 defendant Algar Thomas potter 601709 601709 Algar, Thomas, of Kelsale, potter 1
4044579 2040513 2040513 plaintiff Reve Nicholas (legal representative) 601709 601709 Reve, Nicholas, of Kelsale, executors of 0
4232823 2106985 2106985 defendant Goose Thomas yeoman 601709 601709 Goose, Thomas, of Kelsale, yeoman 3
4241488 2110135 2110135 defendant Goose Thomas yeoman 601709 601709 Goose, Thomas, of Kelsale, yeoman 3
4250791 2113242 2113242 defendant Pratte John yeoman 601709 601709 Pratte, John, of Kelsale, yeoman 0
4274433 2121005 2121005 defendant Lusse or Luffe John yeoman 601709 601709 Lusse or Luffe, John, of Kelsale, yeoman 0
4690936 2262695 2262695 defendant Colvyle John butcher 601709 601709 Colvyle, John, of Kelsale, butcher 0
4721154 2271951 2271951 defendant Colvyle John butcher 601709 601709 Colvyle, John, of Kelsale, butcher 0
4752354 2281148 2281148 defendant Colvyle John yeoman 601709 601709 Colvyle, John, of Kelsale, yeoman 0
4795982 2294890 2294890 defendant Davy William laborer 601709 601709 Davy, William, of Kelsale, laborer 2
4915962 2331489 2331489 defendant Fysk Richard husbandman 601709 601709 Fysk, Richard, of Kelsale, husbandman 0
4926252 2334635 2334635 defendant Caythorp Roger husbandman 601709 601709 Caythorp, Roger, of Kelsale, husbandman 0
4949118 2341714 2341714 defendant Hose Stephen   601709 601709 Hose, Stephen, of Kelsale 0
4962450 2345673 2345673 defendant Steyke Robert husbandman 601709 601709 Steyke, Robert, of Kelsale, husbandman 1
4989606 2353818 2353818 defendant Hese Stephen   601709 601709 Hese, Stephen, of Kelsale 0
5045563 2370303 2370303 defendant Bacheler John, senior engraver 601709 601709 Bacheler, John, senior, of Kelsale, engraver 0
5045564 2370303 2370303 defendant Bacheler John, junior   601709 601709 Bacheler, John, junior, of Kelsale, servant 1
5202524 2416500 2416500 defendant Lynes alias Braunche Nicholas laborer 601709 601709 Lynes alias Braunche, Nicholas, of Kelsale, laborer 3
5202525 2416500 2416500 defendant Bakler John carpenter 601709 601709 Bakler, John, of Kelsale, carpenter 4
5214066 2419843 2419843 defendant Lynes alias Braunche Nicholas laborer 601709 601709 Lynes alias Braunche, Nicholas, of Kelsale, laborer 2
5214067 2419843 2419843 defendant Bakeler John carpenter 601709 601709 Bakeler, John, of Kelsale, carpenter 3
5224561 2422852 2422852 defendant Bacheler William husbandman 601709 601709 Bacheler, William, of Kelsale, husbandman 0
5224565 2422853 2422853 defendant Bacheler William husbandman 601709 601709 Bacheler, William, of Kelsale, husbandman 0
5226008 2423274 2423274 defendant Lyndys John yeoman 601709 601709 Lyndys, John, of Kelsale, yeoman 2
5245808 2428939 2428939 defendant Braunche Nicholas husbandman 601709 601709 Braunche, Nicholas, of Kelsale, husbandman 0
5290949 2442355 2442355 defendant Wryght Robert husbandman 601709 601709 Wryght, Robert, of Kelsale, husbandman 0
5290950 2442355 2442355 defendant Everard Richard yeoman 601709 601709 Everard, Richard, of Kelsale, yeoman 1
5290951 2442355 2442355 defendant Wyllyng William husbandman 601709 601709 Wyllyng, William, of Kelsale, husbandman 2
5290952 2442355 2442355 defendant Catmere William husbandman 601709 601709 Catmere, William, of Kelsale, husbandman 3
5328762 2453681 2453681 defendant Bakeler John husbandman 601709 601709 Bakeler, John, of Kelsale, husbandman 0
5330359 2454156 2454156 defendant Gymbald William yeoman 601709 601709 Gymbald, William, of Kelsale, yeoman 1
5330364 2454157 2454157 defendant Gymbald William yeoman 601709 601709 Gymbald, William, of Kelsale, yeoman 1
5340704 2457294 2457294 defendant Wright Robert husbandman 601709 601709 Wright, Robert, of Kelsale, husbandman 0
5340705 2457294 2457294 defendant Everard Richard husbandman 601709 601709 Everard, Richard, of Kelsale, husbandman 1
5340706 2457294 2457294 defendant Everard John husbandman 601709 601709 Everard, John, of Kelsale, husbandman 2
5340707 2457294 2457294 defendant Catmere William husbandman 601709 601709 Catmere, William, of Kelsale, husbandman 3
5538937 2516669 2516669 defendant FitzHarry William gent 601709 601709 FitzHarry, William, of Kelsale, gent 0
5571104 2526110 2526110 defendant Hamond John butcher 601709 601709 Hamond, John, of Kelsale, butcher 0
5576165 2527607 2527607 defendant Bysshop John husbandman 601709 601709 Bysshop, John, of Kelsale, husbandman 1
5576381 2527666 2527666 defendant Thropptnell William tailor 601709 601709 Thropptnell, William, of Kelsale, tailor 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);