names

76 rows where place_id = 606158

✎ 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
3664241 1914765 1914765 plaintiff Reynoldes John   606158 606158 Reynoldes, John, of Boxford, Suff 0
3712840 1930336 1930336 defendant Gosnall John clothier 606158 606158 Gosnall, John, of Boxford, Suff, clothier 2
3780351 1951587 1951587 defendant Gryg Robert clothman 606158 606158 Gryg, Robert, of Boxford, Suff, clothman 0
3780353 1951588 1951588 defendant Kyng John clothman 606158 606158 Kyng, John, of Boxford, Suff, clothman 0
3785865 1953369 1953369 defendant Kyng John clothmaker 606158 606158 Kyng, John, of Boxford, Suff, clothmaker 0
3798691 1957502 1957502 defendant Tode Edmund clothier 606158 606158 Tode, Edmund, of Boxford, Suff, clothier 1
3815228 1962679 1962679 defendant Tode Edmund clothmaker 606158 606158 Tode, Edmund, of Boxford, Suff, clothmaker 0
3815230 1962680 1962680 defendant Todde Edmund clothmaker 606158 606158 Todde, Edmund, of Boxford, Suff, clothmaker 0
3816730 1963139 1963139 defendant Tode Edmund clothier 606158 606158 Tode, Edmund, of Boxford, Suff, clothier 0
3818095 1963572 1963572 defendant Newton John clothman 606158 606158 Newton, John, of Boxford, Suff, clothman 1
3841116 1970798 1970798 defendant Tod Edmund clothmaker 606158 606158 Tod, Edmund, of Boxford, Suff, clothmaker 1
3856879 1975781 1975781 defendant Mendam Robert smith 606158 606158 Mendam, Robert, of Boxford, Suff, smith 2
3872520 1981033 1981033 defendant Cowper Walter clothmaker 606158 606158 Cowper, Walter, of Boxford, Suff, clothmaker 3
3872523 1981034 1981034 defendant Kyng John clothmaker 606158 606158 Kyng, John, of Boxford, Suff, clothmaker 0
3893033 1987916 1987916 defendant Bronde William clothier 606158 606158 Bronde, William, of Boxford, Suff, clothier 0
3895305 1988637 1988637 defendant Todd Edward clothier 606158 606158 Todd, Edward, of Boxford, Suff, clothier 0
3895883 1988830 1988830 defendant Brande Richard clothier 606158 606158 Brande, Richard, of Boxford, Suff, clothier 1
3910176 1993717 1993717 defendant Brand Richard clothier 606158 606158 Brand, Richard, of Boxford, Suff, clothier 1
3916146 1995786 1995786 defendant Cooke Thomas clothier 606158 606158 Cooke, Thomas, of Boxford, Suff, clothier 0
3927566 1999561 1999561 defendant Loffkyn Robert   606158 606158 Loffkyn, Robert, of Boxford, Suff, cloth maker 2
3929723 2000278 2000278 defendant Whytyng William, senior clothier 606158 606158 Whytyng, William, senior, of Boxford, Suff, clothier 0
3947451 2006181 2006181 defendant Clyff Christopher clothier 606158 606158 Clyff, Christopher, of Boxford, Suff, clothier 1
3948276 2006456 2006456 defendant Lufkyn Thomas clothier 606158 606158 Lufkyn, Thomas, of Boxford, Suff, clothier 0
3953514 2008301 2008301 defendant Luskyn Thomas clothier 606158 606158 Luskyn, Thomas, of Boxford, Suff, clothier 0
3953517 2008302 2008302 defendant Brand William clothier 606158 606158 Brand, William, of Boxford, Suff, clothier 0
3964686 2012255 2012255 defendant Luffkyn Thomas clothier 606158 606158 Luffkyn, Thomas, of Boxford, Suff, clothier 0
3973982 2015470 2015470 defendant Clarke John   606158 606158 Clarke, John, of Boxford, Suff, wood setter 1
3988896 2020772 2020772 defendant Wortham Thomas clothier 606158 606158 Wortham, Thomas, of Boxford, Suff, clothier 0
3990959 2021529 2021529 defendant Gayle Robert clothier 606158 606158 Gayle, Robert, of Boxford, Suff, clothier 0
3991519 2021725 2021725 defendant Brand William clothier 606158 606158 Brand, William, of Boxford, Suff, clothier 0
3992745 2022156 2022156 defendant Baker Robert chapman 606158 606158 Baker, Robert, of Boxford, Suff, chapman 0
4019388 2031668 2031668 defendant Browton Robert clothier 606158 606158 Browton, Robert, of Boxford, Suff, clothier 0
4020743 2032146 2032146 defendant Northam Thomas clothier 606158 606158 Northam, Thomas, of Boxford, Suff, clothier 0
4030640 2035620 2035620 defendant Clarke John   606158 606158 Clarke, John, of Boxford, Suff, wad setter 1
4030645 2035622 2035622 defendant Clarke John   606158 606158 Clarke, John, of Boxford, Suff, "wadsetter" 1
4030648 2035623 2035623 defendant Forde William   606158 606158 Forde, William, of Boxford, Suff, "wadsetter" 1
4032201 2036189 2036189 plaintiff Gale John, senior clothier 606158 606158 Gale, John, senior, of Boxford, Suff, clothier 0
4059529 2045801 2045801 defendant Wyllyamson Augustine clothier 606158 606158 Wyllyamson, Augustine, of Boxford, Suff, clothier 1
4123962 2068869 2068869 defendant Broughtene Robert clothier 606158 606158 Broughtene, Robert, of Boxford, Suff, clothier 0
4126053 2069604 2069604 defendant Luffkyn Robert clothier 606158 606158 Luffkyn, Robert, of Boxford, Suff, clothier 0
4127408 2070092 2070092 defendant Baker Robert chapman 606158 606158 Baker, Robert, of Boxford, Suff, chapman 0
4147158 2077145 2077145 defendant Wortham Anne widow 606158 606158 Wortham, Anne, of Boxford, Suff, widow 0
4234703 2107684 2107684 defendant Coo Thomas clothier 606158 606158 Coo, Thomas, of Boxford, Suff, clothier 1
4239217 2109341 2109341 defendant Brand William clothier 606158 606158 Brand, William, of Boxford, Suff, clothier 2
4239957 2109612 2109612 defendant Hartwell John yeoman 606158 606158 Hartwell, John, of Boxford, Suff, yeoman 0
4243261 2110738 2110738 defendant Coo Thomas clothier 606158 606158 Coo, Thomas, of Boxford, Suff, clothier 0
4255666 2114868 2114868 defendant Clere Benjamin clothier 606158 606158 Clere, Benjamin, of Boxford, Suff, clothier 1
4255668 2114869 2114869 defendant Laughlinge or Lawlinge John clothier 606158 606158 Laughlinge or Lawlinge, John, of Boxford, Suff, clothier 0
4268048 2118931 2118931 defendant Brand William clothier 606158 606158 Brand, William, of Boxford, Suff, clothier 1
4268053 2118932 2118932 defendant Laughlinge John clothier 606158 606158 Laughlinge, John, of Boxford, Suff, clothier 1
4328407 2139816 2139816 defendant Brande John clothier 606158 606158 Brande, John, of Boxford, Suff, clothier 0
4356944 2149661 2149661 defendant Bonde Thomas chapman 606158 606158 Bonde, Thomas, of Boxford, Suff, chapman 1
4386530 2160169 2160169 defendant Hargrave Lawrence gent 606158 606158 Hargrave, Lawrence, of Boxford, Suff, attorney, gent 0
4401812 2165204 2165204 defendant Sharman William clothier 606158 606158 Sharman, William, of Boxford, Suff, clothier 0
4490196 2197644 2197644 defendant Tylle John dyer 606158 606158 Tylle, John, of Boxford, Suff, dyer 1
4651160 2246367 2246367 defendant Coo John fisherman 606158 606158 Coo, John, of Boxford, Suff, fisherman 1
4744437 2278894 2278894 defendant Martell Thomas esq 606158 606158 Martell, Thomas, of Boxford, Suff, esq 0
4798411 2295689 2295689 defendant Lyster Walter husbandman 606158 606158 Lyster, Walter, of Boxford, Suff, husbandman 2
4851280 2311847 2311847 defendant Sparowe Philip draper 606158 606158 Sparowe, Philip, of Boxford, Suff, draper 2
4851284 2311848 2311848 defendant Sparowe Philip draper 606158 606158 Sparowe, Philip, of Boxford, Suff, draper 2
4918654 2332350 2332350 defendant Wyssh Thomas husbandman 606158 606158 Wyssh, Thomas, of Boxford, Suff, husbandman 1
4918657 2332351 2332351 defendant Wyssh Thomas husbandman 606158 606158 Wyssh, Thomas, of Boxford, Suff, husbandman 0
4977003 2350075 2350075 defendant Bollok Thomas husbandman 606158 606158 Bollok, Thomas, of Boxford, Suff, husbandman 2
4977371 2350192 2350192 defendant Bollok Thomas husbandman 606158 606158 Bollok, Thomas, of Boxford, Suff, husbandman 2
5031035 2365953 2365953 defendant Sparowe Philip chapman 606158 606158 Sparowe, Philip, of Boxford, Suff, chapman 3
5031049 2365956 2365956 defendant Sparowe Philip chapman 606158 606158 Sparowe, Philip, of Boxford, Suff, chapman 3
5035781 2367320 2367320 defendant Hall Thomas chapman 606158 606158 Hall, Thomas, of Boxford, Suff, chapman 0
5035818 2367334 2367334 defendant Hall Thomas chapman 606158 606158 Hall, Thomas, of Boxford, Suff, chapman 0
5059681 2374459 2374459 defendant Coo John chapman 606158 606158 Coo, John, of Boxford, Suff, chapman 1
5059687 2374460 2374460 defendant Coo John chapman 606158 606158 Coo, John, of Boxford, Suff, chapman 1
5062728 2375408 2375408 defendant Reve John, senior yeoman 606158 606158 Reve, John, senior, of Boxford, Suff, yeoman 0
5067308 2376730 2376730 defendant Musteler John clothman 606158 606158 Musteler, John, of Boxford, Suff, clothman 1
5077682 2379820 2379820 defendant Baggele John butcher 606158 606158 Baggele, John, of Boxford, Suff, butcher 6
5094803 2384892 2384892 defendant Reve John mercer 606158 606158 Reve, John, of Boxford, Suff, mercer 0
5115921 2391085 2391085 defendant Coo John, senior   606158 606158 Coo, John, senior, of Boxford, Suff 2
5242218 2427925 2427925 defendant Bekyngham Richard chapman 606158 606158 Bekyngham, Richard, of Boxford, Suff, chapman 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);