names

21 rows where place_id = 597541

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628957 1903931 1903931 defendant Ponyard John husbandman 597541 597541 Ponyard, John, of Heynford, husbandman 4
3722182 1933196 1933196 defendant Garrard Thomas husbandman 597541 597541 Garrard, Thomas, of Heynford, husbandman 0
3797493 1957106 1957106 defendant Watker Walter laborer 597541 597541 Watker, Walter, of Heynford, laborer 0
4180082 2088512 2088512 defendant Symondes Robert   597541 597541 Symondes, Robert, of Heynford, oatmeal maker 3
4258646 2115853 2115853 defendant Parnell John yeoman 597541 597541 Parnell, John, of Heynford, yeoman 0
4309548 2133499 2133499 defendant Iveson Anthony clerk 597541 597541 Iveson, Anthony, of Heynford, clerk 1
4823068 2303299 2303299 defendant Wete John tanner 597541 597541 Wete, John, of Heynford, tanner 0
4830698 2305627 2305627 defendant Isaak Roger husbandman 597541 597541 Isaak, Roger, of Heynford, husbandman 1
4882917 2321576 2321576 defendant Heynes Guy husbandman 597541 597541 Heynes, Guy, of Heynford, husbandman 1
5006821 2358895 2358895 defendant Heynes Guy husbandman 597541 597541 Heynes, Guy, of Heynford, husbandman 1
5043077 2369545 2369545 defendant Rabet or Ravet Thomas husbandman 597541 597541 Rabet or Ravet, Thomas, of Heynford, husbandman 0
5070698 2377732 2377732 defendant Rabat Thomas husbandman 597541 597541 Rabat, Thomas, of Heynford, husbandman 1
5112674 2390094 2390094 defendant Wete John husbandman 597541 597541 Wete, John, of Heynford, husbandman 2
5234040 2425544 2425544 defendant Shelton Thomas esq 597541 597541 Shelton, Thomas, of Heynford, esq 0
5234043 2425545 2425545 defendant Shelton Thomas esq 597541 597541 Shelton, Thomas, of Heynford, esq 0
5260999 2433558 2433558 defendant (not given) John rector of Baker 597541 597541 Baker, John, of Heynford, rector of Heydon 1
5278690 2438872 2438872 defendant Crede Thomas yeoman 597541 597541 Crede, Thomas, of Heynford, yeoman 1
5313817 2449160 2449160 defendant Calwe John yeoman 597541 597541 Calwe, John, of Heynford, yeoman 0
5391321 2472598 2472598 defendant Gerard Thomas husbandman 597541 597541 Gerard, Thomas, of Heynford, husbandman 4
5404271 2476298 2476298 defendant Gerard Thomas husbandman 597541 597541 Gerard, Thomas, of Heynford, husbandman 3
5549934 2520017 2520017 defendant Hervy John clerk 597541 597541 Hervy, John, of Heynford, 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);