names

145 rows where place_id = 590538

✎ 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
3601534 1868136 1868136 defendant Randolf Edmund husbandman 590538 590538 Randolf, Edmund, of Freton, husbandman 0
3632580 1905008 1905008 defendant Broun Robert husbandman 590538 590538 Broun, Robert, of Freton, husbandman 0
3740904 1939014 1939014 defendant Strawger Henry husbandman 590538 590538 Strawger, Henry, of Freton, husbandman 1
3754066 1943217 1943217 plaintiff Johnson William yeoman 590538 590538 Johnson, William, of Freton, yeoman 5
3788120 1954078 1954078 defendant Meke Thomas butcher 590538 590538 Meke, Thomas, of Freton, butcher 0
3804303 1959281 1959281 defendant Hewson William clerk 590538 590538 Hewson, William, of Freton, clerk 0
3805213 1959576 1959576 defendant Strowger Henry husbandman 590538 590538 Strowger, Henry, of Freton, husbandman 1
3936946 2002688 2002688 defendant Meeke William (legal representative) 590538 590538 Meeke, William, of Freton, husbandman, executrix of 0
3936947 2002688 2002688 defendant Meke Alice widow 590538 590538 Meke, Alice, of Freton, widow 1
3950589 2007277 2007277 defendant Goldsmyth Stephen yeoman 590538 590538 Goldsmyth, Stephen, of Freton, yeoman 0
3962743 2011555 2011555 defendant Collyson James clerk 590538 590538 Collyson, James, of Freton, clerk 0
3962745 2011556 2011556 defendant Collyson James clerk 590538 590538 Collyson, James, of Freton, clerk 0
4452975 2185937 2185937 defendant Clerk John   590538 590538 Clerk, John, of Freton 0
4460121 2188227 2188227 plaintiff Serrean Richard   590538 590538 Serrean, Richard, of Freton 0
4513538 2204657 2204657 defendant Py Pepter   590538 590538 Py, Pepter, of Freton 0
4518948 2206287 2206287 defendant Herman William   590538 590538 Herman, William, of Freton 2
4545755 2214598 2214598 defendant Sporle Thomas   590538 590538 Sporle, Thomas, of Freton, mason 2
4555475 2217647 2217647 defendant Smyth Adam   590538 590538 Smyth, Adam, of Freton 2
4580277 2225313 2225313 defendant Smyth Ralph   590538 590538 Smyth, Ralph, of Freton 1
4584359 2226521 2226521 defendant Jay Peter   590538 590538 Jay, Peter, of Freton 0
4584500 2226568 2226568 plaintiff Godewyn Edmund   590538 590538 Godewyn, Edmund, of Freton 0
4621385 2237681 2237681 defendant Bernard Stephen   590538 590538 Bernard, Stephen, of Freton 3
4621390 2237682 2237682 defendant Bernard Stephen   590538 590538 Bernard, Stephen, of Freton 3
4637811 2242598 2242598 defendant Jay Peter   590538 590538 Jay, Peter, of Freton 0
4637820 2242599 2242599 defendant Jay Patrick   590538 590538 Jay, Patrick, of Freton 3
4643417 2244179 2244179 plaintiff Jay Peter   590538 590538 Jay, Peter, of Freton 0
4644841 2244559 2244559 plaintiff Bokenham Robert   590538 590538 Bokenham, Robert, of Freton, parson 1
4666442 2250982 2250982 plaintiff Jay Peter   590538 590538 Jay, Peter, of Freton 0
4676540 2258279 2258279 defendant Pekeman John carpenter 590538 590538 Pekeman, John, of Freton, carpenter 0
4728549 2274169 2274169 defendant Walsshe Thomas gent 590538 590538 Walsshe, Thomas, of Freton, gent 0
4760729 2283696 2283696 defendant Bray Robert yeoman 590538 590538 Bray, Robert, of Freton, yeoman 0
4808187 2298737 2298737 defendant Bray Robert yeoman 590538 590538 Bray, Robert, of Freton, yeoman 0
4850752 2311687 2311687 defendant Candeler or Caudeler John husbandman 590538 590538 Candeler or Caudeler, John, of Freton, husbandman 2
4927895 2335160 2335160 defendant Smyth Thomas smith 590538 590538 Smyth, Thomas, of Freton, smith 1
4927896 2335160 2335160 defendant Sporle Walter shoemaker 590538 590538 Sporle, Walter, of Freton, shoemaker 2
4933884 2336978 2336978 defendant Freton Richard gent 590538 590538 Freton, Richard, of Freton, gent 2
4967565 2347242 2347242 defendant Geggebald Nicholas yeoman 590538 590538 Geggebald, Nicholas, of Freton, yeoman 1
4977840 2350331 2350331 defendant Gegebald Nicholas yeoman 590538 590538 Gegebald, Nicholas, of Freton, yeoman 0
4979661 2350872 2350872 defendant Freton Richard gent 590538 590538 Freton, Richard, of Freton, gent 0
5038254 2368077 2368077 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 0
5038409 2368123 2368123 defendant (illegible) John husbandman 590538 590538 ---, John, of Freton, husbandman 1
5048998 2371337 2371337 plaintiff Seman William yeoman 590538 590538 Seman, William, of Freton, yeoman 0
5057152 2373719 2373719 defendant Seman William yeoman 590538 590538 Seman, William, of Freton, yeoman 2
5066991 2376652 2376652 defendant Chandeler Thomas yeoman 590538 590538 Chandeler, Thomas, of Freton, yeoman 0
5070516 2377676 2377676 plaintiff Seman William   590538 590538 Seman, William, of Freton 0
5088682 2383065 2383065 defendant Godewyn John gent 590538 590538 Godewyn, John, of Freton, gent 0
5088685 2383066 2383066 defendant Godewyn John gent 590538 590538 Godewyn, John, of Freton, gent 0
5195802 2414520 2414520 plaintiff Seman William   590538 590538 Seman, William, of Freton 1
5197313 2414953 2414953 defendant Smyth Thomas smith 590538 590538 Smyth, Thomas, of Freton, smith 0
5197314 2414953 2414953 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 1
5197315 2414953 2414953 defendant Smyth Edmund smith 590538 590538 Smyth, Edmund, of Freton, smith 2
5207208 2417848 2417848 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 0
5209400 2418485 2418485 plaintiff Seman William   590538 590538 Seman, William, of Freton 1
5210013 2418661 2418661 defendant Smyth Thomas smith 590538 590538 Smyth, Thomas, of Freton, smith 0
5210014 2418661 2418661 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 1
5210015 2418661 2418661 defendant Smyth Edmund smith 590538 590538 Smyth, Edmund, of Freton, smith 2
5210017 2418662 2418662 defendant Smyth Thomas smith 590538 590538 Smyth, Thomas, of Freton, smith 0
5210018 2418662 2418662 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 1
5210019 2418662 2418662 defendant Smyth Edmund smith 590538 590538 Smyth, Edmund, of Freton, smith 2
5221188 2421898 2421898 defendant Godewyn John gent 590538 590538 Godewyn, John, of Freton, gent 0
5226716 2423479 2423479 defendant Knyght Richard husbandman 590538 590538 Knyght, Richard, of Freton, husbandman 3
5226719 2423480 2423480 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 0
5226720 2423480 2423480 defendant Smyth Edmund smith 590538 590538 Smyth, Edmund, of Freton, smith 1
5233013 2425237 2425237 defendant Smyth John yeoman 590538 590538 Smyth, John, of Freton, yeoman 1
5234242 2425603 2425603 defendant Godewyn John gent 590538 590538 Godewyn, John, of Freton, gent 1
5235415 2425939 2425939 defendant Rysyng John husbandman 590538 590538 Rysyng, John, of Freton, husbandman 8
5235428 2425941 2425941 defendant Rysyng John husbandman 590538 590538 Rysyng, John, of Freton, husbandman 8
5237010 2426405 2426405 defendant Godewyn John gent 590538 590538 Godewyn, John, of Freton, gent 0
5263035 2434181 2434181 defendant Thorn Joan widow 590538 590538 Thorn, Joan, of Freton, widow 1
5263637 2434377 2434377 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 1
5272498 2437028 2437028 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 4
5275046 2437782 2437782 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 2
5275047 2437782 2437782 defendant Smyth Edmund smith 590538 590538 Smyth, Edmund, of Freton, smith 3
5275048 2437782 2437782 defendant Smyth Robert laborer 590538 590538 Smyth, Robert, of Freton, laborer 4
5275051 2437782 2437782 defendant Turnour John clerk 590538 590538 Turnour, John, of Freton, clerk 7
5275638 2437941 2437941 defendant Turnour John clerk 590538 590538 Turnour, John, of Freton, clerk 3
5275641 2437941 2437941 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 6
5275643 2437941 2437941 defendant Smyth Edmund smith 590538 590538 Smyth, Edmund, of Freton, smith 8
5275645 2437942 2437942 defendant Turnor John clerk 590538 590538 Turnor, John, of Freton, clerk 0
5275649 2437944 2437944 defendant Brent John clerk 590538 590538 Brent, John, of Freton, clerk 0
5275650 2437944 2437944 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 1
5275652 2437944 2437944 defendant Estgate William laborer 590538 590538 Estgate, William, of Freton, laborer 3
5275786 2437985 2437985 defendant Godewyn John gent 590538 590538 Godewyn, John, of Freton, gent 2
5275956 2438042 2438042 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 0
5275959 2438043 2438043 defendant Cheny John laborer 590538 590538 Cheny, John, of Freton, laborer 1
5276106 2438086 2438086 defendant Seman William yeoman 590538 590538 Seman, William, of Freton, yeoman 0
5278748 2438892 2438892 defendant Stevenson John gent 590538 590538 Stevenson, John, of Freton, gent 0
5278751 2438893 2438893 defendant Stevenson John gent 590538 590538 Stevenson, John, of Freton, gent 1
5278902 2438941 2438941 defendant Stevenson John gent 590538 590538 Stevenson, John, of Freton, gent 0
5287264 2441295 2441295 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 5
5293298 2443021 2443021 defendant Goodewyn John gent 590538 590538 Goodewyn, John, of Freton, gent 4
5293302 2443023 2443023 defendant Stevenson John gent 590538 590538 Stevenson, John, of Freton, gent 0
5293691 2443118 2443118 defendant Herward William husbandman 590538 590538 Herward, William, of Freton, husbandman 1
5293727 2443126 2443126 plaintiff Smyth John   590538 590538 Smyth, John, of Freton 0
5295353 2443635 2443635 defendant Seman William yeoman 590538 590538 Seman, William, of Freton, yeoman 0
5297681 2444328 2444328 defendant Stevenson John gent 590538 590538 Stevenson, John, of Freton, gent 0
5297684 2444329 2444329 defendant Stevenson John gent 590538 590538 Stevenson, John, of Freton, gent 0
5308404 2447550 2447550 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 0
5308405 2447550 2447550 defendant Billerne William husbandman 590538 590538 Billerne, William, of Freton, husbandman 1
5309339 2447833 2447833 defendant Smyth John smith 590538 590538 Smyth, John, of Freton, smith 0

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