names

15 rows where place_id = 646195

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3889577 1986747 1986747 defendant Jenyn Thomas cordwainer 646195 646195 Jenyn, Thomas, of Erdysley, cordwainer 0
3889578 1986747 1986747 defendant Tryll John laborer 646195 646195 Tryll, John, of Erdysley, laborer 1
3897077 1989242 1989242 defendant Est Margaret widow 646195 646195 Est, Margaret, of Erdysley, widow 2
3897104 1989250 1989250 defendant Dedebrough Walter husbandman 646195 646195 Dedebrough, Walter, of Erdysley, husbandman 1
3899146 1989921 1989921 defendant Hues James husbandman 646195 646195 Hues, James, of Erdysley, husbandman 1
3911513 1994168 1994168 defendant Jakett John yeoman 646195 646195 Jakett, John, of Erdysley, yeoman 0
3932843 2001276 2001276 defendant Ceane Richard yeoman 646195 646195 Ceane, Richard, of Erdysley, yeoman 37
3965118 2012407 2012407 defendant Hold or Houll William yeoman 646195 646195 Hold or Houll, William, of Erdysley, yeoman 1
3972343 2014897 2014897 defendant ap Jevan David waver 646195 646195 ap Jevan, David, of Erdysley, waver 0
4065958 2048116 2048116 defendant Cooke William yeoman 646195 646195 Cooke, William, of Erdysley, yeoman 1
4065959 2048116 2048116 defendant Ries John yeoman 646195 646195 Ries, John, of Erdysley, yeoman 2
4083216 2054285 2054285 defendant Shepperd John yeoman 646195 646195 Shepperd, John, of Erdysley, yeoman 0
4113254 2065007 2065007 defendant Stevens Thomas weaver 646195 646195 Stevens, Thomas, of Erdysley, weaver 1
4128273 2070397 2070397 defendant Baskervile Humphrey esq 646195 646195 Baskervile, Humphrey, of Erdysley, esq, son of John Basbervile, of Erdysley, esq 0
4183139 2089584 2089584 defendant Harper James yeoman 646195 646195 Harper, James, of Erdysley, 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);