names

133 rows where place_id = 585887

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587419 1863710 1863710 defendant Daweson William dyer 585887 585887 Daweson, William, of Guldeford, dyer 1
3587423 1863711 1863711 defendant Daweson William dyer 585887 585887 Daweson, William, of Guldeford, dyer 1
3595756 1866305 1866305 defendant Yonge John gent 585887 585887 Yonge, John, of Guldeford, gent 0
3595983 1866374 1866374 plaintiff Norbrigge Henry draper 585887 585887 Norbrigge, Henry, of Guldeford, draper 0
3595991 1866375 1866375 defendant Kyngeston Thomas innholder 585887 585887 Kyngeston, Thomas, of Guldeford, innholder 0
3596976 1866681 1866681 defendant Yong John (legal representative) 585887 585887 Yong, John, of Guldeford, gent, administratrix of 0
3596977 1866681 1866681 defendant Yong Margaret widow 585887 585887 Yong, Margaret, of Guldeford, widow 1
3612521 1871547 1871547 defendant Asser Thomas clerk 585887 585887 Asser, Thomas, of Guldeford, clerk 0
3616846 1872899 1872899 defendant Fylpot Richard laborer 585887 585887 Fylpot, Richard, of Guldeford, laborer 1
3639021 1907026 1907026 defendant Becke John baker 585887 585887 Becke, John, of Guldeford, baker 0
3639022 1907026 1907026 defendant Hoggekyns Thomas brewer 585887 585887 Hoggekyns, Thomas, of Guldeford, brewer 1
3639023 1907026 1907026 defendant Alen John smith 585887 585887 Alen, John, of Guldeford, smith 2
3652982 1911263 1911263 defendant Mugge Daniel gent 585887 585887 Mugge, Daniel, of Guldeford, gent 0
3652983 1911263 1911263 defendant Exfold John butcher 585887 585887 Exfold, John, of Guldeford, butcher 1
3683233 1920875 1920875 defendant Rypley Henry husbandman 585887 585887 Rypley, Henry, of Guldeford, husbandman 0
3684108 1921165 1921165 defendant Atkynson Thomas yeoman 585887 585887 Atkynson, Thomas, of Guldeford, yeoman 0
3690323 1923136 1923136 defendant Couper William   585887 585887 Couper, William, of Guldeford, administrators of 0
3690327 1923137 1923137 defendant Couper William   585887 585887 Couper, William, of Guldeford, administrators of 0
3699699 1926131 1926131 defendant Toker John schoolmaster 585887 585887 Toker, John, of Guldeford, schoolmaster 0
3701148 1926608 1926608 plaintiff Bold Gregory yeoman 585887 585887 Bold, Gregory, of Guldeford, yeoman 0
3769022 1947961 1947961 defendant Norbryge Henry mercer 585887 585887 Norbryge, Henry, of Guldeford, mercer 0
3795563 1956495 1956495 plaintiff Daborn John dyer 585887 585887 Daborn, John, of Guldeford, dyer 0
3801509 1958384 1958384 defendant FitzWilliam William   585887 585887 FitzWilliam, William, of Guldeford, knight 1
3804434 1959325 1959325 defendant Hayward Thomas butcher 585887 585887 Hayward, Thomas, of Guldeford, butcher 0
3810487 1961175 1961175 defendant Johnson John clerk 585887 585887 Johnson, John, of Guldeford, clerk 0
3810488 1961175 1961175 defendant Nyxe Edward clerk 585887 585887 Nyxe, Edward, of Guldeford, clerk 1
3810489 1961175 1961175 defendant Smyth William yeoman 585887 585887 Smyth, William, of Guldeford, yeoman 2
3810546 1961196 1961196 defendant Parvysche Henry clothier 585887 585887 Parvysche, Henry, of Guldeford, clothier 0
3814532 1962458 1962458 defendant Pynson William fuller 585887 585887 Pynson, William, of Guldeford, fuller 0
3850156 1973638 1973638 defendant Rogers Oswald dyer 585887 585887 Rogers, Oswald, of Guldeford, dyer 1
3865995 1978861 1978861 plaintiff Parkhurst George clothier 585887 585887 Parkhurst, George, of Guldeford, clothier 0
3876754 1982468 1982468 plaintiff Hamond William, senior draper 585887 585887 Hamond, William, senior, of Guldeford, draper 0
3877739 1982795 1982795 defendant Fulven Henry innholder 585887 585887 Fulven, Henry, of Guldeford, innholder 0
3880709 1983812 1983812 defendant Derby Robert clerk 585887 585887 Derby, Robert, of Guldeford, clerk 0
3891117 1987295 1987295 defendant Byrcheall Richard sherman 585887 585887 Byrcheall, Richard, of Guldeford, sherman 0
3891118 1987295 1987295 defendant Aldey John glover 585887 585887 Aldey, John, of Guldeford, glover 1
3917679 1996270 1996270 plaintiff Hamond William, senior   585887 585887 Hamond, William, senior, of Guldeford 0
3918745 1996599 1996599 defendant Fulven Henry innholder 585887 585887 Fulven, Henry, of Guldeford, innholder 0
4110064 2063864 2063864 plaintiff Russell William yeoman 585887 585887 Russell, William, of Guldeford, yeoman 0
4110695 2064082 2064082 defendant Skocher William clothier 585887 585887 Skocher, William, of Guldeford, clothier 1
4124948 2069214 2069214 defendant Tuersley Thomas dyer 585887 585887 Tuersley, Thomas, of Guldeford, or of Goddalmyn, Surrey, dyer 0
4180497 2088660 2088660 plaintiff Marten Elizabeth spinster 585887 585887 Elizabeth his wife, formerly Elizabeth Tredcrofte, of Guldeford, spinster 1
4184367 2090032 2090032 defendant West Lawrence yeoman 585887 585887 West, Lawrence, of Guldeford, yeoman 2
4237502 2108707 2108707 defendant Marten Thomas glover 585887 585887 Marten, Thomas, of Guldeford, glover 0
4312061 2134358 2134358 defendant Bristowe or Briscowe John clothier 585887 585887 Bristowe or Briscowe, John, of Guldeford, clothier 0
4312063 2134359 2134359 defendant Snellynge Anthony clothier 585887 585887 Snellynge, Anthony, of Guldeford, clothier 0
4363490 2152016 2152016 defendant Scarlett John gent 585887 585887 Scarlett, John, of Guldeford, gent 0
4368660 2153840 2153840 defendant Jure Stephen laborer 585887 585887 Jure, Stephen, of Guldeford, laborer 0
4375509 2156294 2156294 defendant Perryer Richard clothier 585887 585887 Perryer, Richard, of Guldeford, clothier 1
4409840 2167894 2167894 defendant Weston John butcher 585887 585887 Weston, John, of Guldeford, butcher 0
4434788 2175639 2175639 plaintiff Lumbard John (legal representative) 585887 585887 Lumbard, John, of Guldeford, executors of 0
4434790 2175639 2175639 plaintiff Joan servant of John Lumbard   585887 585887 Joan, servant of John Lumbard, of Guldeford 2
4437101 2176345 2176345 defendant Patryk John   585887 585887 Patryk, John, of Guldeford 0
4450659 2185164 2185164 defendant Hallere William spicer 585887 585887 Hallere, William, of Guldeford, spicer 0
4458205 2187606 2187606 defendant Semer Peter (legal representative) 585887 585887 Semer, Peter, of Guldeford, executors of 0
4460040 2188198 2188198 plaintiff Semer Peter (legal representative) 585887 585887 Semer, Peter, of Guldeford, executors of 0
4460043 2188198 2188198 defendant Patryk Robert   585887 585887 Patryk, Robert, of Guldeford 0
4513359 2204593 2204593 plaintiff Broke Walter merchant 585887 585887 Broke, Walter, of Guldeford, merchant 0
4517278 2205804 2205804 plaintiff Crochon Thomas brother & prior 585887 585887 Crochon, Thomas, of Guldeford, brother & prior 0
4523269 2207602 2207602 defendant Kitte Thomas   585887 585887 Kitte, Thomas, of Guldeford 0
4531487 2210124 2210124 defendant Balchild William   585887 585887 Balchild, William, of Guldeford 0
4550045 2215951 2215951 defendant Rydyngherssh John   585887 585887 Rydyngherssh, John, of Guldeford 0
4605967 2232982 2232982 plaintiff atte Mulle Robert   585887 585887 atte Mulle, Robert, of Guldeford 0
4618716 2236861 2236861 defendant Hull Robert   585887 585887 Hull, Robert, of Guldeford 5
4858270 2313959 2313959 defendant Knyght Henry dyer 585887 585887 Knyght, Henry, of Guldeford, dyer 1
4866079 2316362 2316362 plaintiff Grigge John spicer 585887 585887 Grigge, John, of Guldeford, spicer 0
4866386 2316455 2316455 defendant Preston Bartholomew husbandman 585887 585887 Preston, Bartholomew, of Guldeford, husbandman 0
4866387 2316455 2316455 defendant Parys William weaver 585887 585887 Parys, William, of Guldeford, weaver 1
4867249 2316719 2316719 defendant Bambelot John pewterer 585887 585887 Bambelot, John, of Guldeford, pewterer 0
4867252 2316719 2316719 defendant Dytlesdon Thomas fisher 585887 585887 Dytlesdon, Thomas, of Guldeford, fisher 3
4884192 2321964 2321964 defendant Balchilde Thomas yeoman 585887 585887 Balchilde, Thomas, of Guldeford, yeoman 0
4889820 2323607 2323607 defendant Tornoure Thomas husbandman 585887 585887 Tornoure, Thomas, of Guldeford, husbandman 0
4950265 2342049 2342049 defendant Lokyer Richard   585887 585887 Lokyer, Richard, of Guldeford, groom 0
4960030 2344965 2344965 plaintiff Balchylde William   585887 585887 Balchylde, William, of Guldeford 1
4968535 2347557 2347557 defendant Kyngeston John grocer 585887 585887 Kyngeston, John, of Guldeford, grocer 0
4973146 2348901 2348901 defendant Kyngeston John chapman 585887 585887 Kyngeston, John, of Guldeford, chapman 1
4980251 2351037 2351037 defendant Northampton William miller 585887 585887 Northampton, William, of Guldeford, miller 0
4984166 2352195 2352195 defendant Hayward Henry dyer 585887 585887 Hayward, Henry, of Guldeford, dyer 2
5013387 2360751 2360751 defendant Thrysk William gent 585887 585887 Thrysk, William, of Guldeford, gent 0
5057556 2373829 2373829 defendant Fraunceys Geoffrey yeoman 585887 585887 Fraunceys, Geoffrey, of Guldeford, yeoman 3
5068383 2377043 2377043 defendant Herman Stephen glasier 585887 585887 Herman, Stephen, of Guldeford, glasier 0
5074272 2378797 2378797 plaintiff Wheler Richard   585887 585887 Wheler, Richard, of Guldeford 0
5074277 2378799 2378799 plaintiff Whelere Richard   585887 585887 Whelere, Richard, of Guldeford 0
5083684 2381621 2381621 plaintiff FitzJohn John   585887 585887 FitzJohn, John, of Guldeford 0
5090722 2383673 2383673 defendant Mundy John yeoman 585887 585887 Mundy, John, of Guldeford, yeoman 0
5101502 2386851 2386851 defendant Toker alias Montegewe John clerk 585887 585887 Toker alias Montegewe, John, of Guldeford, clerk 2
5108715 2388986 2388986 defendant Toker alias Montegewe John clerk 585887 585887 Toker alias Montegewe, John, of Guldeford, clerk 3
5119530 2392143 2392143 defendant Blakeney Robert cordwainer 585887 585887 Blakeney, Robert, of Guldeford, cordwainer 4
5120671 2392477 2392477 defendant Edyndon John barber 585887 585887 Edyndon, John, of Guldeford, barber 0
5120673 2392478 2392478 defendant Edyngden John barber 585887 585887 Edyngden, John, of Guldeford, barber 0
5212376 2419363 2419363 defendant Blakeney Robert cordwainer 585887 585887 Blakeney, Robert, of Guldeford, cordwainer 0
5212377 2419363 2419363 defendant Blakeney Nicholas cordwainer 585887 585887 Blakeney, Nicholas, of Guldeford, cordwainer 1
5217650 2420894 2420894 defendant Basset Thomas esq 585887 585887 Basset, Thomas, of Guldeford, esq 0
5226092 2423298 2423298 defendant Wolkyng John yeoman 585887 585887 Wolkyng, John, of Guldeford, yeoman 0
5255398 2431805 2431805 defendant Davy John   585887 585887 Davy, John, of Guldeford, mason 1
5256052 2432017 2432017 defendant Twychener William, junior chapman 585887 585887 Twychener, William, junior, of Guldeford, chapman 2
5284699 2440537 2440537 defendant Blakeney Nicholas yeoman 585887 585887 Blakeney, Nicholas, of Guldeford, yeoman 0
5284700 2440537 2440537 defendant Blakeney Robert cordwainer 585887 585887 Blakeney, Robert, of Guldeford, cordwainer 1
5286433 2441033 2441033 defendant Grover James chandler 585887 585887 Grover, James, of Guldeford, chandler 0
5286435 2441034 2441034 defendant Grover James chandler 585887 585887 Grover, James, of Guldeford, chandler 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);