names

49 rows where place_id = 624471

✎ 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
3737239 1937879 1937879 defendant (not given) William rector of Hampton 624471 624471 Hampton, William, of Holme juxta Mare, rector of Thorp Morieux 0
3758348 1944607 1944607 defendant Mathewe Peter miller 624471 624471 Mathewe, Peter, of Holme juxta Mare, miller 0
3768100 1947658 1947658 defendant Pepyr Robert husbandman 624471 624471 Pepyr, Robert, of Holme juxta Mare, husbandman 0
3802484 1958676 1958676 defendant Peerson William butcher 624471 624471 Peerson, William, of Holme juxta Mare, butcher 0
3851224 1973979 1973979 defendant Peerson William husbandman 624471 624471 Peerson, William, of Holme juxta Mare, husbandman 0
3851225 1973979 1973979 defendant Peerson Nicholas husbandman 624471 624471 Peerson, Nicholas, of Holme juxta Mare, husbandman 1
3879692 1983463 1983463 defendant Calowe John husbandman 624471 624471 Calowe, John, of Holme juxta Mare, husbandman 0
3881728 1984139 1984139 plaintiff Skye William   624471 624471 Skye, William, of Holme juxta Mare 0
3906934 1992607 1992607 defendant Stone Robert yeoman 624471 624471 Stone, Robert, of Holme juxta Mare, yeoman 0
3943655 2004894 2004894 defendant Bale John husbandman 624471 624471 Bale, John, of Holme juxta Mare, husbandman 0
3943656 2004894 2004894 defendant Banyard Nicholas   624471 624471 Banyard, Nicholas, of Holme juxta Mare 1
3943657 2004894 2004894 defendant Englysshe alias Shepperde Nicholas husbandman 624471 624471 Englysshe alias Shepperde, Nicholas, of Holme juxta Mare, husbandman 2
3943658 2004894 2004894 defendant Palmer John, senior husbandman 624471 624471 Palmer, John, senior, of Holme juxta Mare, husbandman 3
3943660 2004895 2004895 defendant Bale John husbandman 624471 624471 Bale, John, of Holme juxta Mare, husbandman 0
3943661 2004895 2004895 defendant Banyard Nicholas husbandman 624471 624471 Banyard, Nicholas, of Holme juxta Mare, husbandman 1
3970790 2014373 2014373 defendant Futter Nicholas husbandman 624471 624471 Futter, Nicholas, of Holme juxta Mare, husbandman 0
3990081 2021206 2021206 plaintiff Bell William smith 624471 624471 Bell, William, of Holme juxta Mare, smith 0
3990082 2021206 2021206 defendant Stone Robert husbandman 624471 624471 Stone, Robert, of Holme juxta Mare, husbandman 0
3990987 2021539 2021539 defendant Hawghton Henry mariner 624471 624471 Hawghton, Henry, of Holme juxta Mare, mariner 1
4016378 2030557 2030557 plaintiff Stone Richard yeoman 624471 624471 Stone, Richard, of Holme juxta Mare, yeoman 0
4021327 2032350 2032350 defendant Wysse Robert husbandman 624471 624471 Wysse, Robert, of Holme juxta Mare, husbandman 6
4033747 2036721 2036721 defendant Stone Richard yeoman 624471 624471 Stone, Richard, of Holme juxta Mare, yeoman 0
4047667 2041613 2041613 defendant Aslack William gent 624471 624471 Aslack, William, of Holme juxta Mare, gent 0
4047668 2041613 2041613 defendant Pyper William husbandman 624471 624471 Pyper, William, of Holme juxta Mare, husbandman 1
4047670 2041614 2041614 defendant Rightwysse Richard husbandman 624471 624471 Rightwysse, Richard, of Holme juxta Mare, husbandman 0
4051850 2043082 2043082 defendant Smyth William thatcher 624471 624471 Smyth, William, of Holme juxta Mare, thatcher 0
4061848 2046633 2046633 defendant Skey Reginald merchant 624471 624471 Skey, Reginald, of Holme juxta Mare, merchant 0
4103627 2061578 2061578 defendant Person William laborer 624471 624471 Person, William, of Holme juxta Mare, laborer 0
4113052 2064934 2064934 defendant Todde Richard husbandman 624471 624471 Todde, Richard, of Holme juxta Mare, husbandman 1
4113053 2064934 2064934 defendant Darrell Henry husbandman 624471 624471 Darrell, Henry, of Holme juxta Mare, husbandman 2
4143754 2075976 2075976 defendant Ledbeater Stephen yeoman 624471 624471 Ledbeater, Stephen, of Holme juxta Mare, yeoman 0
4221808 2103123 2103123 defendant Skye Reginald husbandman 624471 624471 Skye, Reginald, of Holme juxta Mare, husbandman 0
4247499 2112150 2112150 defendant Palmer Robert husbandman 624471 624471 Palmer, Robert, of Holme juxta Mare, husbandman 0
4247501 2112151 2112151 defendant Palmer Robert husbandman 624471 624471 Palmer, Robert, of Holme juxta Mare, husbandman 0
4261138 2116694 2116694 defendant Godfrey Giles gent 624471 624471 Godfrey, Giles, of Holme juxta Mare, gent 0
4261139 2116694 2116694 defendant Person Beatrice widow 624471 624471 Person, Beatrice, of Holme juxta Mare, widow 1
4261140 2116694 2116694 defendant West John husbandman 624471 624471 West, John, of Holme juxta Mare, husbandman 2
4261141 2116694 2116694 defendant Ryschys Robert husbandman 624471 624471 Ryschys, Robert, of Holme juxta Mare, husbandman 3
4291050 2126864 2126864 defendant Skye Reginald yeoman 624471 624471 Skye, Reginald, of Holme juxta mare, yeoman 2
4291057 2126867 2126867 defendant Skey Reginald husbandman 624471 624471 Skey, Reginald, of Holme juxta Mare, husbandman 0
4291060 2126868 2126868 defendant Hollie William, junior yeoman 624471 624471 Hollie, William, junior, of Holme juxta Mare, yeoman 1
4321055 2137460 2137460 defendant Skey Reginald husbandman 624471 624471 Skey, Reginald, of Holme juxta Mare, husbandman 0
4354457 2148790 2148790 defendant Overman Simon husbandman 624471 624471 Overman, Simon, of Holme juxta Mare, husbandman 0
5314576 2449391 2449391 defendant Batell William yeoman 624471 624471 Batell, William, of Holme juxta Mare, yeoman 2
5363273 2464168 2464168 defendant Abbis or Abbot Robert (legal representative) 624471 624471 Abbis or Abbot, Robert, of Holme juxta Mare, husbandman, executor of 0
5363274 2464168 2464168 defendant Fouler Nicholas husbandman 624471 624471 Fouler, Nicholas, of Holme juxta Mare, husbandman 1
5546922 2519100 2519100 defendant Halys John husbandman 624471 624471 Halys, John, of Holme juxta Mare, husbandman 2
5586360 2530777 2530777 defendant Huntley John husbandman 624471 624471 Huntley, John, of Holme juxta Mare, husbandman 0
5627320 2552512 2552512 plaintiff Notyngham Henry esq 624471 624471 Notyngham, Henry, of Holme juxta Mare, esq 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);