names

37 rows where place_id = 678154

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4030072 2035403 2035403 defendant Butt William gent 678154 678154 Butt, William, of Watlington, gent 0
4074947 2051340 2051340 defendant Furner Robert husbandman 678154 678154 Furner, Robert, of Watlington, husbandman 0
4129735 2070945 2070945 defendant Warner Reginald husbandman 678154 678154 Warner, Reginald, of Watlington, husbandman 1
4139686 2074555 2074555 defendant Fyssher William yeoman 678154 678154 (Fyssher, William, of Watlington, yeoman 4
4146641 2076976 2076976 defendant Fever John husbandman 678154 678154 Fever, John, of Watlington, husbandman 0
4146642 2076976 2076976 defendant Warne John husbandman 678154 678154 Warne, John, of Watlington, husbandman 1
4161487 2082093 2082093 defendant Warner John husbandman 678154 678154 Warner, John, of Watlington, husbandman 0
4161488 2082093 2082093 defendant Merell Edward husbandman 678154 678154 Merell, Edward, of Watlington, husbandman 1
4166732 2083860 2083860 defendant Wynter John yeoman 678154 678154 Wynter, John, of Watlington, yeoman 0
4189480 2091818 2091818 defendant Shouldham Robert gent 678154 678154 Shouldham, Robert, of Watlington, gent 0
4204414 2097090 2097090 defendant Shouldham Robert gent 678154 678154 Shouldham, Robert, of Watlington, gent 0
4218851 2102088 2102088 defendant Browne William husbandman 678154 678154 Browne, William, of Watlington, or of Brankester, husbandman 1
4219983 2102491 2102491 defendant Michelson Thomas blacksmith 678154 678154 Michelson, Thomas, of Watlington, yeoman, or of Wisbiche, Isle of Ely, blacksmith 0
4219984 2102491 2102491 defendant Wesenham Thomas fishmonger 678154 678154 Wesenham, Thomas, of Watlington yeoman, or of Wisbeche, fishmonger 1
4219986 2102492 2102492 defendant Peache Oliver maltster 678154 678154 Peache, Oliver, of Watlington, yeoman, or of Ely, Cams, maltster 0
4219987 2102492 2102492 defendant Aurdenall Richard   678154 678154 Aurdenall, Richard, of Watlington, yeoman, or of Wisbeach, Isle of Ely, Cams glover 1
4222650 2103413 2103413 defendant Wormell Bartholomew yeoman 678154 678154 Wormell, Bartholomew, of Watlington, yeoman 0
4222670 2103419 2103419 defendant Tey Peter clerk 678154 678154 Tey, Peter, of Watlington, clerk 2
4230993 2106337 2106337 defendant Alle Richard yeoman 678154 678154 Alle, Richard, of Watlington, yeoman 1
4230994 2106337 2106337 defendant Springold Simon yeoman 678154 678154 Springold, Simon, of Watlington, yeoman 2
4242535 2110500 2110500 defendant Thorey Anthony yeoman 678154 678154 Thorey, Anthony, of Watlington, yeoman 3
4244892 2111277 2111277 defendant Browne William husbandman 678154 678154 Browne, William, of Watlington, laborer, or of Brankester, husbandman 1
4246040 2111654 2111654 defendant Peache Oliver maltster 678154 678154 Peache, Oliver, of Watlington, yeoman, or of Ely, Cams, maltster 0
4247646 2112194 2112194 defendant Gardiner or Garner John husbandman 678154 678154 Gardiner or Garner, John, of Watlington, yeoman, or of Tydd St Giles, Isle of Elym Cams, husbandman 0
4247647 2112194 2112194 defendant Gardiner or Garner Thomas husbandman 678154 678154 Gardiner or Garner, Thomas, of Watlington, yeoman, or of Tydd St Mary, Holland, Lincs, husbandman 1
4253408 2114131 2114131 defendant Buck William waterman 678154 678154 Buck, William, of Watlington, waterman 0
4254831 2114608 2114608 defendant Angevell Anthony yeoman 678154 678154 Angevell, Anthony, of Watlington, yeoman 0
4254832 2114608 2114608 defendant Harrison William yeoman 678154 678154 Harrison, William, of Watlington, yeoman 1
4254833 2114608 2114608 defendant Dawson John yeoman 678154 678154 Dawson, John, of Watlington, yeoman 2
4254834 2114608 2114608 defendant Wyllson Robert yeoman 678154 678154 Wyllson, Robert, of Watlington, yeoman 3
4254958 2114649 2114649 defendant Bayes William yeoman 678154 678154 Bayes, William, of Watlington, or of Pentney, yeoman 0
4256893 2115277 2115277 defendant Holden Robert gent 678154 678154 Holden, Robert, of Watlington, gent 0
4258521 2115815 2115815 defendant Buck William waterman 678154 678154 Buck, William, of Watlington, waterman 0
4296873 2128981 2128981 defendant Raynes Robert yeoman 678154 678154 Raynes, Robert, of Watlington, yeoman 0
4405029 2166255 2166255 defendant Yonge Thomas joiner 678154 678154 Yonge, Thomas, of Watlington, joiner 0
4406891 2166870 2166870 defendant Mason William husbandman 678154 678154 Mason, William, of Watlington, husbandman 0
4406892 2166870 2166870 defendant West Richard husbandman 678154 678154 West, Richard, of Watlington, 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);