names

25 rows where place_id = 599796

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3638321 1906802 1906802 defendant Clerke Robert husbandman 599796 599796 Clerke, Robert, of Elme, Cams, husbandman 1
3784286 1952875 1952875 defendant Payne John, senior yeoman 599796 599796 Payne, John, senior, of Elme, Cams, yeoman 0
3799095 1957627 1957627 defendant Balam John gent 599796 599796 Balam, John, of Elme, Cams, gent 0
3877601 1982747 1982747 defendant Balam John gent 599796 599796 Balam, John, of Elme, Cams, gent 0
3894113 1988247 1988247 defendant Balam John gent 599796 599796 Balam, John, of Elme, Cams, gent 0
3894129 1988253 1988253 defendant Balam John gent 599796 599796 Balam, John, of Elme, Cams, gent 0
4001258 2025230 2025230 defendant Bryce Thomas husbandman 599796 599796 Bryce, Thomas, of Elme, Cams, husbandman 0
4001263 2025231 2025231 defendant Bryce Thomas husbandman 599796 599796 Bryce, Thomas, of Elme, Cams, husbandman 0
4044652 2040535 2040535 defendant Balam Alexander gent 599796 599796 Balam, Alexander, of Elme, Cams, gent 0
4196118 2094190 2094190 defendant Payne William yeoman 599796 599796 Payne, William, of Elme, Cams, yeoman 0
4311747 2134248 2134248 defendant Balam Alexander esq 599796 599796 Balam, Alexander, of Elme, Cams, esq 2
4963292 2345930 2345930 defendant Reynold Thomas clerk 599796 599796 Reynold, Thomas, of Elme, Cams, clerk 2
4969836 2347925 2347925 defendant Campes John laborer 599796 599796 Campes, John, of Elme, Cams, laborer 0
4969838 2347926 2347926 defendant Say Peter weaver 599796 599796 Say, Peter, of Elme, Cams, weaver 0
4977616 2350271 2350271 defendant Mouse William laborer 599796 599796 Mouse, William, of Elme, Cams, laborer 2
5072568 2378282 2378282 defendant Leper John husbandman 599796 599796 Leper, John, of Elme, Cams, husbandman 0
5106134 2388231 2388231 defendant Bonyng or Bovyng Richard butcher 599796 599796 Bonyng or Bovyng, Richard, of Elme, Cams, butcher 1
5218408 2421115 2421115 defendant Medilton Richard husbandman 599796 599796 Medilton, Richard, of Elme, Cams, husbandman 0
5237905 2426670 2426670 defendant Medilton Richard husbandman 599796 599796 Medilton, Richard, of Elme, Cams, husbandman 0
5237907 2426671 2426671 defendant Hervy John hubandman 599796 599796 Hervy, John, of Elme, Cams, hubandman 0
5247434 2429404 2429404 defendant Freman John carpenter 599796 599796 Freman, John, of Elme, Cams, carpenter 0
5325496 2452707 2452707 defendant Rorey Edmund chaplain 599796 599796 Rorey, Edmund, of Elme, Cams, chaplain 0
5325499 2452708 2452708 defendant Rorey Edmund chaplain 599796 599796 Rorey, Edmund, of Elme, Cams, chaplain 0
5569694 2525706 2525706 defendant Ketyll Joan widow 599796 599796 Ketyll, Joan, of Elme, Cams, widow 0
5603563 2535990 2535990 defendant Goolde John husbandman 599796 599796 Goolde, John, of Elme, Cams, 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);