names

18 rows where case_id = 1910263

✎ 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
3649610 1910263 1910263 plaintiff Pykeryng Christopher knight   Pykeryng, Christopher, knight 0
3649611 1910263 1910263 defendant Conder Christopher husbandman 602334 602334 Conder, Christopher, of Hutton Ruffe, husbandman 0
3649612 1910263 1910263 defendant Bethom Christopher husbandman 602334 602334 Bethom, Christopher, of Hutton Ruffe, husbandman 1
3649613 1910263 1910263 defendant Gwyn or Ewyn William     Gwyn or Ewyn, William 2
3649614 1910263 1910263 defendant Harwod Thomas     Harwod, Thomas 3
3649615 1910263 1910263 defendant Harlyng John     Harlyng, John 4
3649616 1910263 1910263 defendant Smyth Reginald     Smyth, Reginald 5
3649617 1910263 1910263 defendant More George     More, George 6
3649618 1910263 1910263 defendant Gwyn or Ewyn Reginald   588960 588960 Gwyn or Ewyn, Reginald, of Byggyng 7
3649619 1910263 1910263 defendant Blande Leonard     Blande, Leonard 8
3649620 1910263 1910263 defendant Richardson alias Wyllyamson Leonard     Richardson alias Wyllyamson, Leonard 9
3649621 1910263 1910263 defendant Wylson John     Wylson, John 10
3649622 1910263 1910263 defendant Bethom Mathew     Bethom, Mathew 11
3649623 1910263 1910263 defendant Waryner Robert     Waryner, Robert 12
3649624 1910263 1910263 defendant Huchynson James     Huchynson, James 13
3649625 1910263 1910263 defendant Donald John     Donald, John 14
3649626 1910263 1910263 defendant Huchynson Reginald     Huchynson, Reginald 15
3649627 1910263 1910263 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);