names

71 rows where place_id = 588201

✎ 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
3593725 1865677 1865677 defendant Heyward Richard gent 588201 588201 Heyward, Richard, of Owtwell, gent 0
3593727 1865677 1865677 defendant Fawn William yeoman 588201 588201 Fawn, William, of Owtwell, yeoman 2
3625728 1875585 1875585 defendant Heywode Richard yeoman 588201 588201 Heywode, Richard, of Owtwell, yeoman 1
3639398 1907132 1907132 plaintiff Wellys Thomas gent 588201 588201 Wellys, Thomas, of Owtwell, gent 0
3640836 1907579 1907579 plaintiff Fyncham John   588201 588201 Fyncham, John, of Owtwell 2
3698034 1925612 1925612 defendant Fyssher John husbandman 588201 588201 Fyssher, John, of Owtwell, husbandman 0
3702455 1927029 1927029 defendant Lambart Genry yeoman 588201 588201 Lambart, Genry, of Owtwell, yeoman 0
3704545 1927717 1927717 plaintiff Fyncham John gent 588201 588201 Fyncham, John, of Owtwell, gent 0
3736466 1937652 1937652 defendant Delfe or Delse John husbandman 588201 588201 Delfe or Delse, John, of Owtwell, husbandman 0
3736467 1937652 1937652 defendant Delfe or Delse Thomas husbandman 588201 588201 Delfe or Delse, Thomas, of Owtwell, husbandman 1
3736699 1937730 1937730 defendant Smyth James butcher 588201 588201 Smyth, James, of Owtwell, butcher 0
3794695 1956217 1956217 defendant Lambard Henry yeoman 588201 588201 Lambard, Henry, of Owtwell, yeoman 0
3837622 1969675 1969675 defendant Upton Richard   588201 588201 Upton, Richard, of Owtwell, mason 0
3840511 1970593 1970593 defendant Cosyn Thomas husbandman 588201 588201 Cosyn, Thomas, of Owtwell, husbandman 0
3841233 1970838 1970838 defendant Hasby Thomas husbandman 588201 588201 Hasby, Thomas, of Owtwell, husbandman 0
3843866 1971622 1971622 plaintiff Conye Robert (legal representative) 588201 588201 Conye, Robert, of Owtwell, executors of 0
3844310 1971771 1971771 defendant Everard John laborer 588201 588201 Everard, John, of Owtwell, laborer 1
3845028 1971998 1971998 defendant Everrode John husbandman 588201 588201 Everrode, John, of Owtwell, husbandman 0
3845048 1972006 1972006 defendant Everrode John husbandman 588201 588201 Everrode, John, of Owtwell, husbandman 0
3846309 1972401 1972401 defendant Mayse William husbandman 588201 588201 Mayse, William, of Owtwell, husbandman 0
3846310 1972401 1972401 defendant Hasby Thomas husbandman 588201 588201 Hasby, Thomas, of Owtwell, husbandman 1
3846311 1972401 1972401 defendant Walton John husbandman 588201 588201 Walton, John, of Owtwell, husbandman 2
3857209 1975888 1975888 defendant Cosyn Thomas baker 588201 588201 Cosyn, Thomas, of Owtwell, baker 0
3858781 1976422 1976422 defendant Alpe Thomas turner 588201 588201 Alpe, Thomas, of Owtwell, turner 1
3863696 1978045 1978045 defendant Everard John husbandman 588201 588201 Everard, John, of Owtwell, husbandman 0
3871743 1980786 1980786 defendant Delffe John yeoman 588201 588201 Delffe, John, of Owtwell, yeoman 0
3878277 1982982 1982982 defendant Midelton Cecilia widow 588201 588201 Midelton, Cecilia, of Owtwell, widow 5
3895423 1988679 1988679 defendant Aston alias Chamber John husbandman 588201 588201 Aston alias Chamber, John, of Owtwell, husbandman 2
3895428 1988680 1988680 defendant Aston alias Chamber John husbandman 588201 588201 Aston alias Chamber, John, of Owtwell, husbandman 2
3901581 1990754 1990754 defendant Cosyn Thomas laborer 588201 588201 Cosyn, Thomas, of Owtwell, laborer 2
3905579 1992135 1992135 plaintiff Lancrooke John   588201 588201 Lancrooke, John, of Owtwell 0
3929841 2000320 2000320 defendant Chartresse John tailor 588201 588201 Chartresse, John, of Owtwell, tailor 0
3978943 2017221 2017221 defendant Rayner Hugh waterman 588201 588201 Rayner, Hugh, of Owtwell, waterman 1
3989775 2021088 2021088 plaintiff Bateman John   588201 588201 Bateman, John, of Owtwell, bachelor 0
3999433 2024559 2024559 plaintiff Fyncham Simon gent 588201 588201 Fyncham, Simon, of Owtwell, gent 0
4010646 2028578 2028578 defendant Tyvy Andrew laborer 588201 588201 Tyvy, Andrew, of Owtwell, laborer 1
4033931 2036790 2036790 plaintiff Gyrlyng Thomas gent 588201 588201 Gyrlyng, Thomas, of Owtwell, gent 0
4045945 2040997 2040997 defendant Fyncham Simon gent 588201 588201 Fyncham, Simon, of Owtwell, gent 3
4046122 2041051 2041051 defendant Fyncham Richard gent 588201 588201 Fyncham, Richard, of Owtwell, gent 0
4046123 2041051 2041051 defendant Fyncham Robert gent 588201 588201 Fyncham, Robert, of Owtwell, gent 1
4062678 2046948 2046948 defendant Fyncham Robert gent 588201 588201 Fyncham, Robert, of Owtwell, gent 7
4066958 2048480 2048480 defendant Skotte Richard yeoman 588201 588201 Skotte, Richard, of Owtwell, yeoman 1
4076415 2051860 2051860 defendant Cambridge William yeoman 588201 588201 Cambridge, William, of Owtwell, yeoman 0
4094488 2058368 2058368 defendant Sparrowe Richard yeoman 588201 588201 Sparrowe, Richard, of Owtwell, or of Wisbiche, Isle of Ely, Cams, yeoman 0
4100051 2060348 2060348 defendant Kirke alias Church John yeoman 588201 588201 Kirke alias Church, John, of Owtwell, or of Hargrave, Suff, yeoman 0
4106536 2062626 2062626 defendant Manne George husbandman 588201 588201 Manne, George, of Owtwell, husbandman 3
4150957 2078463 2078463 defendant Nicholas William yeoman 588201 588201 Nicholas, William, of Owtwell, yeoman 3
4168824 2084587 2084587 defendant Cooke William chandler 588201 588201 Cooke, William, of Owtwell, chandler 0
4173769 2086282 2086282 defendant Cornyshe alias Corlas William husbandman 588201 588201 Cornyshe alias Corlas, William, of Owtwell, husbandman 0
4195781 2094076 2094076 defendant Coward John yeoman 588201 588201 Coward, John, of Owtwell, yeoman 2
4201104 2095937 2095937 defendant Nicholas William yeoman 588201 588201 Nicholas, William, of Owtwell, yeoman 1
4243758 2110894 2110894 defendant Jackson Thomas waterman 588201 588201 Jackson, Thomas, of Owtwell, waterman 1
4262263 2117049 2117049 defendant Cambridge Thomas yeoman 588201 588201 Cambridge, Thomas, of Owtwell, yeoman 0
4262264 2117049 2117049 defendant Hall Edmund husbandman 588201 588201 Hall, Edmund, of Owtwell, husbandman 1
4262265 2117049 2117049 defendant Delphe Robert husbandman 588201 588201 Delphe, Robert, of Owtwell, husbandman 2
4277509 2122055 2122055 defendant Corbett Henry butcher 588201 588201 Corbett, Henry, of Owtwell, butcher 2
4393002 2162270 2162270 defendant Overstowe Richard blacksmith 588201 588201 Overstowe, Richard, of Owtwell, blacksmith 0
4393003 2162270 2162270 defendant Boste John husbandman 588201 588201 Boste, John, of owtwell, husbandman 1
5092367 2384144 2384144 defendant Bocher John   588201 588201 Bocher, John, of Owtwell, Norf. butcher 1
5106132 2388231 2388231 plaintiff Covyngton or Conyngton Thomas   588201 588201 Covyngton or Conyngton, Thomas, of Owtwell 0
5106133 2388231 2388231 defendant Powediche Peter, senior husbandman 588201 588201 Powediche, Peter, senior, of Owtwell, husbandman 0
5110354 2389433 2389433 plaintiff Gryme Thomas (legal representative) 588201 588201 Gryme, Thomas, of Owtwell, executor of 0
5287151 2441256 2441256 defendant Joly Thomas dyer 588201 588201 Joly, Thomas, of Owtwell, dyer 2
5301480 2445396 2445396 defendant Baret John brewer 588201 588201 Baret, John, of Owtwell, brewer 1
5526642 2512898 2512898 defendant Powedyche James roper 588201 588201 Powedyche, James, of Owtwell, roper 0
5526643 2512898 2512898 defendant Powedyche Thomas roper 588201 588201 Powedyche, Thomas, of Owtwell, roper 1
5526645 2512899 2512899 defendant Powedyche James roper 588201 588201 Powedyche, James, of Owtwell, roper 0
5526646 2512899 2512899 defendant Powedyche Thomas roper 588201 588201 Powedyche, Thomas, of Owtwell, roper 1
5530180 2513945 2513945 defendant Shen Robert husbandman 588201 588201 Shen, Robert, of Owtwell, husbandman 0
5533762 2515107 2515107 defendant Heywod Richard gent 588201 588201 Heywod, Richard, of Owtwell, gent 1
5577323 2527965 2527965 plaintiff Wellys Thomas gent 588201 588201 Wellys, Thomas, of Owtwell, gent 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);