names

18 rows where case_id = 1910265

✎ 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
3649646 1910265 1910265 plaintiff Pykeryng Christopher knight   Pykeryng, Christopher, knight 0
3649647 1910265 1910265 defendant Conder Christopher husbandman 602334 602334 Conder, Christopher, of Hutton Ruffe, husbandman 0
3649648 1910265 1910265 defendant Bethom Christopher husbandman 602334 602334 Bethom, Christopher, of Hutton Ruffe, husbandman 1
3649649 1910265 1910265 defendant Gwyn William husbandman 602334 602334 Gwyn, William, of Hutton Ruffe, husbandman 2
3649650 1910265 1910265 defendant Harwode Thomas husbandman 602334 602334 Harwode, Thomas, of Hutton Ruffe, husbandman 3
3649651 1910265 1910265 defendant Harlyng John husbandman 602334 602334 Harlyng, John, of Hutton Ruffe, husbandman 4
3649652 1910265 1910265 defendant Smyth Reginald husbandman 602334 602334 Smyth, Reginald, of Hutton Ruffe, husbandman 5
3649653 1910265 1910265 defendant More George husbandman 602334 602334 More, George, of Hutton Ruffe, husbandman 6
3649654 1910265 1910265 defendant Gwyn Reginald husbandman 588960 588960 Gwyn, Reginald, of Byggyng, husbandman 7
3649655 1910265 1910265 defendant Bland Leonard husbandman 588960 588960 Bland, Leonard, of Byggyng, husbandman 8
3649656 1910265 1910265 defendant Richardson alias Wyllyamson Leonard husbandman 588960 588960 Richardson alias Wyllyamson, Leonard, of Byggyng, husbandman 9
3649657 1910265 1910265 defendant Wylson John     Wylson, John 10
3649658 1910265 1910265 defendant Bethom Mathew     Bethom, Mathew 11
3649659 1910265 1910265 defendant Wariner Robert     Wariner, Robert 12
3649660 1910265 1910265 defendant Huchynson James     Huchynson, James 13
3649661 1910265 1910265 defendant Donald John     Donald, John 14
3649662 1910265 1910265 defendant Huchynson Reginald     Huchynson, Reginald 15
3649663 1910265 1910265 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);