names

16 rows where case_id = 2382039

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5085052 2382039 2382039 plaintiff Gore William   588518 588518 Gore, William, of Aldryngton 0
5085053 2382039 2382039 defendant Baron William husbandman 595378 595378 Baron, William, of Potterne, husbandman 0
5085054 2382039 2382039 defendant Hert John laborer 602405 602405 Hert, John, of South Brome, laborer 1
5085055 2382039 2382039 defendant Dorchestre John roper 602405 602405 Dorchestre, John, of South Brome, roper 2
5085056 2382039 2382039 defendant Purye John husbandman 595378 595378 Purye, John, of Potterne, husbandman 3
5085057 2382039 2382039 defendant Lylbrone John yeoman 595378 595378 Lylbrone, John, of Potterne, yeoman 4
5085058 2382039 2382039 defendant Ryse John husbandman 595378 595378 Ryse, John, of Potterne, husbandman 5
5085059 2382039 2382039 defendant Meryet John husbandman 844596 844596 Meryet, John, of Wyke, Bishops Canynges, husbandman 6
5085060 2382039 2382039 defendant Amys John butcher 595378 595378 Amys, John, of Potterne, butcher 7
5085061 2382039 2382039 defendant Barbour William butcher 595378 595378 Barbour, William, of Potterne, butcher 8
5085062 2382039 2382039 defendant Bony or Bovy John husbandman 595378 595378 Bony or Bovy, John, of Potterne, husbandman 9
5085063 2382039 2382039 defendant Colyns Thomas, junior husbandman 595378 595378 Colyns, Thomas, junior, of Potterne, husbandman 10
5085064 2382039 2382039 defendant Smyth Robert husbandman 595378 595378 Smyth, Robert, of Potterne, husbandman 11
5085065 2382039 2382039 defendant Grevell Thomas butcher 595378 595378 Grevell, Thomas, of Potterne, butcher 12
5085066 2382039 2382039 defendant Berde Thomas   844597 844597 Berde, Thomas, of Potterne, husbandmn 13
5085067 2382039 2382039 defendant Swayn Robert laborer 595378 595378 Swayn, Robert, of Potterne, laborer 14

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