names

89 rows where place_id = 588355

✎ 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
3592349 1865222 1865222 defendant Gore John (legal representative) 588355 588355 Gore, John, of South Elmham, Suff, brick maker, administratrix of 4
3594212 1865831 1865831 defendant Cotweyn Thomas husbandman 588355 588355 Cotweyn, Thomas, of South Elmham, Suff, husbandman 1
3602185 1868350 1868350 defendant Fuller William husbandman 588355 588355 Fuller, William, of South Elmham, Suff, husbandman 0
3602396 1868410 1868410 defendant Tasburgh John gent 588355 588355 Tasburgh, John, of South Elmham, Suff, gent 0
3605490 1869382 1869382 defendant Bateman William gent 588355 588355 Bateman, William, of South Elmham, Suff, gent 2
3617774 1873183 1873183 defendant Smyth John husbandman 588355 588355 Smyth, John, of South Elmham St Peter, Suff, husbandman 1
3619808 1873769 1873769 defendant Scarff William engraver 588355 588355 Scarff, William, of South Elmham, Suff, engraver 0
3631415 1904638 1904638 defendant Warde John husbandman 588355 588355 Warde, John, of South Elmham, Suff, husbandman 1
3647862 1909728 1909728 defendant Care Richard smith 588355 588355 Care, Richard, of South Elmham, Suff, smith 2
3731846 1936189 1936189 defendant Tasburgh John gent 588355 588355 Tasburgh, John, of South Elmham, Suff, gent 0
3740278 1938824 1938824 defendant Throkmorton Francis gent 588355 588355 Throkmorton, Francis, of South Elmham, Suff, gentAlcok, Robert, of London, gent 0
3803615 1959044 1959044 defendant Throgmerton Francis (legal representative) 588355 588355 Throgmerton, Francis, of South Elmham, Suff, gent, executrix of 0
3803911 1959136 1959136 defendant Throgmerton Francis (legal representative) 588355 588355 Throgmerton, Francis, of South Elmham, Suff, gent, executor of 0
4066907 2048462 2048462 plaintiff Huflett Thomas yeoman 588355 588355 Huflett, Thomas, of South Elmham St Peter, Suff, yeoman 0
4066909 2048463 2048463 plaintiff Huflett Thomas yeoman 588355 588355 Huflett, Thomas, of South Elmham St Peter, Suff, yeoman 0
4111873 2064496 2064496 defendant Leake John clerk 588355 588355 Leake, John, of South Elmham, Suff, clerk 2
4112103 2064585 2064585 defendant Leave John clerk 588355 588355 Leave, John, of South Elmham, Suff, clerk 2
4175038 2086735 2086735 defendant Bacon John gent 588355 588355 Bacon, John, of South Elmham, Suff, gent 3
4175778 2087001 2087001 defendant Owers George yeoman 588355 588355 Owers, George, of South Elmham, Suff, yeoman 0
4383690 2159254 2159254 defendant Bowler James yeoman 588355 588355 Bowler, James, of South Elmham, Suff, yeoman 0
4529915 2209646 2209646 defendant Olyver John esq 588355 588355 Olyver, John, of South Elmham, Suff, esq 1
4671007 2256602 2256602 defendant Bateman Robert esq 588355 588355 Bateman, Robert, of South Elmham, Suff, esq 1
4738445 2277114 2277114 defendant Dighton Richard yeoman 588355 588355 Dighton, Richard, of South Elmham, Suff, yeoman 1
4750425 2280604 2280604 defendant smyth Thomas yeoman 588355 588355 smyth, Thomas, of South Elmham, Suff, yeoman 2
4881512 2321120 2321120 defendant Bateman Robert esq 588355 588355 Bateman, Robert, of South Elmham, Suff, esq 0
4887206 2322840 2322840 defendant Wymere Walter gent 588355 588355 Wymere, Walter, of South Elmham, Suff, gent 6
4893587 2324696 2324696 defendant Thord Robert yeoman 588355 588355 Thord, Robert, of South Elmham, Suff, yeoman 0
4897769 2325968 2325968 defendant Wymer Walter gent 588355 588355 Wymer, Walter, of South Elmham, Suff, gent 6
4905190 2328220 2328220 defendant Wymere Walter gent 588355 588355 Wymere, Walter, of South Elmham, Suff, gent 5
5013103 2360661 2360661 defendant Smethes Roger yeoman 588355 588355 Smethes, Roger, of South Elmham, Suff, yeoman 1
5041322 2369013 2369013 defendant Dyton William yeoman 588355 588355 Dyton, William, of South Elmham, Suff, yeoman 0
5051839 2372165 2372165 defendant Robyns John clerk 588355 588355 Robyns, John, of South Elmham, Suff, clerk 0
5063041 2375480 2375480 defendant Pyke Richard yeoman 588355 588355 Pyke, Richard, of South Elmham, Suff, yeoman 0
5082064 2381130 2381130 defendant Baret John yeoman 588355 588355 Baret, John, of South Elmham, Suff, yeoman 2
5097299 2385642 2385642 plaintiff Tasburgh John   588355 588355 Tasburgh, John, of South Elmham, Suff 0
5101566 2386877 2386877 defendant Salter John butcher 588355 588355 Salter, John, of South Elmham St Peter, Suff, butcher 0
5112217 2389954 2389954 defendant Ederych John butcher 588355 588355 Ederych, John, of South Elmham, Suff, butcher 0
5124238 2393541 2393541 defendant Smethes Robert yeoman 588355 588355 Smethes, Robert, of South Elmham, Suff, yeoman 4
5138733 2397824 2397824 defendant Smethys John, senior yeoman 588355 588355 Smethys, John, senior, of South Elmham, Suff, yeoman 0
5138734 2397824 2397824 defendant Smethys John, junior yeoman 588355 588355 Smethys, John, junior, of South Elmham, Suff, yeoman 1
5156316 2403000 2403000 defendant Dyghton William yeoman 588355 588355 Dyghton, William, of South Elmham, Suff, yeoman 1
5192093 2413417 2413417 defendant Dyghton William   588355 588355 Dyghton, William, of South Elmham, Suff 1
5211082 2418968 2418968 defendant Sellyng Richard yeoman 588355 588355 Sellyng, Richard, of South Elmham, Suff, yeoman 5
5211086 2418969 2418969 defendant Sellyng Richard yeoman 588355 588355 Sellyng, Richard, of South Elmham, Suff, yeoman 2
5225417 2423111 2423111 defendant Dyghton William yeoman 588355 588355 Dyghton, William, of South Elmham, Suff, yeoman 0
5240480 2427429 2427429 defendant Pyke Richard yeoman 588355 588355 Pyke, Richard, of South Elmham, Suff, yeoman 1
5259457 2433081 2433081 defendant Gasburgh Thomas gent 588355 588355 Gasburgh, Thomas, of South Elmham, Suff, gent 0
5273946 2437459 2437459 defendant Taseburgh John, senior gent 588355 588355 Taseburgh, John, senior, of South Elmham, Suff, gent 0
5274895 2437743 2437743 defendant Toppesfeld Ralph gent 588355 588355 Toppesfeld, Ralph, of South Elmham, Suff, gent 0
5277433 2438479 2438479 defendant Folkard Thomas husbandman 588355 588355 Folkard, Thomas, of South Elmham, Suff, husbandman 0
5284835 2440580 2440580 defendant Erle Robert husbandman 588355 588355 Erle, Robert, of South Elmham, Suff, husbandman 11
5290399 2442195 2442195 defendant Toppesfeld Ralph esq 588355 588355 Toppesfeld, Ralph, of South Elmham, Suff, esq 0
5291866 2442626 2442626 defendant Tasburgh Thomas gent 588355 588355 Tasburgh, Thomas, of South Elmham, Suff, gent 2
5346847 2459170 2459170 defendant Toly Robert carpenter 588355 588355 Toly, Robert, of South Elmham, Suff, carpenter 1
5350713 2460334 2460334 defendant Pyke Richard yeoman 588355 588355 Pyke, Richard, of South Elmham, Suff, yeoman 1
5350718 2460335 2460335 defendant Pyke Richard yeoman 588355 588355 Pyke, Richard, of South Elmham, Suff, yeoman 1
5364592 2464587 2464587 defendant Barfote John husbandman 588355 588355 Barfote, John, of South Elmham, Suff, husbandman 0
5381440 2469753 2469753 defendant Leper Nicholas yeoman 588355 588355 Leper, Nicholas, of South Elmham, Suff, yeoman 2
5382906 2470177 2470177 defendant Taylour John husbandman 588355 588355 Taylour, John, of South Elmham, Suff, husbandman 1
5384201 2470568 2470568 defendant Brend Thomas husbandman 588355 588355 Brend, Thomas, of South Elmham, Suff, husbandman 3
5388408 2471735 2471735 defendant Tayllour John yeoman 588355 588355 Tayllour, John, of South Elmham, Suff, yeoman 0
5388800 2471858 2471858 defendant Leper Nicholas yeoman 588355 588355 Leper, Nicholas, of South Elmham, Suff, yeoman 0
5393788 2473282 2473282 defendant Turnour John husbandman 588355 588355 Turnour, John, of South Elmham, Suff, husbandman 1
5399231 2474849 2474849 defendant Brid Thomas husbandman 588355 588355 Brid, Thomas, of South Elmham, Suff, husbandman 3
5399506 2474938 2474938 defendant Taylour John yeoman 588355 588355 Taylour, John, of South Elmham, Suff, yeoman 0
5406743 2476995 2476995 defendant Bateman Robert gent 588355 588355 Bateman, Robert, of South Elmham, Suff, gent 0
5406983 2477059 2477059 defendant Tornour John husbandman 588355 588355 Tornour, John, of South Elmham, Suff, husbandman 1
5412511 2478689 2478689 defendant Taylour John yeoman 588355 588355 Taylour, John, of South Elmham, Suff, yeoman 0
5414023 2479132 2479132 defendant Tayllour John yeoman 588355 588355 Tayllour, John, of South Elmham, Suff, yeoman 0
5429576 2483784 2483784 defendant Tayllour John yeoman 588355 588355 Tayllour, John, of South Elmham, Suff, yeoman 0
5429586 2483785 2483785 defendant Tayllour John yeoman 588355 588355 together with Tayllour, John, of South Elmham, Suff, yeoman 3
5438908 2486559 2486559 defendant Brame John yeoman 588355 588355 Brame, John, of South Elmham, Suff, yeoman 2
5457093 2492021 2492021 defendant Pyke Richard yeoman 588355 588355 Pyke, Richard, of South Elmham, Suff, yeoman 1
5458319 2492385 2492385 defendant Brende Thomas husbandman 588355 588355 Brende, Thomas, of South Elmham, Suff, husbandman 5
5464713 2494360 2494360 defendant Brame John yeoman 588355 588355 Brame, John, of South Elmham, Suff, yeoman 2
5464724 2494363 2494363 defendant Brame John yeoman 588355 588355 Brame, John, of South Elmham, Suff, yeoman 1
5468975 2495645 2495645 defendant Pyke Richard yeoman 588355 588355 Pyke, Richard, of South Elmham, Suff, yeoman 1
5469956 2495938 2495938 defendant Brende Thomas husbandman 588355 588355 Brende, Thomas, of South Elmham, Suff, husbandman 4
5470113 2495974 2495974 defendant Brende Thomas husbandman 588355 588355 Brende, Thomas, of South Elmham, Suff, husbandman 5
5480103 2499035 2499035 defendant Pyke Richard yeoman 588355 588355 Pyke, Richard, of South Elmham, Suff, yeoman 1
5499521 2504803 2504803 defendant Elmy Thomas yeoman 588355 588355 Elmy, Thomas, of South Elmham, Suff, yeoman 0
5499529 2504806 2504806 defendant Lumhals Agnes widow 588355 588355 Lumhals, Agnes, of South Elmham, Suff, widow 0
5518020 2510479 2510479 defendant Turnour John yeoman 588355 588355 Turnour, John, of South Elmham, Suff, yeoman 0
5524141 2512323 2512323 defendant W- John yeoman 588355 588355 W-, John, of South Elmham, Suff, yeoman 2
5524202 2512329 2512329 defendant Watteson John yeoman 588355 588355 Watteson, John, of South Elmham, Suff, yeoman 1
5524215 2512330 2512330 defendant Watteson John yeoman 588355 588355 Watteson, John,of South Elmham, Suff, yeoman 1
5527292 2513114 2513114 defendant Pecke Robert butcher 588355 588355 Pecke, Robert,of South Elmham, Suff, butcher 0
5530031 2513901 2513901 defendant Tasburgh John gent 588355 588355 Tasburgh, John, of South Elmham, Suff, gent 0
5582121 2529476 2529476 defendant Auncell Isabel widow 588355 588355 Auncell, Isabel, of South Elmham, Suff, widow 4

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