names

83 rows where place_id = 780959

✎ 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
4670469 2256448 2256448 defendant Wodyer John skinner 780959 780959 Wodyer, John, of Hereford, Herefs, skinner 0
4672921 2257170 2257170 defendant Ruyhale Edmund clerk 780959 780959 Ruyhale, Edmund, of Hereford, Herefs, clerk 0
4676189 2258165 2258165 defendant Brydbrok John clerk 780959 780959 Brydbrok, John, of Hereford, Herefs, clerk 0
4676929 2258402 2258402 defendant Mortemer Rose gentlewoman 780959 780959 Mortemer, Rose, of Hereford, Herefs, gentlewoman 0
4680393 2259483 2259483 defendant Falk Richard husbandman 780959 780959 Falk, Richard, of Hereford, Herefs, husbandman 0
4683995 2260602 2260602 defendant Penbroke John loder 780959 780959 Penbroke, John, of Hereford, Herefs, loder 1
4718484 2271122 2271122 defendant Crompe Thomas pardoner 780959 780959 Crompe, Thomas, of Hereford, Herefs, pardoner 0
4719203 2271357 2271357 defendant Hemmyng William clerk 780959 780959 Hemmyng, William, of Hereford, Herefs, clerk 0
4724375 2272920 2272920 defendant Somerset Thomas chapman 780959 780959 Somerset, Thomas, of Hereford, Herefs, chapman 1
4724379 2272921 2272921 defendant Somerset Thomas chapman 780959 780959 Somerset, Thomas, of Hereford, Herefs, chapman 1
4727537 2273852 2273852 defendant Dyer Thomas dyer 780959 780959 Dyer, Thomas, of Hereford, Herefs, dyer 2
4728872 2274268 2274268 defendant Gregory John baker 780959 780959 Gregory, John, of Hereford, Herefs, baker 0
4740994 2277877 2277877 defendant Mey John gent 780959 780959 Mey, John, of Hereford, Herefs, gent 0
4742455 2278293 2278293 defendant Drapere David draper 780959 780959 Drapere, David, of Hereford, Herefs, draper 0
4746608 2279499 2279499 defendant Dyer Thomas dyer 780959 780959 Dyer, Thomas, of Hereford, Herefs, dyer 2
4750843 2280729 2280729 defendant Straunge Richard esq 780959 780959 Straunge, Richard, of Hereford, Herefs, esq 0
4754003 2281636 2281636 defendant Hachewey John dyer 780959 780959 Hachewey, John, of Hereford, Herefs, dyer 2
4756628 2282438 2282438 defendant Draper David draper 780959 780959 Draper, David, of Hereford, Herefs, draper 1
4764337 2284842 2284842 defendant Cornewaill William gent 780959 780959 Cornewaill, William, of Hereford, Herefs, gent 0
4768955 2286270 2286270 defendant Langham Maurice chapman 780959 780959 Langham, Maurice, of Hereford, Herefs, chapman 1
4770232 2286664 2286664 defendant Nowell Thomas chapman 780959 780959 Nowell, Thomas, of Hereford, Herefs, chapman 2
4770332 2286692 2286692 defendant Morys Edmund gent 780959 780959 Morys, Edmund, of Hereford, Herefs, gent 1
4774013 2287856 2287856 defendant Norton Stephen chapman 780959 780959 Norton, Stephen, of Hereford, Herefs, chapman 0
4806036 2298098 2298098 defendant Steven John salder 780959 780959 Steven, John, of Hereford, Herefs, salder 2
4807245 2298466 2298466 defendant Baynham Robert gent 780959 780959 Baynham, Robert, of Hereford, Herefs, gent 3
4810311 2299369 2299369 defendant Hemmyng William clerk 780959 780959 (Hemmyng, William, of Hereford, Herefs, clerk 1
4811069 2299570 2299570 defendant Saundres John clerk 780959 780959 Saundres, John, of Hereford, Herefs, clerk 1
4815506 2300955 2300955 defendant Purveour Nicholas chapman 780959 780959 Purveour, Nicholas, of Hereford, Herefs, chapman 0
4816316 2301189 2301189 defendant Byryton William husbandman 780959 780959 Byryton, William, of Hereford, Herefs, husbandman 1
4821468 2302800 2302800 defendant Strange Richard esq 780959 780959 Strange, Richard, of Hereford, Herefs, esq 0
4823591 2303469 2303469 defendant Now--- Henry chapman 780959 780959 Now---, Henry, of Hereford, Herefs, chapman 0
4823593 2303470 2303470 defendant Nowell Henry chapman 780959 780959 Nowell, Henry, of Hereford, Herefs, chapman 0
4823691 2303500 2303500 defendant Coleys Richard chapman 780959 780959 Coleys, Richard, of Hereford, Herefs, chapman 4
4826668 2304374 2304374 defendant Elys Thomas chapman 780959 780959 Elys, Thomas, of Hereford, Herefs, chapman 2
4826673 2304375 2304375 defendant Elys Thomas chapman 780959 780959 Elys, Thomas, of Hereford, Herefs, chapman 2
4833714 2306554 2306554 defendant Berowe John clerk 780959 780959 Berowe, John, of Hereford, Herefs, clerk 0
4833718 2306555 2306555 defendant Derowe John clerk 780959 780959 Derowe, John, of Hereford, Herefs, clerk 0
4837399 2307635 2307635 defendant Massy David chapman 780959 780959 Massy, David, of Hereford, Herefs, chapman 0
4837403 2307636 2307636 defendant Massy David chapman 780959 780959 Massy, David, of Hereford, Herefs, chapman 0
4840438 2308546 2308546 defendant Jones Philip carrier 780959 780959 Jones, Philip, of Hereford, Herefs, carrier 3
4841317 2308820 2308820 defendant Lye David carrier 780959 780959 Lye, David, of Hereford, Herefs, carrier 1
4843611 2309524 2309524 defendant Ree William gent 780959 780959 Ree, William, of Hereford, Herefs, gent 0
4850983 2311756 2311756 defendant Wermestre John husbandman 780959 780959 Wermestre, John, of Hereford, Herefs, husbandman 1
4852211 2312121 2312121 defendant Nowell Henry mercer 780959 780959 Nowell, Henry, of Hereford, Herefs, mercer 0
4852607 2312236 2312236 defendant Logard William clerk 780959 780959 (Logard, William, of Hereford, Herefs, clerk 5
4852935 2312341 2312341 defendant Elys Thomas yeoman 780959 780959 Elys, Thomas, of Hereford, Herefs, yeoman 0
4927427 2335010 2335010 defendant Verbum Thomas husbandman & apothecary 780959 780959 Verbum, Thomas, of Hereford, Herefs, husbandman & apothecary 0
4932961 2336697 2336697 defendant More Roger   780959 780959 More, Roger, of Hereford, Herefs, mason 1
4990313 2354012 2354012 defendant Assheby John clerk 780959 780959 Assheby, John, of Hereford, Herefs, clerk 0
4993170 2354837 2354837 defendant Hayward William gent 780959 780959 Hayward, William, of Hereford, Herefs, gent 0
4999141 2356620 2356620 defendant Taylour Richard tailor 780959 780959 Taylour, Richard, of Hereford, Herefs, tailor 0
5008727 2359442 2359442 defendant Bursgawd John yeoman 780959 780959 Bursgawd, John, of Hereford, Herefs, yeoman 2
5011747 2360286 2360286 plaintiff Wodward John (legal representative) 780959 780959 Wodward, John, of Hereford, Herefs, merchant, executor of 0
5131986 2395841 2395841 defendant Rufford Alice widow 780959 780959 Rufford, Alice, of Hereford, Herefs, widow 0
5151559 2401606 2401606 defendant Rufford Alice widow 780959 780959 Rufford, Alice, of Hereford, Herefs, widow 0
5151561 2401607 2401607 defendant Rufford Alice widow 780959 780959 Rufford, Alice, of Hereford, Herefs, widow 0
5151963 2401711 2401711 defendant Personys John draper 780959 780959 Personys, John, of Hereford, Herefs, draper 3
5151971 2401712 2401712 defendant Personys John draper 780959 780959 Personys, John, of Hereford, Herefs, draper 3
5153188 2402079 2402079 defendant Berowe John clerk 780959 780959 Berowe, John, of Hereford, Herefs, clerk 0
5157627 2403359 2403359 defendant ap Wylcoke David husbandman 780959 780959 ap Wylcoke, David, of Hereford, Herefs, husbandman 2
5169827 2406918 2406918 defendant Personys John draper 780959 780959 Personys, John, of Hereford, Herefs, draper 3
5170712 2407155 2407155 defendant Berowe John clerk 780959 780959 Berowe, John, of Hereford, Herefs, clerk 0
5186992 2411934 2411934 defendant Jonys John husbandman 780959 780959 Jonys, John, of Hereford, Herefs, husbandman 0
5188575 2412380 2412380 defendant Berowe John clerk 780959 780959 Berowe, John, of Hereford, Herefs, clerk 0
5206126 2417524 2417524 defendant Berowe John clerk 780959 780959 Berowe, John, of Hereford, Herefs, clerk 0
5269429 2436155 2436155 defendant Wygmore Walter esq 780959 780959 Wygmore, Walter, of Hereford, Herefs, esq 1
5269433 2436156 2436156 defendant Wygmore Walter esq 780959 780959 Wygmore, Walter, of Hereford, Herefs, esq 1
5271714 2436825 2436825 defendant Tanner John clerk 780959 780959 Tanner, John, of Hereford, Herefs, clerk 0
5273443 2437307 2437307 defendant Gregge John vintner 780959 780959 Gregge, John, of Hereford, Herefs, vintner 0
5304305 2446291 2446291 defendant Welford John gent 780959 780959 Welford, John, of Hereford, Herefs, gent 1
5305991 2446780 2446780 defendant Mason William merchant 780959 780959 Mason, William, of Hereford, Herefs, merchant 0
5379990 2469328 2469328 defendant Affillawe John yeoman 780959 780959 Affillawe, John, of Hereford, Herefs, yeoman 1
5383642 2470405 2470405 defendant Affyllawe John yeoman 780959 780959 Affyllawe, John, of Hereford, Herefs, yeoman 1
5383682 2470417 2470417 defendant Affillawe John yeoman 780959 780959 Affillawe, John, of Hereford, Herefs, yeoman 1
5394968 2473632 2473632 defendant Sutton Thomas woolman 780959 780959 Sutton, Thomas, of Hereford, Herefs, woolman 3
5423103 2481867 2481867 defendant Sutton Thomas woolman 780959 780959 Sutton, Thomas, of Hereford, Herefs, woolman 0
5432627 2484727 2484727 defendant Brasyer John chaplain 780959 780959 Brasyer, John, of Hereford, Herefs, chaplain 3
5440805 2487159 2487159 defendant Sutton Thomas woolman 780959 780959 Sutton, Thomas, of Hereford, Herefs, woolman 5
5443418 2487945 2487945 defendant Sutton Thomas woolman 780959 780959 Sutton, Thomas, of Hereford, Herefs, woolman 0
5453747 2491014 2491014 defendant Jordan Thomas   780959 780959 Jordan, Thomas, of Hereford, Herefs 0
5457138 2492032 2492032 defendant Michell John yeoman 780959 780959 Michell, John, of Hereford, Herefs, yeoman 0
5468917 2495632 2495632 defendant Hosteler Richard yeoman 780959 780959 Hosteler, Richard, of Hereford, Herefs, yeoman 1
5468930 2495635 2495635 defendant Osteler Richard yeoman 780959 780959 Osteler, Richard, of Hereford, Herefs, yeoman 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);