names

49 rows where place_id = 626174

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3768445 1947779 1947779 defendant Holley Robert husbandman 626174 626174 Holley, Robert, of Wodenorton, husbandman 0
3768447 1947780 1947780 defendant Sympton Robert yeoman 626174 626174 Sympton, Robert, of Wodenorton, yeoman 0
3855290 1975290 1975290 defendant Holley Andrew husbandman 626174 626174 Holley, Andrew, of Wodenorton, husbandman 0
3861512 1977312 1977312 defendant Symton Robert husbandman 626174 626174 Symton, Robert, of Wodenorton, husbandman 0
4559260 2218850 2218850 defendant Makhayt Simon   626174 626174 Makhayt, Simon, of Wodenorton 0
4657519 2248243 2248243 defendant Bulman John yeoman 626174 626174 Bulman, John, of Wodenorton, yeoman 3
4658234 2248456 2248456 defendant Frost William husbandman 626174 626174 Frost, William, of Wodenorton, husbandman 0
4685277 2260991 2260991 defendant Bulman Lawrence yeoman 626174 626174 Bulman, Lawrence, of Wodenorton, yeoman 0
4685278 2260991 2260991 defendant Bulman William yeoman 626174 626174 Bulman, William, of Wodenorton, yeoman 1
4685279 2260991 2260991 defendant Bulman John yeoman 626174 626174 Bulman, John, of Wodenorton, yeoman 2
4819186 2302080 2302080 defendant Bulman William yeoman 626174 626174 Bulman, William, of Wodenorton, yeoman 0
4861770 2315053 2315053 defendant Botelers Roger laborer 626174 626174 Botelers, Roger, of Wodenorton, laborer 4
4867725 2316877 2316877 defendant Collys John laborer 626174 626174 Collys, John, of Wodenorton, laborer 0
4867726 2316877 2316877 defendant Bulman Thomas laborer 626174 626174 Bulman, Thomas, of Wodenorton, laborer 1
4867727 2316877 2316877 defendant Bulman William laborer 626174 626174 Bulman, William, of Wodenorton, laborer 2
4867733 2316879 2316879 defendant Pampe John husbandman 626174 626174 Pampe, John, of Wodenorton, husbandman 0
4867734 2316879 2316879 defendant Byntre William husbandman 626174 626174 Byntre, William, of Wodenorton, husbandman 1
4867735 2316879 2316879 defendant Cosyn Thomas, senior husbandman 626174 626174 Cosyn, Thomas, senior, of Wodenorton, husbandman 2
4867736 2316879 2316879 defendant Smyth Richard husbandman 626174 626174 Smyth, Richard, of Wodenorton, husbandman 3
4867737 2316879 2316879 defendant Cosyn Thomas, junior husbandman 626174 626174 Cosyn, Thomas, junior, of Wodenorton, husbandman 4
4867738 2316879 2316879 defendant Skowele Thomas husbandman 626174 626174 Skowele, Thomas, of Wodenorton, husbandman 5
4867739 2316879 2316879 defendant Skowele Robert husbandman 626174 626174 Skowele, Robert, of Wodenorton, husbandman 6
4873640 2318695 2318695 defendant Bulman William yeoman 626174 626174 Bulman, William, of Wodenorton, yeoman 1
4902459 2327384 2327384 defendant Holle John husbandman 626174 626174 Holle, John, of Wodenorton, husbandman 0
5001767 2357412 2357412 defendant Crane John esq 626174 626174 Crane, John, of Wodenorton, esq 0
5024349 2364038 2364038 plaintiff Holle Thomas   626174 626174 Holle, Thomas, of Wodenorton 0
5031059 2365958 2365958 defendant Ulffe John husbandman 626174 626174 Ulffe, John, of Wodenorton, husbandman 0
5031060 2365958 2365958 defendant Souter Adam husbandman 626174 626174 Souter, Adam, of Wodenorton, husbandman 1
5258803 2432873 2432873 defendant Dokkyng Edmund gent 626174 626174 Dokkyng, Edmund, of Wodenorton, gent 0
5275072 2437789 2437789 defendant Holley Robert husbandman 626174 626174 Holley, Robert, of Wodenorton, husbandman 2
5277710 2438567 2438567 defendant Holle William yeoman 626174 626174 Holle, William, of Wodenorton, yeoman 1
5277934 2438634 2438634 defendant Holley Robert husbandman 626174 626174 Holley, Robert, of Wodenorton, husbandman 1
5286960 2441192 2441192 defendant Holley Robert yeoman 626174 626174 Holley, Robert, of Wodenorton, yeoman 0
5286962 2441193 2441193 defendant Holley Robert yeoman 626174 626174 Holley, Robert, of Wodenorton, yeoman 0
5293001 2442941 2442941 defendant Holley Robert husbandman 626174 626174 Holley, Robert, of Wodenorton, husbandman 3
5345827 2458834 2458834 defendant Holle William husbandman 626174 626174 Holle, William, of Wodenorton, husbandman 1
5345836 2458835 2458835 defendant Holle William husbandman 626174 626174 Holle, William, of Wodenorton, husbandman 1
5358364 2462668 2462668 defendant Holl William turner 626174 626174 Holl, William, of Wodenorton, turner 0
5358365 2462668 2462668 defendant Holl Richard turner 626174 626174 Holl, Richard, of Wodenorton, turner 1
5449705 2489800 2489800 defendant (illegible) Thomas husbandman 626174 626174 _, Thomas, of Wodenorton, husbandman 0
5479216 2498803 2498803 defendant Holley William husbandman 626174 626174 Holley, William, of Wodenorton, husbandman 5
5480577 2499165 2499165 defendant Holle William yeoman 626174 626174 Holle, William, of Wodenorton, yeoman 3
5480598 2499166 2499166 defendant Holle William yeoman 626174 626174 Holle, William, of Wodenorton, yeoman 11
5507898 2507369 2507369 defendant Souter Adam (legal representative) 626174 626174 Souter, Adam, of Wodenorton, husbandman, executor of 2
5544823 2518490 2518490 defendant Lamberd William husbandman 626174 626174 Lamberd, William, of Wodenorton, husbandman 2
5585965 2530662 2530662 defendant Geys Robert husbandman 626174 626174 Geys, Robert, of Wodenorton, husbandman 6
5600624 2535086 2535086 defendant Sheryngham John yeoman 626174 626174 Sheryngham, John, of Wodenorton, yeoman 0
5605501 2536601 2536601 defendant Gees Thomas butcher 626174 626174 Gees, Thomas, of Wodenorton, butcher 0
5627722 2552639 2552639 defendant Bulman William draper 626174 626174 Bulman, William, of Wodenorton, draper 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);