names

110 rows where place_id = 588047

✎ 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
3593179 1865497 1865497 defendant Symond William yeoman 588047 588047 Symond, William, of Sutterton, yeoman 1
3598789 1867250 1867250 defendant Alger Robert husbandman 588047 588047 Alger, Robert, of Sutterton, husbandman 0
3608235 1870231 1870231 defendant Alger Robert husbandman 588047 588047 Alger, Robert, of Sutterton, husbandman 0
3611112 1871150 1871150 defendant Crabdam Thomas laborer 588047 588047 Crabdam, Thomas, of Sutterton, laborer 0
3613748 1871951 1871951 defendant Percy Richard yeoman 588047 588047 Percy, Richard, of Sutterton, yeoman 0
3643915 1908528 1908528 defendant Benet Roger husbandman 588047 588047 Benet, Roger, of Sutterton, husbandman 1
3666938 1915605 1915605 defendant Hugden John   588047 588047 Hugden, John, of Sutterton, vicar & clerk 0
3673926 1917881 1917881 defendant Brandon Edmund husbandman 588047 588047 Brandon, Edmund, of Sutterton, husbandman 0
3673927 1917881 1917881 defendant Robertson Richard husbandman 588047 588047 Robertson, Richard, of Sutterton, husbandman 1
3684777 1921376 1921376 defendant Watte John husbandman 588047 588047 Watte, John, of Sutterton, husbandman 1
3684778 1921376 1921376 defendant Hylton Robert husbandman 588047 588047 Hylton, Robert, of Sutterton, gent, Tomson, John, of Wigtoft, husbandman 2
3687560 1922284 1922284 defendant Friskeney William gent 588047 588047 Friskeney, William, of Sutterton, gent 0
3692215 1923732 1923732 defendant Bennet William (legal representative) 588047 588047 Bennet, William, of Sutterton, husbandman, executors of 0
3711074 1929774 1929774 defendant Bele Robert husbandman 588047 588047 Bele, Robert, of Sutterton, husbandman 0
3718059 1931942 1931942 defendant Felde William yeoman 588047 588047 Felde, William, of Sutterton, yeoman 0
3719358 1932340 1932340 defendant Arnoll Alice widow 588047 588047 Arnoll, Alice, of Sutterton, widow 0
3723983 1933784 1933784 defendant Clerk William husbandman 588047 588047 Clerk, William, of Sutterton, husbandman 0
3724711 1934014 1934014 defendant Doughty Thomas husbandman 588047 588047 Doughty, Thomas, of Sutterton, husbandman 0
3725715 1934330 1934330 defendant Beale Robert husbandman 588047 588047 Beale, Robert, of Sutterton, husbandman 0
3736077 1937525 1937525 defendant Nunne Richard husbandman 588047 588047 Nunne, Richard, of Sutterton, husbandman 0
3736078 1937525 1937525 defendant Davy Walter husbandman 588047 588047 Davy, Walter, of Sutterton, husbandman 1
3744831 1940282 1940282 defendant Bog William   588047 588047 Bog, William, of Sutterton 0
3759202 1944865 1944865 defendant Alyn John roper 588047 588047 Alyn, John, of Sutterton, roper 0
3798040 1957285 1957285 defendant Alger Richard husbandman 588047 588047 Alger, Richard, of Sutterton, husbandman 0
3809604 1960890 1960890 defendant Bele John husbandman 588047 588047 Bele, John,of Sutterton, husbandman 2
3822923 1965075 1965075 defendant Benycle Richard husbandman 588047 588047 Benycle, Richard, of Sutterton, husbandman 0
3827179 1966363 1966363 defendant Bele John husbandman 588047 588047 Bele, John, of Sutterton, husbandman 0
3827181 1966364 1966364 defendant Bele John husbandman 588047 588047 Bele, John, of Sutterton, husbandman 0
3832087 1967940 1967940 defendant Bele John husbandman 588047 588047 Bele, John, of Sutterton, husbandman 0
3839608 1970311 1970311 defendant Eland William husbandman 588047 588047 Eland, William, of Sutterton, husbandman 0
3850948 1973888 1973888 defendant Bele John husbandman 588047 588047 Bele, John, of Sutterton, husbandman 2
3857141 1975862 1975862 defendant Wyborn Henry weaver 588047 588047 Wyborn, Henry, of Sutterton, weaver 1
3936384 2002491 2002491 defendant Hoxston Robert yeoman 588047 588047 Hoxston, Robert, of sutterton, yeoman 0
3936388 2002492 2002492 defendant Hoxton Robert yeoman 588047 588047 Hoxton, Robert, of Sutterton, yeoman 0
3940295 2003775 2003775 defendant Bennett Richard husbandman 588047 588047 Bennett, Richard, of Sutterton, husbandman 1
3942304 2004438 2004438 defendant Brandon William husbandman 588047 588047 Brandon, William, of Sutterton, husbandman 0
3970824 2014380 2014380 defendant Felde Edward yeoman 588047 588047 Felde, Edward, of Sutterton, yeoman 6
3986016 2019767 2019767 plaintiff Waysse Richard yeoman 588047 588047 Waysse, Richard, of Sutterton, yeoman 0
4002765 2025756 2025756 defendant Irby Kenelm yeoman 588047 588047 Irby, Kenelm, of Sutterton, or of Tatissall, gent, Selby, John, of Boston, yeoman 0
4003667 2026078 2026078 defendant Robartson alias Robinson Brian gent 588047 588047 Robartson alias Robinson, Brian, of Sutterton, gent 0
4021781 2032519 2032519 defendant Wood David clerk 588047 588047 Wood, David, of Sutterton, or of Boston, clerk 0
4021783 2032520 2032520 defendant Wood David clerk 588047 588047 Wood, David, of Sutterton, or of Boston, clerk 0
4030723 2035651 2035651 plaintiff Elsome Edward yeoman 588047 588047 Elsome, Edward, of Sutterton, yeoman 0
4042992 2039969 2039969 plaintiff Percy Thomas   588047 588047 Percy, Thomas, of Sutterton 0
4042993 2039969 2039969 defendant Irby Kenelm gent 588047 588047 Irby, Kenelm, of Sutterton, gent 0
4047938 2041708 2041708 defendant Josson Christopher husbandman 588047 588047 Josson, Christopher, of Sutterton, husbandman 2
4052711 2043401 2043401 plaintiff Bogg Giles yeoman 588047 588047 Bogg, Giles, of Sutterton, yeoman 0
4055843 2044473 2044473 plaintiff Bogg Giles yeoman 588047 588047 Bogg, Giles, of Sutterton, yeoman 0
4081319 2053629 2053629 defendant Feld Edward yeoman 588047 588047 Feld, Edward, of Sutterton, yeoman 0
4097199 2059319 2059319 defendant Flower Joshua clerk 588047 588047 Flower, Joshua, of Sutterton, clerk 0
4103802 2061633 2061633 defendant Benakell George husbandman 588047 588047 Benakell, George, of Sutterton, husbandman 0
4150116 2078178 2078178 defendant Broker Rowland yeoman 588047 588047 Broker, Rowland, of Sutterton, or of St John Street, Middx, yeoman 0
4235465 2107972 2107972 defendant Lodd Richard husbandman 588047 588047 Lodd, Richard, of Sutterton, husbandman 0
4253422 2114136 2114136 defendant Pell Stephen yeoman 588047 588047 Pell, Stephen, of Sutterton, yeoman 0
4253423 2114136 2114136 defendant Heynsworth Simon yeoman 588047 588047 Heynsworth, Simon, of Sutterton, yeoman 1
4299423 2129884 2129884 defendant Dent Humphrey yeoman 588047 588047 Dent, Humphrey, of Sutterton, yeoman 1
4317245 2136145 2136145 defendant Bogge Humphrey gent 588047 588047 Bogge, Humphrey, of Sutterton, gent 0
4345445 2145678 2145678 defendant Jackson William yeoman 588047 588047 Jackson, William, of Sutterton, yeoman 0
4362474 2151628 2151628 defendant Jackson Robert yeoman 588047 588047 Jackson, Robert, of Sutterton, yeoman 0
4369269 2154072 2154072 defendant Jackson William yeoman 588047 588047 Jackson, William, of Sutterton, yeoman 0
4379703 2157837 2157837 defendant Sutterton Roger laborer 588047 588047 Sutterton, Roger, of Sutterton, laborer 0
4502229 2201295 2201295 plaintiff Meres Athelard   588047 588047 Meres, Athelard, of Sutterton 0
4506112 2202426 2202426 plaintiff Symond John   588047 588047 Symond, John, of Sutterton 0
4537514 2212004 2212004 defendant Loke John   588047 588047 Loke, John, of sutterton 1
4542520 2213547 2213547 defendant Massyngberd Hugh   588047 588047 Massyngberd, Hugh, of Sutterton 0
4633823 2241432 2241432 defendant Bosy John   588047 588047 Bosy, John, of Sutterton 0
4676028 2258113 2258113 defendant Dykson Thomas husbandman 588047 588047 Dykson, Thomas, of Sutterton, husbandman 1
4787914 2292286 2292286 defendant del Felde Athelard gent 588047 588047 del Felde, Athelard, of Sutterton, gent 1
4982666 2351728 2351728 defendant Symond John husbandman 588047 588047 Symond, John, of Sutterton, husbandman 1
4982667 2351728 2351728 defendant Everard William gent 588047 588047 Everard, William, of Sutterton, gent 2
4983860 2352097 2352097 defendant Halcok John husbandman 588047 588047 Halcok, John, of Sutterton, husbandman 2
5020578 2362907 2362907 defendant Felde Athelard gent 588047 588047 Felde, Athelard, of Sutterton, gent 1
5020579 2362907 2362907 defendant Dixon Thomas husbandman 588047 588047 Dixon, Thomas, of Sutterton, husbandman 2
5052859 2372445 2372445 defendant Everard William gent 588047 588047 Everard, William, of Sutterton, gent 0
5062069 2375214 2375214 defendant Fryskeney John tailor 588047 588047 Fryskeney, John, of Sutterton, tailor 0
5070321 2377617 2377617 defendant Saundyrson William husbandman 588047 588047 Saundyrson, William, of Sutterton, husbandman 0
5070322 2377617 2377617 defendant Saundyrson Thomas yeoman 588047 588047 Saundyrson, Thomas, of Sutterton, yeoman 1
5072901 2378380 2378380 defendant Everard William gent 588047 588047 Everard, William, of Sutterton, gent 0
5116918 2391374 2391374 defendant Holand Robert gent 588047 588047 Holand, Robert, of Sutterton, gent 0
5116919 2391374 2391374 defendant Symond John, senior husbandman 588047 588047 Symond, John, senior, of Sutterton, husbandman 1
5212078 2419272 2419272 defendant Blyssebury John yeoman 588047 588047 Blyssebury, John, of Sutterton, yeoman 0
5216120 2420446 2420446 defendant Percy Athelard husbandman 588047 588047 Percy, Athelard, of Sutterton, husbandman 0
5236090 2426139 2426139 defendant Deconson John tailor 588047 588047 Deconson, John, of Sutterton, tailor 0
5236092 2426140 2426140 defendant Deconson John tailor 588047 588047 Deconson, John, of Sutterton, tailor 0
5259258 2433014 2433014 defendant Hakford William yeoman 588047 588047 together with Hakford, William, of Sutterton, yeoman 1
5259264 2433015 2433015 defendant Hakforde William yeoman 588047 588047 Hakforde, William, of Sutterton, yeoman 0
5288994 2441788 2441788 defendant Wase John yeoman 588047 588047 Wase, John, of Sutterton, yeoman 0
5295543 2443686 2443686 defendant Barugh William yeoman 588047 588047 Barugh, William, of Sutterton, yeoman 0
5307926 2447387 2447387 defendant Pasmer John   588047 588047 Pasmer, John, of Sutterton 0
5404933 2476488 2476488 defendant Percy John husbandman 588047 588047 Percy, John, of Sutterton, husbandman 0
5444238 2488182 2488182 defendant Wace John husbandman 588047 588047 (Wace, John, of Sutterton, husbandman 3
5470947 2496242 2496242 defendant Wace Richard husbandman 588047 588047 Wace, Richard, of Sutterton, husbandman 1
5486529 2500862 2500862 defendant Wattes Thomas husbandman 588047 588047 Wattes, Thomas, of Sutterton, husbandman 0
5523580 2512203 2512203 defendant Howeson John, senior husbandman 588047 588047 Howeson, John, senior, of Sutterton, husbandman 0
5523581 2512203 2512203 defendant Bray John husbandman 588047 588047 Bray, John, of Sutterton, husbandman 1
5523582 2512203 2512203 defendant Quetyngham Richard husbandman 588047 588047 Quetyngham, Richard, of Sutterton, husbandman 2
5523583 2512203 2512203 defendant Rous John husbandman 588047 588047 Rous, John, of Sutterton, husbandman 3
5523584 2512203 2512203 defendant Benet Robert husbandman 588047 588047 Benet, Robert, of Sutterton, husbandman 4
5523586 2512204 2512204 defendant Rous John husbandman 588047 588047 Rous, John, of Sutterton, husbandman 0
5523587 2512204 2512204 defendant Benet Robert husbandman 588047 588047 Benet, Robert, of Sutterton, husbandman 1

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