names

169 rows where place_id = 586230

✎ 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
3588218 1863969 1863969 defendant Kynne William yeoman 586230 586230 Kynne, William, of Fyncham, yeoman 1
3590767 1864751 1864751 defendant Leke Godwin husbandman 586230 586230 Leke, Godwin, of Fyncham, husbandman 2
3591106 1864841 1864841 defendant Lede Robert shoemaker 586230 586230 Lede, Robert, of Fyncham, shoemaker 4
3597249 1866761 1866761 defendant Clerke John tailor 586230 586230 Clerke, John, of Fyncham, tailor 1
3597250 1866761 1866761 defendant Kinbard John husbandman 586230 586230 Kinbard, John, of Fyncham, husbandman 2
3607963 1870141 1870141 defendant Lamberte John husbandman 586230 586230 Lamberte, John, of Fyncham, husbandman 1
3624667 1875251 1875251 defendant Leke Godwin yeoman 586230 586230 Leke, Godwin, of Fyncham, yeoman 1
3639591 1907193 1907193 defendant Pleyterse Edmund gent 586230 586230 Pleyterse, Edmund, of Fyncham, gent 0
3648197 1909833 1909833 defendant Moyle Robert husbandman 586230 586230 Moyle, Robert, of Fyncham, husbandman 0
3681397 1920268 1920268 defendant Davy William beer brewer 586230 586230 Davy, William, of Fyncham, beer brewer 0
3694947 1924630 1924630 defendant Davy William mercer 586230 586230 Davy, William, of Fyncham, mercer 0
3723497 1933617 1933617 defendant Davy William husbandman 586230 586230 Davy, William, of Fyncham, husbandman 0
3725441 1934251 1934251 plaintiff Fyncham John esq 586230 586230 Fyncham, John, of Fyncham, esq 5
3725454 1934252 1934252 plaintiff Fyncham John esq 586230 586230 Fyncham, John, of Fyncham, esq 5
3738534 1938261 1938261 plaintiff Fyncham John   586230 586230 Fyncham, John, of Fyncham 2
3739354 1938514 1938514 defendant Davy William husbandman 586230 586230 Davy, William, of Fyncham, husbandman 0
3756818 1944105 1944105 defendant Jakson Thomas husbandman 586230 586230 Jakson, Thomas, of Fyncham, husbandman 1
3798479 1957425 1957425 defendant Goodale John hardwareman 586230 586230 Goodale, John, of Fyncham, hardwareman 2
3802475 1958673 1958673 defendant Playter Edmund esq 586230 586230 Playter, Edmund, of Fyncham, esq 2
3829588 1967143 1967143 plaintiff Davy Richard (legal representative) 586230 586230 Davy, Richard, of Fyncham, clerk, executor of 0
3829591 1967143 1967143 defendant Davy Agnes spinster 586230 586230 Davy, Agnes, of Fyncham, spinster 1
3841940 1971046 1971046 defendant Godale John mercer 586230 586230 Godale, John, of Fyncham, mercer 0
3869379 1979997 1979997 defendant Davy William innholder 586230 586230 Davy, William, of Fyncham, innholder 0
3888222 1986316 1986316 defendant Orton William clerk 586230 586230 Orton, William, of Fyncham, clerk 3
3903273 1991317 1991317 defendant Topley alias Topclyff Thomas husbandman 586230 586230 Topley alias Topclyff, Thomas, of Fyncham, husbandman 0
3903555 1991418 1991418 defendant Cobbe John yeoman 586230 586230 Cobbe, John, of Fyncham, yeoman 0
3915914 1995702 1995702 defendant Jerves Thomas husbandman 586230 586230 Jerves, Thomas, of Fyncham, husbandman 0
3917870 1996337 1996337 defendant Miller Nicholas butcher 586230 586230 Miller, Nicholas, of Fyncham, butcher 1
3917873 1996337 1996337 defendant Potterell William husbandman 586230 586230 Potterell, William, of Fyncham, husbandman 4
3921858 1997654 1997654 defendant Jaxson John clerk 586230 586230 Jaxson, John, of Fyncham, clerk 1
3931346 2000778 2000778 defendant Lambart William yeoman 586230 586230 Lambart, William, of Fyncham, yeoman 0
3931400 2000799 2000799 defendant Menyk Edward yeoman 586230 586230 Menyk, Edward, of Fyncham, yeoman 1
3931401 2000799 2000799 defendant Jervys Henry yeoman 586230 586230 Jervys, Henry, of fyncham, yeoman 2
3931402 2000799 2000799 defendant Church Richard yeoman 586230 586230 Church, Richard, of Fyncham, yeoman 3
3937493 2002875 2002875 defendant Fyncham Thomas (legal representative) 586230 586230 Fyncham, Thomas, of Fyncham, esq, executors of 0
3937494 2002875 2002875 defendant Hyham John gent 586230 586230 (Hyham, John, of Fyncham, gent 1
3944366 2005126 2005126 defendant Freke Thomas clerk 586230 586230 Freke, Thomas, of Fyncham, clerk 0
3945619 2005544 2005544 defendant Bloke William husbandman 586230 586230 Bloke, William, of Fyncham, husbandman 1
3967489 2013265 2013265 defendant Thurston William husbandman 586230 586230 Thurston, William, of Fyncham, husbandman 0
3973490 2015297 2015297 defendant Guybon Humphrey gent 586230 586230 Guybon, Humphrey, of Fyncham, gent 0
3975276 2015922 2015922 defendant Peersey Henry husbandman 586230 586230 Peersey, Henry, of Fyncham, husbandman 1
3989776 2021088 2021088 defendant Marshall Richard husbandman 586230 586230 Marshall, Richard, of Fyncham, husbandman 0
4000903 2025093 2025093 defendant Ryxe Nicholas yeoman 586230 586230 Ryxe, Nicholas, of Fyncham, yeoman 1
4023387 2033075 2033075 defendant Gabriell John   586230 586230 Gabriell, John, of Fyncham, shepherd 1
4032720 2036356 2036356 defendant Fyncham William gent 586230 586230 Fyncham, William, of Fyncham, gent 1
4049706 2042333 2042333 defendant Complyn Richard husbandman 586230 586230 Complyn, Richard, of Fyncham, husbandman 0
4054683 2044065 2044065 plaintiff Barrett Henry yeoman 586230 586230 Barrett, Henry, of Fyncham, yeoman 0
4054687 2044066 2044066 plaintiff Barrett Henry yeoman 586230 586230 Barrett, Henry, of Fyncham, yeoman 0
4054691 2044067 2044067 plaintiff Barrett Henry yeoman 586230 586230 Barrett, Henry, of Fyncham, yeoman 0
4054693 2044068 2044068 plaintiff Barrett Henry yeoman 586230 586230 Barrett, Henry, of Fyncham, yeoman 0
4057945 2045222 2045222 defendant Dyckson William tailor 586230 586230 Dyckson, William, of Fyncham, tailor 2
4072629 2050516 2050516 defendant Bardwell Robert   586230 586230 Bardwell, Robert, of Fyncham, shepherd 1
4072630 2050516 2050516 defendant Archer Robert clerk 586230 586230 Archer, Robert, of Fyncham, clerk 2
4084248 2054640 2054640 defendant Lambert John husbandman 586230 586230 Lambert, John, of Fyncham, husbandman 1
4099781 2060243 2060243 defendant Walter Robert tailor 586230 586230 Walter, Robert, of Fyncham, tailor 0
4105508 2062249 2062249 defendant Fyshe William   586230 586230 Fyshe, William, of Fyncham, wheelwright 0
4106567 2062638 2062638 defendant Thurston William yeoman 586230 586230 Thurston, William, of Fyncham, yeoman 0
4130176 2071100 2071100 defendant Drewrey Thomas yeoman 586230 586230 Drewrey, Thomas, of Fyncham, yeoman 0
4136199 2073292 2073292 defendant Chambers Thomas husbandman 586230 586230 Chambers, Thomas, of Fyncham, husbandman 0
4148311 2077539 2077539 defendant Stonner Thomas husbandman 586230 586230 Stonner, Thomas, of Fyncham, husbandman 3
4163799 2082865 2082865 defendant Thurston William husbandman 586230 586230 Thurston, William, of Fyncham, husbandman 0
4163801 2082866 2082866 defendant Thurston William husbandman 586230 586230 Thurston, William, of Fyncham, husbandman 0
4176172 2087141 2087141 defendant Clerke William yeoman 586230 586230 Clerke, William, of Fyncham, yeoman 0
4179198 2088200 2088200 defendant Barrett John   586230 586230 Barrett, John, of Fyncham, shepherd 0
4193621 2093336 2093336 defendant Gylbert Richard yeoman 586230 586230 Gylbert, Richard, of Fyncham, yeoman 1
4197611 2094720 2094720 defendant Stoner Thomas husbandman 586230 586230 together with Stoner, Thomas, of Fyncham, husbandman 1
4201165 2095959 2095959 defendant Theckell John chapman 586230 586230 Theckell, John, of Fyncham, chapman 0
4218058 2101813 2101813 defendant Barker Richard husbandman 586230 586230 Barker, Richard, of Fyncham, husbandman 0
4218059 2101813 2101813 defendant Mason Nicholas   586230 586230 Mason, Nicholas, of Fyncham, husbandman, or of Shingham, shepherd 1
4222170 2103244 2103244 defendant Neve John schoolmaster 586230 586230 Neve, John, of Fyncham, schoolmaster 0
4244073 2110999 2110999 defendant Thinkle John yeoman 586230 586230 Thinkle, John, of Fyncham, yeoman 0
4249832 2112926 2112926 defendant Smyth Edmund yeoman 586230 586230 Smyth, Edmund, of Fyncham, yeoman 2
4277896 2122199 2122199 defendant Bacon Richard yeoman 586230 586230 Bacon, Richard, of Fyncham, yeoman 0
4286952 2125386 2125386 defendant Chambers William knacker 586230 586230 Chambers, William, of Fyncham, knacker 2
4393649 2162479 2162479 defendant Turner Christopher laborer 586230 586230 Turner, Christopher, of Fyncham, laborer 3
4427765 2173521 2173521 defendant Ode Andrew   586230 586230 Ode, Andrew, of Fyncham 0
4431757 2174706 2174706 plaintiff Buleware John   586230 586230 Buleware, John, of Fyncham 0
4432018 2174795 2174795 defendant Hode Andrew   586230 586230 Hode, Andrew, of Fyncham 0
4436497 2176153 2176153 plaintiff Smyth Thomas le   586230 586230 Smyth, Thomas le, of Fyncham 0
4439957 2181779 2181779 defendant Tulle Thomas   586230 586230 Tulle, Thomas, of Fyncham 0
4439958 2181779 2181779 defendant bulwere Roger   586230 586230 bulwere, Roger, of Fyncham 1
4445954 2183678 2183678 defendant Blak Thomas   586230 586230 Blak, Thomas, of fyncham 1
4465402 2189850 2189850 defendant Bulwere Roger   586230 586230 Bulwere, Roger, of Fyncham 3
4489907 2197551 2197551 defendant Skynner John   586230 586230 Skynner, John, of Fyncham 2
4489909 2197551 2197551 defendant Ode Nicholas   586230 586230 Ode, Nicholas, of Fyncham 4
4489911 2197551 2197551 defendant attte Grene Robert   586230 586230 attte Grene, Robert, of Fyncham 6
4560818 2219341 2219341 defendant Deye Richard   586230 586230 Deye, Richard, of Fyncham 0
4683419 2260415 2260415 defendant Loksmyth John   586230 586230 Loksmyth, John, of Fyncham 2
4683420 2260415 2260415 defendant Kyn Richard   586230 586230 Kyn, Richard, of Fyncham 3
4712373 2269186 2269186 defendant Payn Nicholas   586230 586230 Payn, Nicholas, of Fyncham, franklin 0
4712374 2269186 2269186 defendant Wormegey John   586230 586230 Wormegey, John, of Fyncham, parson of St Michael's church 1
4738344 2277088 2277088 defendant Harple John yeoman 586230 586230 Harple, John, of Fyncham, yeoman 0
4751426 2280899 2280899 defendant Payn Nicholas yeoman 586230 586230 Payn, Nicholas, of Fyncham, yeoman 0
4761258 2283868 2283868 defendant Allone John husbandman 586230 586230 Allone, John, of Fyncham, husbandman 1
4775934 2288476 2288476 defendant Newehall Nicholas husbandman 586230 586230 Newehall, Nicholas, of Fyncham, husbandman 0
4775935 2288476 2288476 defendant Pykeman Edmund yeoman 586230 586230 Pykeman, Edmund, of Fyncham, yeoman 1
4784387 2291118 2291118 defendant Payn Nicholas yeoman 586230 586230 Payn, Nicholas, of Fyncham, yeoman 1
4784389 2291119 2291119 defendant Outlawe Richard yeoman 586230 586230 Outlawe, Richard, of Fyncham, yeoman 0
4801932 2296788 2296788 defendant Payn Nicholas husbandman 586230 586230 Payn, Nicholas, of Fyncham, husbandman 0
4801933 2296788 2296788 defendant Crowe Robert husbandman 586230 586230 Crowe, Robert, of Fyncham, husbandman 1

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