names

25 rows where case_id = 2107397

✎ 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
4233925 2107397 2107397 plaintiff Dawtrey Richard gent, attorney   Dawtrey, Richard, gent, attorney 0
4233926 2107397 2107397 defendant Warde John chapman 586134 586134 Warde, John, of Ipswich, chapman 0
4233927 2107397 2107397 defendant Dowe Michael clothier 591076 591076 Dowe, Michael, of Est Bergholt, clothier 1
4233928 2107397 2107397 defendant Finche William yeoman 625193 625193 Finche, William, of Claydon, yeoman 2
4233929 2107397 2107397 defendant Abbott Thomas husbandman 610563 610563 Abbott, Thomas, of Wolverston, husbandman 3
4233930 2107397 2107397 defendant Bromell Robert clothier 586134 586134 Bromell, Robert, of Ipswich, clothier 4
4233931 2107397 2107397 defendant Cooke Thomasine yeoman 720293 720293 Cooke, Thomasine, of hersey widow Cortnall, Richard, of Claydon, yeoman 5
4233932 2107397 2107397 defendant Markes Otwell husbandman 625168 625168 Markes, Otwell, of Bayleham, husbandman 6
4233933 2107397 2107397 defendant Rayner Robert husbandman 591076 591076 Rayner, Robert, of Est Bergholt, husbandman 7
4233934 2107397 2107397 defendant Moyse John husbandman 720294 720294 Moyse, John, of Hollowtree, husbandman 8
4233935 2107397 2107397 defendant Potter John bricklayer 586134 586134 Potter, John, of Ipswich, bricklayer 9
4233936 2107397 2107397 defendant Wentworth Henry esq 610056 610056 Wentworth, Henry, of Blakenham on the Hill, esq 10
4233937 2107397 2107397 defendant Page Edward gent 702251 702251 Page Edward, of Wingfeld, gent 11
4233938 2107397 2107397 defendant Hasselton Richard husbandman 586134 586134 Hasselton, Richard, of Ipswich, husbandman 12
4233939 2107397 2107397 defendant Coates Robert husbandman 720295 720295 Coates, Robert, of Creatinge St Mary, husbandman 13
4233940 2107397 2107397 defendant Drane Thomas husbandman 720296 720296 Drane, Thomas, of Otlye, husbandman 14
4233941 2107397 2107397 defendant Finche Thomas scrivener 586134 586134 Finche, Thomas, of Ipswich, scrivener 15
4233942 2107397 2107397 defendant Laurence Roger shoemaker 586134 586134 Laurence, Roger, of Ipswich, shoemaker 16
4233943 2107397 2107397 defendant Froste John   586134 586134 Froste, John, of Ipswich, sailor 17
4233944 2107397 2107397 defendant Glemefeld Nicholas husbandman 588273 588273 Glemefeld, Nicholas, of Stowmarket, husbandman 18
4233945 2107397 2107397 defendant Sudbury alias Haines William yeoman 720295 720295 Sudbury alias Haines, William, of Creatinge St Mary, yeoman 19
4233946 2107397 2107397 defendant Hunt George clothier 610857 610857 Hunt, George, of Boxsted, clothier 20
4233947 2107397 2107397 defendant Luffkyn Richard clothier 610857 610857 Luffkyn, Richard, of Boxsted, clothier 21
4233948 2107397 2107397 defendant Goodige John husbandman 593418 593418 Goodige, John, of Soham Earl, husbandman 22
4233949 2107397 2107397 defendant Clarke William bricklayer 586134 586134 Clarke, William, of Ipswich, bricklayer 23

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