names

99 rows where place_id = 586651

✎ 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
3589299 1864295 1864295 defendant Bocher John butcher 586651 586651 Bocher, John, of Castel Acre, butcher 1
3593295 1865534 1865534 defendant Hendry Edmund butcher 586651 586651 Hendry, Edmund, of Castel Acre, butcher 0
3593296 1865534 1865534 defendant Candeler Thomas yeoman 586651 586651 Candeler, Thomas, of Castel Acre, yeoman 1
3593297 1865534 1865534 defendant Broun John, senior husbandman 586651 586651 Broun, John, senior, of Castel Acre, husbandman 2
3593309 1865538 1865538 defendant Hendry Edmund butcher 586651 586651 Hendry, Edmund, of Castel Acre, butcher 0
3593310 1865538 1865538 defendant Candeler Thomas yeoman 586651 586651 Candeler, Thomas, of Castel Acre, yeoman 1
3593311 1865538 1865538 defendant Broun John, senior husbandman 586651 586651 Broun, John, senior, of Castel Acre, husbandman 2
3596099 1866408 1866408 defendant Royde John yeoman 586651 586651 Royde, John, of Castel Acre, yeoman 4
3625764 1875596 1875596 defendant Candeler Thomas husbandman 586651 586651 Candeler, Thomas, of Castel Acre, husbandman 2
3625765 1875596 1875596 defendant Fyssher William husbandman 586651 586651 Fyssher, William, of Castel Acre, husbandman 3
3670875 1916857 1916857 plaintiff Calybutt John   586651 586651 Calybutt, John, of Castel Acre 0
3673964 1917896 1917896 plaintiff Fuller William   586651 586651 Fuller, William, of Castel Acre 0
3673967 1917897 1917897 plaintiff Fuller William yeoman 586651 586651 Fuller, William, of Castel Acre, yeoman 0
3704134 1927586 1927586 defendant Lakford John butcher 586651 586651 Lakford, John, of Castel Acre, butcher 0
3706774 1928403 1928403 defendant Peskod George   586651 586651 Peskod, George, of Castel Acre, wax chandler 2
3707022 1928481 1928481 defendant Foster Richard husbandman 586651 586651 Foster, Richard, of Castel Acre, husbandman 0
3707023 1928481 1928481 defendant Shortyng Richard laborer 586651 586651 Shortyng, Richard, of Castel Acre, laborer 1
3730178 1935664 1935664 defendant Davy William (legal representative) 586651 586651 Davy, William, of Castel Acre, executrix of 0
3730179 1935664 1935664 defendant Davy Alice widow 586651 586651 Davy, Alice, of Castel Acre, widow 1
3734265 1936957 1936957 plaintiff Fuller William (legal representative) 586651 586651 Fuller, William, of Castel Acre, executors of 0
3734269 1936958 1936958 plaintiff Fuller William (legal representative) 586651 586651 Fuller, William, of Castel Acre, executors of 0
3734276 1936959 1936959 plaintiff Fuller William (legal representative) 586651 586651 Fuller, William, of Castel Acre, executors of 0
3734280 1936960 1936960 plaintiff Fuller William (legal representative) 586651 586651 Fuller, William, of Castel Acre, executors of 0
3737788 1938040 1938040 plaintiff Lytylbery John (legal representative) 586651 586651 Lytylbery, John, of Castel Acre, executor of Lamkyn, Thomas, of Castel Acre, executor of 0
3745787 1940586 1940586 plaintiff Calybutt John   586651 586651 Calybutt, John, of Castel Acre 0
3853833 1974830 1974830 defendant Clement Thomas tailor 586651 586651 Clement, Thomas, of Castel Acre, tailor 2
3900553 1990414 1990414 defendant Stoker Richard husbandman 586651 586651 Stoker, Richard, of Castel Acre, husbandman 0
3900555 1990415 1990415 defendant Manby William laborer 586651 586651 Manby, William, of Castel Acre, laborer 0
3907821 1992904 1992904 defendant Smyth Robert husbandman 586651 586651 Smyth, Robert, of Castel Acre, husbandman 0
3907823 1992905 1992905 plaintiff Petyver John   586651 586651 Petyver, John, of Castel Acre 0
3935218 2002088 2002088 defendant Stokar Richard husbandman 586651 586651 Stokar, Richard, of Castel Acre, husbandman 0
4184512 2090092 2090092 defendant Warde John miller 586651 586651 Warde, John, of Castel Acre, miller 0
4184513 2090092 2090092 defendant Warde Thomas miller 586651 586651 Warde, Thomas, of Castel Acre, miller 1
4863148 2315453 2315453 plaintiff Fox John   586651 586651 Fox, John, of Castel Acre 1
4882938 2321583 2321583 defendant Dey alias Crowe Richard butcher 586651 586651 Dey alias Crowe, Richard, of Castel Acre, butcher 0
4882966 2321592 2321592 defendant Deye Richard butcher 586651 586651 Deye, Richard, of Castel Acre, butcher 3
4913978 2330883 2330883 plaintiff Cordy Richard   586651 586651 Cordy, Richard, of Castel Acre 0
4913980 2330883 2330883 defendant Cordy Richard   586651 586651 Cordy, Richard, of Castel Acre 0
4933784 2336945 2336945 plaintiff Aleyn John   586651 586651 Aleyn, John, of Castel Acre 0
4938269 2338349 2338349 defendant Onden or Ouden Henry yeoman 586651 586651 Onden or Ouden, Henry, of Castel Acre, yeoman 1
4950873 2342243 2342243 defendant Jakys John husbandman 586651 586651 Jakys, John, of Castel Acre, husbandman 0
4956966 2344040 2344040 defendant Jakys John yeoman 586651 586651 together with Jakys, John, of Castel Acre, yeoman 1
4977445 2350219 2350219 plaintiff Prentys William   586651 586651 Prentys, William, of Castel Acre 0
5015469 2361406 2361406 plaintiff Botys or Dotys James   586651 586651 Botys or Dotys, James, of Castel Acre 0
5015470 2361406 2361406 plaintiff Metton Thomas   586651 586651 Metton, Thomas, of Castel Acre 1
5030863 2365898 2365898 plaintiff Prentys William   586651 586651 Prentys, William, of Castel Acre 0
5030864 2365898 2365898 plaintiff Gegge John   586651 586651 Gegge, John, of Castel Acre 1
5034972 2367087 2367087 plaintiff Symmeson Gilbert   586651 586651 Symmeson Gilbert, of Castel Acre 0
5034973 2367087 2367087 plaintiff Whytfote Robert   586651 586651 Whytfote, Robert, of Castel Acre 1
5034974 2367087 2367087 plaintiff Pescodd John   586651 586651 Pescodd, John, of Castel Acre 2
5044708 2370052 2370052 defendant Josep John glover 586651 586651 Josep, John, of Castel Acre, glover 0
5061073 2374887 2374887 defendant Kelyng William gent 586651 586651 Kelyng, William, of Castel Acre, gent 0
5061075 2374888 2374888 defendant Kelyng William gent 586651 586651 Kelyng, William, of Castel Acre, gent 0
5069787 2377456 2377456 defendant Dey Richard butcher 586651 586651 Dey, Richard, of Castel Acre, butcher 1
5074105 2378743 2378743 defendant Prentys William gent 586651 586651 Prentys, William, of Castel Acre, gent 0
5076974 2379610 2379610 defendant Thory Henry   586651 586651 Thory, Henry, of Castel Acre, shepherd 0
5094324 2384746 2384746 defendant Dey Richard butcher 586651 586651 Dey, Richard, of Castel Acre, butcher 1
5095883 2385224 2385224 defendant Gardener William shoemaker 586651 586651 Gardener, William, of Castel Acre, shoemaker 0
5100372 2386549 2386549 defendant Millere Robert miller 586651 586651 Millere, Robert, of Castel Acre, miller 1
5100373 2386549 2386549 defendant Monseux Robert baker 586651 586651 Monseux, Robert, of Castel Acre, baker 2
5102245 2387075 2387075 defendant Bomond Richard   586651 586651 Bomond, Richard, of Castel Acre, shepherd 0
5106366 2388300 2388300 defendant Deye Richard husbandman 586651 586651 Deye, Richard, of Castel Acre, husbandman 4
5136657 2397243 2397243 defendant Smyth John yeoman 586651 586651 Smyth, John, of Castel Acre, yeoman 2
5212969 2419529 2419529 defendant Munsews Robert husbandman 586651 586651 Munsews, Robert, of Castel Acre, husbandman 0
5216132 2420449 2420449 defendant Deye Richard husbandman 586651 586651 Deye, Richard, of Castel Acre, husbandman 4
5216138 2420450 2420450 defendant Deye Richard husbandman 586651 586651 Deye, Richard, of Castel Acre, husbandman 4
5252805 2430987 2430987 defendant Doo John laborer 586651 586651 Doo, John, of Castel Acre, laborer 0
5260375 2433373 2433373 defendant Aleyn John (legal representative) 586651 586651 Aleyn, John, of Castel Acre, or of Hokewold, Norf, yeoman, executors of 0
5262921 2434145 2434145 defendant Bevys John weaver 586651 586651 Bevys, John, of Castel Acre, weaver 0
5262923 2434146 2434146 defendant Denys John weaver 586651 586651 Denys, John, of Castel Acre, weaver 0
5265143 2434860 2434860 defendant Candeler Richard husbandman 586651 586651 Candeler, Richard, of Castel Acre, husbandman 0
5265144 2434860 2434860 defendant Bemond Richard laborer 586651 586651 Bemond, Richard, of Castel Acre, laborer 1
5265147 2434861 2434861 defendant Candeler Richard husbandman 586651 586651 Candeler, Richard, of Castel Acre, husbandman 0
5265148 2434861 2434861 defendant Bemond Richard laborer 586651 586651 Bemond, Richard, of Castel Acre, laborer 1
5275799 2437989 2437989 defendant Henry Robert butcher 586651 586651 Henry, Robert, of Castel Acre, butcher 2
5278865 2438929 2438929 defendant Farle William husbandman 586651 586651 (Farle, William, of Castel Acre, husbandman 1
5278866 2438929 2438929 defendant Candeler Richard husbandman 586651 586651 Candeler, Richard, of Castel Acre, husbandman 2
5283344 2440186 2440186 defendant Farle William yeoman 586651 586651 Farle, William, of Castel Acre, yeoman 0
5283345 2440186 2440186 defendant Maryot Thomas yeoman 586651 586651 Maryot, Thomas, of Castel Acre, yeoman 1
5283346 2440186 2440186 defendant Fyssher William yeoman 586651 586651 Fyssher, William, of Castel Acre, yeoman 2
5283347 2440186 2440186 defendant Poyntour Richard yeoman 586651 586651 together with Poyntour, Richard, of Castel Acre, yeoman 3
5283861 2440309 2440309 defendant Farley William yeoman 586651 586651 Farley, William, of Castel Acre, yeoman 1
5284441 2440465 2440465 defendant Buttery John chandler 586651 586651 Buttery, John, of Castel Acre, chandler 1
5291547 2442530 2442530 defendant Bennys Robet laborer 586651 586651 Bennys, Robet, of Castel Acre, laborer 2
5295638 2443714 2443714 defendant Davy Stephen yeoman 586651 586651 Davy, Stephen, of Castel Acre, yeoman 0
5295639 2443714 2443714 defendant Heylotte Thomas yeoman 586651 586651 Heylotte, Thomas, of Castel Acre, yeoman 1
5296282 2443902 2443902 defendant Marche Thomas mercer 586651 586651 Marche, Thomas, of Castel Acre, mercer 3
5324976 2452549 2452549 defendant Marysshe John husbandman 586651 586651 Marysshe, John, of Castel Acre, husbandman 0
5332568 2454808 2454808 defendant Payn Richard husbandman 586651 586651 Payn, Richard, of Castel Acre, husbandman 0
5337308 2456228 2456228 defendant Prentys William gent 586651 586651 Prentys, William, of Castel Acre, gent 3
5338396 2456584 2456584 defendant Sobour Henry husbandman 586651 586651 Sobour, Henry, of Castel Acre, husbandman 2
5338397 2456584 2456584 defendant Colyns John husbandman 586651 586651 Colyns, John, of Castel Acre, husbandman 3
5344695 2458516 2458516 defendant Baker John yeoman 586651 586651 Baker, John, of Castel Acre, yeoman 0
5401940 2475614 2475614 defendant Wotton William gent 586651 586651 Wotton, William, of Castel Acre, gent 8
5441820 2487482 2487482 defendant Sobyr John miller 586651 586651 Sobyr, John, of Castel Acre, miller 0
5484497 2500281 2500281 defendant Sobre John husbandman 586651 586651 Sobre, John, of Castel Acre, husbandman 0
5553109 2520948 2520948 plaintiff Fuller William   586651 586651 Fuller, William, of Castel Acre 0
5560764 2523115 2523115 defendant Spaldyng Agnes widow 586651 586651 Spaldyng, Agnes, of Castel Acre, widow 0
5598232 2534336 2534336 defendant Hendry William laborer 586651 586651 Hendry, William, of Castel Acre, laborer 1

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