names

104 rows where place_id = 598611

✎ 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
3633301 1905231 1905231 defendant Best William husbandman 598611 598611 Best, William, of Stansted, husbandman 1
3633756 1905370 1905370 defendant Chamlet John yeoman 598611 598611 Chamlet, John, of Stansted, yeoman 1
3637280 1906462 1906462 defendant Romney Thomas husbandman 598611 598611 Romney, Thomas, of Stansted, husbandman 0
3643991 1908552 1908552 defendant Chapman John, senior husbandman 598611 598611 Chapman, John, senior, of Stansted Abbot, husbandman 4
3649929 1910343 1910343 defendant Gurnard Roger fuller 598611 598611 Gurnard, Roger, of Stansted, fuller 2
3660208 1913454 1913454 defendant Jugeler John gent 598611 598611 Jugeler, John, of Stansted, gent 2
3664567 1914872 1914872 defendant Ingler John gent 598611 598611 Ingler, John, of Stansted, gent 0
3673853 1917854 1917854 defendant Payne Lawrence yeoman 598611 598611 Payne, Lawrence, of Stansted, yeoman 1
3674571 1918097 1918097 defendant Branton John weaver 598611 598611 Branton, John, of Stansted, weaver 5
3675271 1918305 1918305 defendant Spachehurste Richard husbandman 598611 598611 Spachehurste, Richard, of Stansted, husbandman 1
3696105 1925005 1925005 defendant Waren Andrew husbandman 598611 598611 Waren, Andrew, of Stansted, husbandman 3
3699414 1926040 1926040 defendant Betyll Thomas husbandman 598611 598611 Betyll, Thomas, of Stansted, husbandman 0
3704409 1927676 1927676 defendant Williams Henry husbandman 598611 598611 Williams, Henry, of Stansted, husbandman 5
3708103 1928833 1928833 defendant Chapman John, junior yeoman 598611 598611 Chapman, John, junior, of Stansted, yeoman 1
3708109 1928834 1928834 defendant Chapman John, junior yeoman 598611 598611 Chapman, John, junior, of Stansted, yeoman 2
3708205 1928860 1928860 defendant Waren Andrew yeoman 598611 598611 Waren, Andrew, of Stansted, yeoman 1
3710590 1929635 1929635 defendant Gurnard Roger miller 598611 598611 Gurnard, Roger, of Stansted, miller 1
3724510 1933951 1933951 defendant Mower Thomas thatcher 598611 598611 Mower, Thomas, of Stansted, thatcher 2
3724511 1933951 1933951 defendant Seymer John laborer 598611 598611 Seymer, John, of Stansted, laborer 3
3741155 1939094 1939094 defendant Gurnard Roger miller 598611 598611 Gurnard, Roger, of Stansted, miller 3
3751952 1942527 1942527 plaintiff Paynter Alice   598611 598611 Paynter, Alice, of Stansted, widow, administrators of 0
3756964 1944156 1944156 defendant Jermyn John husbandman 598611 598611 Jermyn, John, of Stansted, husbandman 0
3780704 1951698 1951698 defendant Waren Andrew laborer 598611 598611 Waren, Andrew, of Stansted, laborer 1
3804526 1959356 1959356 defendant Roberd John husbandman 598611 598611 Roberd, John, of Stansted, husbandman 0
3821178 1964516 1964516 defendant Lane Robert yeoman 598611 598611 Lane, Robert, of Stansted, yeoman 0
3832772 1968178 1968178 plaintiff Jermyn John yeoman 598611 598611 Jermyn, John, of Stansted, yeoman 0
3836449 1969307 1969307 defendant Branton John yeoman 598611 598611 Branton, John, of Stansted, yeoman 2
3836450 1969307 1969307 defendant Watson Edward yeoman 598611 598611 Watson, Edward, of Stansted, yeoman 3
3837354 1969593 1969593 defendant Jermyn John yeoman 598611 598611 Jermyn, John, of Stansted, yeoman 0
3843891 1971629 1971629 defendant Mardelyng John laborer 598611 598611 Mardelyng, John, of Stansted, laborer 0
3848539 1973125 1973125 plaintiff Jermyn John yeoman 598611 598611 Jermyn, John, of Stansted, yeoman 0
3848541 1973126 1973126 plaintiff Jermyn John yeoman 598611 598611 Jermyn, John, of Stansted, yeoman 0
3851846 1974169 1974169 defendant Calve William laborer 598611 598611 Calve, William, of Stansted, laborer 0
3858691 1976390 1976390 defendant Coke William tilemaker 598611 598611 Coke, William, of Stansted Mountfytcher, tilemaker 0
3861900 1977439 1977439 defendant Wulderygge John husbandman 598611 598611 Wulderygge, John, of Stansted, husbandman 0
3863842 1978082 1978082 plaintiff Jermyn John yeoman 598611 598611 Jermyn, John, of Stansted, yeoman 0
3900491 1990395 1990395 defendant Scudder John husbandman 598611 598611 Scudder, John, of Stansted, husbandman 1
3928787 1999963 1999963 defendant Howe Roger pedler 598611 598611 Howe, Roger, of Stansted, pedler 2
3935303 2002120 2002120 defendant Wode John clothier 598611 598611 Wode, John, of Stansted, clothier 0
3950653 2007301 2007301 defendant More Anne widow 598611 598611 More, Anne, of Stansted, widow 2
3954966 2008800 2008800 plaintiff Lybbe Richard gent 598611 598611 Lybbe, Richard, of Stansted, gent 0
3980918 2017936 2017936 plaintiff Powell Thomas   598611 598611 Powell, Thomas, of Stansted, administrators of 0
3982999 2018695 2018695 defendant Graungesden William yeoman 598611 598611 Graungesden, William, of Stansted, yeoman 2
3997854 2023991 2023991 defendant Hasselyn Anthony yeoman 598611 598611 Hasselyn, Anthony, of Stansted, yeoman 0
4030267 2035478 2035478 defendant Chauncye John gent 598611 598611 Chauncye, John, of Stansted Abbot, gent 0
4193849 2093413 2093413 defendant Wooden William yeoman 598611 598611 Wooden, William, of Stansted, yeoman 0
4218676 2102031 2102031 defendant Grave Thomas yeoman 598611 598611 Grave, Thomas, of Stansted, yeoman 0
4233025 2107058 2107058 defendant Raye George yeoman 598611 598611 Raye, George, of Stansted, yeoman 0
4275288 2121291 2121291 defendant Gave Thomas vintner 598611 598611 Gave, Thomas, of Stansted, vintner 2
4280688 2123149 2123149 defendant Rumbolde Richard husbandman 598611 598611 Rumbolde, Richard, of Stansted, or of Ugley, husbandman 0
4281596 2123469 2123469 defendant Smythe John   598611 598611 Smythe, John, of Stansted, brick maker 2
4401262 2165016 2165016 defendant Wakelyn Richard husbandman 598611 598611 Wakelyn, Richard, of Stansted, husbandman 0
4402468 2165411 2165411 defendant Broghton Thomas yeoman 598611 598611 Broghton, Thomas, of Stansted, yeoman 1
4566142 2220972 2220972 defendant Barell John, sen   598611 598611 Barell, John, sen, of Stansted 0
4567403 2221366 2221366 defendant Germyn Walter   598611 598611 Germyn, Walter, of Stansted 0
4574045 2223405 2223405 defendant Coraunt John   598611 598611 Coraunt, John, of Stansted 0
4614410 2235515 2235515 defendant Porter William   598611 598611 Porter, William, of Stansted 1
4649571 2245904 2245904 defendant Jermyn Walter   598611 598611 Jermyn, Walter, of Stansted 0
4722337 2272309 2272309 defendant Merke John laborer 598611 598611 Merke, John, of Stansted, laborer 3
4777227 2288864 2288864 defendant Osbarn Henry parker 598611 598611 Osbarn, Henry, of Stansted, parker 0
4802778 2297055 2297055 defendant Belcham John fuller 598611 598611 Belcham, John, of Stansted, fuller 0
4894990 2325098 2325098 defendant atte Moor John husbandman 598611 598611 atte Moor, John, of Stansted, husbandman 0
4916454 2331648 2331648 defendant Whatlok Henry fuller 598611 598611 Whatlok, Henry, of Stansted, fuller 0
4954193 2343227 2343227 defendant Bouchier Robert husbandman 598611 598611 Bouchier, Robert, of Stansted, husbandman 1
4965428 2346576 2346576 defendant Qwatlok Henry yeoman 598611 598611 Qwatlok, Henry, of Stansted, yeoman 0
4982653 2351725 2351725 defendant Knyght Richard laborer 598611 598611 Knyght, Richard, of Stansted, laborer 0
4982654 2351725 2351725 defendant Trotte John barber 598611 598611 Trotte, John, of Stansted, barber 1
4982655 2351725 2351725 defendant Bocher John husbandman 598611 598611 Bocher, John, of Stansted, husbandman 2
5015227 2361339 2361339 defendant Broke Robert husbandman 598611 598611 Broke, Robert, of Stansted, husbandman 1
5128391 2394779 2394779 defendant Whatlok Henry fuller 598611 598611 Whatlok, Henry, of Stansted, fuller 1
5129506 2395118 2395118 defendant Warde John tailor 598611 598611 Warde, John, of Stansted, tailor 0
5132664 2396051 2396051 defendant Moos Richard husbandman 598611 598611 Moos, Richard, of Stansted, husbandman 2
5142591 2398961 2398961 defendant Warde John tailor 598611 598611 Warde, John, of Stansted, tailor 0
5147037 2400272 2400272 defendant Warde John tailor 598611 598611 Warde, John, of Stansted, tailor 0
5147039 2400272 2400272 defendant More John, sen husbandman 598611 598611 More, John, sen, of Stansted, husbandman 2
5152508 2401869 2401869 defendant Moor Richard husbandman 598611 598611 Moor, Richard, of Stansted, husbandman 2
5163940 2405191 2405191 defendant Warde John tailor 598611 598611 Warde, John, of Stansted, tailor 0
5195229 2414350 2414350 defendant Cotear Roger husbandman 598611 598611 Cotear, Roger, of Stansted, husbandman 4
5209168 2418409 2418409 defendant Coteare Robert husbandman 598611 598611 Coteare, Robert, of Stansted, husbandman 4
5218371 2421105 2421105 defendant Cotyer Roger husbandman 598611 598611 Cotyer, Roger, of Stansted, husbandman 3
5227405 2423643 2423643 defendant Whatlok Henry fuller 598611 598611 Whatlok, Henry, of Stansted, fuller 1
5233917 2425508 2425508 defendant Lemer John husbandman 598611 598611 Lemer, John, of Stansted, husbandman 2
5242785 2428094 2428094 defendant Letton Henry weaver 598611 598611 Letton, Henry, of Stansted, weaver 1
5266224 2435190 2435190 defendant Writell Walter esq 598611 598611 Writell, Walter, of Stansted, esq 0
5315189 2449597 2449597 defendant Worlych or Wolrych John   598611 598611 Worlych or Wolrych, John, of Stansted, mason 3
5322031 2451659 2451659 defendant Turnour John turner 598611 598611 Turnour, John, of Stansted, turner 0
5330257 2454125 2454125 defendant Turnour John husbandman 598611 598611 Turnour, John, of Stansted Abbot, husbandman 2
5357152 2462300 2462300 defendant Arnold Robert laborer 598611 598611 Arnold, Robert, of Stansted, laborer 4
5384005 2470512 2470512 defendant Barell Henry husbandman 598611 598611 Barell, Henry, of Stansted, husbandman 2
5521498 2511539 2511539 defendant Baroll Henry husbandman 598611 598611 Baroll, Henry, of Stansted, husbandman 1
5521499 2511539 2511539 defendant Reede Andrew husbandman 598611 598611 Reede, Andrew, of Stansted, husbandman 2
5531068 2514233 2514233 defendant Cok alias Sporeer John husbandman 598611 598611 Cok alias Sporeer, John, of Stansted, husbandman 0
5548793 2519691 2519691 defendant Cooke John husbandman 598611 598611 Cooke, John, of Stansted, husbandman 3
5551594 2520504 2520504 defendant Peche John yeoman 598611 598611 Peche, John, of Stansted, yeoman 3
5551595 2520504 2520504 defendant Dey William yeoman 598611 598611 Dey, William, of Stansted, yeoman 4
5551608 2520509 2520509 defendant Peche John yeoman 598611 598611 Peche, John, of Stansted, yeoman 0
5551609 2520509 2520509 defendant Dey William yeoman 598611 598611 Dey, William, of Stansted, yeoman 1
5554801 2521404 2521404 defendant Peche John yeoman 598611 598611 Peche, John, of Stansted, yeoman 0
5554802 2521404 2521404 defendant Dey William yeoman 598611 598611 Dey, William, of Stansted, yeoman 1
5562540 2523643 2523643 plaintiff Whithyngton Hugh   598611 598611 Whithyngton, Hugh, of STansted 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);