names

71 rows where place_id = 586559

✎ 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
3589027 1864217 1864217 defendant Russhmer Richard yeoman 586559 586559 Russhmer, Richard, of Topcroft, yeoman 0
3661399 1913838 1913838 defendant Wodeard Robert yeoman 586559 586559 Wodeard, Robert, of Topcroft, yeoman 4
3789929 1954676 1954676 defendant Goodwyn William husbandman 586559 586559 (Goodwyn, William, of Topcroft, husbandman 1
3829055 1966968 1966968 defendant Woodyard Robert yeoman 586559 586559 Woodyard, Robert, of Topcroft, yeoman 0
3835009 1968890 1968890 defendant Woodherd Robert, senior husbandman 586559 586559 Woodherd, Robert, senior, of Topcroft, husbandman 0
3865641 1978728 1978728 defendant Woodyerd Robert husbandman 586559 586559 Woodyerd, Robert, of Topcroft, husbandman 0
3894106 1988245 1988245 defendant Randolfe William butcher 586559 586559 Randolfe, William, of Topcroft, butcher 2
3959476 2010405 2010405 defendant Dynnes Robert (legal representative) 586559 586559 Dynnes, Robert, of Topcroft, yeoman, executors of 0
3983308 2018802 2018802 defendant Bemes John yeoman 586559 586559 Bemes, John, of Topcroft, yeoman 1
4035374 2037324 2037324 plaintiff Hobbard Robert weaver 586559 586559 Hobbard, Robert, of Topcroft, weaver 0
4075956 2051698 2051698 defendant Demons Thomas husbandman 586559 586559 Demons, Thomas, of Topcroft, husbandman 3
4228546 2105465 2105465 defendant Burges Richard   586559 586559 Burges, Richard, of Topcroft 3
4285829 2124983 2124983 defendant Burges Richard turner 586559 586559 Burges, Richard, of Topcroft, turner 1
4451560 2185458 2185458 defendant Gedwyn John   586559 586559 Gedwyn, John, of Topcroft 0
4474973 2192841 2192841 defendant Hakon John   586559 586559 Hakon, John, of Topcroft 0
4475759 2193091 2193091 defendant Turry John butcher 586559 586559 Turry, John, of Topcroft, butcher 0
4541564 2213256 2213256 defendant Colman John   586559 586559 Colman, John, of Topcroft 4
4542712 2213607 2213607 defendant Straunge Robert   586559 586559 Straunge, Robert, of Topcroft 0
4542714 2213608 2213608 defendant Straunge Robert   586559 586559 Straunge, Robert, of Topcroft 0
4579025 2224920 2224920 defendant Turry John   586559 586559 Turry, John, of Topcroft 1
4584081 2226440 2226440 defendant Hacoun John   586559 586559 Hacoun, John, of Topcroft 0
4599383 2231022 2231022 defendant Stowe Walter   586559 586559 Stowe, Walter, of Topcroft 5
4630664 2240499 2240499 defendant Hegham John   586559 586559 Hegham, John, of Topcroft, parson 0
4630678 2240500 2240500 defendant Heigham John   586559 586559 Heigham, John, of Topcroft, parson 0
4663155 2249942 2249942 defendant Haken John yeoman 586559 586559 Haken, John, of Topcroft, yeoman 3
4681535 2259836 2259836 defendant Palmere William pedder 586559 586559 Palmere, William, of Topcroft, bailiff, Harre, John, of Banham, pedder 1
4752084 2281091 2281091 defendant Crane William clerk 586559 586559 Crane, William, of Topcroft, clerk 8
4754622 2281829 2281829 defendant Crane Thomas   586559 586559 Crane, Thomas, of Topcroft 1
4773039 2287539 2287539 defendant Crane William clerk 586559 586559 Crane, William, of Topcroft, clerk 1
4809781 2299223 2299223 defendant Stannewe Ralph yeoman 586559 586559 Stannewe, Ralph, of Topcroft, yeoman 0
4885054 2322219 2322219 plaintiff Wodhyrd Richard   586559 586559 Wodhyrd, Richard, of Topcroft 0
4885056 2322219 2322219 plaintiff Boiley John   586559 586559 Boiley, John, of Topcroft 2
4904432 2327999 2327999 plaintiff Wodhird Robert   586559 586559 Wodhird, Robert, of Topcroft 0
4904434 2327999 2327999 plaintiff Borley John   586559 586559 Borley, John, of Topcroft 2
4982759 2351755 2351755 defendant Water Joan widow 586559 586559 Water, Joan, of Topcroft, widow 0
4983107 2351851 2351851 defendant Tyte Walter husbandman 586559 586559 Tyte, Walter, of Topcroft, husbandman 2
5085718 2382218 2382218 defendant Woderd John husbandman 586559 586559 Woderd, John, of Topcroft, husbandman 0
5085719 2382218 2382218 defendant Woderd Richard husbandman 586559 586559 Woderd, Richard, of Topcroft, husbandman 1
5124267 2393545 2393545 defendant Clyfton Robert esq 586559 586559 Clyfton, Robert, of Topcroft, esq 0
5134951 2396724 2396724 defendant Wyet Robert clerk & parson 586559 586559 Wyet, Robert, of Topcroft, clerk & parson 1
5155082 2402637 2402637 defendant Wyot Robert clerk & parson 586559 586559 Wyot, Robert, of Topcroft, clerk & parson 0
5182492 2410635 2410635 defendant Hakun John, sen husbandman 586559 586559 Hakun, John, sen, of Topcroft, husbandman 0
5203406 2416757 2416757 defendant Hakun John, sen husbandman 586559 586559 Hakun, John, sen, of Topcroft, husbandman 0
5207020 2417790 2417790 defendant Wyot Robert clerk & parson 586559 586559 Wyot, Robert, of Topcroft, clerk & parson 0
5245772 2428927 2428927 defendant Hadesle Richard clerk 586559 586559 Hadesle, Richard, of Topcroft, clerk 0
5245773 2428927 2428927 defendant Godewyn Richard yeoman 586559 586559 Godewyn, Richard, of Topcroft, yeoman 1
5325060 2452576 2452576 defendant Base John, senior   586559 586559 Base, John, senior, of Topcroft, groom 0
5325061 2452576 2452576 defendant Base John, junior   586559 586559 Base, John, junior, of Topcroft, groom 1
5331748 2454579 2454579 defendant Goldsmyth Robert husbandman 586559 586559 Goldsmyth, Robert, of Topcroft, husbandman 5
5381977 2469902 2469902 defendant Goldsmyth Robert husbandman 586559 586559 Goldsmyth, Robert, of Topcroft, husbandman 0
5384893 2470753 2470753 defendant Goldsmyth John yeoman 586559 586559 Goldsmyth, John, of Topcroft, yeoman 2
5400332 2475171 2475171 defendant Goldsmyth John husbandman 586559 586559 Goldsmyth, John, of Topcroft, husbandman 4
5400333 2475171 2475171 defendant Call Thomas husbandman 586559 586559 Call, Thomas, of Topcroft, husbandman 5
5403241 2476010 2476010 defendant Goldsmyth Robert husbandman 586559 586559 Goldsmyth, Robert, of Topcroft, husbandman 0
5413327 2478917 2478917 defendant Goldsmyth John husbandman 586559 586559 Goldsmyth, John, of Topcroft, husbandman 4
5413328 2478917 2478917 defendant Calf Thomas husbandman 586559 586559 Calf, Thomas, of Topcroft, husbandman 5
5416232 2479787 2479787 defendant Goldsmyth Robert husbandman 586559 586559 Goldsmyth, Robert, of Topcroft, husbandman 0
5416234 2479788 2479788 defendant Goldsmyth Robert husbandman 586559 586559 Goldsmyth, Robert, of Topcroft, husbandman 0
5423727 2482061 2482061 defendant Goldsmyth Robert husbandman 586559 586559 Goldsmyth, Robert, of Topcroft, husbandman 0
5428529 2483459 2483459 defendant Goldsmyth John husbandman 586559 586559 Goldsmyth, John, of Topcroft, husbandman 4
5428530 2483459 2483459 defendant Calf Thomas husbandman 586559 586559 Calf, Thomas, of Topcroft, husbandman 5
5428566 2483467 2483467 defendant Goldsmyth John husbandman 586559 586559 Goldsmyth, John, of Topcroft, husbandman 4
5438513 2486455 2486455 defendant Goldsmith Robert husbandman 586559 586559 Goldsmith, Robert, of Topcroft, husbandman 0
5455684 2491601 2491601 defendant Goldsmith Robert husbandman 586559 586559 Goldsmith, Robert, of Topcroft, husbandman 0
5512031 2508622 2508622 defendant Thakker John barker 586559 586559 Thakker, John, of Topcroft, barker 1
5554877 2521426 2521426 defendant Godewyn John yeoman 586559 586559 Godewyn, John, of Topcroft, yeoman 0
5567387 2525041 2525041 defendant Thakker John yeoman 586559 586559 Thakker, John, of Topcroft, yeoman 0
5617551 2549311 2549311 defendant Sergeant John   586559 586559 Sergeant, John, of Topcroft 0
5631344 2553805 2553805 defendant Turry John butcher 586559 586559 Turry, John, of Topcroft, butcher 1
5631350 2553806 2553806 defendant Turry John butcher 586559 586559 Turry, John, of Topcroft, butcher 1
5632659 2554233 2554233 defendant Wodherd Robert   586559 586559 Wodherd, Robert, of Topcroft 4

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