names

66 rows where place_id = 594193

✎ 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
3615020 1872343 1872343 defendant Honyter Everard clerk 594193 594193 Honyter, Everard, of Walsoken, Norf, clerk 1
3856694 1975722 1975722 defendant Nicolson William husbandman 594193 594193 Nicolson, William, of Walsoken, Norf, husbandman 1
3884788 1985188 1985188 defendant Narbery Richard husbandman 594193 594193 Narbery, Richard, of Walsoken, Norf, husbandman 1
3885304 1985338 1985338 defendant Prentysse Thomas gent 594193 594193 Prentysse, Thomas, of Walsoken, Norf, gent 0
3893055 1987925 1987925 defendant Angell Katherine widow 594193 594193 Angell, Katherine, of Walsoken, Norf, widow 1
3927115 1999406 1999406 defendant Thorpe Nicholas yeoman 594193 594193 Thorpe, Nicholas, of Walsoken, Norf, yeoman 0
3989245 2020895 2020895 plaintiff Balam Robert esq 594193 594193 Balam, Robert, of Walsoken, Norf, esq 0
4029756 2035281 2035281 defendant Balam Robert (legal representative) 594193 594193 Balam, Robert, of Walsoken, Norf, esq, administratrix of 0
4033631 2036677 2036677 defendant Hunston Richard gent 594193 594193 Hunston, Richard, of Walsoken, Norf, gent 2
4054790 2044102 2044102 defendant Eden Charles gent 594193 594193 Eden, Charles, of Walsoken, Norf, gent 0
4054793 2044103 2044103 defendant Eden Charles gent 594193 594193 Eden, Charles, of Walsoken, Norf, gent 0
4061764 2046608 2046608 defendant Grome John husbandman 594193 594193 Grome, John, of Walsoken, Norf, husbandman 1
4090158 2056766 2056766 defendant Harvye Thomas yeoman 594193 594193 Harvye, Thomas, of Walsoken, Norf, yeoman 1
4092928 2057781 2057781 defendant Harvye Thomas yeoman 594193 594193 Harvye, Thomas, of Walsoken, Norf, yeoman 0
4092936 2057783 2057783 defendant Wyllyngam Thomas yeoman 594193 594193 Wyllyngam, Thomas, of Walsoken, Norf, yeoman 0
4096002 2058900 2058900 defendant Estmond Thomas yeoman 594193 594193 Estmond, Thomas, of Walsoken, Norf, yeoman 1
4108827 2063409 2063409 defendant Gardyner Francis gent 594193 594193 Gardyner, Francis, of Walsoken, Norf, gent 0
4150408 2078272 2078272 defendant Hunston Richard gent 594193 594193 Hunston, Richard, of Walsoken, Norf, gent 0
4162786 2082541 2082541 defendant Hunston Richard gent 594193 594193 Hunston, Richard, of Walsoken, Norf, gent 2
4173893 2086325 2086325 defendant Palmer Thomas husbandman 594193 594193 Palmer, Thomas, of Walsoken, Norf, husbandman 0
4176833 2087366 2087366 defendant Hunston Henry esq 594193 594193 Hunston, Henry, of Walsoken, Norf, esq 0
4176839 2087367 2087367 defendant Hunston Henry esq 594193 594193 Hunston, Henry, of Walsoken, Norf, esq 2
4265935 2118244 2118244 defendant Clitheroe Robert yeoman 594193 594193 Clitheroe, Robert, of Walsoken, Norf, yeoman 1
4303827 2131469 2131469 defendant Balam Charles (legal representative) 594193 594193 Balam, Charles, of Walsoken, Norf, gent, executors of 0
4323984 2138431 2138431 defendant Vyncent William (legal representative) 594193 594193 Vyncent, William, of Walsoken, Norf, husbandman, executors of 2
4340205 2143836 2143836 defendant Richemond Thomas gent 594193 594193 Richemond, Thomas, of Walsoken, Norf, gent 0
4341359 2144255 2144255 defendant Maye William yeoman 594193 594193 Maye, William, of Walsoken, Norf, yeoman 0
4352708 2148178 2148178 defendant Ritchman Thomas gent 594193 594193 Ritchman, Thomas, of Walsoken, Norf, gent 1
4667720 2255616 2255616 defendant Dodde Geoffrey husbandman 594193 594193 Dodde, Geoffrey, of Walsoken, Norf, husbandman 0
4680253 2259436 2259436 defendant Grey Thomas chaplain 594193 594193 Grey, Thomas, of Walsoken, Norf, chaplain 0
4708399 2267992 2267992 defendant Odan William husbandman 594193 594193 Odan, William, of Walsoken, Norf, husbandman 5
4718195 2271029 2271029 defendant Elger Isabel widow 594193 594193 Elger, Isabel, of Walsoken, Norf, widow 1
4730404 2274706 2274706 defendant Bunche Evorard chapman 594193 594193 Bunche, Evorard, of Walsoken, Norf, chapman 4
4760097 2283501 2283501 defendant Thurkell John, sen husbandman 594193 594193 Thurkell, John, sen, of Walsoken, Norf, husbandman 3
4799103 2295895 2295895 defendant Lucas James brewer 594193 594193 Lucas, James, of Walsoken, Norf, brewer 0
4915639 2331392 2331392 defendant Denyell John brewer 594193 594193 Denyell, John, of Walsoken, Norf, brewer 1
4920712 2332994 2332994 defendant Danyell John brewer 594193 594193 Danyell, John, of Walsoken, Norf, brewer 0
4922451 2333431 2333431 defendant Hungate Thomas husbandman 594193 594193 Hungate, Thomas, of Walsoken, Norf, husbandman 2
4955486 2343603 2343603 defendant Cewall Robert husbandman 594193 594193 Cewall, Robert, of Walsoken, Norf, husbandman 0
4967627 2347258 2347258 defendant Palgrome John yeoman 594193 594193 Palgrome, John, of Walsoken, Norf, yeoman 3
4998652 2356480 2356480 defendant Palmer Walter husbandman 594193 594193 Palmer, Walter, of Walsoken, Norf, husbandman 4
5022008 2363329 2363329 defendant Kyrton Henry husbandman 594193 594193 Kyrton, Henry, of Walsoken, Norf, husbandman 0
5105083 2387921 2387921 defendant Dabbe Robert yeoman 594193 594193 Dabbe, Robert, of Walsoken, Norf, yeoman 2
5117758 2391628 2391628 defendant Danyell John husbandman 594193 594193 Danyell, John, of Walsoken, Norf, husbandman 2
5117762 2391629 2391629 defendant Danyell John husbandman 594193 594193 Danyell, John, of Walsoken, Norf, husbandman 2
5199569 2415619 2415619 defendant Brygge Robert husbandman 594193 594193 Brygge, Robert, of Walsoken, Norf, husbandman 0
5199573 2415620 2415620 defendant Bygge Robert husbandman 594193 594193 Bygge, Robert, of Walsoken, Norf, husbandman 0
5199577 2415621 2415621 defendant Bygge Robert husbandman 594193 594193 Bygge, Robert, of Walsoken, Norf, husbandman 0
5211147 2418987 2418987 defendant Bygge Robert husbandman 594193 594193 Bygge, Robert, of Walsoken, Norf, husbandman Mey, John, of Walsoken, husbandman 0
5224459 2422822 2422822 defendant Danyell John husbandman 594193 594193 Danyell, John, of Walsoken, Norf, husbandman 0
5280844 2439469 2439469 defendant Bygge John husbandman 594193 594193 Bygge, John, of Walsoken, Norf, husbandman 0
5308954 2447724 2447724 defendant Pamplyn Everardus husbandman 594193 594193 Pamplyn, Everardus, of Walsoken, Norf, husbandman 0
5326414 2452984 2452984 defendant Stevenson Lawrence husbandman 594193 594193 Stevenson, Lawrence, of Walsoken, Norf, husbandman 0
5326416 2452985 2452985 defendant Stevenson Lawrence husbandman 594193 594193 Stevenson, Lawrence, of Walsoken, Norf, husbandman 0
5371005 2466520 2466520 defendant Danyell Thomas gent 594193 594193 Danyell, Thomas, of Walsoken, Norf, gent 0
5416579 2479873 2479873 defendant Bunche Robert gent 594193 594193 Bunche, Robert, of Walsoken, Norf, gent 0
5433505 2484982 2484982 defendant Bunche Robert gent 594193 594193 Bunche, Robert, of Walsoken, Norf, gent 0
5447715 2489192 2489192 defendant Danyell Thomas   594193 594193 Danyell, Thomas, of Walsoken, Norf 0
5460102 2492953 2492953 defendant Danyell Thomas gent 594193 594193 Danyell, Thomas, of Walsoken, Norf, gent 0
5471744 2496500 2496500 defendant Danyell Thomas gent 594193 594193 Danyell, Thomas, of Walsoken, Norf, gent 0
5471747 2496501 2496501 defendant Danyell Thomas gent 594193 594193 Danyell, Thomas, of Walsoken, Norf, gent 0
5483143 2499899 2499899 defendant Danyell Thomas gent 594193 594193 Danyell, Thomas, of Walsoken, Norf, gent 0
5520887 2511353 2511353 defendant Couper Thomas yeoman 594193 594193 Couper, Thomas, of Walsoken, Norf, yeoman 0
5555170 2521515 2521515 defendant May Thomas yeoman 594193 594193 May, Thomas, of Walsoken, Norf, yeoman 0
5555173 2521516 2521516 defendant May Thomas yeoman 594193 594193 May, Thomas, of Walsoken, Norf, yeoman 0
5624144 2551497 2551497 defendant Crane John weaver 594193 594193 Crane, John, of Walsoken, Norf, weaver 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);