names

55 rows where place_id = 595200

✎ 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
3619347 1873643 1873643 defendant Thuresby John husbandman 595200 595200 Thuresby, John, of Sturton, husbandman 37
3619348 1873643 1873643 defendant Warderoppe Robert yeoman 595200 595200 Warderoppe, Robert, of Sturton, yeoman 38
3619349 1873643 1873643 defendant Sturton Thomas yeoman 595200 595200 Sturton, Thomas, of Sturton, yeoman 39
3759673 1945015 1945015 defendant Sturton Thomas yeoman 595200 595200 Sturton, Thomas, of Sturton, yeoman 0
3766395 1947145 1947145 defendant Sturton Thomas yeoman 595200 595200 Sturton, Thomas, of Sturton, yeoman 0
3845389 1972120 1972120 defendant Clyfton William husbandman 595200 595200 Clyfton, William, of Sturton, husbandman 0
3845390 1972120 1972120 defendant Pereson Robert husbandman 595200 595200 Pereson, Robert, of Sturton, husbandman 1
3902775 1991159 1991159 defendant Holme John butcher 595200 595200 Holme, John, of Sturton, butcher 0
3902776 1991159 1991159 defendant Sanke Richard laborer 595200 595200 Sanke, Richard, of Sturton, laborer 1
3965158 2012423 2012423 defendant Sturton Thomas yeoman 595200 595200 Sturton, Thomas, of Sturton, yeoman 0
3976378 2016312 2016312 defendant Eaton George yeoman 595200 595200 Eaton, George, of Sturton, yeoman 1
3977125 2016571 2016571 defendant Remyngton William yeoman 595200 595200 Remyngton, William, of Sturton, yeoman 0
3990853 2021485 2021485 defendant Dighton Edmund esq 595200 595200 Dighton, Edmund, of Sturton, esq 0
4013801 2029666 2029666 defendant Dyghton Edmund esq 595200 595200 Dyghton, Edmund, of Sturton, esq 0
4013804 2029667 2029667 defendant Dyghton Edmund esq 595200 595200 Dyghton, Edmund, of Sturton, esq 0
4061054 2046362 2046362 defendant Dighton Edmund esq 595200 595200 Dighton, Edmund, of Sturton, esq 1
4061055 2046362 2046362 defendant Dighton Thomas   595200 595200 Dighton, Thomas, of Sturton, gent, his son 2
4078015 2052439 2052439 defendant Harryson Richard butcher 595200 595200 Harryson, Richard, of Sturton, butcher 3
4081082 2053546 2053546 defendant Dyghton Edmund esq 595200 595200 Dyghton, Edmund, of Sturton, esq 1
4103636 2061582 2061582 defendant Cowper John yeoman 595200 595200 Cowper, John, of Sturton, yeoman 0
4103645 2061584 2061584 defendant Sturton Thomas gent 595200 595200 Sturton, Thomas, of Sturton, gent 0
4156909 2080494 2080494 defendant Gollande Alvered laborer 595200 595200 Gollande, Alvered, of Sturton, laborer 2
4160955 2081904 2081904 defendant Rymyngton Joan widow 595200 595200 Rymyngton, Joan, of Sturton, widow 0
4160956 2081904 2081904 defendant Browytt William   595200 595200 Browytt, William, of Sturton, ploughwright 1
4160957 2081904 2081904 defendant Harryson Richard butcher 595200 595200 Harryson, Richard, of Sturton, butcher 2
4202874 2096550 2096550 defendant Dighton Edmund esq 595200 595200 Dighton, Edmund, of Sturton, esq 0
4214725 2100656 2100656 defendant Smyth George yeoman 595200 595200 Smyth, George, of Sturton, yeoman 0
4216332 2101205 2101205 defendant Lassell George gent 595200 595200 Lassell, George, of Sturton, gent 0
4225646 2104435 2104435 defendant Lassell George gent 595200 595200 Lassell, George, of Sturton, gent 0
4227445 2105080 2105080 defendant Gascoigne Henry gent 595200 595200 Gascoigne, Henry, of Sturton, gent 0
4227447 2105080 2105080 defendant Funtaine or Funtance William laborer 595200 595200 Funtaine or Funtance, William, of Sturton, laborer 2
4233993 2107414 2107414 defendant Quarton William husbandman 595200 595200 Quarton, William, of Sturton, husbandman 0
4255795 2114912 2114912 defendant Gascoigne Henry gent 595200 595200 Gascoigne, Henry, of Sturton, gent 0
4255797 2114912 2114912 defendant Funtance William laborer 595200 595200 Funtance, William, of Sturton, laborer 2
4280290 2123010 2123010 defendant Sturton Thomas gent 595200 595200 Sturton, Thomas, of Sturton, gent 0
4289939 2126464 2126464 defendant Smyth Brian yeoman 595200 595200 Smyth, Brian, of Sturton, yeoman 0
4299366 2129864 2129864 defendant Conywood or Conywell William laborer 595200 595200 Conywood or Conywell, William, of Sturton, laborer 1
4335982 2142318 2142318 defendant Atkyn Henry husbandman 595200 595200 Atkyn, Henry, of Sturton, husbandman 3
4343287 2144926 2144926 defendant Anne Jervase gent 595200 595200 Anne, Jervase, of Sturton, gent 0
4358247 2150119 2150119 defendant Smythe William husbandman 595200 595200 Smythe, William, of Sturton, husbandman 0
4363270 2151931 2151931 defendant Dighton Thomas gent 595200 595200 Dighton, Thomas, of Sturton, gent 0
4364335 2152306 2152306 defendant Cowper John yeoman 595200 595200 Cowper, John, of Sturton, yeoman 0
4364337 2152306 2152306 defendant Jessoppe Thomas   595200 595200 Jessoppe, Thomas, of Sturton laborer 2
4377741 2157111 2157111 defendant Harrison John yeoman 595200 595200 Harrison, John, of Sturton, yeoman 2
4388380 2160746 2160746 defendant Sturton Thomas gent 595200 595200 Sturton, Thomas, of Sturton, gent 2
4391063 2161631 2161631 defendant Cowper John yeoman 595200 595200 Cowper, John, of Sturton, yeoman 0
4391064 2161631 2161631 defendant Kyrkby George laborer 595200 595200 Kyrkby, George, of Sturton, laborer 1
4404489 2166069 2166069 defendant Shacklocke Richard laborer 595200 595200 Shacklocke, Richard, of Sturton, laborer 0
4404490 2166069 2166069 defendant Kyrkbye George laborer 595200 595200 Kyrkbye, George, of Sturton, laborer 1
5101455 2386837 2386837 defendant Lymestre Henry yeoman 595200 595200 Lymestre, Henry, of Sturton, yeoman 2
5101460 2386838 2386838 defendant Lymestre Henry yeoman 595200 595200 Lymestre, Henry, of Sturton, yeoman 2
5309562 2447899 2447899 plaintiff Sturton William   595200 595200 Sturton, William, of Sturton, knight 0
5318281 2450564 2450564 defendant Rykesman Walter yeoman 595200 595200 Rykesman, Walter, of Sturton, yeoman 4
5511055 2508297 2508297 defendant Weston William husbandman 595200 595200 Weston, William, of Sturton, husbandman 0
5584093 2530101 2530101 defendant Scryven Richard gent 595200 595200 Scryven, Richard, of Sturton, gent 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);