names

35 rows where place_id = 606757

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3666430 1915451 1915451 defendant Bucke Anthony butcher 606757 606757 Bucke, Anthony, of Chellesfeld, butcher 1
4477252 2193552 2193552 defendant Couper John   606757 606757 Couper, John, of Chellesfeld 0
4786571 2291850 2291850 defendant Whasshenersh John, junior carter 606757 606757 Whasshenersh, John, junior, of Chellesfeld, carter 0
4795177 2294638 2294638 defendant Jetur William husbandman 606757 606757 Jetur, William, of Chellesfeld, husbandman 0
4887450 2322914 2322914 defendant Thepon Alan summoner 606757 606757 Thepon, Alan, of Chellesfeld, summoner 0
5022283 2363412 2363412 defendant Typon Alan husbandman 606757 606757 Typon, Alan, of Chellesfeld, husbandman 0
5022284 2363412 2363412 defendant Wodeward Simon husbandman 606757 606757 Wodeward, Simon, of Chellesfeld, husbandman 1
5030171 2365692 2365692 defendant Getour Stephen laborer 606757 606757 Getour, Stephen, of Chellesfeld, laborer 0
5052523 2372347 2372347 defendant Norfolk Thomas laborer 606757 606757 Norfolk, Thomas, of Chellesfeld, laborer 0
5052525 2372347 2372347 defendant Cok William   606757 606757 Cok, William, of Chellesfeld 2
5127618 2394564 2394564 defendant Larke Simon laborer 606757 606757 Larke, Simon, of Chellesfeld, laborer 1
5242564 2428032 2428032 defendant Hasillerssh John laborer 606757 606757 Hasillerssh, John, of Chellesfeld, laborer 0
5242567 2428032 2428032 defendant Hasillerssh Richard laborer 606757 606757 Hasillerssh, Richard, of Chellesfeld, laborer 3
5289700 2441989 2441989 defendant Buk William butcher 606757 606757 Buk, William, of Chellesfeld, butcher 4
5302422 2445691 2445691 defendant Swan Robert husbandman 606757 606757 Swan, Robert, of Chellesfeld, husbandman 1
5317258 2450242 2450242 defendant Swan Robert husbandman 606757 606757 Swan, Robert, of Chellesfeld, husbandman 3
5330545 2454224 2454224 defendant Colgate William laborer 606757 606757 Colgate, William, of Chellesfeld, laborer 2
5341016 2457391 2457391 defendant Colgate William laborer 606757 606757 Colgate, William, of Chellesfeld, laborer 1
5360230 2463240 2463240 defendant Jetour John yeoman 606757 606757 Jetour, John, of Chellesfeld, yeoman 0
5372019 2466841 2466841 defendant Jetour Thomas   606757 606757 Jetour, Thomas, of Chellesfeld, laborer, son of Thomas Jetour, senior 0
5372020 2466841 2466841 defendant Jetour Henry laborer 606757 606757 Jetour, Henry, of Chellesfeld, laborer 1
5375127 2467807 2467807 defendant Wodeward Simon husbandman 606757 606757 Wodeward, Simon, of Chellesfeld, husbandman 0
5429350 2483713 2483713 defendant Wodward John husbandman 606757 606757 Wodward, John, of Chellesfeld, husbandman 0
5446396 2488816 2488816 defendant Edward John husbandman 606757 606757 Edward, John, of Chellesfeld, husbandman 0
5459030 2492595 2492595 defendant Wodward John husbandman 606757 606757 Wodward, John, of Chellesfeld, husbandman 0
5459032 2492596 2492596 defendant Wodward John husbandman 606757 606757 Wodward, John, of Chellesfeld, husbandman 0
5495954 2503684 2503684 defendant Andreweson John tiler 606757 606757 Andreweson, John, of Chellesfeld, tiler 2
5497975 2504340 2504340 defendant Bovauntre or Bonauntre Richard clerk 606757 606757 Bovauntre or Bonauntre, Richard, of Chellesfeld, clerk 0
5497976 2504340 2504340 defendant Belle John laborer 606757 606757 Belle, John, of Chellesfeld, laborer 1
5497977 2504340 2504340 defendant William John laborer 606757 606757 William, John, of Chellesfeld, laborer 2
5552607 2520817 2520817 defendant Petley William yeoman 606757 606757 Petley, William, of Chellesfeld, yeoman 0
5603053 2535839 2535839 defendant Colgate Henry husbandman 606757 606757 Colgate, Henry, of Chellesfeld, husbandman 0
5603054 2535839 2535839 defendant Hese John laborer 606757 606757 Hese, John, of Chellesfeld, laborer 1
5603055 2535839 2535839 defendant Plommer Henry laborer 606757 606757 Plommer, Henry, of Chellesfeld, laborer 2
5606187 2536826 2536826 defendant Colgate Henry husbandman 606757 606757 Colgate, Henry, of Chellesfeld, husbandman 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);