names

12 rows where case_id = 2170435

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4417765 2170435 2170435 plaintiff Stonleye Richard de     Stonleye, Richard de 0
4417766 2170435 2170435 defendant Balaunce Thomas   754071 754071 Balaunce, Thomas, of Asshorn 0
4417767 2170435 2170435 defendant Porter Robert le   587058 587058 Porter, Robert le, of Sutton 1
4417768 2170435 2170435 defendant Whytyngton John de son of Nicholas   Whytyngton, John de, son of Nicholas 2
4417769 2170435 2170435 defendant Warde John le   754072 754072 Warde, John le, of Wytyngton 3
4417770 2170435 2170435 defendant Ince Henry   754073 754073 Ince, Henry, of Austelowe 4
4417771 2170435 2170435 defendant Boteler John le   754073 754073 Boteler, John le, of Austelowe 5
4417772 2170435 2170435 defendant Barre John le   754074 754074 Barre, John le, of Scokkyfors 6
4417773 2170435 2170435 defendant Gore Walter of Athereston     Gore, Walter of Athereston 7
4417774 2170435 2170435 defendant Ster William   754075 754075 Ster, William, of Birchyeleye 8
4417775 2170435 2170435 defendant Scot John   754076 754076 Scot, John, of Austeldye 9
4417776 2170435 2170435 defendant Smith Henry le   763189 763189 Smith, Henry le, of Mancestre or Mancetter 10

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