names

19 rows where place_id = 753495

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4413842 2169227 2169227 plaintiff Burton Robert de   753495 753495 Burton, Robert de, of Salisbury, canon 0
4443921 2183068 2183068 defendant Oldyngton Thomas de   753495 753495 Oldyngton, Thomas de, of Salisbury, canon 0
4445575 2183569 2183569 plaintiff Croxton Richard de   753495 753495 Croxton, Richard de, of Salisbury, canon 0
4445577 2183570 2183570 plaintiff Croxton Richard de   753495 753495 Croxton, Richard de, of Salisbury, canon, on his own account 0
4445579 2183571 2183571 plaintiff Croxton Richard   753495 753495 Croxton, Richard, of Salisbury, canon, on his own account 0
4515481 2205261 2205261 plaintiff Chitterne John   753495 753495 Chitterne, John, of Salisbury, canon 0
4517105 2205750 2205750 plaintiff Coutterns John   753495 753495 Coutterns, John, of Salisbury, canon 0
4535928 2211510 2211510 plaintiff Louthorp George   753495 753495 Louthorp, George, of Salisbury, canon 1
4547370 2215109 2215109 plaintiff Milton William   753495 753495 Milton, William, of Salisbury, canon 2
4558845 2218728 2218728 plaintiff Pyttys Richard   753495 753495 (Pyttys, Richard, of Salisbury, canon 1
4571596 2222696 2222696 plaintiff Hareburgh Henry   753495 753495 (Hareburgh, Henry, of Salisbury, canon 1
4571604 2222697 2222697 plaintiff Hareburgh Henry   753495 753495 (Hareburgh, Henry, of Salisbury, canon 1
4678419 2258855 2258855 plaintiff Holme Richard de   753495 753495 Holme, Richard de, of Salisbury, canon 0
4925777 2334495 2334495 plaintiff Heende William   753495 753495 Heende, William, of Salisbury, canon 4
5006433 2358780 2358780 plaintiff Sessyk Nicholas   753495 753495 Sessyk, Nicholas, of Salisbury, canon 0
5082619 2381306 2381306 plaintiff Drewe Ralph   753495 753495 Drewe, Ralph, of Salisbury, canon 0
5419979 2480892 2480892 plaintiff Thacham Robert (legal representative) 753495 753495 Thacham, Robert, of Salisbury, canon, executors of 0
5464441 2494283 2494283 plaintiff Thacham Robert (legal representative) 753495 753495 Thacham, Robert, of Salisbury, canon, executors of 0
5623428 2551261 2551261 plaintiff Wynterton Henry de   753495 753495 Wynterton, Henry de, of Salisbury, canon 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);