names

94 rows where place_id = 602141

✎ 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
3648612 1909953 1909953 defendant Howes Stephen husbandman 602141 602141 Howes, Stephen, of Banyngham, husbandman 3
3720363 1932647 1932647 defendant Crome Robert butcher 602141 602141 Crome, Robert, of Banyngham, butcher 0
3720365 1932648 1932648 defendant Brome Robert butcher 602141 602141 Brome, Robert, of Banyngham, butcher 0
3720366 1932648 1932648 defendant Budde John widower 602141 602141 Budde, John, of Banyngham, husbandman, widower 1
3750874 1942194 1942194 defendant Emondes Simon draper 602141 602141 Emondes, Simon, of Banyngham, draper 0
3766928 1947321 1947321 defendant Howse Thomas butcher 602141 602141 Howse, Thomas, of Banyngham, butcher 0
3766929 1947321 1947321 defendant Crome Robert butcher 602141 602141 Crome, Robert, of Banyngham, butcher 1
3779501 1951312 1951312 plaintiff Emondys Simon   602141 602141 Emondys, Simon, of Banyngham, wool chapman 0
3842717 1971254 1971254 defendant Anseley George husbandman 602141 602141 Anseley, George, of Banyngham, husbandman 1
3866582 1979050 1979050 plaintiff Pulle Agnes (legal representative) 602141 602141 Pulle, Agnes, of Banyngham, widow, executor of 0
3866584 1979050 1979050 defendant Pulle Stephen pedder 602141 602141 Pulle, Stephen, of Banyngham, pedder 0
3879615 1983435 1983435 plaintiff Neve William   602141 602141 Neve, William, of Banyngham 0
3879616 1983435 1983435 defendant Goodyer William   602141 602141 Goodyer, William, of Banyngham, worsted weaver 0
3928025 1999708 1999708 defendant Hovest John yeoman 602141 602141 Hovest, John, of Banyngham, yeoman 12
4438432 2181310 2181310 defendant Skot John   602141 602141 Skot, John, of Banyngham 1
4438748 2181411 2181411 defendant Froyse Martin   602141 602141 Froyse, Martin, of Banyngham 0
4438749 2181411 2181411 defendant Smyth Richard   602141 602141 Smyth, Richard, of Banyngham 1
4500513 2200782 2200782 defendant Godewen John carpenter 602141 602141 Godewen, John, of Banyngham, carpenter 0
4504380 2201921 2201921 defendant Godewyn John carpenter 602141 602141 Godewyn, John, of Banyngham, carpenter 1
4525148 2208207 2208207 defendant Burgh Simon   602141 602141 Burgh, Simon, of Banyngham 1
4602904 2232123 2232123 defendant Ryston William   602141 602141 Ryston, William, of Banyngham 0
4634475 2241630 2241630 defendant Edys John   602141 602141 Edys, John, of Banyngham 2
4663159 2249944 2249944 defendant Lyon Adam butcher 602141 602141 Lyon, Adam, of Banyngham, butcher 0
4677577 2258601 2258601 defendant Burgh Simon gent 602141 602141 Burgh, Simon, of Banyngham, gent 0
4677578 2258601 2258601 defendant Westgate William, junior yeoman 602141 602141 Westgate, William, junior, of Banyngham, yeoman 1
4685290 2260995 2260995 defendant Lyoun Adam butcher 602141 602141 Lyoun, Adam, of Banyngham, butcher 1
4686385 2261347 2261347 defendant Lyon Adam butcher 602141 602141 Lyon, Adam, of Banyngham, butcher 0
4707716 2267779 2267779 defendant Foy William yeoman 602141 602141 Foy, William, of Banyngham, yeoman 2
4712131 2269106 2269106 defendant Burgh Simon gent 602141 602141 Burgh, Simon, of Banyngham, gent 0
4724686 2273018 2273018 defendant Lyon Adam butcher 602141 602141 Lyon, Adam, of Banyngham, butcher 1
4724689 2273019 2273019 defendant Lyon Adam butcher 602141 602141 Lyon, Adam, of Banyngham, butcher 1
4724693 2273020 2273020 defendant Lyon Adam butcher 602141 602141 Lyon, Adam, of Banyngham, butcher 1
4742513 2278311 2278311 defendant Lyon Adam yeoman 602141 602141 Lyon, Adam, of Banyngham, yeoman 0
4744340 2278868 2278868 defendant Hoberd William pedder 602141 602141 Hoberd, William, of Banyngham, pedder 0
4751452 2280907 2280907 defendant Lyon Adam yeoman 602141 602141 Lyon, Adam, of Banyngham, yeoman 1
4775311 2288270 2288270 defendant Wodegate William laborer 602141 602141 Wodegate, William, of Banyngham, laborer 2
4797042 2295238 2295238 defendant Lyon Adam yeoman 602141 602141 Lyon, Adam, of Banyngham, yeoman 0
4825104 2303894 2303894 defendant Bekker Ralph   602141 602141 Bekker, Ralph, of Banyngham 0
4839855 2308376 2308376 defendant Large Ralph yeoman 602141 602141 Large, Ralph, of Banyngham, yeoman 0
4857490 2313732 2313732 defendant Stampe John husbandman 602141 602141 Stampe, John, of Banyngham, husbandman 0
4857491 2313732 2313732 defendant Pulle John husbandman 602141 602141 Pulle, John, of Banyngham, husbandman 1
4900896 2326909 2326909 defendant Stamp John husbandman 602141 602141 Stamp, John, of Banyngham, husbandman 1
5030535 2365802 2365802 defendant Wysdam Thomas laborer 602141 602141 Wysdam, Thomas, of Banyngham, laborer 1
5032959 2366526 2366526 defendant Coke Henry laborer 602141 602141 Coke, Henry, of Banyngham, laborer 0
5050641 2371820 2371820 defendant Dapelyn William, junior husbandman 602141 602141 Dapelyn, William, junior, of Banyngham, husbandman 0
5056159 2373416 2373416 defendant Turnour Nicholas husbandman 602141 602141 Turnour, Nicholas, of Banyngham, husbandman 4
5057066 2373692 2373692 defendant Elys Simon husbandman 602141 602141 Elys, Simon, of Banyngham, husbandman 0
5059370 2374371 2374371 defendant Turnour Nicholas turner 602141 602141 Turnour, Nicholas, of Banyngham, turner 3
5059909 2374529 2374529 defendant Elys Simon husbandman 602141 602141 Elys, Simon, of Banyngham, husbandman 1
5065208 2376130 2376130 defendant Stampe John husbandman 602141 602141 Stampe, John, of Banyngham, husbandman 0
5065209 2376130 2376130 defendant Pulle John husbandman 602141 602141 Pulle, John, of Banyngham, husbandman 1
5080185 2380563 2380563 defendant Elys Simon husbandman 602141 602141 Elys, Simon, of Banyngham, husbandman 1
5080267 2380587 2380587 defendant Crabbe John husbandman 602141 602141 Crabbe, John, of Banyngham, husbandman 3
5088121 2382902 2382902 defendant Budde Stephen yeoman 602141 602141 Budde, Stephen, of Banyngham, yeoman 2
5095289 2385040 2385040 defendant Budde Stephen yeoman 602141 602141 Budde, Stephen, of Banyngham, yeoman 0
5109026 2389058 2389058 defendant Ely Simon husbandman 602141 602141 Ely, Simon,of Banyngham, husbandman 2
5115422 2390937 2390937 defendant Turnour Nicholas husbandman 602141 602141 Turnour, Nicholas, of Banyngham, husbandman 0
5118578 2391864 2391864 defendant Stampe John husbandman 602141 602141 Stampe, John, of Banyngham, husbandman 0
5121795 2392806 2392806 defendant Turnour Nicholas turner 602141 602141 Turnour, Nicholas, of Banyngham, turner 0
5121796 2392806 2392806 defendant Elys Simon husbandman 602141 602141 Elys, Simon, of Banyngham, husbandman 1
5124262 2393543 2393543 defendant Tabbe John weaver 602141 602141 Tabbe, John, of Banyngham, weaver 6
5124316 2393558 2393558 defendant Tabbe John weaver 602141 602141 Tabbe, John, of Banyngham, weaver 5
5124621 2393674 2393674 defendant Elys Simon husbandman 602141 602141 Elys, Simon, of Banyngham, husbandman 2
5139137 2397940 2397940 defendant Elys Simon husbandman 602141 602141 Elys, Simon, of Banyngham, husbandman 2
5146355 2400067 2400067 defendant Turnour Nicholas husbandman 602141 602141 Turnour, Nicholas, of Banyngham, husbandman 1
5146546 2400128 2400128 defendant Heron Edmund yeoman 602141 602141 Heron, Edmund, of Banyngham, yeoman 0
5164516 2405355 2405355 defendant Elys Simon   602141 602141 Elys, Simon, of Banyngham 2
5182338 2410590 2410590 defendant Heron Edmund yeoman 602141 602141 Heron, Edmund, of Banyngham, yeoman 0
5182339 2410590 2410590 defendant Turnour Nicholas turner 602141 602141 Turnour, Nicholas, of Banyngham, turner 1
5198555 2415333 2415333 defendant Barker Henry   602141 602141 Barker, Henry, of Banyngham, mason 0
5203329 2416737 2416737 defendant Heron Edmund husbandman 602141 602141 Heron, Edmund, of Banyngham, husbandman 0
5203330 2416737 2416737 defendant Turnour Nicholas turner 602141 602141 Turnour, Nicholas, of Banyngham, turner 1
5210607 2418841 2418841 defendant Barker Henry   602141 602141 Barker, Henry, of Banyngham, mason 0
5220857 2421792 2421792 defendant Brynyng John husbandman 602141 602141 Brynyng, John, of Banyngham, husbandman 0
5225719 2423193 2423193 defendant Goneld Richard clerk 602141 602141 Goneld, Richard, of Banyngham, clerk 0
5225721 2423194 2423194 defendant Goneld Richard clerk 602141 602141 Goneld, Richard, of Banyngham, clerk 0
5239997 2427274 2427274 defendant Cates John yeoman 602141 602141 Cates, John, of Banyngham, yeoman 1
5245474 2428832 2428832 defendant Cadys John husbandman 602141 602141 Cadys, John, of Banyngham, husbandman 0
5247508 2429424 2429424 defendant Turnour Nicholas yeoman 602141 602141 Turnour, Nicholas, of Banyngham, yeoman 1
5249171 2429879 2429879 defendant Turnour Nicholas husbandman 602141 602141 Turnour, Nicholas, of Banyngham, husbandman 0
5251536 2430584 2430584 defendant Camond William clerk 602141 602141 Camond, William, of Banyngham, clerk 4
5258292 2432713 2432713 defendant Smyth Roger shoemaker 602141 602141 Smyth, Roger, of Banyngham, shoemaker 0
5270192 2436382 2436382 defendant Elyce Simon husbandman 602141 602141 Elyce, Simon, of Banyngham, husbandman 6
5279371 2439054 2439054 defendant Gryme Gregory husbandman 602141 602141 Gryme, Gregory, of Banyngham, husbandman 2
5302164 2445604 2445604 defendant Hoberd Robert   602141 602141 Hoberd, Robert, of Banyngham, pedlar 0
5302233 2445629 2445629 defendant Smyth Roger husbandman 602141 602141 Smyth, Roger, of Banyngham, husbandman 0
5304060 2446219 2446219 defendant Miller Henry   602141 602141 Miller, Henry, of Banyngham, mason 2
5322217 2451714 2451714 defendant Turnour Nicholas turner 602141 602141 Turnour, Nicholas, of Banyngham, turner 3
5361103 2463499 2463499 defendant Trydcok John husbandman 602141 602141 Trydcok, John, of Banyngham, husbandman 3
5382317 2470000 2470000 defendant Barker Henry husbandman 602141 602141 Barker, Henry, of Banyngham, husbandman 4
5391320 2472598 2472598 defendant Barker Henry husbandman 602141 602141 Barker, Henry, of Banyngham, husbandman 3
5493526 2502977 2502977 defendant Miller alias Mosens Henry, senior husbandman 602141 602141 Miller alias Mosens, Henry, senior, of Banyngham, husbandman 1
5616159 2548847 2548847 defendant Kemyng John   602141 602141 Kemyng, John, of Banyngham, administrators of 0
5629992 2553381 2553381 defendant Lyoun Adam butcher 602141 602141 Lyoun, Adam, of Banyngham, butcher 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);