names

71 rows where place_id = 593764

✎ 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
3613221 1871789 1871789 defendant Penne John gent 593764 593764 Penne, John, of Penne, gent 0
3654412 1911641 1911641 defendant Cok Henry husbandman 593764 593764 Cok, Henry, of Penne, husbandman 0
3654413 1911641 1911641 defendant Shrympton William husbandman 593764 593764 Shrympton, William, of Penne, husbandman 1
3674861 1918165 1918165 defendant at Redyng William bargeman 593764 593764 at Redyng, William, of Penne, bargeman 0
3685459 1921603 1921603 defendant Eggam Richard carpenter 593764 593764 Eggam, Richard, of Penne, carpenter 0
3731758 1936163 1936163 defendant More William butcher 593764 593764 More, William, of Penne, butcher 0
3731759 1936163 1936163 defendant Mathewe John husbandman 593764 593764 Mathewe, John, of Penne, husbandman 1
3743193 1939734 1939734 defendant Londysdale George sawyer 593764 593764 Londysdale, George, of Penne, sawyer 4
3745975 1940647 1940647 defendant Grove Thomas laborer 593764 593764 Grove, Thomas, of Penne, laborer 1
3753355 1942987 1942987 defendant Bovyndon Thomas husbandman 593764 593764 Bovyndon, Thomas, of Penne, husbandman 1
3754797 1943457 1943457 defendant Tylbury John   593764 593764 Tylbury, John, of Penne, parish clerk 0
3758977 1944797 1944797 defendant Grove Thomas laborer 593764 593764 Grove, Thomas, of Penne, laborer 1
3769360 1948072 1948072 defendant Culverhowse Roger husbandman 593764 593764 Culverhowse, Roger, of Penne, husbandman 1
3770370 1948408 1948408 defendant Grove Thomas yeoman 593764 593764 Grove, Thomas, of Penne, yeoman 0
3770371 1948408 1948408 defendant Bevyndon Thomas husbandman 593764 593764 Bevyndon, Thomas, of Penne, husbandman 1
3775285 1950009 1950009 defendant Newman John husbandman 593764 593764 Newman, John, of Penne, husbandman 1
3776999 1950552 1950552 defendant Grove Thomas laborer 593764 593764 Grove, Thomas, of penne, laborer 1
3791388 1955141 1955141 defendant Adene Henry husbandman 593764 593764 Adene, Henry, of Penne, husbandman 0
3806806 1960032 1960032 defendant Newman John laborer 593764 593764 Newman, John, of Penne, laborer 0
3857812 1976082 1976082 defendant Playter John laborer 593764 593764 Playter, John, of Penne, laborer 0
3857813 1976082 1976082 defendant Miles Robert laborer 593764 593764 Miles, Robert, of Penne, laborer 1
3872710 1981088 1981088 defendant Playter Roger husbandman 593764 593764 Playter, Roger, of Penne, husbandman 2
3878692 1983121 1983121 defendant Hyll Edmund husbandman 593764 593764 Hyll, Edmund, of Penne, husbandman 0
3878694 1983122 1983122 defendant Hyll Edmund husbandman 593764 593764 Hyll, Edmund, of Penne, husbandman 0
3902022 1990905 1990905 defendant Dene William husbandman 593764 593764 Dene, William, of Penne, husbandman 0
3902024 1990906 1990906 defendant Denne William husbandman 593764 593764 Denne, William, of Penne, husbandman 0
3902025 1990906 1990906 defendant Newman John husbandman 593764 593764 Newman, John, of Penne, husbandman 1
3913140 1994728 1994728 defendant Hylle Edmund husbandman 593764 593764 Hylle, Edmund, of Penne, husbandman 0
3925636 1998885 1998885 defendant Myles John husbandman 593764 593764 Myles, John, of Penne, husbandman 0
4074615 2051224 2051224 defendant Jonnes William yeoman 593764 593764 Jonnes, William, of Penne, yeoman 0
4157271 2080612 2080612 defendant Eles Lawrence husbandman 593764 593764 Eles, Lawrence, of Penne, husbandman 2
4157277 2080613 2080613 defendant Eles Lawrence husbandman 593764 593764 Eles, Lawrence, of Penne, husbandman 2
4440567 2181961 2181961 defendant Shephurd Robert parker 593764 593764 Shephurd, Robert, of penne, parker 5
4444973 2183401 2183401 defendant Brigges William   593764 593764 Brigges, William, of Penne 0
4534452 2211051 2211051 defendant Virgon Thomas   593764 593764 Virgon, Thomas, of Penne 0
4534458 2211051 2211051 defendant Hullemete Walter   593764 593764 together with Hullemete, Walter, of Penne 6
4534459 2211051 2211051 defendant atte Dene Baldewin laborer 593764 593764 atte Dene, Baldewin, of Penne, laborer 7
4564666 2220511 2220511 defendant atte Penne Richard   593764 593764 atte Penne, Richard, of Penne 0
4592352 2228956 2228956 defendant Virgun Thomas   593764 593764 Virgun, Thomas, of Penne 0
4592353 2228956 2228956 defendant Spenser William   593764 593764 Spenser, William, of Penne 1
4619736 2237160 2237160 defendant Nurse William   593764 593764 Nurse, William, of Penne 1
4713119 2269424 2269424 defendant Chepman Robert laborer 593764 593764 Chepman, Robert, of Penne, laborer 3
4735598 2276284 2276284 defendant Chepman Robert laborer 593764 593764 Chepman, Robert, of Penne, laborer 3
4934033 2337023 2337023 defendant Palmer Stephen husbandman 593764 593764 Palmer, Stephen, of Penne, husbandman 0
4942955 2339771 2339771 defendant Cokkys John husbandman 593764 593764 Cokkys, John, of Penne, husbandman 3
4978874 2350638 2350638 defendant Austyn Thomas husbandman 593764 593764 Austyn, Thomas, of Penne, husbandman 0
5061597 2375057 2375057 defendant Hener or Hever Henry husbandman 593764 593764 Hener or Hever, Henry, of Penne, husbandman 0
5240023 2427282 2427282 defendant Halle John yeoman 593764 593764 Halle, John, of Penne, yeoman 0
5240024 2427282 2427282 defendant Puttenham Henry gent 593764 593764 Puttenham, Henry, of Penne, gent 1
5240026 2427283 2427283 defendant Halle John yeoman 593764 593764 Halle, John, of Penne, yeoman 0
5240027 2427283 2427283 defendant Puttenham Henry gent 593764 593764 Puttenham, Henry, of Penne, gent 1
5340839 2457336 2457336 defendant Culverhous Richard smith 593764 593764 Culverhous, Richard, of Penne, smith 0
5346013 2458889 2458889 defendant Sexten Richard husbandman 593764 593764 Sexten, Richard, of Penne, husbandman 1
5346014 2458889 2458889 defendant Knyfe John laborer 593764 593764 Knyfe, John, of Penne, laborer 2
5355329 2461741 2461741 defendant Taillour John clerk 593764 593764 Taillour, John, of Penne, clerk 0
5367296 2465424 2465424 defendant Bovyndon Richard   593764 593764 Bovyndon, Richard, of Penne 0
5367297 2465424 2465424 defendant Funge Richard   593764 593764 Funge, Richard, of Penne 1
5367300 2465424 2465424 defendant Culverhous Thomas husbandman 593764 593764 Culverhous, Thomas, of Penne, husbandman 4
5374828 2467722 2467722 plaintiff Penne John gent 593764 593764 Penne, John, of Penne, gent 0
5423362 2481947 2481947 defendant Abbot John yeoman 593764 593764 Abbot, John, of Penne, yeoman 1
5467218 2495140 2495140 defendant Abbot John yeoman 593764 593764 Abbot, John, of Penne, yeoman 1
5486427 2500831 2500831 defendant Kyng Richard   593764 593764 Kyng, Richard, of Penne, wheelwright 0
5490530 2502059 2502059 defendant Panyer or Pavyer William husbandman 593764 593764 Panyer or Pavyer, William, of Penne, husbandman 2
5501088 2505276 2505276 defendant Overstrete Henry   593764 593764 Overstrete, Henry, of Penne, tile maker 1
5563057 2523793 2523793 defendant Culverhowse Roger   593764 593764 Culverhowse, Roger, of Penne 0
5563058 2523793 2523793 defendant Lake Edward laborer 593764 593764 Lake, Edward, of Penne, laborer 1
5563059 2523793 2523793 defendant (not given) Thomas husbandman 593764 593764 -, Thomas, of Penne, husbandman 2
5563567 2523950 2523950 defendant Dene Henry yeoman 593764 593764 Dene, Henry, of Penne, yeoman 0
5563569 2523951 2523951 defendant Saunder William yeoman 593764 593764 Saunder, William, of Penne, yeoman 0
5576215 2527622 2527622 defendant Culverhowse Roger husbandman 593764 593764 Culverhowse, Roger, of Penne, husbandman 2
5593060 2532814 2532814 defendant Felowe Joan widow 593764 593764 Felowe, Joan, of Penne, widow 0

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