names

16 rows where case_id = 2483004

✎ 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
5426960 2483004 2483004 plaintiff Denne William     Denne, William, on his own account 0
5426961 2483004 2483004 defendant Myles Thomas   586102 586102 Myles, Thomas, of Hengham, mason 0
5426962 2483004 2483004 defendant Lynne John husbandman 630844 630844 Lynne, John, of Tyteleshale, husbandman 1
5426963 2483004 2483004 defendant Coche Roger yeoman 590409 590409 Coche, Roger, of Costessey, yeoman 2
5426964 2483004 2483004 defendant Verdon Nicholas husbandman 589042 589042 Verdon, Nicholas, of Heydon, husbandman 3
5426965 2483004 2483004 defendant Alpe Thomas butcher 586102 586102 Alpe, Thomas, of Hengham, butcher 4
5426966 2483004 2483004 defendant Crome John yeoman 856182 856182 Crome, John, of Billyngford by Baldeswell, yeoman 5
5426967 2483004 2483004 defendant Wolle Walter husbandman 604304 604304 Wolle, Walter, of Upwell, Cambs, husbandman 6
5426968 2483004 2483004 defendant Elam Thomas miller 601937 601937 Elam, Thomas, of Ersham, miller 7
5426969 2483004 2483004 defendant Yarham John carpenter 598081 598081 Yarham, John, of Hyndolveston, carpenter 8
5426970 2483004 2483004 defendant Baret Thomas husbandman 587414 587414 Baret, Thomas, of Thetford, husbandman 9
5426971 2483004 2483004 defendant Sparke John husbandman 592833 592833 Sparke, John, of Wakton, husbandman 10
5426972 2483004 2483004 defendant Groute William husbandman 587166 587166 Groute, William, of Salle, husbandman 11
5426973 2483004 2483004 defendant Bolold Thomas husbandman 592833 592833 Bolold, Thomas, of Wakton, husbandman 12
5426974 2483004 2483004 defendant Herryson John   586396 586396 Herryson, John, of Yaxham, mason 13
5426975 2483004 2483004 defendant Phyppys Richard husbandman 588926 588926 Phyppys, Richard, of North Elmham, husbandman 14

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