names

71 rows where place_id = 621281

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3740532 1938898 1938898 defendant Marvyn John husbandman 621281 621281 Marvyn, John, of Layham, husbandman 0
3740534 1938898 1938898 defendant Wylys Robert husbandman 621281 621281 Wylys, Robert, of Layham, husbandman 2
3777608 1950748 1950748 defendant Condall Richard laborer 621281 621281 Condall, Richard, of Layham, laborer 4
3930615 2000583 2000583 defendant Blosse Peter yeoman 621281 621281 Blosse, Peter, of Layham, yeoman 1
3975025 2015827 2015827 defendant Blese Peter husbandman 621281 621281 Blese, Peter, of Layham, husbandman 0
3987375 2020233 2020233 defendant Grene John   621281 621281 Grene, John, of Layham, ash burner 0
3987376 2020233 2020233 defendant Tomson Robert tanner 621281 621281 Tomson, Robert, of Layham, tanner 1
4036776 2037840 2037840 defendant Rolse or Rolfe William sherman 621281 621281 Rolse or Rolfe, William, of Layham, sherman 1
4055175 2044243 2044243 defendant Woodroff William clerk 621281 621281 Woodroff, William, of Layham, clerk 3
4058420 2045397 2045397 defendant Sparlyng John husbandman 621281 621281 Sparlyng, John, of Layham, husbandman 1
4062439 2046855 2046855 defendant Wever John husbandman 621281 621281 Wever, John, of Layham, husbandman 1
4062975 2047061 2047061 defendant Bloyse Robert husbandman 621281 621281 Bloyse, Robert, of Layham, husbandman 0
4090304 2056817 2056817 defendant Turnor William yeoman 621281 621281 Turnor, William, of Layham, yeoman 1
4118152 2066776 2066776 defendant Waynwright Richard yeoman 621281 621281 Waynwright, Richard, of Layham, yeoman 0
4122236 2068257 2068257 defendant Hayward John husbandman 621281 621281 Hayward, John, of Layham, husbandman 0
4137627 2073810 2073810 defendant Clarke Robert husbandman 621281 621281 Clarke, Robert, of Layham, or of Hadleighe, husbandman 0
4137632 2073812 2073812 defendant Hall alias Harman Christian spinster 621281 621281 Hall alias Harman, Christian, of Layham, spinster 0
4138707 2074210 2074210 defendant Water William husbandman 621281 621281 Water, William, of Layham, husbandman 2
4140086 2074700 2074700 defendant Wetyng Walter husbandman 621281 621281 Wetyng, Walter, of Layham, husbandman 0
4145044 2076428 2076428 defendant Chapman Thomas butcher 621281 621281 Chapman, Thomas, of Layham, butcher 0
4151030 2078490 2078490 defendant Woodroffe William clerk 621281 621281 Woodroffe, William, of Layham, clerk 2
4151776 2078738 2078738 defendant Blosse Robert yeoman 621281 621281 Blosse, Robert, of Layham, yeoman 1
4152021 2078818 2078818 defendant Woodroff William clerk 621281 621281 Woodroff, William, of Layham, clerk 0
4155487 2080005 2080005 defendant Chapman Thomas butcher 621281 621281 Chapman, Thomas, of Layham, butcher 1
4159367 2081346 2081346 defendant Clarke Robert husbandman 621281 621281 Clarke, Robert, of Layham, husbandman 1
4162046 2082283 2082283 defendant Clarke Robert husbandman 621281 621281 Clarke, Robert, of Layham, or of Hadleighe, husbandman 0
4167723 2084201 2084201 defendant Chadwick William yeoman 621281 621281 Chadwick, William, of Layham, yeoman 0
4172071 2085696 2085696 defendant Chapman Thomas yeoman 621281 621281 Chapman, Thomas, of Layham, yeoman 0
4172072 2085696 2085696 defendant Weaver John husbandman 621281 621281 Weaver, John, of Layham, husbandman 1
4193062 2093141 2093141 defendant Munnynge Robert husbandman 621281 621281 Munnynge, Robert, of Layham, husbandman 0
4193063 2093141 2093141 defendant Kynge John husbandman 621281 621281 Kynge, John, of Layham, husbandman 1
4193065 2093141 2093141 defendant Hayward John husbandman 621281 621281 Hayward, John, of Layham, husbandman 3
4195057 2093835 2093835 defendant Monnyng Robert gent 621281 621281 Monnyng, Robert, of Layham, gent 1
4281101 2123290 2123290 defendant Tabret John yeoman 621281 621281 Tabret, John, of Layham, yeoman 1
4281739 2123518 2123518 defendant Sherwood Henry miller 621281 621281 Sherwood, Henry, of Layham, husbandman, miller 0
4281740 2123518 2123518 defendant Bull Thomas   621281 621281 Bull, Thomas, of Layham, wheelwright 1
4281741 2123518 2123518 defendant Bull Stephen   621281 621281 Bull, Stephen, of Layham, wheelwright 2
4284246 2124417 2124417 defendant Doyly Edward gent 621281 621281 Doyly, Edward, of Layham, gent 1
4290028 2126498 2126498 defendant Hunt Edmund tanner 621281 621281 Hunt, Edmund, of Layham, tanner 0
4303983 2131525 2131525 defendant Sturgyon James yeoman 621281 621281 Sturgyon, James, of Layham, yeoman 1
4304167 2131589 2131589 defendant Wodroffe William clerk 621281 621281 Wodroffe, William, of Layham, clerk 3
4325463 2138892 2138892 defendant Hall Edward yeoman 621281 621281 Hall, Edward, of Layham, yeoman 0
4325465 2138892 2138892 defendant Tabrett John yeoman 621281 621281 Tabrett, John, of Layham, yeoman 2
4333002 2141323 2141323 defendant Ive John yeoman 621281 621281 Ive, John, of Layham, yeoman 0
4333798 2141585 2141585 defendant Brooke John yeoman 621281 621281 Brooke, John, of Layham, yeoman 0
4333800 2141586 2141586 defendant Stoddard Nicholas gent 621281 621281 Stoddard, Nicholas, of Layham, gent 0
4336309 2142434 2142434 defendant Chapman Thomas yeoman 621281 621281 Chapman, Thomas, of Layham, yeoman 0
4336311 2142435 2142435 defendant Cowper John yeoman 621281 621281 Cowper, John, of Layham, yeoman 0
4336313 2142436 2142436 defendant Wever John yeoman 621281 621281 Wever, John, of Layham, yeoman 0
4338993 2143395 2143395 defendant Weaver John yeoman 621281 621281 Weaver, John, of Layham, yeoman 0
4343524 2145012 2145012 defendant Martyn Mathew husbandman 621281 621281 Martyn, Mathew, of Layham, husbandman 1
4347275 2146305 2146305 defendant Cowper John yeoman 621281 621281 Cowper, John, of Layham, yeoman 1
4354575 2148835 2148835 defendant Martyn Edmund husbandman 621281 621281 Martyn, Edmund, of Layham, husbandman 2
4356539 2149518 2149518 defendant Chapman Thomas, senior butcher 621281 621281 Chapman, Thomas, senior, of Layham, butcher 0
4356693 2149571 2149571 defendant Martyn Henry husbandman 621281 621281 Martyn, Henry, of Layham, husbandman 1
4363371 2151971 2151971 defendant Tompson Robert tanner 621281 621281 Tompson, Robert, of Layham, tanner 0
4386719 2160233 2160233 defendant Hall Christiana widow 621281 621281 Hall, Christiana, of Layham, widow 3
4388330 2160728 2160728 defendant Weaver John yeoman 621281 621281 Weaver, John, of Layham, yeoman 0
4389804 2161215 2161215 defendant Baker Thomas husbandman 621281 621281 Baker, Thomas, of Layham, husbandman 0
4389807 2161215 2161215 defendant Pope William husbandman 621281 621281 Pope, William, of Layham, husbandman 3
4393690 2162492 2162492 defendant Hall Christina widow 621281 621281 Hall, Christina, of Layham, widow 1
4400192 2164655 2164655 defendant Knapp John husbandman 621281 621281 Knapp, John, of Layham, husbandman 0
4400206 2164660 2164660 defendant Baker Thomas husbandman 621281 621281 Baker, Thomas, of Layham, husbandman 0
4400207 2164660 2164660 defendant Podd William husbandman 621281 621281 Podd, William, of Layham, husbandman 1
4400208 2164660 2164660 defendant Gadyner Michael husbandman 621281 621281 Gadyner, Michael, of Layham, husbandman 2
4408949 2167596 2167596 defendant Stoddarde Nicholas gent 621281 621281 Stoddarde, Nicholas, of Layham, gent 0
4409797 2167879 2167879 defendant Kinge John husbandman 621281 621281 Kinge, John, of Layham, husbandman 0
4409798 2167879 2167879 defendant Martyn Edmund yeoman 621281 621281 Martyn Edmund, of Layham, yeoman 1
4409799 2167879 2167879 defendant Martyn Mathew yeoman 621281 621281 Martyn, Mathew, of Layham, yeoman 2
4410384 2168072 2168072 defendant Downinge Robert butcher 621281 621281 Downinge, Robert, of Layham, butcher 0
4412495 2168769 2168769 defendant Haywarde John husbandman 621281 621281 Haywarde, John, of Layham, yeoman, or of Myldyng, husbandman 1

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