names

217 rows where place_id = 587620

✎ 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
3591965 1865100 1865100 defendant Rous William yeoman 587620 587620 Rous, William, of Saltfletby, yeoman 0
3597582 1866869 1866869 defendant Pormard Thomas gent 587620 587620 Pormard, Thomas, of Saltfletby, gent 2
3600689 1867865 1867865 defendant Pormard Thomas gent 587620 587620 Pormard, Thomas, of Saltfletby, gent 0
3607292 1869942 1869942 defendant Sparke Robert carpenter 587620 587620 Sparke, Robert, of Saltfletby, carpenter 2
3630437 1904352 1904352 defendant Spark Robert husbandman 587620 587620 Spark, Robert, of Saltfletby, husbandman 0
3634139 1905477 1905477 defendant Baliff John yeoman 587620 587620 Baliff, John, of Saltfletby, yeoman 0
3637908 1906672 1906672 defendant Crathorn Barnard gent 587620 587620 Crathorn, Barnard, of Saltfletby, gent 1
3643030 1908268 1908268 defendant Shirwode Robert yeoman 587620 587620 Shirwode, Robert, of Saltfletby, yeoman 1
3654658 1911715 1911715 defendant West Robert husbandman 587620 587620 West, Robert, of Saltfletby, husbandman 0
3702017 1926886 1926886 defendant Sherwode William chaplain 587620 587620 Sherwode, William, of Saltfletby, chaplain 0
3702018 1926886 1926886 defendant Sherwode George laborer 587620 587620 Sherwode, George, of Saltfletby, laborer 1
3702019 1926886 1926886 defendant West Robert mariner 587620 587620 West, Robert, of Saltfletby, mariner 2
3702020 1926886 1926886 defendant Raa Nicholas, senior laborer 587620 587620 Raa, Nicholas, senior, of Saltfletby, laborer 3
3702021 1926886 1926886 defendant Kendall alias Barton Alice spinster 587620 587620 Kendall alias Barton, Alice, of Saltfletby, spinster 4
3708324 1928899 1928899 defendant Sherwode Robert yeoman 587620 587620 Sherwode, Robert, of Saltfletby, yeoman 0
3708333 1928902 1928902 defendant Heryson John laborer 587620 587620 Heryson, John, of Saltfletby, laborer 0
3722903 1933428 1933428 defendant Sherwode Robert yeoman 587620 587620 Sherwode, Robert, of Saltfletby, yeoman 0
3735304 1937274 1937274 defendant Furnes William yeoman 587620 587620 Furnes, William, of Saltfletby, yeoman 2
3735614 1937371 1937371 defendant Bale alias Baylye William yeoman 587620 587620 Bale alias Baylye, William, of Saltfletby, yeoman 2
3770457 1948440 1948440 defendant Pormarde George gent 587620 587620 Pormarde, George, of Saltfletby, gent 0
3828230 1966699 1966699 defendant Brigge John husbandman 587620 587620 Brigge, John, of Saltfletby, husbandman 1
3831036 1967590 1967590 defendant Ratheby John gent 587620 587620 Ratheby, John, of Saltfletby, gent 0
3834582 1968750 1968750 plaintiff Newcomen Martin gent 587620 587620 Newcomen, Martin, of Saltfletby, gent 0
3837253 1969557 1969557 defendant Rathby John gent 587620 587620 Rathby, John, of Saltfletby, gent 1
3844512 1971824 1971824 defendant Crathorn Thomas gent 587620 587620 Crathorn, Thomas, of Saltfletby, gent 0
3864363 1978277 1978277 defendant Browne Martin husbandman 587620 587620 Browne, Martin, of Saltfletby, husbandman 0
3866914 1979172 1979172 defendant Crathorn Ralph gent 587620 587620 Crathorn, Ralph, of Saltfletby, gent 0
3867295 1979295 1979295 defendant Crathorne Thomas gent 587620 587620 Crathorne, Thomas, of Saltfletby, gent 0
3881900 1984200 1984200 defendant Ratheby John gent 587620 587620 Ratheby, John, of Saltfletby, gent 0
3897686 1989434 1989434 defendant Browne Martin husbandman 587620 587620 Browne, Martin, of Saltfletby, husbandman 0
3897687 1989434 1989434 defendant Garbray John husbandman 587620 587620 Garbray, John, of Saltfletby, husbandman 1
3924288 1998432 1998432 defendant Craythorn Ralph husbandman 587620 587620 Craythorn, Ralph, of Saltfletby, husbandman 0
3937012 2002710 2002710 defendant Cabarne Thomas yeoman 587620 587620 Cabarne, Thomas, of Saltfletby, yeoman 0
3937013 2002710 2002710 defendant Cawthorp John yeoman 587620 587620 Cawthorp, John, of Saltfletby, yeoman 1
3941570 2004194 2004194 plaintiff Veill Thomas   587620 587620 Veill, Thomas, of Saltfletby, clerk, administrators of 0
3941742 2004252 2004252 defendant Arnold John clerk 587620 587620 Arnold, John, of Saltfletby, clerk 0
3941746 2004253 2004253 defendant Arnold John clerk 587620 587620 Arnold, John, of Saltfletby, clerk 0
3948937 2006695 2006695 defendant Caborn John yeoman 587620 587620 Caborn, John, of Saltfletby, yeoman 0
3948939 2006696 2006696 defendant Cawthorpe Martin husbandman 587620 587620 Cawthorpe, Martin, of Saltfletby, husbandman 0
3974505 2015661 2015661 defendant Caborne Thomas drover 587620 587620 Caborne, Thomas, of Saltfletby, drover 1
3974920 2015794 2015794 defendant Caborne Thomas husbandman 587620 587620 Caborne, Thomas, of Saltfletby, husbandman 0
3976680 2016417 2016417 defendant Caborne John Lincs, yeoman 587620 587620 Caborne John, of Saltfletby, Lincs, yeoman 10
4004103 2026240 2026240 defendant North Cuthbert butcher 587620 587620 North, Cuthbert, of Saltfletby, butcher 0
4004104 2026240 2026240 defendant Barkworthe Henry yeoman 587620 587620 Barkworthe, Henry, of Saltfletby, yeoman 1
4012895 2029340 2029340 defendant Caborne Thomas husbandman 587620 587620 Caborne Thomas, of Saltfletby, husbandman 0
4012897 2029341 2029341 defendant Caborne Thomas husbandman 587620 587620 Caborne, Thomas, of Saltfletby, husbandman 0
4012899 2029342 2029342 defendant Caborne Thomas husbandman 587620 587620 Caborne, Thomas, of Saltfletby, husbandman 0
4023458 2033097 2033097 defendant Wyllouse Robert yeoman 587620 587620 Wyllouse, Robert, of Saltfletby, yeoman 3
4023507 2033115 2033115 defendant Willouse or Willonse Robert yeoman 587620 587620 Willouse or Willonse, Robert, of Saltfletby, yeoman 3
4052449 2043296 2043296 defendant Sherwood William yeoman 587620 587620 Sherwood, William, of Saltfletby, yeoman 0
4057168 2044948 2044948 defendant Skypwyth John gent 587620 587620 Skypwyth, John, of Saltfletby, gent 0
4057725 2045148 2045148 plaintiff Caborne Christopher yeoman 587620 587620 Caborne, Christopher, of Saltfletby, yeoman 0
4070538 2049757 2049757 plaintiff Massingberde Thomas gent 587620 587620 Massingberde, Thomas, of Saltfletby, gent 0
4076489 2051887 2051887 defendant Skypwyth John gent 587620 587620 Skypwyth, John, of Saltfletby, gent 0
4124697 2069128 2069128 defendant Broune Richard yeoman 587620 587620 Broune, Richard, of Saltfletby, yeoman 0
4124698 2069128 2069128 defendant Broune John yeoman 587620 587620 Broune, John, of Saltfletby, yeoman 1
4137301 2073689 2073689 defendant Richardson Lawrence husbandman 587620 587620 Richardson, Lawrence, of Saltfletby, husbandman 0
4137302 2073689 2073689 defendant Smyth Richard husbandman 587620 587620 Smyth, Richard, of Saltfletby, husbandman 1
4147956 2077418 2077418 defendant Broune Richard yeoman 587620 587620 Broune, Richard, of Saltfletby, yeoman 0
4158266 2080963 2080963 defendant Keale Henry laborer 587620 587620 Keale, Henry, of Saltfletby, laborer 3
4170614 2085223 2085223 defendant Hundlebey John yeoman 587620 587620 Hundlebey, John, of Saltfletby, yeoman 0
4231619 2106560 2106560 defendant Grymball Martin yeoman 587620 587620 Grymball, Martin, of Saltfletby, yeoman 0
4238770 2109179 2109179 defendant Grimball Martin husbandman 587620 587620 Grimball, Martin, of Saltfletby, husbandman 0
4299294 2129844 2129844 defendant Preste John gent 587620 587620 Preste, John, of Saltfletby, gent 1
4329757 2140247 2140247 defendant Hundlebye John, junior yeoman 587620 587620 Hundlebye, John, junior, of Saltfletby, yeoman 2
4490893 2197849 2197849 plaintiff Webster Simon   587620 587620 Webster, Simon, of Saltfletby 0
4490894 2197849 2197849 defendant Haryngton John de   587620 587620 Haryngton, John de, of Saltfletby 0
4542108 2213425 2213425 defendant Wyther John   587620 587620 Wyther, John, of Saltfletby 0
4547150 2215041 2215041 plaintiff Burgh Simon   587620 587620 Burgh, Simon, of Saltfletby 0
4561469 2219521 2219521 defendant Wyles William   587620 587620 Wyles, William, of Saltfletby 2
4567893 2221532 2221532 defendant Edlyngton Richard (legal representative) 587620 587620 Edlyngton, Richard, of Saltfletby, executors of 0
4572019 2222815 2222815 defendant Tote Robert   587620 587620 together with Tote, Robert, of Saltfletby 1
4575643 2223893 2223893 defendant Adamson William   587620 587620 Adamson, William, of Saltfletby 0
4575645 2223893 2223893 defendant Broun Richard   587620 587620 Broun, Richard, of Saltfletby 2
4659855 2248934 2248934 defendant Rous Michael yeoman 587620 587620 Rous, Michael, of Saltfletby, yeoman 0
4663305 2249994 2249994 defendant Borogh Simon husbandman 587620 587620 Borogh, Simon, of Saltfletby, husbandman 0
4692073 2263051 2263051 defendant Gregge Robert husbandman 587620 587620 Gregge, Robert, of Saltfletby, husbandman 8
4692878 2263278 2263278 defendant Gregge Robert husbandman 587620 587620 Gregge, Robert, of Saltfletby, husbandman 8
4708159 2267929 2267929 plaintiff Hewys John   587620 587620 Hewys, John, of Saltfletby 3
4708226 2267950 2267950 plaintiff Helwys John   587620 587620 Helwys, John, of Saltfletby 3
4726109 2273454 2273454 plaintiff Gregge Robert brother of William 587620 587620 Gregge, Robert, of Saltfletby, brother of William 1
4735209 2276159 2276159 defendant Rous Michael husbandman 587620 587620 Rous, Michael, of Saltfletby, husbandman 0
4735210 2276159 2276159 defendant Rous William husbandman 587620 587620 Rous, William, of Saltfletby, husbandman 1
4737542 2276854 2276854 defendant Veskeford William clerk & parson 587620 587620 Veskeford, William, of Saltfletby, clerk & parson 0
4739406 2277408 2277408 defendant del Aa Richard husbandman 587620 587620 del Aa, Richard, of Saltfletby, husbandman 0
4739435 2277418 2277418 defendant Veskeford William clerk 587620 587620 Veskeford, William, of Saltfletby, clerk 0
4740866 2277843 2277843 defendant Pormard Robert husbandman 587620 587620 Pormard, Robert, of Saltfletby, husbandman 0
4750728 2280697 2280697 defendant rous Michael   587620 587620 rous, Michael, of Saltfletby, bailiff 2
4753675 2281522 2281522 defendant Craven John esq 587620 587620 Craven, John, of Saltfletby, esq 2
4754060 2281650 2281650 defendant Craven John esq 587620 587620 Craven, John, of Saltfletby, esq 2
4754190 2281689 2281689 defendant Cravene Henry   587620 587620 Cravene, Henry, of Saltfletby, parson 1
4775669 2288386 2288386 defendant Jonson Richard husbandman 587620 587620 Jonson, Richard, of Saltfletby, husbandman 0
4775670 2288386 2288386 defendant Richardson William laborer 587620 587620 Richardson, William, of Saltfletby, laborer 1
4815365 2300915 2300915 defendant of the AA Richard --ser 587620 587620 of the AA, Richard, of Saltfletby, --ser 0
4823992 2303578 2303578 defendant Gregge William clerk 587620 587620 Gregge, William, of Saltfletby, clerk 0
4827854 2304764 2304764 defendant Rousse Michael yeoman 587620 587620 Rousse, Michael, of Saltfletby, yeoman 2
4829828 2305372 2305372 defendant Rous Michael yeoman 587620 587620 Rous, Michael, of Saltfletby, yeoman 1
4832237 2306115 2306115 defendant Jonson John husbandman 587620 587620 (Jonson, John, of Saltfletby, husbandman 1
4832490 2306189 2306189 defendant Fysshwyk Thomas husbandman 587620 587620 Fysshwyk, Thomas, of Saltfletby, husbandman 1
4834790 2306882 2306882 defendant Paynard John husbandman 587620 587620 Paynard, John, of Saltfletby, husbandman 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);