names

24 rows where place_id = 596587

✎ 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
3625379 1875478 1875478 defendant Saunderson William husbandman 596587 596587 Saunderson, William, of Holand, husbandman 0
3678878 1919461 1919461 defendant Scatergod John butcher 596587 596587 Scatergod, John, of Holand, butcher 0
3797964 1957261 1957261 defendant Racheby Richard clerk 596587 596587 Racheby, Richard, of Holand, clerk 0
3851122 1973938 1973938 defendant Baynbryg William   596587 596587 Baynbryg, William, of Holand, wool driver 0
3851123 1973938 1973938 defendant Alsop Bartholomew husbandman 596587 596587 Alsop, Bartholomew, of Holand, husbandman 1
4185079 2090286 2090286 defendant Bynney Henry husbandman 596587 596587 Bynney, Henry, of Holand, husbandman 0
4185081 2090286 2090286 defendant Mylwarde Thomas husbandman 596587 596587 Mylwarde, Thomas, of Holand, husbandman 2
4416693 2170087 2170087 defendant Porter Thomas le   596587 596587 Porter, Thomas le, of Holand 0
4426351 2173049 2173049 defendant Porter Thomas le   596587 596587 Porter, Thomas le, of Holand 0
4438204 2181246 2181246 defendant Hull William   596587 596587 Hull, William, of Holand 2
4439230 2181546 2181546 defendant Hull William   596587 596587 Hull, William, of Holand 2
4543152 2213739 2213739 defendant Tope John   596587 596587 Tope, John, of Holand 0
4545902 2214651 2214651 defendant Derby Ralph   596587 596587 Derby, Ralph, of Holand 0
4569776 2222126 2222126 defendant Pykeworth John   596587 596587 Pykeworth, John, of Holand 2
4588262 2227721 2227721 defendant Sherman Peter   596587 596587 Sherman, Peter, of Holand 0
4598344 2230722 2230722 defendant Andrewe John fishmonger 596587 596587 Andrewe, John, of Holand, fishmonger 0
4611394 2234622 2234622 plaintiff Cleyson Henry   596587 596587 Cleyson, Henry, of Holand 0
4680374 2259476 2259476 defendant Haweslyn William husbandman 596587 596587 Haweslyn, William, of Holand, husbandman 1
4690999 2262709 2262709 defendant Haweselyn Joan widow 596587 596587 Haweselyn, Joan, of Holand, widow 2
4744071 2278792 2278792 defendant Wynter John husbandman 596587 596587 Wynter, John, of Holand, husbandman 2
4827078 2304513 2304513 defendant Vynter John husbandman 596587 596587 Vynter, John, of Holand, husbandman 1
4861354 2314920 2314920 plaintiff Couper Richard   596587 596587 Couper, Richard, of Holand 0
5452427 2490601 2490601 defendant Carrok Robert yeoman 596587 596587 Carrok, Robert, of Holand, yeoman 0
5574504 2527108 2527108 defendant Aspynall Richard husbandman 596587 596587 Aspynall, Richard, of Holand, husbandman 3

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);