names

114 rows where place_id = 597338

✎ 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
3628183 1903669 1903669 defendant Edward William yeoman 597338 597338 Edward, William, of Henlowe, yeoman 3
3638043 1906717 1906717 defendant Edward John husbandman 597338 597338 Edward, John, of Henlowe, husbandman 0
3647497 1909608 1909608 defendant Edwardes John husbandman 597338 597338 Edwardes, John, of Henlowe, husbandman 0
3652264 1911046 1911046 defendant Edward John husbandman 597338 597338 Edward, John, of Henlowe, husbandman 4
3654786 1911755 1911755 defendant Edwards John, junior husbandman 597338 597338 Edwards, John, junior, of Henlowe, husbandman 0
3668919 1916211 1916211 defendant Birt Thomas husbandman 597338 597338 Birt, Thomas, of Henlowe, husbandman 1
3675511 1918379 1918379 defendant Edward John yeoman 597338 597338 Edward, John, of Henlowe, yeoman 0
3675512 1918379 1918379 defendant Heyward William maltman 597338 597338 Heyward, William, of Henlowe, maltman 1
3681282 1920232 1920232 defendant Burte Thomas husbandman 597338 597338 Burte, Thomas, of Henlowe, husbandman 0
3687123 1922146 1922146 defendant Birte Thomas husbandman 597338 597338 Birte, Thomas, of Henlowe, husbandman 0
3693115 1924055 1924055 defendant Est Robert yeoman 597338 597338 Est, Robert, of Henlowe, yeoman 1
3693116 1924055 1924055 defendant Jacobe William husbandman 597338 597338 Jacobe, William, of Henlowe, husbandman 2
3721539 1933042 1933042 defendant Edwardys John husbandman 597338 597338 Edwardys, John, of Henlowe, husbandman 3
3736791 1937756 1937756 defendant Burwell George husbandman 597338 597338 Burwell, George, of Henlowe, husbandman 0
3748507 1941468 1941468 defendant Oste alias Strynger Robert or Richard yeoman 597338 597338 Oste alias Strynger, Robert or Richard, of Henlowe, yeoman 2
3763761 1946311 1946311 defendant Heworth William maltman 597338 597338 Heworth, William, of Henlowe, maltman 1
3796844 1956893 1956893 defendant Perott John (legal representative) 597338 597338 Perott, John, of Henlowe, executrix of 0
3796845 1956893 1956893 defendant Perott Elizabeth widow 597338 597338 Perott, Elizabeth, of Henlowe, widow 1
3806612 1959968 1959968 defendant Lewys Hugh laborer 597338 597338 Lewys, Hugh, of Henlowe, laborer 2
3829776 1967206 1967206 defendant Ost Robert yeoman 597338 597338 Ost, Robert, of Henlowe, yeoman 2
3914356 1995142 1995142 defendant Smyth Robert husbandman 597338 597338 Smyth, Robert, of Henlowe, husbandman 0
3919241 1996765 1996765 defendant Rocheford Richard husbandman 597338 597338 Rocheford, Richard, of Henlowe, husbandman 0
3935559 2002203 2002203 defendant Underwood William   597338 597338 Underwood, William, of Henlowe, wool buyer 0
3950146 2007133 2007133 defendant Roper alias Caryngton George stringer 597338 597338 Roper alias Caryngton, George, of Henlowe, stringer 0
3950147 2007133 2007133 defendant Brytten William stringer 597338 597338 Brytten, William, of Henlowe, stringer 1
3974911 2015791 2015791 plaintiff Holden William miller 597338 597338 Holden, William, of Henlowe, miller 0
4058662 2045488 2045488 defendant Raven John yeoman 597338 597338 Raven, John, of Henlowe, yeoman 0
4058664 2045489 2045489 defendant Raven John yeoman 597338 597338 Raven, John, of Henlowe, yeoman 0
4069843 2049498 2049498 defendant Edward George gent 597338 597338 Edward, George, of Henlowe, gent 0
4075473 2051529 2051529 plaintiff Russhe John yeoman 597338 597338 Russhe, John, of Henlowe, yeoman 0
4126823 2069884 2069884 defendant Carryngton George   597338 597338 Carryngton, George, of Henlowe, yeoman, bowstring maker 0
4138337 2074075 2074075 defendant Heydey Thomas stringer 597338 597338 Heydey, Thomas, of Henlowe, laborer, stringer 0
4160868 2081874 2081874 defendant Underwood Thomas yeoman 597338 597338 Underwood, Thomas, of Henlowe, yeoman 1
4180593 2088696 2088696 defendant Shawe John butcher 597338 597338 Shawe, John, of Henlowe, butcher 0
4180594 2088696 2088696 defendant Awdeley John miller 597338 597338 Awdeley, John, of Henlowe, miller 1
4506865 2202616 2202616 defendant Cook Adam butcher 597338 597338 Cook, Adam, of Henlowe, butcher 0
4551139 2216300 2216300 defendant Godfrey William   597338 597338 Godfrey, William, of Henlowe 0
4551140 2216300 2216300 defendant Broun Thomas   597338 597338 Broun, Thomas, of Henlowe 1
4551141 2216300 2216300 defendant Beton Simon   597338 597338 Beton, Simon, of Henlowe 2
4551142 2216300 2216300 defendant Bocher Adam   597338 597338 Bocher, Adam, of Henlowe 3
4554735 2217406 2217406 defendant Cook John butcher 597338 597338 Cook, John, of Henlowe, butcher 2
4583766 2226338 2226338 defendant Marchall John   597338 597338 Marchall, John, of Henlowe 1
4619066 2236957 2236957 defendant Bocher Adam   597338 597338 Bocher, Adam, of Henlowe 1
4674027 2257488 2257488 defendant Cook John butcher 597338 597338 Cook, John, of Henlowe, butcher 1
4687347 2261645 2261645 defendant Mauby William husbandman 597338 597338 Mauby, William, of Henlowe, husbandman 0
4687348 2261645 2261645 defendant Jakys John husbandman 597338 597338 Jakys, John, of Henlowe, husbandman 1
4721288 2271988 2271988 defendant Scot William husbandman 597338 597338 Scot, William, of Henlowe, husbandman 4
4734306 2275903 2275903 defendant Laurence John husbandman 597338 597338 Laurence, John, of Henlowe, husbandman 0
4737857 2276943 2276943 defendant Mauby Richard husbandman 597338 597338 Mauby, Richard, of Henlowe, husbandman 0
4737858 2276943 2276943 defendant Potell John husbandman 597338 597338 Potell, John, of Henlowe, husbandman 1
4740337 2277684 2277684 defendant Jecob Richard husbandman 597338 597338 Jecob, Richard, of Henlowe, husbandman 0
4761479 2283933 2283933 defendant Manley Alice   597338 597338 Manley, Alice, of Henlowe, formerly wife of William 4
4777517 2288962 2288962 defendant del Ely John weaver 597338 597338 del Ely, John, of Henlowe, weaver 1
4779739 2289655 2289655 defendant Pecok John husbandman 597338 597338 Pecok, John, of Henlowe, husbandman 3
4791755 2293519 2293519 defendant Broyn John husbandman 597338 597338 Broyn, John, of Henlowe, husbandman 1
4797166 2295285 2295285 defendant Wyse William husbandman 597338 597338 Wyse, William, of Henlowe, husbandman 4
4813971 2300480 2300480 defendant Wyse William smith 597338 597338 Wyse, William, of Henlowe, smith 1
4825429 2303998 2303998 defendant Potell John, junior husbandman 597338 597338 Potell, John, junior, of Henlowe, husbandman 0
4854037 2312670 2312670 defendant Sandon George husbandman 597338 597338 Sandon, George, of Henlowe, husbandman 2
4885803 2322431 2322431 defendant Cooke Hugh butcher 597338 597338 Cooke, Hugh, of Henlowe, butcher 1
4895496 2325259 2325259 defendant Golde Henry husbandman 597338 597338 Golde, Henry, of Henlowe, husbandman 1
4914312 2330990 2330990 defendant Fille John husbandman 597338 597338 Fille, John, of Henlowe, husbandman 2
4917281 2331913 2331913 plaintiff Fylle John   597338 597338 Fylle, John, of Henlowe 0
4931698 2336300 2336300 defendant Bryngham John husbandman 597338 597338 Bryngham, John, of Henlowe, husbandman 0
4931699 2336300 2336300 defendant Pykerell Henry husbandman 597338 597338 Pykerell, Henry, of Henlowe, husbandman 1
4931700 2336300 2336300 defendant Wyse William husbandman 597338 597338 Wyse, William, of Henlowe, husbandman 2
4934622 2337221 2337221 defendant Fyll John husbandman 597338 597338 Fyll, John, of Henlowe, husbandman 2
4943749 2340012 2340012 defendant Fylle John   597338 597338 Fylle, John, of Henlowe, "deye" 1
4944245 2340172 2340172 defendant Pykerell Henry husbandman 597338 597338 Pykerell, Henry, of Henlowe, husbandman 0
4957796 2344303 2344303 defendant Whyfe or Whyse John smith 597338 597338 Whyfe or Whyse, John, of Henlowe, smith 1
4979874 2350936 2350936 defendant Paxton Robert husbandman 597338 597338 Paxton, Robert, of Henlowe, husbandman 0
4979875 2350936 2350936 defendant Fylle John husbandman 597338 597338 Fylle, John, of Henlowe, husbandman 1
4979876 2350936 2350936 defendant Ayleberne Robert husbandman 597338 597338 Ayleberne, Robert, of Henlowe, husbandman 2
4986535 2352901 2352901 defendant Fyll John husbandman 597338 597338 Fyll, John, of Henlowe, husbandman 1
4988853 2353618 2353618 defendant Coke Hugh butcher 597338 597338 Coke, Hugh, of Henlowe, butcher 0
5015929 2361550 2361550 defendant Deye William husbandman 597338 597338 Deye, William, of Henlowe, husbandman 0
5015930 2361550 2361550 defendant Deye Richard husbandman 597338 597338 Deye, Richard, of Henlowe, husbandman 1
5015932 2361550 2361550 defendant Fylle John husbandman 597338 597338 Fylle, John, of Henlowe, husbandman 3
5021907 2363301 2363301 defendant Pekworth Thomas chaplain 597338 597338 Pekworth, Thomas, of Henlowe, chaplain 0
5022699 2363548 2363548 defendant Pekworth Thomas clerk 597338 597338 Pekworth, Thomas, of Henlowe, clerk 3
5026307 2364583 2364583 defendant Jacob Richard husbandman 597338 597338 Jacob, Richard, of Henlowe, husbandman 0
5044521 2369992 2369992 defendant Knot John husbandman 597338 597338 Knot, John, of Henlowe, husbandman 0
5045113 2370169 2370169 defendant Alyleberne Robert husbandman 597338 597338 Alyleberne, Robert, of Henlowe, husbandman 0
5045114 2370169 2370169 defendant Daye Richard husbandman 597338 597338 Daye, Richard, of Henlowe, husbandman 1
5045115 2370169 2370169 defendant Mauby or Manby Richard husbandman 597338 597338 Mauby or Manby, Richard, of Henlowe, husbandman 2
5053639 2372691 2372691 defendant Fylle Thomas yeoman 597338 597338 Fylle, Thomas, of Henlowe, ,yeoman 2
5053644 2372692 2372692 defendant Fylle Thomas yeoman 597338 597338 Fylle, Thomas, of Henlowe, yeoman 2
5141597 2398653 2398653 defendant atte Stone John (legal representative) 597338 597338 atte Stone, John, of Henlowe, executors of 0
5162682 2404806 2404806 defendant atte Stone John (legal representative) 597338 597338 atte Stone, John, of Henlowe, executors of 0
5162685 2404806 2404806 defendant Goold Nicholas husbandman 597338 597338 Goold, Nicholas, of Henlowe, husbandman 3
5162690 2404807 2404807 defendant atte Stone John (legal representative) 597338 597338 atte Stone, John, of Henlowe, executors of 0
5162692 2404807 2404807 defendant Day William husbandman 597338 597338 Day, William, of Henlowe, husbandman 2
5213776 2419758 2419758 defendant Charlton Thomas laborer 597338 597338 Charlton, Thomas, of Henlowe, laborer 2
5235646 2426007 2426007 plaintiff Dey William   597338 597338 Dey, William, of Henlowe 0
5238056 2426722 2426722 defendant Botiller Richard butcher 597338 597338 Botiller, Richard, of Henlowe, butcher 2
5238884 2426961 2426961 defendant Northfolk John (legal representative) 597338 597338 Northfolk, John, of Henlowe, husbandman, executors of 4
5271357 2436715 2436715 defendant Hochekyn Thomas yeoman 597338 597338 Hochekyn, Thomas, of Henlowe, yeoman 4
5285175 2440686 2440686 defendant Taverner William yeoman 597338 597338 Taverner, William, of Henlowe, yeoman 1
5285180 2440687 2440687 defendant Taverner William yeoman 597338 597338 Taverner, William, of Henlowe, yeoman 1
5290630 2442262 2442262 defendant Taverner William yeoman 597338 597338 Taverner, William, of Henlowe, yeoman 2

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