names

57 rows where place_id = 598667

✎ 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
3633483 1905286 1905286 defendant Smyth William husbandman 598667 598667 Smyth, William, of Bedyngfeld, husbandman 0
3658173 1912812 1912812 defendant Lyson John clerk & vicar 598667 598667 Lyson, John, of Bedyngfeld, clerk & vicar 0
3704746 1927773 1927773 defendant Drane Thomas yeoman 598667 598667 Drane, Thomas, of Bedyngfeld, yeoman 1
3705627 1928042 1928042 defendant Curwyn Richard husbandman 598667 598667 Curwyn, Richard, of Bedyngfeld, husbandman 2
3721025 1932872 1932872 defendant Neele Thomas husbandman 598667 598667 Neele, Thomas, of Bedyngfeld, husbandman 1
3748965 1941608 1941608 defendant Curwen John butcher 598667 598667 Curwen, John, of Bedyngfeld, butcher 2
3992287 2022008 2022008 defendant Lanham Robert yeoman 598667 598667 Lanham, Robert, of Bedyngfeld, yeoman 0
4213425 2100213 2100213 defendant Cullum Lawrence yeoman 598667 598667 Cullum, Lawrence, of Bedyngfeld, yeoman 0
4450332 2185062 2185062 defendant Cley John   598667 598667 Cley, John, of Bedyngfeld 0
4497056 2199741 2199741 defendant Cley John shoemaker 598667 598667 Cley, John, of Bedyngfeld, shoemaker 0
4501648 2201118 2201118 defendant Cullum John   598667 598667 Cullum, John, of Bedyngfeld 1
4505112 2202132 2202132 defendant Dowe John   598667 598667 Dowe, John, of Bedyngfeld 0
4505113 2202132 2202132 defendant Toke William   598667 598667 Toke, William, of Bedyngfeld 1
4505114 2202132 2202132 defendant Lopham Jacob de   598667 598667 Lopham, Jacob de, of Bedyngfeld 2
4557473 2218273 2218273 defendant Toke William   598667 598667 Toke, William, of Bedyngfeld 0
4641514 2243617 2243617 defendant Cley John   598667 598667 Cley, John, of Bedyngfeld 0
4848964 2311142 2311142 plaintiff Smyth William   598667 598667 Smyth, William, of Bedyngfeld 0
4939973 2338890 2338890 defendant Hamond Robert yeoman 598667 598667 Hamond, Robert, of Bedyngfeld, yeoman 1
4971095 2348297 2348297 defendant Toke John husbandman 598667 598667 Toke, John, of Bedyngfeld, husbandman 0
5102413 2387109 2387109 defendant Toke Roger husbandman 598667 598667 Toke, Roger, of Bedyngfeld, husbandman 0
5126907 2394347 2394347 defendant Toke William husbandman 598667 598667 Toke, William, of Bedyngfeld, husbandman 0
5137966 2397616 2397616 defendant Worleche Roger husbandman 598667 598667 Worleche, Roger, of Bedyngfeld, husbandman 0
5142518 2398939 2398939 defendant Toke William   598667 598667 Toke, William, of Bedyngfeld 1
5145609 2399858 2399858 defendant Toke William husbandman 598667 598667 Toke, William, of Bedyngfeld, husbandman 0
5163876 2405169 2405169 defendant Toke William husbandman 598667 598667 Toke, William, of Bedyngfeld, husbandman 1
5180677 2410089 2410089 defendant Toke William husbandman 598667 598667 Toke, William, of Bedyngfeld, husbandman 0
5180679 2410090 2410090 defendant Toke William husbandman 598667 598667 Toke, William, of Bedyngfeld, husbandman 0
5183916 2411032 2411032 defendant Toke John   598667 598667 Toke, John, of Bedyngfeld, glove maker 1
5194562 2414139 2414139 defendant Worlyche Richard yeoman 598667 598667 Worlyche, Richard, of Bedyngfeld, yeoman 1
5208803 2418300 2418300 defendant Worlyche Richard yeoman 598667 598667 Worlyche, Richard, of Bedyngfeld, yeoman 1
5211462 2419086 2419086 defendant Toke William husbandman 598667 598667 Toke, William, of Bedyngfeld, husbandman 1
5226693 2423471 2423471 defendant Toke William husbandman 598667 598667 Toke, William, of Bedyngfeld, husbandman 2
5258417 2432746 2432746 defendant Pakke William husbandman 598667 598667 Pakke, William, of Bedyngfeld, husbandman 0
5327506 2453296 2453296 defendant Lincolne John (legal representative) 598667 598667 Lincolne, John, of Bedyngfeld, yeoman, executors of 0
5343092 2458027 2458027 plaintiff Smyth John   598667 598667 Smyth, John, of Bedyngfeld, son of Smyth, William 0
5343095 2458028 2458028 plaintiff Smyth John   598667 598667 Smyth, John, of Bedyngfeld, son of Smyth, William, of Bedyngfeld 0
5352240 2460799 2460799 defendant Toke William husbandman 598667 598667 Toke, William, of Bedyngfeld, husbandman 3
5411968 2478535 2478535 defendant Pakke George yeoman 598667 598667 Pakke, George, of Bedyngfeld, yeoman 1
5426518 2482879 2482879 defendant Pakke George yeoman 598667 598667 Pakke, George, of Bedyngfeld, yeoman 1
5427207 2483078 2483078 defendant Colyn Robert husbandman 598667 598667 Colyn, Robert, of Bedyngfeld, husbandman 0
5438746 2486516 2486516 defendant Toke William yeoman 598667 598667 Toke, William, of Bedyngfeld, yeoman 1
5451742 2490395 2490395 defendant Toke William yeoman 598667 598667 Toke, William, of Bedyngfeld, yeoman 1
5464580 2494324 2494324 defendant Toke William yeoman 598667 598667 Toke,William, of Bedyngfeld, yeoman 1
5476091 2497862 2497862 defendant Toke (illegible) yeoman 598667 598667 Toke, _, of Bedyngfeld, yeoman 1
5505041 2506487 2506487 defendant Pakke George yeoman 598667 598667 Pakke, George, of Bedyngfeld, yeoman 0
5505408 2506606 2506606 defendant Worlych Robert husbandman 598667 598667 Worlych, Robert, of Bedyngfeld, husbandman 0
5519111 2510824 2510824 defendant Pakke George yeoman 598667 598667 Pakke, George, of Bedyngfeld, yeoman 0
5519112 2510824 2510824 defendant Pakke George, junior husbandman 598667 598667 Pakke, George, junior, of Bedyngfeld, husbandman 1
5519114 2510825 2510825 defendant Pakke George, senior yeoman 598667 598667 Pakke, George, senior, of Bedyngfeld, yeoman 0
5519115 2510825 2510825 defendant Pakke George, junior husbandman 598667 598667 Pakke, George, junior, of Bedyngfeld, husbandman 1
5538968 2516675 2516675 defendant Jenour Robert yeoman 598667 598667 Jenour, Robert, of Bedyngfeld, yeoman 4
5540831 2517264 2517264 defendant Jenour Robert yeoman 598667 598667 Jenour, Robert, of Bedyngfeld, yeoman 0
5564823 2524294 2524294 defendant Worlyche Robert husbandman 598667 598667 Worlyche, Robert, of Bedyngfeld, husbandman 3
5573520 2526817 2526817 defendant Lysson John clerk 598667 598667 Lysson, John, of Bedyngfeld, clerk 0
5595262 2533468 2533468 defendant Lysson John clerk 598667 598667 Lysson, John, of Bedyngfeld, clerk 2
5633983 2554610 2554610 defendant Bedyngfeld William   598667 598667 Bedyngfeld, William, of Bedyngfeld, husbandman, son of Alice Bedyngfeld 0
5633984 2554610 2554610 defendant Brond John laborer 598667 598667 Brond, John, of Bedyngfeld, 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);