names

14 rows where case_id = 2373239

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5055545 2373239 2373239 plaintiff Bruyn Richard     Bruyn, Richard 0
5055546 2373239 2373239 plaintiff Smyth John     Smyth, John 1
5055547 2373239 2373239 defendant Alton William gent 791188 791188 Alton, William, of Hoo St Mary, gent 0
5055548 2373239 2373239 defendant Alton John clerk 791188 791188 Alton, John, of Hoo St Mary, clerk 1
5055549 2373239 2373239 defendant Banyster Thomas yeoman 841009 841009 Banyster, Thomas, of Hoo St Wereburg, yeoman 2
5055550 2373239 2373239 defendant Spycer Henry laborer 791188 791188 Spycer, Henry, of Hoo St Mary, laborer 3
5055551 2373239 2373239 defendant Fraunceys Thomas laborer 791188 791188 Fraunceys, Thomas, of Hoo St Mary, laborer 4
5055552 2373239 2373239 defendant Rolfe or Rolse Stephen   841009 841009 Rolfe or Rolse, Stephen, of Hoo St Wereburg, servant 5
5055553 2373239 2373239 defendant Raffe John clerk 791188 791188 Raffe, John, of Hoo St Mary, clerk 6
5055554 2373239 2373239 defendant Banyster William yeoman 841009 841009 Banyster, William, of Hoo St Wereburg, yeoman 7
5055555 2373239 2373239 defendant Godyer John fermer 769843 769843 Godyer, John, of Hoo All Saints, fermer 8
5055556 2373239 2373239 defendant Alton Adam laborer 791188 791188 Alton, Adam, of Hoo St Mary, laborer 9
5055557 2373239 2373239 defendant Wayte Stephen laborer 791188 791188 Wayte, Stephen, of Hoo St Mary, laborer 10
5055558 2373239 2373239 defendant Wayte John laborer 791188 791188 Wayte, John, of Hoo St Mary, laborer 11

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);