names

15 rows where place_id = 751805

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4403289 2165673 2165673 defendant Atkinson George yeoman 751805 751805 Atkinson, George, of Raby, yeoman 0
4416615 2170065 2170065 plaintiff Nevyll Ralph de   751805 751805 Nevyll, Ralph de, of Raby 0
4426185 2172994 2172994 plaintiff Nevill Ralph de   751805 751805 Nevill, Ralph de, of Raby 0
4426188 2172995 2172995 plaintiff Nevill Ralph de   751805 751805 Nevill, Ralph de, of Raby 0
4435386 2175822 2175822 plaintiff Nevill Ralph de   751805 751805 Nevill, Ralph de, of Raby 0
4456178 2186950 2186950 plaintiff Nevill John de   751805 751805 Nevill, John de, of Raby 0
4456181 2186951 2186951 plaintiff Nevill John de   751805 751805 Nevill, John de, of Raby, knight 0
4456184 2186952 2186952 plaintiff Nevill John de   751805 751805 Nevill, John de, of Raby, knight 0
4456205 2186958 2186958 plaintiff Nevill William de   751805 751805 Nevill, William de, of Raby, knight 0
4480148 2194451 2194451 defendant Nevill John (legal representative) 751805 751805 Nevill, John, of Raby, knight, executors of 0
4577245 2224401 2224401 defendant Baldwyn William   751805 751805 Baldwyn, William, of Raby 1
4592116 2228892 2228892 plaintiff Nevill Ralph de   751805 751805 Nevill, Ralph de, of Raby, Earl of Westmorland 0
4592140 2228898 2228898 plaintiff Nevyll Ralph de   751805 751805 Nevyll, Ralph de, of Raby, earl of Westmorland 0
4656744 2248005 2248005 plaintiff Chaumberlayn Richard (legal representative) 751805 751805 Chaumberlayn, Richard, of Raby, executrix of 0
4673847 2257440 2257440 defendant Dicson William yeoman 751805 751805 Dicson, William, of Raby, yeoman 0

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