names

18 rows where place_id = 588229

✎ 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
3593795 1865697 1865697 defendant Latymer Henry gent 588229 588229 Latymer, Henry, of Stalbrigge, gent 0
4546632 2214872 2214872 defendant Gylle Thomas   588229 588229 Gylle, Thomas, of Stalbrigge 0
4546633 2214872 2214872 defendant Baker Robert   588229 588229 Baker, Robert, of Stalbrigge 1
4589870 2228195 2228195 defendant Childe John   588229 588229 Childe, John, of Stalbrigge 0
4763547 2284582 2284582 defendant Gaunt John husbandman 588229 588229 Gaunt, John, of Stalbrigge, husbandman 0
4783273 2290787 2290787 defendant Snoke John husbandman 588229 588229 Snoke, John, of Stalbrigge, husbandman 0
4849726 2311388 2311388 defendant Leeke John husbandman 588229 588229 Leeke, John, of Stalbrigge, husbandman 3
4860224 2314558 2314558 defendant atte Freth William husbandman 588229 588229 together with atte Freth, William, of Stalbrigge, husbandman 1
4869294 2317363 2317363 defendant Locke Robert husbandman 588229 588229 Locke, Robert, of Stalbrigge, husbandman 0
4889249 2323423 2323423 defendant Honwes or Houwes John husbandman 588229 588229 Honwes or Houwes, John, of Stalbrigge, husbandman 0
5299769 2444902 2444902 defendant Davy John yeoman 588229 588229 Davy, John, of Stalbrigge, yeoman 0
5340421 2457207 2457207 defendant Sellar Walter   588229 588229 Sellar, Walter, of Stalbrigge, pedlar 0
5348797 2459750 2459750 defendant Seler Walter   588229 588229 Seler, Walter, of Stalbrigge, pedlar 1
5360593 2463344 2463344 defendant Seller Walter   588229 588229 Seller, Walter, of Stalbrigge, pedlar 2
5423589 2482019 2482019 defendant Selar Walter chapman 588229 588229 Selar, Walter, of Stalbrigge, chapman 1
5455593 2491580 2491580 defendant Selar Walter chapman 588229 588229 Selar, Walter, of Stalbrigge, chapman 1
5492947 2502798 2502798 defendant Coke John gent 588229 588229 Coke, John, of Stalbrigge, gent 1
5620680 2550335 2550335 plaintiff Dodewich Robert   588229 588229 Dodewich, Robert, of Stalbrigge, parson 2

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