names

18 rows where case_id = 1910262

✎ 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
3649592 1910262 1910262 plaintiff Pykeryng Christopher knight   Pykeryng, Christopher, knight 0
3649593 1910262 1910262 defendant Bethom Christopher husbandman 602334 602334 Bethom, Christopher, of Hutton Ruffe, husbandman 0
3649594 1910262 1910262 defendant Gwyn or Elkyn William husbandman 602334 602334 Gwyn or Elkyn, William, of Hutton Ruffe, husbandman 1
3649595 1910262 1910262 defendant Harlyng John husbandman 602334 602334 Harlyng, John, of Hutton Ruffe, husbandman 2
3649596 1910262 1910262 defendant Smyth Reginald husbandman 602334 602334 Smyth, Reginald, of Hutton Ruffe, husbandman 3
3649597 1910262 1910262 defendant More George husbandman 602334 602334 More, George, of Hutton Ruffe, husbandman 4
3649598 1910262 1910262 defendant Gwyn Reginald husbandman 588960 588960 Gwyn, Reginald, of Byggyng, husbandman 5
3649599 1910262 1910262 defendant Bland Leonard husbandman 588960 588960 Bland, Leonard, of Byggyng, husbandman 6
3649600 1910262 1910262 defendant Richardson alias Wyllyamson Leonard husbandman 588960 588960 Richardson alias Wyllyamson, Leonard, of Byggyng, husbandman 7
3649601 1910262 1910262 defendant Wylson John     Wylson, John 8
3649602 1910262 1910262 defendant Bethom Mathew     Bethom, Mathew 9
3649603 1910262 1910262 defendant Wariner Robert     Wariner, Robert 10
3649604 1910262 1910262 defendant Huchynson James     Huchynson, James 11
3649605 1910262 1910262 defendant Donald John     Donald, John 12
3649606 1910262 1910262 defendant Huchynson Reginald     Huchynson, Reginald 13
3649607 1910262 1910262 defendant Hewetson James     Hewetson, James 14
3649608 1910262 1910262 defendant Condor Christopher     Condor, Christopher 15
3649609 1910262 1910262 defendant Harwode Thomas     Harwode, Thomas 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);