names

204 rows where place_id = 590990

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602946 1868586 1868586 defendant Tomkyns Roger husbandman 590990 590990 Tomkyns, Roger, of Newenton, husbandman 0
3651619 1910865 1910865 plaintiff Taillour William   590990 590990 Taillour, William, of Newenton 0
3671311 1917001 1917001 defendant Brown William baker 590990 590990 Brown, William, of Newenton, baker 0
3675529 1918383 1918383 defendant Ladde Peter laborer 590990 590990 Ladde, Peter, of Newenton, laborer 1
3769001 1947952 1947952 defendant Fox Robert husbandman 590990 590990 Fox, Robert, of Newenton, husbandman 1
3769002 1947952 1947952 defendant Cripis Alice widow 590990 590990 Cripis, Alice, of Newenton, widow 2
3771358 1948732 1948732 defendant Mores Alexander husbandman 590990 590990 Mores, Alexander, of Newenton, husbandman 4
3790790 1954947 1954947 defendant Kemere John butcher 590990 590990 Kemere, John, of Newenton, butcher 1
3790796 1954948 1954948 defendant Kemere John butcher 590990 590990 Kemere, John, of Newenton, butcher 1
3790803 1954949 1954949 defendant Kemere John butcher 590990 590990 Kemere, John, of Newenton, butcher 2
3790808 1954950 1954950 defendant Kymere John butcher 590990 590990 Kymere, John, of Newenton, butcher 1
3793854 1955945 1955945 defendant Carder John husbandman 590990 590990 Carder, John, of Newenton, husbandman 0
3800186 1957978 1957978 defendant Jenkyns John yeoman 590990 590990 Jenkyns, John, of Newenton, yeoman 1
3801765 1958447 1958447 defendant Parke John husbandman 590990 590990 Parke, John, of Newenton, husbandman 2
3842905 1971314 1971314 defendant Hollowey Thomas husbandman 590990 590990 Hollowey, Thomas, of Newenton, husbandman 4
3884185 1984976 1984976 defendant Carder John husbandman 590990 590990 Carder, John, of Newenton, husbandman 0
3891019 1987260 1987260 defendant Fremlyn Gilbert yeoman 590990 590990 Fremlyn, Gilbert, of Newenton, yeoman 0
3891868 1987533 1987533 plaintiff Lyghe George   590990 590990 Lyghe, George, of Newenton 0
3926877 1999322 1999322 defendant Frenlyn Gilbert   590990 590990 Frenlyn, Gilbert, of Newenton 0
3997970 2024034 2024034 defendant Nychols John husbandman 590990 590990 Nychols, John, of Newenton, husbandman 0
3997971 2024034 2024034 defendant Trewman George yeoman 590990 590990 Trewman, George, of Newenton, yeoman 1
3997972 2024034 2024034 defendant Mylles Henry yeoman 590990 590990 Mylles, Henry, of Newenton, yeoman 2
3997976 2024035 2024035 defendant Rydler Robert yeoman 590990 590990 Rydler, Robert, of Newenton, yeoman 2
4030819 2035688 2035688 defendant Nicholas John husbandman 590990 590990 Nicholas, John, of Newenton, husbandman 0
4030820 2035688 2035688 defendant Trewman George smith 590990 590990 Trewman, George, of Newenton, smith 1
4030821 2035688 2035688 defendant Adye Nicholas yeoman 590990 590990 Adye, Nicholas, of Newenton, yeoman 2
4030822 2035688 2035688 defendant Rydler John yeoman 590990 590990 Rydler, John, of Newenton, yeoman 3
4030823 2035688 2035688 defendant Milles Henry yeoman 590990 590990 Milles, Henry, of Newenton, yeoman 4
4434250 2175471 2175471 defendant Messager Joan   590990 590990 Messager, Joan, of Newenton, formerly wife of John 0
4464198 2189474 2189474 defendant Knyght John   590990 590990 Knyght, John, of Newenton 0
4475578 2193049 2193049 plaintiff Fenell Stephen   590990 590990 Fenell, Stephen, of Newenton 0
4480732 2194639 2194639 defendant Hardy William   590990 590990 Hardy, William, of Newenton, parson 0
4505469 2202240 2202240 defendant atte Rede Thomas   590990 590990 atte Rede, Thomas, of Newenton 1
4506313 2202474 2202474 defendant Knyght Thomas   590990 590990 Knyght, Thomas, of Newenton 4
4509388 2203412 2203412 defendant Berkesworth William weaver 590990 590990 Berkesworth, William, of Newenton, weaver 0
4512370 2204311 2204311 defendant Sclatter John   590990 590990 Sclatter, John, of Newenton 0
4520222 2206663 2206663 defendant Champeneys John   590990 590990 Champeneys, John, of Newenton 0
4573786 2223319 2223319 defendant Roche John   590990 590990 Roche, John, of Newenton 1
4574645 2223596 2223596 defendant Smyth John   590990 590990 Smyth, John, of Newenton 2
4574811 2223648 2223648 plaintiff Blakebroke Richard (legal representative) 590990 590990 Blakebroke, Richard, of Newenton, executors of 0
4583499 2226263 2226263 defendant Frogenhale William   590990 590990 Frogenhale, William, of Newenton 0
4583503 2226264 2226264 defendant Frogenhale William   590990 590990 Frogenhale, William, of Newenton 0
4583844 2226364 2226364 defendant Sybly William   590990 590990 Sybly, William, of Newenton 0
4597381 2230424 2230424 defendant Byk William   590990 590990 Byk, William, of Newenton 0
4597382 2230424 2230424 defendant May Henry   590990 590990 May, Henry, of Newenton 1
4604034 2232430 2232430 defendant Craunford Robert   590990 590990 Craunford, Robert, of Newenton 0
4610186 2234268 2234268 defendant atte Rode Thomas   590990 590990 atte Rode, Thomas, of Newenton 0
4641212 2243521 2243521 defendant Loksmyth Thomas   590990 590990 Loksmyth, Thomas, of Newenton 3
4644090 2244370 2244370 defendant Graungeman Thomas   590990 590990 Graungeman, Thomas, of Newenton 0
4655728 2247674 2247674 defendant Chydyng William laborer 590990 590990 Chydyng, William, of Newenton, laborer 0
4680962 2259671 2259671 defendant Romfeld John carpenter 590990 590990 Romfeld, John, of Newenton, carpenter 3
4685259 2260986 2260986 defendant Roper John, senior husbandman 590990 590990 Roper, John, senior, of Newenton, husbandman 0
4695224 2263986 2263986 defendant Aldebury William husbandman 590990 590990 Aldebury, William, of Newenton, husbandman 1
4695334 2264021 2264021 defendant Notyngham John   590990 590990 Notyngham, John, of Newenton 0
4698026 2264872 2264872 plaintiff Couk John   590990 590990 Couk, John, of Newenton, vicar 0
4700563 2265586 2265586 defendant Dod William butcher 590990 590990 Dod, William, of Newenton, butcher 0
4705275 2267021 2267021 defendant Paton Simon miller 590990 590990 Paton, Simon, of Newenton, miller 0
4760092 2283500 2283500 defendant Aston John husbandman 590990 590990 Aston, John, of Newenton, husbandman 0
4761989 2284096 2284096 defendant Lake Henry brewer 590990 590990 Lake, Henry, of Newenton, brewer 0
4763215 2284483 2284483 defendant Godfrey Robert weaver 590990 590990 Godfrey, Robert, of Newenton, weaver 0
4774184 2287908 2287908 defendant Somer William husbandman 590990 590990 Somer, William, of Newenton, husbandman 1
4779569 2289595 2289595 defendant Boteler John esq 590990 590990 Boteler, John, of Newenton, esq 0
4782326 2290476 2290476 defendant Aston John husbandman 590990 590990 Aston, John, of Newenton, husbandman 0
4784221 2291064 2291064 defendant Furneys William husbandman 590990 590990 Furneys, William, of Newenton, husbandman 0
4784223 2291065 2291065 defendant Furneys William husbandman 590990 590990 Furneys, William, of Newenton, husbandman 0
4785419 2291461 2291461 plaintiff Eynesham Nicholas   590990 590990 Eynesham, Nicholas, of Newenton 0
4795099 2294615 2294615 defendant Corveser William weaver 590990 590990 Corveser, William, of Newenton, weaver 0
4795101 2294615 2294615 defendant Clement John shoemaker 590990 590990 Clement, John, of Newenton, shoemaker 2
4795102 2294615 2294615 defendant Stegill William shoemaker 590990 590990 Stegill, William, of Newenton, shoemaker 3
4795103 2294615 2294615 defendant Heed John husbandman 590990 590990 Heed, John, of Newenton, husbandman 4
4795104 2294615 2294615 defendant Heed Nicholas Jonesservant laborer 590990 590990 Heed, Nicholas Jonesservant, of Newenton, laborer 5
4813430 2300312 2300312 defendant Curteys John husbandman 590990 590990 Curteys, John, of Newenton, husbandman 4
4835011 2306953 2306953 plaintiff Dandy William   590990 590990 Dandy, William, of Newenton, wax man 0
4836644 2307434 2307434 defendant Colyngworth Robert husbandman 590990 590990 Colyngworth, Robert, of Newenton, husbandman 3
4837735 2307736 2307736 defendant Baldewyne Thomas husbandman 590990 590990 Baldewyne, Thomas, of Newenton, husbandman 0
4841197 2308785 2308785 plaintiff James John   590990 590990 James, John, of Newenton, parson of St Bart's church 0
4851240 2311836 2311836 defendant Bereford William gent 590990 590990 Bereford, William, of Newenton, gent 0
4859592 2314370 2314370 defendant Boure William husbandman 590990 590990 Boure, William, of Newenton, husbandman 0
4860119 2314533 2314533 defendant Provet Robert husbandman 590990 590990 Provet, Robert, of Newenton, husbandman 1
4868902 2317250 2317250 defendant Frogenale Richard gent 590990 590990 Frogenale, Richard, of Newenton, gent 0
4885356 2322310 2322310 defendant Holde Robert husbandman 590990 590990 Holde, Robert, of Newenton, husbandman 0
4889459 2323498 2323498 defendant Bartilmewe William weaver 590990 590990 Bartilmewe, William, of Newenton, weaver 0
4889465 2323501 2323501 defendant Crosseby John brewer 590990 590990 Crosseby, John, of Newenton, brewer 0
4894475 2324945 2324945 defendant Sumond Thomas yeoman 590990 590990 Sumond, Thomas, of Newenton, yeoman 0
4907859 2329020 2329020 defendant Colyngworthe Robert husbandman 590990 590990 Colyngworthe, Robert, of Newenton, husbandman 0
4917767 2332069 2332069 defendant West John clerk 590990 590990 with West, John, of Newenton, clerk 6
4931505 2336235 2336235 defendant Stapulton William laborer 590990 590990 Stapulton, William, of Newenton, laborer 1
4935484 2337495 2337495 defendant Frogenhale Richard gent 590990 590990 Frogenhale, Richard, of Newenton, gent 1
4935506 2337502 2337502 defendant Adams William husbandman 590990 590990 Adams, William, of Newenton, husbandman 0
4938530 2338430 2338430 defendant Adams William husbandman 590990 590990 Adams, William, of Newenton, husbandman 0
4965156 2346503 2346503 defendant Campion Thomas husbandman 590990 590990 Campion, Thomas, of Newenton, husbandman 0
4966572 2346934 2346934 defendant Denys Thomas husbandman 590990 590990 Denys, Thomas, of Newenton, husbandman 3
4975371 2349593 2349593 defendant Lorde Robert husbandman 590990 590990 Lorde, Robert, of Newenton, husbandman 1
4976136 2349818 2349818 defendant Estfeld Luke brewer 590990 590990 Estfeld, Luke, of Newenton, brewer 2
4976151 2349822 2349822 defendant Mason Roger husbandman 590990 590990 Mason, Roger, of Newenton, husbandman 1
4976152 2349822 2349822 defendant Estfeld Luke brewer 590990 590990 Estfeld, Luke, of Newenton, brewer 2
4978537 2350532 2350532 defendant Rumsfeld William husbandman 590990 590990 (Rumsfeld, William, of Newenton, husbandman 1
4982725 2351744 2351744 defendant Berford William gent 590990 590990 Berford, William, of Newenton, gent 1
4983605 2352017 2352017 defendant Pegyn John laborer 590990 590990 Pegyn, John, of Newenton, laborer 0
4983607 2352018 2352018 defendant Pegyn John laborer 590990 590990 Pegyn, John, of Newenton, laborer 0

Next page

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