names

70 rows where place_id = 589605

✎ 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
3598154 1867051 1867051 defendant Judde Henry courser 589605 589605 Judde, Henry, of Wolley, courser 1
3603215 1868674 1868674 defendant Hosteler John husbandman 589605 589605 Hosteler, John, of Wolley, husbandman 0
3630128 1904272 1904272 plaintiff Dyghton William   589605 589605 Dyghton, William, of Wolley 0
3649386 1910198 1910198 defendant Warde John husbandman 589605 589605 Warde, John, of Wolley, husbandman 0
3652539 1911126 1911126 defendant Abdy John nailer 589605 589605 Abdy, John, of Wolley, nailer 0
3673394 1917698 1917698 defendant Boswell William esq 589605 589605 Boswell, William, of Wolley, esq 0
3673395 1917698 1917698 defendant Langley James gent 589605 589605 Langley, James, of Wolley, gent 1
3673396 1917698 1917698 defendant Wodrove Thomas esq 589605 589605 Wodrove, Thomas, of Wolley, esq 2
3673402 1917699 1917699 defendant Crawshawe William husbandman 589605 589605 Crawshawe, William, of Wolley, husbandman 4
3721228 1932941 1932941 defendant Woderove Thomas esq 589605 589605 Woderove, Thomas, of Wolley, esq 2
3791275 1955105 1955105 defendant Ledlam Richard husbandman 589605 589605 Ledlam, Richard, of Wolley, husbandman 0
3791276 1955105 1955105 defendant Sharpe Thomas husbandman 589605 589605 Sharpe, Thomas, of Wolley, husbandman 1
3978635 2017105 2017105 defendant Darnwell William yeoman 589605 589605 Darnwell, William, of Wolley, yeoman 1
3989994 2021174 2021174 plaintiff Beck William gent 589605 589605 Beck, William, of Wolley, gent 0
3989995 2021174 2021174 defendant Redhalle Robert husbandman 589605 589605 Redhalle, Robert, of Wolley, husbandman 0
4014752 2029987 2029987 plaintiff Sheppard Thomas (legal representative) 589605 589605 Sheppard, Thomas, of Wolley, husbandman, executor of 0
4015160 2030114 2030114 defendant Marrowe John gent 589605 589605 Marrowe, John, of Wolley, gent 0
4090150 2056763 2056763 defendant Keche John gent 589605 589605 Keche, John, of Wolley, gent 0
4132415 2071909 2071909 defendant Keche John gent 589605 589605 Keche, John, of Wolley, gent 2
4140693 2074910 2074910 plaintiff Wheatley Anne widow 589605 589605 Wheatley, Anne, of Wolley, widow 0
4148576 2077627 2077627 defendant Clerke Anthony clerk 589605 589605 Clerke, Anthony, of Wolley, clerk 0
4263103 2117326 2117326 defendant Woodrove George (legal representative) 589605 589605 Woodrove, George, of Wolley, esq, administrator of 0
4263104 2117326 2117326 defendant Woodrove Francis gent 589605 589605 Woodrove, Francis, of Wolley, gent 1
4273763 2120770 2120770 defendant Woodrove George (legal representative) 589605 589605 Woodrove, George, of Wolley, esq, administrator of 0
4273764 2120770 2120770 defendant Woodrove Francis gent 589605 589605 Woodrove, Francis, of Wolley, gent 1
4322328 2137882 2137882 defendant Hyncheliffe Francis yeoman 589605 589605 Hyncheliffe, Francis, of Wolley, yeoman 2
4347283 2146307 2146307 defendant Browne   husbandman 589605 589605 Browne, , of Wolley, husbandman 3
4728498 2274149 2274149 defendant Padley John husbandman 589605 589605 Padley, John, of Wolley, husbandman 0
4728499 2274149 2274149 defendant Padley William husbandman 589605 589605 Padley, William, of Wolley, husbandman 1
4788413 2292437 2292437 defendant Wheteley John husbandman 589605 589605 Wheteley, John, of Wolley, husbandman 0
4798642 2295752 2295752 defendant Hepworth Richard chaplain 589605 589605 Hepworth, Richard, of Wolley, chaplain 0
4801031 2296511 2296511 defendant Warde Thomas husbandman 589605 589605 Warde, Thomas, of Wolley, husbandman 0
4947957 2341350 2341350 defendant Wylson Robert husbandman 589605 589605 Wylson, Robert, of Wolley, husbandman 0
5002909 2357756 2357756 defendant Mory Richard husbandman 589605 589605 Mory, Richard, of Wolley, husbandman 0
5005444 2358495 2358495 defendant Pynnyng William husbandman 589605 589605 Pynnyng, William, of Wolley, husbandman 0
5005445 2358495 2358495 defendant Wodde William husbandman 589605 589605 Wodde, William, of Wolley, husbandman 1
5005446 2358495 2358495 defendant Tomlynson William husbandman 589605 589605 Tomlynson, William, of Wolley, husbandman 2
5005447 2358495 2358495 defendant Rysshworth John   589605 589605 Rysshworth, John, of Wolley, wright 3
5099433 2386266 2386266 defendant Rilleston William gent 589605 589605 Rilleston, William, of Wolley, gent 0
5120890 2392541 2392541 defendant Frensheman Robert laborer 589605 589605 Frensheman, Robert, of Wolley, laborer 0
5123341 2393268 2393268 defendant Staynton Lawrence gent 589605 589605 Staynton, Lawrence, of Wolley, gent 0
5123342 2393268 2393268 defendant Staynton William gent 589605 589605 Staynton, William, of Wolley, gent 1
5123343 2393268 2393268 defendant Dighton Christopher yeoman 589605 589605 Dighton, Christopher, of Wolley, yeoman 2
5123345 2393269 2393269 defendant Staynton Lawrence gent 589605 589605 Staynton, Lawrence, of Wolley, gent 0
5123346 2393269 2393269 defendant Staynton William gent 589605 589605 Staynton, William, of Wolley, gent 1
5123347 2393269 2393269 defendant Dighton Christopher yeoman 589605 589605 Dighton, Christopher, of Wolley, yeoman 2
5123350 2393270 2393270 defendant Byrton William gent 589605 589605 Byrton, William, of Wolley, gent 1
5275612 2437934 2437934 defendant Stone John yeoman 589605 589605 Stone, John, of Wolley, yeoman 0
5275615 2437935 2437935 defendant Stone John yeoman 589605 589605 Stone, John, of Wolley, yeoman 0
5275861 2438012 2438012 defendant Wilkynson James husbandman 589605 589605 Wilkynson, James, of Wolley, husbandman 1
5283583 2440249 2440249 defendant Woderove Richard gent 589605 589605 Woderove, Richard, of Wolley, gent 5
5283599 2440253 2440253 defendant Woderove Richard gent 589605 589605 Woderove, Richard, of Wolley, gent 2
5285619 2440816 2440816 defendant Hacche John gent 589605 589605 Hacche, John, of Wolley, gent 0
5335605 2455720 2455720 defendant Fetiplace William gent 589605 589605 Fetiplace, William, of Wolley, gent 5
5337819 2456390 2456390 defendant Marrcham William husbandman 589605 589605 Marrcham, William, of Wolley, husbandman 0
5337820 2456390 2456390 defendant Marrcham Roger husbandman 589605 589605 Marrcham, Roger, of Wolley, husbandman 1
5367234 2465403 2465403 defendant Porter John husbandman 589605 589605 Porter, John, of Wolley, husbandman 0
5497019 2504043 2504043 defendant Staynton William yeoman 589605 589605 Staynton, William, of Wolley, yeoman 3
5511923 2508585 2508585 defendant Stayneton William yeoman 589605 589605 Stayneton, William, of Wolley, yeoman 4
5511924 2508585 2508585 defendant Stayneton Lawrence yeoman 589605 589605 Stayneton, Lawrence, of Wolley, yeoman 5
5529812 2513833 2513833 plaintiff Porter John esq or yeoman 589605 589605 Porter, John, of Wolley, esq or yeoman 0
5529814 2513834 2513834 plaintiff Porter John yeoman 589605 589605 Porter, John, of Wolley, yeoman 0
5543740 2518150 2518150 defendant Snytall Richard gent 589605 589605 Snytall, Richard, of Wolley, gent 1
5543741 2518150 2518150 defendant Craweshawe John yeoman 589605 589605 Craweshawe, John, of Wolley, yeoman 2
5543742 2518150 2518150 defendant Bramley Constantine yeoman 589605 589605 Bramley, Constantine, of Wolley, yeoman 3
5543743 2518150 2518150 defendant Wode John   589605 589605 Wode, John, of Wolley, wheelwright 4
5543744 2518150 2518150 defendant Hyncheclyf John sherman 589605 589605 Hyncheclyf, John, of Wolley, sherman 5
5607457 2537228 2537228 defendant Popeley John gent 589605 589605 (Popeley, John, of Wolley, gent 1
5607458 2537228 2537228 defendant Popeley Elizabeth widow 589605 589605 Popeley, Elizabeth, of Wolley, widow 2
5607459 2537228 2537228 defendant Popeley John gent 589605 589605 Popeley, John, of Wolley, gent 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);