names

507 rows where place_id = 587004

✎ 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
3590214 1864580 1864580 defendant Skylman John laborer 587004 587004 Skylman, John, of Preston, laborer 4
3605497 1869383 1869383 defendant Preste Richard carpenter 587004 587004 Preste, Richard, of Preston, carpenter 3
3612057 1871415 1871415 defendant ap Howell Ralph yeoman 587004 587004 ap Howell, Ralph, of Preston, yeoman 0
3632677 1905036 1905036 defendant Ryce Thomas yeoman 587004 587004 Ryce, Thomas, of Preston, yeoman 0
3634889 1905713 1905713 defendant Waren Thomas husbandman 587004 587004 Waren, Thomas, of Preston, husbandman 1
3634890 1905713 1905713 defendant Spryng John husbandman 587004 587004 Spryng, John, of Preston, husbandman 2
3636304 1906146 1906146 plaintiff Ranson or Rauson Adam   587004 587004 Ranson or Rauson, Adam, of Preston 0
3637694 1906602 1906602 defendant Sage Richard yeoman 587004 587004 Sage, Richard, of Preston, yeoman 3
3639159 1907063 1907063 defendant Wodefeld Richard yeoman 587004 587004 Wodefeld, Richard, of Preston, yeoman 9
3642372 1908061 1908061 defendant Dyer Hugh yeoman 587004 587004 Dyer, Hugh, of Preston, yeoman 1
3650203 1910434 1910434 defendant Thurger Ralph husbandman 587004 587004 Thurger, Ralph, of Preston, husbandman 1
3655082 1911852 1911852 plaintiff Berker William   587004 587004 Berker, William, of Preston 0
3656471 1912271 1912271 defendant Clement Thomas husbandman 587004 587004 Clement, Thomas, of Preston, husbandman 1
3669148 1916287 1916287 defendant Grave John husbandman 587004 587004 Grave, John, of Preston, husbandman 2
3670514 1916740 1916740 defendant Too Richard husbandman 587004 587004 Too, Richard, of Preston, husbandman 0
3671650 1917121 1917121 plaintiff Colles Richard   587004 587004 Colles, Richard, of Preston 0
3672007 1917244 1917244 defendant Hartwell John esq 587004 587004 Hartwell, John, of Preston, esq 0
3678680 1919396 1919396 defendant Hyll Thomas husbandman 587004 587004 Hyll, Thomas, of Preston, husbandman 2
3680745 1920058 1920058 defendant Reyner John husbandman 587004 587004 Reyner, John, of Preston, husbandman 3
3682593 1920659 1920659 defendant Andrewe John, junior husbandman 587004 587004 Andrewe, John, junior, of Preston, husbandman 0
3690165 1923081 1923081 defendant Palmer John husbandman 587004 587004 Palmer, John, of Preston, husbandman 1
3691715 1923568 1923568 defendant Caket William husbandman 587004 587004 Caket, William, of Preston, husbandman 0
3701873 1926839 1926839 defendant Maunsell Thomas, senior husbandman 587004 587004 Maunsell, Thomas, senior, of Preston, husbandman 0
3701874 1926839 1926839 defendant Maunsell Thomas, junior husbandman 587004 587004 Maunsell, Thomas, junior, of Preston, husbandman 1
3703745 1927450 1927450 defendant Theccher John yeoman 587004 587004 Theccher, John, of Preston, yeoman 2
3710045 1929452 1929452 defendant Stannard Robert laborer 587004 587004 Stannard, Robert, of Preston, laborer 0
3710049 1929453 1929453 plaintiff Ryce Robert yeoman 587004 587004 Ryce, Robert, of Preston, yeoman 0
3710051 1929454 1929454 plaintiff Ryce Robert yeoman 587004 587004 Ryce, Robert, of Preston, yeoman 0
3710056 1929455 1929455 plaintiff Ryce Robert yeoman 587004 587004 Ryce, Robert, of Preston, yeoman 0
3710058 1929456 1929456 plaintiff Ryce Robert yeoman 587004 587004 Ryce, Robert, of Preston, yeoman 0
3710119 1929477 1929477 defendant Thomas Robert clerk 587004 587004 Thomas, Robert, of Preston, clerk 0
3724620 1933983 1933983 plaintiff Ryce Robert yeoman 587004 587004 Ryce, Robert, of Preston, yeoman 0
3728649 1935197 1935197 defendant ap Reis John weaver 587004 587004 ap Reis, John, of Preston, weaver 1
3729457 1935460 1935460 defendant Cosyn alias Alysaunder Robert husbandman 587004 587004 Cosyn alias Alysaunder, Robert, of Preston, husbandman 2
3734693 1937098 1937098 defendant Cofyn Robert laborer 587004 587004 Cofyn, Robert, of Preston, laborer 3
3739615 1938605 1938605 defendant Watson George yeoman 587004 587004 Watson, George, of Preston, yeoman 0
3741457 1939196 1939196 defendant Watson George tailor 587004 587004 Watson, George, of Preston, tailor 0
3741459 1939197 1939197 defendant Watson George tailor 587004 587004 Watson, George, of Preston, tailor 0
3742880 1939628 1939628 defendant Ham John smith 587004 587004 Ham, John, of Preston Candever, smith 0
3746805 1940919 1940919 defendant ap Lewes David gent 587004 587004 ap Lewes, David, of Preston, gent 2
3751018 1942250 1942250 defendant Orrell Lawrence clerk 587004 587004 Orrell, Lawrence, of Preston, clerk 0
3751513 1942387 1942387 defendant Ham John smith 587004 587004 Ham, John, of Preston Candower, smith 0
3758469 1944644 1944644 defendant Orrell Lawrence clerk 587004 587004 Orrell, Lawrence, of Preston, clerk 0
3760654 1945334 1945334 defendant Warner Nicholas husbandman 587004 587004 Warner, Nicholas, of Preston, husbandman 0
3764287 1946489 1946489 defendant Wade Thomas laborer 587004 587004 Wade, Thomas, of Preston, laborer 0
3767920 1947603 1947603 defendant Burton Robert clerk 587004 587004 Burton, Robert, of Preston, clerk 0
3769544 1948135 1948135 defendant Huntyng Thomas carpenter 587004 587004 Huntyng, Thomas, of Preston, carpenter 3
3769545 1948135 1948135 defendant Grey Richard carpenter 587004 587004 Grey, Richard, of Preston, carpenter 4
3773254 1949343 1949343 defendant Wensley John gent 587004 587004 Wensley, John, of Preston, gent 0
3781259 1951878 1951878 defendant Hamlett William husbandman 587004 587004 Hamlett, William, of Preston, husbandman 2
3798060 1957290 1957290 defendant Grawe or Grave John husbandman 587004 587004 Grawe or Grave, John, of Preston, husbandman 1
3800111 1957959 1957959 defendant Walle William gent 587004 587004 Walle, William, of Preston, gent 1
3803641 1959053 1959053 plaintiff Rise   yeoman 587004 587004 Rise, , of Preston, yeoman 0
3803939 1959147 1959147 plaintiff Ryse Robert yeoman 587004 587004 Ryse, Robert, of Preston, yeoman 0
3808605 1960571 1960571 defendant Davyes William clerk 587004 587004 Davyes, William, of Preston, clerk 1
3810140 1961061 1961061 defendant Hartwell John esq 587004 587004 Hartwell, John, of Preston, esq 0
3820106 1964167 1964167 defendant Grenehod Richard yeoman 587004 587004 Grenehod, Richard, of Preston, yeoman 0
3820107 1964167 1964167 defendant Grenehod Agnes widow 587004 587004 Grenehod, Agnes, of Preston, widow 1
3821334 1964564 1964564 defendant Elys John miller 587004 587004 Elys, John, of Preston, miller 1
3822830 1965048 1965048 defendant Cosyn Robert laborer 587004 587004 Cosyn, Robert, of Preston, laborer 2
3822831 1965048 1965048 defendant Mody Robert husbandman 587004 587004 Mody, Robert, of Preston, husbandman 3
3830578 1967441 1967441 defendant Bageley Roger husbandman 587004 587004 Bageley, Roger, of Preston, husbandman 2
3841014 1970759 1970759 defendant Wigilworth John husbandman 587004 587004 Wigilworth, John, of Preston, husbandman 0
3846938 1972583 1972583 plaintiff Gyttowe John   587004 587004 Gyttowe, John, of preston 0
3852833 1974495 1974495 plaintiff Ryce Robert gent 587004 587004 Ryce, Robert, of Preston, gent 0
3852862 1974505 1974505 plaintiff Ryse Robert gent 587004 587004 Ryse, Robert, of Preston, gent 0
3854913 1975181 1975181 defendant Yong Richard chaplain 587004 587004 Yong, Richard, of Preston, chaplain 0
3854915 1975182 1975182 defendant Yong Richard chaplain 587004 587004 Yong, Richard, of Preston, chaplain 0
3855719 1975423 1975423 defendant Dyer John yeoman 587004 587004 Dyer, John, of Preston, yeoman 1
3859268 1976593 1976593 defendant Dryver Edmund husbandman 587004 587004 Dryver, Edmund, of Preston, husbandman 0
3859662 1976729 1976729 defendant Sibelys Richard yeoman 587004 587004 Sibelys, Richard, of Preston, yeoman 1
3861470 1977296 1977296 defendant Bagaley Roger husbandman 587004 587004 Bagaley, Roger, of Preston, husbandman 0
3877667 1982773 1982773 defendant Hame John smith 587004 587004 Hame, John, of Preston Candever, smith 1
3879976 1983561 1983561 defendant Watson George yeoman 587004 587004 Watson, George, of Preston, yeoman 0
3882917 1984552 1984552 defendant Watson Michael husbandman 587004 587004 Watson, Michael, of Preston, husbandman 0
3883003 1984580 1984580 defendant Edwardys John butcher 587004 587004 Edwardys, John, of Preston Candever, butcher 0
3894929 1988513 1988513 defendant Wyllesby Christopher husbandman 587004 587004 Wyllesby, Christopher, of Preston, husbandman 0
3894930 1988513 1988513 defendant Smyth Thomas husbandman 587004 587004 Smyth, Thomas, of Preston, husbandman 1
3901644 1990779 1990779 defendant Scomeler Anthony chaplain 587004 587004 Scomeler, Anthony, of Preston, chaplain 0
3901646 1990779 1990779 defendant Ireland Thomas   587004 587004 Ireland, Thomas, of Preston, mason 2
3904959 1991920 1991920 defendant ap John Walter laborer 587004 587004 ap John, Walter, of Preston, laborer 0
3907724 1992871 1992871 defendant Hamlett John yeoman 587004 587004 Hamlett, John, of Preston, yeoman 2
3910000 1993651 1993651 defendant Fordham Thomas laborer 587004 587004 Fordham, Thomas, of Preston, laborer 2
3914907 1995334 1995334 defendant Thompson Marmaduke clerk 587004 587004 Thompson, Marmaduke, of Preston, clerk 0
3916488 1995892 1995892 defendant Cooke John husbandman 587004 587004 Cooke, John, of Preston, husbandman 1
3919888 1996984 1996984 defendant Syngleton Randolph gent 587004 587004 Syngleton, Randolph, of Preston, gent 1
3920107 1997059 1997059 defendant Tayler John husbandman 587004 587004 Tayler, John, of Preston, husbandman 1
3928384 1999832 1999832 defendant Baggley Roger husbandman 587004 587004 Baggley, Roger, of Preston, husbandman 0
3928996 2000036 2000036 defendant Taylor Henry yeoman 587004 587004 Taylor, Henry, of Preston, yeoman 0
3928997 2000036 2000036 defendant Welles Richard husbandman 587004 587004 Welles, Richard, of Preston, husbandman 1
3948643 2006585 2006585 defendant Browne Richard miller 587004 587004 Browne, Richard, of Preston, miller 0
3949601 2006936 2006936 defendant Holmes John smith 587004 587004 Holmes, John, of Preston, smith 0
3949602 2006936 2006936 defendant Bowcher Ralph husbandman 587004 587004 Bowcher, Ralph, of Preston, husbandman 1
3967682 2013331 2013331 defendant Smyth John carpenter 587004 587004 Smyth, John, of Preston, carpenter 1
3971832 2014709 2014709 plaintiff Firmyn Robert   587004 587004 Firmyn, Robert, of Preston 0
3972352 2014902 2014902 plaintiff Fyrmyn Robert   587004 587004 Fyrmyn, Robert, of Preston 0
3981105 2017999 2017999 defendant Pryor Robert husbandman 587004 587004 Pryor, Robert, of Preston, husbandman 1
3988469 2020620 2020620 plaintiff Apowell Thomas yeoman 587004 587004 Apowell, Thomas, of Preston, yeoman 0
3993515 2022426 2022426 defendant Ryche Stephen (legal representative) 587004 587004 Ryche, Stephen, of Preston, husbandman, executrix of 0
3993516 2022426 2022426 defendant Ryche Joan widow 587004 587004 Ryche, Joan, of Preston, widow 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);