names

25 rows where place_id = 667479

✎ 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
3985272 2019491 2019491 defendant Holmewood John yeoman 667479 667479 Holmewood, John, of Cuckfeld, yeoman 2
3994888 2022924 2022924 plaintiff Cooke John   667479 667479 Cooke, John, of Cuckfeld 0
4084964 2054901 2054901 defendant Culpeper Nicholas gent 667479 667479 Culpeper, Nicholas, of Cuckfeld, or of Clayton, gent 0
4094483 2058367 2058367 defendant Blunden Robert husbandman 667479 667479 Blunden, Robert, of Cuckfeld, husbandman 0
4094484 2058367 2058367 defendant Edsall John husbandman 667479 667479 Edsall, John, of Cuckfeld, husbandman 1
4187603 2091167 2091167 defendant Sampson John yeoman 667479 667479 Sampson, John, of Cuckfeld, yeoman 0
4224749 2104126 2104126 defendant Moodey Thomas chapman 667479 667479 Moodey, Thomas, of Cuckfeld, chapman 0
4227635 2105151 2105151 defendant Moodey Thomas chapman 667479 667479 Moodey, Thomas, of Cuckfeld, chapman 0
4227636 2105151 2105151 defendant Hamson John chapman 667479 667479 Hamson, John, of Cuckfeld, chapman 1
4264964 2117917 2117917 defendant Moodye Thomas chapman 667479 667479 Moodye, Thomas, of Cuckfeld, mercer, chapman 0
4268587 2119091 2119091 defendant Moodey Thomas chapman 667479 667479 Moodey, Thomas, of Cuckfeld, chapman 0
4268588 2119091 2119091 defendant Hamson John chapman 667479 667479 Hamson, John, of Cuckfeld, chapman 1
4287663 2125640 2125640 defendant Ryckward Ralph yeoman 667479 667479 Ryckward, Ralph, of Cuckfeld, yeoman 0
4310790 2133917 2133917 defendant Hushe Richard gent 667479 667479 Hushe, Richard, of Cuckfeld, or of Southover, gent 0
4310791 2133917 2133917 defendant Hushe William gent 667479 667479 Hushe, William, of Cuckfeld, or of Southover, gent 1
4311073 2134023 2134023 defendant Culpeper Richard gent 667479 667479 Culpeper, Richard, of Cuckfeld, gent 0
4312859 2134627 2134627 defendant Sone Thomas fyner 667479 667479 Sone, Thomas, of Cuckfeld, fyner 1
4314440 2135163 2135163 defendant Dumbrell John yeoman 667479 667479 Dumbrell, John, of Cuckfeld, yeoman 0
4315622 2135575 2135575 defendant Ryckward Ralph yeoman 667479 667479 Ryckward, Ralph, of Cuckfeld, yeoman 0
4322744 2138023 2138023 defendant Mychell John   667479 667479 Mychell, John, of Cuckfeld, gent, his son 1
4324647 2138635 2138635 defendant Hushe Richard gent 667479 667479 Hushe, Richard, of Cuckfeld, or of Southover, gent 0
4360699 2150996 2150996 defendant Couchman Edward gent 667479 667479 Couchman, Edward, of Cuckfeld, or of Linfeild, Sussex, gent 0
4369652 2154200 2154200 defendant Parson John innholder 667479 667479 Parson, John, of Cuckfeld, innholder 0
4370386 2154460 2154460 defendant Evans Nicholas butcher 667479 667479 Evans, Nicholas, of Cuckfeld, butcher 2
4392410 2162087 2162087 defendant Hills Robert yeoman 667479 667479 Hills, Robert, of Cuckfeld, yeoman 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);