names

38 rows where place_id = 586611

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589212 1864269 1864269 defendant Wymarke John husbandman 586611 586611 Wymarke, John, of Helpston, husbandman 0
3638853 1906974 1906974 defendant Preston Robert husbandman 586611 586611 Preston, Robert, of Helpston, husbandman 1
3694024 1924335 1924335 plaintiff Molsworth John gent 586611 586611 Molsworth, John, of Helpston, gent 0
3699287 1925992 1925992 defendant Rowson John husbandman 586611 586611 Rowson, John, of Helpston, husbandman 0
3759051 1944817 1944817 defendant Wylson Henry clerk 586611 586611 Wylson, Henry, of Helpston, clerk 1
3759052 1944817 1944817 defendant Sharp Henry yeoman 586611 586611 Sharp, Henry, of Helpston, yeoman 2
3759053 1944817 1944817 defendant Crosby Thomas husbandman 586611 586611 Crosby, Thomas, of Helpston, husbandman 3
3759054 1944817 1944817 defendant Gilpyn James husbandman 586611 586611 Gilpyn, James, of Helpston, husbandman 4
3759055 1944817 1944817 defendant Smyth William husbandman 586611 586611 Smyth, William, of Helpston, husbandman 5
3761671 1945661 1945661 defendant Foster Adam gent 586611 586611 Foster, Adam, of Helpston, gent 0
3776535 1950412 1950412 defendant Henley Robert husbandman 586611 586611 Henley, Robert, of Helpston, husbandman 0
3776536 1950412 1950412 defendant Smyth alias Howse William smith 586611 586611 Smyth alias Howse, William, of Helpston, smith 1
3819090 1963863 1963863 defendant Offidell Thomas husbandman 586611 586611 Offidell, Thomas, of Helpston, husbandman 0
3819091 1963863 1963863 defendant Walton Robert husbandman 586611 586611 Walton, Robert, of Helpston, husbandman 1
3819092 1963863 1963863 defendant Ray Richard husbandman 586611 586611 Ray, Richard, of Helpston, husbandman 2
3819093 1963863 1963863 defendant Thystylton John husbandman 586611 586611 Thystylton, John, of Helpston, husbandman 3
3819094 1963863 1963863 defendant Eye John husbandman 586611 586611 Eye, John, of Helpston, husbandman 4
3819095 1963863 1963863 defendant Cooke John husbandman 586611 586611 Cooke, John, of Helpston, husbandman 5
3819096 1963863 1963863 defendant Barnard John husbandman 586611 586611 Barnard, John, of Helpston, husbandman 6
3827690 1966523 1966523 defendant Molsworth John gent 586611 586611 Molsworth, John, of Helpston, gent 0
3854855 1975164 1975164 defendant Wylson Henry clerk 586611 586611 Wylson, Henry, of Helpston, clerk 0
3856740 1975735 1975735 defendant Greneleffe Joan   586611 586611 Greneleffe, Joan, of Helpston spinster 1
3892496 1987737 1987737 defendant Hakman John carpenter 586611 586611 Hakman, John, of Helpston, carpenter 0
3892497 1987737 1987737 defendant Jerman William husbandman 586611 586611 Jerman, William, of Helpston, husbandman 1
3905800 1992220 1992220 defendant Worseley John gent 586611 586611 Worseley, John, of Helpston, gent 0
4030240 2035466 2035466 defendant Clapham Thomas, senior gent 586611 586611 Clapham, Thomas, senior, of Helpston, gent 1
4317272 2136154 2136154 defendant Clarke William yeoman 586611 586611 Clarke, William, of Helpston, yeoman 0
4743908 2278745 2278745 defendant Tykyll Robert husbandman 586611 586611 Tykyll, Robert, of Helpston, husbandman 2
4823965 2303570 2303570 defendant Tykell Robert husbandman 586611 586611 Tykell, Robert, of Helpston, husbandman 1
4833025 2306347 2306347 defendant atte Strete Robert husbandman 586611 586611 atte Strete, Robert, of Helpston, husbandman 0
4873510 2318670 2318670 defendant Strete Robert husbandman 586611 586611 Strete, Robert, of Helpston, husbandman 7
4873511 2318670 2318670 defendant Strete John husbandsman 586611 586611 Strete, John, of Helpston, husbandsman 8
4873539 2318673 2318673 defendant Strete Robert husbandman 586611 586611 Strete, Robert, of Helpston, husbandman 6
4873540 2318673 2318673 defendant Strete John husbandsman 586611 586611 Strete, John, of Helpston, husbandsman 7
5265700 2435025 2435025 defendant Susan John husbandman 586611 586611 Susan, John, of Helpston, husbandman 2
5265701 2435025 2435025 defendant Norton John husbandman 586611 586611 Norton, John, of Helpston, husbandman 3
5367314 2465428 2465428 defendant Salman Thomas butcher 586611 586611 Salman, Thomas, of Helpston, butcher 1
5491362 2502305 2502305 defendant Westburn Quintin gent 586611 586611 Westburn, Quintin, of Helpston, gent 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);