names

67 rows where place_id = 588033

✎ 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
3593153 1865487 1865487 plaintiff Harper Richard gent 588033 588033 Harper, Richard, of Eppyng, gent 0
3612450 1871525 1871525 defendant Pratte Mathew yeoman 588033 588033 Pratte, Mathew, of Eppyng, yeoman 0
3652024 1910985 1910985 defendant Wyberd Thomas yeoman 588033 588033 Wyberd, Thomas, of Eppyng, yeoman 0
3688052 1922426 1922426 defendant Borton Thomas brewer 588033 588033 Borton, Thomas, of Eppyng, brewer 4
3693250 1924099 1924099 defendant Pakker William butcher 588033 588033 Pakker, William, of Eppyng, butcher 0
3694112 1924362 1924362 defendant Rygby Oliver yeoman 588033 588033 Rygby, Oliver, of Eppyng, yeoman 0
3700443 1926377 1926377 defendant Sargeant George sawyer 588033 588033 Sargeant, George, of Eppyng, sawyer 0
3710914 1929732 1929732 defendant Pakker William butcher 588033 588033 Pakker, William, of Eppyng, butcher 1
3710919 1929733 1929733 defendant Pakker William butcher 588033 588033 Pakker, William, of Eppyng, butcher 1
3710924 1929734 1929734 defendant Pakker William butcher 588033 588033 Pakker, William, of Eppyng, butcher 1
3735268 1937265 1937265 defendant Williams John cordwainer 588033 588033 Williams, John, of Eppyng, cordwainer 0
3736650 1937714 1937714 defendant Pakker William butcher 588033 588033 Pakker, William, of Eppyng, butcher 0
3744342 1940132 1940132 defendant Ramsey George husbandman 588033 588033 Ramsey, George, of Eppyng, husbandman 0
3748444 1941447 1941447 defendant Packer William butcher 588033 588033 Packer, William, of Eppyng, butcher 3
3755620 1943716 1943716 defendant Pecok Robert husbandman 588033 588033 Pecok, Robert, of Eppyng, husbandman 0
3755622 1943716 1943716 defendant Benton William husbandman 588033 588033 Benton, William, of Eppyng, husbandman 2
3781350 1951909 1951909 defendant Williams John shoemaker 588033 588033 Williams, John, of Eppyng, shoemaker 0
3781462 1951940 1951940 defendant Baker William carpenter 588033 588033 Baker, William, of Eppyng, carpenter 0
3798044 1957286 1957286 defendant Hare Richard husbandman 588033 588033 Hare, Richard, of Eppyng, husbandman 0
3799948 1957904 1957904 defendant Bradley Andrew yeoman 588033 588033 Bradley, Andrew, of Eppyng, yeoman 0
3801846 1958473 1958473 defendant Sariant George husbandman 588033 588033 Sariant, George, of Eppyng, husbandman 0
3871886 1980833 1980833 defendant Campyon Edward gent 588033 588033 Campyon, Edward, of Eppyng, gent 0
3905120 1991977 1991977 defendant Greygose William yeoman 588033 588033 Greygose, William, of Eppyng, yeoman 0
3906781 1992559 1992559 defendant Abbott John   588033 588033 Abbott, John, of Eppyng, horse courser 0
3921181 1997437 1997437 defendant Sedcole John maltman 588033 588033 Sedcole, John, of Eppyng, maltman 0
3983285 2018794 2018794 defendant Riggeby John yeoman 588033 588033 Riggeby, John, of Eppyng, yeoman 0
3983286 2018794 2018794 defendant Newman John laborer 588033 588033 Newman, John, of Eppyng, laborer 1
3983287 2018794 2018794 defendant Poole William laborer 588033 588033 Poole, William, of Eppyng, laborer 2
4339210 2143476 2143476 defendant Gore Robert yeoman 588033 588033 Gore, Robert, of Eppyng, yeoman 1
4429505 2174028 2174028 defendant atte Chaumbre Gilbert   588033 588033 atte Chaumbre, Gilbert, of Eppyng 0
4716423 2270453 2270453 defendant Wyberd Thomas laborer 588033 588033 Wyberd, Thomas, of Eppyng, laborer 2
4840472 2308558 2308558 defendant Wyberd John husbandman 588033 588033 Wyberd, John, of Eppyng, husbandman 1
4840473 2308558 2308558 defendant Wyberd Thomas husbandman 588033 588033 Wyberd, Thomas, of Eppyng, husbandman 2
4840474 2308558 2308558 defendant Wyberd Robert husbandman 588033 588033 Wyberd, Robert, of Eppyng, husbandman 3
4865125 2316066 2316066 defendant Wyberd Robert husbandman 588033 588033 Wyberd, Robert, of Eppyng, husbandman 1
4915115 2331234 2331234 defendant Sly John husbandman 588033 588033 Sly, John, of Eppyng, husbandman 4
4926294 2334649 2334649 defendant Wyberd Robert yeoman 588033 588033 Wyberd, Robert, of Eppyng, yeoman 0
4928389 2335300 2335300 defendant Roppesley Henry clerk 588033 588033 Roppesley, Henry, of eppyng, clerk 1
4977606 2350267 2350267 defendant Bryd Robert husbandman 588033 588033 Bryd, Robert, of Eppyng, husbandman 0
5073696 2378618 2378618 defendant Fretyngham Alice widow 588033 588033 Fretyngham, Alice, of Eppyng, widow 1
5077786 2379851 2379851 defendant Brigge John laborer 588033 588033 Brigge, John, of Eppyng, laborer 0
5077795 2379853 2379853 defendant Brygge John laborer 588033 588033 Brygge, John, of Eppyng, laborer 3
5118139 2391739 2391739 defendant Forest John husbandman 588033 588033 together with Forest, John, of Eppyng, husbandman 1
5118140 2391739 2391739 defendant Petecrwe Robert smith 588033 588033 Petecrwe, Robert, of Eppyng, smith 2
5263099 2434202 2434202 defendant Peke William collier 588033 588033 Peke, William, of Eppyng, collier 0
5319481 2450919 2450919 defendant Alderford Thomas butcher 588033 588033 Alderford, Thomas, of Eppyng, butcher 1
5319485 2450920 2450920 defendant Alderford Thomas butcher 588033 588033 Alderford, Thomas, of Eppyng, butcher 0
5374556 2467647 2467647 defendant Smyth John husbandman 588033 588033 Smyth, John, of Eppyng, husbandman 0
5386191 2471114 2471114 defendant P_ William husbandman 588033 588033 P_, William, of Eppyng, husbandman 1
5389915 2472179 2472179 defendant Algoe Henry husbandman 588033 588033 Algoe, Henry, of Eppyng, husbandman 2
5391209 2472564 2472564 defendant Smyth John smith 588033 588033 Smyth, John, of Eppyng, smith 0
5391211 2472565 2472565 defendant Smyth John smith 588033 588033 Smyth, John, of Eppyng, smith 0
5402718 2475853 2475853 defendant Algore Henry husbandman 588033 588033 Algore, Henry, of Eppyng, husbandman 2
5404173 2476272 2476272 defendant Smyth John smith 588033 588033 Smyth, John, of Eppyng, smith 0
5404175 2476273 2476273 defendant Smyth John smith 588033 588033 Smyth, John, of Eppyng, smith 0
5404177 2476274 2476274 defendant South John smith 588033 588033 South, John, of Eppyng, smith 0
5415651 2479624 2479624 defendant Algore Henry husbandman 588033 588033 Algore, Henry, of Eppyng, husbandman 2
5432059 2484556 2484556 defendant Albore Henry husbandman 588033 588033 Albore, Henry, of Eppyng, husbandman 2
5432065 2484557 2484557 defendant Algor Henry husbandman 588033 588033 Algor, Henry, of Eppyng, husbandman 2
5435349 2485510 2485510 defendant Parker Richard yeoman 588033 588033 Parker, Richard, of Eppyng, yeoman 1
5490055 2501908 2501908 defendant Holwey Henry husbandman 588033 588033 Holwey, Henry, of Eppyng, husbandman 2
5498613 2504528 2504528 defendant Shirwode Nicholas collier 588033 588033 Shirwode, Nicholas, of Eppyng, collier 0
5502529 2505709 2505709 defendant Smyth Thomas (legal representative) 588033 588033 Smyth, Thomas, of Eppyng, husbandman, executors of 3
5519002 2510786 2510786 defendant Sclye or Solye John brewer 588033 588033 Sclye or Solye, John, of Eppyng, brewer 0
5547672 2519334 2519334 defendant Carter John husbandman 588033 588033 Carter, John, of Eppyng, husbandman 1
5578715 2528404 2528404 defendant Schotte Richard butcher 588033 588033 Schotte, Richard, of Eppyng, butcher 1
5582597 2529624 2529624 defendant Skot Richard butcher 588033 588033 Skot, Richard, of Eppyng, butcher 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);