names

18 rows where place_id = 657537

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3944714 2005251 2005251 defendant Cokeram Henry gent 657537 657537 Cokeram, Henry, of Sevenock, gent 0
3945722 2005578 2005578 defendant Feld William cordwainer 657537 657537 Feld, William, of Sevenock, cordwainer 0
3980299 2017721 2017721 defendant Latyn Cedda painter 657537 657537 Latyn, Cedda, of Sevenock, painter 0
4121960 2068154 2068154 defendant Burges William clothier 657537 657537 Burges, William, of Sevenock, clothier 1
4121966 2068156 2068156 defendant Masters John yeoman 657537 657537 Masters, John, of Sevenock, yeoman 0
4121967 2068156 2068156 defendant German Henry cooper 657537 657537 German, Henry, of Sevenock, cooper 1
4189702 2091896 2091896 defendant Misshawe alias Blande John founder 657537 657537 Misshawe alias Blande, John, of Sevenock, founder 0
4228019 2105276 2105276 defendant Hollyngdale alias Moodye Richard innholder 657537 657537 Hollyngdale alias Moodye, Richard, of Sevenock, innholder 0
4233072 2107075 2107075 defendant Lambe John yeoman 657537 657537 Lambe, John, of Sevenock, yeoman 0
4316146 2135759 2135759 defendant Venables George chapman 657537 657537 Venables, George, of Sevenock, chapman 0
4363005 2151832 2151832 defendant Haynes John miller 657537 657537 Haynes, John, of Sevenock, miller 0
4368924 2153944 2153944 defendant Bloome alias Coomes John mercer 657537 657537 Bloome alias Coomes, John, of Sevenock, mercer 1
4376740 2156749 2156749 defendant Deane Mathew butcher 657537 657537 Deane, Mathew, of Sevenock, butcher 0
4382235 2158755 2158755 defendant Pocock William butcher 657537 657537 Pocock, William, of Sevenock, butcher 0
4384680 2159562 2159562 defendant Lested or Lusted Edward yeoman 657537 657537 Lested or Lusted, Edward, of Sevenock, yeoman 1
4397366 2163697 2163697 defendant Terry Enticius mercer 657537 657537 Terry, Enticius, of Sevenock, mercer 1
4400848 2164875 2164875 defendant Thompson Michael tailor 657537 657537 Thompson, Michael, of Sevenock, tailor 1
4402477 2165413 2165413 defendant Lamperd Edmund yeoman 657537 657537 Lamperd, Edmund, of Sevenock, 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);