names

74 rows where place_id = 589561

✎ 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
3598000 1866998 1866998 defendant Elward Thomas yeoman 589561 589561 Elward, Thomas, of Hagworthyngham, yeoman 0
3904633 1991804 1991804 defendant Purrell Thomas husbandman 589561 589561 Purrell, Thomas, of Hagworthyngham, husbandman 0
4019863 2031837 2031837 plaintiff West Richard (legal representative) 589561 589561 West, Richard, of Hagworthyngham, clerk, executor of 0
4037013 2037905 2037905 defendant Everyngton Richard husbandman 589561 589561 Everyngton, Richard, of Hagworthyngham, husbandman 0
4037014 2037905 2037905 defendant Rayler Saunder husbandman 589561 589561 Rayler, Saunder, of Hagworthyngham, husbandman 1
4037015 2037905 2037905 defendant Estwood Thomas husbandman 589561 589561 Estwood, Thomas, of Hagworthyngham, husbandman 2
4050896 2042763 2042763 plaintiff West Richard (legal representative) 589561 589561 West, Richard, of Hagworthyngham, clerk, executor of 0
4575651 2223896 2223896 defendant Hobkynson Philip   589561 589561 Hobkynson, Philip, of Hagworthyngham 0
4666047 2250851 2250851 defendant Bradley Richard gent 589561 589561 Bradley, Richard, of Hagworthyngham, gent 0
4684586 2260780 2260780 defendant Bradlay Richard esq 589561 589561 Bradlay, Richard, of Hagworthyngham, esq 0
4684599 2260782 2260782 defendant Bradlay Richard   589561 589561 Bradlay, Richard, of Hagworthyngham 0
4686897 2261510 2261510 plaintiff Spenser Thomas   589561 589561 Spenser, Thomas, of Hagworthyngham 0
4686898 2261510 2261510 defendant Rynget John husbandman 589561 589561 Rynget, John, of Hagworthyngham, husbandman 0
4686899 2261510 2261510 defendant Strete John husbandman 589561 589561 Strete, John, of Hagworthyngham, husbandman 1
4706148 2267300 2267300 defendant Bradley Richard esq 589561 589561 Bradley, Richard, of Hagworthyngham, esq 0
4727061 2273726 2273726 defendant Travers Henry yeoman 589561 589561 Travers, Henry, of Hagworthyngham, yeoman 0
4727066 2273727 2273727 defendant Travers Henry yeoman 589561 589561 Travers, Henry, of Hagworthyngham, yeoman 0
4735880 2276373 2276373 defendant Spenser Thomas husbandman 589561 589561 Spenser, Thomas, of Hagworthyngham, husbandman 0
4785057 2291342 2291342 defendant Hagworthyngham John husbandman 589561 589561 Hagworthyngham, John, of Hagworthyngham, husbandman 0
4788085 2292342 2292342 defendant Clerk John husbandman 589561 589561 Clerk, John, of Hagworthyngham, husbandman 0
4795771 2294829 2294829 plaintiff Roper Robert   589561 589561 Roper, Robert, of Hagworthyngham 0
4813874 2300449 2300449 defendant Smyth William   589561 589561 Smyth, William, of Hagworthyngham 0
4822841 2303227 2303227 defendant Taskere Richard   589561 589561 Taskere, Richard, of Hagworthyngham, son of John Taskere 0
4826959 2304471 2304471 plaintiff Wilughby William   589561 589561 Wilughby, William, of Hagworthyngham, parson 0
4867094 2316671 2316671 defendant Marre William gent 589561 589561 Marre, William, of Hagworthyngham, gent 0
4872904 2318478 2318478 plaintiff Palmer Richard chaplain 589561 589561 Palmer, Richard, of Hagworthyngham, chaplain 0
4886065 2322501 2322501 defendant Draper Richard chapman 589561 589561 Draper, Richard, of Hagworthyngham, chapman 0
4891182 2323975 2323975 defendant Draper Richard chapman 589561 589561 Draper, Richard, of Hagworthyngham, chapman 0
4891189 2323976 2323976 defendant Draper Richard merchant 589561 589561 Draper, Richard, of Hagworthyngham, merchant 1
4919980 2332761 2332761 defendant Jonyson John husbandman 589561 589561 Jonyson, John, of Hagworthyngham, husbandman 1
4940845 2339164 2339164 plaintiff Draper Richard merchant 589561 589561 Draper, Richard, of Hagworthyngham, merchant 0
4961702 2345462 2345462 defendant Woderoffe William husbandman 589561 589561 Woderoffe, William, of Hagworthyngham, husbandman 2
4965694 2346663 2346663 defendant Sybsay John husbandman 589561 589561 Sybsay, John, of Hagworthyngham, husbandman 4
4967342 2347174 2347174 defendant Jonyson John husbandman 589561 589561 Jonyson, John, of Hagworthyngham, husbandman 10
4999261 2356651 2356651 defendant Bolyngbrok Thomas laborer 589561 589561 Bolyngbrok, Thomas, of Hagworthyngham, laborer 0
4999263 2356651 2356651 defendant Terras William laborer 589561 589561 Terras, William, of Hagworthyngham, laborer 2
5023318 2363726 2363726 defendant Boton Richard   589561 589561 Boton, Richard, of Hagworthyngham, shepherd 0
5034565 2366969 2366969 defendant Lange John husbandman 589561 589561 Lange, John, of Hagworthyngham, husbandman 0
5054838 2373014 2373014 defendant Bolyngbroke Thomas husbandman 589561 589561 Bolyngbroke, Thomas, of Hagworthyngham, husbandman 0
5054839 2373014 2373014 defendant Bolyngbroke Robert laborer 589561 589561 Bolyngbroke, Robert, of Hagworthyngham, laborer 1
5059118 2374294 2374294 plaintiff Draper Richard   589561 589561 Draper, Richard, of Hagworthyngham 0
5064440 2375905 2375905 defendant Bolyngbroke John husbandman 589561 589561 Bolyngbroke, John, of Hagworthyngham, husbandman 0
5082568 2381293 2381293 plaintiff Draper Rchard merchant 589561 589561 Draper, Rchard, of Hagworthyngham, merchant 0
5082571 2381294 2381294 plaintiff Draper Richard   589561 589561 Draper, Richard, of Hagworthyngham 0
5106685 2388382 2388382 defendant Copeland Robert husbandman 589561 589561 Copeland, Robert, of Hagworthyngham, husbandman 0
5189374 2412624 2412624 defendant Draper Nicholas gent 589561 589561 Draper, Nicholas, of Hagworthyngham, gent 2
5220812 2421779 2421779 defendant Draper Richard merchant 589561 589561 Draper, Richard, of Hagworthyngham, merchant 0
5231312 2424755 2424755 defendant Draper Richard merchant 589561 589561 Draper, Richard, of Hagworthyngham, merchant 0
5231313 2424755 2424755 defendant Draper Nicholas gent 589561 589561 Draper, Nicholas, of Hagworthyngham, gent 1
5240500 2427436 2427436 defendant Draper Richard merchant 589561 589561 Draper, Richard, of Hagworthyngham, merchant 0
5240862 2427533 2427533 defendant Strete Robert husbandman 589561 589561 Strete, Robert, of Hagworthyngham, husbandman 0
5293925 2443195 2443195 defendant Rasshe John tailor 589561 589561 Rasshe, John, of Hagworthyngham, tailor 1
5301915 2445524 2445524 defendant Lyndesey Thomas gent 589561 589561 Lyndesey, Thomas, of Hagworthyngham, gent 1
5334152 2455281 2455281 defendant Rasur William merchant 589561 589561 Rasur, William, of Hagworthyngham, merchant 0
5334605 2455419 2455419 defendant Spert Richard gent 589561 589561 Spert, Richard, of Hagworthyngham, gent 0
5343370 2458117 2458117 defendant Aylward Thomas yeoman 589561 589561 Aylward, Thomas, of Hagworthyngham, yeoman 0
5363386 2464200 2464200 defendant Elward Thomas yeoman 589561 589561 Elward, Thomas, of Hagworthyngham, yeoman 0
5393115 2473102 2473102 defendant Elward Thomas husbandman 589561 589561 Elward, Thomas, of Hagworthyngham, husbandman 1
5406331 2476881 2476881 defendant Elward Thomas husbandman 589561 589561 Elward, Thomas, of Hagworthyngham, husbandman 1
5419403 2480719 2480719 defendant Elward Thomas husbandman 589561 589561 Elward, Thomas, of Hagworthyngham, husbandman 0
5428986 2483588 2483588 defendant Webster Thomas husbandman 589561 589561 Webster, Thomas, of Hagworthyngham, husbandman 3
5499790 2504884 2504884 plaintiff Rassh John   589561 589561 Rassh, John, of Hagworthyngham 0
5519705 2510997 2510997 defendant Elward William yeoman 589561 589561 Elward, William, of Hagworthyngham, yeoman 0
5530808 2514153 2514153 defendant Burton Thomas husbandman 589561 589561 Burton, Thomas, of Hagworthyngham, husbandman 0
5530809 2514153 2514153 defendant Webster Thomas weaver 589561 589561 Webster, Thomas, of Hagworthyngham, weaver 1
5530810 2514153 2514153 defendant Yonge Robert husbandman 589561 589561 Yonge, Robert, of Hagworthyngham, husbandman 2
5531634 2514427 2514427 defendant Kylclyff William chaplain 589561 589561 Kylclyff, William, of Hagworthyngham, chaplain 0
5543585 2518099 2518099 defendant Smert William husbandman 589561 589561 Smert, William, of Hagworthyngham, husbandman 0
5543586 2518099 2518099 defendant Burton Thomas husbandman 589561 589561 Burton, Thomas, of Hagworthyngham, husbandman 1
5552290 2520716 2520716 defendant Baker William chaplain 589561 589561 Baker, William, of Hagworthyngham, chaplain 1
5598140 2534312 2534312 defendant Elwarde William yeoman 589561 589561 Elwarde, William, of Hagworthyngham, yeoman 4
5598146 2534313 2534313 defendant Elwarde William yeoman 589561 589561 Elwarde, William, of Hagworthyngham, yeoman 4
5610561 2547026 2547026 defendant Tetford Thomas   589561 589561 Tetford, Thomas, of Hagworthyngham, parson 0
5621421 2550594 2550594 defendant Smyth Richard   589561 589561 Smyth, Richard, of Hagworthyngham 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);