names

62 rows where place_id = 637874

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3839093 1970147 1970147 defendant Coo Thomas husbandman 637874 637874 Coo, Thomas, of Bawdeswell, husbandman 0
3839095 1970148 1970148 defendant Coo Thomas laborer 637874 637874 Coo, Thomas, of Bawdeswell, laborer 0
3871523 1980719 1980719 defendant Hayes Roger smith 637874 637874 Hayes, Roger, of Bawdeswell, smith 1
3871524 1980719 1980719 defendant Bett Robert husbandman 637874 637874 Bett, Robert, of Bawdeswell, husbandman 2
3891455 1987409 1987409 defendant Coward Richard blacksmith 637874 637874 Coward, Richard, of Bawdeswell, blacksmith 1
3984287 2019144 2019144 defendant Kent Nicholas baker 637874 637874 Kent, Nicholas, of Bawdeswell, baker 2
3999118 2024445 2024445 defendant Sherryngham Denis butcher 637874 637874 Sherryngham, Denis, of Bawdeswell, butcher 0
4037050 2037915 2037915 defendant Cratche John yeoman 637874 637874 Cratche, John, of Bawdeswell, yeoman 1
4039209 2038649 2038649 defendant Sheringham Denis butcher 637874 637874 Sheringham, Denis, of Bawdeswell, butcher 1
4044715 2040557 2040557 defendant Hase Roger innholder 637874 637874 Hase, Roger, of Bawdeswell, innholder 0
4044716 2040557 2040557 defendant Hase Richard butcher 637874 637874 Hase, Richard, of Bawdeswell, butcher 1
4044717 2040557 2040557 defendant Hase Thomas fishmonger 637874 637874 Hase, Thomas, of Bawdeswell, fishmonger 2
4047735 2041637 2041637 defendant Sheryngham Denis butcher 637874 637874 Sheryngham, Denis, of Bawdeswell, butcher 0
4047737 2041638 2041638 defendant Sheryngham Denis butcher 637874 637874 Sheryngham, Denis, of Bawdeswell, butcher 0
4052121 2043180 2043180 defendant Hase Richard butcher 637874 637874 Hase, Richard, of Bawdeswell, butcher 6
4052134 2043181 2043181 defendant Hase Richard butcher 637874 637874 Hase, Richard, of Bawdeswell, butcher 7
4052971 2043499 2043499 defendant Hase Richard yeoman 637874 637874 Hase, Richard, of Bawdeswell, yeoman 0
4054070 2043839 2043839 defendant Hase Richard butcher 637874 637874 Hase, Richard, of Bawdeswell, butcher 0
4060495 2046156 2046156 defendant Wrenwryght John clerk 637874 637874 Wrenwryght, John, of Bawdeswell, clerk 3
4062720 2046966 2046966 defendant Warmyngham Richard   637874 637874 Warmyngham, Richard, of Bawdeswell, wool chapman 0
4062722 2046966 2046966 defendant Sheringham Richard husbandman 637874 637874 Sheringham, Richard, of Bawdeswell, husbandman 2
4062760 2046982 2046982 defendant Nonnes Robert innkeeper 637874 637874 Nonnes, Robert, of Bawdeswell, innkeeper 0
4068545 2049038 2049038 defendant Warmyncham Richard   637874 637874 Warmyncham, Richard, of Bawdeswell, wool chapman 0
4068546 2049038 2049038 defendant Sheryngham Denis butcher 637874 637874 Sheryngham, Denis, of Bawdeswell, butcher 1
4074284 2051101 2051101 defendant Hase Roger yeoman 637874 637874 Hase, Roger, of Bawdeswell, yeoman 0
4079269 2052887 2052887 defendant Sheringham Richard husbandman 637874 637874 Sheringham, Richard, of Bawdeswell, husbandman 2
4080866 2053467 2053467 defendant Sheringham Denis butcher 637874 637874 Sheringham, Denis, of Bawdeswell, butcher 0
4080867 2053467 2053467 defendant Warmyngham Richard husbandman 637874 637874 Warmyngham, Richard, of Bawdeswell, husbandman 1
4085447 2055071 2055071 defendant Sheringham Denis butcher 637874 637874 Sheringham, Denis, of Bawdeswell, butcher 0
4107587 2062997 2062997 defendant Hase Richard butcher 637874 637874 Hase, Richard, of Bawdeswell, butcher 2
4111229 2064265 2064265 defendant Nons Robert husbandman 637874 637874 Nons, Robert, of Bawdeswell, husbandman 0
4114145 2065340 2065340 defendant Sheringham Denis butcher 637874 637874 Sheringham, Denis, of Bawdeswell, butcher 0
4121145 2067856 2067856 defendant Eglington Henry husbandman 637874 637874 Eglington, Henry, of Bawdeswell, husbandman 0
4151194 2078541 2078541 defendant Hast Richard yeoman 637874 637874 Hast, Richard, of Bawdeswell, yeoman 3
4159819 2081502 2081502 defendant Bulwer William innholder 637874 637874 Bulwer, William, of Bawdeswell, innholder 0
4168805 2084580 2084580 defendant Eglenton William husbandman 637874 637874 Eglenton, William, of Bawdeswell, husbandman 0
4199522 2095384 2095384 defendant Sheryngham Denis yeoman 637874 637874 Sheryngham, Denis, of Bawdeswell, yeoman 0
4231364 2106471 2106471 defendant Gunnell Robert tailor 637874 637874 Gunnell, Robert, of Bawdeswell, tailor 2
4243328 2110759 2110759 defendant Beales Roger gent 637874 637874 Beales, Roger, of Bawdeswell, gent 0
4243330 2110760 2110760 defendant Beales Roger gent 637874 637874 Beales, Roger, of Bawdeswell, gent 0
4262118 2117005 2117005 defendant Powle Thomas yeoman 637874 637874 Powle, Thomas, of Bawdeswell, yeoman 0
4262119 2117005 2117005 defendant Eglyntyne William yeoman 637874 637874 Eglyntyne, William, of Bawdeswell, yeoman 1
4264261 2117693 2117693 defendant Brigham Henry cooper 637874 637874 Brigham, Henry, of Bawdeswell, cooper 3
4280998 2123255 2123255 defendant Johnes Anthony vintner 637874 637874 Johnes, Anthony, of Bawdeswell, vintner 2
4293079 2127589 2127589 defendant Graunge Gregory clerk 637874 637874 Graunge, Gregory, of Bawdeswell, clerk 0
4310524 2133834 2133834 defendant Graunge Gregory clerk 637874 637874 Graunge, Gregory, of Bawdeswell, clerk 0
4328372 2139806 2139806 defendant Wharton Henry yeoman 637874 637874 Wharton, Henry, of Bawdeswell, yeoman 0
4328373 2139806 2139806 defendant Moultyn Henry yeoman 637874 637874 Moultyn, Henry, of Bawdeswell, yeoman 1
4335839 2142265 2142265 defendant Clarke Robert   637874 637874 Clarke, Robert, of Bawdeswell, shepherd 2
4340266 2143858 2143858 defendant Gunwell Robert tailor 637874 637874 Gunwell, Robert, of Bawdeswell, tailor 2
4362222 2151535 2151535 defendant Wharton Henry yeoman 637874 637874 Wharton, Henry, of Bawdeswell, yeoman 0
4379840 2157889 2157889 defendant Hase Richard husbandman 637874 637874 Hase, Richard, of Bawdeswell, husbandman 0
4385868 2159967 2159967 defendant Duckett John, senior butcher 637874 637874 Duckett, John, senior, of Bawdeswell, butcher 0
4388172 2160672 2160672 defendant Alforde James yeoman 637874 637874 Alforde, James, of Bawdeswell, yeoman 0
4391717 2161849 2161849 defendant Enmer or Emner Robert tailor 637874 637874 Enmer or Emner, Robert, of Bawdeswell, tailor 3
4402942 2165569 2165569 defendant Powle Thomas yeoman 637874 637874 Powle, Thomas, of Bawdeswell, yeoman 3
4404813 2166177 2166177 defendant Beales George yeoman 637874 637874 Beales, George, of Bawdeswell, yeoman 0
4404815 2166177 2166177 defendant Gedney Stephen yeoman 637874 637874 Gedney, Stephen, of Bawdeswell, yeoman 2
4409073 2167640 2167640 defendant Wharton Henry innholder 637874 637874 Wharton, Henry, of Bawdeswell, innholder 0
4411205 2168335 2168335 defendant Warmingham Richard   637874 637874 Warmingham, Richard, of Bawdeswell, wool chapman 2
5377069 2468417 2468417 defendant Warner John ostler 637874 637874 Warner, John, of Bawdeswell, ostler 1
5426764 2482947 2482947 defendant Bysshop Nicholas yeoman 637874 637874 Bysshop, Nicholas, of Bawdeswell, yeoman 8

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);