names

18 rows where case_id = 1910264

✎ 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
3649628 1910264 1910264 plaintiff Pykeryng Christopher knight   Pykeryng, Christopher, knight 0
3649629 1910264 1910264 defendant Conder Christopher husbandman 602334 602334 Conder, Christopher, of Hutton Ruffe, husbandman 0
3649630 1910264 1910264 defendant Bethom Christopher husbandman 602334 602334 Bethom, Christopher, of Hutton Ruffe, husbandman 1
3649631 1910264 1910264 defendant Gwyn William husbandman 602334 602334 Gwyn, William, of Hutton Ruffe, husbandman 2
3649632 1910264 1910264 defendant Harwode Thomas husbandman 602334 602334 Harwode, Thomas, of Hutton Ruffe, husbandman 3
3649633 1910264 1910264 defendant Harlyng John husbandman 602334 602334 Harlyng, John, of Hutton Ruffe, husbandman 4
3649634 1910264 1910264 defendant Smyth Reginald husbandman 602334 602334 Smyth, Reginald, of Hutton Ruffe, husbandman 5
3649635 1910264 1910264 defendant More George husbandman 602334 602334 More, George, of Hutton Ruffe, husbandman 6
3649636 1910264 1910264 defendant Gwyn Reginald husbandman 588960 588960 Gwyn, Reginald, of Byggyng, husbandman 7
3649637 1910264 1910264 defendant Bland Leonard husbandman 588960 588960 Bland, Leonard, of Byggyng, husbandman 8
3649638 1910264 1910264 defendant Richardson alias Wyllyamson Leonard husbandman 588960 588960 Richardson alias Wyllyamson, Leonard, of Byggyng, husbandman 9
3649639 1910264 1910264 defendant Wylson John     Wylson, John 10
3649640 1910264 1910264 defendant Bethom Mathew     Bethom, Mathew 11
3649641 1910264 1910264 defendant Wariner Robert     Wariner, Robert 12
3649642 1910264 1910264 defendant Huchynson James     Huchynson, James 13
3649643 1910264 1910264 defendant Donald John     Donald, John 14
3649644 1910264 1910264 defendant Huchynson Reginald     Huchynson, Reginald 15
3649645 1910264 1910264 defendant Hewetson James     Hewetson, James 16

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