names

74 rows where place_id = 587820

✎ 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
3592529 1865279 1865279 defendant Wetyng Robert yeoman 587820 587820 Wetyng, Robert, of Leystoft, Suff, yeoman 0
3592899 1865397 1865397 defendant Hyns Alice widow 587820 587820 Hyns, Alice, of Leystoft, Suff, widow 0
3607667 1870052 1870052 defendant Hervy Thomas gent 587820 587820 Hervy, Thomas, of Leystoft, Suff, gent 1
3636376 1906166 1906166 defendant Bonere Thomas mercer 587820 587820 Bonere, Thomas, of Leystoft, Suff, mercer 1
3669369 1916357 1916357 defendant Saxmendham John   587820 587820 Saxmendham, John, of Leystoft, Suff, yeoman, administrators of 0
3669370 1916357 1916357 defendant Denne Ralph tailor 587820 587820 (Denne, Ralph, of Leystoft, Suff, tailor 1
3690655 1923242 1923242 defendant Barker John smith 587820 587820 Barker, John, of Leystoft, Suff, smith 0
3691782 1923590 1923590 defendant Dene Ralph merchant 587820 587820 Dene, Ralph, of Leystoft, Suff, merchant 0
3700364 1926351 1926351 defendant Palmer John gent 587820 587820 Palmer, John, of Leystoft, Suff, gent 1
3723401 1933587 1933587 defendant Mordoke Robert yeoman 587820 587820 Mordoke, Robert, of Leystoft, Suff, yeoman 0
3749740 1941828 1941828 defendant Ovy Theodore grocer 587820 587820 Ovy, Theodore, of Leystoft, Suff, grocer 0
3785981 1953411 1953411 defendant Everard John fisherman 587820 587820 Everard, John, of Leystoft, Suff, fisherman 1
3789140 1954413 1954413 defendant Palmer John merchant 587820 587820 Palmer, John, of Leystoft, Suff, merchant 2
3820839 1964409 1964409 defendant Styward Roland husbandman 587820 587820 Styward, Roland, of Leystoft, Suff, husbandman 1
3840103 1970477 1970477 defendant Jetter John merchant 587820 587820 Jetter, John, of Leystoft, Suff, merchant 0
3851281 1973998 1973998 defendant Broun John clerk 587820 587820 Broun, John, of Leystoft, Suff, clerk 0
3861078 1977188 1977188 defendant Bull Simon husbandman 587820 587820 Bull, Simon, of Leystoft, Suff, husbandman 0
3866035 1978871 1978871 defendant Jetour John merchant 587820 587820 Jetour, John, of Leystoft, Suff, merchant 0
3866037 1978872 1978872 defendant Jetour John merchant 587820 587820 Jetour, John, of Leystoft, Suff, merchant 0
3871971 1980860 1980860 defendant Bulle Simon husbandman 587820 587820 Bulle, Simon, of Leystoft, Suff, husbandman 0
3871973 1980861 1980861 defendant Bulle Simon husbandman 587820 587820 Bulle, Simon, of Leystoft, Suff, husbandman 0
3873754 1981442 1981442 defendant Rutte John baker 587820 587820 Rutte, John, of Leystoft, Suff, baker 0
3892868 1987862 1987862 defendant Rowght John yeoman 587820 587820 Rowght, John, of Leystoft, Suff, yeoman 0
3913448 1994835 1994835 defendant Rough John yeoman 587820 587820 Rough, John, of Leystoft, Suff, yeoman 4
3969270 2013859 2013859 plaintiff Cook Henry (legal representative) 587820 587820 Cook, Henry, of Leystoft, Suff, draper, executor of John Storke, of Harleston, sherman, administrators of 0
3984237 2019131 2019131 defendant Itchyngham Edward gent 587820 587820 Itchyngham, Edward, of Leystoft, Suff, gent 0
4082767 2054141 2054141 defendant Gooche Robert yeoman 587820 587820 Gooche, Robert, of Leystoft, Suff, yeoman 1
4752041 2281087 2281087 defendant Burughard James yeoman 587820 587820 Burughard, James, of Leystoft, Suff, yeoman 4
4795802 2294836 2294836 defendant Edward Henry yeoman 587820 587820 Edward, Henry, of Leystoft, Suff, yeoman 0
4801589 2296681 2296681 defendant Talyour or Taylour William tailor 587820 587820 Talyour or Taylour, William, of Leystoft, Suff, tailor 0
4805153 2297812 2297812 defendant Huntman Stephen cooper 587820 587820 Huntman, Stephen, of Leystoft, Suff, cooper 0
4805540 2297947 2297947 defendant Gybbersson Thomas yeoman 587820 587820 Gybbersson, Thomas, of Leystoft, Suff, yeoman 0
4883327 2321709 2321709 defendant Stengate Henry roper 587820 587820 Stengate, Henry, of Leystoft, Suff, roper 1
4883487 2321752 2321752 defendant Childerhowns John chapman 587820 587820 Childerhowns, John, of Leystoft, Suff, chapman 2
4889154 2323396 2323396 defendant Stengate Henry roper 587820 587820 Stengate, Henry, of Leystoft, Suff, roper 1
4889808 2323603 2323603 defendant Childerhowns John chapman 587820 587820 Childerhowns, John, of Leystoft, Suff, chapman 4
4903040 2327565 2327565 defendant Boof John gent 587820 587820 Boof, John, of Leystoft, Suff, gent 0
4911766 2330180 2330180 defendant Wryght John chapman 587820 587820 Wryght, John, of Leystoft, Suff, chapman 0
4921199 2333148 2333148 defendant Hert Willam   587820 587820 Hert, Willam, of Leystoft, Suff, notary 2
4930719 2336017 2336017 defendant Alman John merchant 587820 587820 Alman, John, of Leystoft, Suff, merchant 0
4934890 2337314 2337314 defendant Zymmes John yeoman 587820 587820 Zymmes, John, of Leystoft, Suff, yeoman 3
4937129 2337985 2337985 defendant Zymmys John yeoman 587820 587820 Zymmys, John, of Leystoft, Suff, yeoman 0
4949883 2341941 2341941 defendant Puttok Robert chapman 587820 587820 Puttok, Robert, of Leystoft, Suff, chapman 17
5030898 2365907 2365907 defendant Bery Richard hosier 587820 587820 Bery, Richard, of Leystoft, Suff, hosier 4
5031967 2366221 2366221 defendant Alman John yeoman 587820 587820 Alman, John, of Leystoft, Suff, yeoman 0
5071942 2378098 2378098 defendant Saly Edmund yeoman 587820 587820 Saly, Edmund, of Leystoft, Suff, yeoman 1
5074549 2378891 2378891 defendant Wright Thomas carpenter 587820 587820 Wright, Thomas, of Leystoft, Suff, carpenter 0
5075053 2379040 2379040 defendant Porter Clement butcher 587820 587820 Porter, Clement, of Leystoft, Suff, butcher 0
5079814 2380442 2380442 defendant Sterky Peter merchant 587820 587820 Sterky, Peter, of Leystoft, Suff, merchant 0
5079817 2380443 2380443 defendant Sterky Peter merchant 587820 587820 Sterky, Peter, of Leystoft, Suff, merchant 0
5081487 2380962 2380962 defendant Hatter Walter yeoman 587820 587820 Hatter, Walter, of Leystoft, Suff, yeoman 2
5084348 2381830 2381830 defendant Tyserd John yeoman 587820 587820 Tyserd, John, of Leystoft, Suff, yeoman 1
5084362 2381832 2381832 defendant Tyserd John yeoman 587820 587820 Tyserd, John, of Leystoft, Suff, yeoman 1
5120459 2392409 2392409 defendant Yemmes John shoemaker 587820 587820 Yemmes, John, of Leystoft, Suff, shoemaker 2
5125194 2393846 2393846 defendant Gibsone William merchant 587820 587820 Gibsone, William, of Leystoft, Suff, merchant 0
5143790 2399319 2399319 defendant Gibsone William merchant 587820 587820 Gibsone, William, of Leystoft, Suff, merchant 0
5164874 2405462 2405462 defendant Gibsone William merchant 587820 587820 Gibsone, William, of Leystoft, Suff, merchant 0
5225918 2423252 2423252 defendant Parker William yeoman 587820 587820 Parker, William,of Leystoft, Suff, yeoman 2
5261288 2433641 2433641 defendant Neweman John mariner 587820 587820 Neweman, John, of Leystoft, Suff, mariner 1
5267416 2435573 2435573 defendant Saxmondham William merchant 587820 587820 Saxmondham, William, of Leystoft, Suff, merchant 0
5280975 2439516 2439516 defendant Boof John gent 587820 587820 Boof, John, of Leystoft, Suff, gent 0
5296992 2444115 2444115 defendant Fleet Richard yeoman 587820 587820 Fleet, Richard, of Leystoft, Suff, yeoman 4
5400312 2475164 2475164 defendant Tomson John husbandman 587820 587820 Tomson, John, of Leystoft, suff, husbandman 2
5405530 2476660 2476660 defendant Wrasteler Everard smith 587820 587820 Wrasteler, Everard, of Leystoft, Suff, smith 2
5458719 2492498 2492498 defendant Reynold William yeoman 587820 587820 Reynold, William, of Leystoft, Suff, yeoman 1
5541590 2517479 2517479 defendant Calver or Calner John carpenter 587820 587820 (Calver or Calner, John, of Leystoft, Suff, carpenter 3
5541597 2517480 2517480 defendant Calver or Calner John carpenter 587820 587820 (Calver or Calner, John, of Leystoft, Suff, carpenter 3
5547842 2519385 2519385 defendant Gall Richard yeoman 587820 587820 Gall, Richard, of Leystoft, Suff, yeoman 0
5578695 2528399 2528399 defendant Denne Ralph tailor 587820 587820 Denne, Ralph, of Leystoft, Suff, tailor 0
5579791 2528759 2528759 defendant Galle William merchant 587820 587820 Galle, William, of Leystoft, Suff, merchant 1
5585920 2530649 2530649 defendant Fello William husbandman 587820 587820 Fello, William, of Leystoft, Suff, husbandman 1
5585923 2530650 2530650 defendant Tayllour Richard merchant 587820 587820 Tayllour, Richard, of Leystoft, Suff, merchant 1
5599596 2534764 2534764 defendant Dene Ralph yeoman 587820 587820 Dene, Ralph, of Leystoft, Suff, yeoman 0
5603340 2535934 2535934 defendant Felowe William yeoman 587820 587820 Felowe, William, of Leystoft, Suff, yeoman 1

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