names

34 rows where place_id = 703319

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4147159 2077145 2077145 defendant Eleson or Gleson Thomas clerk 703319 703319 Eleson or Gleson, Thomas, of Hadle, Suff, clerk 1
4527845 2208983 2208983 defendant Kempston John   703319 703319 Kempston, John, of Hadle, Suff 0
4527848 2208984 2208984 defendant Kempston John   703319 703319 Kempston, John, of Hadle, Suff 0
4585799 2226981 2226981 plaintiff Harpour William   703319 703319 Harpour, William, of Hadle, Suff 0
4688090 2261844 2261844 defendant Colman John butcher 703319 703319 Colman, John, of Hadle, Suff, butcher 4
4749548 2280349 2280349 defendant Carswell Peter   703319 703319 Carswell, Peter, of Hadle, Suff, franklin 0
4753425 2281447 2281447 defendant Smyth Henry chapman 703319 703319 Smyth, Henry, of Hadle, Suff, chapman 0
4850695 2311673 2311673 defendant Stonham William husbandman 703319 703319 Stonham, William, of Hadle, Suff, husbandman 1
4881257 2321041 2321041 defendant Tiler Edmund chapman 703319 703319 Tiler, Edmund, of Hadle, Suff, chapman 0
4893749 2324739 2324739 defendant Forde William draper 703319 703319 Forde, William, of Hadle, Suff, draper 1
4894681 2325007 2325007 defendant Savage Robert clerk 703319 703319 Savage, Robert, of Hadle, Suff, clerk 0
4904555 2328034 2328034 defendant Belsham John gent 703319 703319 Belsham, John, of Hadle, Suff, gent 0
4913559 2330737 2330737 defendant Snowe John draper 703319 703319 Snowe, John, of Hadle, Suff, draper 0
4916846 2331771 2331771 defendant Forthe William merchant 703319 703319 Forthe, William, of Hadle, Suff, merchant 0
4981466 2351371 2351371 defendant Chichele Thomas clerk 703319 703319 (Chichele, Thomas, of Hadle, Suff, clerk 1
4981478 2351372 2351372 defendant Chichele Thomas clerk 703319 703319 (Chichele, Thomas, of Hadle, Suff, clerk 1
5039124 2368347 2368347 defendant Bettes Geoffrey laborer 703319 703319 Bettes, Geoffrey, of Hadle, Suff, laborer 4
5077631 2379805 2379805 defendant Wellyot Henry spicer 703319 703319 Wellyot, Henry, of Hadle, Suff, spicer 1
5082036 2381120 2381120 defendant Bendyssh John esq 703319 703319 Bendyssh, John, of Hadle, Suff, esq 0
5082038 2381121 2381121 defendant Bendyssh John esq 703319 703319 Bendyssh, John, of Hadle, Suff, esq 0
5108885 2389018 2389018 plaintiff Foord William   703319 703319 Foord, William, of Hadle, Suff 0
5357696 2462474 2462474 defendant Fen John clothmaker 703319 703319 Fen, John, of Hadle, Suff, clothmaker 0
5357698 2462475 2462475 defendant Fen John clothmaker 703319 703319 Fen, John, of Hadle, Suff, clothmaker 0
5374120 2467499 2467499 defendant Baron John mercer 703319 703319 Baron, John, of Hadle, Suff, mercer 3
5404622 2476395 2476395 defendant Goodwyne John yeoman 703319 703319 Goodwyne, John, of Hadle, Suff, yeoman 0
5404721 2476430 2476430 defendant Tyler Augustine chapman 703319 703319 Tyler, Augustine, of Hadle, Suff, chapman 0
5417758 2480236 2480236 defendant Goodwyne John yeoman 703319 703319 Goodwyne, John, of Hadle, Suff, yeoman 0
5417870 2480273 2480273 defendant Tyler Augustine chapman 703319 703319 Tyler, Augustine, of Hadle, Suff, chapman 0
5435244 2485473 2485473 defendant Goodwyne John yeoman 703319 703319 Goodwyne, John, of Hadle, Suff, yeoman 0
5435246 2485474 2485474 defendant Goodwyne John yeoman 703319 703319 Goodwyne, John, of Hadle, Suff, yeoman 0
5507782 2507331 2507331 defendant Baron John mercer 703319 703319 Baron, John, of Hadle, Suff, mercer 7
5627412 2552545 2552545 defendant Coke Richard   703319 703319 Coke, Richard, of Hadle, Suff, cook 0
5629982 2553378 2553378 defendant Slade Nicholas farmer 703319 703319 Slade, Nicholas, of Hadle, Suff, farmer 1
5629985 2553379 2553379 defendant Slade Nicholas farmer 703319 703319 Slade, Nicholas, of Hadle, Suff, farmer 1

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