names

98 rows where place_id = 598468

✎ 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
3602524 1868449 1868449 defendant Tendale William   598468 598468 Tendale, William, of Hokewold, knight 0
3632632 1905024 1905024 defendant Bull William carpenter 598468 598468 Bull, William, of Hokewold, carpenter 2
3637873 1906661 1906661 defendant Smyth Edmund husbandman 598468 598468 Smyth, Edmund, of Hokewold, husbandman 5
3655293 1911915 1911915 defendant Tendale John esq 598468 598468 Tendale, John, of Hokewold, esq 0
3655294 1911915 1911915 defendant Mathewe John yeoman 598468 598468 Mathewe, John, of Hokewold, yeoman 1
3655295 1911915 1911915 defendant Hoke Hugh husbandman 598468 598468 Hoke, Hugh, of Hokewold, husbandman 2
3655296 1911915 1911915 defendant Bacon John yeoman 598468 598468 Bacon, John, of Hokewold, yeoman 3
3655297 1911915 1911915 defendant Smyth Edmund   598468 598468 Smyth, Edmund, of Hokewold, shepherd 4
3655299 1911916 1911916 defendant Tendale John esq 598468 598468 Tendale, John, of Hokewold, esq 0
3655300 1911916 1911916 defendant Mathewe Philip yeoman 598468 598468 Mathewe, Philip, of Hokewold, yeoman 1
3655873 1912091 1912091 defendant Hoke Hugh husbandman 598468 598468 Hoke, Hugh, of Hokewold, husbandman 1
3655874 1912091 1912091 defendant Bacon John husbandman 598468 598468 Bacon, John, of Hokewold, husbandman 2
3655875 1912091 1912091 defendant Smyth Edmund   598468 598468 Smyth, Edmund, of Hokewold, shepherd 3
3655876 1912091 1912091 defendant Tendale John esq 598468 598468 Tendale, John, of Hokewold, esq 4
3658052 1912773 1912773 defendant Baton John yeoman 598468 598468 Baton, John, of Hokewold, yeoman 0
3658053 1912773 1912773 defendant Mathewe Philip yeoman 598468 598468 Mathewe, Philip, of Hokewold, yeoman 1
3658054 1912773 1912773 defendant Hoke Hugh husbandman 598468 598468 Hoke, Hugh, of Hokewold, husbandman 2
3658056 1912774 1912774 defendant Mathewe Philip yeoman 598468 598468 Mathewe, Philip, of Hokewold, yeoman 0
3660983 1913707 1913707 defendant Shynfeld John laborer 598468 598468 Shynfeld, John, of Hokewold, laborer 0
3660985 1913708 1913708 defendant Tendale John esq 598468 598468 Tendale, John, of Hokewold, esq 0
3661006 1913716 1913716 defendant Mathewe Philip yeoman 598468 598468 Mathewe, Philip, of Hokewold, yeoman 0
3661010 1913718 1913718 defendant Tendale John esq 598468 598468 Tendale, John, of Hokewold, esq 0
3661011 1913718 1913718 defendant Smyth Edmund   598468 598468 Smyth, Edmund, of Hokewold, shepherd 1
3662390 1914150 1914150 defendant Tendale John esq 598468 598468 Tendale, John, of Hokewold, esq 0
3662708 1914254 1914254 defendant Mathew Philip yeoman 598468 598468 Mathew, Philip, of Hokewold, yeoman 1
3663298 1914446 1914446 defendant Mathewe Philip yeoman 598468 598468 Mathewe, Philip, of Hokewold, yeoman 0
3666017 1915308 1915308 plaintiff Tendale John esq 598468 598468 Tendale, John, of Hokewold, esq 0
3676446 1918678 1918678 defendant Holyngeshed Arthur husbandman 598468 598468 Holyngeshed, Arthur, of Hokewold, husbandman 0
3700222 1926304 1926304 defendant Tendale John esq 598468 598468 Tendale, John, of Hokewold, esq 0
3700223 1926304 1926304 defendant Holwey Humphrey gent 598468 598468 Holwey, Humphrey, of Hokewold, gent 1
3700224 1926304 1926304 defendant Mathewe Philip yeoman 598468 598468 Mathewe, Philip, of Hokewold, yeoman 2
3729225 1935391 1935391 defendant Tendale John esq 598468 598468 Tendale, John, of Hokewold, esq 0
3729226 1935391 1935391 defendant Holwey Humphrey gent 598468 598468 Holwey, Humphrey, of Hokewold, gent 1
3729227 1935391 1935391 defendant Mathew Philip yeoman 598468 598468 Mathew, Philip, of Hokewold, yeoman 2
3819263 1963915 1963915 defendant Tendale John esq 598468 598468 Tendale, John, of Hokewold, esq 0
3819264 1963915 1963915 defendant Tendale Thomas gent 598468 598468 Tendale, Thomas, of Hokewold, gent 1
3819265 1963915 1963915 defendant Howghton Thomas chaplain 598468 598468 Howghton, Thomas, of Hokewold, chaplain 2
4435089 2175735 2175735 defendant Heroun John   598468 598468 Heroun, John, of Hokewold 0
4458631 2187747 2187747 defendant atte Howe William   598468 598468 atte Howe, William, of Hokewold 0
4547054 2215014 2215014 plaintiff Bungeye John   598468 598468 Bungeye, John, of Hokewold, parson 0
4576702 2224223 2224223 plaintiff Bungeye John   598468 598468 Bungeye, John, of Hokewold, parson 0
4576704 2224223 2224223 defendant Treys Reyner   598468 598468 Treys, Reyner, of Hokewold 1
4585180 2226787 2226787 defendant Wynche John   598468 598468 Wynche, John, of Hokewold 1
4656374 2247886 2247886 defendant Sumpter John weaver 598468 598468 Sumpter, John, of Hokewold, weaver 0
4656375 2247886 2247886 defendant Troys William butcher 598468 598468 Troys, William, of Hokewold, butcher 1
4738102 2277021 2277021 defendant Norwold Robert yeoman 598468 598468 Norwold, Robert, of Hokewold, yeoman 0
4738104 2277021 2277021 defendant Oldman William chaplain 598468 598468 Oldman, William, of Hokewold, chaplain 2
4738108 2277022 2277022 defendant Norwold Robert yeoman 598468 598468 Norwold, Robert, of Hokewold, yeoman 0
4738110 2277022 2277022 defendant Oldman William chaplain 598468 598468 Oldman, William, of Hokewold, chaplain 2
4758652 2283081 2283081 defendant Grene Thomas laborer 598468 598468 Grene, Thomas, of Hokewold, laborer 19
4758656 2283081 2283081 defendant Ciffe William tailor 598468 598468 together with Ciffe, William, of Hokewold, tailor 23
4758673 2283082 2283082 defendant Ciffe William tailor 598468 598468 Ciffe, William, of Hokewold, tailor 0
4758699 2283083 2283083 defendant Sumpter John laborer 598468 598468 Sumpter, John, of Hokewold, laborer 9
4758700 2283083 2283083 defendant Sumpter Reginald laborer 598468 598468 Sumpter, Reginald, of Hokewold, laborer 10
4758707 2283083 2283083 defendant Fyncen Richard baker 598468 598468 Fyncen, Richard, of Hokewold, baker 17
4758711 2283083 2283083 defendant Grene Thomas laborer 598468 598468 Grene, Thomas, of Hokewold, laborer 21
4767280 2285753 2285753 defendant Narburgh John husbandman 598468 598468 Narburgh, John, of Hokewold, husbandman 2
4767281 2285753 2285753 defendant Wynche John husbandman 598468 598468 Wynche, John, of Hokewold, husbandman 3
4885095 2322231 2322231 defendant Sponer Richard chaplain 598468 598468 Sponer, Richard, of Hokewold, chaplain 0
4891662 2324131 2324131 defendant Sponer Richard chaplain 598468 598468 Sponer, Richard, of Hokewold, chaplain 0
4928074 2335214 2335214 defendant Stokes John husbandman 598468 598468 Stokes, John, of Hokewold, husbandman 1
4929229 2335558 2335558 defendant Dekeman Richard husbandman 598468 598468 Dekeman, Richard, of Hokewold, husbandman 1
4954679 2343352 2343352 defendant Dykeman Richard husbandman 598468 598468 Dykeman, Richard, of Hokewold, husbandman 1
5097746 2385764 2385764 defendant Steward Thomas yeoman 598468 598468 Steward, Thomas, of Hokewold, yeoman 0
5100823 2386657 2386657 plaintiff Aleyn John (legal representative) 598468 598468 Aleyn, John, of Hokewold, or of Castel Acre, executors of 0
5122119 2392890 2392890 defendant Aleyn John (legal representative) 598468 598468 Aleyn, John, of Hokewold, gent, executors of 0
5123860 2393436 2393436 defendant Aleyn or Aldyn John (legal representative) 598468 598468 Aleyn or Aldyn, John, of Hokewold, executors of 0
5123862 2393436 2393436 defendant Styward Thomas   598468 598468 Styward, Thomas, of Hokewold, court holder 2
5124474 2393620 2393620 defendant Styward Thomas yeoman 598468 598468 Styward, Thomas, of Hokewold, yeoman 0
5139033 2397909 2397909 defendant Styward Thomas husbandman 598468 598468 Styward, Thomas, of Hokewold, husbandman 0
5159425 2403874 2403874 defendant Styward Thomas yeoman 598468 598468 Styward, Thomas, of Hokewold, yeoman 0
5159893 2403990 2403990 defendant Styward Thomas yeoman 598468 598468 Styward, Thomas, of Hokewold, yeoman 0
5278869 2438930 2438930 defendant Carle Ralph husbandman 598468 598468 Carle, Ralph, of Hokewold, husbandman 0
5291548 2442530 2442530 defendant Aleyn John (legal representative) 598468 598468 Aleyn, John, of Hokewold, executors of 3
5296509 2443969 2443969 defendant Walpoll William husbandman 598468 598468 Walpoll, William, of Hokewold, husbandman 1
5296510 2443969 2443969 defendant Botore William husbandman 598468 598468 Botore, William, of Hokewold, husbandman 2
5296511 2443969 2443969 defendant Bray John waterman 598468 598468 Bray, John, of Hokewold, waterman 3
5296512 2443969 2443969 defendant Bray Robert waterman 598468 598468 Bray, Robert, of Hokewold, waterman 4
5296514 2443969 2443969 defendant Bray Reginald laborer 598468 598468 Bray, Reginald, of Hokewold, laborer 6
5315709 2449763 2449763 defendant Tendale William esq 598468 598468 Tendale, William, of Hokewold, esq 0
5330693 2454257 2454257 defendant Cleye Henry husbandman 598468 598468 Cleye, Henry, of Hokewold, husbandman 2
5335897 2455804 2455804 defendant Bulle Peter yeoman 598468 598468 Bulle, Peter, of Hokewold, yeoman 0
5337309 2456228 2456228 defendant Carell Ralph (legal representative) 598468 598468 Carell, Ralph, of Hokewold, gent, executrix of 4
5337310 2456228 2456228 defendant Carell Alice widow 598468 598468 Carell, Alice, of Hokewold, widow 5
5341942 2457670 2457670 defendant Mondes William yeoman 598468 598468 Mondes, William, of Hokewold, yeoman 0
5341943 2457670 2457670 defendant Felton Thomas yeoman 598468 598468 Felton, Thomas, of Hokewold, yeoman 1
5341944 2457670 2457670 defendant Botour William yeoman 598468 598468 Botour, William, of Hokewold, yeoman 2
5412280 2478621 2478621 defendant Cook John clerk 598468 598468 Cook, John, of Hokewold, clerk 0
5412282 2478621 2478621 defendant Botour William husbandman 598468 598468 Botour, William, of Hokewold, husbandman 2
5412283 2478621 2478621 defendant Bole Robert husbandman 598468 598468 Bole, Robert, of Hokewold, husbandman 3
5412285 2478621 2478621 defendant Tebald John laborer 598468 598468 Tebald, John, of Hokewold, laborer 5
5426920 2482998 2482998 defendant Cook John clerk 598468 598468 Cook, John, of Hokewold, clerk 0
5426922 2482998 2482998 defendant Botour William husbandman 598468 598468 Botour, William, of Hokewold, husbandman 2
5426923 2482998 2482998 defendant Bole Robert husbandman 598468 598468 Bole, Robert, of Hokewold, husbandman 3
5426925 2482998 2482998 defendant Tebald John laborer 598468 598468 Tebald, John, of Hokewold, laborer 5
5508907 2507641 2507641 plaintiff Felton Thomas   598468 598468 Felton, Thomas, of Hokewold 0
5525005 2512413 2512413 defendant Boole Peter yeoman 598468 598468 Boole, Peter, of Hokewold, yeoman 0
5611291 2547261 2547261 defendant Cook William   598468 598468 Cook, William, of Hokewold 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);