names

96 rows where place_id = 592005

✎ 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
3606285 1869634 1869634 defendant Fynche John husbandman 592005 592005 Fynche, John, of Mendham, Suff, husbandman 0
3606391 1869666 1869666 defendant Fynche John husbandman 592005 592005 Fynche, John, of Mendham, Suff, husbandman 0
3622449 1874557 1874557 defendant Spark William husbandman 592005 592005 Spark, William, of Mendham, Suff, husbandman 1
3638753 1906938 1906938 defendant Weston Geoffrey husbandman 592005 592005 Weston, Geoffrey, of Mendham, Suff, husbandman 0
3659073 1913101 1913101 defendant Kyngessey Robert yeoman 592005 592005 Kyngessey, Robert, of Mendham, Suff, yeoman 1
3661391 1913837 1913837 defendant Baret John yeoman 592005 592005 Baret, John, of Mendham, Suff, yeoman 0
3679576 1919681 1919681 defendant Kyngsey Robert yeoman 592005 592005 Kyngsey, Robert, of Mendham, Suff, yeoman 0
3739229 1938489 1938489 defendant Payne Robert yeoman 592005 592005 Payne, Robert, of Mendham, Suff, yeoman 2
3749242 1941689 1941689 defendant Bullok John butcher 592005 592005 Bullok, John, of Mendham, Suff, butcher 0
3751838 1942492 1942492 defendant Whyte John clerk 592005 592005 Whyte, John, of Mendham, Suff, clerk 1
3797616 1957151 1957151 defendant Chamber John yeoman 592005 592005 Chamber, John, of Mendham, Suff, yeoman 0
3859135 1976543 1976543 defendant Ryall Robert smith 592005 592005 Ryall, Robert, of Mendham, Suff, smith 0
3887119 1985956 1985956 defendant Dogett Robert butcher 592005 592005 Dogett, Robert, of Mendham, Suff, butcher 0
3934404 2001800 2001800 defendant Payne William chapman 592005 592005 Payne, William, of Mendham, Suff, chapman 1
3971737 2014676 2014676 defendant Skott William husbandman 592005 592005 Skott, William, of Mendham, Suff, husbandman 1
3972252 2014857 2014857 defendant Wentworth Thomas gent 592005 592005 Wentworth, Thomas, of Mendham, Suff, gent 0
3972256 2014859 2014859 defendant Wentworth Thomas gent 592005 592005 Wentworth, Thomas, of Mendham, Suff, gent 0
4140432 2074822 2074822 defendant Haton or Heyton James yeoman 592005 592005 Haton or Heyton, James, of Mendham, Suff, yeoman 0
4172161 2085723 2085723 defendant Meane John yeoman 592005 592005 Meane, John, of Mendham, Suff, yeoman 0
4218443 2101951 2101951 defendant Hayward Christopher baker 592005 592005 Hayward, Christopher, of Mendham, Suff, baker 1
4244664 2111200 2111200 defendant Haywarde Christopher baker 592005 592005 Haywarde, Christopher, of Mendham, Suff, baker 1
4244666 2111200 2111200 defendant Barbor John tailor 592005 592005 Barbor, John, of Mendham, Suff, tailor 3
4275328 2121304 2121304 defendant Hering Alice widow 592005 592005 Hering, Alice, of Mendham, Suff, widow 1
4278158 2122296 2122296 defendant Smyth Richard gent 592005 592005 Smyth, Richard, of Mendham, Suff, gent 0
4288732 2126027 2126027 defendant Smyth Richard gent 592005 592005 Smyth, Richard, of Mendham, Suff, gent 0
4289254 2126213 2126213 defendant Harper William cooper 592005 592005 Harper, William, of Mendham, Suff, cooper 3
4316976 2136052 2136052 defendant Sowthwell Miles gent 592005 592005 Sowthwell, Miles, of Mendham, Suff, gent 3
4316994 2136056 2136056 defendant Huddinge John tailor 592005 592005 Huddinge, John, of Mendham, Suff, tailor 2
4340925 2144101 2144101 defendant Southwell Miles gent 592005 592005 Southwell, Miles, of Mendham, Suff, gent 2
4347122 2146250 2146250 defendant Southwell Miles gent 592005 592005 Southwell, Miles, of Mendham, Suff, gent 0
4351452 2147759 2147759 defendant Sowthwell Miles gent 592005 592005 Sowthwell, Miles, of Mendham, Suff, gent 1
4354100 2148660 2148660 defendant Harvy Joan widow 592005 592005 Harvy, Joan, of Mendham, Suff, widow 0
4364631 2152407 2152407 defendant Southwell Miles esq 592005 592005 Southwell, Miles, of Mendham, Suff, esq 0
4383691 2159254 2159254 defendant Toplyfe John laborer 592005 592005 Toplyfe, John, of Mendham, Suff, laborer 1
4386173 2160055 2160055 defendant Heryng John yeoman 592005 592005 Heryng, John, of Mendham, Suff, yeoman 0
4386940 2160294 2160294 defendant Southwell Miles gent 592005 592005 Southwell, Miles, of Mendham, Suff, or of Wymondham, gent 0
4386980 2160301 2160301 defendant Southwell Miles esq 592005 592005 Southwell, Miles, of Mendham, Suff, gent, or of Wymondham, esq 0
4391527 2161779 2161779 defendant Southwell Miles esq 592005 592005 Southwell, Miles, of Mendham, Suff, esq 0
4392952 2162255 2162255 defendant Botewright Keremy butcher 592005 592005 Botewright, Keremy, of Mendham, Suff, butcher 2
4395603 2163114 2163114 defendant Flatman Peter   592005 592005 Flatman, Peter, of mendham, Suff, mason 3
4408159 2167298 2167298 defendant Fenne Daniel yeoman 592005 592005 Fenne, Daniel, of Mendham, Suff, yeoman, yeoman 2
4412260 2168690 2168690 defendant Turner William husbandman 592005 592005 Turner, William, of Mendham, Suff, husbandman 1
4663831 2250171 2250171 defendant Fynche Richard dyer 592005 592005 Fynche, Richard, of Mendham, Suff, dyer 3
4750118 2280508 2280508 defendant Gardener Richard   592005 592005 Gardener, Richard, of Mendham, Suff, holy water clerk 0
4750426 2280604 2280604 defendant Cokerell John yeoman 592005 592005 Cokerell, John, of Mendham, Suff, yeoman 3
4817075 2301438 2301438 defendant Couper John clerk 592005 592005 Couper, John, of Mendham, Suff, clerk 0
4826378 2304290 2304290 defendant Couper John clerk 592005 592005 Couper, John, of Mendham, Suff, clerk 0
4826383 2304291 2304291 defendant Couper John clerk 592005 592005 Couper, John, of Mendham, Suff, clerk 0
4826388 2304292 2304292 defendant Couper John clerk 592005 592005 Couper, John, of Mendham, Suff, clerk 0
4826393 2304293 2304293 defendant Couper John clerk 592005 592005 Couper, John, of Mendham, Suff, clerk 0
5010374 2359902 2359902 defendant Mey William   592005 592005 Mey, William, of Mendham, Suff, servant 1
5010377 2359902 2359902 defendant Jekkes John   592005 592005 Jekkes, John, of Mendham, Suff, servant 4
5070253 2377596 2377596 defendant Skutte Edmund husbandman 592005 592005 Skutte, Edmund, of Mendham, Suff, husbandman 0
5144615 2399583 2399583 defendant Scutte John yeoman 592005 592005 Scutte, John, of Mendham, Suff, yeoman 1
5216521 2420560 2420560 defendant mainpernors for Skutte Edmund husbandman 592005 592005 mainpernors for Skutte, Edmund, of Mendham, Suff, husbandman 2
5261773 2433792 2433792 plaintiff Morrse John   592005 592005 Morrse, John, of Mendham, Suff 0
5273615 2437358 2437358 plaintiff Mors John   592005 592005 Mors, John, of Mendham, Suff 0
5282084 2439834 2439834 defendant Floure William butcher 592005 592005 Floure, William, of Mendham, Suff, butcher 0
5282139 2439847 2439847 defendant Mors John tiler 592005 592005 Mors, John, of Mendham, Suff, tiler 1
5282150 2439848 2439848 defendant Mors John tiler 592005 592005 Mors, John, of Mendham, Suff, tiler 1
5296824 2444061 2444061 defendant Dory Thomas yeoman 592005 592005 Dory, Thomas, of Mendham, Suff, yeoman 0
5318723 2450690 2450690 defendant Fynche John yeoman 592005 592005 Fynche, John, of Mendham, Suff, yeoman 0
5331823 2454597 2454597 defendant Medilton Robert gent 592005 592005 Medilton, Robert, of Mendham, Suff, gent 0
5350712 2460334 2460334 defendant Medylton Robert gent 592005 592005 Medylton, Robert, of Mendham, Suff, gent 0
5350717 2460335 2460335 defendant Medylton Robert gent 592005 592005 Medylton, Robert, of Mendham, Suff, gent 0
5365848 2464973 2464973 defendant Underwode Thomas husbandman 592005 592005 Underwode, Thomas, of Mendham, Suff, husbandman 0
5365850 2464973 2464973 defendant Neche John husbandman 592005 592005 Neche, John, of Mendham, Suff, husbandman 2
5369850 2466160 2466160 defendant Underwode Robert (legal representative) 592005 592005 Underwode, Robert, of Mendham, Suff, husbandman, administrator of 4
5369851 2466160 2466160 defendant Underwode Thomas husbandman 592005 592005 Underwode, Thomas, of Mendham, Suff, husbandman 5
5369857 2466161 2466161 defendant Underwode Robert (legal representative) 592005 592005 Underwode, Robert, of Mendham, Suff, husbandman, administrator of 4
5369858 2466161 2466161 defendant Underwode Thomas husbandman 592005 592005 Underwode, Thomas, of Mendham, Suff, husbandman 5
5370974 2466509 2466509 defendant Medylton Robert gent 592005 592005 Medylton, Robert, of Mendham, Suff, gent 2
5381194 2469678 2469678 plaintiff Gandy John yeoman 592005 592005 Gandy, John, of Mendham, Suff, yeoman 0
5381195 2469678 2469678 defendant Underwode Thomas husbandman 592005 592005 Underwode, Thomas, of Mendham, Suff, husbandman 0
5382907 2470177 2470177 defendant Underwode Thomas husbandman 592005 592005 Underwode, Thomas, of Mendham, Suff, husbandman 2
5393789 2473282 2473282 defendant Underwode Thomas husbandman 592005 592005 Underwode, Thomas, of Mendham, Suff, husbandman 2
5400334 2475171 2475171 defendant Middelton Robert gent 592005 592005 Middelton, Robert, of Mendham, Suff, gent 6
5400542 2475221 2475221 plaintiff Gandy or Gaudy John yeoman 592005 592005 Gandy or Gaudy, John, of Mendham, Suff, yeoman 0
5400543 2475221 2475221 defendant Underwode (illegible) husbandman 592005 592005 Underwode, -----, of Mendham, Suff, husbandman 0
5406984 2477059 2477059 defendant Unersode Thomas husbandman 592005 592005 Unersode, Thomas, of Mendham, Suff, husbandman 2
5413329 2478917 2478917 defendant Middelton Robert gent 592005 592005 Middelton, Robert, of Mendham, Suff, gent 6
5413553 2478976 2478976 plaintiff Gandy John yeoman 592005 592005 Gandy, John, of Mendham, Suff, yeoman 0
5420174 2480952 2480952 defendant Underwode Thomas husbandman 592005 592005 Underwode, Thomas, of Mendham, Suff, husbandman 0
5428523 2483458 2483458 defendant Flour William husbandman 592005 592005 Flour, William, of Mendham, Suff, husbandman 7
5428531 2483459 2483459 defendant Middelton Robert gent 592005 592005 Middelton, Robert, of Mendham, Suff, gent 6
5444657 2488303 2488303 defendant Medylton Robert gent 592005 592005 Medylton, Robert, of Mendham, Suff, gent 0
5445838 2488644 2488644 defendant Flour William husbandman 592005 592005 Flour, William, of Mendham, Suff, husbandman 6
5457092 2492021 2492021 defendant Medylton Robert gent 592005 592005 Medylton, Robert, of Mendham, Suff, gent 0
5468974 2495645 2495645 defendant Medylton Robert gent 592005 592005 Medylton, Robert, of Mendham, Suff, gent 0
5470322 2496047 2496047 plaintiff Gandy John yeoman 592005 592005 Gandy, John, of Mendham, Suff, yeoman 0
5480102 2499035 2499035 defendant Medylton Robert gent 592005 592005 Medylton, Robert, of Mendham, Suff, gent 0
5493223 2502882 2502882 defendant Flowre William yeoman 592005 592005 Flowre, William, of Mendham, Suff, yeoman 0
5538453 2516509 2516509 defendant Weston William husbandman 592005 592005 Weston, William, of Mendham, Suff, husbandman 2
5544138 2518281 2518281 defendant Stonley John husbandman 592005 592005 Stonley, John, of Mendham, Suff, husbandman 3
5558150 2522334 2522334 defendant Medylton Thomas gent 592005 592005 Medylton, Thomas, of Mendham, Suff, gent 0
5596200 2533727 2533727 defendant Kynessey Robert husbandman 592005 592005 Kynessey, Robert, of Mendham, Suff, husbandman 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);