names

48 rows where place_id = 606255

✎ 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
3604490 1869070 1869070 defendant Reed Robert   606255 606255 Reed, Robert, of Whytwell miller 0
3664627 1914889 1914889 defendant Sanford Brian clerk 606255 606255 Sanford, Brian, of Whytwell, clerk 0
3719485 1932362 1932362 defendant Belamy Richard yeoman 606255 606255 Belamy, Richard, of Whytwell, yeoman 1
3797044 1956955 1956955 defendant Ryce Randolph esq 606255 606255 Ryce, Randolph, of Whytwell, esq 0
3804033 1959182 1959182 defendant Hey Alan husbandman 606255 606255 Hey, Alan, of Whytwell, husbandman 0
3807548 1960268 1960268 defendant Marshall Robert husbandman 606255 606255 Marshall, Robert, of Whytwell, husbandman 2
3822873 1965061 1965061 defendant Tailler Christopher husbandman 606255 606255 Tailler, Christopher, of Whytwell, husbandman 0
3845181 1972054 1972054 defendant Sowyate John, senior husbandman 606255 606255 Sowyate, John, senior, of Whytwell, husbandman 0
3845649 1972183 1972183 defendant Hey Alan yeoman 606255 606255 Hey, Alan, of Whytwell, yeoman 1
3853415 1974694 1974694 defendant Hardy Thomas husbandman or pewterer 606255 606255 Hardy, Thomas, of Whytwell, husbandman or pewterer 0
3877022 1982556 1982556 defendant Brone Thomas   606255 606255 Brone, Thomas, of Whytwell, worsted weaver 0
3886990 1985913 1985913 plaintiff Clarkson James yeoman 606255 606255 Clarkson, James, of Whytwell, yeoman 0
3903093 1991264 1991264 defendant Waller William husbandman 606255 606255 Waller, William, of Whytwell, husbandman 2
3905768 1992205 1992205 defendant Morehows Thomas husbandman 606255 606255 Morehows, Thomas, of Whytwell, husbandman 1
3905769 1992205 1992205 defendant Shene Thomas husbandman 606255 606255 Shene, Thomas, of Whytwell, husbandman 2
4039881 2038885 2038885 plaintiff Martyn William yeoman 606255 606255 Martyn, William, of Whytwell, yeoman 0
4039884 2038886 2038886 plaintiff Martyn William yeoman 606255 606255 Martyn, William, of Whytwell, yeoman 0
4081166 2053574 2053574 defendant Myll Robert husbandman 606255 606255 Myll, Robert, of Whytwell, husbandman 3
4088674 2056251 2056251 defendant Snoden Thomas husbandman 606255 606255 Snoden, Thomas, of Whytwell, husbandman 0
4099403 2060114 2060114 defendant Wyckes or Wylkes Edmund carpenter 606255 606255 Wyckes or Wylkes, Edmund, of Whytwell, carpenter 0
4106932 2062773 2062773 defendant Etherington Thomas gent 606255 606255 Etherington, Thomas, of Whytwell, gent 0
4146231 2076832 2076832 defendant Skyllynge Thomas husbandman 606255 606255 Skyllynge, Thomas, of Whytwell, husbandman 1
4216570 2101288 2101288 defendant Gilbert Thomas husbandman 606255 606255 Gilbert, Thomas, of Whytwell, husbandman 1
4230732 2106247 2106247 defendant Tiplady George gent 606255 606255 Tiplady, George, of Whytwell, gent 0
4262170 2117019 2117019 defendant Tipladie George gent 606255 606255 Tipladie, George, of Whytwell, gent 2
4264448 2117749 2117749 defendant Gilbert Thomas husbandman 606255 606255 Gilbert, Thomas, of Whytwell, husbandman 0
4266668 2118496 2118496 defendant Gilbert Thomas, junior husbandman 606255 606255 Gilbert, Thomas, junior, of Whytwell, husbandman 0
4266669 2118496 2118496 defendant Gylbert John husbandman 606255 606255 Gylbert, John, of Whytwell, husbandman 1
4281637 2123484 2123484 defendant Gilbert Thomas yeoman 606255 606255 Gilbert, Thomas, of Whytwell, yeoman 0
4312833 2134617 2134617 defendant Eggmer William husbandman 606255 606255 Eggmer, William, of Whytwell, husbandman 2
4385473 2159831 2159831 defendant Gylbarde Thomas yeoman 606255 606255 Gylbarde, Thomas, of Whytwell, yeoman 1
4390334 2161389 2161389 defendant Wyggett William husbandman 606255 606255 Wyggett, William, of Whytwell, husbandman 3
4752484 2281188 2281188 defendant Gybbe Helen widow 606255 606255 Gybbe, Helen, of Whytwell, widow 1
4849206 2311225 2311225 defendant Palfreyman John yeoman 606255 606255 Palfreyman, John, of Whytwell, yeoman 1
4900140 2326670 2326670 plaintiff Scelthe John   606255 606255 Scelthe, John, of Whytwell 0
4999612 2356759 2356759 defendant Foyster Thomas forester 606255 606255 Foyster, Thomas, of Whytwell, forester 0
5035504 2367244 2367244 defendant Eggemer John, senior husbandman 606255 606255 Eggemer, John, senior, of Whytwell, husbandman 3
5141576 2398647 2398647 defendant Vowe Joan widow 606255 606255 Vowe, Joan, of Whytwell, widow 0
5165109 2405540 2405540 defendant Clyffe Nicholas   606255 606255 Clyffe, Nicholas, of Whytwell 0
5192425 2413522 2413522 plaintiff Newerk John clerk 606255 606255 Newerk, John, of Whytwell, clerk 0
5278689 2438872 2438872 defendant Grene Robert yeoman 606255 606255 Grene, Robert, of Whytwell, yeoman 0
5279392 2439056 2439056 defendant Rede Stephen miller 606255 606255 Rede, Stephen, of Whytwell, miller 9
5311191 2448373 2448373 defendant Medilton Robert miller 606255 606255 Medilton, Robert, of Whytwell, miller 1
5328448 2453583 2453583 defendant Grene Robert husbandman 606255 606255 Grene, Robert, of Whytwell, husbandman 3
5364986 2464720 2464720 defendant Myller alias Rede Robert husbandman 606255 606255 Myller alias Rede, Robert, of Whytwell, husbandman 0
5503717 2506076 2506076 defendant Reed Robert miller 606255 606255 Reed, Robert, of Whytwell, miller 0
5511505 2508445 2508445 defendant Rede Robert husbandman 606255 606255 Rede, Robert, of Whytwell, husbandman 1
5529646 2513772 2513772 defendant Snowe John husbandman 606255 606255 Snowe, John, of Whytwell, husbandman 0

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