names

24 rows where place_id = 604037

✎ 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
3656637 1912329 1912329 defendant Joppys William husbandman 604037 604037 Joppys, William, of Sutton in Holland, husbandman 0
3657527 1912614 1912614 defendant Calowe Henry yeoman 604037 604037 Calowe, Henry, of Sutton in Holland, yeoman 0
3657528 1912614 1912614 defendant Halden Simon yeoman 604037 604037 Halden, Simon, of Sutton in Holland, yeoman 1
3818246 1963622 1963622 plaintiff Man John   604037 604037 Man, John, of Sutton in Holland 0
3819860 1964093 1964093 defendant Cokke Robert husbandman 604037 604037 Cokke, Robert, of Sutton in Holland, husbandman 0
3940029 2003684 2003684 defendant Tompson Robert, senior husbandman 604037 604037 Tompson, Robert, senior, of Sutton in Holland, husbandman 0
3942438 2004482 2004482 defendant Chapman Richard husbandman 604037 604037 Chapman, Richard, of Sutton in Holland, husbandman 2
3978415 2017036 2017036 defendant Brightman John yeoman 604037 604037 Brightman, John, of Sutton in Holland, yeoman 1
3989348 2020932 2020932 defendant Foster John husbandman 604037 604037 Foster, John, of Sutton in Holland, husbandman 0
3989349 2020932 2020932 defendant Marret Thomas husbandman 604037 604037 Marret, Thomas, of Sutton in Holland, husbandman 1
4010648 2028579 2028579 defendant Nun Lawrence yeoman 604037 604037 Nun, Lawrence, of Sutton in Holland, yeoman 0
4010649 2028579 2028579 defendant Donyngton Edward carpenter 604037 604037 Donyngton, Edward, of Sutton in Holland, carpenter 1
4010651 2028580 2028580 plaintiff Partriche George gent 604037 604037 Partriche, George, of Sutton in Holland, gent 0
4010652 2028580 2028580 defendant Nun Lawrence husbandman 604037 604037 Nun, Lawrence, of Sutton in Holland, husbandman 0
4010668 2028587 2028587 plaintiff Partryche George gent 604037 604037 Partryche, George, of Sutton in Holland, gent 0
4010669 2028587 2028587 defendant Nun Lawrence husbandman 604037 604037 Nun, Lawrence, of Sutton in Holland, husbandman 0
4072762 2050559 2050559 defendant Craxton Robert husbandman 604037 604037 Craxton, Robert, of Sutton in Holland, husbandman 1
4072763 2050559 2050559 defendant Coppewell Richard fisher 604037 604037 Coppewell, Richard, of Sutton in Holland, fisher 2
4295796 2128589 2128589 defendant Watson William husbandman 604037 604037 Watson, William, of Sutton in Holland, husbandman 0
4723757 2272735 2272735 defendant Symson Gilbert chaplain 604037 604037 (Symson, Gilbert, of Sutton in Holland, chaplain 1
4723758 2272735 2272735 defendant Reyner Richard husbandman 604037 604037 Reyner, Richard, of Sutton in Holland, husbandman 2
5004646 2358259 2358259 defendant Mariot Thomas husbandman 604037 604037 Mariot, Thomas, of Sutton in Holland, husbandman 2
5092892 2384304 2384304 plaintiff Philipp Robert   604037 604037 Philipp, Robert, of Sutton in Holland 0
5434440 2485240 2485240 defendant thakker Simon husbandman 604037 604037 thakker, Simon, of Sutton in Holland, 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);