names

76 rows where place_id = 590879

✎ 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
3602594 1868472 1868472 defendant Ryplyngham Richard gent 590879 590879 Ryplyngham, Richard, of Skulthorp, gent 1
3611099 1871146 1871146 defendant Moyge Henry clerk 590879 590879 Moyge, Henry, of Skulthorp, clerk 0
3613715 1871938 1871938 defendant Cole Thomas husbandman 590879 590879 Cole, Thomas, of Skulthorp, husbandman 2
3617538 1873106 1873106 defendant Bekham John husbandman 590879 590879 Bekham, John, of Skulthorp, husbandman 0
3622101 1874449 1874449 defendant Warde John husbandman 590879 590879 Warde, John, of Skulthorp, husbandman 0
3622108 1874450 1874450 defendant Amyngham Thomas husbandman 590879 590879 Amyngham, Thomas, of Skulthorp, husbandman 1
3628448 1903764 1903764 defendant Ryplyngham Richard gent 590879 590879 Ryplyngham, Richard, of Skulthorp, gent 0
3636823 1906309 1906309 defendant Lexham Henry   590879 590879 Lexham, Henry, of Skulthorp, shepherd 3
3642527 1908104 1908104 defendant Ryplyngham Richard gent 590879 590879 Ryplyngham, Richard, of Skulthorp, gent 0
3738845 1938355 1938355 defendant Mabbys Geoffrey yeoman 590879 590879 Mabbys, Geoffrey, of Skulthorp, yeoman 0
3748555 1941480 1941480 defendant Mabbys Geoffrey yeoman 590879 590879 Mabbys, Geoffrey, of Skulthorp, yeoman 0
3752191 1942613 1942613 defendant Mabbys Geoffrey husbandman 590879 590879 Mabbys, Geoffrey, of Skulthorp, husbandman 2
3754972 1943502 1943502 defendant Malbys Geoffrey yeoman 590879 590879 Malbys, Geoffrey, of Skulthorp, yeoman 1
3762987 1946054 1946054 defendant Mabbys Geoffrey yeoman 590879 590879 Mabbys, Geoffrey, of Skulthorp, yeoman 0
3763779 1946316 1946316 defendant Mabbys Geoffrey yeoman 590879 590879 Mabbys, Geoffrey, of Skulthorp, yeoman 2
3768817 1947895 1947895 defendant Mabbes Geoffrey husbandman 590879 590879 Mabbes, Geoffrey, of Skulthorp, husbandman 2
3771456 1948764 1948764 defendant Mabbys Geoffrey yeoman 590879 590879 Mabbys, Geoffrey, of Skulthorp, yeoman 2
3784218 1952851 1952851 defendant Mabbys Geoffrey husbandman 590879 590879 Mabbys, Geoffrey, of Skulthorp, husbandman 1
3785668 1953309 1953309 defendant Mabbys Geoffrey yeoman 590879 590879 Mabbys, Geoffrey, of Skulthorp, yeoman 0
3786961 1953724 1953724 defendant Mabbys Geoffrey yeoman 590879 590879 Mabbys, Geoffrey, of Skulthorp, yeoman 1
3813907 1962260 1962260 defendant Mabbys Geoffrey husbandman 590879 590879 Mabbys, Geoffrey, of Skulthorp, husbandman 1
3826683 1966193 1966193 defendant Wolsey William husbandman 590879 590879 Wolsey, William, of Skulthorp, husbandman 1
3826686 1966194 1966194 defendant Crystmas Robert husbandman 590879 590879 Crystmas, Robert, of Skulthorp, husbandman 1
3826687 1966194 1966194 defendant Crystmas Thomas laborer 590879 590879 Crystmas, Thomas, of Skulthorp, laborer 2
3881887 1984196 1984196 defendant Styberd Thomas husbandman 590879 590879 Styberd, Thomas, of Skulthorp, husbandman 0
3881888 1984196 1984196 defendant Hawook William laborer 590879 590879 Hawook, William, of Skulthorp, laborer 1
3895569 1988724 1988724 defendant Sonde John husbandman 590879 590879 Sonde, John, of Skulthorp, husbandman 0
3913066 1994699 1994699 defendant Sande John husbandman 590879 590879 Sande, John, of Skulthorp, husbandman 1
3913067 1994699 1994699 defendant Sande William husbandman 590879 590879 Sande, William, of Skulthorp, husbandman 2
4092096 2057469 2057469 defendant Burgony Richard husbandman 590879 590879 Burgony, Richard, of Skulthorp, husbandman 0
4504873 2202066 2202066 defendant Boys John   590879 590879 Boys, John, of Skulthorp, parson 9
4522666 2207429 2207429 plaintiff Berry Edmund   590879 590879 Berry, Edmund, of Skulthorp, parson 2
4641203 2243519 2243519 defendant Hake Richard   590879 590879 Hake, Richard, of Skulthorp 0
4696515 2264387 2264387 defendant Godyng Thomas husbandman 590879 590879 Godyng, Thomas, of Skulthorp, husbandman 0
4696517 2264387 2264387 defendant Lente John husbandman 590879 590879 Lente, John, of Skulthorp, husbandman 2
4696519 2264388 2264388 defendant Godyn Thomas husbandman 590879 590879 Godyn, Thomas, of Skulthorp, husbandman 0
4696521 2264388 2264388 defendant Lence John husbandman 590879 590879 Lence, John, of Skulthorp, husbandman 2
4741087 2277899 2277899 defendant Lente John yeoman 590879 590879 Lente, John, of Skulthorp, yeoman 0
4761345 2283892 2283892 defendant Berry Edmund   590879 590879 Berry, Edmund, of Skulthorp, parson 0
4776447 2288627 2288627 defendant Pottere William husbandman 590879 590879 Pottere, William, of Skulthorp, husbandman 0
4779923 2289719 2289719 defendant Potter William husbandman 590879 590879 Potter, William, of Skulthorp, husbandman 3
4809463 2299135 2299135 defendant Marton Richard   590879 590879 Marton, Richard, of Skulthorp, cook 1
4809464 2299135 2299135 defendant Potter William fishman 590879 590879 Potter, William, of Skulthorp, fishman 2
4815315 2300898 2300898 defendant Cawhit William yeoman 590879 590879 Cawhit, William, of Skulthorp, yeoman 5
4831949 2306022 2306022 defendant Potter William husbandman 590879 590879 Potter, William, of Skulthorp, husbandman 0
4838646 2308013 2308013 defendant Garbald or Garbale Robert yeoman 590879 590879 Garbald or Garbale, Robert, of Skulthorp, yeoman 0
4838814 2308069 2308069 defendant Garbald Robert yeoman 590879 590879 Garbald, Robert, of Skulthorp, yeoman 0
4838820 2308071 2308071 defendant Garbald Robert yeoman 590879 590879 Garbald, Robert, of Skulthorp, yeoman 0
4846619 2310455 2310455 defendant Roo William husbandman 590879 590879 Roo, William, of Skulthorp, husbandman 0
4846620 2310455 2310455 defendant Potter William husbandman 590879 590879 Potter, William, of Skulthorp, husbandman 1
4846622 2310455 2310455 defendant Rlbyns John yeoman 590879 590879 Rlbyns, John, of Skulthorp, yeoman 3
4872440 2318345 2318345 defendant Garbald Robert husbandman 590879 590879 Garbald, Robert, of Skulthorp, husbandman 1
4905048 2328187 2328187 defendant Stanbowe Thomas yeoman 590879 590879 Stanbowe, Thomas, of Skulthorp, yeoman 1
4907735 2328982 2328982 defendant Porter Mary   590879 590879 Porter, Mary, of Skulthorp, servant 2
4911924 2330234 2330234 defendant Robynes John yeoman 590879 590879 Robynes, John, of Skulthorp, yeoman 2
4924546 2334113 2334113 defendant Swanwhich John   590879 590879 Swanwhich, John, of Skulthorp, parson 0
4936734 2337868 2337868 defendant Stanbowe Thomas yeopman 590879 590879 Stanbowe, Thomas, of Skulthorp, yeopman 5
4936735 2337868 2337868 defendant Robynnys John husbandman 590879 590879 Robynnys, John, of Skulthorp, husbandman 6
4967221 2347130 2347130 defendant Sonde James husbandman 590879 590879 Sonde, James, of Skulthorp, husbandman 0
4967222 2347130 2347130 defendant Styberd John smith 590879 590879 Styberd, John, of Skulthorp, smith 1
4967223 2347130 2347130 defendant Swanwych John clerk 590879 590879 Swanwych, John, of Skulthorp, clerk 2
5035200 2367158 2367158 defendant Smyth William   590879 590879 Smyth, William, of Skulthorp, shepherd 2
5253882 2431329 2431329 plaintiff Broun George (legal representative) 590879 590879 Broun, George, of Skulthorp, chaplain, executors of 0
5253884 2431329 2431329 plaintiff Styberd John   590879 590879 Styberd, John, of Skulthorp 2
5253888 2431329 2431329 defendant Fayrest William husbandman 590879 590879 Fayrest, William, of Skulthorp, husbandman 3
5280349 2439331 2439331 defendant Stylberd Valery yeoman 590879 590879 Stylberd, Valery, of Skulthorp, yeoman 9
5296847 2444067 2444067 defendant Shortman Thomas husbandman 590879 590879 Shortman, Thomas, of Skulthorp, husbandman 0
5388617 2471800 2471800 plaintiff Hardfyssh John clerk 590879 590879 Hardfyssh, John, of Skulthorp, clerk 0
5388618 2471800 2471800 defendant Hardfysshe Richard chaplain 590879 590879 Hardfysshe, Richard, of Skulthorp, chaplain 0
5506266 2506879 2506879 defendant Hardfyssh John clerk 590879 590879 Hardfyssh, John, of Skulthorp, clerk 3
5538033 2516384 2516384 defendant Catesby Robert clerk 590879 590879 Catesby, Robert, of Skulthorp, clerk 1
5591801 2532419 2532419 defendant Hunton John yeoman 590879 590879 Hunton, John, of Skulthorp, yeoman 0
5602242 2535596 2535596 defendant Rypplyngham Richard gent 590879 590879 Rypplyngham, Richard, of Skulthorp, gent 2
5604690 2536331 2536331 defendant Shemfeld William   590879 590879 Shemfeld, William, of Skulthorp, yeoman, administrators of 0
5604691 2536331 2536331 defendant Hunton Robert yeoman 590879 590879 (Hunton, Robert, of Skulthorp, yeoman 1
5636926 2555492 2555492 defendant Hake Richard butcher 590879 590879 Hake, Richard, of Skulthorp, butcher 5

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