names

21 rows where case_id = 2487195

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5440910 2487195 2487195 plaintiff _ or Martyn Valentine     _ or Martyn, Valentine 0
5440911 2487195 2487195 defendant Trussell Thomas   887768 887768 Trussell, Thomas, of Bille_ 0
5440912 2487195 2487195 defendant (illegible) of Stretton gent   _, of Stretton, gent 1
5440913 2487195 2487195 defendant Walfard Hugh   887769 887769 Walfard, Hugh, of Wolarton 2
5440914 2487195 2487195 defendant Shawe John   611976 611976 Shawe, John, of Alcestre 3
5440915 2487195 2487195 defendant Dawson_ of Brynkelowe     Dawson_, of Brynkelowe 4
5440916 2487195 2487195 defendant Rutter John   887770 887770 Rutter, John, of Rowynger 5
5440917 2487195 2487195 defendant Haddon John   887771 887771 Haddon, John, of Hak_ 6
5440918 2487195 2487195 defendant (illegible) of Warwick fishmonger   _, of Warwick, fishmonger 7
5440919 2487195 2487195 defendant Winner William   887772 887772 Winner, William, of Wythebrok, Bur_, Thomas 8
5440920 2487195 2487195 defendant (illegible) of Brinkelowe     _, of Brinkelowe 9
5440921 2487195 2487195 defendant Haselholte William   611976 611976 Haselholte, William, of Alcestre 10
5440922 2487195 2487195 defendant Coper Thomas   591511 591511 Coper, Thomas, of Stratford 11
5440923 2487195 2487195 defendant Torperley Richard   887773 887773 Torperley, Richard, of Bynton, Elmys, Thomas, of Alcestre 12
5440924 2487195 2487195 defendant S_ Richard     S_, Richard 13
5440925 2487195 2487195 defendant Hacokkys John   586386 586386 Hacokkys, John, of Weston 14
5440926 2487195 2487195 defendant wyntur William   586152 586152 wyntur, William, of Warwick 15
5440927 2487195 2487195 defendant Staunton of Longbrigge     Staunton, of Longbrigge 16
5440928 2487195 2487195 defendant Bedull Henry   759193 759193 Bedull, Henry, of Herdewyk 17
5440929 2487195 2487195 defendant Ma_ Thomas     Ma_, Thomas 18
5440930 2487195 2487195 defendant (illegible)   husbandman   _, husbandman 19

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