names

24 rows where case_id = 2336118

✎ 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
4931096 2336118 2336118 plaintiff Upton William     Upton, William, on his own account 0
4931097 2336118 2336118 defendant Osthehous Robert   589796 589796 Osthehous, Robert, of Leek 0
4931098 2336118 2336118 defendant Smyth John   610614 610614 Smyth, John, of Gosberkirk 1
4931099 2336118 2336118 defendant Felde Gilbert   589594 589594 Felde, Gilbert, of Quadryng 2
4931100 2336118 2336118 defendant Colvyle John gent 655085 655085 Colvyle, John, of Marche, Cambs, gent 3
4931101 2336118 2336118 defendant Claymond Thomas   586504 586504 Claymond, Thomas, of Frampton 4
4931102 2336118 2336118 defendant Harebrigge Thomas   779198 779198 Harebrigge, Thomas, of Saterton 5
4931103 2336118 2336118 defendant Illary John shoemaker 586286 586286 Illary, John, of Boston, shoemaker 6
4931104 2336118 2336118 defendant Frampton William   586504 586504 Frampton, William, of Frampton 7
4931105 2336118 2336118 defendant Warde Gillbert   649539 649539 Warde, Gillbert, of Gosberkirke 8
4931106 2336118 2336118 defendant Pynke John mercer 649539 649539 Pynke, John, of Gosberkirke, mercer 9
4931107 2336118 2336118 defendant Fraunceys Thomas   649539 649539 Fraunceys, Thomas, of Gosberkirke 10
4931108 2336118 2336118 defendant Sparke Robert   649539 649539 Sparke, Robert, of Gosberkirke 11
4931109 2336118 2336118 defendant Cobden Robert   649539 649539 Cobden, Robert, of Gosberkirke 12
4931110 2336118 2336118 defendant Magotson William   649539 649539 Magotson, William, of Gosberkirke 13
4931111 2336118 2336118 defendant German Thomas   649539 649539 German, Thomas, of Gosberkirke 14
4931112 2336118 2336118 defendant Flayne Walter   649539 649539 Flayne, Walter, of Gosberkirke 15
4931113 2336118 2336118 defendant Grene Robert   649539 649539 Grene, Robert, of Gosberkirke 16
4931114 2336118 2336118 defendant Leper Simon   649539 649539 Leper, Simon, of Gosberkirke 17
4931115 2336118 2336118 defendant Draper Richard   649539 649539 Draper, Richard, of Gosberkirke 18
4931116 2336118 2336118 defendant Halle Robert   823899 823899 Halle, Robert, of Surfleet 19
4931117 2336118 2336118 defendant Rybold Alice widow, formerly wife of Richard Rybold, of Spaldyng   Rybold, Alice, widow, formerly wife of Richard Rybold, of Spaldyng 20
4931118 2336118 2336118 defendant Stykeney Joan widow 589460 589460 Stykeney, Joan, of Spaldyng, widow 21
4931119 2336118 2336118 defendant each a husbandman except where stated otherwise     each a husbandman, except where stated otherwise 22

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