names

18 rows where case_id = 2436861

✎ 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
5271865 2436861 2436861 plaintiff Hert William gent 585869 585869 Hert, William, of London, gent, on his own account 0
5271866 2436861 2436861 defendant Bradshawe Thomas yeoman 608917 608917 Bradshawe, Thomas, of Yerdeley, yeoman 0
5271867 2436861 2436861 defendant Pople John husbandman 755361 755361 Pople, John, of Herdeley, husbandman 1
5271868 2436861 2436861 defendant Borell William husbandman 604444 604444 Borell, William, of Great Munden, husbandman 2
5271869 2436861 2436861 defendant Webbe Thomas husbandman 604444 604444 Webbe, Thomas, of Great Munden, husbandman 3
5271870 2436861 2436861 defendant Smyth Robert husbandman 591512 591512 Smyth, Robert, of Waltham Abbey, Essex, husbandman 4
5271871 2436861 2436861 defendant Middelton Thomas tiler 586528 586528 Middelton, Thomas, of Ware, Herts, tiler 5
5271872 2436861 2436861 defendant Foltmer John husbandman 607738 607738 Foltmer, John, of Sandon, Herts, husbandman 6
5271873 2436861 2436861 defendant Foltmer John, junior husbandman 589769 589769 Foltmer, John, junior, of Sandon, husbandman 7
5271874 2436861 2436861 defendant Pratte Richard husbandman 589769 589769 Pratte, Richard, of Sandon, husbandman 8
5271875 2436861 2436861 defendant Kyng William husbandman 866878 866878 Kyng, William, of Highoresse, Herts, husbandman 9
5271876 2436861 2436861 defendant Reymond Walter husbandman 591966 591966 Reymond, Walter, of Buntyngford, Herts, husbandman 10
5271877 2436861 2436861 defendant Hall Joan widow 859895 859895 Hall, Joan, of Sandon, Beds, widow 11
5271878 2436861 2436861 defendant Hall John husbandman 866879 866879 Hall, John, of Sandon or Sundon, Beds, husbandman 12
5271879 2436861 2436861 defendant Bygby John husbandman 803954 803954 Bygby, John, of Harlyngdon, Beds, husbandman 13
5271880 2436861 2436861 defendant Helyon John (legal representative) 597729 597729 Helyon, John, of Stevenage, Herts, gent, executors of 14
5271881 2436861 2436861 defendant Hakket Richard   866881 866881 (Hakket, Richard, of London, ferrour 15
5271882 2436861 2436861 defendant Hakket Elizabeth     Elizabeth, his wife 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);