names

30 rows where place_id = 620242

✎ 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
3734634 1937078 1937078 defendant Brounejohn Richard husbandman 620242 620242 Brounejohn, Richard, of Wynterborne, husbandman 1
3780631 1951670 1951670 defendant Tayler John husbandman 620242 620242 Tayler, John, of Wynterborne, husbandman 2
3793404 1955801 1955801 defendant Haynes Richard husbandman 620242 620242 Haynes, Richard, of Wynterborne, husbandman 0
3793412 1955804 1955804 defendant Boyer William husbandman 620242 620242 Boyer, William, of Wynterborne, husbandman 0
3793413 1955804 1955804 defendant Tyler William husbandman 620242 620242 Tyler, William, of Wynterborne, husbandman 1
3809627 1960897 1960897 defendant Surman John husbandman 620242 620242 Surman, John, of Wynterborne, husbandman 0
3875663 1982105 1982105 defendant Kenys Henry gent 620242 620242 Kenys, Henry, of Wynterborne, gent 0
3886054 1985587 1985587 defendant Bettys Henry yeoman 620242 620242 Bettys, Henry, of Wynterborne, yeoman 0
3908451 1993122 1993122 defendant Compton John clerk 620242 620242 Compton, John, of Wynterborne, clerk 0
3969449 2013921 2013921 defendant Noceter Mathew husbandman 620242 620242 Noceter, Mathew, of Wynterborne Abbot, husbandman 0
3993183 2022307 2022307 defendant Carrant Leonard esq 620242 620242 Carrant, Leonard, of Wynterborne, esq 0
4145570 2076606 2076606 defendant Ellyott John yeoman 620242 620242 Ellyott, John, of Wynterborne, yeoman 0
4151528 2078656 2078656 defendant Cooke Nicholas yeoman 620242 620242 Cooke, Nicholas, of Wynterborne, yeoman 2
4212538 2099926 2099926 defendant Welsted William clothier 620242 620242 Welsted, William, of Wynterborne Mynster, clothier 0
4285720 2124944 2124944 defendant Styckland Roger, senior husbandman 620242 620242 Styckland, Roger, senior, of Wynterborne, husbandman 0
4304691 2131773 2131773 defendant Frye Thomas husbandman 620242 620242 Frye, Thomas, of Wynterborne, husbandman 0
4308075 2132969 2132969 defendant Ham or Hain Benjamin clerk 620242 620242 Ham or Hain, Benjamin, of Wynterborne, clerk 1
4362677 2151710 2151710 defendant Ham Benjamin clerk 620242 620242 Ham, Benjamin, of Wynterborne, clerk 3
4364852 2152481 2152481 defendant Hame or Haine Benjamin clerk 620242 620242 Hame or Haine, Benjamin, of Wynterborne, clerk 2
4384800 2159604 2159604 defendant Daunter John yeoman 620242 620242 Daunter, John, of Wynterborne, yeoman 1
4401226 2165005 2165005 defendant Stephens alias Marshall John yeoman 620242 620242 Stephens alias Marshall, John, of Wynterborne, yeoman 2
4562680 2219885 2219885 defendant Boteler John   620242 620242 Boteler, John, of Wynterborne, parson 0
4563473 2220146 2220146 defendant Shyne John   620242 620242 Shyne, John, of Wynterborne 0
4907828 2329010 2329010 defendant Slaunt Henry husbandman 620242 620242 Slaunt, Henry, of Wynterborne, husbandman 2
5086083 2382322 2382322 defendant Panter Alexander yeoman 620242 620242 Panter, Alexander, of Wynterborne, yeoman 0
5124996 2393786 2393786 defendant Howechyn John chaplain 620242 620242 Howechyn, John, of Wynterborne Abbot, chaplain 0
5147217 2400327 2400327 defendant Howechyn John chaplain 620242 620242 Howechyn, John, of Wynterborne Abbot, chaplain 0
5355940 2461938 2461938 defendant Bradstone Thomas esq 620242 620242 Bradstone, Thomas, of Wynterborne, esq 0
5474073 2497223 2497223 plaintiff Bradeston Thomas esq 620242 620242 Bradeston, Thomas, of Wynterborne, esq 1
5502512 2505704 2505704 defendant Dobbys Walter husbandman 620242 620242 Dobbys, Walter, of Wynterborne, husbandman 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);