names

29 rows where place_id = 594175

✎ 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
3614877 1872307 1872307 defendant White John yeoman 594175 594175 White, John, of Metefeld, yeoman 3
3657017 1912456 1912456 defendant Jermy John   594175 594175 Jermy, John, of Metefeld, esq, exeuctor of 0
3786942 1953719 1953719 defendant Hunketyll Michael husbandman 594175 594175 Hunketyll, Michael, of Metefeld, husbandman 0
3786943 1953719 1953719 defendant Ferrour Robert husbandman 594175 594175 Ferrour, Robert, of Metefeld, husbandman 1
3803573 1959028 1959028 defendant Unketyll Michael husbandman 594175 594175 Unketyll, Michael, of Metefeld, husbandman 0
3803574 1959028 1959028 defendant Ferrour Robert husbandman 594175 594175 Ferrour, Robert, of Metefeld, husbandman 1
4593430 2229231 2229231 defendant Franke John   594175 594175 Franke, John, of Metefeld 0
4645911 2244874 2244874 defendant Germyn John esq 594175 594175 Germyn, John, of Metefeld, esq 0
4687839 2261763 2261763 defendant Yonge John yeoman 594175 594175 Yonge, John, of Metefeld, yeoman 0
4735991 2276401 2276401 defendant Yonge John yeoman 594175 594175 Yonge, John, of Metefeld, yeoman 3
4768259 2286043 2286043 defendant Purs Edmund smith 594175 594175 Purs, Edmund, of Metefeld, smith 0
4808883 2298946 2298946 defendant Whyte John husbandman 594175 594175 Whyte, John, of Metefeld, husbandman 0
4835062 2306967 2306967 defendant Yunge John husbandman 594175 594175 Yunge, John, of Metefeld, husbandman 0
4883524 2321761 2321761 defendant Yonge John yeoman 594175 594175 Yonge, John, of Metefeld, yeoman 7
4888899 2323312 2323312 defendant Jermyn John esq 594175 594175 Jermyn, John, of Metefeld, esq 2
4888902 2323312 2323312 defendant Yonge John yeoman 594175 594175 Yonge, John, of Metefeld, yeoman 5
4923542 2333797 2333797 defendant Goche John, senior husbandman 594175 594175 Goche, John, senior, of Metefeld, husbandman 0
4923544 2333797 2333797 defendant Spynk John   594175 594175 Spynk, John, of Metefeld, wheel wright 2
5046373 2370553 2370553 defendant Gyle John husbandman 594175 594175 with Gyle, John, of Metefeld, husbandman 3
5100358 2386546 2386546 defendant Spynk John husbandman 594175 594175 Spynk, John, of Metefeld, husbandman 1
5232102 2424962 2424962 plaintiff Boteler Robert   594175 594175 Boteler, Robert, of Metefeld 1
5369139 2465948 2465948 defendant Spark William singleman 594175 594175 Spark, William, of Metefeld, husbandman, singleman 1
5369144 2465949 2465949 defendant Spark William husbandman 594175 594175 Spark, William, of Metefeld, husbandman 1
5388305 2471702 2471702 plaintiff Grene Henry   594175 594175 Grene, Henry, of Metefeld 0
5400906 2475320 2475320 plaintiff Grene Henry   594175 594175 Grene, Henry, of Metefeld 0
5488246 2501384 2501384 defendant Wylton Richard (legal representative) 594175 594175 Wylton, Richard, of Metefeld, administratrix of 1
5517552 2510330 2510330 defendant Wylton Joan spinster 594175 594175 Wylton, Joan, of Metefeld, spinster 1
5535343 2515580 2515580 defendant Cone or Cove John carpenter 594175 594175 Cone or Cove, John, of Metefeld, carpenter 0
5567855 2525177 2525177 defendant Kyng William yeoman 594175 594175 Kyng, William, of Metefeld, yeoman 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);