names

29 rows where place_id = 593555

✎ 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
3612338 1871492 1871492 defendant Lambe Robert laborer 593555 593555 Lambe, Robert, of Chatham, laborer 0
3612339 1871492 1871492 defendant Everard William husbandman 593555 593555 Everard, William, of Chatham, husbandman 1
3655248 1911898 1911898 defendant Droles Yedon laborer 593555 593555 Droles, Yedon, of Chatham, laborer 4
4402460 2165409 2165409 defendant Calles or Callys John yeoman 593555 593555 Calles or Callys, John, of Chatham, yeoman 1
4585188 2226790 2226790 plaintiff Wodyer William   593555 593555 Wodyer, William, of Chatham, diocese of Rochester 1
4585933 2227025 2227025 defendant Belle Simon   593555 593555 Belle, Simon, of Chatham 1
4598704 2230832 2230832 defendant Clere John   593555 593555 Clere, John, of Chatham, vicar 4
4770507 2286752 2286752 defendant Warner Thomas butcher 593555 593555 Warner, Thomas, of Chatham, butcher 0
4773543 2287695 2287695 defendant Wodyere Ellis husbandman 593555 593555 Wodyere, Ellis, of Chatham, husbandman 2
4876621 2319656 2319656 defendant Lorkyn Richard husbandman 593555 593555 Lorkyn, Richard, of Chatham, husbandman 0
4903955 2327855 2327855 defendant Lorkyn Richard husbandman 593555 593555 Lorkyn, Richard, of Chatham, husbandman 0
5061446 2375013 2375013 defendant Pery Thomas husbandman 593555 593555 Pery, Thomas, of Chatham, husbandman 0
5094262 2384727 2384727 defendant Hauke or Hauke Thomas husbandman 593555 593555 Hauke or Hauke, Thomas, of Chatham, husbandman 0
5158754 2403681 2403681 defendant Haylyng John husbandman 593555 593555 Haylyng, John, of Chatham, husbandman 0
5162338 2404710 2404710 defendant Wodyer Robert yeoman 593555 593555 Wodyer, Robert, of Chatham, yeoman 0
5174180 2408147 2408147 defendant Haylyng John husbandman 593555 593555 Haylyng, John, of Chatham, husbandman 0
5176436 2408793 2408793 defendant Wodyer Robert yeoman 593555 593555 Wodyer, Robert, of Chatham, yeoman 0
5198491 2415312 2415312 defendant Wodyer Robert yeoman 593555 593555 Wodyer, Robert, of Chatham, yeoman 0
5198497 2415313 2415313 defendant Wodyer Robert yeoman 593555 593555 Wodyer, Robert, of Chatham, yeoman 0
5297748 2444347 2444347 defendant Pyrry William yeoman 593555 593555 Pyrry, William, of Chatham, yeoman 0
5336699 2456045 2456045 defendant Maghfeld John   593555 593555 Maghfeld, John, of Chatham, clerk, churchwarden of Chatham 0
5336706 2456047 2456047 defendant Maghfeld John   593555 593555 Maghfeld, John, of Chatham, clerk, churchwarden 0
5336707 2456047 2456047 defendant Webbe Robert husbandman 593555 593555 Webbe, Robert, of Chatham, husbandman 1
5353625 2461205 2461205 defendant Pury Thomas husbandman 593555 593555 Pury, Thomas, of Chatham, husbandman 0
5353626 2461205 2461205 defendant Pury Robert husbandman 593555 593555 Pury, Robert, of Chatham, husbandman 1
5448287 2489381 2489381 defendant Cachelove John husbandman 593555 593555 Cachelove, John, of Chatham, husbandman 0
5460749 2493161 2493161 plaintiff Longe Robert   593555 593555 Longe, Robert, of Chatham 2
5507387 2507203 2507203 defendant Pulcher William husbandman 593555 593555 Pulcher, William, of Chatham, husbandman 3
5530293 2513984 2513984 defendant Cardon John gent 593555 593555 Cardon, John, of Chatham, gent 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);