names

23 rows where place_id = 597294

✎ 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
3627995 1903610 1903610 defendant Cheiswryght Thomas husbandman 597294 597294 Cheiswryght, Thomas, of Fordam, husbandman 0
3627999 1903612 1903612 defendant Cheyswryght Thomas husbandman 597294 597294 Cheyswryght, Thomas, of Fordam, husbandman 0
3637381 1906498 1906498 defendant Chesewryght Thomas husbandman 597294 597294 Chesewryght, Thomas, of Fordam, husbandman 0
3639518 1907167 1907167 defendant Chesewright Thomas husbandman 597294 597294 Chesewright, Thomas, of Fordam, husbandman 0
3639520 1907168 1907168 defendant Chesewryght Thomas husbandman 597294 597294 Chesewryght, Thomas, of Fordam, husbandman 0
3639522 1907169 1907169 defendant Chesewryght Thomas husbandman 597294 597294 Chesewryght, Thomas, of Fordam, husbandman 0
3780493 1951631 1951631 defendant Akers Thomas husbandman 597294 597294 Akers, Thomas, of Fordam, husbandman 2
3824450 1965517 1965517 defendant Acres Thomas husbandman 597294 597294 Acres, Thomas, of Fordam, husbandman 3
3827019 1966304 1966304 defendant Cheswright Joan widow 597294 597294 Cheswright, Joan, of Fordam, widow 1
3848444 1973092 1973092 defendant Rayner Thomas miller 597294 597294 Rayner, Thomas, of Fordam, miller 0
3848475 1973104 1973104 defendant Swan William husbandman 597294 597294 Swan, William, of Fordam, husbandman 0
3858497 1976319 1976319 defendant Salter Richard husbandman 597294 597294 Salter, Richard, of Fordam, husbandman 0
3858499 1976320 1976320 defendant Salter Richard husbandman 597294 597294 Salter, Richard, of Fordam, husbandman 0
3890165 1986951 1986951 plaintiff Hawe James gent 597294 597294 Hawe, James, of Fordam, gent 0
3904311 1991691 1991691 plaintiff Hawe James gent 597294 597294 Hawe, James, of Fordam, gent 0
3904313 1991692 1991692 plaintiff Hawe James gent 597294 597294 Hawe, James, of Fordam, gent 0
3905176 1991994 1991994 defendant Dowe John husbandman 597294 597294 Dowe, John, of Fordam, husbandman 1
3948942 2006697 2006697 defendant Hawe James (legal representative) 597294 597294 Hawe, James, of Fordam, gent, executor of 0
3969455 2013924 2013924 defendant Bentham George clerk 597294 597294 Bentham, George, of Fordam, clerk 0
5053765 2372727 2372727 defendant Rosam John husbandman 597294 597294 Rosam, John, of Fordam, husbandman 0
5053766 2372727 2372727 defendant Bonde John husbandman 597294 597294 Bonde, John, of Fordam, husbandman 1
5180793 2410120 2410120 defendant Hawesby Robert husbandman 597294 597294 Hawesby, Robert, of Fordam, husbandman 0
5425453 2482587 2482587 plaintiff Clerk Thomas chaplain & parson 597294 597294 Clerk, Thomas, of Fordam, chaplain & parson 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);