names

15 rows where place_id = 607553

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3669779 1916493 1916493 defendant Incys Thomas fisher 607553 607553 Incys, Thomas, of Pomfret, Yorks, fisher 0
3677913 1919142 1919142 defendant Raulenson Richard yeoman 607553 607553 Raulenson, Richard, of Pomfret, Yorks, yeoman 0
3706657 1928367 1928367 defendant (not given) William mayor of Purser 607553 607553 Purser, William, of Pomfret, Yorks, innholder, mayor of Pomfret 0
3722019 1933149 1933149 defendant Chapman Roger merchant 607553 607553 Chapman, Roger, of Pomfret, Yorks, merchant 0
3784644 1952985 1952985 defendant Hudson Robert chapman 607553 607553 Hudson, Robert, of Pomfret, Yorks, chapman 1
3784650 1952986 1952986 defendant Hudson Robert chapman 607553 607553 Hudson, Robert, of Pomfret, Yorks, chapman 1
3785708 1953322 1953322 defendant Wakefeld Peter chapman 607553 607553 Wakefeld, Peter, of Pomfret, Yorks, chapman 0
3785710 1953323 1953323 defendant Wakefeld Peter chapman 607553 607553 Wakefeld, Peter, of Pomfret, Yorks, chapman 0
4075754 2051634 2051634 plaintiff Savage Boniface gent 607553 607553 Savage, Boniface, of Pomfret, Yorks, gent 0
4304581 2131739 2131739 defendant Haselam Edmund chapman 607553 607553 Haselam, Edmund, of Pomfret, Yorks, chapman 1
4352839 2148222 2148222 defendant Nelstrop Alan yeoman 607553 607553 Nelstrop, Alan, of Pomfret, Yorks, yeoman 0
4358096 2150075 2150075 defendant Nelstrop Alan yeoman 607553 607553 Nelstrop, Alan, of Pomfret, Yorks, yeoman 0
4845067 2309973 2309973 defendant Clenyng or Clevyng Thomas skinner 607553 607553 Clenyng or Clevyng, Thomas, of Pomfret, Yorks, skinner 0
4845139 2309993 2309993 defendant Clavyng or Clanyng Thomas skinner 607553 607553 Clavyng or Clanyng, Thomas, of Pomfret, Yorks, skinner 0
4999103 2356608 2356608 defendant Huchynson Roger chapman 607553 607553 Huchynson, Roger, of Pomfret, Yorks, chapman 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);