names

31 rows where place_id = 610212

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3682469 1920618 1920618 defendant Joleyn John chaplain 610212 610212 Joleyn, John, of Estnor, chaplain 0
3882533 1984424 1984424 defendant Carre Thomas husbandman 610212 610212 Carre, Thomas, of Estnor, husbandman 3
3950644 2007299 2007299 defendant Gillam or Aguilam Nicholas husbandman 610212 610212 Gillam or Aguilam, Nicholas, of Estnor, husbandman 0
3950645 2007299 2007299 defendant Gillam or John Nicholas husbandman 610212 610212 Gillam or John, Nicholas, of Estnor, husbandman 1
3998006 2024046 2024046 defendant Bache Robert husbandman 610212 610212 Bache, Robert, of Estnor, husbandman 0
3998007 2024046 2024046 defendant Bache William husbandman 610212 610212 Bache, William, of Estnor, husbandman 1
3998008 2024046 2024046 defendant Harford Richard collier 610212 610212 Harford, Richard, of Estnor, collier 2
4031070 2035784 2035784 defendant Bache William yeoman 610212 610212 Bache, William, of Estnor, yeoman 0
4031071 2035784 2035784 defendant Webley William yeoman 610212 610212 Webley, William, of Estnor, yeoman 1
4031072 2035784 2035784 defendant Bcahe Robert yeoman 610212 610212 Bcahe, Robert, of Estnor, yeoman 2
4041655 2039508 2039508 defendant Bache William husbandman 610212 610212 Bache, William, of Estnor, husbandman 1
4051496 2042953 2042953 plaintiff Willis Thomas   610212 610212 Willis, Thomas, of Estnor, yeoman, attorney of the bench 0
4051498 2042954 2042954 plaintiff Willis Thomas   610212 610212 Willis, Thomas, of Estnor, yeoman, attorney of the bench 0
4051501 2042955 2042955 plaintiff Willis Thomas   610212 610212 Willis, Thomas, of Estnor, yeoman, attorney of the bench 0
4052235 2043222 2043222 defendant Grene Lewis husbandman 610212 610212 Grene, Lewis, of Estnor, husbandman 1
4052635 2043367 2043367 defendant Bache William yeoman 610212 610212 Bache, William, of Estnor, yeoman 0
4052636 2043367 2043367 defendant Webley William yeoman 610212 610212 Webley, William, of Estnor, yeoman 1
4052637 2043367 2043367 defendant Bache Robert yeoman 610212 610212 Bache, Robert, of Estnor, yeoman 2
4061915 2046659 2046659 defendant Baylye Richard, junior carpenter 610212 610212 (Baylye, Richard, junior, of Estnor, carpenter 1
4078858 2052735 2052735 defendant Holder John husbandman 610212 610212 Holder, John, of Estnor, husbandman 0
4078859 2052735 2052735 defendant Careles Thomas husbandman 610212 610212 Careles, Thomas, of Estnor, husbandman 1
4078860 2052735 2052735 defendant Careles Richard husbandman 610212 610212 Careles, Richard, of Estnor, husbandman 2
4080860 2053465 2053465 defendant Baylye Richard, junior husbandman 610212 610212 Baylye, Richard, junior, of Estnor, husbandman 0
4080861 2053465 2053465 defendant Holder William husbandman 610212 610212 Holder, William, of Estnor, husbandman 1
4147445 2077247 2077247 defendant Scudamore John gent 610212 610212 Scudamore, John, of Estnor or Yesner, gent 1
4147446 2077247 2077247 defendant Pytt George husbandman 610212 610212 Pytt, George, of Estnor, husbandman 2
4235581 2108013 2108013 defendant Lye Giles yeoman 610212 610212 Lye, Giles, of Estnor, yeoman 0
4292557 2127399 2127399 defendant Turnor Francis husbandman 610212 610212 Turnor, Francis, of Estnor, husbandman 2
4314788 2135284 2135284 defendant Baldwyn William yeoman 610212 610212 Baldwyn, William, of Estnor, yeoman 1
4397794 2163838 2163838 defendant Stevens Richard esq 610212 610212 Stevens, Richard, of Estnor, esq 0
4397796 2163839 2163839 defendant Stevens Richard esq 610212 610212 Stevens, Richard, of Estnor, 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);