names

22 rows where case_id = 2200513

✎ 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
4499568 2200513 2200513 plaintiff Haym John forester 589301 589301 Haym, John, of Gillyngham, forester 0
4499569 2200513 2200513 defendant Leget John   589301 589301 Leget, John, of Gillyngham 0
4499570 2200513 2200513 defendant Lo--- Adam chaplain   Lo---, Adam, chaplain 1
4499571 2200513 2200513 defendant Hooper John   589301 589301 Hooper, John, of Gillyngham 2
4499572 2200513 2200513 defendant Lotte Adam     Lotte, Adam 3
4499573 2200513 2200513 defendant Hullecote John   589301 589301 Hullecote, John, of Gillyngham 4
4499574 2200513 2200513 defendant Taillour Walter   589301 589301 Taillour, Walter, of Gillyngham 5
4499575 2200513 2200513 defendant Coyt Walter   589301 589301 Coyt, Walter, of Gillyngham 6
4499576 2200513 2200513 defendant Molyns Henry     Molyns, Henry 7
4499577 2200513 2200513 defendant Wollew John     Wollew, John 8
4499578 2200513 2200513 defendant Lortevourne John   589301 589301 Lortevourne, John, of Gillyngham 9
4499579 2200513 2200513 defendant Touneshend Robert butcher   Touneshend, Robert, butcher 10
4499580 2200513 2200513 defendant Kent John     Kent, John 11
4499581 2200513 2200513 defendant Page Roger     Page, Roger 12
4499582 2200513 2200513 defendant Wylot (illegible)     Wylot, --- 13
4499583 2200513 2200513 defendant Shepherde John   589301 589301 Shepherde, John, of Gillyngham 14
4499584 2200513 2200513 defendant Pypes Nicholas   589301 589301 Pypes, Nicholas, of Gillyngham 15
4499585 2200513 2200513 defendant Gote Thomas     Gote, Thomas 16
4499586 2200513 2200513 defendant (illegible) John     ---, John 17
4499587 2200513 2200513 defendant Kyng (illegible)     Kyng, --- 18
4499588 2200513 2200513 defendant Lyngyver John   608282 608282 Lyngyver, John, of Mere 19
4499589 2200513 2200513 defendant Huxe John     Huxe, John 20

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