names

15 rows where case_id = 2389623

✎ 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
5111045 2389623 2389623 plaintiff Hawe John     Hawe, John 0
5111046 2389623 2389623 defendant Baly John husbandman 586365 586365 Baly, John, of Wymondham, husbandman 0
5111047 2389623 2389623 defendant Plomer Beatrice widow 614359 614359 Plomer, Beatrice, of Honeton St Peter, widow 1
5111048 2389623 2389623 defendant Fauconer Bartholomew   585936 585936 Fauconer, Bartholomew, of Norwich, bed weaver 2
5111049 2389623 2389623 defendant Norton Richard husbandman 617790 617790 Norton, Richard, of Brakenasshe, husbandman 3
5111050 2389623 2389623 defendant Cartwrite Nicholas husbandman 587913 587913 Cartwrite, Nicholas, of Pulham, husbandman 4
5111051 2389623 2389623 defendant Ker Robert laborer 586365 586365 Ker, Robert, of Wymondham, laborer 5
5111052 2389623 2389623 defendant Lotte John hosier 586365 586365 Lotte, John, of Wymondham, hosier 6
5111053 2389623 2389623 defendant Many John brasier 585936 585936 Many, John, of Norwich, brasier 7
5111054 2389623 2389623 defendant Fauconer Thomas skinner 585936 585936 Fauconer, Thomas, of Norwich, skinner 8
5111055 2389623 2389623 defendant Lyne or Lyve Richard carpenter 586102 586102 Lyne or Lyve, Richard, of Hengham, carpenter 9
5111056 2389623 2389623 defendant Palmer Walter husbandman 596822 596822 Palmer, Walter, of Walsoken, husbandman 10
5111057 2389623 2389623 defendant Fraunceys Simon butcher 593852 593852 Fraunceys, Simon, of Wysbech, Cams, butcher 11
5111058 2389623 2389623 defendant Flete John husbandman 594764 594764 Flete, John, of Walsokyn, husbandman 12
5111059 2389623 2389623 defendant Roray John husbandman 595396 595396 Roray, John, of Emneth, husbandman 13

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