names

162 rows where place_id = 603490

✎ 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
3654693 1911726 1911726 defendant Dyconson Richard laborer 603490 603490 Dyconson, Richard, of Wyberton, laborer 0
3654694 1911726 1911726 defendant Cooke Robert laborer 603490 603490 Cooke, Robert, of Wyberton, laborer 1
3719075 1932244 1932244 defendant Hogekynson Roger husbandman 603490 603490 Hogekynson, Roger, of Wyberton, husbandman 0
3719077 1932245 1932245 defendant Hogekynson Roger husbandman 603490 603490 Hogekynson, Roger, of Wyberton, husbandman 0
3719079 1932246 1932246 defendant Hokyngson Roger husbandman 603490 603490 Hokyngson, Roger, of Wyberton, husbandman 0
3739160 1938459 1938459 defendant Hogekynson Roger husbandman 603490 603490 Hogekynson, Roger, of Wyberton, husbandman 1
3759252 1944885 1944885 plaintiff Chetur Richard   603490 603490 Chetur, Richard, of Wyberton 0
3767577 1947496 1947496 defendant Strayll Christopher gent 603490 603490 Strayll, Christopher, of Wyberton, gent 0
3842550 1971198 1971198 defendant Lyndeley Robert husbandman 603490 603490 Lyndeley, Robert, of Wyberton, husbandman 0
3842551 1971198 1971198 defendant Carleton Thomas husbandman 603490 603490 Carleton, Thomas, of Wyberton, husbandman 1
3852443 1974370 1974370 defendant Akey John husbandman 603490 603490 Akey, John, of Wyberton, husbandman 1
3854797 1975145 1975145 defendant Hogekynson Roger husbandman 603490 603490 Hogekynson, Roger, of Wyberton, husbandman 0
3854798 1975145 1975145 defendant Hogekynson William husbandman 603490 603490 Hogekynson, William, of Wyberton, husbandman 1
3958067 2009889 2009889 defendant Sawer Robert husbandman 603490 603490 Sawer, Robert, of Wyberton, husbandman 3
3970812 2014379 2014379 defendant Jettor Richard gent 603490 603490 Jettor, Richard, of Wyberton, gent 6
3972024 2014772 2014772 defendant Jettor Richard gent 603490 603490 Jettor, Richard, of Wyberton, gent 4
4232155 2106748 2106748 defendant Salmon John fisherman 603490 603490 Salmon, John, of Wyberton, fisherman 0
4499001 2200329 2200329 defendant Aynald Robert   603490 603490 Aynald, Robert, of Wyberton 0
4595413 2229821 2229821 plaintiff Redynges Alan   603490 603490 Redynges, Alan, of Wyberton 0
4604070 2232441 2232441 defendant Norlong Thomas, sen   603490 603490 Norlong, Thomas, sen, of Wyberton 0
4604071 2232441 2232441 defendant Norlong Roger   603490 603490 Norlong, Roger, of Wyberton 1
4675727 2258015 2258015 defendant Overey Roger husbandman 603490 603490 Overey, Roger, of Wyberton, husbandman 1
4685349 2261013 2261013 defendant Rogerson Roger   603490 603490 Rogerson, Roger, of Wyberton 0
4697808 2264812 2264812 defendant Bothumsale John husbandman 603490 603490 Bothumsale, John, of Wyberton, husbandman 0
4697810 2264813 2264813 defendant Salter Lambert   603490 603490 Salter, Lambert, of Wyberton 0
4697813 2264814 2264814 defendant Salter Lambert husbandman 603490 603490 Salter, Lambert, of Wyberton, husbandman 0
4700812 2265652 2265652 defendant Bate Robert fishmonger or fisherman 603490 603490 Bate, Robert, of Wyberton, fishmonger or fisherman 0
4700829 2265658 2265658 defendant Lidyngton John   603490 603490 Lidyngton, John, of Wyberton, parson 0
4710550 2268658 2268658 defendant Broun Thomas fowler 603490 603490 Broun, Thomas, of Wyberton, fowler 0
4721972 2272202 2272202 defendant Aynold John laborer 603490 603490 Aynold, John, of Wyberton, laborer 0
4731914 2275163 2275163 defendant Gayton William husbandman 603490 603490 Gayton, William, of Wyberton, husbandman 0
4735679 2276306 2276306 defendant Overay John husbandman 603490 603490 Overay, John, of Wyberton, husbandman 2
4735680 2276306 2276306 defendant Overay Richard husbandman 603490 603490 Overay, Richard, of Wyberton, husbandman 3
4735681 2276306 2276306 defendant Lyne John husbandman 603490 603490 Lyne, John, of Wyberton, husbandman 4
4735747 2276327 2276327 defendant Gayton William husbandman 603490 603490 Gayton, William, of Wyberton, husbandman 0
4736568 2276569 2276569 defendant Aynold John husbandman 603490 603490 Aynold, John, of Wyberton, husbandman 0
4736569 2276569 2276569 defendant Dikunson Richard husbandman 603490 603490 Dikunson, Richard, of Wyberton, husbandman 1
4736571 2276569 2276569 defendant Clerk John (legal representative) 603490 603490 Clerk, John, of Wyberton, executrix of 3
4736573 2276569 2276569 defendant Wilkynson John (legal representative) 603490 603490 Wilkynson, John, of Wyberton, executrix of 5
4774102 2287885 2287885 defendant Gyrke William laborer 603490 603490 Gyrke, William, of Wyberton, laborer 1
4788245 2292392 2292392 defendant Bothumsale John yeoman 603490 603490 Bothumsale, John, of Wyberton, yeoman 2
4788246 2292392 2292392 defendant Bothumsale Robert yeoman 603490 603490 Bothumsale, Robert, of Wyberton, yeoman 3
4799990 2296180 2296180 plaintiff Wace Alan   603490 603490 Wace, Alan, of Wyberton 0
4816095 2301125 2301125 defendant Robynson Roger husbandman 603490 603490 Robynson, Roger, of Wyberton, husbandman 5
4816096 2301125 2301125 defendant Mason Nicholas yeoman 603490 603490 Mason, Nicholas, of Wyberton, yeoman 6
4834711 2306859 2306859 defendant Norlonge Alexander fishmonger 603490 603490 Norlonge, Alexander, of Wyberton, fishmonger 0
4842639 2309233 2309233 plaintiff Lomson John   603490 603490 Lomson, John, of Wyberton 0
4856284 2313337 2313337 defendant Brounale William husbandman 603490 603490 Brounale, William, of Wyberton, husbandman 0
4863367 2315511 2315511 defendant Brounale William husbandman 603490 603490 Brounale, William, of Wyberton, husbandman 0
4863368 2315511 2315511 defendant Rote William husbandman 603490 603490 Rote, William, of Wyberton, husbandman 1
4873104 2318541 2318541 defendant Rote John chaplain 603490 603490 Rote, John, of Wyberton, chaplain 1
4900703 2326859 2326859 defendant Rote Peter husbandman 603490 603490 Rote, Peter, of Wyberton, husbandman 0
4900704 2326859 2326859 defendant Broune Thomas fisher 603490 603490 Broune, Thomas, of Wyberton, fisher 1
4904190 2327922 2327922 plaintiff Wace Alan   603490 603490 Wace, Alan, of Wyberton 0
4904191 2327922 2327922 plaintiff Salter Lambert   603490 603490 Salter, Lambert, of Wyberton 1
4950893 2342246 2342246 defendant Spyke William husbandman 603490 603490 Spyke, William, of Wyberton, husbandman 1
4962507 2345689 2345689 defendant Spencer John husbandman 603490 603490 Spencer, John, of Wyberton, husbandman 0
4962508 2345689 2345689 defendant Jakson Robert husbandman 603490 603490 Jakson, Robert, of Wyberton, husbandman 1
4962512 2345691 2345691 plaintiff Broun John   603490 603490 Broun, John, of Wyberton 0
4964592 2346316 2346316 defendant Gefferey Richard laborer 603490 603490 Gefferey, Richard, of Wyberton, laborer 1
4964593 2346316 2346316 defendant Rogerson John husbandman 603490 603490 Rogerson, John, of Wyberton, husbandman 2
4988965 2353639 2353639 defendant Brome Thomas fishmonger 603490 603490 Brome, Thomas, of Wyberton, fishmonger 1
4988967 2353639 2353639 defendant Arnold Peter husbandman 603490 603490 (Arnold, Peter, of Wyberton, husbandman 3
5000935 2357153 2357153 defendant Marram John   603490 603490 Marram, John, of Wyberton, servant 2
5002014 2357490 2357490 plaintiff Murre Lawrence   603490 603490 Murre, Lawrence, of Wyberton 0
5017991 2362145 2362145 defendant Brannake Richard husbandman 603490 603490 Brannake, Richard, of Wyberton, husbandman 1
5020663 2362937 2362937 defendant Claymond Roger husbandman 603490 603490 Claymond, Roger, of Wyberton, husbandman 1
5040297 2368695 2368695 defendant Jonson Henry husbandman 603490 603490 Jonson, Henry, of Wyberton, husbandman 0
5048863 2371294 2371294 defendant Bothumsell Robert (legal representative) 603490 603490 Bothumsell, Robert, of Wyberton, husbandman, executors of 0
5048864 2371294 2371294 defendant Bothumsell Alice widow 603490 603490 (Bothumsell, Alice, of Wyberton, widow 1
5048865 2371294 2371294 defendant Bothumsell John husbandman 603490 603490 Bothumsell, John, of Wyberton, husbandman 2
5048866 2371294 2371294 defendant Norlong George husbandman 603490 603490 Norlong, George, of Wyberton, husbandman 3
5048867 2371294 2371294 defendant Salter Thomas   603490 603490 Salter, Thomas, of Wyberton, administrators of 4
5049982 2371616 2371616 defendant Bothumsell Robert (legal representative) 603490 603490 Bothumsell, Robert, of Wyberton, husbandman, executors of 0
5049983 2371616 2371616 defendant Bothumsell Alice widow 603490 603490 (Bothumsell, Alice, of Wyberton, widow 1
5049984 2371616 2371616 defendant Bothumsell John husbandman 603490 603490 Bothumsell, John, of Wyberton, husbandman 2
5049985 2371616 2371616 defendant Norlong George husbandman 603490 603490 Norlong, George, of Wyberton, husbandman 3
5049986 2371616 2371616 defendant Salter Thomas   603490 603490 Salter, Thomas, of Wyberton, administrators of 4
5051162 2371963 2371963 plaintiff Wate Alan   603490 603490 Wate, Alan, of Wyberton 0
5051163 2371963 2371963 plaintiff Broun John   603490 603490 Broun, John, of Wyberton 1
5051164 2371963 2371963 defendant Redynges Roger husbandman 603490 603490 Redynges, Roger, of Wyberton, husbandman 0
5051165 2371963 2371963 defendant Rote Peter husbandman 603490 603490 Rote, Peter, of Wyberton, husbandman 1
5051167 2371964 2371964 plaintiff Wate Alan   603490 603490 Wate, Alan, of Wyberton 0
5051169 2371964 2371964 plaintiff Brounde John   603490 603490 Brounde, John, of Wyberton 2
5051170 2371964 2371964 defendant Rote Peter husbandman 603490 603490 Rote, Peter, of Wyberton, husbandman 0
5054442 2372901 2372901 defendant Wace Alan husbandman 603490 603490 Wace, Alan, of Wyberton, husbandman 5
5057326 2373757 2373757 defendant Root Roger osterman or oysterman 603490 603490 Root, Roger, of Wyberton, osterman or oysterman 0
5057713 2373875 2373875 defendant Poune or Ponne John husbandman 603490 603490 Poune or Ponne, John, of Wyberton, husbandman 0
5057714 2373875 2373875 defendant Drunale William husbandman 603490 603490 Drunale, William, of Wyberton, husbandman 1
5075913 2379289 2379289 defendant Rote Margaret widow 603490 603490 Rote, Margaret, of Wyberton, widow 0
5080485 2380654 2380654 defendant Bothusell John husbandman 603490 603490 Bothusell, John, of Wyberton, husbandman 0
5093864 2384607 2384607 defendant Broun Thomas husbandman 603490 603490 Broun, Thomas, of Wyberton, husbandman 0
5103631 2387488 2387488 defendant Heyward John fisher 603490 603490 Heyward, John, of Wyberton, fisher 0
5103634 2387488 2387488 defendant Aynold Alan husbandman 603490 603490 Aynold, Alan, of Wyberton, husbandman 3
5105405 2388023 2388023 defendant Lek John chaplain 603490 603490 Lek, John, of Wyberton, chaplain 2
5109510 2389210 2389210 defendant Claymond Roger husbandman 603490 603490 Claymond, Roger, of Wyberton, husbandman 2
5119813 2392232 2392232 defendant Dykonson Richard husbandman 603490 603490 Dykonson, Richard, of Wyberton, husbandman 0
5119814 2392232 2392232 defendant Bromale Richard husbandman 603490 603490 Bromale, Richard, of Wyberton, husbandman 1
5119815 2392232 2392232 defendant Dey William husbandman 603490 603490 Dey, William, of Wyberton, husbandman 2
5123046 2393174 2393174 defendant Bothumsell John yeoman 603490 603490 Bothumsell, John, of Wyberton, yeoman 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);