names

321 rows where place_id = 588373

✎ 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
3594288 1865850 1865850 defendant Burdon William   588373 588373 Burdon, William, of Rosse 0
3594309 1865853 1865853 defendant Burdon William yeoman 588373 588373 Burdon, William, of Rosse, yeoman 1
3596409 1866507 1866507 defendant Glover Richard yeoman 588373 588373 Glover, Richard, of Rosse, yeoman 0
3601284 1868067 1868067 defendant William Philip gent 588373 588373 William, Philip, of Rosse, gent 0
3603492 1868758 1868758 defendant Corser John cordwainer 588373 588373 Corser, John, of Rosse, cordwainer 0
3603494 1868759 1868759 defendant Corser John cordwainer 588373 588373 Corser, John, of Rosse, cordwainer 0
3603496 1868760 1868760 defendant Corser John cordwainer 588373 588373 Corser, John, of Rosse, cordwainer 0
3619281 1873633 1873633 defendant Wattis Sybil widow 588373 588373 Wattis, Sybil, of Rosse, widow 0
3619282 1873633 1873633 defendant Wattis William weaver 588373 588373 Wattis, William, of Rosse, weaver 1
3619597 1873699 1873699 defendant Buklond Richard innholder 588373 588373 Buklond, Richard, of Rosse, innholder 0
3624902 1875323 1875323 defendant Neweton James gent 588373 588373 Neweton, James, of Rosse, gent 1
3624903 1875323 1875323 defendant Corser Swilliam courser 588373 588373 Corser, Swilliam, of Rosse, courser 2
3647635 1909646 1909646 defendant Smyth John smith 588373 588373 Smyth, John, of Rosse, smith 0
3662000 1914046 1914046 defendant Tounnys or Tommys William butcher 588373 588373 Tounnys or Tommys, William, of Rosse, butcher 0
3670508 1916738 1916738 defendant Lovell Nicholas yeoman 588373 588373 Lovell, Nicholas, of Rosse, yeoman 0
3677181 1918905 1918905 defendant Bockelond Thomas butcher 588373 588373 Bockelond, Thomas, of Rosse, butcher 1
3692719 1923911 1923911 defendant Hyde William, junior baker 588373 588373 Hyde, William, junior, of Rosse, baker 0
3692721 1923911 1923911 defendant Tanne Thomas tanner 588373 588373 Tanne, Thomas, of Rosse, tanner 2
3699639 1926116 1926116 defendant Baker Roger yeoman 588373 588373 Baker, Roger, of Rosse, yeoman 0
3715608 1931168 1931168 defendant Lewys Robert yeoman 588373 588373 Lewys, Robert, of Rosse, yeoman 0
3728096 1935047 1935047 plaintiff Worcetur Thomas (legal representative) 588373 588373 Worcetur, Thomas, of Rosse, executor of 0
3728098 1935047 1935047 defendant Lewys Robert yeoman 588373 588373 Lewys, Robert, of Rosse, yeoman 0
3730267 1935696 1935696 defendant Nicholl Henry butcher 588373 588373 Nicholl, Henry, of Rosse, butcher 0
3733369 1936669 1936669 defendant Lewys Robert   588373 588373 Lewys, Robert, of Rosse yeoman 0
3733371 1936670 1936670 defendant Lewys Robert yeoman 588373 588373 Lewys, Robert, of Rosse, yeoman 0
3733373 1936671 1936671 defendant Lewys Robert yeoman 588373 588373 Lewys, Robert, of Rosse, yeoman 0
3742899 1939634 1939634 defendant Taylor William mercer 588373 588373 Taylor, William, of Rosse, mercer 4
3743560 1939862 1939862 plaintiff Worcetur Thomas (legal representative) 588373 588373 Worcetur, Thomas, of Rosse, executor of 0
3743562 1939862 1939862 defendant Lewys Robert yeoman 588373 588373 Lewys, Robert, of Rosse, yeoman 0
3743853 1939963 1939963 plaintiff Wyrcetour Thomas (legal representative) 588373 588373 Wyrcetour, Thomas, of Rosse, executor of 0
3743855 1939963 1939963 defendant Lewys Robert   588373 588373 Lewys, Robert, of Rosse yeoman 0
3757664 1944376 1944376 defendant Dyer Lewis yeoman 588373 588373 Dyer, Lewis, of Rosse, yeoman 0
3757665 1944376 1944376 defendant Brown Roger mercer 588373 588373 Brown, Roger, of Rosse, mercer 1
3757668 1944376 1944376 defendant Philpott Robert yeoman 588373 588373 (Philpott, Robert, of Rosse, yeoman 4
3757669 1944376 1944376 defendant Maddok William yeoman 588373 588373 Maddok, William, of Rosse, yeoman 5
3806600 1959964 1959964 defendant Abrehale Thomas gent 588373 588373 Abrehale, Thomas, of Rosse, gent 2
3806826 1960039 1960039 defendant Browne Roger mercer 588373 588373 Browne, Roger, of Rosse, mercer 0
3816982 1963219 1963219 defendant Nychols Henry butcher 588373 588373 Nychols, Henry, of Rosse, butcher 0
3826451 1966121 1966121 defendant Peterstowe Richard tanner 588373 588373 Peterstowe, Richard, of Rosse, tanner 0
3840529 1970599 1970599 defendant Tayler William laborer 588373 588373 Tayler, William, of Rosse, laborer 0
3840530 1970599 1970599 defendant Barker Robert   588373 588373 Barker, Robert, of Rosse 1
3840531 1970599 1970599 defendant Payntur John yeoman 588373 588373 Payntur, John, of Rosse,yeoman 2
3840532 1970599 1970599 defendant Davys Thomas yeoman 588373 588373 Davys, Thomas, of Rosse, yeoman 3
3840535 1970599 1970599 defendant Stowell John carpenter 588373 588373 Stowell, John, of Rosse, carpenter 6
3840536 1970599 1970599 defendant Tayler William tailor 588373 588373 Tayler, William, of Rosse, tailor 7
3886709 1985810 1985810 defendant Covurley John husbandman 588373 588373 Covurley, John, of Rosse, husbandman 2
3896894 1989173 1989173 defendant Olyver John clerk 588373 588373 Olyver, John, of Rosse, clerk 0
3896899 1989175 1989175 defendant Olyver alias Smith John clerk 588373 588373 Olyver alias Smith, John, of Rosse, clerk 0
3902077 1990928 1990928 defendant Yonge Henry laborer 588373 588373 Yonge, Henry, of Rosse, laborer 0
3902078 1990928 1990928 defendant Yonge Walter laborer 588373 588373 Yonge, Walter, of Rosse, laborer 1
3902080 1990929 1990929 defendant Waves Richard husbandman 588373 588373 Waves, Richard, of Rosse, husbandman 0
3902081 1990929 1990929 defendant Underwood Philip husbandman 588373 588373 Underwood, Philip, of Rosse, husbandman 1
3913247 1994761 1994761 defendant Pryst John innholder 588373 588373 Pryst, John, of Rosse, innholder 0
3913426 1994827 1994827 defendant Cowley John husbandman 588373 588373 Cowley, John, of Rosse, husbandman 2
3929560 2000235 2000235 defendant Cornewell John weaver 588373 588373 Cornewell, John, of Rosse, weaver 0
3943449 2004824 2004824 defendant Collyns John yeoman 588373 588373 Collyns, John, of Rosse, yeoman 1
3943494 2004842 2004842 defendant Vaughan Thomas gent 588373 588373 Vaughan, Thomas, of Rosse, gent 0
3943495 2004842 2004842 defendant Madock William yeoman 588373 588373 Madock, William, of Rosse, yeoman 1
3943496 2004842 2004842 defendant Nycholl Richard yeoman 588373 588373 Nycholl, Richard, of Rosse, yeoman 2
3963522 2011849 2011849 defendant Stowell Walter yeoman 588373 588373 Stowell, Walter, of Rosse, yeoman 1
3963623 2011887 2011887 defendant Dyer Richard yeoman 588373 588373 Dyer, Richard, of Rosse, yeoman 0
3966929 2013065 2013065 defendant Prychard John tanner 588373 588373 Prychard, John, of Rosse, tanner 3
3966934 2013066 2013066 defendant Prychard John tanner 588373 588373 Prychard, John, of Rosse, tanner 3
3975263 2015917 2015917 defendant Cooke Thomas weaver 588373 588373 Cooke, Thomas, of Rosse, weaver 0
3997448 2023834 2023834 defendant Fyrret William cordwainer 588373 588373 Fyrret, William, of Rosse, cordwainer 0
4002456 2025648 2025648 plaintiff Hagger Thomas   588373 588373 Hagger, Thomas, of Rosse yeoman 1
4011239 2028793 2028793 defendant Somner William yeoman 588373 588373 Somner, William, of Rosse, yeoman 0
4022380 2032729 2032729 defendant Web Richard cordwainer 588373 588373 Web, Richard, of Rosse, cordwainer 0
4035116 2037237 2037237 defendant Bullyngton John capper 588373 588373 Bullyngton, John, of Rosse, capper 0
4038896 2038531 2038531 defendant Hall William butcher 588373 588373 Hall, William, of Rosse, butcher 1
4040217 2039005 2039005 defendant Bullyngton John capper 588373 588373 Bullyngton, John, of Rosse, capper 0
4041537 2039466 2039466 defendant Wylse Richard draper 588373 588373 Wylse, Richard, of Rosse, draper 0
4041796 2039548 2039548 defendant Wylse Richard draper 588373 588373 Wylse, Richard, of Rosse, draper 0
4041832 2039561 2039561 plaintiff Nycoll Richard (legal representative) 588373 588373 Nycoll, Richard, of Rosse, gent, executor of 0
4042461 2039781 2039781 defendant Hall John butcher 588373 588373 Hall, John, of Rosse, butcher 12
4042475 2039782 2039782 defendant Hall John butcher 588373 588373 Hall, John, of Rosse, butcher 12
4048404 2041875 2041875 defendant Tomes Richard yeoman 588373 588373 Tomes, Richard, of Rosse, yeoman 0
4050349 2042556 2042556 defendant Wylse Richard mercer 588373 588373 Wylse, Richard, of Rosse, mercer 1
4050352 2042557 2042557 defendant Wylse Richard mercer 588373 588373 Wylse, Richard, of Rosse, mercer 1
4066925 2048467 2048467 defendant Nycoll Thomas gent 588373 588373 Nycoll, Thomas, of Rosse, gent 4
4072138 2050335 2050335 plaintiff Nyccoll or Nicolls Thomas gent 588373 588373 Nyccoll or Nicolls, Thomas, of Rosse, gent 0
4072139 2050335 2050335 defendant Wylshe William butcher 588373 588373 Wylshe, William, of Rosse, butcher 0
4072141 2050336 2050336 defendant Wylshe William butcher 588373 588373 Wylshe, William, of Rosse, butcher 0
4074723 2051259 2051259 defendant Vaughan Giles yeoman 588373 588373 Vaughan, Giles, of Rosse, yeoman 1
4074725 2051259 2051259 defendant Noblett John yeoman 588373 588373 Noblett, John, of Rosse, yeoman 3
4078539 2052622 2052622 defendant Cater Thomas yeoman 588373 588373 Cater, Thomas, of Rosse, yeoman 0
4079783 2053069 2053069 defendant Cater William capper 588373 588373 Cater, William, of Rosse, capper 2
4086906 2055609 2055609 defendant Belamy Thomas yeoman 588373 588373 Belamy, Thomas, of Rosse, yeoman 0
4086907 2055609 2055609 defendant Nycoll Thomas gent 588373 588373 Nycoll, Thomas, of Rosse, gent 1
4094816 2058479 2058479 defendant Stowell Walter yeoman 588373 588373 Stowell, Walter, of Rosse, yeoman 1
4094817 2058479 2058479 defendant Cocke John cordwainer 588373 588373 Cocke, John, of Rosse, cordwainer 2
4094821 2058480 2058480 defendant Stowell Walter yeoman 588373 588373 Stowell, Walter, of Rosse, yeoman 1
4094822 2058480 2058480 defendant Cooke John cordwainer 588373 588373 Cooke, John, of Rosse, cordwainer 2
4099995 2060325 2060325 defendant Niccoll Thomas tanner 588373 588373 Niccoll, Thomas, of Rosse, tanner 1
4102315 2061119 2061119 defendant Nycoll Thomas gent 588373 588373 Nycoll, Thomas, of Rosse, gent 0
4103930 2061682 2061682 defendant Baylye Ralph husbandman 588373 588373 Baylye, Ralph, of Rosse, husbandman 0
4103932 2061683 2061683 defendant Bellamye Thomas yeoman 588373 588373 Bellamye, Thomas, of Rosse, yeoman 0
4112058 2064567 2064567 defendant Gorwey Thomas shoemaker 588373 588373 Gorwey, Thomas, of Rosse, shoemaker 0
4112059 2064567 2064567 defendant Worne Henry shoemaker 588373 588373 Worne, Henry, of Rosse, shoemaker 1
4114895 2065613 2065613 defendant Hyll William husbandman 588373 588373 Hyll, William, of Rosse, husbandman 0

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