names

35 rows where place_id = 586960

✎ 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
3590091 1864541 1864541 defendant Happe William chapman 586960 586960 Happe, William, of Keteryng, Nhants, chapman 2
3590097 1864542 1864542 defendant Happe William chapman 586960 586960 Happe, William, of Keteryng, Nhants, chapman 2
3601089 1868007 1868007 defendant Eston John chapman 586960 586960 Eston, John, of Keteryng, Nhants, chapman 0
3613563 1871890 1871890 defendant Happe William chapman 586960 586960 Happe, William, of Keteryng, Nhants, chapman 1
3793345 1955780 1955780 defendant Alderman Richard yeoman 586960 586960 Alderman, Richard, of Keteryng, Nhants, yeoman 0
3844885 1971944 1971944 defendant Morton Richard mercer 586960 586960 Morton, Richard, of Keteryng, Nhants, mercer 1
3844895 1971946 1971946 defendant Morton Richard mercer 586960 586960 Morton, Richard, of Keteryng, Nhants, mercer 3
3869894 1980174 1980174 defendant Fysshe John draper 586960 586960 Fysshe, John, of Keteryng, Nhants, draper 2
4568071 2221582 2221582 defendant Eston John   586960 586960 Eston, John, of Keteryng, Nhants, parson 1
4592688 2229057 2229057 defendant Eston John   586960 586960 Eston, John, of Keteryng, Nhants, parson 2
4777624 2288998 2288998 defendant Piersson William butcher 586960 586960 Piersson, William, of Keteryng, Nhants, butcher 1
4801161 2296547 2296547 defendant Longe Robert gent 586960 586960 Longe, Robert, of Keteryng, Nhants, gent 0
4801172 2296549 2296549 defendant Longe Robert gent 586960 586960 Longe, Robert, of Keteryng, Nhants, gent 1
4864129 2315758 2315758 defendant Stevyns John chapman 586960 586960 Stevyns, John, of Keteryng, Nhants, chapman 0
4886422 2322613 2322613 defendant Stephenys William chapman 586960 586960 Stephenys, William, of Keteryng, Nhants, chapman 3
4888986 2323345 2323345 defendant Stephenys William husbandman 586960 586960 Stephenys, William, of Keteryng, Nhants, husbandman 0
5020492 2362882 2362882 defendant Turney John   586960 586960 Turney, John, of Keteryng, Nhants, notary 2
5073794 2378649 2378649 defendant Steven William chapman 586960 586960 Steven, William, of Keteryng, Nhants, chapman 0
5126590 2394252 2394252 defendant Scouse or Sconse Richard chapman 586960 586960 Scouse or Sconse, Richard, of keteryng, Nhants, chapman 0
5222447 2422277 2422277 defendant Dysselyng William gent 586960 586960 Dysselyng, William, of Keteryng, Nhants, gent 1
5222450 2422278 2422278 defendant Dysselyng William gent 586960 586960 Dysselyng, William, of Keteryng, Nhants, gent 1
5232945 2425218 2425218 defendant Kere Richard clerk 586960 586960 Kere, Richard, of Keteryng, Nhants, clerk 4
5232951 2425219 2425219 defendant Kere Richard clerk 586960 586960 Kere, Richard, of Keteryng, Nhants, clerk 4
5254487 2431525 2431525 defendant Keyre Richard clerk 586960 586960 Keyre, Richard, of Keteryng, Nhants, clerk 0
5354015 2461318 2461318 plaintiff Gyles William merchant 586960 586960 Gyles, William, of Keteryng, Nhants, merchant 0
5354017 2461319 2461319 plaintiff Gyles William merchant 586960 586960 Gyles, William, of Keteryng, Nhants, merchant 0
5357694 2462473 2462473 defendant Emerton John dyer 586960 586960 Emerton, John, of Keteryng, Nhants, dyer 3
5442208 2487592 2487592 defendant (illegible) William mercer 586960 586960 _, William, of Keteryng, Nhants, mercer 0
5442211 2487592 2487592 defendant Mylys Richard dyer 586960 586960 Mylys, Richard, of Keteryng, Nhants, dyer 3
5478121 2498483 2498483 defendant Happe or Harpe William mercer 586960 586960 Happe or Harpe, William, of Keteryng, Nhants, mercer 0
5488018 2501306 2501306 defendant Happe or Harpe William chapman 586960 586960 Happe or Harpe, William, of Keteryng, Nhants, chapman 3
5563507 2523930 2523930 defendant Harpe William chapman 586960 586960 Harpe, William, of Keteryng, Nhants, chapman 0
5575207 2527334 2527334 defendant Pakke Henry yeoman 586960 586960 Pakke, Henry, of Keteryng, Nhants, yeoman 0
5581016 2529136 2529136 defendant Packe Henry husbandman 586960 586960 Packe, Henry, of Keteryng, Nhants, husbandman 0
5607609 2537277 2537277 defendant Brygeman John clerk 586960 586960 Brygeman, John, of Keteryng, Nhants, clerk 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);