names

207 rows where place_id = 589000

✎ 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
3596224 1866447 1866447 defendant Plumsted Nicholas husbandman 589000 589000 Plumsted, Nicholas, of Bradfeld, husbandman 1
3609024 1870477 1870477 defendant Estgate Roger gent 589000 589000 Estgate, Roger, of Bradfeld, gent 0
3610149 1870837 1870837 defendant Estgate Roger yeoman 589000 589000 Estgate, Roger, of Bradfeld, yeoman 5
3610156 1870838 1870838 defendant Estgate Roger yeoman 589000 589000 Estgate, Roger, of Bradfeld, yeoman 5
3611342 1871219 1871219 defendant Kynge William husbandman 589000 589000 Kynge, William, of Bradfeld, husbandman 0
3624802 1875292 1875292 defendant Estgate Roger yeoman 589000 589000 Estgate, Roger, of Bradfeld, yeoman 0
3634341 1905538 1905538 defendant Serle John (legal representative) 589000 589000 Serle, John, of Bradfeld, yeoman, executors of 1
3634343 1905538 1905538 defendant Herde John tailor 589000 589000 Herde, John, of Bradfeld, tailor 3
3653724 1911427 1911427 defendant Veysey William husbandman 589000 589000 Veysey, William, of Bradfeld, husbandman 1
3669557 1916416 1916416 defendant Carter Thomas fuller 589000 589000 Carter, Thomas, of Bradfeld, fuller 0
3674570 1918097 1918097 defendant Parson William laborer 589000 589000 Parson, William, of Bradfeld, laborer 4
3675763 1918454 1918454 defendant Hilys John yeoman 589000 589000 Hilys, John, of Bradfeld, yeoman 0
3680386 1919947 1919947 defendant Ixworth James husbandman and freemason 589000 589000 Ixworth, James, of Bradfeld, husbandman and freemason 0
3681931 1920452 1920452 defendant Stafford William esq 589000 589000 Stafford, William, of Bradfeld, esq 0
3694411 1924456 1924456 defendant Fichet John gent 589000 589000 Fichet, John, of Bradfeld, gent 0
3697143 1925328 1925328 defendant Stafford William gent 589000 589000 Stafford, William, of Bradfeld, gent 0
3724677 1934002 1934002 defendant Ixworth James   589000 589000 Ixworth, James, of Bradfeld, freemason 0
3729745 1935558 1935558 defendant Crowmer Robert smith 589000 589000 Crowmer, Robert, of Bradfeld, smith 0
3745805 1940592 1940592 defendant Baron Thomas husbandman 589000 589000 Baron, Thomas, of Bradfeld, husbandman 1
3793489 1955827 1955827 defendant Barun Thomas husbandman 589000 589000 Barun, Thomas, of Bradfeld, husbandman 0
3808361 1960488 1960488 defendant Carter Thomas fuller 589000 589000 Carter, Thomas, of Bradfeld, fuller 0
3810298 1961110 1961110 defendant Baron Thomas husbandman 589000 589000 Baron, Thomas, of Bradfeld, husbandman 0
3810697 1961244 1961244 defendant Baron Thomas husbandman 589000 589000 Baron, Thomas, of Bradfeld, husbandman 0
3810698 1961244 1961244 defendant Feryngton Alexander husbandman 589000 589000 Feryngton, Alexander, of Bradfeld, husbandman 1
3813710 1962200 1962200 defendant Sampson William laborer 589000 589000 Sampson, William, of Bradfeld, laborer 0
3818842 1963797 1963797 defendant Morton John yeoman 589000 589000 Morton, John, of Bradfeld, yeoman 1
3818843 1963797 1963797 defendant Wirrall Thomas yeoman 589000 589000 Wirrall, Thomas, of Bradfeld, yeoman 2
3818844 1963797 1963797 defendant Senyour William yeoman 589000 589000 Senyour, William, of Bradfeld, yeoman 3
3850985 1973898 1973898 defendant Bulle Richard husbandman 589000 589000 Bulle, Richard, of Bradfeld, husbandman 1
3858162 1976208 1976208 plaintiff Bevys Thomas dyer 589000 589000 Bevys, Thomas, of Bradfeld, dyer 0
3858164 1976209 1976209 plaintiff Bevys Thomas dyer 589000 589000 Bevys, Thomas, of Bradfeld, dyer 0
3858167 1976210 1976210 defendant Neve Robert   589000 589000 Neve, Robert, of Bradfeld, worsted weaver 0
3861884 1977434 1977434 defendant Wyth John yeoman 589000 589000 Wyth, John, of Bradfeld, yeoman 0
3872320 1980968 1980968 plaintiff Bevys Thomas dyer 589000 589000 Bevys, Thomas, of Bradfeld, dyer 0
3873790 1981454 1981454 defendant Knyghtys Thomas laborer 589000 589000 Knyghtys, Thomas, of Bradfeld, laborer 1
3877594 1982745 1982745 defendant Chatterton Edmund gent 589000 589000 Chatterton, Edmund, of Bradfeld, gent 0
3878104 1982924 1982924 defendant Knapp Thomas husbandman 589000 589000 Knapp, Thomas, of Bradfeld, husbandman 0
3888917 1986537 1986537 defendant Ide William   589000 589000 Ide, William, of Bradfeld, twill weaver 0
3888921 1986537 1986537 defendant Bray John husbandman 589000 589000 Bray, John, of Bradfeld, husbandman 4
3905136 1991982 1991982 defendant Spone John, junior yeoman 589000 589000 Spone, John, junior, of Bradfeld, yeoman 0
3905137 1991982 1991982 defendant Shae Richard yeoman 589000 589000 Shae, Richard, of Bradfeld, yeoman 1
3913219 1994752 1994752 defendant Berton George clerk 589000 589000 Berton, George, of Bradfeld, clerk 1
3922422 1997815 1997815 defendant Walrond Henry esq 589000 589000 Walrond, Henry, of Bradfeld, esq 0
3922986 1997995 1997995 defendant Bromehed Henry laborer 589000 589000 Bromehed, Henry, of Bradfeld, laborer 5
3923527 1998178 1998178 plaintiff Sparhauk Robert yeoman 589000 589000 Sparhauk, Robert, of Bradfeld, yeoman 0
3923529 1998179 1998179 plaintiff Sparhauk Robert yeoman 589000 589000 Sparhauk, Robert, of Bradfeld, yeoman 0
3923531 1998179 1998179 defendant Horesbey Richard miller 589000 589000 Horesbey, Richard, of Bradfeld, miller 1
3940521 2003841 2003841 plaintiff Stafford Thomas esq 589000 589000 Stafford, Thomas, of Bradfeld, esq 0
3940524 2003842 2003842 plaintiff Stafforde Thomas esq 589000 589000 Stafforde, Thomas, of Bradfeld, esq 0
3940525 2003842 2003842 defendant Barton George   589000 589000 Barton, George, of Bradfeld, Berks, rector 0
3955559 2009013 2009013 defendant Ide John yeoman 589000 589000 Ide, John, of Bradfeld, yeoman 0
3976053 2016192 2016192 defendant Ide John   589000 589000 Ide, John, of Bradfeld 0
3976055 2016193 2016193 defendant Ide John   589000 589000 Ide, John, of Bradfeld 0
3993835 2022545 2022545 defendant Heylesdon Robert husbandman 589000 589000 Heylesdon, Robert, of Bradfeld, husbandman 0
4012531 2029204 2029204 defendant Lewgar Thomas   589000 589000 Lewgar, Thomas, of Bradfeld gent 0
4025418 2033748 2033748 defendant Adkynson John husbandman 589000 589000 Adkynson, John, of Bradfeld, husbandman 1
4056437 2044686 2044686 defendant Braye Miles (legal representative) 589000 589000 Braye, Miles, of Bradfeld, yeoman, executors of 0
4056438 2044686 2044686 defendant Rayner John carpenter 589000 589000 (Rayner, John, of Bradfeld, carpenter 1
4056440 2044687 2044687 defendant Braye Miles (legal representative) 589000 589000 Braye, Miles, of Bradfeld, yeoman, executors of 0
4056441 2044687 2044687 defendant Rayner John carpenter 589000 589000 (Rayner, John, of Bradfeld, carpenter 1
4056612 2044754 2044754 plaintiff Brigges Thomas gent 589000 589000 Brigges, Thomas, of Bradfeld, gent 0
4077024 2052066 2052066 defendant Hemysbye Richard husbandman 589000 589000 Hemysbye, Richard, of Bradfeld, or of Gorleston, husbandman 0
4104327 2061828 2061828 defendant Beighton John whitawer 589000 589000 Beighton, John, of Bradfeld, whitawer 0
4120052 2067459 2067459 defendant Stafford Read esq 589000 589000 Stafford, Read, of Bradfeld, or of Bourghfelde, Berks, esq 1
4180971 2088822 2088822 defendant Creswicke Thomas tanner 589000 589000 Creswicke, Thomas, of Bradfeld, tanner 0
4181456 2088994 2088994 defendant Creswycke Thomas tanner 589000 589000 Creswycke, Thomas, of Bradfeld, tanner 0
4210534 2099240 2099240 defendant Nun or None Francis husbandman 589000 589000 Nun or None, Francis, of Bradfeld Synckler, husbandman 0
4219078 2102168 2102168 defendant Greaves Robert yeoman 589000 589000 Greaves, Robert, of Bradfeld, yeoman 0
4229855 2105926 2105926 defendant South Richard yeoman 589000 589000 South, Richard, of Bradfeld, or of Waldershelff, yeoman 0
4231032 2106354 2106354 defendant Wood alias Piender William husbandman 589000 589000 Wood alias Piender, William, of Bradfeld, husbandman 0
4287710 2125656 2125656 defendant Raymer John   589000 589000 Raymer, John, of Bradfeld, yeoman, "howsewright" 0
4287713 2125657 2125657 defendant Rayner John   589000 589000 Rayner, John, of Bradfeld, yeoman, housewright 0
4403252 2165659 2165659 defendant Greaves Robert yeoman 589000 589000 Greaves, Robert, of Bradfeld, yeoman 2
4483511 2195530 2195530 defendant Bridesale John   589000 589000 Bridesale, John, of Bradfeld, parson 0
4483513 2195530 2195530 defendant Dalby John   589000 589000 Dalby, John, of Bradfeld, parson 2
4507909 2202938 2202938 defendant Rust John   589000 589000 Rust, John, of Bradfeld 0
4571516 2222670 2222670 defendant Martyn John   589000 589000 Martyn, John, of Bradfeld 0
4576421 2224137 2224137 defendant Fauconer John   589000 589000 Fauconer, John, of Bradfeld St Cler, parson & clerk 0
4591237 2228617 2228617 defendant Parmounter John   589000 589000 Parmounter, John, of Bradfeld St Cler 0
4605455 2232838 2232838 defendant Wynteworth William de   589000 589000 Wynteworth, William de, of Bradfeld 48
4614152 2235435 2235435 defendant Warner John   589000 589000 Warner, John, of Bradfeld, son of Agatha 0
4640339 2243288 2243288 defendant Warner John   589000 589000 Warner, John, of Bradfeld, son of Agatha 0
4643377 2244169 2244169 plaintiff Jacob John   589000 589000 Jacob, John, of Bradfeld 0
4643379 2244170 2244170 plaintiff Jacob John   589000 589000 Jacob, John, of Bradfeld 0
4716100 2270343 2270343 defendant Morewode John husbandman 589000 589000 Morewode, John, of Bradfeld, husbandman 0
4735907 2276382 2276382 defendant Bret Edmund husbandman 589000 589000 Bret, Edmund, of Bradfeld, husbandman 0
4735910 2276382 2276382 defendant Fauconer John clerk 589000 589000 Fauconer, John, of Bradfeld, St Cler, clerk 3
4739831 2277531 2277531 plaintiff Crull Philip   589000 589000 Crull, Philip, of Bradfeld, vicar 3
4770719 2286823 2286823 plaintiff Richer John (legal representative) 589000 589000 Richer, John, of Bradfeld, executors of 0
4776518 2288649 2288649 defendant Gate John husbandman 589000 589000 Gate, John, of Bradfeld, husbandman 0
4776856 2288749 2288749 defendant Wrasteler Henry yeoman 589000 589000 Wrasteler, Henry, of Bradfeld, yeoman 1
4776857 2288749 2288749 defendant Odeley Henry yeoman 589000 589000 Odeley, Henry, of Bradfeld, yeoman 2
4776878 2288755 2288755 defendant Crokhill Richard yeoman 589000 589000 Crokhill, Richard, of Bradfeld, yeoman 1
4778072 2289129 2289129 defendant Gulle Richard plowman 589000 589000 Gulle, Richard, of Bradfeld, plowman 0
4784131 2291033 2291033 defendant Theyn Roger yeoman 589000 589000 Theyn, Roger, of Bradfeld, yeoman 1
4848863 2311109 2311109 defendant Lowese William husbandman 589000 589000 Lowese, William, of Bradfeld, husbandman 0
4897823 2325983 2325983 defendant Pygon Bartholomew smith 589000 589000 Pygon, Bartholomew, of Bradfeld, smith 0
4897835 2325986 2325986 plaintiff Tebald Robert   589000 589000 Tebald, Robert, of Bradfeld 3
4902535 2327411 2327411 defendant Pygon Bartholomew smith 589000 589000 Pygon, Bartholomew, of Bradfeld, smith 0
4903132 2327591 2327591 defendant Humnale Thomas yeoman 589000 589000 Humnale, Thomas, of Bradfeld Sencler, yeoman 11

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