names

127 rows where place_id = 586446

✎ 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
3588743 1864123 1864123 defendant Godyng John yeoman 586446 586446 Godyng, John, of Hadlo, yeoman 0
3606168 1869599 1869599 defendant Kebyll Richard yeoman 586446 586446 Kebyll, Richard, of Hadlo, yeoman 1
3611357 1871225 1871225 defendant Heccher Reginald husbandman 586446 586446 Heccher, Reginald, of Hadlo, husbandman 0
3740465 1938875 1938875 defendant Style Walter husbandman 586446 586446 Style, Walter, of Hadlo, husbandman 0
3997532 2023867 2023867 defendant Newman Thomas, junior butcher 586446 586446 Newman, Thomas, junior, of Hadlo, butcher 1
4461738 2188733 2188733 defendant Pecham John   586446 586446 Pecham, John, of Hadlo 0
4487909 2196939 2196939 defendant Palmer Nicholas   586446 586446 Palmer, Nicholas, of Hadlo 0
4561286 2219482 2219482 plaintiff Parrok William   586446 586446 Parrok, William, of Hadlo 0
4572782 2223024 2223024 defendant Brodhet Richard   586446 586446 Brodhet, Richard, of Hadlo 0
4596866 2230258 2230258 defendant Brodet Richard butcher 586446 586446 Brodet, Richard, of Hadlo, butcher 0
4602205 2231908 2231908 defendant Lenman John   586446 586446 Lenman, John, of Hadlo 0
4604967 2232714 2232714 defendant Bouryng Robert   586446 586446 Bouryng, Robert, of Hadlo 0
4604968 2232714 2232714 defendant Brodet Richard   586446 586446 Brodet, Richard, of Hadlo 1
4607640 2233499 2233499 defendant Gwodyng William   586446 586446 Gwodyng, William, of Hadlo 0
4612167 2234872 2234872 plaintiff Corch Thomas (legal representative) 586446 586446 Corch, Thomas, of Hadlo, executor of 0
4612169 2234872 2234872 defendant Hardyng Gilbert   586446 586446 Hardyng, Gilbert, of Hadlo 0
4612274 2234904 2234904 plaintiff Corth or Corch Thomas (legal representative) 586446 586446 Corth or Corch, Thomas, of Hadlo, executor of 0
4612276 2234904 2234904 defendant Hardyng Gilbert   586446 586446 Hardyng, Gilbert, of Hadlo 0
4613947 2235375 2235375 plaintiff Deye Thomas   586446 586446 Deye, Thomas, of Hadlo 0
4637044 2242392 2242392 defendant Gwodyng William   586446 586446 Gwodyng, William, of Hadlo 0
4651988 2246556 2246556 defendant Boweryng John husbandman 586446 586446 Boweryng, John, of Hadlo, husbandman 0
4651990 2246557 2246557 defendant Boweryng Robert husbandman 586446 586446 Boweryng, Robert, of Hadlo, husbandman 0
4651992 2246558 2246558 defendant Boweryng Robert husbandman 586446 586446 Boweryng, Robert, of Hadlo, husbandman 0
4654144 2247179 2247179 defendant Bysshopp Robert husbandman 586446 586446 Bysshopp, Robert, of Hadlo, husbandman 0
4654145 2247179 2247179 defendant Bysshopp William farmer 586446 586446 Bysshopp, William, of Hadlo, farmer 1
4657820 2248333 2248333 defendant Bouryng John husbandman 586446 586446 Bouryng, John, of Hadlo, husbandman 2
4657821 2248333 2248333 defendant Bouryng Richard husbandman 586446 586446 Bouryng, Richard, of Hadlo, husbandman 3
4657822 2248333 2248333 defendant Belde Richard husbandman 586446 586446 Belde, Richard, of Hadlo, husbandman 4
4657824 2248334 2248334 defendant Nepecre John laborer 586446 586446 Nepecre, John, of Hadlo, laborer 0
4657825 2248334 2248334 defendant Burdon Richard farmer 586446 586446 together with Burdon, Richard, of Hadlo, farmer 1
4683287 2260377 2260377 defendant Tyrell Simon miller 586446 586446 Tyrell, Simon, of Hadlo, miller 0
4722540 2272364 2272364 plaintiff Botiller Thomas   586446 586446 Botiller, Thomas, of Hadlo, vicar 1
4752527 2281197 2281197 defendant Calche John milner 586446 586446 Calche, John, of Hadlo, milner 1
4778571 2289282 2289282 defendant Daunce John   586446 586446 Daunce, John, of Hadlo, bailiff 0
4792217 2293655 2293655 defendant Palmer Hugh carpenter 586446 586446 Palmer, Hugh, of Hadlo, carpenter 1
4805031 2297779 2297779 defendant Daunce John husbandman 586446 586446 Daunce, John, of Hadlo, husbandman 0
4814572 2300668 2300668 defendant Broghton William   586446 586446 Broghton, William, of Hadlo, vicar 0
4816944 2301401 2301401 defendant Burdon Richard husbandman 586446 586446 Burdon, Richard, of Hadlo, husbandman 0
4818934 2302007 2302007 plaintiff Parrok William (legal representative) 586446 586446 Parrok, William, of Hadlo, executors of 0
4818937 2302007 2302007 defendant Stoperyshelde Nicholas   586446 586446 Stoperyshelde, Nicholas, of Hadlo, parish clerk 0
4818938 2302007 2302007 defendant Belde William laborer 586446 586446 Belde, William, of Hadlo, laborer 1
4818939 2302007 2302007 defendant Grene Ralph laborer 586446 586446 Grene, Ralph, of Hadlo, laborer 2
4818940 2302007 2302007 defendant Belde John husbandman 586446 586446 Belde, John, of Hadlo, husbandman 3
4818941 2302007 2302007 defendant Palmere John carpenter 586446 586446 Palmere, John, of Hadlo, carpenter 4
4821533 2302820 2302820 defendant Daunce John husbandman 586446 586446 Daunce, John, of Hadlo, husbandman 0
4821534 2302820 2302820 defendant Neweman Gilbert husbandman 586446 586446 Neweman, Gilbert, of Hadlo, husbandman 1
4847761 2310790 2310790 defendant Daunce John husbandman 586446 586446 Daunce, John, of Hadlo, husbandman 0
4868282 2317056 2317056 defendant Colman John butcher 586446 586446 Colman, John, of Hadlo, butcher 0
4868283 2317056 2317056 defendant Barbour William barber 586446 586446 Barbour, William, of Hadlo, barber 1
4868285 2317057 2317057 defendant Hambrigale William loader 586446 586446 Hambrigale, William, of Hadlo, loader 0
4877757 2320005 2320005 defendant Byklyng Walter husbandman 586446 586446 Byklyng, Walter, of Hadlo, husbandman 0
4893791 2324753 2324753 defendant Nepacre Andrew husbandman 586446 586446 Nepacre, Andrew, of Hadlo, husbandman 0
4906840 2328724 2328724 defendant Sherrue Gilbert husbandman 586446 586446 Sherrue, Gilbert, of Hadlo, husbandman 0
4917854 2332095 2332095 defendant Frutour alias Chalton Stephen husbandman 586446 586446 Frutour alias Chalton, Stephen, of Hadlo, husbandman 1
4938734 2338502 2338502 defendant Reynold Thomas husbandman 586446 586446 Reynold, Thomas, of Hadlo, husbandman 0
4942711 2339691 2339691 defendant Fromond Gilbert husbandman 586446 586446 Fromond, Gilbert, of Hadlo, husbandman 0
4942714 2339691 2339691 defendant Sandherst Richard butcher 586446 586446 Sandherst, Richard, of Hadlo, butcher 3
4963239 2345913 2345913 defendant Beeld John husbandman 586446 586446 Beeld, John, of Hadlo, husbandman 0
4967538 2347234 2347234 plaintiff Farman Lawrence   586446 586446 Farman, Lawrence, of Hadlo 0
4971632 2348444 2348444 defendant Palmer John carpenter 586446 586446 Palmer, John, of Hadlo, carpenter 1
4971633 2348444 2348444 defendant Penyale Nicholas weaver 586446 586446 Penyale, Nicholas, of Hadlo, weaver 2
4971634 2348444 2348444 defendant Fromond atte Water John husbandman 586446 586446 Fromond atte Water, John, of Hadlo, husbandman 3
4971635 2348444 2348444 defendant Andrewe John   586446 586446 Andrewe, John, of Hadlo, servant 4
4971636 2348444 2348444 defendant Burgeys Walter husbandman 586446 586446 Burgeys, Walter, of Hadlo, husbandman 5
5001678 2357385 2357385 defendant Salman William cooper 586446 586446 Salman, William, of Hadlo, cooper 0
5005129 2358396 2358396 defendant Blyklyng Walter gent 586446 586446 Blyklyng, Walter, of Hadlo, gent 0
5054327 2372874 2372874 defendant Fadyr William fuller 586446 586446 Fadyr, William, of Hadlo, fuller 0
5054329 2372874 2372874 defendant Burdon Thomas rypyer or fishmonger 586446 586446 Burdon, Thomas, of Hadlo, rypyer or fishmonger 2
5073902 2378686 2378686 defendant Bordon William husbandman 586446 586446 Bordon, William, of Hadlo, husbandman 2
5086584 2382467 2382467 defendant Shode Richard (legal representative) 586446 586446 Shode, Richard, of Hadlo, administratrix of 3
5086585 2382467 2382467 defendant Shode Joan widow 586446 586446 Shode, Joan, of Hadlo, widow 4
5127240 2394444 2394444 defendant Andrewe John weaver 586446 586446 Andrewe, John, of Hadlo, weaver 0
5133272 2396217 2396217 plaintiff Houghlet Henry laborer 586446 586446 Houghlet, Henry, of Hadlo, laborer 0
5216789 2420651 2420651 defendant Symond John miller 586446 586446 Symond, John, of Hadlo, miller 0
5220897 2421806 2421806 defendant Stoperfeld Nicholas husbandman 586446 586446 Stoperfeld, Nicholas, of Hadlo, husbandman 0
5222000 2422138 2422138 defendant Godyng John yeoman 586446 586446 Godyng, John, of Hadlo, yeoman 0
5224631 2422876 2422876 defendant Mayne John, senior fuller 586446 586446 Mayne, John, senior, of Hadlo, fuller 0
5224634 2422876 2422876 defendant Stoperfild Nicholas husbandman 586446 586446 Stoperfild, Nicholas, of Hadlo, husbandman 3
5249037 2429842 2429842 defendant Symond alias Meller John husbandman 586446 586446 Symond alias Meller, John, of Hadlo, husbandman 1
5250683 2430323 2430323 defendant Godyng John husbandman 586446 586446 Godyng, John, of Hadlo, husbandman 0
5250985 2430415 2430415 defendant Fareman Lawrence tanner 586446 586446 Fareman, Lawrence, of Hadlo, tanner 0
5252068 2430754 2430754 defendant Tuysnothe Thomas husbandman 586446 586446 Tuysnothe, Thomas, of Hadlo, husbandman 0
5256572 2432175 2432175 defendant Enge John husbandman 586446 586446 Enge, John, of Hadlo, husbandman 1
5262783 2434102 2434102 defendant Godyng John yeoman 586446 586446 Godyng, John, of Hadlo, yeoman 0
5262785 2434103 2434103 defendant Godyng John yeoman 586446 586446 Godyng, John, of Hadlo, yeoman 0
5267403 2435569 2435569 defendant Fareman Lawrence tanner 586446 586446 Fareman, Lawrence, of Hadlo, tanner 0
5269633 2436229 2436229 defendant Godyng John yeoman 586446 586446 Godyng, John, of Hadlo, yeoman 0
5269634 2436229 2436229 defendant Gremond Gilbert husbandman 586446 586446 Gremond, Gilbert, of Hadlo, husbandman 1
5269635 2436229 2436229 defendant Fremond Richard yeoman 586446 586446 Fremond, Richard, of Hadlo, yeoman 2
5278322 2438762 2438762 defendant Welsshe John husbandman 586446 586446 Welsshe, John, of Hadlo, husbandman 0
5278323 2438762 2438762 defendant Symond John, junior laborer 586446 586446 Symond, John, junior, of Hadlo, laborer 1
5280671 2439420 2439420 defendant Tusnoth Thomas laborer 586446 586446 Tusnoth, Thomas, of Hadlo, laborer 3
5281022 2439527 2439527 defendant Fromond Richard yeoman 586446 586446 Fromond, Richard, of Hadlo, yeoman 0
5281023 2439527 2439527 defendant Godyng John yeoman 586446 586446 Godyng, John, of Hadlo, yeoman 1
5281024 2439527 2439527 defendant Fromond Gilbert husbandman 586446 586446 Fromond, Gilbert, of Hadlo, husbandman 2
5282875 2440051 2440051 defendant Symon John husbandman 586446 586446 Symon, John, of Hadlo, husbandman 1
5291307 2442461 2442461 defendant Godyng John yeoman 586446 586446 Godyng, John, of Hadlo, yeoman 0
5294518 2443373 2443373 defendant Symond John, senior husbandman 586446 586446 Symond, John, senior, of Hadlo, husbandman 0
5298982 2444684 2444684 defendant Tusnoth Thomas husbandman 586446 586446 Tusnoth, Thomas, of Hadlo, husbandman 0
5298983 2444684 2444684 defendant Stpersfeld Nicholas husbandman 586446 586446 Stpersfeld, Nicholas, of Hadlo, husbandman 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);