names

15 rows where case_id = 2458811

✎ 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
5345738 2458811 2458811 plaintiff Wode Richard (legal representative) 586117 586117 Wode, Richard, of Coventry, grocer, executors of 0
5345739 2458811 2458811 plaintiff Wode Thomas   586117 586117 (Wode, Thomas, of Coventry 1
5345740 2458811 2458811 plaintiff Taylour William knight   Taylour, William, knight 2
5345741 2458811 2458811 defendant Brese Humphrey chapman 586318 586318 Brese, Humphrey, of Worcester, chapman 0
5345742 2458811 2458811 defendant Cardell Thomas chapman 586318 586318 Cardell, Thomas, of Worcester, chapman 1
5345743 2458811 2458811 defendant Boland Eleanor widow 779696 779696 Boland, Eleanor, of Kynvare, Worcs, widow 2
5345744 2458811 2458811 defendant Cormerant John chapman 590057 590057 Cormerant, John, of Rokeby, chapman 3
5345745 2458811 2458811 defendant Coldale Humphrey chapman 875881 875881 Coldale, Humphrey, of Neucastell, Yorks, chapman 4
5345746 2458811 2458811 defendant Reynold Robert chapman 586432 586432 together with Reynold, Robert, of Camden, Glos, chapman 5
5345747 2458811 2458811 defendant Tyle John chapman 586035 586035 Tyle, John, of Buckingham, chapman 6
5345748 2458811 2458811 defendant Fenton John chapman 586846 586846 Fenton, John, of Lincoln, chapman 7
5345749 2458811 2458811 defendant Adams John chapman 587990 587990 Adams, John, of Ludlowe, Salop, chapman 8
5345750 2458811 2458811 defendant Coke Thomas chapman 589800 589800 Coke, Thomas, of Warsop, Notts, chapman 9
5345751 2458811 2458811 defendant Marchall Joan widow 594086 594086 Marchall, Joan, of Wolverhampton, Staffs, widow 10
5345752 2458811 2458811 defendant Lambard John chapman 593846 593846 Lambard, John, of Stone, Staffs, chapman 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);