names

57 rows where place_id = 588133

✎ 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
3593474 1865593 1865593 defendant Bemont John husbandman 588133 588133 Bemont, John, of Cokeley, husbandman 2
3593475 1865593 1865593 defendant Dorman Richard husbandman 588133 588133 Dorman, Richard, of Cokeley, husbandman 3
3604958 1869214 1869214 defendant Chamberleyn William husbandman 588133 588133 Chamberleyn, William, of Cokeley, husbandman 0
3738416 1938222 1938222 plaintiff More Henry   588133 588133 More, Henry, of Cokeley 0
3738417 1938222 1938222 defendant Sepens Hamo husbandman 588133 588133 Sepens, Hamo, of Cokeley, husbandman 0
3743025 1939665 1939665 defendant Sparke William sawyer 588133 588133 Sparke, William, of Cokeley, sawyer 2
3768371 1947751 1947751 defendant Sepens Hamon husbandman 588133 588133 Sepens, Hamon, of Cokeley, husbandman 0
3844065 1971689 1971689 defendant Lambe Richard husbandman 588133 588133 Lambe, Richard, of Cokeley, husbandman 1
3844550 1971834 1971834 defendant Symson Henry clerk 588133 588133 Symson, Henry, of Cokeley, clerk 1
3846064 1972328 1972328 defendant Pyn Thomas shoemaker 588133 588133 Pyn, Thomas, of Cokeley, shoemaker 0
3848380 1973071 1973071 defendant Mellys John husbandman 588133 588133 Mellys, John, of Cokeley, husbandman 0
3886041 1985582 1985582 defendant Burtour Richard clerk 588133 588133 Burtour, Richard, of Cokeley, clerk 0
3888588 1986442 1986442 defendant Melles John husbandman 588133 588133 Melles, John, of Cokeley, husbandman 1
3888589 1986442 1986442 defendant Burward Hugh husbandman 588133 588133 Burward, Hugh, of Cokeley, husbandman 2
4040652 2039153 2039153 plaintiff Moore Henry yeoman 588133 588133 Moore, Henry, of Cokeley, yeoman 0
4639992 2243202 2243202 defendant Rendelesham Richard   588133 588133 Rendelesham, Richard, of Cokeley 0
4679531 2259214 2259214 defendant Fullere Robert fuller 588133 588133 Fullere, Robert, of Cokeley, fuller 0
4889547 2323527 2323527 defendant Cobbe Henry husbandman 588133 588133 Cobbe, Henry, of Cokeley, husbandman 1
4891878 2324193 2324193 defendant Cobbe Henry husbandman 588133 588133 Cobbe, Henry, of Cokeley, husbandman 1
4919282 2332540 2332540 defendant Lound Thomas husbandman 588133 588133 Lound, Thomas, of Cokeley, husbandman 0
4919283 2332540 2332540 defendant Cobbe Henry painter 588133 588133 Cobbe, Henry, of Cokeley, painter 1
4929564 2335659 2335659 defendant Smethesson Robert yeoman 588133 588133 Smethesson, Robert, of Cokeley, yeoman 0
4929565 2335659 2335659 defendant Spachet Thomas yeoman 588133 588133 Spachet, Thomas, of Cokeley, yeoman 1
4944976 2340416 2340416 defendant Cobbe Henry yeoman 588133 588133 Cobbe, Henry, of Cokeley, yeoman 0
4981452 2351368 2351368 defendant Smethisson Robert yeoman 588133 588133 Smethisson, Robert, of Cokeley, yeoman 2
5041476 2369055 2369055 defendant Smethesson Robert yeoman 588133 588133 Smethesson, Robert, of Cokeley, yeoman 0
5041478 2369055 2369055 defendant Chaumbleyn Geoffrey yeoman 588133 588133 Chaumbleyn, Geoffrey, of Cokeley, yeoman 2
5224657 2422881 2422881 defendant Knyght Robert husbandman 588133 588133 Knyght, Robert, of Cokeley, husbandman 3
5393488 2473193 2473193 defendant Wodehude John yeoman 588133 588133 Wodehude, John, of Cokeley, yeoman 1
5406191 2476849 2476849 plaintiff Spachet Henry   588133 588133 Spachet, Henry, of Cokeley 0
5406199 2476850 2476850 plaintiff Spachet Henry   588133 588133 Spachet, Henry, of Cokeley 0
5437436 2486143 2486143 plaintiff Spachet Henry   588133 588133 Spachet, Henry, of Cokeley 0
5442052 2487544 2487544 defendant Chamberleyn William   588133 588133 Chamberleyn, William, of Cokeley 3
5442053 2487544 2487544 defendant Wodeward John butcher 588133 588133 Wodeward, John, of Cokeley, butcher 4
5454795 2491358 2491358 defendant Bedyngfeld Thomas husbandman 588133 588133 Bedyngfeld, Thomas, of Cokeley, husbandman 1
5454796 2491358 2491358 defendant Sparke William husbandman 588133 588133 Sparke, William, of Cokeley, husbandman 2
5454797 2491358 2491358 defendant Chamberleyn William husbandman 588133 588133 Chamberleyn, William, of Cokeley, husbandman 3
5454798 2491358 2491358 defendant Wode John butcher 588133 588133 Wode, John, of Cokeley, butcher 4
5454799 2491358 2491358 defendant Burgharde William husbandman 588133 588133 Burgharde, William, of Cokeley, husbandman 5
5454802 2491359 2491359 defendant Bedyngfeld Thomas yeoman 588133 588133 Bedyngfeld, Thomas, of Cokeley, yeoman 1
5454803 2491359 2491359 defendant sparke William husbandman 588133 588133 sparke, William, of Cokeley, husbandman 2
5454804 2491359 2491359 defendant Chamberleyn William husbandman 588133 588133 Chamberleyn, William, of cokeley, husbandman 3
5454805 2491359 2491359 defendant Wodeherd John butcher 588133 588133 Wodeherd, John, of Cokeley, butcher 4
5454806 2491359 2491359 defendant Burgharde William husbandman 588133 588133 Burgharde, William, of Cokeley, husbandman 5
5463760 2494079 2494079 plaintiff Spachet Henry   588133 588133 Spachet, Henry, of Cokeley 0
5480960 2499260 2499260 defendant Helmye William, senior husbandman 588133 588133 Helmye, William, senior, of Cokeley, husbandman 1
5480961 2499260 2499260 defendant Kempe John husbandman 588133 588133 Kempe, John, of Cokeley, husbandman 2
5515575 2509714 2509714 defendant Wodherd John butcher 588133 588133 Wodherd, John, of Cokeley, butcher 0
5522726 2511937 2511937 defendant Helmy William, senior (legal representative) 588133 588133 Helmy, William, senior, of Cokeley, executors of 0
5522727 2511937 2511937 defendant Helmy Agnes widow 588133 588133 (Helmy, Agnes, of Cokeley, widow 1
5522728 2511937 2511937 defendant Helmy Henry laborer 588133 588133 Helmy, Henry, of Cokeley, laborer 2
5522733 2511939 2511939 defendant Helmy William, senior yeoman 588133 588133 Helmy, William, senior, of Cokeley, yeoman 1
5522736 2511939 2511939 defendant Kempe John husbandman 588133 588133 Kempe, John, of Cokeley, husbandman 4
5540189 2517058 2517058 defendant Sparke William husbandman 588133 588133 Sparke, William, of Cokeley, husbandman 1
5568401 2525304 2525304 defendant Spachet Robert husbandman 588133 588133 Spachet, Robert, of Cokeley, husbandman 0
5568403 2525305 2525305 defendant Spachet Robert husbandman 588133 588133 Spachet, Robert, of Cokeley, husbandman 0
5594506 2533262 2533262 defendant Sepens Richard husbandman 588133 588133 Sepens, Richard, of Cokeley, husbandman 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);