names

929 rows where place_id = 586386

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588582 1864073 1864073 defendant Ayleff John husbandman 586386 586386 Ayleff, John, of Weston, husbandman 0
3588684 1864105 1864105 defendant Lewes Thomas husbandman 586386 586386 Lewes, Thomas, of Weston under Penyord, husbandman 0
3589913 1864485 1864485 defendant Bryan William laborer 586386 586386 Bryan, William, of Weston, laborer 1
3593265 1865527 1865527 defendant Fauconer Thomas husbandman 586386 586386 Fauconer, Thomas, of Weston, husbandman 0
3595635 1866261 1866261 defendant Dedmore Thomas husbandman 586386 586386 Dedmore, Thomas, of Weston, husbandman 0
3595636 1866261 1866261 defendant Prekyll Thomas husbandman 586386 586386 Prekyll, Thomas, of Weston, husbandman 1
3595637 1866261 1866261 defendant Gatesend Henry husbandman 586386 586386 Gatesend, Henry, of Weston, husbandman 2
3600498 1867803 1867803 defendant Deye Robert husbandman 586386 586386 Deye, Robert, of Weston, husbandman 0
3602713 1868511 1868511 defendant Stephens Robert husbandman 586386 586386 Stephens, Robert, of Weston, husbandman 0
3604763 1869153 1869153 defendant Mapilton Robert husbandman 586386 586386 Mapilton, Robert, of Weston, husbandman 3
3607815 1870096 1870096 defendant Harryson Thomas yeoman 586386 586386 Harryson, Thomas, of Weston under Wetheley, yeoman 1
3607820 1870097 1870097 defendant Harryson Thomas yeoman 586386 586386 Harryson, Thomas, of Weston under Wetherley, yeoman 1
3607825 1870098 1870098 defendant Harryson Thomas yeoman 586386 586386 Harryson, Thomas, of Weston under Wetherley, yeoman 1
3607867 1870110 1870110 defendant Harryson Thomas yeoman 586386 586386 Harryson, Thomas, of Weston under Wetheley, yeoman 0
3609846 1870750 1870750 defendant Vavasour John gent 586386 586386 (Vavasour, John, of Weston, gent 1
3611458 1871258 1871258 defendant Hert William husbandman 586386 586386 Hert, William, of Weston under Penyord, husbandman 0
3611459 1871258 1871258 defendant Hert John husbandman 586386 586386 Hert, John, of Weston under Penyord, husbandman 1
3611460 1871258 1871258 defendant Norse Walter husbandman 586386 586386 Norse, Walter, of Weston under Penyord, husbandman 2
3611852 1871368 1871368 defendant Hertley Margery widow 586386 586386 Hertley, Margery, of Weston, widow 0
3618407 1873391 1873391 defendant Coton Katherine widow 586386 586386 Coton, Katherine, of Weston, widow 0
3618409 1873391 1873391 defendant Faukener Thomas husbandman 586386 586386 Faukener, Thomas, of Weston, husbandman 2
3624207 1875103 1875103 defendant Stoner John husbandman 586386 586386 Stoner, John, of Weston, husbandman 4
3626817 1903238 1903238 defendant Wylkynson Peter clerk 586386 586386 Wylkynson, Peter, of Weston, clerk 0
3628026 1903618 1903618 defendant Mosse John husbandman 586386 586386 Mosse, John, of Weston, husbandman 0
3628027 1903618 1903618 defendant Mosse William husbandman 586386 586386 Mosse, William, of Weston, husbandman 1
3629369 1904043 1904043 defendant Shenkwyn Henry yeoman 586386 586386 Shenkwyn, Henry, of Weston, yeoman 8
3629370 1904043 1904043 defendant Prekyll Thomas yeoman 586386 586386 Prekyll, Thomas, of Weston, yeoman 9
3629371 1904043 1904043 defendant Hesill John laborer 586386 586386 Hesill, John, of Weston, laborer 10
3629372 1904043 1904043 defendant Freer Robert laborer 586386 586386 Freer, Robert, of Weston, laborer 11
3629373 1904043 1904043 defendant Clemens John laborer 586386 586386 Clemens, John, of Weston, laborer 12
3630565 1904387 1904387 defendant Bettys Richard husbandman 586386 586386 Bettys, Richard, of Weston, husbandman 1
3636095 1906080 1906080 defendant Bregham Robert, senior smith 586386 586386 Bregham, Robert, senior, of Weston, smith 1
3636614 1906243 1906243 defendant Styver or Styber Humphrey husbandman 586386 586386 Styver or Styber, Humphrey, of Weston juxta Briggewater, husbandman 0
3637253 1906453 1906453 defendant Myllys Richard husbandman 586386 586386 Myllys, Richard, of Weston, husbandman 0
3637644 1906587 1906587 defendant Gune Thomas husbandman 586386 586386 Gune, Thomas, of Weston, husbandman 0
3637645 1906587 1906587 defendant Edryche Henry husbandman 586386 586386 Edryche, Henry, of Weston, husbandman 1
3637646 1906587 1906587 defendant Idon Thomas carpenter 586386 586386 Idon, Thomas, of Weston, carpenter 2
3638314 1906800 1906800 defendant Aldern John husbandman 586386 586386 Aldern, John, of Weston under Shockenhyll, husbandman 2
3639305 1907104 1907104 defendant Parkyn Thomas husbandman 586386 586386 Parkyn, Thomas, of Weston, husbandman 0
3639598 1907195 1907195 defendant Selers Richard tailor 586386 586386 Selers, Richard, of Weston, tailor 3
3639747 1907240 1907240 defendant Stronde Robert husbandman 586386 586386 Stronde, Robert, of Weston, husbandman 0
3640589 1907498 1907498 defendant Styver Humphrey (legal representative) 586386 586386 Styver, Humphrey, of Weston juxta Briggewater, gent, executrix of 0
3640590 1907498 1907498 defendant Styver Agnes widow 586386 586386 Styver, Agnes, of Weston juxta Briggewater, widow 1
3645102 1908876 1908876 defendant Archard Thomas husbandman 586386 586386 Archard, Thomas, of Weston, husbandman 1
3645252 1908922 1908922 defendant Wyllyams Nicholas smith 586386 586386 Wyllyams, Nicholas, of Weston, smith 0
3649221 1910145 1910145 defendant Parker Elias chaplain 586386 586386 Parker, Elias, of Weston, chaplain 0
3649222 1910145 1910145 defendant Parker John husbandman 586386 586386 Parker, John, of Weston, husbandman 1
3649591 1910261 1910261 defendant Morys William husbandman 586386 586386 Morys, William, of Weston, husbandman 0
3651730 1910895 1910895 defendant Hullys Thomas husbandman 586386 586386 Hullys, Thomas, of Weston under Shuchenhyll, husbandman 4
3653621 1911396 1911396 defendant Fayrkelowe Ralph yeoman 586386 586386 Fayrkelowe, Ralph, of Weston, yeoman 3
3653702 1911421 1911421 defendant Archard Thomas husbandman 586386 586386 Archard, Thomas, of Weston, husbandman 0
3660894 1913674 1913674 defendant Petyngar Bartholomew hsubandman 586386 586386 Petyngar, Bartholomew, of Weston, hsubandman 0
3662661 1914240 1914240 defendant Chaterton Richard yeoman 586386 586386 Chaterton, Richard, of Weston under Lysyard, yeoman 0
3662662 1914240 1914240 defendant Pykeryng James yeoman 586386 586386 Pykeryng, James, of Weston under Lizard, yeoman 1
3662752 1914272 1914272 plaintiff Muryell Thomas   586386 586386 Muryell, Thomas, of Weston yeoman 0
3663289 1914443 1914443 defendant Yerdley Richard husbandman 586386 586386 Yerdley, Richard, of Weston, husbandman 0
3665249 1915085 1915085 defendant Grene Thomas husbandman 586386 586386 Grene, Thomas, of Weston, husbandman 1
3668710 1916149 1916149 defendant Shepard William laborer 586386 586386 Shepard, William, of Weston, laborer 0
3669857 1916517 1916517 defendant Colson Richard husbandman 586386 586386 Colson, Richard, of Weston, husbandman 2
3669858 1916517 1916517 defendant Colson Robert husbandman 586386 586386 Colson, Robert, of Weston, husbandman 3
3669859 1916517 1916517 defendant Wellys John husbandman 586386 586386 Wellys, John, of Weston, husbandman 4
3674644 1918120 1918120 defendant Shenkewyn Henry husbandman 586386 586386 Shenkewyn, Henry, of Weston, husbandman 2
3676972 1918834 1918834 defendant Peyn John yeoman 586386 586386 Peyn, John, of Weston, yeoman 1
3676978 1918836 1918836 defendant Rosomgrave Thomas pewterer 586386 586386 Rosomgrave, Thomas, of Weston, pewterer 0
3678294 1919268 1919268 defendant Chamber William yeoman 586386 586386 Chamber, William, of Weston, yeoman 0
3681305 1920242 1920242 defendant Milles Richard husbandman 586386 586386 Milles, Richard, of Weston, husbandman 0
3682470 1920618 1920618 defendant Althorn John husbandman 586386 586386 Althorn, John, of Weston, husbandman 1
3684957 1921429 1921429 defendant Grono John husbandman 586386 586386 Grono, John, of Weston under Shokenhille, husbandman 0
3685555 1921631 1921631 defendant Bovys Richard husbandman 586386 586386 Bovys, Richard, of Weston, husbandman 3
3685834 1921727 1921727 defendant Dey William husbandman 586386 586386 Dey, William, of Weston, husbandman 1
3686764 1922014 1922014 defendant Adys John carrier 586386 586386 Adys, John, of Weston, carrier 0
3687448 1922253 1922253 defendant Betyll Thomas husbandman 586386 586386 Betyll, Thomas, of Weston, husbandman 1
3690666 1923245 1923245 defendant Shynkwyn Henry husbandman 586386 586386 Shynkwyn, Henry, of Weston, husbandman 2
3692595 1923870 1923870 defendant Isode Roger husbandman 586386 586386 Isode, Roger, of Weston, husbandman 2
3698182 1925658 1925658 defendant Isod Richard yeoman 586386 586386 Isod, Richard, of Weston, yeoman 0
3700073 1926254 1926254 defendant Grono John husbandman 586386 586386 Grono, John, of Weston, husbandman 1
3706416 1928294 1928294 defendant Feld Thomas husbandman 586386 586386 Feld, Thomas, of Weston, husbandman 0
3706949 1928457 1928457 defendant Colman John husbandman 586386 586386 Colman, John, of Weston, husbandman 2
3709065 1929135 1929135 defendant Nurse Walter husbandman 586386 586386 Nurse, Walter, of Weston under Penyord, husbandman 1
3710082 1929463 1929463 defendant Hesell John tailor 586386 586386 Hesell, John, of Weston, tailor 3
3710427 1929580 1929580 defendant Wegge Thomas husbandman 586386 586386 Wegge, Thomas, of Weston, husbandman 1
3710428 1929580 1929580 defendant Grene Thomas laborer 586386 586386 Grene, Thomas, of Weston, laborer 2
3711092 1929780 1929780 plaintiff Harvy John   586386 586386 Harvy, John, of Weston 2
3714414 1930804 1930804 defendant Parker Thomas yeoman 586386 586386 Parker, Thomas, of Weston under Wetherley, yeoman 0
3720808 1932798 1932798 defendant Seman Thomas husbandman 586386 586386 Seman, Thomas, of Weston, husbandman 0
3722729 1933376 1933376 plaintiff Muryell Thomas   586386 586386 Muryell, Thomas, of Weston 0
3724656 1933993 1933993 defendant Dampere John husbandman 586386 586386 Dampere, John, of Weston, husbandman 1
3725083 1934132 1934132 defendant Adams Thomas yeoman 586386 586386 Adams, Thomas, of Weston, yeoman 0
3725084 1934132 1934132 defendant Adams John laborer 586386 586386 Adams, John, of Weston, laborer 1
3725085 1934132 1934132 defendant Brancke Thomas laborer 586386 586386 Brancke, Thomas, of Weston, laborer 2
3734829 1937136 1937136 defendant Shynkwyn Henry yeoman 586386 586386 Shynkwyn, Henry, of Weston, yeoman 4
3735440 1937322 1937322 plaintiff Harvey John   586386 586386 Harvey, John, of Weston 0
3735441 1937322 1937322 defendant Deynte John husbandman 586386 586386 Deynte, John, of Weston, husbandman 0
3735442 1937322 1937322 defendant Growce or Growte Alice widow 586386 586386 Growce or Growte, Alice, of Weston, widow 1
3735443 1937322 1937322 defendant Jonson Richard husbandman 586386 586386 Jonson, Richard, of Weston, husbandman 2
3735444 1937322 1937322 defendant Lambe Thomas husbandman 586386 586386 Lambe, Thomas, of Weston, husbandman 3
3740998 1939044 1939044 defendant Grene Thomas husbandman 586386 586386 Grene, Thomas, of Weston, husbandman 0
3742680 1939582 1939582 defendant Dalton William husbandman 586386 586386 Dalton, William, of Weston, husbandman 0
3742681 1939582 1939582 defendant Felde Thomas butcher 586386 586386 Felde, Thomas, of Weston, butcher 1
3744649 1940219 1940219 defendant Rigge Walter husbandman 586386 586386 Rigge, Walter, of Weston under Penyorde, husbandman 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);