names

70 rows where place_id = 624092

✎ 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
3756099 1943864 1943864 defendant Anyson Thomas husbandman 624092 624092 Anyson, Thomas, of Susted, husbandman 2
3757237 1944249 1944249 plaintiff Bek Clement (legal representative) 624092 624092 Bek, Clement, of Susted, executrix of 0
3773794 1949518 1949518 defendant Yong Thomas laborer 624092 624092 Yong, Thomas, of Susted, laborer 3
3775696 1950146 1950146 defendant Everard John husbandman 624092 624092 Everard, John, of Susted, husbandman 2
3798312 1957370 1957370 defendant Everard John husbandman 624092 624092 Everard, John, of Susted, husbandman 3
3827713 1966533 1966533 defendant Newman Nicholas chapman 624092 624092 Newman, Nicholas, of Susted, chapman 0
3828197 1966688 1966688 defendant Everard John husbandman 624092 624092 Everard, John, of Susted, husbandman 0
3828198 1966688 1966688 defendant Andrewe Simon husbandman 624092 624092 Andrewe, Simon, of Susted, husbandman 1
3830139 1967325 1967325 defendant Andrewe Thomas   624092 624092 Andrewe, Thomas, of Susted, mason 2
3837262 1969561 1969561 defendant Everard John husbandman 624092 624092 Everard, John, of Susted, husbandman 0
3838909 1970095 1970095 defendant Numan Nicholas mercer 624092 624092 Numan, Nicholas, of Susted, mercer 0
3839772 1970368 1970368 defendant Newman Nicholas mercer 624092 624092 Newman, Nicholas, of Susted, mercer 0
3839925 1970422 1970422 defendant Beke William husbandman 624092 624092 Beke, William, of Susted, husbandman 1
3839926 1970422 1970422 defendant Yong alias Yonger Thomas laborer 624092 624092 Yong alias Yonger, Thomas, of Susted, laborer 2
3847363 1972737 1972737 defendant Harwyn William husbandman 624092 624092 Harwyn, William, of Susted, husbandman 0
3851406 1974039 1974039 defendant Numan Nicholas mercer 624092 624092 Numan, Nicholas, of Susted, mercer 1
3851699 1974119 1974119 defendant Harwyn William yeoman 624092 624092 Harwyn, William, of Susted, yeoman 0
3852117 1974257 1974257 defendant Everard John husbandman 624092 624092 Everard, John, of Susted, husbandman 4
3866180 1978917 1978917 defendant Harwyn William yeoman 624092 624092 Harwyn, William, of Susted, yeoman 1
3866181 1978917 1978917 defendant Everard John husbandman 624092 624092 Everard, John, of Susted, husbandman 2
3880463 1983721 1983721 defendant Bekke William husbandman 624092 624092 Bekke, William, of Susted, husbandman 4
3882134 1984283 1984283 defendant Bekke William husbandman 624092 624092 Bekke, William, of Susted, husbandman 0
3882295 1984337 1984337 defendant Bekke William husbandman 624092 624092 Bekke, William, of Susted, husbandman 0
3882711 1984481 1984481 defendant Farnell John husbandman 624092 624092 Farnell, John, of Susted, husbandman 1
3895232 1988613 1988613 defendant Abbis Thomas husbandman 624092 624092 Abbis, Thomas, of Susted, husbandman 0
3895397 1988670 1988670 defendant Harwyn William husbandman 624092 624092 Harwyn, William, of Susted, husbandman 1
3900732 1990473 1990473 defendant Everard John husbandman 624092 624092 Everard, John, of Susted, husbandman 1
3900733 1990473 1990473 defendant Andrewes Simon husbandman 624092 624092 Andrewes, Simon, of Susted, husbandman 2
3907362 1992752 1992752 defendant Bek William yeoman 624092 624092 Bek, William, of Susted, yeoman 0
3913353 1994802 1994802 defendant Swyfte Richard, senior miller 624092 624092 Swyfte, Richard, senior, of Susted, miller 0
3913354 1994802 1994802 defendant Swyfte Richard, junior laborer 624092 624092 Swyfte, Richard, junior, of Susted, laborer 1
3913356 1994802 1994802 defendant Smyth Alice widow 624092 624092 Smyth, Alice, of Susted, widow 3
3924920 1998654 1998654 defendant Gambyll Edmund husbandman 624092 624092 Gambyll, Edmund, of Susted, husbandman 0
3924921 1998654 1998654 defendant Douty or Donty John husbandman 624092 624092 Douty or Donty, John, of Susted, husbandman 1
3965590 2012579 2012579 defendant Andrewes Robert   624092 624092 Andrewes, Robert, of Susted, rough mason 0
4030367 2035513 2035513 defendant Bates Nicholas yeoman 624092 624092 Bates, Nicholas, of Susted, yeoman 0
4053000 2043505 2043505 defendant Whytynge Walter gent 624092 624092 Whytynge,Walter, of Susted, gent 5
4196849 2094447 2094447 defendant Christmas Robert husbandman 624092 624092 Christmas, Robert, of Susted, husbandman 0
4222369 2103314 2103314 defendant Chrismas Thomas, junior singleman 624092 624092 Chrismas, Thomas, junior, of Susted, yeoman, singleman 0
4222370 2103314 2103314 defendant Chrismas Thomas, senior husbandman 624092 624092 Chrismas, Thomas, senior, of Susted, husbandman 1
4249069 2112672 2112672 defendant Ixforth James yeoman 624092 624092 Ixforth, James, of Susted, yeoman 3
4257835 2115595 2115595 defendant Marys William husbandman 624092 624092 Marys, William, of Susted, husbandman 3
4312496 2134505 2134505 defendant Secker Edmund husbandman 624092 624092 Secker, Edmund, of Susted, husbandman 2
4333604 2141522 2141522 defendant Christmas Thomas, junior husbandman 624092 624092 Christmas, Thomas, junior, of Susted, husbandman 0
4333605 2141522 2141522 defendant Christmas Thomas, senior husbandman 624092 624092 Christmas, Thomas, senior, of Susted, husbandman 1
4351144 2147649 2147649 defendant Beckler James yeoman 624092 624092 Beckler, James, of Susted, yeoman 0
4351350 2147722 2147722 defendant Androwes Thomas   624092 624092 Androwes, Thomas, of Susted, rough mason 0
4389371 2161070 2161070 defendant Ixworth James yeoman 624092 624092 Ixworth, James, of Susted, yeoman 3
4947349 2341165 2341165 defendant Dam John gent 624092 624092 (Dam, John, of Susted, gent 1
4990712 2354133 2354133 plaintiff Chever Richard   624092 624092 Chever, Richard, of Susted 0
4998499 2356432 2356432 plaintiff Juys or Inys William husbandman 624092 624092 Juys or Inys, William, of Susted, husbandman 0
5000995 2357169 2357169 defendant Dam John gent 624092 624092 Dam, John, of Susted, gent 3
5003489 2357916 2357916 plaintiff Damme John   624092 624092 Damme, John, of Susted 4
5136912 2397313 2397313 plaintiff Damme John   624092 624092 Damme, John, of Susted 4
5136917 2397314 2397314 plaintiff Daune John   624092 624092 Daune, John, of Susted 3
5148760 2400760 2400760 plaintiff Damme John   624092 624092 Damme, John, of Susted 0
5157473 2403319 2403319 plaintiff Damme John   624092 624092 Damme, John, of Susted 4
5256747 2432231 2432231 defendant Latte John husbandman 624092 624092 Latte, John, of Susted, husbandman 2
5333387 2455057 2455057 defendant Halle Cecily spinster 624092 624092 Halle, Cecily, of Susted, spinster 9
5340530 2457235 2457235 defendant Catte John husbandman 624092 624092 Catte, John, of Susted, husbandman 4
5380843 2469575 2469575 defendant Catte John (legal representative) 624092 624092 Catte, John, of Susted, executor of 0
5380844 2469575 2469575 defendant Catte Robert   624092 624092 Catte, Robert, of Susted 1
5435271 2485481 2485481 defendant Baunne Simon gent 624092 624092 Baunne, Simon, of Susted, gent 0
5462482 2493683 2493683 defendant Daume Simon gent 624092 624092 Daume, Simon, of Susted, gent 0
5495359 2503512 2503512 defendant Holme John husbandman 624092 624092 Holme, John, of Susted, husbandman 0
5495361 2503513 2503513 defendant Holme John husbandman 624092 624092 Holme, John, of Susted, husbandman 0
5522618 2511900 2511900 defendant Damme Simon (legal representative) 624092 624092 Damme, Simon, of Susted, gent, executor of 0
5522619 2511900 2511900 defendant Damme Elia widow 624092 624092 Damme, Elia, of Susted, widow 1
5582087 2529467 2529467 defendant Makke Richard clerk 624092 624092 Makke, Richard, of Susted, clerk 0
5582088 2529467 2529467 defendant Bekke Clement yeoman 624092 624092 Bekke, Clement, of Susted, yeoman 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);