names

15 rows where case_id = 2440307

✎ 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
5283831 2440307 2440307 plaintiff FitzAlan William Earl of Arundell   FitzAlan, William, Earl of Arundell 0
5283832 2440307 2440307 defendant Slade Thomas husbandman 600121 600121 Slade, Thomas, of Fyndon, husbandman 0
5283833 2440307 2440307 defendant Crokebek William laborer 682044 682044 Crokebek, William, of Treford, laborer 1
5283834 2440307 2440307 defendant Lede John laborer 773872 773872 Lede, John, of Creford, laborer 2
5283835 2440307 2440307 defendant Gilys Simon laborer 682044 682044 Gilys, Simon, of Treford, laborer 3
5283836 2440307 2440307 defendant Love or Lone Andrew yeoman 587191 587191 Love or Lone, Andrew, of Arundell, yeoman 4
5283837 2440307 2440307 defendant Gosden William yeoman 868500 868500 Gosden, William, of Heyshet, yeoman 5
5283838 2440307 2440307 defendant Smyth William laborer 590528 590528 Smyth, William, of Cokkyng, laborer 6
5283839 2440307 2440307 defendant Lyncoll Robert lborer 682044 682044 Lyncoll, Robert, of Treford, lborer 7
5283840 2440307 2440307 defendant Nasshe John, junior laborer 868501 868501 Nasshe, John, junior, of Tereford, laborer 8
5283841 2440307 2440307 defendant Dubbyng John laborer 682044 682044 Dubbyng, John, of Treford, laborer 9
5283842 2440307 2440307 defendant Pukpitte Thomas laborer 868500 868500 Pukpitte, Thomas, of Heyshet, laborer 10
5283843 2440307 2440307 defendant Beef John   588918 588918 Beef, John, of Petworth, groom 11
5283844 2440307 2440307 defendant Dene William husbandman 591570 591570 Dene, William, of Slyndon, husbandman 12
5283845 2440307 2440307 defendant Passer John husbandman 696170 696170 Passer, John, of Slynden, husbandman 13

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