names

13 rows where case_id = 2248955

✎ 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
4659912 2248955 2248955 plaintiff de Montagu Thomas Earl of Salisbury   de Montagu, Thomas, Earl of Salisbury 0
4659913 2248955 2248955 defendant atte Castell William husbandman 778768 778768 atte Castell, William, of Swayneston, husbandman 0
4659914 2248955 2248955 defendant Gybbe Nicholas jusbandman 585995 585995 Gybbe, Nicholas, of Neweton, jusbandman 1
4659915 2248955 2248955 defendant Paye Robert husbandman 771076 771076 Paye, Robert, of Shaldeflete, husbandman 2
4659916 2248955 2248955 defendant Hawekyn John laborer 779225 779225 Hawekyn, John, of Bouecombe, laborer 3
4659917 2248955 2248955 defendant Carter William laborer 779225 779225 Carter, William, of Bouecombe, laborer 4
4659918 2248955 2248955 defendant Hosteler John laborer 779225 779225 Hosteler, John, of Bouecombe, laborer 5
4659919 2248955 2248955 defendant Hervy Robert laborer 779225 779225 Hervy, Robert, of Bouecombe, laborer 6
4659920 2248955 2248955 defendant Hawekyn John husbandman 779225 779225 Hawekyn, John, of Bouecombe, husbandman 7
4659921 2248955 2248955 defendant (not given) William son of Robert atte Hulle, husbandman   William son of Robert atte Hulle, of Chelerton, husbandman 8
4659922 2248955 2248955 defendant Burghton Ralph husbandman 585995 585995 Burghton, Ralph, of Neweton, husbandman 9
4659923 2248955 2248955 defendant John Richard Thomasservant Dawe of Chelerton husbandman   John Richard Thomasservant Dawe, of Chelerton, husbandman 10
4659924 2248955 2248955 defendant Pronte or Proute Robert husbandman 779226 779226 Pronte or Proute, Robert, of Bryghtston, husbandman 11

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