names

61 rows where place_id = 594839

✎ 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
3617800 1873190 1873190 defendant Thake John yeoman 594839 594839 Thake, John, of Claveryng, Essex, yeoman 0
3617802 1873191 1873191 defendant Thake John yeoman 594839 594839 Thake, John, of Claveryng, Essex, yeoman 0
3745177 1940397 1940397 defendant Bradbury William esq 594839 594839 Bradbury, William, of Claveryng, Essex, esq 0
3749309 1941709 1941709 defendant Bradbury William gent 594839 594839 Bradbury, William, of Claveryng, Essex, gent 1
3757726 1944398 1944398 defendant Bradbury William esq 594839 594839 Bradbury, William, of Claveryng, Essex, esq 0
3762154 1945807 1945807 defendant Cosyn Nicholas yeoman 594839 594839 Cosyn, Nicholas, of Claveryng, Essex, yeoman 0
3770527 1948466 1948466 defendant Cosyn Nicholas yeoman 594839 594839 Cosyn, Nicholas, of Claveryng, Essex, yeoman 0
3785379 1953214 1953214 defendant Dykkys Richard weaver 594839 594839 Dykkys, Richard, of Claveryng, Essex, weaver 3
3787449 1953866 1953866 defendant Downey Robert chaplain 594839 594839 Downey, Robert, of Claveryng, Essex, chaplain 4
3868662 1979760 1979760 defendant Campe Thomas husbandman 594839 594839 Campe, Thomas, of Claveryng, Essex, husbandman 0
3877345 1982670 1982670 defendant Bradbury William esq 594839 594839 Bradbury, William, of Claveryng, essex, esq 0
3904674 1991819 1991819 defendant Bradbury William esq 594839 594839 Bradbury, William, of Claveryng, Essex, esq 2
3920414 1997170 1997170 defendant Day John mercer 594839 594839 Day, John, of Claveryng, Essex, mercer 0
3920416 1997171 1997171 defendant Day John mercer 594839 594839 Day, John, of Claveryng, Essex, mercer 0
3930609 2000581 2000581 defendant Meade Richard yeoman 594839 594839 Meade, Richard, of Claveryng, Essex, yeoman 0
3932457 2001144 2001144 defendant Fowneby Bartholomew gent 594839 594839 Fowneby, Bartholomew, of Claveryng, Essex, gent 0
3933693 2001561 2001561 plaintiff Hagar John, junior husbandman 594839 594839 Hagar, John, junior, of Claveryng, Essex, husbandman 0
3970005 2014104 2014104 defendant Brasyer alias Hyckman Robert yeoman 594839 594839 Brasyer alias Hyckman, Robert, of Claveryng, Essex, yeoman 0
3979612 2017467 2017467 defendant Hyckman alias Brasyer Robert husbandman 594839 594839 Hyckman alias Brasyer, Robert, of Claveryng, Essex, husbandman 0
3979614 2017468 2017468 defendant Hyckman alias Brasyer Robert husbandman 594839 594839 Hyckman alias Brasyer, Robert, of Claveryng, Essex, husbandman 0
3988970 2020794 2020794 defendant Handichett or Hanchett John yeoman 594839 594839 Handichett or Hanchett, John, of Claveryng, Essex, yeoman 0
4613535 2235252 2235252 defendant Geddyng Richard   594839 594839 Geddyng, Richard, of Claveryng, Essex 0
4754315 2281727 2281727 defendant Benyngton John gent 594839 594839 Benyngton, John, of Claveryng, Essex, gent 0
4761601 2283973 2283973 defendant Collewyk William chaplain 594839 594839 Collewyk, William, of Claveryng, Essex, chaplain 3
4876891 2319740 2319740 defendant Busshop Thomas smith 594839 594839 Busshop, Thomas, of Claveryng, Essex, smith 2
4896177 2325464 2325464 plaintiff Crulle William husbandman 594839 594839 Crulle, William, of Claveryng, Essex, husbandman 0
4901759 2327156 2327156 defendant Skilful Richard gent 594839 594839 Skilful, Richard, of Claveryng, Essex, gent 1
4926842 2334825 2334825 defendant Admond William pulter or poultry man 594839 594839 Admond, William, of Claveryng, Essex, pulter or poultry man 0
4932037 2336409 2336409 defendant Prentys Richard   594839 594839 Prentys, Richard, of Claveryng, Essex, vicar 0
4932792 2336641 2336641 defendant Fale John butcher 594839 594839 Fale, John, of Claveryng, Essex, butcher 1
4933687 2336914 2336914 defendant Admond William pulter 594839 594839 Admond, William, of Claveryng, Essex, pulter 0
4933690 2336915 2336915 defendant Admond William pulter 594839 594839 Admond, William, of Claveryng, Essex, pulter 0
4942930 2339764 2339764 defendant Gynnour Richard yeoman 594839 594839 Gynnour, Richard, of Claveryng, Essex, yeoman 0
4942935 2339765 2339765 defendant Admond William pulter 594839 594839 Admond, William, of Claveryng, Essex, pulter 0
4956181 2343811 2343811 defendant Gyrcok Henry clerk 594839 594839 Gyrcok, Henry, of Claveryng, Essex, clerk 1
4958899 2344631 2344631 defendant Admond William pulter 594839 594839 Admond, William, of Claveryng, Essex, pulter 0
4958902 2344632 2344632 defendant Admond William pulter 594839 594839 Admond, William, of Claveryng, Essex, pulter 0
5115547 2390974 2390974 defendant Thake John butcher 594839 594839 Thake, John, of Claveryng, Essex, butcher 1
5251620 2430609 2430609 defendant Turnour John husbandman 594839 594839 Turnour, John, of Claveryng, Essex, husbandman 3
5277108 2438393 2438393 defendant Fyp William pulter 594839 594839 Fyp, William, of Claveryng, Essex, pulter 2
5277117 2438395 2438395 defendant Fyp William pulter 594839 594839 Fyp, William, of Claveryng, Essex, pulter 2
5328836 2453702 2453702 defendant Helperby Richard clerk 594839 594839 Helperby, Richard, of Claveryng, Essex, clerk 1
5330589 2454240 2454240 defendant Thake John butcher 594839 594839 Thake, John, of Claveryng, Essex, butcher 0
5394216 2473408 2473408 defendant Walton Thomas gent 594839 594839 Walton, Thomas, of Claveryng, Essex, gent 0
5415837 2479671 2479671 defendant Morys Thomas miller 594839 594839 Morys, Thomas, of Claveryng, Essex, miller 1
5460790 2493175 2493175 defendant Hevyngdon Edmund gent & son of John 594839 594839 Hevyngdon, Edmund, of Claveryng, Essex, gent & son of John 1
5472374 2496704 2496704 defendant Honyngton Edmund   594839 594839 Honyngton, Edmund, of Claveryng, Essex, gent, son of John 0
5472378 2496705 2496705 defendant Hovyngdon Edmund gent & son of John 594839 594839 Hovyngdon, Edmund, of Claveryng, Essex, gent & son of John 1
5472384 2496706 2496706 defendant Hovyngdon Edmund gent & son of John 594839 594839 Hovyngdon, Edmund, of Claveryng, Essex, gent & son of John 1
5480889 2499238 2499238 defendant Wenham William husbandman 594839 594839 Wenham, William, of Claveryng, Essex, husbandman 1
5483831 2500107 2500107 defendant Honyngton or Hovyngton Edmund   594839 594839 Honyngton or Hovyngton, Edmund, of Claveryng, Essex, gent, son of Honyngton or Hovyngton, John 1
5501507 2505405 2505405 defendant Lorkyn Thomas yeoman 594839 594839 Lorkyn, Thomas, of Claveryng, Essex, yeoman 2
5522798 2511958 2511958 defendant Lorkyn Thomas yeoman 594839 594839 Lorkyn, Thomas, of Claveryng, Essex, yeoman 0
5542542 2517792 2517792 defendant Songer John husbandman 594839 594839 Songer, John, of Claveryng, Essex, husbandman 0
5542795 2517868 2517868 defendant Songer John husbandman 594839 594839 Songer, John, of Claveryng, Essex, husbandman 1
5547760 2519359 2519359 defendant Mede Thomas husbandman 594839 594839 Mede, Thomas, of Claveryng, Essex, husbandman 0
5550806 2520266 2520266 defendant Cokkeswete John yeoman 594839 594839 Cokkeswete, John, of Claveryng, Essex, yeoman 0
5578284 2528277 2528277 defendant Cokeswhite John husbandman 594839 594839 Cokeswhite, John, of Claveryng, Essex, husbandman 2
5582996 2529756 2529756 defendant Lorkyn Thomas yeoman 594839 594839 Lorkyn, Thomas, of Claveryng, Essex, yeoman 1
5598107 2534304 2534304 defendant Bradbury William gent 594839 594839 Bradbury, William, of Claveryng, essex, gent 0
5599838 2534835 2534835 defendant Lychefeld Richard yeoman 594839 594839 Lychefeld, Richard, of Claveryng, Essex, yeoman 3

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