names

42 rows where place_id = 650810

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594805 1866003 1866003 defendant Hante or Haute Richard   650810 650810 Hante or Haute, Richard, of High Onger, Essex, knight 0
3598558 1867175 1867175 defendant Glascok Geoffrey butcher 650810 650810 Glascok, Geoffrey, of High Ester, Essex, butcher 0
3598585 1867181 1867181 defendant Glayscok John farmer of High Ester Bury 650810 650810 Glayscok, John, of High Ester, Essex, husbandman, farmer of High Ester Bury 0
3615604 1872521 1872521 defendant Wether Thomas yeoman 650810 650810 Wether, Thomas, of High Ester, Essex, yeoman 0
3663853 1914632 1914632 defendant Gates Geoffrey   650810 650810 Gates, Geoffrey, of High Ester, Essex, knight 0
3679064 1919521 1919521 defendant Gates Geoffrey   650810 650810 Gates, Geoffrey, of High Ester, Essex, knight 0
3679069 1919522 1919522 defendant Gates Geoffrey   650810 650810 Gates, Geoffrey, of High Ester, Essex, knight 0
3702252 1926960 1926960 defendant Gate Geoffrey   650810 650810 Gate, Geoffrey, of High Ester, Essex, knight 0
3702255 1926961 1926961 defendant Gate Geoffrey   650810 650810 Gate, Geoffrey, of High Ester, Essex, knight 0
3715927 1931267 1931267 defendant Gate Geoffrey   650810 650810 Gate, Geoffrey, of High Ester, Essex, knight 0
3913639 1994902 1994902 defendant Watson Thomas mercer 650810 650810 Watson, Thomas, of High Ester, Essex, mercer 0
3914070 1995050 1995050 defendant Wyberd John gent 650810 650810 Wyberd, John, of High Onger, Essex, gent 1
3949505 2006897 2006897 defendant Ellys Giles yeoman 650810 650810 Ellys, Giles, of High Ester, Essex, yeoman 0
3991948 2021880 2021880 defendant Plesaunt Thomas husbandman 650810 650810 Plesaunt, Thomas, of High Ester, Essex, husbandman 1
4004765 2026481 2026481 defendant Pawne William esq 650810 650810 Pawne, William, of High Honger, Essex, esq 1
4045019 2040674 2040674 defendant Peerson Anthony tailor 650810 650810 Peerson, Anthony, of High Easter, Essex, tailor 0
4045023 2040675 2040675 defendant Peerson Anthony tailor 650810 650810 Peerson, Anthony, of High Easter, Essex, tailor 0
4126839 2069890 2069890 defendant Lea alias Shyngleton Thomas husbandman 650810 650810 Lea alias Shyngleton, Thomas, of High Laver, Essex, husbandman 0
4136737 2073487 2073487 defendant Bingham Lawrence gent 650810 650810 Bingham, Lawrence, of High Enger, Essex, gent 0
4140713 2074917 2074917 defendant Bingham Lawrence gent 650810 650810 Bingham, Lawrence, of High Hunger, Essex, gent 0
4158687 2081110 2081110 defendant Byngham Lawrence gent 650810 650810 Byngham, Lawrence, of High Onger, Essex, gent 0
4289369 2126257 2126257 defendant Byngham Lawrence gent 650810 650810 Byngham, Lawrence, of High Onger, Essex, gent 0
4291475 2127025 2127025 defendant Rowe Thomas yeoman 650810 650810 Rowe, Thomas, of High Ester, Essex, yeoman 0
4333683 2141545 2141545 defendant Horne Thomas yeoman 650810 650810 Horne, Thomas, of High Onger, Essex, yeoman 0
4344527 2145365 2145365 defendant Quylter Thomas husbandman 650810 650810 Quylter, Thomas, of High Easter, Essex, husbandman 0
4700194 2265480 2265480 defendant Ledyngton John clerk 650810 650810 Ledyngton, John, of High Anger, Essex, clerk 2
4727271 2273784 2273784 defendant Roberd John husbandman 650810 650810 Roberd, John, of High Easter, Essex, husbandman 2
4727281 2273785 2273785 defendant Roberd John husbandman 650810 650810 Roberd, John, of High Easter, Essex, husbandman 2
4808509 2298829 2298829 defendant Denston John chaplain 650810 650810 Denston, John, of High Laver, Essex, chaplain 3
4851489 2311908 2311908 defendant Wrytell Eleanor widow 650810 650810 Wrytell, Eleanor, of High Laver, Essex, widow 11
4915606 2331381 2331381 defendant Bauge Geoffrey husbandman 650810 650810 Bauge, Geoffrey, of High Easter, Essex, husbandman 1
4932553 2336575 2336575 defendant Priour John esq 650810 650810 Priour, John, of High Laver, Essex, esq 0
4947982 2341355 2341355 defendant Suleard John gent 650810 650810 Suleard, John, of High Laver, Essex, gent 2
5077663 2379815 2379815 defendant Bataill John esq 650810 650810 Bataill, John, of High Onger, Essex, esq 1
5199386 2415570 2415570 defendant Mynston John smith 650810 650810 Mynston, John, of High Laver, Essex, smith 3
5276899 2438326 2438326 defendant Warner John yeoman 650810 650810 Warner, John, of High Ounger, Essex, yeoman 0
5276902 2438327 2438327 defendant Warner John yeoman 650810 650810 Warner, John, of High Ounger, Essex, yeoman 0
5301052 2445270 2445270 defendant Hille Wiiliam shoemaker 650810 650810 Hille, Wiiliam, of High Easter, Essex, shoemaker 0
5315551 2449718 2449718 defendant Warner John parker 650810 650810 Warner, John, of High Onger, Essex, parker 2
5334973 2455528 2455528 defendant Goldhand John husbandman 650810 650810 Goldhand, John, of High Onger, Essex, husbandman 4
5501242 2505326 2505326 defendant Lane Richard husbandman 650810 650810 Lane, Richard, of High Onger, Essex, husbandman 3
5522064 2511716 2511716 defendant Taillour William husbandman 650810 650810 Taillour, William, of High Onger, Essex, husbandman 1

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