names

13 rows where case_id = 2433453

✎ 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
5260625 2433453 2433453 plaintiff Leukenore Roger knight   Leukenore, Roger, knight 0
5260626 2433453 2433453 defendant Snodnam Robert husbandman 650376 650376 Snodnam, Robert, of Bromley, Surrey, husbandman 0
5260627 2433453 2433453 defendant Northowe John husbandman 614261 614261 Northowe, John, of Cranley, Surrey, husbandman 1
5260628 2433453 2433453 defendant Atfeld Thomas laborer 592900 592900 Atfeld, Thomas, of Ryggewyke, laborer 2
5260629 2433453 2433453 defendant Longehurst Thomas laborer 634431 634431 Longehurst, Thomas, of Okeley, Surrey, laborer 3
5260630 2433453 2433453 defendant Longehurst Richard laborer 593219 593219 Longehurst, Richard, of Okeley, laborer 4
5260631 2433453 2433453 defendant Brygaunt William laborer 593219 593219 Brygaunt, William, of Okeley, laborer 5
5260632 2433453 2433453 defendant Whyte JOhn laborer 593219 593219 Whyte, JOhn, of Okeley, laborer 6
5260633 2433453 2433453 defendant Nye William, junior laborer 593219 593219 Nye, William, junior, of Okeley, laborer 7
5260634 2433453 2433453 defendant Nye Simon husbandman 593219 593219 Nye, Simon, of Okeley, husbandman 8
5260635 2433453 2433453 defendant Nye Thomas son of Nye, Thomas, of Okeley, laborer   Nye, Thomas, son of Nye, Thomas, of Okeley, laborer 9
5260636 2433453 2433453 defendant Makerell John   865389 865389 Makerell, John, of Slyndefolde, Sussex, groom 10
5260637 2433453 2433453 defendant Bourer Thomas wheeler 593219 593219 Bourer, Thomas, of Okeley, wheeler 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);