names

50 rows where place_id = 592794

✎ 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
3608954 1870457 1870457 defendant Drakys John yeoman 592794 592794 Drakys, John, of Wysbyche, Cams, yeoman 0
3674115 1917944 1917944 defendant Senes Edmund goldsmith 592794 592794 Senes, Edmund, of Wysbyche, Cams, goldsmith 0
3677798 1919106 1919106 defendant Whelpdale William butcher 592794 592794 Whelpdale, William, of Wysbyche, Cams, butcher 1
3705313 1927951 1927951 defendant Sutton Robert gent 592794 592794 Sutton, Robert, of Wysbyche, Cams, gent 0
3709742 1929360 1929360 defendant Stote Henry tailor 592794 592794 Stote, Henry, of Wysbyche, Cams, tailor 0
3745068 1940364 1940364 defendant Beynys John tailor 592794 592794 Beynys, John, of Wysbyche, Cams, tailor 3
3747788 1941228 1941228 defendant Cokke Robert yeoman 592794 592794 (Cokke, Robert, of Wysbyche, Cams, yeoman 1
3750361 1942032 1942032 defendant Sutton Robert gent 592794 592794 Sutton, Robert, of Wysbyche, Cams, gent 0
3752248 1942626 1942626 defendant Sutton Robert gent 592794 592794 Sutton, Robert, of Wysbyche, Cams, gent 0
3763025 1946067 1946067 defendant Conysbury Robert butcher 592794 592794 Conysbury, Robert, of Wysbyche, Cams, butcher 0
3824730 1965609 1965609 defendant Rede Richard yeoman 592794 592794 Rede, Richard, of Wysbyche, Cams, yeoman 0
3827192 1966368 1966368 defendant Wellys Thomas gent 592794 592794 Wellys, Thomas, of Wysbyche, Cams, gent 0
3865928 1978835 1978835 defendant Clarke Richard gent 592794 592794 Clarke, Richard, of Wysbyche, Cams, gent 0
3868772 1979795 1979795 defendant Cokson Matilda widow 592794 592794 Cokson, Matilda, of Wysbyche, Cams, widow 1
3877083 1982577 1982577 defendant Drabbe Thomas shoemaker 592794 592794 Drabbe, Thomas, of Wysbyche, Cams, shoemaker 1
3879968 1983559 1983559 defendant Clerke Richard gent 592794 592794 Clerke, Richard, of Wysbyche, Cams, gent 0
3890526 1987090 1987090 defendant Bromffyld William mercer 592794 592794 Bromffyld, William, of Wysbyche, Cams, mercer 0
3903767 1991494 1991494 defendant Man Thomas husbandman 592794 592794 Man, Thomas, of Wysbyche, Cams, husbandman 0
3903839 1991519 1991519 defendant Drake Thomas cordwainer 592794 592794 Drake, Thomas, of Wysbyche, Cams, cordwainer 1
3908366 1993096 1993096 plaintiff Rede Richard (legal representative) 592794 592794 Rede, Richard, of Wysbyche, Cams, gent, executors of 0
3908435 1993117 1993117 plaintiff Reede Richard (legal representative) 592794 592794 Reede, Richard, of Wysbyche, Cams, gent, executors of 0
3912811 1994617 1994617 defendant Byrde John yeoman 592794 592794 Byrde, John, of Wysbyche, Cams, yeoman 0
3920048 1997042 1997042 defendant Peerson Nicholas draper 592794 592794 Peerson, Nicholas, of Wysbyche, Cams, draper 0
3920060 1997046 1997046 defendant Whyte William husbandman 592794 592794 Whyte, William, of Wysbyche, Cams, husbandman 0
3923067 1998017 1998017 defendant Byrde John yeoman 592794 592794 Byrde, John, of Wysbyche, Cams, yeoman 3
3923988 1998334 1998334 plaintiff Sutton John gent 592794 592794 Sutton, John, of Wysbyche, Cams, gent 0
3972203 2014837 2014837 defendant Dorman Roger carpenter 592794 592794 Dorman, Roger, of Wysbyche, Cams, carpenter 3
3977576 2016728 2016728 plaintiff Lorde Richard innholder 592794 592794 Lorde, Richard, of Wysbyche, Cams, innholder 0
3998990 2024397 2024397 defendant Thornton Thomas smith 592794 592794 Thornton, Thomas, of Wysbyche, Cams, smith 0
4006328 2027042 2027042 defendant Broune Richard laborer 592794 592794 Broune, Richard, of Wysbyche, Cams, laborer 0
4009875 2028308 2028308 defendant Markam Henry butcher 592794 592794 Markam, Henry, of Wysbyche, Cams, butcher 0
4018052 2031174 2031174 defendant Ansleye or Ausleye Henry chapman 592794 592794 Ansleye or Ausleye, Henry, of Wysbyche, Cams, chapman 0
4018087 2031186 2031186 defendant Scott Stephen yeoman 592794 592794 Scott, Stephen, of Wysbyche, Cams, yeoman 3
4062677 2046948 2046948 defendant Howdell Valentine yeoman 592794 592794 Howdell, Valentine, of Wysbyche, Cams, yeoman 6
4111186 2064252 2064252 defendant Darbye Arthur chapman 592794 592794 Darbye, Arthur, of Wysbyche, Cams, chapman 1
4177336 2087544 2087544 defendant Woodwarde Robert baker 592794 592794 Woodwarde, Robert, of Wysbyche, Cams, baker 3
4186897 2090903 2090903 defendant Pelham William yeoman 592794 592794 Pelham, William, of Wysbyche, Cams, or of Tarrington St John, Norf, yeoman 1
4189028 2091648 2091648 defendant Pulvertofte William gent 592794 592794 Pulvertofte, William, of Wysbyche, Cams, gent 0
4264031 2117625 2117625 defendant Saylebanck James oiler 592794 592794 Saylebanck, James, of Wysbyche, Cams, oiler 1
4304824 2131821 2131821 defendant Castelton William yeoman 592794 592794 Castelton, William, of Wysbyche, Cams, yeoman 0
4394573 2162774 2162774 defendant Love Thomas yeoman 592794 592794 Love, Thomas, of Wysbyche, Cams, yeoman 0
5029196 2365416 2365416 defendant Caus William gent 592794 592794 Caus, William, of Wysbyche, Cams, gent 3
5058829 2374205 2374205 defendant Sutton John husbandman 592794 592794 Sutton, John, of Wysbyche, Cams, husbandman 0
5325623 2452740 2452740 defendant Ganne or Gaime John raffman 592794 592794 Ganne or Gaime, John, of Wysbyche, Cams, raffman 0
5501360 2505359 2505359 defendant Odam alias Woodam John yeoman 592794 592794 Odam alias Woodam, John, of Wysbyche, Cams, yeoman 1
5501364 2505360 2505360 defendant Odam alias Woodham John yeoman 592794 592794 Odam alias Woodham, John, of Wysbyche, Cams, yeoman 1
5565323 2524446 2524446 defendant Bukworth Edmund yeoman 592794 592794 (Bukworth, Edmund, of Wysbyche, Cams, yeoman 2
5591617 2532358 2532358 defendant Style Nicholas mercer 592794 592794 Style, Nicholas, of Wysbyche, Cams, mercer 0
5596556 2533840 2533840 defendant Smyth Nicholas merchant 592794 592794 Smyth, Nicholas, of Wysbyche, Cams, merchant 0
5596773 2533910 2533910 defendant Orell David (legal representative) 592794 592794 Orell, David, of Wysbyche, Cams, gent, executrix of 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);