names

145 rows where place_id = 631033

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3656303 1912216 1912216 defendant Mowtyng Thomas yeoman 631033 631033 Mowtyng, Thomas, of East Dereham, yeoman 0
3658613 1912948 1912948 defendant Fyske Nicholas yeoman 631033 631033 Fyske, Nicholas, of East Dereham, yeoman 0
3660417 1913516 1913516 defendant Heye John painter 631033 631033 Heye, John, of East Dereham, painter 0
3662725 1914260 1914260 plaintiff Mowtyng Thomas   631033 631033 Mowtyng, Thomas, of East Dereham 0
3798117 1957307 1957307 defendant Large Richard husbandman 631033 631033 Large, Richard, of Est Dereham, husbandman 2
3802703 1958741 1958741 defendant Peke John baker 631033 631033 Peke, John, of Est Dereham, baker 0
3839616 1970314 1970314 defendant Doddys William beer brewer 631033 631033 Doddys, William, of Est Dereham, beer brewer 0
3856535 1975671 1975671 defendant Crosse Thomas husbandman 631033 631033 Crosse, Thomas, of Est Dereham, husbandman 0
3856536 1975671 1975671 defendant Large Richard husbandman 631033 631033 Large, Richard, of Est Dereham, husbandman 1
3866045 1978876 1978876 plaintiff Fyske John yeoman 631033 631033 Fyske, John, of Est Dereham, yeoman 1
3875772 1982149 1982149 plaintiff Fyske John yeoman 631033 631033 Fyske, John, of Est Dereham, yeoman 0
3875774 1982150 1982150 plaintiff Fyske John yeoman 631033 631033 Fyske, John, of Est Dereham, yeoman 0
3875776 1982151 1982151 plaintiff Fyske John yeoman 631033 631033 Fyske, John, of Est Dereham, yeoman 0
3928023 1999708 1999708 defendant Barrett John yeoman 631033 631033 Barrett, John, of East Dereham, yeoman 10
3928031 1999711 1999711 defendant Clytherowe allias Slater Thomas yeoman 631033 631033 Clytherowe allias Slater, Thomas, of East Dereham, yeoman 0
3928037 1999711 1999711 defendant Warner William yeoman 631033 631033 Warner, William, of East Dereham, yeoman 6
3930556 2000563 2000563 defendant Gurney Michael yeoman 631033 631033 Gurney, Michael, of Est Dereham, yeoman 0
3930557 2000563 2000563 defendant Moultyng Christopher   631033 631033 Moultyng, Christopher, of Est Dereham, tallow chandler 1
3930558 2000563 2000563 defendant Denys Richard tailor 631033 631033 Denys, Richard, of Est Dereham, tailor 2
3930559 2000563 2000563 defendant Rowth Adam tailor 631033 631033 Rowth, Adam, of Est Dereham, tailor 3
3934155 2001715 2001715 defendant Dikon William husbandman 631033 631033 Dikon, William, of East Dereham, husbandman 0
3934156 2001715 2001715 defendant Rason John weaver 631033 631033 Rason, John, of Est Dereham, weaver 1
3934157 2001715 2001715 defendant Dennyes John tailor 631033 631033 Dennyes, John, of Est Dereham, tailor 2
3936955 2002690 2002690 defendant Payntour Thomas yeoman 631033 631033 Payntour, Thomas, of Est Dereham, yeoman 1
3939483 2003511 2003511 defendant More Alexander husbandman 631033 631033 More, Alexander, of East Dereham, husbandman 2
3939965 2003666 2003666 defendant Brygges Thomas   631033 631033 Brygges, Thomas, of East Dereham, black smith 1
3939966 2003666 2003666 defendant Snellyng Thomas butcher 631033 631033 Snellyng, Thomas, of East Dereham, butcher 2
3939967 2003666 2003666 defendant Husband Robert tanner 631033 631033 Husband, Robert, of East Dereham, tanner 3
3939969 2003667 2003667 defendant Chilton William   631033 631033 Chilton, William, of Est Dereham, cord wainer 0
3939970 2003667 2003667 defendant Bircham Thomas   631033 631033 Bircham, Thomas, of Est Dereham, cord wainer 1
3939972 2003667 2003667 defendant Drake Francis mercer 631033 631033 (Drake, Francis, of Est Dereham, mercer 3
3944676 2005236 2005236 defendant Barton Edward (legal representative) 631033 631033 Barton, Edward, of Est Dereham, blacksmith, executors of 0
3944677 2005236 2005236 defendant Forman Stephen blacksmith 631033 631033 (Forman, Stephen, of Est Dereham, blacksmith 1
3946078 2005704 2005704 defendant Folser Christopher husbandman 631033 631033 Folser, Christopher, of Est Dereham, husbandman 0
3946841 2005964 2005964 defendant Bryghtwyse alias Brytens John husbandman 631033 631033 Bryghtwyse alias Brytens, John, of Est Dereham, husbandman 0
3949058 2006736 2006736 defendant Folser Christopher husbandman 631033 631033 Folser, Christopher, of Est Dereham, husbandman 0
3950289 2007187 2007187 defendant Walker Thomas hatter 631033 631033 Walker, Thomas, of Est Dereham, hatter 0
3976747 2016434 2016434 defendant Strowger Reginald   631033 631033 Strowger, Reginald, of Est Dereham, dornec or damask weaver 0
3979539 2017440 2017440 defendant Worlyche Nicholas (legal representative) 631033 631033 Worlyche, Nicholas, of Est Dereham, grocer, executrix of 0
3979543 2017441 2017441 defendant Worlyche Joan widow 631033 631033 Worlyche, Joan, of Est Dereham, widow 1
3984169 2019103 2019103 defendant Rose Richard blacksmith 631033 631033 Rose, Richard, of Est Dereham, blacksmith 2
3997627 2023903 2023903 defendant Penton John yeoman 631033 631033 Penton, John, of Est Dereham, yeoman 0
4015001 2030072 2030072 defendant Elwyn John butcher 631033 631033 Elwyn, John, of Est Dereham, butcher 9
4023076 2032970 2032970 defendant Trench John yeoman 631033 631033 Trench, John, of Est Dereham, yeoman 1
4027014 2034310 2034310 defendant Banyard George gent 631033 631033 Banyard, George, of Est Dereham, gent 0
4053872 2043762 2043762 defendant Moulton Henry tailor 631033 631033 Moulton, Henry, of Est Dereham, tailor 1
4057028 2044897 2044897 defendant Byrcham Thomas cordwainer 631033 631033 Byrcham, Thomas, of Est Dereham, cordwainer 2
4057029 2044897 2044897 defendant Geyton Thomas husbandman 631033 631033 Geyton, Thomas, of Est Dereham, husbandman 3
4067678 2048753 2048753 defendant Neale Robert   631033 631033 Neale, Robert, of Est Dereham, mason 0
4067679 2048753 2048753 defendant Brytyse John   631033 631033 Brytyse, John, of Est Dereham, horse courser 1
4069566 2049397 2049397 defendant Mathyn or Machyn William cordwainer 631033 631033 Mathyn or Machyn, William, of East Dereham, cordwainer 1
4076972 2052047 2052047 defendant Clarke Robert carpenter 631033 631033 Clarke, Robert, of Est Dereham, carpenter 0
4091026 2057078 2057078 defendant Stanes Thomas husbandman 631033 631033 Stanes, Thomas, of Est Dereham, husbandman 3
4091964 2057423 2057423 defendant Paynter William yeoman 631033 631033 Paynter, William, of Est Dereham, yeoman 0
4091967 2057424 2057424 defendant Paynter William yeoman 631033 631033 Paynter, William, of Est Dereham, yeoman 1
4097543 2059449 2059449 defendant Malbye Roger clerk 631033 631033 Malbye, Roger, of Est Dereham, clerk 3
4098652 2059849 2059849 defendant Brytyffe John   631033 631033 Brytyffe, John, of Est Dereham, horse courser 1
4103744 2061609 2061609 defendant Kynge Jerome tailor 631033 631033 Kynge, Jerome, of Est Dereham, tailor 1
4103745 2061609 2061609 defendant Froste Geoffrey cordwainer 631033 631033 Froste, Geoffrey, of Est Dereham, cordwainer 2
4111392 2064321 2064321 defendant Taylour Walter husbandman 631033 631033 Taylour, Walter, of Est Dereham, husbandman 0
4111393 2064321 2064321 defendant Pomfrett Clement laborer 631033 631033 Pomfrett, Clement, of Est Dereham, laborer 1
4111394 2064321 2064321 defendant Tayler Thomas laborer 631033 631033 Tayler, Thomas, of Est Dereham, laborer 2
4142815 2075662 2075662 defendant Legate Arthur gent 631033 631033 Legate, Arthur, of Est Dereham, gent 1
4163689 2082821 2082821 defendant Pyckerell John   631033 631033 Pyckerell, John, of Est Dereham, brick maker 1
4163692 2082822 2082822 defendant Trenche John, senior yeoman 631033 631033 Trenche, John, senior, of Est Dereham, yeoman 0
4168560 2084488 2084488 defendant Pyckerell John   631033 631033 Pyckerell, John, of Est Dereham, brick burner 0
4170606 2085220 2085220 defendant Chenney Robert saddler 631033 631033 Chenney, Robert, of Est Dereham, saddler 0
4180851 2088782 2088782 defendant Wynde John joiner 631033 631033 Wynde, John, of Est Dereham, joiner 0
4181356 2088960 2088960 defendant Shinglewood William carpenter 631033 631033 Shinglewood, William, of Est Dereham, carpenter 2
4181357 2088960 2088960 defendant Poynter William husbandman 631033 631033 Poynter, William, of Est Dereham, husbandman 3
4191998 2092759 2092759 defendant Pyckerell John   631033 631033 Pyckerell, John, of Est Dereham, brick burner 0
4194622 2093676 2093676 defendant Newman Edmund yeoman 631033 631033 Newman, Edmund, of Est Dereham, yeoman 1
4194623 2093676 2093676 defendant Gresnall Henry cordwainer 631033 631033 Gresnall, Henry, of Est Dereham, cordwainer 2
4194624 2093676 2093676 defendant Reynold Thomas tailor 631033 631033 Reynold, Thomas, of Est Dereham, tailor 3
4204233 2097030 2097030 defendant Wynde John joiner 631033 631033 Wynde, John, of Est Dereham, joiner 0
4214019 2100423 2100423 defendant Bryant Arthur joiner 631033 631033 Bryant, Arthur, of Est Dereham, joiner 1
4215787 2101018 2101018 defendant Wroo Mathew beer brewer 631033 631033 Wroo, Mathew, of Est Dereham, beer brewer 1
4216145 2101137 2101137 defendant Curtys John blacksmith 631033 631033 Curtys, John, of Est Dereham, blacksmith 0
4216425 2101241 2101241 defendant Starlyng Robert husbandman 631033 631033 Starlyng, Robert, of Est Dereham, husbandman 0
4216426 2101241 2101241 defendant Fysher Robert sherman 631033 631033 Fysher, Robert, of Est Dereham, sherman 1
4216427 2101241 2101241 defendant Heycock William   631033 631033 Heycock, William, of Est Dereham, mason 2
4219624 2102368 2102368 defendant Bryant Arthur joiner 631033 631033 Bryant, Arthur, of Est Dereham, joiner 3
4219966 2102485 2102485 defendant Elvye Richard yeoman 631033 631033 Elvye, Richard, of Est Dereham, yeoman 1
4227717 2105178 2105178 defendant Smyth Robert bricklayer 631033 631033 Smyth, Robert, of Est Dereham, bricklayer 0
4230201 2106049 2106049 defendant Atley Richard mercer 631033 631033 Atley, Richard, of Est Dereham, mercer 0
4230789 2106268 2106268 defendant Atley Richard   631033 631033 Atley, Richard, of East Dereham, linen draper 0
4241136 2110023 2110023 defendant Atlee Richard yeoman 631033 631033 Atlee, Richard, of Est Dereham, yeoman 0
4241139 2110024 2110024 defendant Atlee Richard yeoman 631033 631033 Atlee, Richard, of Est Dereham, yeoman 0
4242044 2110332 2110332 defendant Browne John tailor 631033 631033 Browne, John, of Est Dereham, tailor 3
4242683 2110543 2110543 defendant Baldwyn John weaver 631033 631033 Baldwyn, John, of East Dereham, weaver 0
4242684 2110543 2110543 defendant Walman John laborer 631033 631033 Walman, John, of East Dereham, laborer 1
4242685 2110543 2110543 defendant Butcher John laborer 631033 631033 Butcher, John, of East Dereham, laborer 2
4244854 2111267 2111267 defendant Baldwyn John weaver 631033 631033 Baldwyn, John, of East Dereham, or of Haveringham, weaver 0
4249455 2112802 2112802 defendant Amys Nicholas cordwainer 631033 631033 Amys, Nicholas, of Est Dereham, cordwainer 0
4249835 2112927 2112927 defendant Newcome Henry yeoman 631033 631033 Newcome, Henry, of East Dereham, yeoman 0
4251473 2113473 2113473 defendant Newcum Henry miller 631033 631033 Newcum, Henry, of Est Dereham, miller 0
4251476 2113473 2113473 defendant Shilling Robert cordwainer 631033 631033 Shilling, Robert, of Est Dereham, cordwainer 3
4254466 2114483 2114483 defendant Lowe William beer brewer 631033 631033 Lowe William, of East Dereham, beer brewer 2
4254467 2114483 2114483 defendant Wroe Mathew laborer 631033 631033 Wroe, Mathew, of Est Dereham, laborer 3
4256481 2115135 2115135 defendant Atley Richard chapman 631033 631033 Atley, Richard, of Est Dereham, chapman 2

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