names

26 rows where place_id = 632127

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3804822 1959451 1959451 defendant Harman Robert husbandman 632127 632127 Harman, Robert, of Shadyngfeld, husbandman 0
3828423 1966762 1966762 defendant Harman Thomas husbandman 632127 632127 Harman, Thomas, of Shadyngfeld, husbandman 2
3832253 1968002 1968002 defendant Harman Robert husbandman 632127 632127 Harman, Robert, of Shadyngfeld, husbandman 0
3836346 1969274 1969274 defendant Harman Robert husbandman 632127 632127 Harman, Robert, of Shadyngfeld, husbandman 0
3858660 1976380 1976380 defendant Harman Robert husbandman 632127 632127 Harman, Robert, of Shadyngfeld, husbandman 0
3880132 1983608 1983608 defendant Harman Robert husbandman 632127 632127 Harman, Robert, of Shadyngfeld, husbandman 0
3897730 1989448 1989448 defendant Brame Thomas husbandman 632127 632127 Brame, Thomas, of Shadyngfeld, husbandman 0
3897731 1989448 1989448 defendant Gelyott William husbandman 632127 632127 Gelyott, William, of Shadyngfeld, husbandman 1
4605252 2232809 2232809 defendant Fraunceys John   632127 632127 Fraunceys, John, of Shadyngfeld 0
4673841 2257437 2257437 defendant Hawe Thomas butcher 632127 632127 Hawe, Thomas, of Shadyngfeld, butcher 0
4676481 2258257 2258257 defendant Howe Thomas butcher 632127 632127 Howe, Thomas, of Shadyngfeld, butcher 1
4687822 2261760 2261760 defendant Hawe Thomas butcher 632127 632127 Hawe, Thomas, of Shadyngfeld, butcher 1
4689520 2262279 2262279 defendant atte Hawe Thomas butcher 632127 632127 atte Hawe, Thomas, of Shadyngfeld, butcher 3
4690937 2262695 2262695 defendant Snowe Roger miller 632127 632127 Snowe, Roger, of Shadyngfeld, miller 1
4724907 2273082 2273082 defendant Hunte Walter   632127 632127 Hunte, Walter, of Shadyngfeld, bailiff 1
5184944 2411343 2411343 defendant Howys Richard clerk 632127 632127 Howys, Richard, of Shadyngfeld, clerk 0
5204610 2417094 2417094 defendant Howys Richard clerk 632127 632127 Howys, Richard, of Shadyngfeld, clerk 0
5215473 2420249 2420249 defendant Payn Roger husbandman 632127 632127 Payn, Roger, of Shadyngfeld, husbandman 0
5215474 2420249 2420249 defendant Graunt Robert husbandman 632127 632127 Graunt, Robert, of Shadyngfeld, husbandman 1
5269542 2436195 2436195 defendant Herman Robert (legal representative) 632127 632127 Herman, Robert, of Shadyngfeld, husbandman, administratrix of 2
5269543 2436195 2436195 defendant Herman Joan widow 632127 632127 Herman, Joan, of Shadyngfeld, widow 3
5597547 2534133 2534133 defendant Hyll John (legal representative) 632127 632127 Hyll, John, of Shadyngfeld, yeoman, executors of 0
5597548 2534133 2534133 defendant Resbon alias Hyll John yeoman 632127 632127 (Resbon alias Hyll, John, of Shadyngfeld, yeoman 1
5597549 2534133 2534133 defendant Hyll James yeoman 632127 632127 Hyll, James, of Shadyngfeld, yeoman 2
5597550 2534133 2534133 defendant Payne Robert yeoman 632127 632127 Payne, Robert, of Shadyngfeld, yeoman 3
5598039 2534285 2534285 defendant Brame or Braine Thomas husbandman 632127 632127 Brame or Braine, Thomas, of Shadyngfeld, husbandman 2

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