names

49 rows where place_id = 588646

✎ 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
3595148 1866113 1866113 defendant Mellys James yeoman 588646 588646 Mellys, James, of Glemysford, yeoman 2
3598030 1867008 1867008 defendant Rogyll William gent 588646 588646 Rogyll, William, of Glemysford, gent 2
3687196 1922172 1922172 defendant Leche William husbandman 588646 588646 Leche, William, of Glemysford, husbandman 1
3687949 1922390 1922390 defendant Gardyner John baker 588646 588646 Gardyner, John, of Glemysford, baker 0
3694942 1924628 1924628 defendant Isak Peter smith 588646 588646 Isak, Peter, of Glemysford, smith 0
3708201 1928859 1928859 plaintiff Mundys John clothmaker 588646 588646 Mundys, John, of Glemysford, clothmaker 0
3761482 1945603 1945603 defendant Manwood William clothmaker 588646 588646 Manwood, William, of Glemysford, clothmaker 0
3800792 1958161 1958161 plaintiff Manwood Richard clothmaker 588646 588646 Manwood, Richard, of Glemysford, clothmaker 0
3803349 1958946 1958946 defendant Haxall John husbandman 588646 588646 Haxall, John, of Glemysford, husbandman 0
3803350 1958946 1958946 defendant Smethe Thomas husbandman 588646 588646 Smethe, Thomas, of Glemysford, husbandman 1
3803351 1958946 1958946 defendant Dister George husbandman 588646 588646 Dister, George, of Glemysford, husbandman 2
3803352 1958946 1958946 defendant Hedgeman Thomas husbandman 588646 588646 Hedgeman, Thomas, of Glemysford, husbandman 3
3821392 1964585 1964585 defendant Manwood James yeoman 588646 588646 Manwood, James, of Glemysford, yeoman 3
3839342 1970232 1970232 defendant Marshall Nicholas sherman 588646 588646 Marshall, Nicholas, of Glemysford, sherman 1
3869545 1980057 1980057 defendant Everard John clothworker 588646 588646 Everard, John, of Glemysford, clothworker 1
3878926 1983205 1983205 defendant Manwood James yeoman 588646 588646 Manwood, James, of Glemysford, yeoman 0
3878927 1983205 1983205 defendant Manwood Robert clothmaker 588646 588646 Manwood, Robert, of Glemysford, clothmaker 1
3878928 1983205 1983205 defendant Manwood William clothmaker 588646 588646 Manwood, William, of Glemysford, clothmaker 2
3940121 2003713 2003713 defendant Goldynge John yeoman 588646 588646 Goldynge, John, of Glemysford, yeoman 0
4294213 2128005 2128005 defendant Froste George yeoman 588646 588646 Froste, George, of Glemysford, yeoman 0
4328452 2139829 2139829 defendant Willughbye Edward esq 588646 588646 Willughbye, Edward, of Glemysford, or of Itam , Kent, esq 0
4487857 2196917 2196917 defendant atte Melle John   588646 588646 atte Melle, John, of Glemysford 0
4666496 2251004 2251004 defendant Glemysford Thomas yeoman 588646 588646 Glemysford, Thomas, of Glemysford, yeoman 0
4773010 2287532 2287532 plaintiff Stubbard John clerk 588646 588646 Stubbard, John, of Glemysford, clerk 0
4773015 2287533 2287533 plaintiff Stubbard John clerk 588646 588646 Stubbard, John, of Glemysford, clerk 0
4893675 2324717 2324717 defendant Rote Richard weaver 588646 588646 Rote, Richard, of Glemysford, weaver 0
4915216 2331265 2331265 defendant Letton Ralph husbandman 588646 588646 Letton, Ralph, of Glemysford, husbandman 2
5005620 2358541 2358541 defendant Letton Ralph   588646 588646 Letton, Ralph, of Glemysford 3
5024317 2364030 2364030 plaintiff Holdeyn John   588646 588646 Holdeyn, John, of Glemysford 0
5032010 2366236 2366236 plaintiff Rote Richard   588646 588646 Rote, Richard, of Glemysford 0
5032013 2366236 2366236 defendant Gardyner John sshoemaker 588646 588646 Gardyner, John, of Glemysford, sshoemaker 2
5067768 2376861 2376861 plaintiff Panell William   588646 588646 Panell, William, of Glemysford 0
5086686 2382497 2382497 defendant Gamelyn Richard husbandman 588646 588646 Gamelyn, Richard, of Glemysford, husbandman 0
5086687 2382497 2382497 defendant Wright John husbandman 588646 588646 Wright, John, of Glemysford, husbandman 1
5087877 2382834 2382834 defendant Panell William yeoman 588646 588646 Panell, William, of Glemysford, yeoman 0
5090167 2383496 2383496 defendant Halle Robert barker 588646 588646 Halle, Robert, of Glemysford, barker 1
5116605 2391290 2391290 plaintiff Panell William   588646 588646 Panell, William, of Glemysford 0
5116606 2391290 2391290 defendant Lane John cutler 588646 588646 Lane, John, of Glemysford, cutler 0
5116607 2391290 2391290 defendant Smyth John weaver 588646 588646 Smyth, John, of Glemysford, weaver 1
5116608 2391290 2391290 defendant Gerold William laborer 588646 588646 Gerold, William, of Glemysford, laborer 2
5116609 2391290 2391290 defendant Crosse William weaver 588646 588646 Crosse, William, of Glemysford, weaver 3
5116610 2391290 2391290 defendant Cristemasse William laborer 588646 588646 Cristemasse, William, of Glemysford, laborer 4
5258120 2432658 2432658 plaintiff Goldyng Thomas   588646 588646 Goldyng, Thomas, of Glemysford 0
5271629 2436799 2436799 defendant Crosse John butcher 588646 588646 Crosse, John, of Glemysford, butcher 0
5271633 2436799 2436799 defendant Halle Robert butcher 588646 588646 Halle, Robert, of Glemysford, butcher 4
5358445 2462693 2462693 defendant Panell John yeoman 588646 588646 Panell, John, of Glemysford, yeoman 1
5365480 2464878 2464878 defendant Crosse William husbandman 588646 588646 Crosse, William, of Glemysford, husbandman 0
5365481 2464878 2464878 defendant Stokys Richard smith 588646 588646 Stokys, Richard, of Glemysford, smith 1
5574850 2527215 2527215 defendant Manhood Agnes widow 588646 588646 Manhood, Agnes, of Glemysford, widow 2

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