names

155 rows where place_id = 585901

✎ 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
3587455 1863724 1863724 defendant Reyner William baker 585901 585901 Reyner, William, of Burwell, baker 0
3602731 1868519 1868519 defendant Rayner Thomas barker 585901 585901 Rayner, Thomas, of Burwell, barker 0
3602732 1868519 1868519 defendant Rayner William barker 585901 585901 Rayner, William, of Burwell, barker 1
3636645 1906253 1906253 defendant Waleys John husbandman 585901 585901 Waleys, John, of Burwell, husbandman 2
3636646 1906253 1906253 defendant Frere Thomas husbandman 585901 585901 Frere, Thomas, of Burwell, husbandman 3
3636647 1906253 1906253 defendant Frere Edmund husbandman 585901 585901 Frere, Edmund, of Burwell, husbandman 4
3636651 1906254 1906254 defendant Waleys John husbandman 585901 585901 Waleys, John, of Burwell, husbandman 2
3636652 1906254 1906254 defendant Frere Thomas husbandman 585901 585901 Frere, Thomas, of Burwell, husbandman 3
3636653 1906254 1906254 defendant Frere Edmund husbandman 585901 585901 Frere, Edmund, of Burwell, husbandman 4
3658315 1912855 1912855 defendant Caseband Thomas husbandman 585901 585901 Caseband, Thomas, of Burwell, husbandman 0
3664365 1914804 1914804 defendant Baron Richard husbandman 585901 585901 Baron, Richard, of Burwell, husbandman 0
3666873 1915581 1915581 defendant Buntyng Ralph husbandman 585901 585901 Buntyng, Ralph, of Burwell, husbandman 0
3666874 1915581 1915581 defendant Anmer Henry husbandman 585901 585901 Anmer, Henry, of Burwell, husbandman 1
3670214 1916631 1916631 defendant Tetsall John husbandman 585901 585901 Tetsall, John, of Burwell, husbandman 0
3670215 1916631 1916631 defendant Culy John clerk 585901 585901 Culy, John, of Burwell, clerk 1
3703017 1927218 1927218 defendant Baker Richard shoemaker 585901 585901 Baker, Richard, of Burwell, shoemaker 0
3745813 1940593 1940593 defendant Chipper Thomas husbandman 585901 585901 Chipper, Thomas, of Burwell, husbandman 4
3765307 1946813 1946813 defendant Wolworth William husbandman 585901 585901 Wolworth, William, of Burwell, husbandman 1
3770464 1948442 1948442 defendant Chipper Thomas husbandman 585901 585901 Chipper, Thomas, of Burwell, husbandman 3
3770605 1948489 1948489 defendant Theler John husbandman 585901 585901 Theler, John, of Burwell, husbandman 1
3774589 1949779 1949779 defendant Welworth William gent 585901 585901 Welworth, William, of Burwell, gent 0
3778521 1951000 1951000 defendant Forster John bricklayer 585901 585901 Forster, John, of Burwell, bricklayer 0
3778524 1951000 1951000 defendant Tebbyngton John husbandman 585901 585901 Tebbyngton, John, of Burwell, husbandman 3
3789265 1954460 1954460 defendant Cheyppar Thomas yeoman 585901 585901 Cheyppar, Thomas, of Burwell, yeoman 0
3789266 1954460 1954460 defendant Barker John yeoman 585901 585901 Barker, John, of Burwell, yeoman 1
3789267 1954460 1954460 defendant Elys Robert husbandman 585901 585901 Elys, Robert, of Burwell, husbandman 2
3789268 1954460 1954460 defendant Thompson Robert laborer 585901 585901 Thompson, Robert, of Burwell, laborer 3
3792268 1955434 1955434 defendant Welworth William gent 585901 585901 Welworth, William, of Burwell, gent 1
3808748 1960613 1960613 defendant Busshe alias Tapster William laborer 585901 585901 Busshe alias Tapster, William, of Burwell, laborer 2
3841498 1970921 1970921 defendant Talwarth John   585901 585901 Talwarth, John, of Burwell, shepherd 0
3841499 1970921 1970921 defendant Talworth Thomas   585901 585901 Talworth, Thomas, of Burwell, shepherd 1
3841500 1970921 1970921 defendant Coo Thomas   585901 585901 Coo, Thomas, of Burwell, shepherd 2
3867031 1979214 1979214 defendant Palmer Thomas husbandman 585901 585901 Palmer, Thomas, of Burwell, husbandman 0
3867032 1979214 1979214 defendant Palmer William laborer 585901 585901 Palmer, William, of Burwell, laborer 1
3867033 1979214 1979214 defendant Collyng John laborer 585901 585901 Collyng, John, of Burwell, laborer 2
3867034 1979214 1979214 defendant Preston Thomas laborer 585901 585901 Preston, Thomas, of Burwell, laborer 3
3867161 1979255 1979255 defendant Talworth Thomas   585901 585901 Talworth, Thomas, of Burwell, shepherd 0
3874057 1981544 1981544 defendant Wylkyn alias Barker John laborer 585901 585901 Wylkyn alias Barker, John, of Burwell, laborer 0
3881513 1984080 1984080 defendant Gooche John tailor 585901 585901 Gooche, John, of Burwell, tailor 0
3892178 1987637 1987637 defendant Burton Edward carpenter 585901 585901 Burton, Edward, of Burwell, carpenter 4
3896783 1989136 1989136 defendant Swygott Richard husbandman 585901 585901 Swygott, Richard, of Burwell, husbandman 0
3896784 1989136 1989136 defendant Chippar Thomas husbandman 585901 585901 Chippar, Thomas, of Burwell, husbandman 1
3913202 1994747 1994747 defendant Wylkyng John husbandman 585901 585901 Wylkyng, John, of Burwell, husbandman 0
3917531 1996220 1996220 defendant Bekett John butcher 585901 585901 Bekett, John, of Burwell, butcher 1
3941736 2004251 2004251 defendant Swygotte Richard miller 585901 585901 Swygotte, Richard, of Burwell, miller 0
3945340 2005454 2005454 defendant Lukyn William yeoman 585901 585901 Lukyn, William, of Burwell, yeoman 0
3994173 2022667 2022667 defendant Wetherell John cordwainer 585901 585901 Wetherell, John, of Burwell, cordwainer 2
3997131 2023742 2023742 defendant Gardner John gent 585901 585901 Gardner, John, of Burwell, gent 0
3997133 2023743 2023743 defendant Gardner John gent 585901 585901 Gardner, John, of Burwell, gent 0
3997149 2023749 2023749 defendant Gardner John gent 585901 585901 Gardner, John, of Burwell, gent 0
3997150 2023749 2023749 defendant Steppyn Joan widow 585901 585901 Steppyn, Joan, of Burwell, widow 1
3997153 2023750 2023750 defendant Gardner John gent 585901 585901 Gardner, John, of Burwell, gent 0
3997154 2023750 2023750 defendant Steppyn Joan widow 585901 585901 Steppyn, Joan, of Burwell, widow 1
4019895 2031848 2031848 plaintiff Westhorpe George husbandman 585901 585901 Westhorpe, George, of Burwell, husbandman 0
4021015 2032242 2032242 plaintiff Wright Anne widow 585901 585901 Wright, Anne, of Burwell, widow 0
4025821 2033888 2033888 defendant Munforde John shoemaker 585901 585901 Munforde, John, of Burwell, shoemaker 1
4025822 2033888 2033888 defendant Dalymer Bartholomew husbandman 585901 585901 Dalymer, Bartholomew, of Burwell, husbandman 2
4025827 2033889 2033889 defendant Munforde John shoemaker 585901 585901 Munforde, John, of Burwell, shoemaker 1
4025828 2033889 2033889 defendant Dalymer Bartholomew husbandman 585901 585901 Dalymer, Bartholomew, of Burwell, husbandman 2
4026339 2034066 2034066 defendant Roger John yeoman 585901 585901 Roger, John, of Burwell, yeoman 0
4026340 2034066 2034066 defendant Roger Edmund yeoman 585901 585901 Roger, Edmund, of Burwell, yeoman 1
4036182 2037623 2037623 defendant Cobbe Richard waterman 585901 585901 Cobbe, Richard, of Burwell, waterman 3
4036195 2037626 2037626 defendant Cobbe Richard waterman 585901 585901 Cobbe, Richard, of Burwell, waterman 3
4069648 2049428 2049428 defendant Elmer George clerk 585901 585901 Elmer, George, of Burwell, clerk 0
4123270 2068625 2068625 defendant Colson Nicholas shoemaker 585901 585901 Colson, Nicholas, of Burwell, or of Burlington, Yorks, shoemaker 0
4139545 2074506 2074506 defendant Markante John husbandman 585901 585901 Markante, John, of Burwell, husbandman 0
4167144 2084014 2084014 defendant Stevenson Mathew shoemaker 585901 585901 Stevenson, Mathew, of Burwell, shoemaker 0
4204909 2097257 2097257 defendant Lytster Richard husbandman 585901 585901 Lytster, Richard, of Burwell, husbandman 1
4204910 2097257 2097257 defendant Stewarde John husbandman 585901 585901 Stewarde, John, of Burwell, husbandman 2
4240350 2109749 2109749 defendant Panton William husbandman 585901 585901 Panton, William, of Burwell, husbandman 0
4255948 2114964 2114964 defendant Merkaunt John yeoman 585901 585901 Merkaunt, John, of Burwell, yeoman 1
4268122 2118955 2118955 defendant Markam or Markant John husbandman 585901 585901 Markam or Markant, John, of Burwell, husbandman 0
4299864 2130042 2130042 defendant Burne Christopher tailor 585901 585901 Burne, Christopher, of Burwell, tailor 0
4300841 2130399 2130399 defendant Melton William yeoman 585901 585901 Melton, William, of Burwell, yeoman 0
4300843 2130399 2130399 defendant Martyndale   widow 585901 585901 Martyndale, , of Burwell, widow 2
4337656 2142919 2142919 defendant Ware John yeoman 585901 585901 Ware, John, of Burwell, yeoman 1
4358395 2150169 2150169 defendant Aldriche George gent 585901 585901 Aldriche, George, of Burwell, gent 0
4362555 2151660 2151660 defendant Spearman John waterman 585901 585901 Spearman, John, of Burwell, waterman 0
4372045 2155066 2155066 defendant Foster Robert husbandman 585901 585901 Foster, Robert, of Burwell, husbandman 1
4376944 2156826 2156826 defendant Smyth Audrey widow 585901 585901 (Smyth, Audrey, of Burwell, widow 1
4376945 2156826 2156826 defendant Smyth Nicholas gent 585901 585901 Smyth, Nicholas, of Burwell, gent 2
4447440 2184113 2184113 defendant Umfraison John   585901 585901 Umfraison, John, of Burwell 0
4447488 2184127 2184127 defendant Unfrayson John   585901 585901 Unfrayson, John, of Burwell 0
4462176 2188866 2188866 defendant Peryng John   585901 585901 Peryng, John, of Burwell 2
4477690 2193689 2193689 defendant del Chaumbre Thomas   585901 585901 del Chaumbre, Thomas, of Burwell 0
4484220 2195764 2195764 defendant Cobell Edmund   585901 585901 Cobell, Edmund, of Burwell 0
4486018 2196330 2196330 defendant Roule John   585901 585901 Roule, John, of Burwell 0
4601418 2231680 2231680 defendant Mason Richard   585901 585901 Mason, Richard, of Burwell 1
4612005 2234817 2234817 defendant Sparowe Alexander   585901 585901 Sparowe, Alexander, of Burwell 1
4634285 2241565 2241565 defendant Lann John de butcher 585901 585901 Lann, John de, of Burwell, butcher 1
4652103 2246599 2246599 plaintiff atte Hill John   585901 585901 atte Hill, John, of Burwell 0
4665374 2250652 2250652 defendant Botyller John yeoman 585901 585901 Botyller, John, of Burwell, yeoman 7
4667971 2255688 2255688 defendant Maltby Richard husbandman 585901 585901 Maltby, Richard, of Burwell, husbandman 0
4676843 2258376 2258376 defendant Bocher George butcher 585901 585901 Bocher, George, of Burwell, butcher 0
4682355 2260103 2260103 defendant Bocher George husbandman 585901 585901 Bocher, George, of Burwell, husbandman 3
4685770 2261139 2261139 plaintiff Saunderson Adam   585901 585901 Saunderson, Adam, of Burwell 0
4686106 2261246 2261246 defendant Maltby Richard husbandman 585901 585901 Maltby, Richard, of Burwell, husbandman 4
4718800 2271223 2271223 defendant Fyssh John   585901 585901 Fyssh, John, of Burwell, shepherd 0
4721617 2272091 2272091 defendant Maltby Richard husbandman 585901 585901 Maltby, Richard, of Burwell, husbandman 0
4732531 2275348 2275348 defendant Beneyt John husbandman 585901 585901 Beneyt, John, of burwell, husbandman 2

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