names

17 rows where place_id = 626109

✎ 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
3768050 1947643 1947643 defendant Tysehurst alias Lucas John husbandman 626109 626109 Tysehurst alias Lucas, John, of Hethefeld, husbandman 0
3927661 1999589 1999589 defendant Woodman Thomas yeoman 626109 626109 Woodman, Thomas, of Hethefeld, yeoman 1
4016662 2030666 2030666 defendant Kynge Nicholas husbandman 626109 626109 Kynge, Nicholas, of Hethefeld, husbandman 0
4322785 2138038 2138038 defendant Topleye Robert yeoman 626109 626109 Topleye, Robert, of Hethefeld, yeoman 1
4574243 2223473 2223473 plaintiff Benekenoll Richard carpenter 626109 626109 Benekenoll, Richard, of Hethefeld, carpenter 0
4621022 2237559 2237559 defendant Taillour Thomas   626109 626109 Taillour, Thomas, of Hethefeld 0
4621023 2237559 2237559 defendant Wodeward William   626109 626109 Wodeward, William, of Hethefeld 1
4639809 2243149 2243149 defendant Tannere William   626109 626109 Tannere, William, of Hethefeld 0
4639810 2243149 2243149 defendant Tannere John   626109 626109 Tannere, John, of Hethefeld 1
4718405 2271095 2271095 plaintiff Bakere John   626109 626109 Bakere, John, of Hethefeld 0
4835571 2307114 2307114 defendant Bocher John butcher 626109 626109 Bocher, John, of Hethefeld, butcher 1
5039188 2368362 2368362 defendant Wyot Walter husbandman 626109 626109 Wyot, Walter, of Hethefeld, husbandman 0
5087179 2382629 2382629 defendant Hanter or Hauter William baker 626109 626109 Hanter or Hauter, William, of Hethefeld, baker 0
5094274 2384731 2384731 defendant Hanter or Hauter William baker 626109 626109 Hanter or Hauter, William, of Hethefeld, baker 0
5225158 2423030 2423030 defendant Vante or Vaute Margaret widow 626109 626109 Vante or Vaute, Margaret, of Hethefeld, widow 0
5508639 2507568 2507568 defendant Batte John butcher 626109 626109 Batte, John, of Hethefeld, butcher 0
5508640 2507568 2507568 defendant Baker John husbandman 626109 626109 Baker, John, of Hethefeld, husbandman 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);