names

69 rows where place_id = 589539

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597907 1866966 1866966 defendant Pake William husbandman 589539 589539 Pake, William, of Wollaston, husbandman 1
3623258 1874802 1874802 defendant Pake William, junior husbandman 589539 589539 Pake, William, junior, of Wollaston, husbandman 1
3623259 1874802 1874802 defendant Pake Thomas husbandman 589539 589539 Pake, Thomas, of Wollaston, husbandman 2
3623260 1874802 1874802 defendant Tayllour William husbandman 589539 589539 Tayllour, William, of Wollaston, husbandman 3
3672734 1917478 1917478 defendant Thornes Thomas gent 589539 589539 Thornes, Thomas, of Wollaston, gent 0
3747890 1941264 1941264 defendant Clerk Richard husbandman 589539 589539 Clerk, Richard, of Wollaston, husbandman 1
3747891 1941264 1941264 defendant Chamberlen William husbandman 589539 589539 Chamberlen, William, of Wollaston, husbandman 2
3930298 2000481 2000481 defendant Sebarne Hugh laborer 589539 589539 Sebarne, Hugh, of Wollaston, laborer 1
3938545 2003233 2003233 plaintiff Pyrrott Roger yeoman 589539 589539 Pyrrott, Roger, of Wollaston, yeoman 0
3938548 2003233 2003233 defendant Wall John nailer 589539 589539 Wall, John, of Wollaston, nailer 2
3961605 2011159 2011159 defendant Mayor John husbandman 589539 589539 Mayor, John, of Wollaston, husbandman 0
3968033 2013449 2013449 defendant Maddock Thomas gent 589539 589539 Maddock, Thomas, of Wollaston, gent 1
3982814 2018626 2018626 plaintiff Sheare Richard   589539 589539 Sheare, Richard, of Wollaston 0
4000933 2025104 2025104 defendant Gouhe George gent 589539 589539 Gouhe, George, of Wollaston, gent 1
4000935 2025104 2025104 defendant James Robert yeoman 589539 589539 James, Robert, of Wollaston, yeoman 3
4001440 2025292 2025292 defendant Handeforde Thomas gent 589539 589539 Handeforde, Thomas, of Wollaston, gent 1
4001441 2025292 2025292 defendant Pope John husbandman 589539 589539 Pope, John, of Wollaston, husbandman 2
4043053 2039984 2039984 plaintiff Perrott William (legal representative) 589539 589539 Perrott, William, of Wollaston, gent, executors of 0
4056019 2044534 2044534 defendant Wollaston George yeoman 589539 589539 Wollaston, George, of Wollaston, yeoman 0
4063796 2047337 2047337 defendant Foster Owen yeoman 589539 589539 Foster, Owen, of Wollaston, yeoman 1
4063798 2047337 2047337 defendant Lea John blacksmith 589539 589539 Lea, John, of Wollaston, blacksmith 3
4094533 2058382 2058382 defendant Pack George husbandman 589539 589539 Pack, George, of Wollaston, husbandman 0
4105626 2062298 2062298 defendant Morrys William yeoman 589539 589539 Morrys, William, of Wollaston, yeoman 0
4106479 2062609 2062609 defendant Duddell Thomas lorimer 589539 589539 Duddell, Thomas, of Wollaston, lorimer 0
4106480 2062609 2062609 defendant Duddell John lorimer 589539 589539 Duddell, John, of Wollaston, lorimer 1
4148396 2077569 2077569 defendant Packe George husbandman 589539 589539 Packe, George, of Wollaston, husbandman 0
4151877 2078768 2078768 defendant Hilton Gilbert tailor 589539 589539 Hilton, Gilbert, of Wollaston, tailor 1
4157168 2080583 2080583 defendant Hoskyn Thomas husbandman 589539 589539 Hoskyn, Thomas, of Wollaston, husbandman 0
4181635 2089062 2089062 defendant Howe John husbandman 589539 589539 Howe, John, of Wollaston, husbandman 0
4181637 2089063 2089063 defendant Mannynge John husbandman 589539 589539 Mannynge, John, of Wollaston, husbandman 0
4181639 2089064 2089064 defendant Mannynge John husbandman 589539 589539 Mannynge, John, of Wollaston, husbandman 0
4205095 2097330 2097330 defendant Howe John husbandman 589539 589539 Howe, John, of Wollaston, husbandman 0
4205097 2097331 2097331 defendant Mannynge John husbandman 589539 589539 Mannynge, John, of Wollaston, husbandman 0
4205099 2097332 2097332 defendant Mannynge John husbandman 589539 589539 Mannynge, John, of Wollaston, husbandman 0
4339389 2143545 2143545 defendant Willaston Hugh gent 589539 589539 Willaston, Hugh, of Wollaston, gent 0
4339390 2143545 2143545 defendant Cureton Thomas   589539 589539 Cureton, Thomas, of Wollaston draper 1
4339392 2143546 2143546 defendant Willaston Hugh gent 589539 589539 Willaston, Hugh, of Wollaston, gent 0
4339393 2143546 2143546 defendant Cureton Thomas   589539 589539 Cureton, Thomas, of Wollaston draper 1
4340909 2144094 2144094 defendant Wollaston Hugh   589539 589539 Wollaston, Hugh, of Wollaston gent 0
4342473 2144640 2144640 defendant Geste Edward gent 589539 589539 Geste, Edward, of Wollaston, gent 0
4383891 2159315 2159315 defendant Mylward William (legal representative) 589539 589539 Mylward, William, of Wollaston, husbandman, executors of 1
4383892 2159315 2159315 defendant Mylward Joan widow 589539 589539 (Mylward, Joan, of Wollaston, widow 2
4489182 2197334 2197334 defendant Holand John de clerk 589539 589539 Holand, John de, of Wollaston, clerk 0
4601535 2231703 2231703 defendant Barton William   589539 589539 Barton, William, of Wollaston 2
4834193 2306704 2306704 defendant Bedyll John   589539 589539 Bedyll, John, of Wollaston 0
4891936 2324215 2324215 defendant Bedyll Thomas gent 589539 589539 Bedyll, Thomas, of Wollaston, gent 1
4935882 2337613 2337613 defendant Langport Ralph gent 589539 589539 Langport, Ralph, of Wollaston, gent 0
4953644 2343054 2343054 defendant Heryot John husbandman 589539 589539 Heryot, John, of Wollaston, husbandman 1
4953645 2343054 2343054 defendant Malleshore John husbandman 589539 589539 Malleshore, John, of Wollaston, husbandman 2
4953646 2343054 2343054 defendant Cony John husbandman 589539 589539 Cony, John, of Wollaston, husbandman 3
4953647 2343054 2343054 defendant Bolme John husbandman 589539 589539 Bolme, John, of Wollaston, husbandman 4
4953648 2343054 2343054 defendant Mower Richard husbandman 589539 589539 Mower, Richard, of Wollaston, husbandman 5
4962597 2345716 2345716 defendant Dalton John miller 589539 589539 Dalton, John, of Wollaston, miller 0
4966682 2346968 2346968 defendant Lybbard John husbandman 589539 589539 Lybbard, John, of Wollaston, husbandman 1
4966683 2346968 2346968 defendant Andrewe Stephen husbandman 589539 589539 Andrewe, Stephen, of Wollaston, husbandman 2
5026987 2364764 2364764 defendant Pudde John husbandman 589539 589539 Pudde, John, of Wollaston, husbandman 0
5172232 2407604 2407604 defendant Gryndell William yeoman 589539 589539 Gryndell, William, of Wollaston, yeoman 3
5191185 2413163 2413163 defendant Gryndell William yeoman 589539 589539 Gryndell, William, of Wollaston, yeoman 3
5207242 2417858 2417858 defendant Gryndell William yeoman 589539 589539 Gryndell, William, of Wollaston, yeoman 2
5291297 2442458 2442458 plaintiff Pilla Lawrence   589539 589539 Pilla, Lawrence, of Wollaston 0
5301955 2445539 2445539 defendant Petyte William husbandman 589539 589539 Petyte, William, of Wollaston, husbandman 0
5301956 2445539 2445539 defendant More John husbandman 589539 589539 More, John, of Wollaston, husbandman 1
5335975 2455833 2455833 defendant Huchyn John husbandman 589539 589539 Huchyn, John, of Wollaston, husbandman 0
5335978 2455833 2455833 defendant Packe William, senior husbandman 589539 589539 Packe, William, senior, of Wollaston, husbandman 3
5418878 2480571 2480571 defendant Kyng Reginald husbandman 589539 589539 Kyng, Reginald, of Wollaston, husbandman 2
5436975 2485991 2485991 defendant Kyng Reginald husbandman 589539 589539 Kyng, Reginald, of Wollaston, husbandman 2
5490999 2502208 2502208 defendant Haryet William husbandman 589539 589539 Haryet, William, of Wollaston, husbandman 1
5531453 2514364 2514364 defendant Stabulles Peter butcher or drover 589539 589539 Stabulles, Peter, of Wollaston, butcher or drover 0
5571627 2526257 2526257 defendant Deye John husbandman 589539 589539 Deye, John, of Wollaston, husbandman 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);