names

19 rows where place_id = 595438

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620470 1873979 1873979 defendant Morell Richard clothmaker 595438 595438 Morell, Richard, of Sutbury, clothmaker 1
3620471 1873979 1873979 defendant Irlond William butcher 595438 595438 Irlond, William, of Sutbury, butcher 2
3620630 1874031 1874031 defendant Coke Robert weaver 595438 595438 Coke, Robert, of Sutbury, weaver 1
3620631 1874031 1874031 defendant Canold Roger fuller 595438 595438 Canold, Roger, of Sutbury, fuller 2
3622113 1874452 1874452 defendant Kyng John butcher 595438 595438 Kyng, John, of Sutbury, butcher 0
3624165 1875089 1875089 defendant Reynold William, senior butcher 595438 595438 Reynold, William, senior, of Sutbury, butcher 0
3624203 1875103 1875103 defendant Irland William husbandman 595438 595438 Irland, William, of Sutbury, husbandman 0
4513562 2204664 2204664 defendant Petit John   595438 595438 Petit, John, of Sutbury 1
4578636 2224806 2224806 defendant Smyth Walter   595438 595438 Smyth, Walter, of Sutbury 0
5104892 2387868 2387868 defendant Brese Richard glover 595438 595438 Brese, Richard, of Sutbury, glover 1
5104897 2387868 2387868 defendant Hyccher or Hycchez John, senior woolman 595438 595438 Hyccher or Hycchez, John, senior, of Sutbury, woolman 6
5104898 2387868 2387868 defendant Hyccher or Hycchez John, junior woolman 595438 595438 Hyccher or Hycchez, John, junior, of Sutbury, woolman 7
5147466 2400406 2400406 defendant Alot William weaver 595438 595438 Alot, William, of Sutbury, weaver 2
5296161 2443870 2443870 plaintiff Wellys Thomas   595438 595438 Wellys, Thomas, of Sutbury 0
5296167 2443871 2443871 plaintiff Welys Thomas   595438 595438 Welys, Thomas, of Sutbury 0
5427926 2483306 2483306 plaintiff Felton William gent 595438 595438 Felton, William, of Sutbury, gent 0
5427929 2483307 2483307 plaintiff Felton William gent 595438 595438 Felton, William, of Sutbury, gent 0
5445495 2488551 2488551 plaintiff Felton William chapman & gent 595438 595438 Felton, William, of Sutbury, chapman & gent 0
5445498 2488552 2488552 plaintiff Felton William gent 595438 595438 Felton, William, of Sutbury, gent 0

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