names

267 rows where place_id = 592093

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606539 1869717 1869717 defendant Gyggys Robert yeoman 592093 592093 Gyggys, Robert, of Wyghton, yeoman 0
3615909 1872617 1872617 plaintiff Creke Robert (legal representative) 592093 592093 Creke, Robert, of Wyghton, executor of 0
3615911 1872617 1872617 defendant Wylch William husbandman 592093 592093 Wylch, William, of Wyghton, husbandman 0
3624198 1875101 1875101 defendant Gyggys Robert yeoman 592093 592093 Gyggys, Robert, of Wyghton, yeoman 0
3624199 1875101 1875101 defendant Gyggys Christopher yeoman 592093 592093 Gyggys, Christopher, of Wyghton, yeoman 1
3626677 1903189 1903189 defendant Palfreman Gilbert husbandman 592093 592093 Palfreman, Gilbert, of Wyghton, husbandman 0
3702164 1926934 1926934 defendant Clerys William   592093 592093 Clerys, William, of Wyghton, shepherd 1
3702168 1926935 1926935 defendant Hall William   592093 592093 Hall, William, of Wyghton, shepherd 2
3719733 1932438 1932438 defendant Hodson John miller 592093 592093 Hodson, John, of Wyghton, miller 1
3742198 1939429 1939429 defendant Clerys William   592093 592093 Clerys, William, of Wyghton, shepherd 0
3742199 1939429 1939429 defendant Gyggys Christopher gent 592093 592093 Gyggys, Christopher, of Wyghton, gent 1
3742447 1939508 1939508 defendant Scothorp John yeoman 592093 592093 Scothorp, John, of Wyghton, yeoman 1
3750764 1942162 1942162 defendant Asteley Thomas gent 592093 592093 Asteley, Thomas, of Wyghton, gent 0
3764263 1946481 1946481 defendant Asteley Thomas gent 592093 592093 Asteley, Thomas, of Wyghton, gent 2
3790629 1954892 1954892 defendant Sculthorp John yeoman 592093 592093 Sculthorp, John, of Wyghton, yeoman 1
3808944 1960678 1960678 defendant Feke James husbandman 592093 592093 Feke, James, of Wyghton, husbandman 0
3885654 1985458 1985458 defendant Kyng John husbandman 592093 592093 Kyng, John, of Wyghton, husbandman 0
3885658 1985460 1985460 defendant Kyng John husbandman 592093 592093 Kyng, John, of Wyghton, husbandman 0
3886410 1985707 1985707 plaintiff Buntyng John (legal representative) 592093 592093 Buntyng, John, of Wyghton, executor of Gloys, John, executor of 0
3893014 1987908 1987908 plaintiff Palfreman Clement husbandman 592093 592093 Palfreman, Clement, of Wyghton, husbandman 0
3899061 1989895 1989895 defendant Smyth John gent 592093 592093 Smyth, John, of Wyghton, gent 0
3899253 1989961 1989961 defendant Aungell John miller 592093 592093 Aungell, John, of Wyghton, miller 0
3913058 1994697 1994697 defendant Kyng John husbandman 592093 592093 Kyng, John, of Wyghton, husbandman 0
3916642 1995939 1995939 defendant Aungell John miller 592093 592093 Aungell, John, of Wyghton, miller 0
3920081 1997050 1997050 defendant Gloys Robert husbandman 592093 592093 Gloys, Robert, of Wyghton, husbandman 0
3920082 1997050 1997050 defendant Ryngsted John husbandman 592093 592093 Ryngsted, John, of Wyghton, husbandman 1
3924851 1998630 1998630 defendant Smyth John gent 592093 592093 Smyth, John, of Wyghton, gent 1
3934795 2001936 2001936 defendant Bawmforth William yeoman 592093 592093 Bawmforth, William, of Wyghton, yeoman 0
3953575 2008324 2008324 defendant Gygg alias Dobydo John yeoman 592093 592093 Gygg alias Dobydo, John, of Wyghton, yeoman 0
3972168 2014828 2014828 defendant Smyth John, junior gent 592093 592093 Smyth, John, junior, of Wyghton, gent 0
3977798 2016805 2016805 defendant Ranson Richard butcher 592093 592093 Ranson, Richard, of Wyghton, butcher 0
3992187 2021970 2021970 defendant Walpole George yeoman 592093 592093 Walpole, George, of Wyghton, yeoman 1
3999824 2024700 2024700 defendant Gygg John yeoman 592093 592093 Gygg, John, of Wyghton, yeoman 1
4018882 2031485 2031485 defendant Gygg John yeoman 592093 592093 Gygg John, of Wyghton, yeoman 0
4045839 2040957 2040957 defendant Mabbes Giles gent 592093 592093 Mabbes, Giles, of Wyghton, gent 0
4046738 2041287 2041287 defendant Grigges John yeoman 592093 592093 Grigges, John, of Wyghton, yeoman 0
4046740 2041288 2041288 defendant Mabbes Giles gent 592093 592093 Mabbes, Giles, of Wyghton, gent 0
4046743 2041289 2041289 defendant Mabbes Giles gent 592093 592093 Mabbes, Giles, of Wyghton, gent 0
4048832 2042028 2042028 defendant Teymes Stephen gent 592093 592093 Teymes, Stephen, of Wyghton, gent 1
4067516 2048697 2048697 defendant Black Henry yeoman 592093 592093 Black, Henry, of Wyghton, yeoman 0
4067520 2048698 2048698 defendant Cooke Thomas yeoman 592093 592093 Cooke, Thomas, of Wyghton, yeoman 2
4070623 2049790 2049790 defendant Cooke Thomas husbandman 592093 592093 Cooke, Thomas, of Wyghton, husbandman 0
4070624 2049790 2049790 defendant Wyghtman Walter husbandman 592093 592093 Wyghtman, Walter, of Wyghton, husbandman 1
4070625 2049790 2049790 defendant Baker Robert husbandman 592093 592093 Baker, Robert, of Wyghton, husbandman 2
4094381 2058330 2058330 defendant Beeston John husbandman 592093 592093 Beeston, John, of Wyghton, husbandman 1
4122736 2068424 2068424 defendant Angell William husbandman 592093 592093 Angell, William, of Wyghton, husbandman 0
4149870 2078083 2078083 defendant Feake George clerk 592093 592093 Feake, George, of Wyghton, clerk 0
4154073 2079518 2079518 defendant Smyth John gent 592093 592093 Smyth, John, of Wyghton, gent 2
4154078 2079519 2079519 defendant Smyth John gent 592093 592093 Smyth, John, of Wyghton, gent 2
4169609 2084877 2084877 defendant Smythe John gent 592093 592093 Smythe, John, of Wyghton, gent 0
4261049 2116660 2116660 defendant Thorye William husbandman 592093 592093 Thorye, William, of Wyghton, husbandman 1
4385461 2159827 2159827 defendant Jygg John, senior yeoman 592093 592093 Jygg, John, senior, of Wyghton, yeoman 2
4424114 2172397 2172397 defendant atte Milne William   592093 592093 atte Milne, William, of Wyghton 7
4430211 2174227 2174227 defendant Sale John de la   592093 592093 Sale, John de la, of Wyghton, son of Simon 0
4515749 2205354 2205354 plaintiff Clerk Thomas   592093 592093 Clerk, Thomas, of Wyghton 0
4522036 2207233 2207233 defendant Bernard John   592093 592093 Bernard, John, of Wyghton 1
4528219 2209100 2209100 plaintiff Malton Roger de   592093 592093 Malton, Roger de, of Wyghton, vicar 0
4552858 2216837 2216837 plaintiff Frankelayn Alice   592093 592093 Frankelayn, Alice, of Wyghton, formerly wife of Roger 0
4568218 2221629 2221629 defendant Collom Robert de   592093 592093 Collom, Robert de, of Wyghton 0
4578481 2224759 2224759 plaintiff Cliderawe Robert   592093 592093 Cliderawe, Robert, of Wyghton, vicar 0
4579275 2224999 2224999 defendant Whitelafe Robert   592093 592093 Whitelafe, Robert, of Wyghton 0
4591058 2228558 2228558 defendant Warner John   592093 592093 Warner, John, of Wyghton 2
4607773 2233543 2233543 defendant Thorlay John   592093 592093 Thorlay, John, of Wyghton 0
4609953 2234203 2234203 defendant Wodhall John   592093 592093 Wodhall, John, of Wyghton 0
4617971 2236627 2236627 defendant Grys John   592093 592093 Grys, John, of Wyghton 0
4622070 2237882 2237882 plaintiff Grys John   592093 592093 Grys, John, of Wyghton 1
4627324 2239489 2239489 defendant Collom Beatrice   592093 592093 Collom, Beatrice, of Wyghton 2
4627946 2239668 2239668 defendant Bell John smith 592093 592093 Bell, John, of Wyghton, smith 5
4628214 2239750 2239750 defendant Stevenson Robert   592093 592093 Stevenson, Robert, of Wyghton 3
4628215 2239750 2239750 defendant Fyssher Robert   592093 592093 Fyssher, Robert, of Wyghton 4
4628216 2239750 2239750 defendant Thorley William   592093 592093 Thorley, William, of Wyghton 5
4637981 2242643 2242643 plaintiff Burgeys Stephen   592093 592093 Burgeys, Stephen, of Wyghton 0
4637982 2242643 2242643 defendant Aubry Stephen   592093 592093 Aubry, Stephen, of Wyghton 0
4642164 2243821 2243821 defendant Grys John   592093 592093 Grys, John, of Wyghton 2
4642893 2244033 2244033 plaintiff Hilton Thomas de   592093 592093 Hilton, Thomas de, of Wyghton, prebendary of the prebend, in the Cathedral church 0
4649832 2245972 2245972 defendant Caudelere Richard   592093 592093 Caudelere, Richard, of Wyghton 10
4649908 2245990 2245990 defendant Grys John   592093 592093 Grys, John, of Wyghton 0
4655179 2247503 2247503 defendant Haterbergh William husbandman 592093 592093 Haterbergh, William, of Wyghton, husbandman 0
4659612 2248858 2248858 defendant Haterbergh William husbandman 592093 592093 Haterbergh, William, of Wyghton, husbandman 0
4663965 2250214 2250214 plaintiff Grys John   592093 592093 Grys, John, of Wyghton 0
4664620 2250413 2250413 defendant Haterbergh William yeoman 592093 592093 Haterbergh, William, of Wyghton, yeoman 1
4676599 2258299 2258299 defendant atte Fen Thomas laborer 592093 592093 atte Fen, Thomas, of Wyghton, laborer 1
4676980 2258418 2258418 plaintiff Grys John   592093 592093 Grys, John, of Wyghton, on his own account 0
4676981 2258418 2258418 defendant Atte Fen Edmund husbandman 592093 592093 Atte Fen, Edmund, of Wyghton, husbandman 0
4687848 2261764 2261764 defendant Fen Edmund   592093 592093 Fen, Edmund, of Wyghton 5
4687957 2261801 2261801 defendant Frankeleyne Robert gent 592093 592093 Frankeleyne, Robert, of Wyghton, gent 1
4691735 2262947 2262947 defendant Berngere Thomas   592093 592093 Berngere, Thomas, of Wyghton, shepherd 0
4695985 2264231 2264231 defendant Haterbergh William yeoman 592093 592093 Haterbergh, William, of Wyghton, yeoman 0
4696012 2264237 2264237 defendant Haterbergh William yeoman 592093 592093 Haterbergh, William, of Wyghton, yeoman 1
4701024 2265724 2265724 defendant Chamberlayn Agnes widow 592093 592093 Chamberlayn, Agnes, of Wyghton, widow 3
4706271 2267342 2267342 defendant Crak Richard butcher 592093 592093 Crak, Richard, of Wyghton, butcher 0
4708411 2267995 2267995 defendant Coo Thomas husbandman 592093 592093 Coo, Thomas, of Wyghton, husbandman 0
4708486 2268022 2268022 defendant Wykkes John clerk 592093 592093 Wykkes, John, of Wyghton, clerk 0
4712354 2269179 2269179 defendant atte Fen John butcher 592093 592093 atte Fen, John, of Wyghton, butcher 1
4715458 2270171 2270171 defendant Haterbergh William yeoman 592093 592093 Haterbergh, William, of Wyghton, yeoman 0
4720486 2271744 2271744 defendant Lyndesay Robert husbandman 592093 592093 Lyndesay, Robert, of Wyghton, husbandman 0
4733425 2275631 2275631 defendant Crak Richard butcher 592093 592093 Crak, Richard, of Wyghton, butcher 0
4750475 2280622 2280622 defendant Haterbergh William husbandman 592093 592093 Haterbergh, William, of Wyghton, husbandman 0
4750500 2280628 2280628 defendant Marham Richard yeoman 592093 592093 Marham, Richard, of Wyghton, yeoman 6
4751346 2280870 2280870 defendant Baude John yeoman 592093 592093 Baude, John, of Wyghton, yeoman 3

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