names

9 rows where case_id = 2216562

✎ 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
4551947 2216562 2216562 plaintiff Esby William merchant 586067 586067 Esby, William, of York, merchant 0
4551948 2216562 2216562 defendant Maystirson John shipman   Maystirson, John, shipman 0
4551949 2216562 2216562 defendant Dr_m_yston Walter   606673 606673 Dr_m_yston, Walter, of Hull 1
4551950 2216562 2216562 defendant Rotse Thomas   606673 606673 Rotse, Thomas, of Hull 2
4551951 2216562 2216562 defendant Tylar Thomas   586067 586067 Tylar, Thomas, of York 3
4551952 2216562 2216562 defendant Evenwode John turner 586067 586067 Evenwode, John, of York, turner 4
4551953 2216562 2216562 defendant Slabard Richard   768773 768773 Slabard, Richard, of Stukey, Norfolk 5
4551954 2216562 2216562 defendant Taverner William   609837 609837 Taverner, William, of Bautre 6
4551955 2216562 2216562 defendant Barneburgh William   592299 592299 Barneburgh, William, of Doncaster 7

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