names

16 rows where place_id = 595379

✎ 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
3620248 1873912 1873912 plaintiff Larstoke Thomas   595379 595379 Larstoke, Thomas, of Ilchester 0
3711712 1929976 1929976 plaintiff Trent William   595379 595379 Trent, William, of Ilchester 0
3735954 1937482 1937482 defendant Smyth John smith 595379 595379 Smyth, John, of Ilchester, smith 1
3770776 1948547 1948547 defendant Jefferey John innholder 595379 595379 Jefferey, John, of Ilchester, innholder 3
3773098 1949288 1949288 defendant Jeffrys John innholder 595379 595379 Jeffrys, John, of Ilchester, innholder 1
3786416 1953538 1953538 defendant Treu or Tren Richard husbandman 595379 595379 Treu or Tren, Richard, of Ilchester, husbandman 3
3861570 1977330 1977330 defendant Clerke Thomas husbandman 595379 595379 Clerke, Thomas, of Ilchester, husbandman 1
4060405 2046121 2046121 defendant Bounge Robert yeoman or husbandman 595379 595379 Bounge, Robert, of Ilchester, yeoman or husbandman 0
4060407 2046122 2046122 defendant Tayler John yeoman 595379 595379 Tayler, John, of Ilchester, yeoman 0
4123417 2068679 2068679 defendant Rood William yeoman 595379 595379 Rood, William, of Ilchester, yeoman 0
4124087 2068912 2068912 defendant Sylvester Giles yeoman 595379 595379 Sylvester, Giles, of Ilchester, yeoman 3
4306083 2132267 2132267 defendant Hartry Nicholas yeoman 595379 595379 Hartry, Nicholas, of Ilchester, yeoman 1
4372137 2155102 2155102 defendant Hodges Richard   595379 595379 Hodges, Richard, of Ilchester, woollen draper 0
4396434 2163383 2163383 defendant Holman John   595379 595379 Holman, John, of Ilchester tailor 0
4400105 2164624 2164624 defendant Harris Thomas   595379 595379 Harris, Thomas, of Ilchester, woollen draper 0
5534612 2515366 2515366 defendant Bysseley William gent 595379 595379 Bysseley, William, of Ilchester, gent 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);