names

43 rows where place_id = 586915

✎ 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
3589978 1864506 1864506 defendant Eyre Nicholas gent 586915 586915 Eyre, Nicholas, of Hurst, gent 0
3592114 1865150 1865150 defendant Wayte Ralph husbandman 586915 586915 Wayte, Ralph, of Hurst, husbandman 0
3618229 1873325 1873325 defendant Halle Hugh yeoman 586915 586915 Halle, Hugh, of Hurst, yeoman 2
3618230 1873325 1873325 defendant Fodon Hugh yeoman 586915 586915 Fodon, Hugh, of Hurst, yeoman 3
3624398 1875166 1875166 defendant Wyfold Thomas husbandman 586915 586915 Wyfold, Thomas, of Hurst, husbandman 0
3654273 1911595 1911595 defendant Shepard Robert yeoman 586915 586915 Shepard, Robert, of Hurst, yeoman 0
3663560 1914531 1914531 defendant Mottyngley Thomas husbandman 586915 586915 Mottyngley, Thomas, of Hurst, husbandman 0
3679394 1919619 1919619 defendant Wever Michael yeoman 586915 586915 Wever, Michael, of Hurst, yeoman 0
3679397 1919620 1919620 defendant Wever Michael yeoman 586915 586915 Wever, Michael, of Hurst, yeoman 0
3685605 1921650 1921650 defendant Pastler John husbandman 586915 586915 Pastler, John, of Hurst, husbandman 1
3743229 1939748 1939748 defendant Hardyng Thomas yeoman 586915 586915 Hardyng, Thomas, of Hurst, yeoman 0
3744639 1940216 1940216 defendant Fairer John husbandman 586915 586915 Fairer, John, of Hurst, husbandman 3
3744640 1940216 1940216 defendant Corway Richard husbandman 586915 586915 Corway, Richard, of Hurst, husbandman 4
3755458 1943660 1943660 defendant Sanford John tiler 586915 586915 Sanford, John, of Hurst, tiler 0
3813239 1962051 1962051 defendant Carpenter Gilbert husbandman 586915 586915 Carpenter, Gilbert, of Hurst, husbandman 0
3814447 1962432 1962432 defendant Heyne William husbandman 586915 586915 Heyne, William, of Hurst, husbandman 0
3816470 1963058 1963058 defendant Brode Richard husbandman 586915 586915 Brode, Richard, of of Hurst, husbandman 1
3853436 1974701 1974701 defendant Parker Nicholas husbandman 586915 586915 Parker, Nicholas, of Hurst, husbandman 1
3853437 1974701 1974701 defendant Adams Thomas husbandman 586915 586915 Adams, Thomas, of Hurst, husbandman 2
3853440 1974702 1974702 defendant Parker Nicholas husbandman 586915 586915 Parker, Nicholas, of Hurst, husbandman 1
3853441 1974702 1974702 defendant Adams Thomas husbandman 586915 586915 Adams, Thomas, of Hurst, husbandman 2
3896479 1989028 1989028 defendant Corrunden Henry carpenter 586915 586915 Corrunden, Henry, of Hurst, carpenter 0
3903715 1991474 1991474 defendant Sanford Thomas carpenter 586915 586915 Sanford, Thomas, of Hurst, carpenter 1
3909769 1993576 1993576 defendant Byngham William yeoman 586915 586915 Byngham, William, of Hurst, yeoman 0
3914510 1995195 1995195 defendant Clement alias Queryngdon John carpenter 586915 586915 Clement alias Queryngdon, John, of Hurst, carpenter 0
4040231 2039010 2039010 defendant Buny Nicholas gent 586915 586915 (Buny, Nicholas, of Hurst, gent 1
4051130 2042844 2042844 defendant Bunny Nicholas gent 586915 586915 (Bunny, Nicholas, of Hurst, gent 1
4412532 2168779 2168779 defendant Bentley Richard yeoman 586915 586915 Bentley, Richard, of Hurst, yeoman 1
4412541 2168783 2168783 defendant Bentley Richard yeoman 586915 586915 Bentley, Richard, of Hurst, yeoman 1
4439952 2181777 2181777 defendant Restwold Ralph   586915 586915 Restwold, Ralph, of Hurst 2
4458779 2187791 2187791 defendant Couper John   586915 586915 Couper, John, of Hurst 3
4459515 2188030 2188030 defendant Carte John, senior   586915 586915 Carte, John, senior, of Hurst 0
4491842 2198127 2198127 plaintiff Brounyng Thomas   586915 586915 Brounyng, Thomas, of Hurst 3
4514708 2205016 2205016 plaintiff Carpenter Andrew chaplain 586915 586915 Carpenter, Andrew, of Hurst, chaplain 0
4578365 2224722 2224722 defendant Whetham Richard   586915 586915 Whetham, Richard, of Hurst 0
4811921 2299843 2299843 defendant Heynes Thomas laborer 586915 586915 Heynes, Thomas, of Hurst, laborer 0
5011007 2360080 2360080 defendant Gorewey Thomas husbandman 586915 586915 Gorewey, Thomas, of Hurst, husbandman 0
5012823 2360584 2360584 defendant Lucas John husbandman 586915 586915 Lucas, John, of Hurst, husbandman 2
5532324 2514652 2514652 defendant Wyfeld Thomas husbandman 586915 586915 Wyfeld, Thomas, of Hurst, husbandman 0
5555452 2521598 2521598 defendant Eyre Thomas gent 586915 586915 Eyre, Thomas, of Hurst, gent 3
5578535 2528357 2528357 defendant Wynstanley William clerk 586915 586915 Wynstanley, William, of Hurst, clerk 0
5584372 2530175 2530175 defendant Hervy Ralph yeoman 586915 586915 Hervy, Ralph, of Hurst, yeoman 0
5619104 2549821 2549821 plaintiff Osamme John   586915 586915 Osamme, John, of Hurst 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);