names

247 rows where place_id = 588135

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593479 1865595 1865595 defendant Symkyn Edith widow 588135 588135 Symkyn, Edith, of Somerton, widow 0
3600240 1867722 1867722 defendant Salwey Richard husbandman 588135 588135 Salwey, Richard, of Somerton, husbandman 1
3626596 1903171 1903171 defendant Howchon John husbandman 588135 588135 Howchon, John, of Somerton, husbandman 0
3639145 1907061 1907061 defendant Apleyn John husbandman 588135 588135 Apleyn, John, of Somerton, husbandman 2
3665292 1915098 1915098 plaintiff Speke John merchant 588135 588135 Speke, John, of Somerton, merchant 0
3697017 1925292 1925292 defendant Pedwell William husbandman 588135 588135 Pedwell, William, of Somerton, husbandman 0
3697018 1925292 1925292 defendant Pyper William husbandman 588135 588135 Pyper, William, of Somerton, husbandman 1
3710822 1929702 1929702 plaintiff Speke John   588135 588135 Speke, John, of Somerton 0
3710824 1929703 1929703 plaintiff Speke John   588135 588135 Speke, John, of Somerton 0
3725430 1934249 1934249 defendant Pedwell William husbandman 588135 588135 Pedwell, William, of Somerton, husbandman 0
3725431 1934249 1934249 defendant Pyper William husbandman 588135 588135 Pyper, William, of Somerton, husbandman 1
3725434 1934250 1934250 defendant Pedwell William husbandman 588135 588135 Pedwell, William, of Somerton, husbandman 0
3725435 1934250 1934250 defendant Pyper William husbandman 588135 588135 Pyper, William, of Somerton, husbandman 1
3752167 1942606 1942606 defendant Hucker Elizabeth widow 588135 588135 Hucker, Elizabeth, of Somerton, widow 0
3752168 1942606 1942606 defendant Hucker John husbandman 588135 588135 Hucker, John, of Somerton, husbandman 1
3770774 1948547 1948547 defendant Davy John husbandman 588135 588135 Davy, John, of Somerton, husbandman 1
3778951 1951136 1951136 defendant Botolff John yeoman 588135 588135 Botolff, John, of Somerton, yeoman 0
3779745 1951399 1951399 plaintiff Fermer William gent 588135 588135 Fermer, William, of Somerton, gent 0
3808279 1960463 1960463 defendant Johnson John scrivener 588135 588135 Johnson, John, of Somerton, scrivener 1
3817241 1963305 1963305 defendant Colvile Robert gent 588135 588135 (Colvile, Robert, of Somerton, gent 2
3817249 1963306 1963306 defendant Colvyle Robert gent 588135 588135 Colvyle, Robert, of Somerton, gent 5
3817255 1963307 1963307 defendant Colvile Robert gent 588135 588135 Colvile, Robert, of Somerton, gent 4
3822200 1964844 1964844 defendant Gosby Edmund cordwainer 588135 588135 Gosby, Edmund, of Somerton, cordwainer 0
3843143 1971381 1971381 defendant Calowe Robert mercer 588135 588135 Calowe, Robert, of Somerton, mercer 0
3844749 1971901 1971901 defendant Coppyng William yeoman 588135 588135 Coppyng, William, of Somerton, yeoman 1
3851930 1974195 1974195 defendant Speke John gent 588135 588135 Speke, John, of Somerton, gent 0
3851931 1974195 1974195 defendant Wason John laborer 588135 588135 Wason, John, of Somerton, laborer 1
3851932 1974195 1974195 defendant Yemens John husbandman 588135 588135 Yemens, John, of Somerton, husbandman 2
3851934 1974196 1974196 defendant Speke John gent 588135 588135 Speke, John, of Somerton, gent 0
3851935 1974196 1974196 defendant Wason John laborer 588135 588135 Wason, John, of Somerton, laborer 1
3851936 1974196 1974196 defendant Yemens John husbandman 588135 588135 Yemens, John, of Somerton, husbandman 2
3851938 1974197 1974197 defendant Speke John gent 588135 588135 Speke, John, of Somerton, gent 0
3851939 1974197 1974197 defendant Waston John laborer 588135 588135 Waston, John, of Somerton, laborer 1
3851940 1974197 1974197 defendant Yemens John husbandman 588135 588135 Yemens, John, of Somerton, husbandman 2
3861837 1977419 1977419 defendant Hyllacare Cuthbert clerk 588135 588135 Hyllacare, Cuthbert, of Somerton, clerk 0
3886953 1985901 1985901 plaintiff Chyppat Robert yeoman 588135 588135 Chyppat, Robert, of Somerton, yeoman 0
3889847 1986845 1986845 defendant Unde John brickmaker 588135 588135 Unde, John, of Somerton, brickmaker 0
3940930 2003974 2003974 defendant Newman John   588135 588135 Newman, John, of Somerton, inn holder 0
3952398 2007909 2007909 defendant Horne John tailor 588135 588135 Horne, John, of Somerton, tailor 0
3952545 2007959 2007959 plaintiff Hodges James yeoman 588135 588135 Hodges, James, of Somerton, yeoman 0
3957910 2009828 2009828 defendant Bull John smith 588135 588135 Bull, John, of Somerton, smith 3
3957952 2009845 2009845 defendant Bright Richard fisherman 588135 588135 Bright, Richard, of Somerton, fisherman 1
3968414 2013586 2013586 plaintiff Chipper Robert yeoman 588135 588135 Chipper, Robert, of Somerton, yeoman 0
3993868 2022556 2022556 plaintiff Chypper or Chepperd Robert yeoman 588135 588135 Chypper or Chepperd, Robert, of Somerton, yeoman 0
3993870 2022557 2022557 plaintiff Chypper or Chypeper Robert   588135 588135 Chypper or Chypeper, Robert, of Somerton 0
3993880 2022561 2022561 plaintiff Chypper Robert   588135 588135 Chypper, Robert, of Somerton 0
3993882 2022562 2022562 plaintiff Chypper Robert yeoman 588135 588135 Chypper, Robert, of Somerton, yeoman 0
3993884 2022563 2022563 plaintiff Chypper Robert yeoman 588135 588135 Chypper, Robert, of Somerton, yeoman 0
3993886 2022564 2022564 plaintiff Chypper Robert yeoman 588135 588135 Chypper, Robert, of Somerton, yeoman 0
3993889 2022565 2022565 plaintiff Chypper Robert yeoman 588135 588135 Chypper, Robert, of Somerton, yeoman 0
3993892 2022566 2022566 plaintiff Chypper Robert yeoman 588135 588135 Chypper, Robert, of Somerton, yeoman 0
3993894 2022567 2022567 plaintiff Chypper Robert yeoman 588135 588135 Chypper, Robert, of Somerton, yeoman 0
4027444 2034464 2034464 plaintiff Chypper or Chypeper Robert   588135 588135 Chypper or Chypeper, Robert, of Somerton 0
4027448 2034466 2034466 plaintiff Chypper Robert yeoman 588135 588135 Chypper, Robert, of Somerton, yeoman 0
4027449 2034466 2034466 defendant Pedell John yeoman or corn driver 588135 588135 Pedell, John, of Somerton, yeoman or corn driver 0
4037989 2038232 2038232 defendant Bussard William husbandman 588135 588135 Bussard, William, of Somerton, husbandman 0
4058119 2045283 2045283 defendant Brewster William yeoman 588135 588135 Brewster, William, of Somerton, yeoman 1
4059796 2045897 2045897 defendant Lyde William chandler 588135 588135 Lyde, William, of Somerton, chandler 0
4070613 2049785 2049785 defendant Lyde William chandler 588135 588135 Lyde, William, of Somerton, chandler 0
4075135 2051412 2051412 defendant Browster William husbandman 588135 588135 Browster, William, of Somerton, husbandman 1
4087213 2055717 2055717 defendant Brewster or Bruster William yeoman 588135 588135 Brewster or Bruster, William, of Somerton, yeoman 0
4087215 2055718 2055718 defendant Bruster William yeoman 588135 588135 Bruster, William, of Somerton, yeoman 0
4132346 2071882 2071882 defendant Reder Nicholas husbandman 588135 588135 Reder, Nicholas, of Somerton, husbandman 1
4147003 2077097 2077097 defendant Hodges James yeoman 588135 588135 Hodges, James, of Somerton, yeoman 0
4200940 2095886 2095886 defendant Marshall John, junior clerk 588135 588135 Marshall, John, junior, of Somerton, clerk 1
4216678 2101327 2101327 defendant Ely James gent 588135 588135 Ely, James, of Somerton, gent 0
4219744 2102410 2102410 defendant Aldred Richard yeoman 588135 588135 Aldred, Richard, of Somerton, yeoman 1
4287098 2125439 2125439 defendant Marshall John husbandman 588135 588135 Marshall, John, of Somerton, husbandman 2
4287529 2125590 2125590 defendant Bishop John innholder 588135 588135 Bishop, John, of Somerton, innholder 1
4287750 2125669 2125669 defendant Balche Robert butcher 588135 588135 Balche, Robert, of Somerton, butcher 2
4294270 2128027 2128027 defendant Strowde George gent 588135 588135 Strowde, George, of Somerton, gent 0
4308685 2133188 2133188 defendant Bridges John husbandman 588135 588135 Bridges, John, of Somerton, husbandman 2
4308686 2133188 2133188 defendant Salesburye Robert husbandman 588135 588135 Salesburye, Robert, of Somerton, husbandman 3
4312298 2134437 2134437 defendant Sparke Robert yeoman 588135 588135 Sparke, Robert, of Somerton, yeoman 1
4312674 2134565 2134565 defendant Cannon Stephen butcher 588135 588135 Cannon, Stephen, of Somerton, butcher 0
4341309 2144235 2144235 defendant Turcocke Robert husbandman 588135 588135 Turcocke, Robert, of Somerton, husbandman 0
4371852 2154995 2154995 defendant Major alias Buckland Erasmus husbandman 588135 588135 Major alias Buckland, Erasmus, of Somerton, or of Toller Porcorum, Dorset, husbandman 0
4416198 2169951 2169951 defendant Sutton William de   588135 588135 Sutton, William de, of Somerton 0
4453550 2186120 2186120 defendant Bental Walter   588135 588135 Bental, Walter, of Somerton 0
4462075 2188839 2188839 defendant Craan Robert   588135 588135 Craan, Robert, of Somerton 0
4468565 2190837 2190837 defendant Tuttebury John   588135 588135 Tuttebury, John, of Somerton 0
4480657 2194616 2194616 defendant Rifton John   588135 588135 Rifton, John, of Somerton 0
4487838 2196911 2196911 defendant Tuttebury John   588135 588135 Tuttebury, John, of Somerton 0
4487839 2196911 2196911 defendant Hobbes Richard   588135 588135 Hobbes, Richard, of Somerton, vicar 1
4493785 2198749 2198749 defendant Tuttebury John   588135 588135 Tuttebury, John, of Somerton 0
4511539 2204057 2204057 defendant Aston Richard   588135 588135 Aston, Richard, of Somerton 0
4511541 2204058 2204058 defendant Aston Richard   588135 588135 Aston, Richard, of Somerton 0
4513793 2204740 2204740 defendant Leverhych Walter   588135 588135 Leverhych, Walter, of Somerton 1
4545757 2214599 2214599 defendant Bevyn William   588135 588135 Bevyn, William, of Somerton 0
4545758 2214599 2214599 defendant Dygon Richard   588135 588135 Dygon, Richard, of Somerton 1
4557941 2218413 2218413 defendant Dygon Richard   588135 588135 Dygon, Richard, of Somerton 0
4568203 2221627 2221627 defendant Sutton John, sen   588135 588135 Sutton, John, sen, of Somerton 0
4568205 2221627 2221627 defendant Sherp William   588135 588135 Sherp, William, of Somerton 2
4568206 2221627 2221627 defendant Saleweye Philip   588135 588135 Saleweye, Philip, of Somerton 3
4568207 2221627 2221627 defendant Keneman John   588135 588135 Keneman, John, of Somerton 4
4568208 2221627 2221627 defendant Bons or Bous John   588135 588135 Bons or Bous, John, of Somerton 5
4571693 2222725 2222725 defendant Sherp William   588135 588135 Sherp, William, of Somerton 0
4573053 2223108 2223108 plaintiff Bakere Thomas   588135 588135 Bakere, Thomas, of Somerton 0
4573607 2223261 2223261 defendant Aston Richard   588135 588135 Aston, Richard, of Somerton 0
4573608 2223261 2223261 defendant Wattes John   588135 588135 Wattes, John, of Somerton 1

Next page

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