names

25 rows where case_id = 2519955

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5549714 2519955 2519955 plaintiff Bray Reginald knight   Bray, Reginald, knight, executors of 0
5549715 2519955 2519955 plaintiff Smyth William Bishop of Lincoln   (Smyth, William, Bishop of Lincoln 1
5549716 2519955 2519955 plaintiff Oldom Hugh Bishop of Exeter   Oldom, Hugh, Bishop of Exeter 2
5549717 2519955 2519955 plaintiff Emson Richard knight   Emson, Richard, knight 3
5549718 2519955 2519955 plaintiff Cutte John knight   Cutte, John, knight 4
5549719 2519955 2519955 plaintiff Conyngesby Humphrey     Conyngesby, Humphrey 5
5549720 2519955 2519955 plaintiff Cope William     Cope, William 6
5549721 2519955 2519955 plaintiff Dygby Simon     Dygby, Simon 7
5549722 2519955 2519955 defendant Roydon John esq, escheator in Norf and Suff   Roydon, John, esq, escheator in Norf and Suff 0
5549723 2519955 2519955 defendant Ryder Thomas esq 596824 596824 Ryder, Thomas, of Lynstede, Kent, esq 1
5549724 2519955 2519955 defendant A Lye Thomas esq 621341 621341 A Lye, Thomas, of Slyford, Lincs, esq 2
5549725 2519955 2519955 defendant Coton Henry escheator in Surrey and Sussex   Coton, Henry, escheator in Surrey and Sussex 3
5549726 2519955 2519955 defendant Abell John gent 589282 589282 Abell, John, of Chertesey, Surrey, gent 4
5549727 2519955 2519955 defendant Wayte John esq, escheator in Hants and Wilts   Wayte, John, esq, escheator in Hants and Wilts 5
5549728 2519955 2519955 defendant Cheyne Roger esq 898974 898974 Cheyne, Roger, of Kinburn, Berks, esq 6
5549729 2519955 2519955 defendant Wroughton John, junior esq 595147 595147 Wroughton, John, junior, of Wilton, Wilts, esq 7
5549730 2519955 2519955 defendant Whitton John escheator in Beds and Bucks   Whitton, John, escheator in Beds and Bucks 8
5549731 2519955 2519955 defendant Creke Thomas esq 898975 898975 Creke, Thomas, of Rykemonsworth, Herts, esq 9
5549732 2519955 2519955 defendant Bukmaister Robert yeoman 638859 638859 Bukmaister, Robert, of Kynges Langley, Herts, yeoman 10
5549733 2519955 2519955 defendant Pudsey Richard esq, escheator of Soms and Dorset   Pudsey, Richard, esq, escheator of Soms and Dorset 11
5549734 2519955 2519955 defendant Proure Thomas gent 586958 586958 Proure, Thomas, of Gloucester, gent 12
5549735 2519955 2519955 defendant Partriche Andrew   614249 614249 Partriche, Andrew, of Brendwode, Essex 13
5549736 2519955 2519955 defendant Kyrkeham Nicholas esq, escheator in Devon   Kyrkeham, Nicholas, esq, escheator in Devon 14
5549737 2519955 2519955 defendant Seyntcler John gent 667674 667674 Seyntcler, John, of Est Budlegh, Devon, gent 15
5549738 2519955 2519955 defendant Mountford William gent 585869 585869 Mountford, William, of London, gent 16

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