names

17 rows where place_id = 610046

✎ 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
3681704 1920375 1920375 defendant Browne Thomas carpenter 610046 610046 Browne, Thomas, of Westhorp, Suff, carpenter 0
3750487 1942066 1942066 defendant Browne Thomas carpenter 610046 610046 Browne, Thomas, of Westhorp, Suff, carpenter 0
4798412 2295689 2295689 defendant Baron Robert husbandman 610046 610046 Baron, Robert, of Westhorp, Suff, husbandman 3
4802551 2296986 2296986 defendant Trusse Robert   610046 610046 (Trusse, Robert, of Westhorp, Suff, parson 3
4802553 2296986 2296986 defendant Kynch John chaplain 610046 610046 Kynch, John, of Westhorp, Suff, chaplain 5
5253228 2431106 2431106 defendant Floteman Thomas yeoman 610046 610046 Floteman, Thomas, of Westhorp, Suff, yeoman 0
5377050 2468414 2468414 defendant Bromer John gent & servant of the Duke of Suffolk 610046 610046 Bromer, John, of Westhorp, Suff, gent & servant of the Duke of Suffolk 0
5377056 2468415 2468415 defendant Bromer John gent & servant of the Duke of Suffolk 610046 610046 Bromer, John, of Westhorp, Suff, gent & servant of the Duke of Suffolk 0
5397453 2474356 2474356 defendant Blundell James gent 610046 610046 Blundell, James, of Westhorp, Suff, gent 3
5410650 2478128 2478128 defendant Blundell James gent 610046 610046 Blundell, James, of Westhorp, Suff, gent 3
5419336 2480704 2480704 defendant Bromer John   610046 610046 Bromer, John, of Westhorp, Suff, gent, formerly servant to John, Duke of Suffolk 0
5424616 2482334 2482334 defendant Blundell James gent 610046 610046 Blundell, James, of Westhorp, Suff, gent 3
5424626 2482335 2482335 defendant Blundell James gent 610046 610046 Blundell, James, of Westhorp, Suff, gent 3
5437482 2486152 2486152 defendant Bromer John   610046 610046 Bromer, John, of Westhorp, Suff, gent, lateley servant to John, Duke, of Suffolk 0
5437488 2486153 2486153 defendant Bromer John gent 610046 610046 Bromer, John, of Westhorp, Suff, gent 0
5591972 2532479 2532479 defendant Steynour John yeoman 610046 610046 Steynour, John, of Westhorp, Suff, yeoman 0
5591974 2532480 2532480 defendant Steynoure John yeoman 610046 610046 Steynoure, John, of Westhorp, Suff, 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);