names

151 rows where place_id = 592497

✎ 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
3607888 1870116 1870116 defendant Thorold John gent 592497 592497 Thorold, John, of Marston, gent 0
3625405 1875484 1875484 defendant Acrode William clerk 592497 592497 Acrode, William, of Marston, clerk 1
3625406 1875484 1875484 defendant Bacheler William husbandman 592497 592497 Bacheler, William, of Marston, husbandman 2
3625407 1875484 1875484 defendant Watson William husbandman 592497 592497 Watson, William, of Marston, husbandman 3
3625408 1875484 1875484 defendant Sam Thomas husbandman 592497 592497 Sam, Thomas, of Marston, husbandman 4
3625409 1875484 1875484 defendant Notyngham William, senior husbandman 592497 592497 Notyngham, William, senior, of Marston, husbandman 5
3625410 1875484 1875484 defendant Hudson William husbandman 592497 592497 Hudson, William, of Marston, husbandman 6
3625411 1875484 1875484 defendant Notyngham John, junior husbandman 592497 592497 Notyngham, John, junior, of Marston, husbandman 7
3625412 1875484 1875484 defendant Gregge John laborer 592497 592497 Gregge, John, of Marston, laborer 8
3625413 1875484 1875484 defendant Graunge Thomas laborer 592497 592497 Graunge, Thomas, of Marston, laborer 9
3627072 1903329 1903329 defendant Sale William husbandman 592497 592497 Sale, William, of Marston, husbandman 0
3627073 1903329 1903329 defendant Rayneshawe Henry husbandman 592497 592497 Rayneshawe, Henry, of Marston, husbandman 1
3627074 1903329 1903329 defendant Thomkynson William husbandman 592497 592497 Thomkynson, William, of Marston, husbandman 2
3627075 1903329 1903329 defendant Mason Ralph capper 592497 592497 Mason, Ralph, of Marston, capper 3
3627076 1903329 1903329 defendant Kenwardyne John husbandman 592497 592497 Kenwardyne, John, of Marston, husbandman 4
3627079 1903330 1903330 defendant Rayneshawe Henry husbandman 592497 592497 Rayneshawe, Henry, of Marston, husbandman 1
3627080 1903330 1903330 defendant Thomkynson William husbandman 592497 592497 Thomkynson, William, of Marston, husbandman 2
3627081 1903330 1903330 defendant Mason Ralph capper 592497 592497 Mason, Ralph, of Marston, capper 3
3627082 1903330 1903330 defendant Kenwardyne John husbandman 592497 592497 Kenwardyne, John, of Marston, husbandman 4
3641241 1907713 1907713 defendant Sale William husbandman 592497 592497 Sale, William, of Marston, husbandman 0
3641242 1907713 1907713 defendant Reynshawe Henry husbandman 592497 592497 Reynshawe, Henry, of Marston, husbandman 1
3641243 1907713 1907713 defendant Tomkynson William husbandman 592497 592497 Tomkynson, William,of Marston, husbandman 2
3641244 1907713 1907713 defendant Kenwardyne John husbandman 592497 592497 Kenwardyne, John, of Marston, husbandman 3
3641245 1907713 1907713 defendant Mason Ralph capper 592497 592497 Mason, Ralph, of Marston, capper 4
3641247 1907714 1907714 defendant Sale William husbandman 592497 592497 Sale, William, of Marston, husbandman 0
3641248 1907714 1907714 defendant Reynshawe Henry husbandman 592497 592497 Reynshawe, Henry, of Marston, husbandman 1
3641249 1907714 1907714 defendant Tomkynson William husbandman 592497 592497 Tomkynson, William,of Marston, husbandman 2
3641250 1907714 1907714 defendant Kenwardyne John husbandman 592497 592497 Kenwardyne, John, of Marston, husbandman 3
3641251 1907714 1907714 defendant Mason Ralph capper 592497 592497 Mason, Ralph, of Marston, capper 4
3690690 1923254 1923254 plaintiff Corbett William   592497 592497 Corbett, William, of Marston 1
3713882 1930643 1930643 defendant Archer William husbandman 592497 592497 Archer, William, of Marston Butler, husbandman 7
3713895 1930644 1930644 defendant Archer William husbandman 592497 592497 Archer, William, of Marston Butler, husbandman 7
3716713 1931521 1931521 plaintiff Corbett William (legal representative) 592497 592497 Corbett, William, of Marston, executors of 0
3716719 1931522 1931522 plaintiff Corbett William (legal representative) 592497 592497 Corbett, William, of Marston, executors of 0
3723570 1933646 1933646 defendant Porte Andrew husbandman 592497 592497 Porte, Andrew, of Marston, husbandman 0
3746208 1940722 1940722 defendant Hogeson Richard husbandman 592497 592497 Hogeson, Richard, of Marston, husbandman 0
3746209 1940722 1940722 defendant Lyght Richard husbandman 592497 592497 Lyght, Richard, of Marston, husbandman 1
3746210 1940722 1940722 defendant Assheton Thomas husbandman 592497 592497 Assheton, Thomas, of Marston, husbandman 2
3764767 1946646 1946646 defendant Mascall alias Masco Thomas husbandman 592497 592497 Mascall alias Masco, Thomas, of Marston, husbandman 0
3784831 1953050 1953050 defendant Tyler William, senior husbandman 592497 592497 Tyler, William, senior, of Marston, husbandman 0
3784832 1953050 1953050 defendant Tyler William, junior husbandman 592497 592497 Tyler, William, junior, of Marston, husbandman 1
3794421 1956131 1956131 defendant Breten Lionel butcher 592497 592497 Breten, Lionel, of Marston, butcher 0
3802597 1958706 1958706 defendant Constable Leonard clerk 592497 592497 Constable, Leonard, of Marston, clerk 0
3802598 1958706 1958706 defendant Constable Osmund gent 592497 592497 Constable, Osmund, of Marston, gent 1
3822234 1964858 1964858 defendant Raynshawe Henry husbandman 592497 592497 Raynshawe, Henry, of Marston, husbandman 0
3830052 1967294 1967294 defendant Constable Leonard clerk 592497 592497 Constable, Leonard, of Marston, clerk 1
3860510 1977008 1977008 defendant Stede William husbandman 592497 592497 Stede, William, of Marston, husbandman 2
3870479 1980367 1980367 defendant Emyns James husbandman 592497 592497 Emyns, James, of Marston, husbandman 0
3873900 1981489 1981489 defendant Stede William   592497 592497 Stede, William, of Marston 1
3879804 1983500 1983500 defendant Arnold Thomas yeoman 592497 592497 (Arnold, Thomas, of Marston, yeoman 1
3897439 1989357 1989357 defendant Reynoldys William husbandman 592497 592497 Reynoldys, William, of Marston, husbandman 0
3909710 1993556 1993556 defendant Smyth alias Gaberell Edward   592497 592497 Smyth alias Gaberell, Edward, of Marston, collar maker 0
3913562 1994877 1994877 defendant Crassewalde Otto yeoman 592497 592497 Crassewalde, Otto, of Marston, yeoman 0
3942137 2004388 2004388 defendant Bradwall Christopher husbandman 592497 592497 Bradwall, Christopher, of Marston, husbandman 0
3950584 2007275 2007275 defendant Dansey Bartholomew gent 592497 592497 Dansey, Bartholomew, of Marston, gent 15
3969150 2013818 2013818 defendant Netton John husbandman 592497 592497 Netton, John, of Marston, husbandman 1
3969964 2014094 2014094 defendant Boulde Richard husbandman 592497 592497 Boulde, Richard, of Marston, husbandman 0
3969969 2014095 2014095 defendant Boulde Richard husbandman 592497 592497 Boulde, Richard, of Marston, husbandman 0
3984371 2019165 2019165 defendant Tayler Humphrey tailor 592497 592497 Tayler, Humphrey, of Marston, tailor 0
4019482 2031696 2031696 defendant Kyrrewood or Kerwood William yeoman 592497 592497 Kyrrewood or Kerwood, William, of Marston, yeoman 1
4033346 2036579 2036579 defendant Fletcher Walter tailor 592497 592497 Fletcher, Walter, of Marston, tailor 0
4033349 2036580 2036580 defendant Fletcher Walter tailor 592497 592497 Fletcher, Walter, of Marston, tailor 0
4037487 2038069 2038069 defendant Adams William yeoman 592497 592497 Adams, William, of Marston, yeoman 1
4050567 2042630 2042630 defendant Kyrwood William yeoman 592497 592497 Kyrwood, William, of Marston, yeoman 0
4059306 2045723 2045723 defendant Coxe William husbandman 592497 592497 Coxe, William, of Marston, husbandman 1
4065560 2047973 2047973 plaintiff Heath John   592497 592497 Heath, John, of Marston 0
4065562 2047973 2047973 defendant Yowley John gent 592497 592497 Yowley, John, of Marston, gent 1
4065563 2047973 2047973 defendant Franche Ralph husbandman 592497 592497 Franche, Ralph, of Marston, husbandman 2
4070009 2049563 2049563 defendant Caldwall Christopher carpenter 592497 592497 Caldwall, Christopher, of Marston, carpenter 0
4074491 2051179 2051179 defendant Rathebon Thomas husbandman 592497 592497 Rathebon, Thomas, of Marston, husbandman 1
4080055 2053171 2053171 defendant Shudde Richard husbandman 592497 592497 Shudde, Richard, of Marston, husbandman 0
4080056 2053171 2053171 defendant Tewxbery Roger smith 592497 592497 Tewxbery, Roger, of Marston, smith 1
4095723 2058802 2058802 defendant Skottowe John yeoman 592497 592497 Skottowe, John, of Marston, yeoman 0
4096745 2059167 2059167 defendant Bold Hugh husbandman 592497 592497 Bold, Hugh, of Marston, husbandman 0
4104807 2061995 2061995 defendant Bold Hugh husbandman 592497 592497 Bold, Hugh, of Marston, husbandman 0
4108946 2063455 2063455 defendant Rathbon Troman husbandman 592497 592497 Rathbon, Troman, of Marston, husbandman 1
4116813 2066309 2066309 defendant Wall James husbandman 592497 592497 Wall, James, of Marston, husbandman 0
4118790 2067000 2067000 defendant Kaywood Robert yeoman 592497 592497 Kaywood, Robert, of Marston, yeoman 1
4121183 2067871 2067871 defendant Arrosmythe John yeoman 592497 592497 Arrosmythe, John, of Marston, yeoman 0
4126908 2069917 2069917 defendant Parne Thomas yeoman 592497 592497 Parne, Thomas, of Marston, yeoman 0
4126909 2069917 2069917 defendant Baseley Thomas yeoman 592497 592497 Baseley, Thomas, of Marston, yeoman 1
4126910 2069917 2069917 defendant Cowper Thomas husbandman 592497 592497 Cowper, Thomas, of Marston, husbandman 2
4128793 2070592 2070592 defendant Wolhed Henry husbandman 592497 592497 Wolhed, Henry, of Marston, husbandman 1
4141300 2075116 2075116 defendant Parne Thomas husbandman 592497 592497 Parne, Thomas, of Marston, husbandman 0
4144292 2076165 2076165 defendant Arrosmythe John yeoman 592497 592497 Arrosmythe, John, of Marston, yeoman 0
4165689 2083499 2083499 defendant Bould Hugh husbandman 592497 592497 Bould, Hugh, of Marston, husbandman 1
4166453 2083766 2083766 defendant Boulde Hugh husbandman 592497 592497 Boulde, Hugh, of Marston, husbandman 0
4179839 2088424 2088424 defendant Phelippe Robert yeoman 592497 592497 Phelippe, Robert, of Marston, yeoman 0
4179843 2088425 2088425 defendant Philips Robert yeoman 592497 592497 Philips, Robert, of Marston, yeoman 0
4181902 2089151 2089151 defendant Cutler alias Bagnall Nicholas yeoman 592497 592497 Cutler alias Bagnall, Nicholas, of Marston, yeoman 0
4181903 2089151 2089151 defendant Cutler alias Bagnall William yeoman 592497 592497 Cutler alias Bagnall, William, of Marston, yeoman 1
4198361 2094976 2094976 defendant Pearne Thomas yeoman 592497 592497 Pearne, Thomas, of Marston, yeoman 0
4198362 2094976 2094976 defendant Beseley Thomas yeoman 592497 592497 Beseley, Thomas, of Marston, yeoman 1
4198363 2094976 2094976 defendant Cowper Thomas husbandman 592497 592497 Cowper, Thomas, of Marston, husbandman 2
4199030 2095217 2095217 defendant Cutler Nicholas smith 592497 592497 Cutler, Nicholas, of Marston, smith 2
4212646 2099963 2099963 defendant Hudson Christopher yeoman 592497 592497 (Hudson, Christopher, of Marston, yeoman 1
4212647 2099963 2099963 defendant Hill Edward yeoman 592497 592497 Hill, Edward, of Marston, yeoman 2
4238471 2109070 2109070 defendant Arrowsmythe John yeoman 592497 592497 Arrowsmythe, John, of Marston, yeoman 2
4245993 2111641 2111641 defendant Leake William gent 592497 592497 Leake, William, of Marston, gent 0
4247451 2112130 2112130 plaintiff Steade Walter   592497 592497 Steade, Walter, of Marston 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);