names

26 rows where case_id = 1865076

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591864 1865076 1865076 plaintiff Ferrers Martin     Ferrers, Martin 0
3591865 1865076 1865076 defendant Middelton Nicholas gent 585869 585869 Middelton, Nicholas, of London, gent 0
3591866 1865076 1865076 defendant Jerves John gent 586180 586180 Jerves, John, of Bury St Edmunds, gent 1
3591867 1865076 1865076 defendant Manfeld Robert gent 585869 585869 Manfeld, Robert, of London, gent 2
3591868 1865076 1865076 defendant Bompsted Peter gent 585869 585869 Bompsted, Peter, of London, gent 3
3591869 1865076 1865076 defendant Leylond Henry gent 587594 587594 Leylond, Henry, of Manchester, Lancs, gent 4
3591870 1865076 1865076 defendant Brewarn Lawrence gent 585869 585869 Brewarn, Lawrence, of London, gent 5
3591871 1865076 1865076 defendant Daggys John   585869 585869 Daggys, John, of London gent 6
3591872 1865076 1865076 defendant Brynnyng Thomas gent 587596 587596 Brynnyng, Thomas, of Bere Regis, Dorset, gent 7
3591873 1865076 1865076 defendant Wyllughby Richard gent 585869 585869 Wyllughby, Richard, of London, gent 8
3591874 1865076 1865076 defendant Barton William gent 585951 585951 Barton, William, of Winchester, gent 9
3591875 1865076 1865076 defendant Bosyn Henry gent 585869 585869 Bosyn, Henry, of London, gent 10
3591876 1865076 1865076 defendant Bryggys John gent 585869 585869 Bryggys, John, of London, gent, Bardvyld or Bardnyld, John, of London, gent 11
3591877 1865076 1865076 defendant Wyse Thomas gent 585869 585869 Wyse, Thomas, of London, gent 12
3591878 1865076 1865076 defendant Chaffman or Chassman John, junior gent 587598 587598 Chaffman or Chassman, John, junior, of Mayden Bradley, Wilts, gent 13
3591879 1865076 1865076 defendant Braunche John gent 585869 585869 Braunche, John, of London, gent 14
3591880 1865076 1865076 defendant Yelverton Nicholas gent 585869 585869 Yelverton, Nicholas, of London, gent 15
3591881 1865076 1865076 defendant Mepurley John gent 585869 585869 Mepurley, John, of London, gent 16
3591882 1865076 1865076 defendant Rason William gent 585869 585869 Rason, William, of London, gent 17
3591883 1865076 1865076 defendant Huntley John gent 585869 585869 Huntley, John, of London, gent 18
3591884 1865076 1865076 defendant Taccher Thomas gent 585869 585869 Taccher, Thomas, of London, gent 19
3591885 1865076 1865076 defendant Hostys John gent 585869 585869 Hostys, John, of London, gent 20
3591886 1865076 1865076 defendant Lathom John gent 586254 586254 Lathom, John, of Southampton, gent 21
3591887 1865076 1865076 defendant Hoberthorn John gent 585869 585869 Hoberthorn, John, of London, gent 22
3591888 1865076 1865076 defendant Coxsale William gent 585869 585869 Coxsale, William, of London, gent 23
3591889 1865076 1865076 defendant Edwardys Edmund gent 585869 585869 Edwardys, Edmund, of London, gent 24

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