names

11 rows where case_id = 2488358

✎ 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
5444889 2488358 2488358 plaintiff Denne William     Denne, William, on his own account 0
5444890 2488358 2488358 defendant Holley Andrew clerk 590966 590966 Holley, Andrew, of Byntre, clerk 0
5444891 2488358 2488358 defendant Southed Thomas baker 586940 586940 Southed, Thomas, of Baldeswell, baker 1
5444892 2488358 2488358 defendant Baly John brasier 585936 585936 Baly, John, of Norwich, brasier 2
5444893 2488358 2488358 defendant Mundes Thomas Brandon by Barnham Brome, husbandman   Mundes, Thomas, Brandon by Barnham Brome, husbandman 3
5444894 2488358 2488358 defendant Recok or Pecok John, sen husbandman 586471 586471 Recok or Pecok, John, sen, of Aylesham, husbandman 4
5444895 2488358 2488358 defendant Colles Bartholomew chapman 603983 603983 Colles, Bartholomew, of Little Walsyngham, chapman 5
5444896 2488358 2488358 defendant Swevyn Nicholas shoemaker 586471 586471 Swevyn, Nicholas, of Aylesham, smith, Wylde, William, of Aylesham, shoemaker 6
5444897 2488358 2488358 defendant Blaksale Robert husbandman 831274 831274 Blaksale, Robert, of Hakford by Hengham, husbandman 7
5444898 2488358 2488358 defendant Celers Thomas husbandman 590844 590844 Celers, Thomas, of Lyng, husbandman 8
5444899 2488358 2488358 defendant Partryk William innholder 586528 586528 Partryk, William, of Ware, Herts, innholder 9

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