names

83 rows where place_id = 608174

✎ 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
3619571 1873688 1873688 plaintiff Hynkeley William husbandman 608174 608174 Hynkeley, William, of Assheby Ledger, husbandman 0
3619572 1873688 1873688 plaintiff Atkyns John   608174 608174 Atkyns, John, of Assheby Ledger 1
3672455 1917384 1917384 defendant Toller William yeoman 608174 608174 Toller, William, of Assheby, yeoman 1
3672456 1917384 1917384 defendant Federston William husbandman 608174 608174 Federston, William, of Assheby, husbandman 2
3765099 1946749 1946749 defendant Cole John clerk 608174 608174 Cole, John, of Assheby, clerk 2
3769794 1948208 1948208 plaintiff Rudlond William   608174 608174 Rudlond, William, of Assheby 0
3772552 1949105 1949105 defendant Browne William husbandman 608174 608174 Browne, William, of Assheby, husbandman 0
3787605 1953912 1953912 plaintiff Rudlond William   608174 608174 Rudlond, William, of Assheby 0
3806096 1959834 1959834 defendant Gostwyke William clerk 608174 608174 Gostwyke, William, of Assheby Leger, clerk 1
3806097 1959834 1959834 defendant Gostwyke Thomas yeoman 608174 608174 Gostwyke, Thomas, of Assheby Leger, yeoman 2
3806098 1959834 1959834 defendant Gostwyke Robert yeoman 608174 608174 Gostwyke, Robert, of Assheby Leger, yeoman 3
3821264 1964541 1964541 plaintiff Rudland William   608174 608174 Rudland, William, of Assheby 0
3823748 1965325 1965325 defendant Gostwyke William clerk 608174 608174 Gostwyke, William, of Assheby Leger, clerk 1
3823749 1965325 1965325 defendant Gostwyke Thomas yeoman 608174 608174 Gostwyke, Thomas, of Assheby Leger, yeoman 2
3823750 1965325 1965325 defendant Gostwyke Robert yeoman 608174 608174 Gostwyke, Robert, of Assheby Leger, yeoman 3
3876176 1982278 1982278 defendant Robynson Thomas clerk 608174 608174 Robynson, Thomas, of Assheby, clerk 1
3883741 1984832 1984832 defendant Bursse Thomas clerk 608174 608174 Bursse, Thomas, of Assheby, clerk 0
3884210 1984985 1984985 defendant Thede William yeoman 608174 608174 Thede, William, of Assheby Prior, yeoman 3
3903905 1991544 1991544 defendant Wythe George husbandman 608174 608174 Wythe, George, of Assheby, husbandman 0
3916597 1995927 1995927 defendant Askewe Christopher esq 608174 608174 Askewe, Christopher, of Assheby, esq 1
3917240 1996125 1996125 defendant Wyett George yeoman 608174 608174 Wyett, George, of Assheby, yeoman 1
3939592 2003546 2003546 defendant Dalylaund Edward gent 608174 608174 Dalylaund, Edward, of Assheby, gent 0
3942946 2004646 2004646 plaintiff Wytton Thomas   608174 608174 Wytton, Thomas, of Assheby, Rector 0
3943028 2004678 2004678 plaintiff Yorke Thomas esq 608174 608174 Yorke, Thomas, of Assheby, esq 0
3948488 2006536 2006536 defendant Wentworth Thomas esq 608174 608174 Wentworth, Thomas, of Assheby, esq 0
3968628 2013666 2013666 defendant Davy William husbandman 608174 608174 Davy, William, of Assheby, husbandman 1
3970769 2014367 2014367 defendant Jermyn John husbandman 608174 608174 Jermyn, John, of Assheby, husbandman 3
4162111 2082306 2082306 defendant Swanne Thomas carpenter 608174 608174 Swanne, Thomas, of Assheby, carpenter 0
4431197 2174517 2174517 plaintiff Bere Simon   608174 608174 Bere, Simon, of Assheby, parson 0
4470401 2191391 2191391 defendant Roberdes John   608174 608174 Roberdes, John, of Assheby Leger 1
4475426 2192992 2192992 plaintiff Eyremyn William   608174 608174 Eyremyn, William, of Assheby, parson 0
4521572 2207080 2207080 defendant Birchilles Roger   608174 608174 Birchilles, Roger, of Assheby 0
4532709 2210500 2210500 plaintiff Pym John   608174 608174 Pym, John, of Assheby 0
4563682 2220207 2220207 defendant Blak Ralph   608174 608174 Blak, Ralph, of Assheby 0
4624994 2238785 2238785 defendant Goy William, sen   608174 608174 Goy, William, sen, of Assheby Legger 0
4662250 2249665 2249665 defendant atte Parsones John husbandman 608174 608174 atte Parsones, John, of Assheby, husbandman 4
4682773 2260230 2260230 plaintiff Of the hill William   608174 608174 Of the hill, William, of Assheby Leger 0
4707049 2267588 2267588 defendant Unthanke Thomas yeoman 608174 608174 Unthanke, Thomas, of Assheby, yeoman 0
4726587 2273591 2273591 defendant Blakfordby Simon gent 608174 608174 Blakfordby, Simon, of Assheby, gent 0
4726590 2273592 2273592 defendant Blakfordby Simon gent 608174 608174 Blakfordby, Simon, of Assheby, gent 0
4745634 2279237 2279237 defendant Wolman Nicholas husbandman 608174 608174 Wolman, Nicholas, of Assheby, husbandman 1
4748108 2279957 2279957 defendant Catesby John gent 608174 608174 Catesby, John, of Assheby Legger, gent 0
4748113 2279958 2279958 defendant Catesby John gent 608174 608174 Catesby, John, of Assheby Legger, gent 0
4766983 2285662 2285662 defendant Catesby John gent 608174 608174 Catesby, John, of Assheby Legger, gent 0
4791353 2293389 2293389 defendant Catesby John gent 608174 608174 Catesby, John, of Assheby Legger, gent 0
4880853 2320919 2320919 defendant Smyth John yeoman 608174 608174 Smyth, John, of Assheby, yeoman 0
4880854 2320919 2320919 defendant Fayrhare John yeoman 608174 608174 Fayrhare, John, of Assheby, yeoman 1
4880855 2320919 2320919 defendant Langstrothe William yeoman 608174 608174 Langstrothe, William, of Assheby, yeoman 2
4880856 2320919 2320919 defendant Langstrothe Stephen yeoman 608174 608174 Langstrothe, Stephen, of Assheby, yeoman 3
4880857 2320919 2320919 defendant Boon Thomas yeoman 608174 608174 Boon, Thomas, of Assheby, yeoman 4
4880858 2320919 2320919 defendant Spinner Adam yeoman 608174 608174 Spinner, Adam, of Assheby, yeoman 5
4880859 2320919 2320919 defendant Atkynson John yeoman 608174 608174 Atkynson, John, of Assheby, yeoman 6
4884572 2322082 2322082 defendant Turnour John gent 608174 608174 Turnour, John, of Assheby Leger, gent 0
4907839 2329014 2329014 defendant Turnour John gent 608174 608174 Turnour, John, of Assheby Leger, gent 0
4907841 2329015 2329015 defendant Turnour John gent 608174 608174 Turnour, John, of Assheby Leger, gent 0
4911467 2330089 2330089 defendant Stokes Philip gent 608174 608174 Stokes, Philip, of Assheby, gent 1
4911514 2330102 2330102 defendant Stokes Thomas, junior gent 608174 608174 Stokes, Thomas, junior, of Assheby, gent 1
4919632 2332645 2332645 defendant Turnour John gent 608174 608174 Turnour, John, of Assheby Legger, gent 0
4928877 2335451 2335451 defendant Attylburgh John   608174 608174 Attylburgh, John, of Assheby, parson 1
5002828 2357732 2357732 plaintiff Osbern Thomas   608174 608174 Osbern, Thomas, of Assheby Leger 1
5017817 2362091 2362091 defendant Turnour William gent 608174 608174 Turnour, William, of Assheby, gent 1
5034879 2367057 2367057 defendant Porter John yeoman 608174 608174 Porter, John, of Assheby, yeoman 2
5087983 2382860 2382860 defendant Smyth Stephen husbandman 608174 608174 Smyth, Stephen, of Assheby, husbandman 4
5332016 2454651 2454651 plaintiff Catesby William esq 608174 608174 Catesby, William, of Assheby Liger, esq 0
5387085 2471374 2471374 defendant Blakfordby Thomas laborer 608174 608174 Blakfordby, Thomas, of Assheby, laborer 2
5387086 2471374 2471374 defendant Stanley Alexander laborer 608174 608174 Stanley, Alexander, of Assheby, laborer 3
5387088 2471374 2471374 defendant Colyns John laborer 608174 608174 Colyns, John, of Assheby, laborer 5
5412341 2478636 2478636 defendant Stanley Alexander laborer 608174 608174 Stanley, Alexander, of Assheby, laborer 2
5412342 2478636 2478636 defendant Barly William laborer 608174 608174 Barly, William, of Assheby, laborer 3
5412343 2478636 2478636 defendant Colyer John laborer 608174 608174 Colyer, John, of Assheby, laborer 4
5412344 2478636 2478636 defendant Forster Thomas yeoman 608174 608174 together with Forster, Thomas, of Assheby, yeoman 5
5427081 2483040 2483040 defendant Blakfordby John   608174 608174 together with Blakfordby, John, of Assheby, pedlar 1
5427082 2483040 2483040 defendant Blakfordby Thomas laborer 608174 608174 Blakfordby, Thomas, of Assheby, laborer 2
5427083 2483040 2483040 defendant Stanley Alexander laborer 608174 608174 Stanley, Alexander, of Assheby, laborer 3
5427084 2483040 2483040 defendant Barley William laborer 608174 608174 Barley, William, of Assheby, laborer 4
5427085 2483040 2483040 defendant Colyer John laborer 608174 608174 Colyer, John, of Assheby, laborer 5
5497806 2504286 2504286 defendant Pydde Stephen clerk 608174 608174 Pydde, Stephen, of Assheby, clerk 0
5513843 2509183 2509183 defendant Hanwell Thomas husbandman 608174 608174 Hanwell, Thomas, of Assheby Legger, husbandman 3
5513846 2509184 2509184 defendant Hanwell Thomas husbandman 608174 608174 Hanwell, Thomas, of Assheby Legger, husbandman 1
5524972 2512405 2512405 defendant Pydde Stephen clerk 608174 608174 Pydde, Stephen, of Assheby, clerk 0
5556180 2521803 2521803 defendant Taillour John laborer 608174 608174 Taillour, John, of Assheby, laborer 0
5611845 2547441 2547441 plaintiff Pytkyn William   608174 608174 Pytkyn, William, of Assheby 3
5628393 2552843 2552843 defendant Anwyk Thomas   608174 608174 Anwyk, Thomas, of Assheby 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);