names

141 rows where place_id = 586925

✎ 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
3590001 1864513 1864513 defendant Game Thomas husbandman 586925 586925 Game, Thomas, of Therfeld, husbandman 0
3590003 1864513 1864513 defendant Chapman John, junior husbandman 586925 586925 Chapman, John, junior, of Therfeld, husbandman 2
3596494 1866534 1866534 defendant Carter William husbandman 586925 586925 Carter, William, of Therfeld, husbandman 1
3600220 1867715 1867715 defendant Reynold Thomas husbandman 586925 586925 Reynold, Thomas, of Therfeld, husbandman 2
3609384 1870595 1870595 defendant Preste William smith 586925 586925 Preste, William, of Therfeld, smith 1
3609385 1870595 1870595 defendant Ampton William husbandman 586925 586925 Ampton, William, of Therfeld, husbandman 2
3626820 1903238 1903238 defendant Page William maltman 586925 586925 Page, William, of Therfeld, maltman 3
3641434 1907777 1907777 defendant Berners John gent 586925 586925 Berners, John, of Therfeld, gent 0
3645584 1909013 1909013 defendant Wode Mary widow 586925 586925 Wode, Mary, of Therfeld, widow 1
3645585 1909013 1909013 defendant Glover John husbandman 586925 586925 Glover, John, of Therfeld, husbandman 2
3645586 1909013 1909013 defendant Wode John husbandman 586925 586925 Wode, John, of Therfeld, husbandman 3
3645589 1909014 1909014 defendant Wode Marion widow 586925 586925 Wode, Marion, of Therfeld, widow 1
3645590 1909014 1909014 defendant Glover John husbandman 586925 586925 Glover, John, of Therfeld, husbandman 2
3645591 1909014 1909014 defendant Wode John husbandman 586925 586925 Wode, John, of Therfeld, husbandman 3
3653620 1911396 1911396 defendant Turner William husbandman 586925 586925 Turner, William, of Therfeld, husbandman 2
3656037 1912141 1912141 defendant Fordam John yeoman 586925 586925 Fordam, John, of Therfeld, yeoman 1
3659849 1913335 1913335 defendant Fordam John husbandman 586925 586925 Fordam, John, of Therfeld, husbandman 1
3662917 1914314 1914314 defendant Wesyngham William husbandman 586925 586925 Wesyngham, William, of Therfeld, husbandman 3
3671190 1916961 1916961 defendant Mathewe Thomas yeoman 586925 586925 Mathewe, Thomas, of Therfeld, yeoman 0
3671416 1917038 1917038 defendant Stoweton John husbandman 586925 586925 Stoweton, John, of Therfeld, husbandman 2
3684241 1921203 1921203 defendant Mathewe Thomas husbandman 586925 586925 Mathewe, Thomas, of Therfeld, husbandman 2
3691146 1923393 1923393 defendant Stoughton John husbandman 586925 586925 Stoughton, John, of Therfeld, husbandman 0
3702061 1926900 1926900 defendant Wode William yeoman 586925 586925 Wode, William, of Therfeld, yeoman 0
3702062 1926900 1926900 defendant Ryssley John husbandman 586925 586925 Ryssley, John, of Therfeld, husbandman 1
3729474 1935466 1935466 defendant Rysley alias Stowton John husbandman 586925 586925 Rysley alias Stowton, John, of Therfeld, husbandman 2
3729475 1935466 1935466 defendant Fordham William husbandman 586925 586925 Fordham, William, of Therfeld, husbandman 3
3735106 1937221 1937221 defendant Stokton John husbandman 586925 586925 Stokton, John, of Therfeld, husbandman 0
3744546 1940196 1940196 plaintiff Barley Peter husbandman 586925 586925 Barley, Peter, of Therfeld, husbandman 0
3744583 1940203 1940203 defendant Pynnok John laborer 586925 586925 Pynnok, John, of Therfeld, laborer 0
3744584 1940203 1940203 defendant Stokton John husbandman 586925 586925 Stokton, John, of Therfeld, husbandman 1
3744585 1940203 1940203 defendant Coll Simon husbandman 586925 586925 Coll, Simon, of Therfeld, husbandman 2
3744586 1940203 1940203 defendant Sell Thomas husbandman 586925 586925 Sell, Thomas, of Therfeld, husbandman 3
3756941 1944148 1944148 defendant Game William, junior husbandman 586925 586925 Game, William, junior, of Therfeld, husbandman 0
3756945 1944149 1944149 defendant Pynnok John husbandman 586925 586925 Pynnok, John, of Therfeld, husbandman 2
3756947 1944150 1944150 defendant Rysle alias Stoughton John husbandman 586925 586925 Rysle alias Stoughton, John, of Therfeld, husbandman 0
3759104 1944834 1944834 defendant Barlee Peter husbandman 586925 586925 Barlee, Peter, of Therfeld, husbandman 0
3759105 1944834 1944834 defendant Pryste Edward husbandman 586925 586925 Pryste, Edward, of Therfeld, husbandman 1
3773400 1949389 1949389 defendant Barley Peter husbandman 586925 586925 Barley, Peter, of Therfeld, husbandman 0
3774875 1949872 1949872 defendant Gayler John husbandman 586925 586925 Gayler, John, of Therfeld, husbandman 0
3774878 1949872 1949872 defendant Waren alias Woode William husbandman 586925 586925 Waren alias Woode, William, of Therfeld, husbandman 3
3779994 1951467 1951467 defendant Stoughton alias Ryssley William husbandman 586925 586925 Stoughton alias Ryssley, William, of Therfeld, husbandman 0
3781358 1951912 1951912 defendant Game William husbandman 586925 586925 Game, William, of Therfeld, husbandman 0
3786686 1953630 1953630 defendant Woode alias Waren William husbandman 586925 586925 Woode alias Waren, William, of Therfeld, husbandman 0
3789808 1954643 1954643 plaintiff Twytt William gent 586925 586925 Twytt, William, of Therfeld, gent 0
3792557 1955530 1955530 defendant Gayler John husbandman 586925 586925 Gayler, John, of Therfeld, husbandman 0
3801862 1958478 1958478 defendant Stoughton John husbandman 586925 586925 Stoughton, John, of Therfeld, husbandman 3
3805898 1959785 1959785 plaintiff Twytt alias Swyth William gent 586925 586925 Twytt alias Swyth, William, of Therfeld, gent 0
3809141 1960742 1960742 defendant Stoughton John husbandman 586925 586925 Stoughton, John, of Therfeld, husbandman 2
3825039 1965705 1965705 defendant Barners John gent 586925 586925 Barners, John, of Therfeld, gent 0
3856313 1975593 1975593 defendant Wood John husbandman 586925 586925 Wood, John, of Therfeld, husbandman 1
3911769 1994262 1994262 defendant Flemyng Thomas husbandman 586925 586925 Flemyng, Thomas, of Therfeld, husbandman 1
4422393 2171869 2171869 defendant Colyn John   586925 586925 Colyn, John, of Therfeld 0
4458515 2187712 2187712 plaintiff Ravendale Michael   586925 586925 Ravendale, Michael, of Therfeld, parson, on his own account 0
4458517 2187713 2187713 plaintiff Ravendale Michael   586925 586925 Ravendale, Michael, of Therfeld, parson, on his own account 0
4458519 2187714 2187714 plaintiff Ravendale Michale   586925 586925 Ravendale, Michale, of Therfeld, parson, on his own account 0
4499702 2200542 2200542 defendant Elyngton John   586925 586925 (Elyngton, John, of Therfeld, parson 1
4499709 2200543 2200543 defendant Elyngton John   586925 586925 (Elyngton, John, of Therfeld, parson 1
4554501 2217342 2217342 plaintiff Gurney John   586925 586925 Gurney, John, of Therfeld 0
4554504 2217343 2217343 plaintiff Gurney John   586925 586925 Gurney, John, of Therfeld 0
4554506 2217344 2217344 plaintiff Gurney John   586925 586925 Gurney, John, of Therfeld 0
4554518 2217345 2217345 plaintiff Gurney John   586925 586925 Gurney, John, of Therfeld 0
4719125 2271331 2271331 defendant Preest Robert husbandman 586925 586925 Preest, Robert, of Therfeld, husbandman 0
4719126 2271331 2271331 defendant Sewale Robert husbandman 586925 586925 Sewale, Robert, of Therfeld, husbandman 1
4719127 2271331 2271331 defendant Colyn John husbandman 586925 586925 Colyn, John, of Therfeld, husbandman 2
4719128 2271331 2271331 defendant Jankyn John husbandman 586925 586925 Jankyn, John, of Therfeld, husbandman 3
4719129 2271331 2271331 defendant Wenhom John husbandman 586925 586925 Wenhom, John, of Therfeld, husbandman 4
4848829 2311098 2311098 defendant Game William husbandman 586925 586925 Game, William, of Therfeld, husbandman 0
4848830 2311098 2311098 defendant Game Richard husbandman 586925 586925 Game, Richard, of Therfeld, husbandman 1
4848831 2311098 2311098 defendant Lewe William laborer 586925 586925 Lewe, William, of Therfeld, laborer 2
4848832 2311098 2311098 defendant Curteys John husbandman 586925 586925 Curteys, John, of Therfeld, husbandman 3
4893513 2324671 2324671 defendant Smyth Richard tailor or draper 586925 586925 Smyth, Richard, of Therfeld, tailor or draper 0
4944503 2340259 2340259 defendant Wylmer William yeoman 586925 586925 Wylmer, William, of Therfeld, yeoman 1
4968199 2347440 2347440 defendant Taylour John maltman 586925 586925 Taylour, John, of Therfeld, maltman 0
4968202 2347440 2347440 defendant Prest William smith 586925 586925 Prest, William, of Therfeld, smith 3
4968203 2347440 2347440 defendant Waryngor William husbandman 586925 586925 Waryngor, William, of Therfeld, husbandman 4
4982686 2351735 2351735 defendant Yongion John maltman 586925 586925 Yongion, John, of Therfeld, maltman 0
5035196 2367157 2367157 defendant Lewes John husbandman 586925 586925 Lewes, John, of Therfeld, husbandman 0
5047160 2370772 2370772 defendant Gurney William husbandman 586925 586925 Gurney, William, of Therfeld, husbandman 1
5095598 2385137 2385137 defendant Angtyle Stephen husbandman 586925 586925 Angtyle, Stephen, of Therfeld, husbandman 0
5095599 2385137 2385137 defendant Angtyle William laborer 586925 586925 Angtyle, William, of Therfeld, laborer 1
5095600 2385137 2385137 defendant Angtyle Thomas laborer 586925 586925 Angtyle, Thomas, of Therfeld, laborer 2
5124826 2393735 2393735 plaintiff Breton John   586925 586925 (Breton, John, of Therfeld, parson 1
5143391 2399207 2399207 plaintiff Breton John   586925 586925 (Breton, John, of Therfeld, parson 1
5143397 2399208 2399208 plaintiff Breton John   586925 586925 (Breton, John, of Therfeld, parson 1
5143406 2399209 2399209 plaintiff Breton John   586925 586925 (Breton, John, of Therfeld, parson of the parish church 1
5152424 2401840 2401840 defendant Waryn William husbandman 586925 586925 Waryn, William, of Therfeld, husbandman 1
5164656 2405398 2405398 plaintiff Breton John   586925 586925 (Breton, John, of Therfeld, parson 1
5170206 2407014 2407014 defendant Waryn William husbandman 586925 586925 Waryn, William, of Therfeld, husbandman 1
5178016 2409277 2409277 plaintiff Breton John   586925 586925 (Breton, John, of Therfeld, parson 1
5178022 2409278 2409278 plaintiff Breton John   586925 586925 (Breton, John, of Therfeld, parson 1
5178031 2409279 2409279 plaintiff Breton John   586925 586925 (Breton, John, of Therfeld, parson 1
5178040 2409280 2409280 plaintiff Breton John   586925 586925 (Breton, John, of Therfeld, parson 1
5187686 2412116 2412116 defendant Waryn William husbandman 586925 586925 Waryn, William, of Therfeld, husbandman 1
5201217 2416115 2416115 plaintiff Breton John   586925 586925 (Breton, John, of Therfeld, domine & parson 1
5201226 2416116 2416116 plaintiff Breton John   586925 586925 (Breton, John, of Therfeld, parson 1
5201235 2416117 2416117 plaintiff Breton John   586925 586925 (Breton, John, of Therfeld, parson 1
5217127 2420748 2420748 defendant Boteler John husbandman 586925 586925 Boteler, John, of Therfeld, husbandman 4
5248285 2429631 2429631 defendant Preest William smith 586925 586925 Preest, William, of Therfeld, smith 0
5284406 2440456 2440456 defendant Game Thomas husbandman 586925 586925 Game, Thomas, of Therfeld, husbandman 2
5284412 2440457 2440457 defendant Game Thomas husbandman 586925 586925 Game, Thomas, of Therfeld, husbandman 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);