names

18 rows where case_id = 2533291

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5594598 2533291 2533291 plaintiff Beresford John     Beresford, John 0
5594599 2533291 2533291 defendant Messyngham John prior of St Thomas martyr Priory, Stafford   Messyngham, John, prior of St Thomas martyr Priory, Stafford 0
5594600 2533291 2533291 defendant Boughey George gent 591515 591515 Boughey, George, of Weston on Trent, gent 1
5594601 2533291 2533291 defendant Nyxson Thomas yeoman 680205 680205 Nyxson, Thomas, of St Thomas, yeoman 2
5594602 2533291 2533291 defendant Shepperd John   680205 680205 Shepperd, John, of St Thomas, shepherd 3
5594603 2533291 2533291 defendant Bageley William husbandman 903943 903943 Bageley, William, of Arberton, husbandman 4
5594604 2533291 2533291 defendant Johnson William husbandman 903943 903943 Johnson, William, of Arberton, husbandman 5
5594605 2533291 2533291 defendant Barsewyche Roger husbandman 903943 903943 Barsewyche, Roger, of Arberton, husbandman 6
5594606 2533291 2533291 defendant Baker Hugh husbandman 903944 903944 Baker, Hugh, of Barsewyche, husbandman 7
5594607 2533291 2533291 defendant Persons William husbandman 903944 903944 Persons, William, of Barsewyche, husbandman 8
5594608 2533291 2533291 defendant Wakefeld Ralph husbandman 609411 609411 Wakefeld, Ralph, of Salt, husbandman 9
5594609 2533291 2533291 defendant Coke John, junior husbandman 609411 609411 Coke, John, junior, of Salt, husbandman 10
5594610 2533291 2533291 defendant Cant William laborer 680205 680205 Cant, William, of St Thomas, laborer 11
5594611 2533291 2533291 defendant Eyton William laborer 680205 680205 Eyton, William, of St Thomas, laborer 12
5594612 2533291 2533291 defendant Stubbe William laborer 680205 680205 Stubbe, William, of St Thomas, laborer 13
5594613 2533291 2533291 defendant Sutton Edward laborer 680205 680205 Sutton, Edward, of St Thomas, laborer 14
5594614 2533291 2533291 defendant Sponer Peter laborer 680205 680205 Sponer, Peter, of St Thomas, laborer 15
5594615 2533291 2533291 defendant Shortman John laborer 680205 680205 Shortman, John, of St Thomas, laborer 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);