names

122 rows where place_id = 586445

✎ 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
3588741 1864122 1864122 defendant Hoiggis William husbandman 586445 586445 Hoiggis, William, of Ulcombe, husbandman 1
3634416 1905563 1905563 defendant Amerey John carpenter 586445 586445 Amerey, John, of Ulcombe, carpenter 0
3635646 1905950 1905950 defendant Rycard John laborer 586445 586445 Rycard, John, of Ulcombe, laborer 0
3639213 1907077 1907077 defendant Selenger Ralph   586445 586445 Selenger, Ralph, of Ulcombe, Kent esq 4
3694989 1924645 1924645 defendant Boycott Lawrence husbandman 586445 586445 Boycott, Lawrence, of Ulcombe, husbandman 1
3694992 1924645 1924645 defendant Barlyng William husbandman 586445 586445 Barlyng, William, of Ulcombe, husbandman 4
3694996 1924646 1924646 defendant Rycharde John butcher 586445 586445 Rycharde, John, of Ulcombe, butcher 2
3702296 1926975 1926975 defendant Barnard John husbandman 586445 586445 Barnard, John, of Ulcombe, husbandman 0
3749088 1941644 1941644 defendant Ade William husbandman 586445 586445 Ade, William, of Ulcombe, husbandman 0
3802571 1958699 1958699 defendant Rycard John butcher 586445 586445 Rycard, John, of Ulcombe, butcher 4
3802837 1958782 1958782 defendant Foo John husbandman 586445 586445 Foo, John, of Ulcombe, husbandman 0
3816316 1963011 1963011 plaintiff Homersham Thomas   586445 586445 Homersham, Thomas, of Ulcombe 0
3831704 1967817 1967817 defendant Haffynden Henry husbandman 586445 586445 Haffynden, Henry, of Ulcombe, husbandman 0
3845934 1972285 1972285 defendant Wytt John butcher 586445 586445 Wytt, John, of Ulcombe, butcher 3
3892268 1987667 1987667 defendant Broken alias Brokyng William gent 586445 586445 Broken alias Brokyng, William, of Ulcombe, gent 0
3899595 1990084 1990084 defendant Rychard Thomas butcher 586445 586445 Rychard, Thomas, of Ulcombe, butcher 0
3906482 1992460 1992460 defendant Rycard Thomas husbandman 586445 586445 Rycard, Thomas, of Ulcombe, husbandman 1
3937973 2003034 2003034 defendant Post George husbandman 586445 586445 Post, George, of Ulcombe, husbandman 1
3955584 2009023 2009023 defendant Sentleger Nicholas esq 586445 586445 Sentleger, Nicholas, of Ulcombe, esq 0
3989302 2020915 2020915 defendant Jones Thomas clerk 586445 586445 Jones, Thomas, of Ulcombe, clerk 0
3994646 2022837 2022837 defendant Wood George butcher 586445 586445 Wood, George, of Ulcombe, butcher 0
4023023 2032954 2032954 defendant Reader Dunstan husbandman 586445 586445 Reader, Dunstan, of Ulcombe, husbandman 0
4023475 2033104 2033104 defendant Crane William husbandman 586445 586445 Crane, William, of Ulcombe, husbandman 0
4042598 2039822 2039822 defendant Johns Thomas clerk 586445 586445 Johns, Thomas, of Ulcombe, clerk 0
4050505 2042607 2042607 defendant Pynde Richard yeoman 586445 586445 Pynde, Richard, of Ulcombe, yeoman 1
4094185 2058254 2058254 defendant Cooke alias Johnson John yeoman 586445 586445 Cooke alias Johnson, John, of Ulcombe, yeoman 0
4097971 2059603 2059603 defendant Andvyll or Audvyll Sampson yeoman 586445 586445 Andvyll or Audvyll, Sampson, of Ulcombe, yeoman 1
4105166 2062120 2062120 defendant Jones Thomas clerk 586445 586445 Jones, Thomas, of Ulcombe, clerk 0
4105250 2062156 2062156 defendant Nebbe Thomas turner 586445 586445 Nebbe, Thomas, of Ulcombe, turner 0
4105532 2062259 2062259 defendant Handvyll Sampson yeoman 586445 586445 Handvyll, Sampson, of Ulcombe, yeoman 0
4105534 2062260 2062260 defendant Handvyll Sampson yeoman 586445 586445 Handvyll, Sampson, of Ulcombe, yeoman 0
4129488 2070850 2070850 defendant Jones Thomas clerk 586445 586445 Jones, Thomas, of Ulcombe, clerk 0
4166583 2083808 2083808 defendant Johnes Thomas clerk 586445 586445 Johnes, Thomas, of Ulcombe, clerk 0
4168259 2084384 2084384 defendant Barton Salamon   586445 586445 Barton, Salamon, of Ulcombe, pale maker 0
4203604 2096817 2096817 defendant Burden Richard husbandman 586445 586445 Burden, Richard, of Ulcombe, yeoman, or of Marden, husbandman 0
4211071 2099427 2099427 defendant Kyngsnod Jerome yeoman 586445 586445 Kyngsnod, Jerome, of Ulcombe, yeoman 1
4211073 2099427 2099427 defendant Kyngsnod George yeoman 586445 586445 Kyngsnod, George, of Ulcombe, yeoman 3
4231259 2106433 2106433 defendant Bensted Christopher mealman 586445 586445 Bensted, Christopher, of Ulcombe, yeoman, mealman 0
4231260 2106433 2106433 defendant Tylman John clothworker 586445 586445 Tylman, John, of Ulcombe, yeoman, clothworker 1
4238452 2109063 2109063 defendant Gorham Richard clothier 586445 586445 Gorham, Richard, of Ulcombe, clothier 1
4239480 2109433 2109433 defendant Hoysted or Heistede Thomas yeoman 586445 586445 Hoysted or Heistede, Thomas, of Ulcombe, yeoman 0
4240401 2109767 2109767 defendant Tylman John clothworker 586445 586445 Tylman, John, of Ulcombe, yeoman, clothworker 0
4255113 2114703 2114703 defendant Cole John   586445 586445 Cole, John, of Ulcombe, broad weaver 2
4322120 2137815 2137815 defendant Fowe Ralph tanner 586445 586445 Fowe, Ralph, of Ulcombe, tanner 2
4398414 2164050 2164050 defendant Baldocke Philip husbandman 586445 586445 Baldocke, Philip, of Ulcombe, husbandman 2
4551972 2216567 2216567 plaintiff Eslynden John   586445 586445 Eslynden, John, of Ulcombe 0
4594817 2229633 2229633 defendant Aleyn Robert smith 586445 586445 Aleyn, Robert, of Ulcombe, smith 2
4612417 2234952 2234952 defendant Page Henry   586445 586445 Page, Henry, of Ulcombe 3
4612418 2234952 2234952 defendant Boycote John   586445 586445 Boycote, John, of Ulcombe 4
4642968 2244049 2244049 defendant Doraunt Roger   586445 586445 Doraunt, Roger, of Ulcombe 1
4642969 2244049 2244049 defendant Maynard Richard carpenter 586445 586445 Maynard, Richard, of Ulcombe, carpenter 2
4660546 2249123 2249123 defendant Philpot Thomas laborer 586445 586445 Philpot, Thomas, of Ulcombe, laborer 1
4660549 2249123 2249123 defendant Ta- John husbandman 586445 586445 Ta-, John, of Ulcombe, husbandman 4
4665472 2250675 2250675 defendant Post John weaver 586445 586445 Post, John, of Ulcombe, weaver 2
4682595 2260175 2260175 defendant Ive Thomas husbandman 586445 586445 Ive, Thomas, of Ulcombe, husbandman 1
4693266 2263395 2263395 defendant Boycote Henry gent 586445 586445 Boycote, Henry, of Ulcombe, gent 0
4694110 2263658 2263658 defendant Bele Thomas laborer 586445 586445 Bele, Thomas, of Ulcombe, laborer 1
4696852 2264495 2264495 defendant Duraunt Thomas tailor 586445 586445 Duraunt, Thomas, of Ulcombe, tailor 1
4807844 2298640 2298640 plaintiff Conyier John   586445 586445 Conyier John, of Ulcombe 0
4818149 2301751 2301751 defendant Millys Joan widow 586445 586445 Millys, Joan, of Ulcombe, widow 1
4818152 2301751 2301751 defendant Mosewell Thomas husbandman 586445 586445 Mosewell, Thomas, of Ulcombe, husbandman 4
4834057 2306659 2306659 plaintiff Conyere John yeoman 586445 586445 Conyere, John, of Ulcombe, yeoman 0
4836122 2307278 2307278 defendant St Ledger John esq 586445 586445 St Ledger, John, of Ulcombe, esq 0
4836123 2307278 2307278 defendant Grysele William   586445 586445 together with Grysele, William, of Ulcombe, servant 1
4913873 2330847 2330847 plaintiff Conyer John shoemaker 586445 586445 Conyer, John, of Ulcombe, shoemaker 0
4970890 2348238 2348238 defendant Smoddyng Richard husbandman 586445 586445 Smoddyng, Richard, of Ulcombe, husbandman 1
4979218 2350743 2350743 defendant Doget Thomas husbandman 586445 586445 Doget, Thomas, of Ulcombe, husbandman 0
5024540 2364091 2364091 defendant Boycote John gent 586445 586445 Boycote, John, of Ulcombe, gent 0
5041821 2369152 2369152 defendant Pende Thomas laborer 586445 586445 Pende, Thomas, of Ulcombe, laborer 2
5050480 2371765 2371765 defendant Brewer John carpenter 586445 586445 Brewer, John, of Ulcombe, carpenter 1
5057620 2373847 2373847 plaintiff Conyer John   586445 586445 Conyer, John, of Ulcombe 0
5080820 2380755 2380755 plaintiff Conyer or Conere John   586445 586445 Conyer or Conere, John, of Ulcombe 0
5093214 2384408 2384408 defendant Honynden or Hovynden Richard, senior husbandman 586445 586445 Honynden or Hovynden, Richard, senior, of Ulcombe, husbandman 0
5093215 2384408 2384408 defendant Honynden or Hovynden Richard, junior laborer 586445 586445 Honynden or Hovynden, Richard, junior, of Ulcombe, laborer 1
5105736 2388128 2388128 plaintiff Conyer John   586445 586445 Conyer, John, of Ulcombe 0
5128661 2394867 2394867 plaintiff Conyer John   586445 586445 Conyer , John, of Ulcombe 0
5128670 2394870 2394870 defendant Badnor Thomas laborer 586445 586445 Badnor, Thomas, of Ulcombe, laborer 0
5128688 2394874 2394874 plaintiff Conyer John   586445 586445 Conyer, John, of Ulcombe 0
5128694 2394875 2394875 plaintiff Conyer John   586445 586445 Conyer, John, of Ulcombe 0
5128696 2394876 2394876 plaintiff Conyer John yeoman 586445 586445 Conyer, John, of Ulcombe, yeoman 0
5128868 2394929 2394929 plaintiff Coryer alias Couyere John   586445 586445 Coryer alias Couyere, John, of Ulcombe 0
5147855 2400516 2400516 defendant Badenor Thomas laborer 586445 586445 Badenor, Thomas, of Ulcombe, laborer 0
5147880 2400522 2400522 plaintiff Conyer John   586445 586445 Conyer, John, of Ulcombe 0
5147886 2400523 2400523 plaintiff Conyer John   586445 586445 Conyer, John, of Ulcombe 0
5147888 2400524 2400524 plaintiff Conyer John   586445 586445 Conyer, John, of Ulcombe 0
5147890 2400525 2400525 plaintiff Conyer John yeoman 586445 586445 Conyer, John, of Ulcombe, yeoman 0
5154887 2402589 2402589 defendant Mosewell Thomas (legal representative) 586445 586445 Mosewell, Thomas, of Ulcombe, husbandman, executrix of 0
5154888 2402589 2402589 defendant Mosewell Godeleva   586445 586445 Mosewell, Godeleva, of Ulcombe, formerly wife of Thomas 1
5167370 2406193 2406193 defendant Badenor Thomas laborer 586445 586445 Badenor, Thomas, of Ulcombe, laborer 0
5167396 2406198 2406198 plaintiff Conyer John   586445 586445 Conyer, John, of Ulcombe 0
5167398 2406199 2406199 plaintiff Conyer John   586445 586445 Conyer, John, of Ulcombe 0
5182837 2410733 2410733 defendant Badenor Thomas laborer 586445 586445 Badenor, Thomas, of Ulcombe, laborer 0
5182854 2410736 2410736 plaintiff Conyer John   586445 586445 Conyer, John, of Ulcombe 0
5182856 2410737 2410737 plaintiff Conyer John yeoman 586445 586445 Conyer, John, of Ulcombe, yeoman 0
5203611 2416811 2416811 plaintiff Conyer John   586445 586445 Conyer, John, of Ulcombe 0
5206743 2417708 2417708 defendant Mosewelle Thomas (legal representative) 586445 586445 Mosewelle, Thomas, of Ulcombe, husbandman, executrix of 0
5215873 2420375 2420375 defendant Horn Thomas laborer 586445 586445 Horn, Thomas, of Ulcombe, laborer 0
5225008 2422985 2422985 defendant Mosewell William husbanman 586445 586445 Mosewell, William, of Ulcombe, husbanman 0
5234201 2425593 2425593 plaintiff Conyer John   586445 586445 Conyer, John, of Ulcombe 0
5255487 2431838 2431838 defendant Mosewell William husbandman 586445 586445 Mosewell, William, of Ulcombe, husbandman 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);