names

17 rows where place_id = 606378

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3664760 1914926 1914926 defendant Holmeden John (legal representative) 606378 606378 Holmeden, John, of Edenbridge, executors of 0
3664985 1914992 1914992 defendant Bowre John tailor 606378 606378 Bowre, John, of Edenbridge, tailor 1
4643258 2244136 2244136 defendant Gambon Roger   606378 606378 Gambon, Roger, of Edenbridge 3
4692418 2263146 2263146 defendant Hasshecombe Walter baker 606378 606378 Hasshecombe, Walter, of Edenbridge, baker 0
4697369 2264662 2264662 defendant Monsherst Mathew husbandman 606378 606378 Monsherst, Mathew, of Edenbridge, husbandman 0
4709154 2268229 2268229 defendant Oghtred John yeoman 606378 606378 Oghtred, John, of Edenbridge, yeoman 0
4715632 2270218 2270218 plaintiff Warner John   606378 606378 Warner, John, of Edenbridge 0
4769097 2286316 2286316 defendant Smyth John laborer 606378 606378 Smyth, John, of Edenbridge, laborer 3
4769098 2286316 2286316 defendant Coupere John husbandman 606378 606378 Coupere, John, of Edenbridge, husbandman 4
4773904 2287817 2287817 defendant Medewey Richard dyer 606378 606378 Medewey, Richard, of Edenbridge, dyer 0
4842214 2309100 2309100 defendant Rote Margaret widow 606378 606378 Rote, Margaret, of Edenbridge, widow 0
5151028 2401440 2401440 defendant Wyvyton Roger tailor 606378 606378 Wyvyton, Roger, of Edenbridge, tailor 2
5160789 2404252 2404252 plaintiff Spycer Richard   606378 606378 Spycer, Richard, of Edenbridge 0
5169319 2406761 2406761 defendant Wynyton Roger tailor 606378 606378 Wynyton, Roger, of Edenbridge, tailor 2
5187669 2412110 2412110 plaintiff Hendeman William husbandman 606378 606378 Hendeman, William, of Edenbridge, husbandman 0
5298158 2444477 2444477 defendant Gylys Richard baker 606378 606378 Gylys, Richard, of Edenbridge, baker 1
5453511 2490943 2490943 defendant (illegible) Henry dyer 606378 606378 _, Henry, of Edenbridge, dyer 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);