names

6 rows where case_id = 2324178

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4891800 2324178 2324178 plaintiff Colyn William     Colyn, William 0
4891801 2324178 2324178 defendant Kynot John laborer 586851 586851 Kynot, John, of Adyngton, laborer 0
4891802 2324178 2324178 defendant Bonewell Walter fletcher 586447 586447 Bonewell, Walter, of West Mallyng, fletcher 1
4891803 2324178 2324178 defendant Couper Nicholas cooper 589186 589186 Couper, Nicholas, of Halstede, cooper 2
4891804 2324178 2324178 defendant Kennane or Kennave John glover 589033 589033 Kennane or Kennave, John, of Tunbrigge, glover 3
4891805 2324178 2324178 defendant Pette Nicholas laborer 588508 588508 Pette, Nicholas, of Maideston, laborer 4

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