names

35 rows where place_id = 698364

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4121349 2067931 2067931 defendant Deathe Geoffrey   698364 698364 Deathe, Geoffrey, of Pinchbecke, yeoman, tallow chandler 2
4123796 2068809 2068809 defendant Reade William husbandman 698364 698364 Reade, William, of Pinchbecke, husbandman 0
4123797 2068809 2068809 defendant Williamson Richard laborer 698364 698364 Williamson, Richard, of Pinchbecke, laborer 1
4123801 2068810 2068810 defendant Reade William husbandman 698364 698364 Reade, William, of Pinchbecke, husbandman 0
4123802 2068810 2068810 defendant Williamson Richard laborer 698364 698364 Williamson, Richard, of Pinchbecke, laborer 1
4171978 2085661 2085661 defendant Hudleston Richard gent 698364 698364 Hudleston, Richard, of Pinchbecke, gent 0
4234115 2107459 2107459 defendant Inman Roland yeoman 698364 698364 (Inman, Roland, of Pinchbecke, yeoman 1
4235429 2107960 2107960 defendant Sicleprise Nicholas victualer 698364 698364 Sicleprise, Nicholas, of Pinchbecke, victualer 1
4243265 2110739 2110739 defendant Makris John yeoman 698364 698364 Makris, John, of Pinchbecke, yeoman 2
4243270 2110740 2110740 defendant Makris John yeoman 698364 698364 Makris, John, of Pinchbecke, yeoman 2
4244069 2110998 2110998 defendant Sliceprice Nicholas victualer 698364 698364 Sliceprice, Nicholas, of Pinchbecke, victualer 0
4250020 2112986 2112986 defendant Freman Henry yeoman 698364 698364 Freman, Henry, of Pinchbecke, yeoman 0
4255987 2114979 2114979 defendant Woodes Thomas laborer 698364 698364 Woodes, Thomas, of Pinchbecke, laborer 0
4257233 2115398 2115398 defendant Hinman Anthony yeoman 698364 698364 Hinman, Anthony, of Pinchbecke, yeoman 0
4274572 2121049 2121049 defendant Bukele William baker 698364 698364 Bukele, William, of Pinchbecke, baker 2
4282311 2123713 2123713 defendant Tomson Joel yeoman 698364 698364 Tomson, Joel, of Pinchbecke, yeoman 0
4304732 2131788 2131788 defendant Hodges John yeoman 698364 698364 Hodges, John, of Pinchbecke, yeoman 0
4326222 2139136 2139136 defendant Wroe William husbandman 698364 698364 Wroe, William, of Pinchbecke, husbandman 0
4336247 2142411 2142411 defendant Cust Henry yeoman 698364 698364 Cust, Henry, of Pinchbecke, yeoman 0
4337936 2143014 2143014 defendant Hinman Anthony yeoman 698364 698364 Hinman, Anthony, of Pinchbecke, yeoman 0
4343626 2145048 2145048 defendant Burde Richard husbandman 698364 698364 Burde, Richard, of Pinchbecke, husbandman 0
4343627 2145048 2145048 defendant Worshipp John husbandman 698364 698364 Worshipp, John, of Pinchbecke, husbandman 1
4344083 2145209 2145209 defendant Jenkinson Henry husbandman 698364 698364 Jenkinson, Henry, of Pinchbecke, husbandman 0
4348224 2146629 2146629 defendant Tomsone Joel yeoman 698364 698364 Tomsone, Joel, of Pinchbecke, yeoman 0
4348225 2146629 2146629 defendant Cust Henry yeoman 698364 698364 Cust, Henry, of Pinchbecke, yeoman 1
4348226 2146629 2146629 defendant Makernes John yeoman 698364 698364 Makernes, John, of Pinchbecke, yeoman 2
4349788 2147185 2147185 defendant mercer Richard laborer 698364 698364 mercer, Richard, of Pinchbecke, laborer 1
4357247 2149763 2149763 defendant Rampshawe or Ramshawe Nicholas butcher 698364 698364 Rampshawe or Ramshawe, Nicholas, of Pinchbecke, husbandman, butcher 0
4357248 2149763 2149763 defendant Ramshawe John (legal representative) 698364 698364 Ramshawe, John, of Pinchbecke, husbandman, executor of 1
4357249 2149763 2149763 defendant Ramshawe Robert husbandman 698364 698364 Ramshawe, Robert, of Pinchbecke, husbandman 2
4368566 2153805 2153805 defendant Burde Richard yeoman 698364 698364 Burde, Richard, of Pinchbecke, yeoman 2
4368675 2153847 2153847 defendant Ruffe Thomas butcher 698364 698364 Ruffe, Thomas, of Pinchbecke, butcher 0
4372380 2155189 2155189 defendant Cooke Roger laborer 698364 698364 Cooke, Roger, of Pinchbecke, laborer 0
4374661 2156000 2156000 defendant Storer Thomas   698364 698364 Storer, Thomas, of Pinchbecke, carpenter, administrators during minority of Jane Storer 2
4379405 2157714 2157714 defendant Browne Peter husbandman 698364 698364 Browne, Peter, of Pinchbecke, 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);