names

16 rows where case_id = 2483003

✎ 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
5426944 2483003 2483003 plaintiff Denne William     Denne, William, on his own account 0
5426945 2483003 2483003 defendant Myles Thomas   586102 586102 Myles, Thomas, of Hengham, mason 0
5426946 2483003 2483003 defendant Lyme John husbandman 630844 630844 Lyme, John, of Tyteleshale, husbandman 1
5426947 2483003 2483003 defendant Coche Roger yeoman 590409 590409 Coche, Roger, of Costessey, yeoman 2
5426948 2483003 2483003 defendant Verdon Nicholas husbandman 589042 589042 Verdon, Nicholas, of Heydon, husbandman 3
5426949 2483003 2483003 defendant Alpe Thomas butcher 586102 586102 Alpe, Thomas, of Hengham, butcher 4
5426950 2483003 2483003 defendant Crome John yeoman 879981 879981 Crome, John, of Byllyngford by Baldeswell, yeoman 5
5426951 2483003 2483003 defendant Welle Walter husbandman 604304 604304 Welle, Walter, of Upwell, Cambs, husbandman 6
5426952 2483003 2483003 defendant Glam Thomas miller 654207 654207 Glam, Thomas, of Earsham, miller 7
5426953 2483003 2483003 defendant Yarham John carpenter 859462 859462 Yarham, John, of Hyndelveston, carpenter 8
5426954 2483003 2483003 defendant Baret Thomas husbandman 587414 587414 Baret, Thomas, of Thetford, husbandman 9
5426955 2483003 2483003 defendant Sparke John husbandman 592833 592833 Sparke, John, of Wakton, husbandman 10
5426956 2483003 2483003 defendant Groute William husbandman 587166 587166 Groute, William, of Salle, husbandman 11
5426957 2483003 2483003 defendant Botteld Thomas husbandman 589127 589127 Botteld, Thomas, of Walton, husbandman 12
5426958 2483003 2483003 defendant Herryson John   586396 586396 Herryson, John, of Yaxham, mason 13
5426959 2483003 2483003 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);