names

16 rows where case_id = 2504931

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5499917 2504931 2504931 plaintiff Reve Nicholas     Reve, Nicholas 0
5499918 2504931 2504931 defendant Odryche John husbandman 587716 587716 Odryche, John, of Hecham, husbandman 0
5499919 2504931 2504931 defendant Hert Robert tailor 645268 645268 Hert, Robert, of Emeswell, tailor 1
5499920 2504931 2504931 defendant Sugge William yeoman 585947 585947 Sugge, William, of Hadley, yeoman 2
5499921 2504931 2504931 defendant Belcham George fuller 592109 592109 Belcham, George, of Kersey, fuller 3
5499922 2504931 2504931 defendant Mannyng Richard husbandman 585947 585947 Mannyng, Richard, of Hadley, husbandman 4
5499923 2504931 2504931 defendant Cok Richard clothmaker 585947 585947 Cok, Richard, of Hadley, clothmaker 5
5499924 2504931 2504931 defendant Ine or Ive William merchant 587759 587759 Ine or Ive, William, of Nedeham, merchant 6
5499925 2504931 2504931 defendant Rose John husbandman 867557 867557 Rose, John, of Lanshull, husbandman 7
5499926 2504931 2504931 defendant Byrd John of Shymlyngthorn husbandman   Byrd, John of Shymlyngthorn, husbandman 8
5499927 2504931 2504931 defendant Crowe Thomas thatcher 587716 587716 Crowe, Thomas, of Hecham, thatcher 9
5499928 2504931 2504931 defendant Coke John butcher 587716 587716 Coke, John, of Hecham, butcher 10
5499929 2504931 2504931 defendant Laman John butcher 587716 587716 Laman, John, of Hecham, butcher 11
5499930 2504931 2504931 defendant Wode Margaret widow 587716 587716 Wode, Margaret, of Hecham, widow 12
5499931 2504931 2504931 defendant Wode Robert laborer 587716 587716 Wode, Robert, of Hecham, laborer 13
5499932 2504931 2504931 defendant Wode John laborer 587716 587716 Wode, John, of Hecham, laborer 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);