names

55 rows where place_id = 662905

✎ 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
3966675 2012981 2012981 defendant Payne James laborer 662905 662905 Payne, James, of Saxthorpe, laborer 1
3992213 2021980 2021980 defendant Ryall William husbandman 662905 662905 Ryall, William, of Saxthorpe, husbandman 0
3992220 2021983 2021983 defendant Page Thomas husbandman 662905 662905 Page, Thomas, of Saxthorpe, husbandman 0
4014647 2029960 2029960 defendant Dey Thomas gent 662905 662905 Dey, Thomas, of Saxthorpe, gent 1
4017736 2031050 2031050 plaintiff Tolye Richard   662905 662905 Tolye, Richard, of Saxthorpe 0
4032522 2036278 2036278 defendant Daye Thomas gent 662905 662905 Daye, Thomas, of Saxthorpe, gent 0
4035912 2037517 2037517 defendant Graye Thomas fishmonger 662905 662905 Graye, Thomas, of Saxthorpe, fishmonger 0
4048433 2041886 2041886 defendant Graye Thomas yeoman 662905 662905 Graye, Thomas, of Saxthorpe, yeoman 0
4052130 2043181 2043181 defendant Graye Thomas fishmonger 662905 662905 Graye, Thomas, of Saxthorpe, fishmonger 3
4062712 2046962 2046962 defendant Deye Thomas gent 662905 662905 Deye, Thomas, of Saxthorpe, gent 1
4082450 2054030 2054030 defendant Dey Thomas merchant 662905 662905 Dey, Thomas, of Saxthorpe, merchant 0
4095952 2058883 2058883 defendant Dey Thomas merchant 662905 662905 Dey, Thomas, of Saxthorpe, merchant 2
4095957 2058884 2058884 defendant Deye Thomas merchant 662905 662905 Deye, Thomas, of Saxthorpe, merchant 2
4098708 2059870 2059870 defendant Mayne Thomas husbandman 662905 662905 Mayne, Thomas, of Saxthorpe, husbandman 2
4098713 2059871 2059871 defendant Mayne Thomas husbandman 662905 662905 Mayne, Thomas, of Saxthorpe, husbandman 2
4100632 2060551 2060551 defendant Ryxe Geoffrey miller 662905 662905 Ryxe, Geoffrey, of Saxthorpe, miller 1
4103113 2061402 2061402 defendant Lowe Edmund gent 662905 662905 Lowe, Edmund, of Saxthorpe, gent 3
4103123 2061405 2061405 defendant Dey Thomas merchant 662905 662905 Dey, Thomas, of Saxthorpe, merchant 1
4103124 2061405 2061405 defendant Lowe Edmund gent 662905 662905 Lowe, Edmund, of Saxthorpe, gent 2
4103135 2061408 2061408 defendant Lowe Edmund gent 662905 662905 Lowe, Edmund, of Saxthorpe, gent 3
4103583 2061565 2061565 defendant Dey Thomas thatcher 662905 662905 Dey, Thomas, of Saxthorpe, thatcher 0
4103585 2061566 2061566 defendant Deye Thomas gent 662905 662905 Deye, Thomas, of Saxthorpe, gent 0
4106214 2062515 2062515 defendant Lynes Thomas cordwainer 662905 662905 Lynes, Thomas, of Saxthorpe, cordwainer 0
4114526 2065483 2065483 defendant Chapman Robert husbandman 662905 662905 Chapman, Robert, of Saxthorpe, husbandman 2
4128173 2070365 2070365 defendant Dey Thomas yeoman 662905 662905 Dey, Thomas, of Saxthorpe, yeoman 0
4130448 2071202 2071202 defendant Dey Thomas former churchwarden of Saxthorpe 662905 662905 Dey, Thomas, of Saxthorpe, yeoman, former churchwarden of Saxthorpe 0
4150469 2078294 2078294 defendant Deye Thomas gent 662905 662905 Deye, Thomas, of Saxthorpe, gent 0
4150786 2078411 2078411 defendant Dey Thomas gent 662905 662905 Dey, Thomas, of Saxthorpe, gent 0
4150787 2078411 2078411 defendant Dey John gent 662905 662905 Dey, John, of Saxthorpe, gent 1
4172156 2085721 2085721 defendant Brigg Richard laborer 662905 662905 Brigg, Richard, of Saxthorpe, laborer 2
4182934 2089511 2089511 defendant Leynes Thomas   662905 662905 Leynes, Thomas, of Saxthorpe, wool comber 1
4202394 2096378 2096378 defendant Chambers Philip miller 662905 662905 Chambers, Philip, of Saxthorpe, miller 0
4202498 2096412 2096412 defendant Coppuldyke Humphrey gent 662905 662905 Coppuldyke, Humphrey, of Saxthorpe, gent 2
4218736 2102055 2102055 defendant Hall William butcher 662905 662905 Hall, William, of Saxthorpe, butcher 3
4229573 2105829 2105829 defendant Grene George husbandman 662905 662905 Grene, George, of Saxthorpe, husbandman 2
4244810 2111251 2111251 defendant Hall William butcher 662905 662905 Hall, William, of Saxthorpe, butcher 3
4259352 2116104 2116104 defendant Beck Edward weaver 662905 662905 Beck, Edward, of Saxthorpe, weaver 2
4281046 2123270 2123270 defendant Ollyett William clerk 662905 662905 Ollyett, William, of Saxthorpe, clerk 2
4282336 2123721 2123721 defendant Writington Richard yeoman 662905 662905 Writington, Richard, of Saxthorpe, yeoman 1
4285327 2124802 2124802 defendant Johnsons William husbandman 662905 662905 Johnsons, William, of Saxthorpe, husbandman 0
4285328 2124802 2124802 defendant Wigge Thomas tailor 662905 662905 Wigge, Thomas, of Saxthorpe, tailor 1
4318128 2136450 2136450 defendant Rame or Raine Henry yeoman 662905 662905 Rame or Raine, Henry, of Saxthorpe, yeoman 1
4321153 2137492 2137492 defendant Writington Richard yeoman 662905 662905 Writington, Richard, of Saxthorpe, yeoman 1
4326511 2139229 2139229 defendant Dunken Robert tanner 662905 662905 Dunken, Robert, of Saxthorpe, tanner 0
4326512 2139229 2139229 defendant Ryall William yeoman 662905 662905 Ryall, William, of Saxthorpe, yeoman 1
4326513 2139229 2139229 defendant Grene Henry yeoman 662905 662905 Grene, Henry, of Saxthorpe, yeoman 2
4327857 2139640 2139640 defendant Wright Richard yeoman 662905 662905 Wright, Richard, of Saxthorpe, yeoman 0
4330303 2140439 2140439 defendant Wright Richard   662905 662905 Wright, Richard, of Saxthorpe, husbandman, "keamer" 0
4330304 2140439 2140439 defendant Wright Richard husbandman 662905 662905 Wright, Richard, of Saxthorpe, husbandman 1
4330305 2140439 2140439 defendant Wright Sarah widow 662905 662905 Sarah his wife, formerly Sarah Marshall, of Saxthorpe, widow 2
4336134 2142369 2142369 defendant Rixe Geoffrey miller 662905 662905 Rixe, Geoffrey, of Saxthorpe, miller 0
4349830 2147198 2147198 defendant Devis Christopher husbandman 662905 662905 Devis, Christopher, of Saxthorpe, husbandman 0
4391043 2161622 2161622 defendant Dunken Robert husbandman 662905 662905 Dunken, Robert, of Saxthorpe, husbandman 1
4392494 2162111 2162111 defendant Crane William (legal representative) 662905 662905 Crane, William, of Saxthorpe, wool chapman, administrator of 0
5106638 2388370 2388370 defendant Roberdys Nicholas husbandman 662905 662905 Roberdys, Nicholas, of Saxthorpe, 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);