names

382 rows where place_id = 600449

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3641084 1907654 1907654 defendant Wyllyamson Ellen widow 600449 600449 Wyllyamson, Ellen, of Boston, Lincs, widow 1
3641092 1907657 1907657 defendant Wyllyamson Ellen widow 600449 600449 Wyllyamson, Ellen, of Boston, Lincs, widow 1
3645509 1908995 1908995 defendant Godyng Richard yeoman 600449 600449 Godyng, Richard, of Boston, Lincs, yeoman 5
3654735 1911738 1911738 defendant Warde Hugh   600449 600449 Warde, Hugh, of Boston, Lincs, staple merchant 1
3654754 1911744 1911744 defendant Warde Hugh   600449 600449 Warde, Hugh, of Boston, Lincs, staple merchant 1
3660667 1913599 1913599 defendant Pulvertoft Robert gent 600449 600449 Pulvertoft, Robert, of Boston, Lincs, gent 0
3660722 1913619 1913619 defendant Robynson John draper 600449 600449 Robynson, John, of Boston, Lincs, draper 1
3661988 1914041 1914041 defendant Baret John merchant 600449 600449 Baret, John, of Boston, Lincs, merchant 1
3662797 1914282 1914282 defendant Russham John merchant 600449 600449 Russham, John, of Boston, Lincs, merchant 2
3662798 1914282 1914282 defendant Palmer Thomas gent 600449 600449 Palmer, Thomas, of Boston, Lincs, gent 3
3686778 1922020 1922020 defendant Palmer Thomas gent 600449 600449 Palmer, Thomas, of Boston, Lincs, gent 0
3689862 1922987 1922987 defendant Rodley John   600449 600449 Rodley, John, of Boston, Lincs, singing man 2
3703592 1927399 1927399 defendant Crawe Thomas chaplain 600449 600449 Crawe, Thomas, of Boston, Lincs, chaplain 0
3715383 1931096 1931096 defendant Conseyt John clerk 600449 600449 Conseyt, John, of Boston, Lincs, clerk 0
3752908 1942835 1942835 defendant Sybsey George gent 600449 600449 Sybsey, George, of Boston, Lincs, gent 0
3755304 1943613 1943613 defendant Hubberd William chapman 600449 600449 Hubberd, William, of Boston, Lincs, chapman 2
3762534 1945925 1945925 defendant Wodell Robert yeoman 600449 600449 Wodell, Robert, of Boston, Lincs, yeoman 2
3790216 1954758 1954758 defendant Inkasell John clerk 600449 600449 Inkasell, John, of Boston, Lincs, clerk 3
3815930 1962887 1962887 defendant Sharpe Edward mercer 600449 600449 Sharpe, Edward, of Boston, Lincs, mercer 1
3831027 1967587 1967587 defendant Spynkys William merchant of the staple 600449 600449 Spynkys, William, of Boston, Lincs, merchant of the staple 2
3831324 1967684 1967684 defendant Walthewe Thomas fishmonger 600449 600449 Walthewe, Thomas, of Boston, Lincs, fishmonger 0
3831742 1967829 1967829 defendant Sutton Thomas gent 600449 600449 Sutton, Thomas, of Boston, Lincs, gent 0
3845713 1972205 1972205 defendant Leeke Thomas mercer 600449 600449 Leeke, Thomas, of Boston, Lincs, mercer 1
3861949 1977456 1977456 defendant Spynkys William merchant of the staple 600449 600449 Spynkys, William, of Boston, Lincs, merchant of the staple 0
3870979 1980546 1980546 defendant Bellman Lawrence fishmonger 600449 600449 Bellman, Lawrence, of Boston, Lincs, fishmonger 0
3871436 1980693 1980693 defendant Bothe Edward clerk 600449 600449 Bothe, Edward, of Boston, Lincs, clerk 0
3874243 1981605 1981605 defendant Tomlyngson William mercer 600449 600449 Tomlyngson, William, of Boston, Lincs, mercer 3
3875636 1982094 1982094 defendant Hardcastell John mercer 600449 600449 Hardcastell, John, of Boston, Lincs, mercer 0
3875638 1982095 1982095 defendant Hardcastell John mercer 600449 600449 Hardcastell, John, of Boston, Lincs, mercer 0
3886294 1985670 1985670 defendant Walthewe Thomas fishmonger 600449 600449 Walthewe, Thomas, of Boston, Lincs, fishmonger 0
3892603 1987771 1987771 defendant Walton Thomas yeoman 600449 600449 Walton, Thomas, of Boston, Lincs, yeoman 0
3892703 1987809 1987809 defendant Paynell William esq 600449 600449 Paynell, William, of Boston, Lincs, esq 0
3894127 1988252 1988252 defendant Whitacres Gilbert husbandman 600449 600449 Whitacres, Gilbert, of Boston, Lincs, husbandman 2
3899200 1989939 1989939 defendant Audley Brian yeoman 600449 600449 Audley, Brian, of Boston, Lincs, yeoman 0
3899341 1989992 1989992 defendant Hargrave John esq 600449 600449 Hargrave, John, of Boston, Lincs, esq 0
3902180 1990964 1990964 defendant Almondson William clerk 600449 600449 Almondson, William, of Boston, Lincs, clerk 0
3905567 1992130 1992130 defendant Waltham Thomas baker 600449 600449 Waltham, Thomas, of Boston, Lincs, baker 0
3926152 1999067 1999067 defendant Robynson Anthony gent 600449 600449 Robynson, Anthony, of Boston, Lincs, gent 0
3927848 1999652 1999652 defendant Skynner Alexander gent 600449 600449 Skynner, Alexander, of Boston, Lincs, gent 4
3928256 1999785 1999785 defendant Borough William merchant 600449 600449 Borough, William, of Boston, Lincs, merchant 1
3929057 2000057 2000057 defendant Browne Thomas chapman 600449 600449 Browne, Thomas, of Boston, Lincs, chapman 2
3933514 2001493 2001493 defendant Skynner Alexander gent 600449 600449 Skynner, Alexander, of Boston, Lincs, gent 1
3935453 2002170 2002170 defendant Wrenche James merchant 600449 600449 Wrenche, James, of Boston, Lincs, merchant 2
3935455 2002170 2002170 defendant Phyllyppes Hugh   600449 600449 Phyllyppes, Hugh, of Boston, Lincs, inn holder 4
3935467 2002171 2002171 defendant Strayles Christopher gent 600449 600449 Strayles, Christopher, of Boston, Lincs, gent 1
3935473 2002172 2002172 defendant Skynner Alexander gent 600449 600449 Skynner, Alexander, of Boston, Lincs, gent 0
3935657 2002239 2002239 plaintiff Langrake Edmund (legal representative) 600449 600449 Langrake, Edmund, of Boston, Lincs, husbandman, executor of 0
3936229 2002443 2002443 defendant Love Christopher yeoman 600449 600449 Love, Christopher, of Boston, Lincs, yeoman 2
3936558 2002551 2002551 defendant Stevynson John baker 600449 600449 Stevynson, John, of Boston, Lincs, baker 0
3938865 2003339 2003339 defendant Middelton Hugh draper 600449 600449 Middelton, Hugh, of Boston, Lincs, draper 2
3940341 2003789 2003789 defendant Dove John gent & merchant 600449 600449 Dove, John, of Boston, Lincs, gent & merchant 0
3967705 2013340 2013340 defendant Earsby Leonard esq 600449 600449 Earsby, Leonard, of Boston, Lincs, esq 0
3967847 2013386 2013386 plaintiff Calverley Edward   600449 600449 Calverley, Edward, of Boston, Lincs, administrators of 0
3970764 2014366 2014366 defendant Hartgrave Francis gent 600449 600449 Hartgrave, Francis, of Boston, Lincs,, gent 0
4045255 2040759 2040759 defendant Jeter Richard gent 600449 600449 Jeter, Richard, of Boston, Lincs, gent 0
4062051 2046713 2046713 defendant Stoughton George gent 600449 600449 Stoughton, George, of Boston, Lincs, gent 0
4183758 2089808 2089808 defendant Jackson John   600449 600449 Jackson, John, of Boston, Lincs, brewer, or of Wombwell, yorks butcher 0
4219836 2102441 2102441 defendant Kingston John gent 600449 600449 Kingston, John, of Boston, Lincs, gent 3
4333816 2141591 2141591 defendant Noble William butcher 600449 600449 Noble, William, of Boston, Lincs, or of St Katherines by the Tower of London, butcher 0
4351464 2147762 2147762 defendant Smyth Thomas gent 600449 600449 Smyth, Thomas, of Boston, Lincs, or of Haverhill, Suff, gent 0
4391668 2161831 2161831 defendant Folkingham Robert yeoman 600449 600449 Folkingham, Robert, of Boston, Lincs, yeoman 0
4476586 2193337 2193337 plaintiff Game Annice daughter of William 600449 600449 Game, Annice, of Boston, Lincs, daughter of William 0
4531034 2209995 2209995 defendant Lister John   600449 600449 Lister, John, of Boston, Lincs 0
4531089 2210003 2210003 defendant Lytster John   600449 600449 Lytster, John, of Boston, Lincs 0
4561989 2219679 2219679 defendant Thorynton John   600449 600449 Thorynton, John, of Boston, Lincs 1
4567263 2221318 2221318 defendant Wryght William   600449 600449 Wryght, William, of Boston, Lincs 2
4590695 2228445 2228445 defendant Cleymond Alan   600449 600449 Cleymond, Alan, of Boston, Lincs 0
4595135 2229731 2229731 defendant Botheby William   600449 600449 Botheby, William, of Boston, Lincs 0
4629353 2240112 2240112 defendant Grene Nicholas   600449 600449 Grene, Nicholas, of Boston, Lincs 1
4630941 2240568 2240568 defendant Belle John chapman 600449 600449 Belle, John, of Boston, Lincs, chapman 0
4658873 2248646 2248646 defendant Bernaby Michael draper 600449 600449 Bernaby, Michael, of Boston, Lincs, draper 2
4669966 2256304 2256304 defendant Cok John gent 600449 600449 Cok, John, of Boston, Lincs, gent 0
4675948 2258087 2258087 defendant Rope John, junior shipman 600449 600449 Rope, John, junior, of Boston, Lincs, shipman 0
4676712 2258336 2258336 defendant Bocher John chapman 600449 600449 Bocher, John, of Boston, Lincs, chapman 1
4677506 2258579 2258579 defendant Fyssher Henry fisher 600449 600449 Fyssher, Henry, of Boston, Lincs, fisher 0
4678177 2258782 2258782 defendant del Kyrk Hugh mariner 600449 600449 del Kyrk, Hugh, of Boston, Lincs, mariner 1
4678180 2258783 2258783 defendant Bette John mariner 600449 600449 Bette, John, of Boston, Lincs, mariner 1
4683918 2260580 2260580 defendant Malteby Richard merchant 600449 600449 Malteby, Richard, of Boston, Lincs, merchant 0
4684336 2260706 2260706 defendant Belle John gent 600449 600449 Belle, John, of Boston, Lincs, gent 2
4684342 2260707 2260707 defendant Belle John gent 600449 600449 Belle, John, of Boston, Lincs, gent 2
4688418 2261945 2261945 defendant Bowyere John merchant & woolman 600449 600449 Bowyere, John, of Boston, Lincs, merchant & woolman 0
4688807 2262054 2262054 defendant Bowyere John merchant & woolman 600449 600449 Bowyere, John, of Boston, Lincs, merchant & woolman 0
4691727 2262944 2262944 defendant Aileward Richard merchant 600449 600449 Aileward, Richard, of Boston, Lincs, merchant 0
4693662 2263517 2263517 defendant Day Robert mariner 600449 600449 Day, Robert, of Boston, Lincs, mariner 2
4696624 2264421 2264421 defendant Toynton John taverner 600449 600449 Toynton, John, of Boston, Lincs, taverner 0
4696735 2264456 2264456 defendant Gernon Peter merchant 600449 600449 Gernon, Peter, of Boston, Lincs, merchant 0
4704747 2266863 2266863 defendant Stevenson John yeoman 600449 600449 Stevenson, John, of Boston, Lincs, yeoman 3
4710688 2268700 2268700 defendant Thorneton John mercer 600449 600449 Thorneton, John, of Boston, Lincs, mercer 0
4710704 2268703 2268703 defendant Serle Richard mercer 600449 600449 Serle, Richard, of Boston, Lincs, mercer 0
4714179 2269763 2269763 defendant Wylughby Thomas   600449 600449 Wylughby, Thomas, of Boston, Lincs, knight, administrators of 0
4714181 2269763 2269763 defendant Glaston John draper 600449 600449 Glaston, John, of Boston, Lincs, draper 2
4721386 2272022 2272022 defendant Dawelyn John   600449 600449 Dawelyn, John, of Boston, Lincs, spicer, formerly of Depyng, Lincs 0
4721567 2272077 2272077 defendant Capmaker William   600449 600449 Capmaker, William, of Boston, Lincs, cap maker 0
4727184 2273764 2273764 defendant Honnyngton John merchant 600449 600449 Honnyngton, John, of Boston, Lincs, merchant 2
4733474 2275644 2275644 defendant Holand John gent 600449 600449 Holand, John, of Boston, Lincs, gent 0
4739738 2277503 2277503 defendant Aileward Richard merchant 600449 600449 Aileward, Richard, of Boston, Lincs, merchant 0
4740191 2277644 2277644 defendant Peek John husbandman 600449 600449 Peek, John, of Boston, Lincs, husbandman 2
4740498 2277734 2277734 defendant Cook John husbandman 600449 600449 Cook, John, of Boston, Lincs, husbandman 2
4746295 2279413 2279413 defendant Broune John husbandman 600449 600449 Broune, John, of Boston, Lincs, husbandman 0
4748358 2280027 2280027 defendant Waterman William capmaker 600449 600449 Waterman, William, of Boston, Lincs, capmaker 0

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