names

27 rows where case_id = 2096171

✎ 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
4201782 2096171 2096171 plaintiff Jobson Michael gent, Principal of Furnivals Inn   Jobson, Michael, gent, Principal of Furnivals Inn 0
4201783 2096171 2096171 defendant Lovett Francis gent 713984 713984 Lovett, Francis, of Soulbye, Bucks, gent 0
4201784 2096171 2096171 defendant Ledgingham Michael gent 593376 593376 Ledgingham, Michael, of Wendover, Bucks, gent 1
4201785 2096171 2096171 defendant Lee Thomas gent 713985 713985 Lee, Thomas, of Biggenfarm, Bucks, gent 2
4201786 2096171 2096171 defendant Cheyney John gent 586079 586079 Cheyney, John, of Bedford, gent 3
4201787 2096171 2096171 defendant Ackworth Richard gent 586079 586079 Ackworth, Richard, of Bedford, gent 4
4201788 2096171 2096171 defendant Clarke Nicholas of Wynchenden Bucks, gent   Clarke, Nicholas of Wynchenden, Bucks, gent 5
4201789 2096171 2096171 defendant Essex Ciprion gent 713986 713986 Essex, Ciprion, of Beckett, Berks, gent 6
4201790 2096171 2096171 defendant Hodgeson of Newcastle on Tyne gent   Hodgeson, of Newcastle on Tyne, gent 7
4201791 2096171 2096171 defendant Purifye Richard gent 713987 713987 Purifye, Richard, of Shildeston, Bucks, gent 8
4201792 2096171 2096171 defendant Pawlett Hamdon gent 713988 713988 Pawlett, Hamdon, of Hamblendon, Bucks, gent 9
4201793 2096171 2096171 defendant Packington Thomas gent 588180 588180 Packington, Thomas, of Aylesbury, Bucks, gent 10
4201794 2096171 2096171 defendant Whytney Brooke gent 713989 713989 Whytney, Brooke, of Allyme, Cheshire, gent 11
4201795 2096171 2096171 defendant Vaughan Thomas gent 713990 713990 Vaughan, Thomas, of Spyttey, Carnarvon, gent 12
4201796 2096171 2096171 defendant Williams Edmund gent 713991 713991 Williams, Edmund, of Coghewillan, Carnarvon, gent 13
4201797 2096171 2096171 defendant Wrighte Lawrence gent 647088 647088 Wrighte, Lawrence, of Nantwich, Cheshire, gent 14
4201798 2096171 2096171 defendant Walker Henry gent 588081 588081 Walker, Henry, of Cambridge, gent 15
4201799 2096171 2096171 defendant Gwynne William gent 713992 713992 Gwynne, William, of Nantley, Carnarvon, gent 16
4201800 2096171 2096171 defendant Gwynne John gent 713993 713993 Gwynne, John, of Gwyder, Carnrvon, gent 17
4201801 2096171 2096171 defendant Rudston Thomas gent 597465 597465 Rudston, Thomas, of Ely, Cams, gent 18
4201802 2096171 2096171 defendant Ratclyf Robert gent 592889 592889 Ratclyf, Robert, of Shelford, Cams, gent 19
4201803 2096171 2096171 defendant Stoyett John gent 713994 713994 Stoyett, John, of Gamblingaye, Cams, gent 20
4201804 2096171 2096171 defendant Rutter Jasper gent 655784 655784 Rutter, Jasper, of Nantwiche, gent 21
4201805 2096171 2096171 defendant Morgan Henry gent 713995 713995 Morgan, Henry, of Kedwelley, Carnarvon, gent 22
4201806 2096171 2096171 defendant Newton Thomas gent 713996 713996 Newton, Thomas, of Chaddeston, Derbs, gent 23
4201807 2096171 2096171 defendant Blackwall Francis gent 713997 713997 Blackwall, Francis, of Tydeswall, Derbs, gent 24
4201808 2096171 2096171 defendant Swynnerton Thomas   844478 844478 Swynnerton, Thomas, of Chaddeston, Derbs gent, et al 25

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