names

21 rows where case_id = 2091438

✎ 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
4188429 2091438 2091438 plaintiff Wallenger James principal of Thavis Inn   Wallenger, James, principal of Thavis Inn 0
4188430 2091438 2091438 defendant Godderd John gent 586180 586180 Godderd, John, of Bury St Edmunds, gent 0
4188431 2091438 2091438 defendant Jermyn William gent 585869 585869 Jermyn, William, of London, gent 1
4188432 2091438 2091438 defendant Fuller Robert gent 603181 603181 Fuller, Robert, of Levermere, gent 2
4188433 2091438 2091438 defendant Haywarde Robert gent 585869 585869 Haywarde, Robert, of London, gent 3
4188434 2091438 2091438 defendant Seman George gent 585869 585869 Seman, George, of London, gent 4
4188435 2091438 2091438 defendant Bossevile Francism of Gunthayte Yorks gent   Bossevile Francism of Gunthayte, Yorks, gent 5
4188436 2091438 2091438 defendant Chester John gent 603301 603301 Chester, John, of Sutton in Holdernesse, Yorks, gent 6
4188437 2091438 2091438 defendant Ricard Charles of Hes Yorks, gent   Ricard Charles, of Hes, Yorks, gent 7
4188438 2091438 2091438 defendant Leighe Thomas gent 585869 585869 Leighe, Thomas, of London, gent 8
4188439 2091438 2091438 defendant Wicklyff William gent 585869 585869 Wicklyff, William, of London, gent 9
4188440 2091438 2091438 defendant Constable Edward gent 585869 585869 Constable, Edward, of London, gent 10
4188441 2091438 2091438 defendant Crossebye Thomas gent 585869 585869 Crossebye, Thomas, of London, gent 11
4188442 2091438 2091438 defendant Corker Lionel gent 585869 585869 Corker, Lionel, of London, gent 12
4188443 2091438 2091438 defendant Corker Leonard gent 585869 585869 Corker, Leonard, of London, gent 13
4188444 2091438 2091438 defendant Leigh Gilbert gent 585869 585869 Leigh, Gilbert, of London, gent 14
4188445 2091438 2091438 defendant Prater George gent 585869 585869 Prater, George, of London, gent 15
4188446 2091438 2091438 defendant Prowe Thomas gent 711351 711351 Prowe, Thomas, of Broade Chalke, Wilts, gent 16
4188447 2091438 2091438 defendant Prater John gent 603346 603346 Prater, John, of Latton, Wilts, gent 17
4188448 2091438 2091438 defendant Allen Thomas gent 585869 585869 Allen, Thomas, of London, gent 18
4188449 2091438 2091438 defendant Baker John gent 585869 585869 Baker, John, of London, gent 19

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