names

74 rows where place_id = 586029

✎ 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
3587736 1863810 1863810 defendant Aston John carpenter 586029 586029 Aston, John, of Haveryll, carpenter 0
3599732 1867561 1867561 defendant Pyngyll Thomas yeoman 586029 586029 Pyngyll, Thomas, of Haveryll, yeoman 2
3633485 1905287 1905287 defendant Turnour Henry esq 586029 586029 Turnour, Henry, of Haveryll, esq 0
3634336 1905537 1905537 defendant Cornewayle Nicholas gent 586029 586029 Cornewayle, Nicholas, of Haveryll, gent 0
3634337 1905537 1905537 defendant Pyngyll Thomas tailor 586029 586029 Pyngyll, Thomas, of Haveryll, tailor 1
3634338 1905537 1905537 defendant Camsfeld John yeoman 586029 586029 Camsfeld, John, of Haveryll, yeoman 2
3637755 1906624 1906624 defendant Dodde John husbandman 586029 586029 Dodde, John, of Haveryll, husbandman 1
3637756 1906624 1906624 defendant Dodde Robert husbandman 586029 586029 Dodde, Robert, of Haveryll, husbandman 2
3642962 1908249 1908249 defendant Reve John clothmaker 586029 586029 Reve, John, of Haveryll, clothmaker 0
3651092 1910708 1910708 defendant Dodde Robert husbandman 586029 586029 Dodde, Robert, of Haveryll, husbandman 3
3663638 1914559 1914559 defendant Cowper Richard cowper 586029 586029 Cowper, Richard, of Haveryll, cowper 2
3663639 1914559 1914559 defendant Covyn John husbandman 586029 586029 Covyn, John, of Haveryll, husbandman 3
3667698 1915844 1915844 defendant Awger John yeoman 586029 586029 Awger, John, of Haveryll, yeoman 0
3667699 1915844 1915844 defendant Reson John tanner 586029 586029 Reson, John, of Haveryll, tanner 1
3673087 1917589 1917589 defendant Wage John husbandman 586029 586029 Wage, John, of Haveryll, husbandman 1
3673886 1917866 1917866 defendant Tye Thomas butcher 586029 586029 Tye, Thomas, of Haveryll, butcher 0
3675347 1918328 1918328 defendant Flory Robert husbandman 586029 586029 Flory, Robert, of Haveryll, husbandman 0
3676166 1918588 1918588 defendant Barker Nicholas husbandman 586029 586029 Barker, Nicholas, of Haveryll, husbandman 0
3679477 1919648 1919648 defendant Reve John clothier 586029 586029 Reve, John, of Haveryll, clothier 0
3679480 1919649 1919649 defendant Reve John clothier 586029 586029 Reve, John, of Haveryll, clothier 0
3679481 1919649 1919649 defendant Carter John clothier 586029 586029 Carter, John, of Haveryll, clothier 1
3679482 1919649 1919649 defendant Dodde Robert husbandman 586029 586029 Dodde, Robert, of Haveryll, husbandman 2
3682991 1920794 1920794 defendant Flory Robert husbandman 586029 586029 Flory, Robert, of Haveryll, husbandman 0
3682992 1920794 1920794 defendant Symson Robert chaplain 586029 586029 Symson, Robert, of Haveryll, chaplain 1
3727264 1934802 1934802 defendant Pyngle Thomas husbandman 586029 586029 Pyngle, Thomas, of Haveryll, husbandman 0
3751949 1942526 1942526 defendant Alger John miller 586029 586029 Alger, John, of Haveryll, miller 0
3751950 1942526 1942526 defendant Hubbard Nicholas gent 586029 586029 Hubbard, Nicholas, of Haveryll, gent 1
3784712 1953007 1953007 plaintiff Michell Joan (legal representative) 586029 586029 Michell, Joan, of Haveryll, widow of Michell, Andrew, of Cambridge, executor of 0
3820215 1964203 1964203 defendant Seson John innholder 586029 586029 Seson, John, of Haveryll, innholder 1
3820217 1964203 1964203 defendant Burton Leonard yeoman 586029 586029 Burton, Leonard, of Haveryll, yeoman 3
3820218 1964203 1964203 defendant Fayer John husbandman 586029 586029 Fayer, John, of Haveryll, husbandman 4
3822395 1964903 1964903 defendant Smyth Thomas shoemaker 586029 586029 Smyth, Thomas, of Haveryll, shoemaker 0
3846536 1972473 1972473 defendant Reve John clothmaker 586029 586029 Reve, John, of Haveryll, clothmaker 0
3850347 1973697 1973697 plaintiff Michell Joan (legal representative) 586029 586029 Michell, Joan, of Haveryll, widow, executor of 0
4468878 2190945 2190945 defendant Chapeyles John   586029 586029 Chapeyles, John, of Haveryll 0
4468880 2190946 2190946 defendant Chapeyles John   586029 586029 Chapeyles, John, of Haveryll 0
4543015 2213706 2213706 defendant Godefrey John   586029 586029 Godefrey, John, of Haveryll 0
4547665 2215211 2215211 defendant Payn John   586029 586029 Payn, John, of Haveryll 0
4555553 2217666 2217666 defendant Copleyngge John   586029 586029 Copleyngge, John, of Haveryll 0
4573395 2223210 2223210 defendant Smyth Gerard   586029 586029 Smyth, Gerard, of Haveryll 0
4587523 2227500 2227500 defendant Tomesson William   586029 586029 Tomesson, William, of Haveryll 0
4587524 2227500 2227500 defendant Payn John   586029 586029 Payn, John, of Haveryll 1
4594406 2229511 2229511 plaintiff Polsted Thomas (legal representative) 586029 586029 Polsted, Thomas, of Haveryll, executors of 0
4618911 2236908 2236908 defendant Goldsmyth John   586029 586029 Goldsmyth, John, of Haveryll 2
4643426 2244180 2244180 defendant Rodyng William smith 586029 586029 Rodyng, William, of Haveryll, smith 3
4643433 2244181 2244181 defendant Redyng William smith 586029 586029 Redyng, William, of Haveryll, smith 3
4724774 2273046 2273046 defendant Sturmyn William weaver 586029 586029 Sturmyn, William, of Haveryll, weaver 2
4810466 2299418 2299418 defendant Kelyng John   586029 586029 Kelyng, John, of Haveryll 1
4849033 2311168 2311168 defendant Ragdale Thomas laborer 586029 586029 Ragdale, Thomas, of Haveryll, laborer 0
4867220 2316710 2316710 defendant Lane William, junior husbandman 586029 586029 Lane, William, junior, of Haveryll, husbandman 0
4870732 2317824 2317824 defendant Cote William smith 586029 586029 Cote, William, of Haveryll, smith 0
4870733 2317824 2317824 defendant Thomson John spicer 586029 586029 Thomson, John, of Haveryll, spicer 1
4870734 2317824 2317824 defendant Lane John tanner 586029 586029 Lane, John, of Haveryll, tanner 2
4870736 2317825 2317825 defendant Cote William smith 586029 586029 Cote, William, of Haveryll, smith 0
4870737 2317825 2317825 defendant Thomson John spicer 586029 586029 Thomson, John, of Haveryll, spicer 1
4870738 2317825 2317825 defendant Lane John tanner 586029 586029 Lane, John, of Haveryll, tanner 2
4873144 2318552 2318552 defendant Hegge John   586029 586029 Hegge, John, of Haveryll, wright 4
4912060 2330272 2330272 defendant Glover Alice widow 586029 586029 Glover, Alice, of Haveryll, widow 5
4944761 2340348 2340348 defendant Renell or Revell William husbandman 586029 586029 Renell or Revell, William, of Haveryll, husbandman 0
4944763 2340349 2340349 defendant Revell or Renell William husbandman 586029 586029 Revell or Renell, William, of Haveryll, husbandman 0
4949732 2341909 2341909 defendant Renell or Revell William husbandman 586029 586029 Renell or Revell, William, of Haveryll, husbandman 2
4960052 2344973 2344973 defendant Cornewell John   586029 586029 Cornewell, John, of Haveryll, receiver general for Bourchier, Henry, Earl of Ewe 0
4960261 2345044 2345044 defendant Coote William husbandman 586029 586029 Coote, William, of Haveryll, husbandman 0
4975365 2349591 2349591 defendant Lane John husbandman 586029 586029 (Lane, John, of Haveryll, husbandman 6
4977136 2350116 2350116 defendant Mayster John gent 586029 586029 Mayster, John, of Haveryll, gent 0
4986776 2352982 2352982 defendant Smyth John husbandman 586029 586029 Smyth, John, of Haveryll, husbandman 3
4992797 2354727 2354727 defendant Cook Walen husbandman 586029 586029 Cook, Walen, of Haveryll, husbandman 0
5123500 2393325 2393325 defendant Fenne William husbandman 586029 586029 Fenne, William, of Haveryll, husbandman 1
5337405 2456259 2456259 defendant Crowe Robert draper 586029 586029 Crowe, Robert, of Haveryll, draper 3
5352581 2460903 2460903 defendant Pryour Thomas   586029 586029 Pryour, Thomas, of Haveryll, tallow chandler 3
5352586 2460904 2460904 defendant Pryour Thomas   586029 586029 Pryour, Thomas, of Haveryll, tallow chandler 3
5417285 2480088 2480088 defendant Rysby William husbandman 586029 586029 Rysby, William, of Haveryll, husbandman 0
5520786 2511322 2511322 defendant Lyng John, junior husbandman 586029 586029 Lyng, John, junior, of Haveryll, husbandman 1
5604740 2536345 2536345 defendant Lambard John grocer 586029 586029 Lambard, John, of Haveryll, grocer 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);