names

97 rows where place_id = 611062

✎ 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
3686598 1921960 1921960 defendant Sturgeys John gent 611062 611062 Sturgeys, John, of Craneworth, gent 0
3701678 1926767 1926767 defendant Sturgeys John gent 611062 611062 Sturgeys, John, of Craneworth, gent 0
3716622 1931495 1931495 defendant Byrle John smith 611062 611062 Byrle, John, of Craneworth, smith 4
3735868 1937455 1937455 defendant Sturgeys John gent 611062 611062 Sturgeys, John, of Craneworth, gent 2
3736589 1937695 1937695 defendant Sturges John, senior gent 611062 611062 Sturges, John, senior, of Craneworth, gent 0
3736590 1937695 1937695 defendant Sturges John, junior gent 611062 611062 Sturges, John, junior, of Craneworth, gent 1
3749807 1941851 1941851 defendant Sturges John, senior gent 611062 611062 Sturges, John, senior, of Craneworth, gent 0
3749808 1941851 1941851 defendant Sturges John, junior gent 611062 611062 Sturges, John, junior, of Craneworth, gent 1
3749810 1941852 1941852 defendant Sturges John, junior gent 611062 611062 Sturges, John, junior, of Craneworth, gent 0
3753595 1943067 1943067 plaintiff Southwell Katherine widow 611062 611062 Southwell, Katherine, of Craneworth, widow 0
3753599 1943068 1943068 plaintiff Southwell Katherine widow 611062 611062 Southwell, Katherine, of Craneworth, widow 0
3764171 1946445 1946445 defendant Sheryngton William gent 611062 611062 Sheryngton, William, of Craneworth, gent 0
3782157 1952172 1952172 defendant Sheryngton William gent 611062 611062 Sheryngton, William, of Craneworth, gent 0
3792986 1955664 1955664 defendant Sharyngton William gent 611062 611062 Sharyngton, William, of Craneworth, gent 0
3795962 1956600 1956600 defendant Sharyngton William esq 611062 611062 Sharyngton, William, of Craneworth, esq 0
3795965 1956601 1956601 defendant Sharyngton William gent 611062 611062 Sharyngton, William, of Craneworth, gent 0
3804720 1959421 1959421 defendant Sharyngton William gent 611062 611062 Sharyngton, William, of Craneworth, gent 0
3812610 1961831 1961831 defendant Sturges John, junior gent 611062 611062 Sturges, John, junior, of Craneworth, gent 0
3827704 1966529 1966529 defendant Grene alias Sponer Henry husbandman 611062 611062 Grene alias Sponer, Henry, of Craneworth, husbandman 1
3830308 1967373 1967373 defendant Sturges John, junior gent 611062 611062 Sturges, John, junior, of Craneworth, gent 0
3830488 1967414 1967414 defendant Sponer Henry husbandman 611062 611062 Sponer, Henry, of Craneworth, husbandman 1
3832278 1968010 1968010 defendant Sharyngton William gent 611062 611062 Sharyngton, William, of Craneworth, gent 0
3843049 1971353 1971353 defendant Barnewell William husbandman 611062 611062 Barnewell, William, of Craneworth, husbandman 0
3843050 1971353 1971353 defendant Dey Peter clerk 611062 611062 Dey, Peter, of Craneworth, clerk 1
3843051 1971353 1971353 defendant Hobbys John husbandman 611062 611062 Hobbys, John, of Craneworth, husbandman 2
3847800 1972887 1972887 defendant Sharyngton William gent 611062 611062 Sharyngton, William, of Craneworth, gent 0
3856304 1975589 1975589 defendant Sturgys John, senior husbandman 611062 611062 Sturgys, John, senior, of Craneworth, husbandman 0
3856427 1975634 1975634 defendant Sharyngton William gent 611062 611062 Sharyngton, William, of Craneworth, gent 0
3859225 1976577 1976577 defendant Beamond Robert mercer 611062 611062 Beamond, Robert, of Craneworth, mercer 0
3861616 1977345 1977345 defendant Canon John tailor 611062 611062 Canon, John, of Craneworth, tailor 1
3874911 1981834 1981834 plaintiff Dey Peter clerk 611062 611062 Dey, Peter, of Craneworth, clerk 0
3874912 1981834 1981834 defendant Sturgeys John, junior esq 611062 611062 Sturgeys, John, junior, of Craneworth, esq 0
3875817 1982165 1982165 defendant Sturges John, junior esq 611062 611062 Sturges, John, junior, of Craneworth, esq 0
3901532 1990738 1990738 defendant Sturgeys John esq 611062 611062 Sturgeys, John, of Craneworth, esq 0
3905153 1991986 1991986 defendant Ussher Thomas   611062 611062 Ussher, Thomas, of Craneworth, worsted weaver, administrators of 3
3941768 2004261 2004261 defendant Sturgys John   611062 611062 Sturgys, John, of Craneworth, gent, administrators of 0
3952463 2007930 2007930 defendant Peerson Richard husbandman 611062 611062 Peerson, Richard, of Craneworth, husbandman 1
3976620 2016399 2016399 plaintiff Knyght Robert   611062 611062 Knyght, Robert, of Craneworth 0
3987516 2020285 2020285 defendant Dixson Christopher clerk 611062 611062 Dixson, Christopher, of Craneworth, clerk 0
4015041 2030075 2030075 defendant Dyxson Christopher clerk 611062 611062 Dyxson, Christopher, of Craneworth, clerk 2
4220670 2102728 2102728 defendant Barnewell Thomas yeoman 611062 611062 Barnewell, Thomas, of Craneworth, yeoman 2
4537264 2211925 2211925 defendant Salman William   611062 611062 Salman, William, of Craneworth 0
4735941 2276390 2276390 defendant Alman William gent 611062 611062 Alman, William, of Craneworth, gent 4
4736189 2276454 2276454 plaintiff Swathyng Edmund esq 611062 611062 Swathyng, Edmund, of Craneworth, esq 0
4743058 2278489 2278489 plaintiff Alman William   611062 611062 Alman, William, of Craneworth 2
4743063 2278490 2278490 plaintiff Alman William   611062 611062 Alman, William, of Craneworth 2
4752059 2281089 2281089 defendant Alman William gent 611062 611062 Alman, William, of Craneworth, gent 2
4760209 2283545 2283545 defendant Alman William gent 611062 611062 Alman, William, of Craneworth, gent 0
4778599 2289290 2289290 defendant Souter William yeoman 611062 611062 Souter, William, of Craneworth, yeoman 2
4791710 2293504 2293504 plaintiff Alman William   611062 611062 Alman, William, of Craneworth 2
4791712 2293504 2293504 defendant Swachyng Edmund esq 611062 611062 Swachyng, Edmund, of Craneworth, esq 0
4796209 2294963 2294963 defendant Souter William clerk 611062 611062 Souter, William, of Craneworth, clerk 0
4796210 2294963 2294963 defendant Souter Richard yeoman 611062 611062 Souter, Richard, of Craneworth, yeoman 1
4796216 2294965 2294965 defendant Souter William clerk 611062 611062 Souter, William, of Craneworth, clerk 0
4796217 2294965 2294965 defendant Souter Richard yeoman 611062 611062 Souter, Richard, of Craneworth, yeoman 1
4799732 2296103 2296103 defendant Alman William husbandman 611062 611062 Alman, William, of Craneworth, husbandman 1
4800928 2296479 2296479 defendant Swatching Edmund esq 611062 611062 Swatching, Edmund, of Craneworth, esq 0
4800930 2296480 2296480 defendant Swatthyng Edmund esq 611062 611062 Swatthyng, Edmund, of Craneworth, esq 0
4803682 2297337 2297337 defendant Edmond John esq 611062 611062 Edmond, John, of Craneworth, esq 0
4810462 2299417 2299417 defendant Swathyng Edmund esq 611062 611062 Swathyng, Edmund, of Craneworth, esq 1
4823767 2303522 2303522 defendant Alman William yeoman 611062 611062 Alman, William, of Craneworth, yeoman 0
4823796 2303526 2303526 defendant Netoll John yeoman 611062 611062 Netoll, John, of Craneworth, yeoman 3
4831150 2305773 2305773 defendant Cony Henry yeoman 611062 611062 Cony, Henry, of Craneworth, yeoman 0
4861199 2314867 2314867 defendant Alman William yeoman 611062 611062 Alman, William, of Craneworth, yeoman 0
4877857 2320035 2320035 defendant Alman William yeoman 611062 611062 Alman, William, of Craneworth, yeoman 3
4911147 2330000 2330000 defendant Bernewell John laborer 611062 611062 Bernewell, John, of Craneworth, laborer 1
4911148 2330000 2330000 defendant Nicoll John laborer 611062 611062 with Nicoll, John, of Craneworth, laborer 2
4911149 2330000 2330000 defendant Alman William yeoman 611062 611062 Alman, William, of Craneworth, yeoman 3
4929498 2335642 2335642 defendant Roselyn Henry yeoman 611062 611062 Roselyn, Henry, of Craneworth, yeoman 1
4936732 2337868 2337868 defendant Salman John husbandman 611062 611062 Salman, John, of Craneworth, husbandman 3
4937130 2337985 2337985 defendant Love or Lone Nicholas yeoman 611062 611062 Love or Lone, Nicholas, of Craneworth, yeoman 1
4955019 2343455 2343455 defendant Salman John yeoman 611062 611062 Salman, John, of Craneworth, yeoman 2
4955038 2343458 2343458 defendant Sharyngton Henry esq 611062 611062 Sharyngton, Henry, of Craneworth, esq 0
4955045 2343460 2343460 defendant Roslyn Henry yeoman 611062 611062 Roslyn, Henry, of Craneworth, yeoman 1
4957718 2344281 2344281 defendant Smyth alias Richer John husbandman 611062 611062 Smyth alias Richer, John, of Craneworth, husbandman 0
4975841 2349737 2349737 defendant Couper William husbandman 611062 611062 Couper, William, of Craneworth, husbandman 7
4981413 2351358 2351358 defendant Salman John yeoman 611062 611062 Salman, John, of Craneworth, yeoman 0
5008110 2359256 2359256 defendant Peyntour Agnes   611062 611062 Peyntour, Agnes, of Craneworth, servant 2
5036047 2367399 2367399 defendant Alman William husbandman 611062 611062 Alman, William, of Craneworth, husbandman 0
5036049 2367400 2367400 defendant Couper Thomas husbandman 611062 611062 Couper, Thomas, of Craneworth, husbandman 0
5036050 2367400 2367400 defendant Salman John husbandman 611062 611062 Salman, John, of Craneworth, husbandman 1
5194710 2414190 2414190 plaintiff Redery Andrew   611062 611062 Redery, Andrew, of Craneworth 0
5194711 2414190 2414190 defendant Styward Thomas clerk & rector 611062 611062 Styward, Thomas, of Craneworth, clerk & rector 0
5194712 2414190 2414190 defendant Barnwell John husbandman 611062 611062 Barnwell, John, of Craneworth, husbandman 1
5196650 2414774 2414774 defendant Couper John husbandman 611062 611062 Couper, John, of Craneworth, husbandman 2
5203747 2416846 2416846 defendant Barnewell Thomas   611062 611062 Barnewell, Thomas, of Craneworth, hoop hewer 0
5203748 2416846 2416846 defendant Barnewell John husbandman 611062 611062 Barnewell, John, of Craneworth, husbandman 1
5209772 2418594 2418594 defendant Couper John husbandman 611062 611062 Couper, John, of Craneworth, husbandman 2
5284791 2440568 2440568 defendant Salman Robert cooper 611062 611062 Salman, Robert, of Craneworth, cooper 1
5288245 2441578 2441578 defendant Sheryngton William gent 611062 611062 Sheryngton, William, of Craneworth, or of Thuxston, gent 0
5317467 2450309 2450309 defendant Pennyng Alexander husbandman 611062 611062 Pennyng, Alexander, of Craneworth, husbandman 1
5327598 2453329 2453329 defendant Salman Robert husbandman 611062 611062 Salman, Robert, of Craneworth, husbandman 0
5353386 2461137 2461137 defendant Englysshe Richard husbandman 611062 611062 Englysshe, Richard, of Craneworth, husbandman 1
5530659 2514109 2514109 defendant Broun William clerk 611062 611062 Broun, William, of Craneworth, clerk 0
5543774 2518158 2518158 defendant Broun William clerk 611062 611062 Broun, William, of Craneworth, clerk 1
5558142 2522331 2522331 defendant Hobbard John husbandman 611062 611062 Hobbard, John, of Craneworth, husbandman 1
5631907 2554000 2554000 defendant Bernewell John husbandman 611062 611062 Bernewell, John, of Craneworth, husbandman 1

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