names

343 rows where place_id = 588580

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594978 1866059 1866059 defendant Leverych William yeoman 588580 588580 Leverych, William, of West Walton, yeoman 0
3605591 1869414 1869414 defendant Symond Thomas yeoman 588580 588580 Symond, Thomas, of West Walton, yeoman 1
3605592 1869414 1869414 defendant Norbery George yeoman 588580 588580 Norbery, George, of West Walton, yeoman 2
3618611 1873446 1873446 defendant Powdyche William husbandman 588580 588580 Powdyche, William, of West Walton, husbandman 0
3618612 1873446 1873446 defendant Barewell Robert husbandman 588580 588580 Barewell, Robert, of West Walton, husbandman 1
3618615 1873446 1873446 defendant Lynkhoke William husbandman 588580 588580 Lynkhoke, William, of West Walton, husbandman 4
3618887 1873518 1873518 defendant Powedyche William husbandman 588580 588580 Powedyche, William, of West Walton, husbandman 0
3618888 1873518 1873518 defendant Barwell Robert husbandman 588580 588580 Barwell, Robert, of West Walton, husbandman 1
3618891 1873518 1873518 defendant Lynkhoke William husbandman 588580 588580 Lynkhoke, William, of West Walton, husbandman 4
3631776 1904745 1904745 defendant Tovy Adam husbandman 588580 588580 Tovy, Adam, of West Walton, husbandman 0
3631777 1904745 1904745 defendant Alcok William husbandman 588580 588580 Alcok, William, of West Walton, husbandman 1
3631778 1904745 1904745 defendant Doddys Thomas husbandman 588580 588580 Doddys, Thomas, of West Walton, husbandman 2
3631779 1904745 1904745 defendant Hoky Thomas husbandman 588580 588580 Hoky, Thomas, of West Walton, husbandman 3
3631780 1904745 1904745 defendant Tony or Tovy Robert husbandman 588580 588580 Tony or Tovy, Robert, of West Walton, husbandman 4
3659748 1913302 1913302 defendant Burdall Thomas clerk 588580 588580 Burdall, Thomas, of West Walton, clerk 0
3676952 1918828 1918828 defendant Broun Simon husbandman 588580 588580 Broun, Simon, of West Walton, husbandman 0
3680099 1919843 1919843 defendant Costen Geoffrey husbandman 588580 588580 Costen, Geoffrey, of West Walton, husbandman 0
3680100 1919843 1919843 defendant Carter Robert husbandman 588580 588580 Carter, Robert, of West Walton, husbandman 1
3686181 1921840 1921840 defendant Leveriche Thomas husbandman 588580 588580 Leveriche, Thomas, of West Walton, husbandman 5
3705198 1927911 1927911 defendant Carter Robert husbandman 588580 588580 Carter, Robert, of West Walton, husbandman 2
3707228 1928552 1928552 defendant Clerk Robert   588580 588580 Clerk, Robert, of West Walton, laborer, Joan his wife 4
3727421 1934849 1934849 defendant Brownn Simon husbandman 588580 588580 Brownn, Simon, of West Walton, husbandman 0
3727423 1934849 1934849 defendant Brown Robert tailor 588580 588580 Brown, Robert, of West Walton, tailor 2
3758908 1944777 1944777 defendant Scote John husbandman 588580 588580 Scote, John, of West Walton, husbandman 0
3758909 1944777 1944777 defendant Carter Gregory husbandman 588580 588580 Carter, Gregory, of West Walton, husbandman 1
3772653 1949138 1949138 defendant Smyth Robert husbandman 588580 588580 Smyth, Robert, of West Walton, husbandman 0
3787215 1953794 1953794 defendant Carter Robert husbandman 588580 588580 Carter, Robert, of West Walton, husbandman 1
3808859 1960651 1960651 defendant Carter Robert husbandman 588580 588580 Carter, Robert, of West Walton, husbandman 0
3808860 1960651 1960651 defendant Shepard John husbandman 588580 588580 Shepard, John, of West Walton, husbandman 1
3823065 1965123 1965123 defendant Carter George husbandman 588580 588580 Carter, George, of West Walton, husbandman 0
3841948 1971047 1971047 defendant Lyne Robert carpenter 588580 588580 Lyne, Robert, of West Walton, carpenter 1
3852030 1974225 1974225 defendant Sewall John, senior husbandman 588580 588580 (Sewall, John, senior, of West Walton, husbandman 1
3855167 1975250 1975250 defendant Peerson Henry husbandman 588580 588580 Peerson, Henry, of West Walton, husbandman 0
3855168 1975250 1975250 defendant Hervy Robert husbandman 588580 588580 Hervy, Robert, of West Walton, husbandman 1
3855169 1975250 1975250 defendant Smartwaytte George husbandman 588580 588580 Smartwaytte, George, of West Walton, husbandman 2
3864763 1978410 1978410 defendant Hervy Robert husbandman 588580 588580 Hervy, Robert, of West Walton, husbandman 0
3864764 1978410 1978410 defendant Lowes Stephen clerk 588580 588580 Lowes, Stephen, of West Walton, clerk 1
3882700 1984479 1984479 defendant Shepherd Thomas, senior husbandman 588580 588580 Shepherd, Thomas, senior, of West Walton, husbandman 0
3882701 1984479 1984479 defendant Stote William, senior husbandman 588580 588580 Stote, William, senior, of West Walton, husbandman 1
3882702 1984479 1984479 defendant Smyth Richard husbandman 588580 588580 Smyth, Richard, of West Walton, husbandman 2
3882703 1984479 1984479 defendant Delff Thomas   588580 588580 Delff, Thomas, of West Walton, parish clerk 3
3912498 1994511 1994511 defendant Adamson George yeoman 588580 588580 Adamson, George, of West Walton, yeoman 0
3929068 2000060 2000060 defendant Baldyn Richard yeoman 588580 588580 Baldyn, Richard, of West Walton, yeoman 0
3930318 2000486 2000486 defendant Whelpdale William yeoman 588580 588580 Whelpdale, William, of West Walton, yeoman 1
3930323 2000488 2000488 defendant Whelpdale William yeoman 588580 588580 Whelpdale, William, of West Walton, yeoman 0
3930473 2000537 2000537 defendant Dryngley Roger clker 588580 588580 Dryngley, Roger, of West Walton, clker 0
3938804 2003318 2003318 plaintiff Repps Henry gent 588580 588580 Repps, Henry, of West Walton, gent 0
3981635 2018189 2018189 defendant Smyth Robert yeoman 588580 588580 Smyth, Robert, of West Walton, yeoman 0
3981636 2018190 2018190 plaintiff Reppes Henry (legal representative) 588580 588580 Reppes, Henry, of West Walton, esq, executrix of 0
3981638 2018190 2018190 defendant Smyth Robert yeoman 588580 588580 Smyth, Robert, of West Walton, yeoman 0
3981640 2018190 2018190 defendant Smyth Robert husbandman 588580 588580 Smyth, Robert, of West Walton, husbandman 2
3983324 2018808 2018808 plaintiff Smythe Robert, junior yeoman 588580 588580 Smythe, Robert, junior, of West Walton, yeoman 0
3996063 2023345 2023345 defendant Reppes Henry (legal representative) 588580 588580 Reppes, Henry, of West Walton, esq, executrix of 0
3996064 2023345 2023345 defendant Reppes Elizabeth widow 588580 588580 Reppes, Elizabeth, of West Walton, widow 1
3996813 2023627 2023627 defendant Wyles Henry tailor 588580 588580 Wyles, Henry, of West Walton, tailor 0
4001579 2025343 2025343 defendant Reppes Henry (legal representative) 588580 588580 Reppes, Henry, of West Walton, esq, executrix of 1
4001580 2025343 2025343 defendant Reppes Elizabeth widow 588580 588580 Reppes, Elizabeth, of West Walton, widow 2
4019357 2031656 2031656 defendant Drewe Geoffrey gent 588580 588580 Drewe, Geoffrey, of West Walton, gent 0
4037908 2038207 2038207 defendant Webb John yeoman 588580 588580 Webb, John, of West Walton, yeoman 0
4046618 2041242 2041242 defendant Carter Thomas yeoman 588580 588580 Carter, Thomas, of West Walton, yeoman 0
4046619 2041242 2041242 defendant Ashborne John husbandman 588580 588580 Ashborne, John, of West Walton, husbandman 1
4046630 2041248 2041248 plaintiff Smyth Robert   588580 588580 Smyth, Robert, of West Walton 0
4046631 2041248 2041248 plaintiff Carter Thomas   588580 588580 Carter, Thomas, of West Walton 1
4046632 2041248 2041248 defendant Smarthwayte John yeoman 588580 588580 Smarthwayte, John, of West Walton, yeoman 0
4046633 2041248 2041248 defendant Carter John, junior yeoman 588580 588580 Carter, John, junior, of West Walton, yeoman 1
4048507 2041918 2041918 defendant Adamson George husbandman 588580 588580 Adamson, George, of West Walton, husbandman 2
4048508 2041918 2041918 defendant Carter John laborer 588580 588580 Carter, John, of West Walton, laborer 3
4056643 2044765 2044765 defendant Alcock Gregory yeoman 588580 588580 Alcock, Gregory, of West Walton, yeoman 0
4058331 2045364 2045364 plaintiff Chamberleyn Robert gent 588580 588580 Chamberleyn, Robert, of West Walton, gent 0
4058332 2045364 2045364 defendant Harvye Thomas yeoman 588580 588580 Harvye, Thomas, of West Walton, yeoman 0
4058334 2045364 2045364 defendant Kedbye John yeoman 588580 588580 Kedbye, John, of West Walton, yeoman 2
4061703 2046584 2046584 defendant Alcocke Gregory husbandman 588580 588580 Alcocke, Gregory, of West Walton, husbandman 1
4061704 2046584 2046584 defendant Foxe Thomas husbandman 588580 588580 Foxe, Thomas, of West Walton, husbandman 2
4062676 2046948 2046948 defendant Cawson Christopher yeoman 588580 588580 Cawson, Christopher, of West Walton, yeoman 5
4063670 2047298 2047298 defendant Smyth John husbandman 588580 588580 Smyth, John, of West Walton, husbandman 0
4065295 2047871 2047871 plaintiff Harvye Thomas yeoman 588580 588580 Harvye, Thomas, of West Walton, yeoman 0
4066732 2048398 2048398 defendant Scote or Stote William yeoman 588580 588580 Scote or Stote, William, of West Walton, yeoman 0
4066736 2048399 2048399 defendant Harvy Thomas yeoman 588580 588580 Harvy, Thomas, of West Walton, yeoman 0
4066963 2048481 2048481 defendant Lefe or Lese Robert husbandman 588580 588580 Lefe or Lese, Robert, of West Walton, husbandman 1
4068537 2049036 2049036 defendant Stote William yeoman 588580 588580 Stote, William, of West Walton, yeoman 0
4068538 2049036 2049036 defendant Smarthwayte John yeoman 588580 588580 Smarthwayte, John, of West Walton, yeoman 1
4068541 2049037 2049037 defendant Stote William yeoman 588580 588580 Stote, William, of West Walton, yeoman 0
4068542 2049037 2049037 defendant Smarthwayte John yeoman 588580 588580 Smarthwayte, John, of West Walton, yeoman 1
4082593 2054081 2054081 defendant Kedby Thomas husbandman 588580 588580 Kedby, Thomas, of West Walton, husbandman 0
4106533 2062626 2062626 defendant Stote or Stoote William yeoman 588580 588580 Stote or Stoote, William, of West Walton, yeoman 0
4110503 2064017 2064017 defendant Stoote William husbandman 588580 588580 Stoote, William, of West Walton, husbandman 0
4110505 2064018 2064018 defendant Stote or Stoote William husbandman 588580 588580 Stote or Stoote, William, of West Walton, husbandman 0
4118500 2066908 2066908 defendant Stoote William yeoman 588580 588580 Stoote, William, of West Walton, yeoman 1
4145021 2076418 2076418 defendant Dodd Thomas yeoman 588580 588580 Dodd, Thomas, of West Walton, yeoman 2
4145022 2076418 2076418 defendant Brymble William husbandman 588580 588580 Brymble, William, of West Walton, husbandman 3
4145047 2076429 2076429 defendant Carter George yeoman 588580 588580 Carter, George, of West Walton, yeoman 0
4145048 2076429 2076429 defendant Kedbye Thomas yeoman 588580 588580 Kedbye, Thomas, of West Walton, yeoman 1
4145051 2076430 2076430 defendant Garter Gregory yeoman 588580 588580 Garter, Gregory, of West Walton, yeoman 0
4145052 2076430 2076430 defendant Kedby Thomas yeoman 588580 588580 Kedby, Thomas, of West Walton, yeoman 1
4146152 2076803 2076803 defendant Smarthwayte John yeoman 588580 588580 Smarthwayte, John, of West Walton, yeoman 0
4147521 2077275 2077275 defendant Stote or Scote William yeoman 588580 588580 Stote or Scote, William, of West Walton, yeoman 0
4160126 2081606 2081606 defendant Gilbert William husbandman 588580 588580 Gilbert, William, of West Walton, husbandman 2
4164830 2083211 2083211 defendant Cawson or Cawston Christopher husbandman 588580 588580 Cawson or Cawston, Christopher, of West Walton, husbandman 1
4164839 2083213 2083213 defendant Cawson Christopher husbandman 588580 588580 Cawson, Christopher, of West Walton, husbandman 1
4184446 2090067 2090067 defendant Stoote William yeoman 588580 588580 Stoote, William, of West Walton, yeoman 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);