names

154 rows where place_id = 593519

✎ 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
3612210 1871459 1871459 defendant Blakborne John sherman 593519 593519 Blakborne, John, of Est Grensted, sherman 7
3707743 1928717 1928717 defendant Uden Richard husbandman 593519 593519 Uden, Richard, of Est Grensted, husbandman 1
3738048 1938116 1938116 defendant Uden Richard husbandman 593519 593519 Uden, Richard, of Est Grensted, husbandman 1
3746692 1940877 1940877 defendant Cocheford Thomas husbandman 593519 593519 Cocheford, Thomas, of Est Grensted, husbandman 0
3755667 1943729 1943729 defendant Humfrey Robert husbandman 593519 593519 Humfrey, Robert, of Est Grensted, husbandman 0
3766982 1947340 1947340 defendant Stanford Thomas tailor 593519 593519 Stanford, Thomas, of Est Grensted, tailor 1
3785313 1953193 1953193 defendant Albery Edmund gent 593519 593519 Albery, Edmund, of Est Grensted, gent 0
3800855 1958176 1958176 defendant Umfrey Robert husbandman 593519 593519 Umfrey, Robert, of Est Grensted, husbandman 0
3826372 1966096 1966096 defendant Umfrey John husbandman 593519 593519 Umfrey, John, of Est Grensted, husbandman 0
3826373 1966096 1966096 defendant Stonstrete Thomas   593519 593519 Stonstrete, Thomas, of Est Grensted, ash burner 1
3840852 1970708 1970708 defendant Umfrey John husbandman 593519 593519 Umfrey, John, of Est Grensted, husbandman 0
3840853 1970708 1970708 defendant Stonstrete Thomas   593519 593519 Stonstrete, Thomas, of Est Grensted, ash burner 1
3857534 1975991 1975991 defendant Umfrey John husbandman 593519 593519 Umfrey, John, of Est grensted, husbandman 0
3857535 1975991 1975991 defendant Stonstrete Thomas   593519 593519 Stonstrete, Thomas, of Est Grensted, ash burner 1
3867220 1979273 1979273 defendant Bacon Thomas husbandman 593519 593519 Bacon, Thomas, of Est Grensted, husbandman 0
3871770 1980795 1980795 defendant Aleyn Henry husbandman 593519 593519 Aleyn, Henry, of Est Grensted, husbandman 0
3891648 1987461 1987461 defendant Alfrey Edward gent 593519 593519 Alfrey, Edward, of Est Grensted, gent 0
3891649 1987461 1987461 defendant Goodwyn Edward mercer 593519 593519 Goodwyn, Edward, of Est Grensted, mercer 1
3891650 1987461 1987461 defendant Umfrey John husbandman 593519 593519 Umfrey, John, of Est Grensted, husbandman 2
3898991 1989868 1989868 defendant Outtered William tailor 593519 593519 Outtered, William, of Est Grensted, tailor 0
3898994 1989869 1989869 defendant Outtred John tailor 593519 593519 Outtred, John, of Est Grensted, tailor 0
3907336 1992742 1992742 defendant Hasilden Thomas butcher 593519 593519 Hasilden, Thomas, of Est Grensted, butcher 0
3944458 2005161 2005161 defendant Camfeld Robert husbandman 593519 593519 (Camfeld, Robert, of Est Grensted, husbandman 1
4019876 2031840 2031840 defendant Cornecastle John husbandman 593519 593519 Cornecastle, John, of Est Grensted, husbandman 1
4021877 2032551 2032551 defendant A Tree John yeoman 593519 593519 A Tree, John, of Est Grensted, yeoman 0
4021879 2032552 2032552 defendant A Tree John yeoman 593519 593519 A Tree, John, of Est Grensted, yeoman 0
4021881 2032553 2032553 defendant Baldwyn James yeoman 593519 593519 Baldwyn, James, of Est Grensted, yeoman 0
4021883 2032554 2032554 defendant Wright Thomas shoemaker 593519 593519 Wright, Thomas, of Est Grensted, shoemaker 0
4021885 2032555 2032555 defendant Wryght Thomas shoemaker 593519 593519 Wryght, Thomas, of Est Grensted, shoemaker 0
4023392 2033076 2033076 defendant Humfrey Robert yeoman 593519 593519 Humfrey, Robert, of Est Grensted, yeoman 1
4055963 2044512 2044512 defendant Harryson Arthur nailer 593519 593519 Harryson, Arthur, of Est Grensted, nailer 1
4055964 2044512 2044512 defendant Cocke Roger husbandman 593519 593519 Cocke, Roger, of Est Grensted, husbandman 2
4055965 2044512 2044512 defendant Osborne John collier 593519 593519 Osborne, John, of Est Grensted, collier 3
4057036 2044899 2044899 defendant Wynson John weaver 593519 593519 Wynson, John, of Est Grensted, weaver 0
4057037 2044899 2044899 defendant Osborne John collier 593519 593519 Osborne, John, of Est Grensted, collier 1
4057696 2045135 2045135 defendant Browne William butcher 593519 593519 Browne, William, of Est Grensted, butcher 0
4069942 2049533 2049533 defendant Hayselden Richard yeoman 593519 593519 Hayselden, Richard, of Est Grensted, yeoman 0
4069943 2049533 2049533 defendant Bottyng John husbandman 593519 593519 Bottyng, John, of Est Grensted, husbandman 1
4069944 2049533 2049533 defendant Morgan William tailor 593519 593519 Morgan, William, of Est Grensted, tailor 2
4072849 2050586 2050586 plaintiff Payne John yeoman 593519 593519 Payne, John, of Est Grensted, yeoman 0
4078148 2052489 2052489 defendant Saxpes John yeoman 593519 593519 Saxpes, John, of Est Grensted, yeoman 0
4092604 2057663 2057663 defendant Lullyngden Drew yeoman 593519 593519 Lullyngden, Drew, of Est Grensted, yeoman 0
4097159 2059307 2059307 defendant Croft Thomas husbandman 593519 593519 Croft, Thomas, of Est Grensted, husbandman 0
4106801 2062725 2062725 defendant Cropper or Gropper Henry yeoman 593519 593519 Cropper or Gropper, Henry, of Est Grensted, yeoman 0
4108493 2063292 2063292 defendant Humfrey Robert, junior yeoman 593519 593519 (Humfrey, Robert, junior, of Est Grensted, yeoman 1
4108494 2063292 2063292 defendant Payne Henry yeoman 593519 593519 Payne, Henry, of Est Grensted, yeoman 2
4131492 2071582 2071582 defendant Apprice Edward shoemaker 593519 593519 Apprice, Edward, of East Grensted, or of Newbury, Berks, shoemaker 0
4131494 2071583 2071583 defendant Apprice Edward shoemaker 593519 593519 Apprice, Edward, of East Grensted, or of Newburye, Berks, shoemaker 0
4131583 2071613 2071613 defendant Ellys William brother of Thomas Ellys 593519 593519 Ellys, William, of Est Grensted, yeoman, brother of Thomas Ellys 0
4136747 2073492 2073492 defendant Hussher Nicholas collier 593519 593519 Hussher, Nicholas, of Est Grensted, collier 0
4155281 2079940 2079940 defendant Ellys William   593519 593519 Ellys, William, of Est Grensted, yeoman, son of Thomas Ellys 0
4174976 2086714 2086714 defendant Webb Thomas husbandman 593519 593519 Webb, Thomas, of East Grensted, husbandman 2
4174980 2086715 2086715 defendant Webbe Thomas husbandman 593519 593519 Webbe, Thomas, of Est Grensted, husbandman 2
4177538 2087621 2087621 defendant Synco John yeoman 593519 593519 Synco, John, of Est Grensted, yeoman 0
4178384 2087914 2087914 defendant Syncoe William innholder 593519 593519 Syncoe, William, of Est Grensted, innholder 0
4181022 2088839 2088839 defendant Goble Henry yeoman 593519 593519 Goble, Henry, of East Grensted, yeoman 1
4219182 2102206 2102206 defendant Lullyngden William yeoman 593519 593519 Lullyngden, William, of Est Grensted, yeoman 0
4219183 2102206 2102206 defendant Fawkener Peter weaver 593519 593519 Fawkener, Peter, of Est Grensted, weaver 1
4219184 2102206 2102206 defendant Baldwyn William husbandman 593519 593519 Baldwyn, William, of Est Grensted, husbandman 2
4219186 2102207 2102207 defendant Lullyngden William yeoman 593519 593519 Lullyngden, William, of Est Grensted, yeoman 0
4219187 2102207 2102207 defendant Fawkener Peter weaver 593519 593519 Fawkener, Peter, of Est Grensted, weaver 1
4219188 2102207 2102207 defendant Baldwyn William husbandman 593519 593519 Baldwyn, William, of Est Grensted, husbandman 2
4220897 2102803 2102803 defendant Rydges Grace widow 593519 593519 Rydges, Grace, of Est Grensted, widow 1
4230781 2106265 2106265 defendant Humfrey Michael husbandman 593519 593519 Humfrey, Michael, of Est Grensted, husbandman 0
4246735 2111887 2111887 defendant Ridges William (legal representative) 593519 593519 Ridges, William, of Est Grensted, yeoman, executrix of 0
4246736 2111887 2111887 defendant Ridges Grace widow 593519 593519 Ridges, Grace, of Est Grensted, widow 1
4256908 2115283 2115283 defendant Lullyngdon William yeoman 593519 593519 Lullyngdon, William, of Est Grensted, yeoman 0
4256910 2115283 2115283 defendant Baldwyn William husbandman or yeoman 593519 593519 Baldwyn, William, of Est Grensted, husbandman or yeoman 2
4257161 2115372 2115372 defendant Lullyngdon William yeoman 593519 593519 Lullyngdon, William, of Est Grensted, yeoman 0
4257162 2115372 2115372 defendant Fawkener Peter weaver 593519 593519 Fawkener, Peter, of Est Grensted, weaver 1
4257163 2115372 2115372 defendant Baldwyn William yeoman 593519 593519 Baldwyn, William, of Est Grensted, yeoman 2
4312338 2134451 2134451 defendant Petley Ralph innholder 593519 593519 Petley, Ralph, of Est Grensted, gent, innholder 0
4317493 2136233 2136233 defendant Bellyngham Edward chapman 593519 593519 Bellyngham, Edward, of East Grensted, chapman 1
4321905 2137747 2137747 defendant Ellys William yeoman 593519 593519 Ellys, William, of Est Grensted, yeoman 1
4323173 2138164 2138164 defendant Petley Ralph gent 593519 593519 Petley, Ralph, of Est Grensted, gent 0
4333731 2141560 2141560 defendant Ellys William yeoman 593519 593519 Ellys, William, of Est Grensted, yeoman 1
4359562 2150580 2150580 defendant Lullyngden William yeoman 593519 593519 Lullyngden, William, of Est Grensted, yeoman 0
4367915 2153575 2153575 defendant Brasted William butcher 593519 593519 Brasted, William, of Est Grensted, butcher 0
4367916 2153575 2153575 defendant Duffeild William yeoman 593519 593519 Duffeild, William, of Est Grensted, yeoman 1
4367917 2153575 2153575 defendant Durrant John shoemaker 593519 593519 Durrant, John, of Est Grensted, shoemaker 2
4367918 2153575 2153575 defendant Bassett William husbandman 593519 593519 Bassett, William, of Est Grensted, husbandman 3
4427415 2173414 2173414 defendant Estcote Thomas   593519 593519 Estcote, Thomas, of East Grensted 1
4437684 2176543 2176543 plaintiff Wynton John de   593519 593519 Wynton, John de, of East Grensted, parson 0
4500978 2200914 2200914 defendant Brookes John   593519 593519 Brookes, John, of East Grensted 0
4754463 2281775 2281775 defendant Nevell Alan clerk & parson 593519 593519 Nevell, Alan, of East Grensted, clerk & parson 0
4776492 2288642 2288642 defendant Modell John husbandman 593519 593519 Modell, John, of Est Grensted, husbandman 0
4790993 2293274 2293274 defendant Joop Nicholas gent 593519 593519 Joop, Nicholas, of Est Grensted, gent 0
4815843 2301058 2301058 defendant Joop Nicholas gent 593519 593519 Joop, Nicholas, of East Grensted, gent 0
4822036 2302967 2302967 defendant Jopp Nicholas gent 593519 593519 Jopp, Nicholas, of East Grensted, gent 0
4838886 2308093 2308093 defendant Couper Richard   593519 593519 Couper, Richard, of East Grensted, bailiff 1
4841341 2308828 2308828 plaintiff Joop Nicholas   593519 593519 Joop, Nicholas, of East Grensted 0
4843061 2309362 2309362 defendant Moumbray Robert (legal representative) 593519 593519 Moumbray, Robert, of East Grensted, gent, executors of 0
4864287 2315807 2315807 defendant Arnold Robert tanner 593519 593519 Arnold, Robert, of Est Grensted, tanner 0
4870915 2317879 2317879 defendant Moumbray Robert (legal representative) 593519 593519 Moumbray, Robert, of Est Grensted, gent, executors of 0
4884143 2321948 2321948 defendant atte Hamme Thomas husbandman 593519 593519 atte Hamme, Thomas, of Est Grensted, husbandman 3
4906849 2328728 2328728 defendant Aleyn Thomas yeoman 593519 593519 Aleyn, Thomas, of Est Grensted, yeoman 0
4906850 2328728 2328728 defendant Crips John yeoman 593519 593519 Crips, John, of Est Grensted, yeoman 1
4932645 2336604 2336604 defendant Loder William husbandman 593519 593519 Loder, William, of East Grensted, husbandman 0
4958800 2344604 2344604 defendant Marcall Thomas tanner 593519 593519 Marcall, Thomas, of Est Grensted, tanner 0
4968713 2347610 2347610 defendant Marchall Thomas tanner 593519 593519 Marchall, Thomas, of Est Grensted, tanner 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);