names

41 rows where place_id = 758854

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3886730 1985820 1985820 plaintiff Carnybys Reginald   758854 758854 Carnybys, Reginald, of Northumberland, knight 0
4457381 2187321 2187321 plaintiff Percy Henry   758854 758854 Percy, Henry, of Northumberland 0
4457384 2187322 2187322 plaintiff Percy Henry   758854 758854 Percy, Henry, of Northumberland 0
4457535 2187370 2187370 defendant Orde John de   758854 758854 (Orde, John de, of Northumberland 1
4457541 2187371 2187371 defendant Orde John de   758854 758854 Orde, John de, of Northumberland 0
4475724 2193085 2193085 plaintiff Ferrour William   758854 758854 Ferrour, William, of Northumberland 0
4519236 2206368 2206368 defendant Fetherstanhalgh Alexander esq 758854 758854 Fetherstanhalgh, Alexander, of Northumberland, esq 0
4551487 2216405 2216405 defendant Clifton John de   758854 758854 Clifton, John de, of Northumberland 0
4559952 2219065 2219065 defendant Dun Alan   758854 758854 Dun, Alan, of Northumberland 2
4562507 2219834 2219834 defendant del Strother Henry   758854 758854 del Strother, Henry, of Northumberland 1
4571580 2222690 2222690 defendant Heron Nicholas esq 758854 758854 Heron, Nicholas, of Northumberland, esq 0
4571582 2222691 2222691 defendant Heron Nicholas esq 758854 758854 Heron, Nicholas, of Northumberland, esq 0
4576816 2224257 2224257 defendant Dureham Robert (legal representative) 758854 758854 Dureham, Robert, of Northumberland, executrix of 0
4586240 2227119 2227119 defendant Tychebourne Ralph de   758854 758854 Tychebourne, Ralph de, of Northumberland 0
4586241 2227119 2227119 defendant Tychebourne William   758854 758854 Tychebourne, William, of Northumberland 1
4586249 2227120 2227120 defendant Tychebourne Ralph de   758854 758854 Tychebourne, Ralph de, of Northumberland 0
4586250 2227120 2227120 defendant Tychebourne William   758854 758854 Tychebourne, William, of Northumberland 1
4594651 2229582 2229582 defendant del Strother Henry   758854 758854 del Strother, Henry, of Northumberland 1
4601896 2231818 2231818 defendant Prendregest John   758854 758854 Prendregest, John, of Northumberland, knight, formerly esquire 0
4608403 2233738 2233738 defendant Mitford William   758854 758854 Mitford, William, of Northumberland 5
4608440 2233748 2233748 defendant Mitford William   758854 758854 Mitford, William, of Northumberland 5
4626262 2239172 2239172 defendant Broket John   758854 758854 Broket, John, of Northumberland 4
4632210 2240957 2240957 plaintiff Turpyn Nicholas   758854 758854 Turpyn, Nicholas, of Northumberland 0
4637381 2242488 2242488 defendant Mitford William de   758854 758854 Mitford, William de, of Northumberland 4
4637387 2242489 2242489 defendant Mitford William de   758854 758854 Mitford, William de, of Northumberland 4
4639417 2243042 2243042 defendant Hirde Robert   758854 758854 Hirde, Robert, of Northumberland 1
4643263 2244137 2244137 defendant Cotour William   758854 758854 Cotour, William, of Northumberland 0
4646385 2245006 2245006 defendant Broket John   758854 758854 Broket, John, of Northumberland 1
4699502 2265298 2265298 plaintiff Dumfrauvyle or Humfreville Robert   758854 758854 Dumfrauvyle or Humfreville, Robert, of Northumberland, knight 0
4750900 2280746 2280746 plaintiff Rykengale John   758854 758854 Rykengale, John, of Northumberland, archdeacon & clerk 0
4831815 2305969 2305969 defendant Heton Ralph de   758854 758854 Heton, Ralph de, of Northumberland, knight 1
4920041 2332780 2332780 plaintiff Hudson John, junior   758854 758854 Hudson, John, junior, of Northumberland, on his own account 0
4923155 2333660 2333660 defendant Middelton Thomas   758854 758854 Middelton, Thomas, of Northumberland, knight 0
4930033 2335800 2335800 plaintiff Herbotell Robert   758854 758854 Herbotell, Robert, of Northumberland, sheriff & knight 1
5002504 2357643 2357643 defendant Nevyle John   758854 758854 Nevyle, John, of Northumberland, knight 1
5002507 2357644 2357644 defendant Nevyle John   758854 758854 Nevyle, John, of Northumberland, knight 1
5121744 2392789 2392789 plaintiff Togell William (legal representative) 758854 758854 Togell, William, of Northumberland, executor of 0
5393348 2473154 2473154 defendant Baret Thomas gent 758854 758854 Baret, Thomas, of Northumberland, gent 0
5611055 2547177 2547177 defendant Moubray Robert   758854 758854 Moubray, Robert, of Northumberland, knight 0
5611188 2547227 2547227 defendant Belasys John   758854 758854 Belasys, John, of Northumberland 0
5618647 2549669 2549669 defendant Heskyn Richard   758854 758854 Heskyn, Richard, of Northumberland 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);