names

85 rows where place_id = 589073

✎ 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
3596429 1866511 1866511 defendant Goodard William husbandman 589073 589073 Goodard, William, of Mildenhale, Suff, husbandman 0
3607113 1869890 1869890 defendant Meyer Robert yeoman 589073 589073 Meyer, Robert, of Mildenhale, Suff, yeoman 1
3657848 1912704 1912704 defendant Bosten William baker 589073 589073 (Bosten, William, of Mildenhale, Suff, baker 1
3663528 1914520 1914520 defendant Pemberton Richard   589073 589073 Pemberton, Richard, of Mildenhale, Suff, Crown valet 0
3663535 1914521 1914521 defendant Pemberton Richard   589073 589073 Pemberton, Richard, of Mildenhale, Suff, King's Crown Valet 0
3674607 1918109 1918109 defendant Cole Richard tanner 589073 589073 Cole, Richard, of Mildenhale, Suff, tanner 2
3713387 1930502 1930502 defendant Gryffyn Thomas esq 589073 589073 Gryffyn, Thomas, of Mildenhale, Suff, esq 0
3729951 1935621 1935621 defendant Heynes Agnes widow 589073 589073 Heynes, Agnes, of Mildenhale, Suff, widow 0
3729957 1935622 1935622 defendant Jerveys John miller 589073 589073 Jerveys, John, of Mildenhale, Suff, miller 0
3752536 1942720 1942720 defendant Lane John smith 589073 589073 Lane, John, of Mildenhale, Suff, smith 0
3793340 1955778 1955778 defendant Larke Thomas mercer 589073 589073 Larke, Thomas, of Mildenhale, Suff, mercer 0
3807722 1960303 1960303 defendant Tyrrell Robert yeoman 589073 589073 Tyrrell, Robert, of Mildenhale, Suff, yeoman 0
3829114 1966987 1966987 defendant Busshe Thomas chapman 589073 589073 Busshe, Thomas, of Mildenhale, Suff, chapman 0
3896806 1989144 1989144 plaintiff Waltham John yeoman 589073 589073 Waltham, John, of Mildenhale, Suff, yeoman 0
3896807 1989144 1989144 plaintiff Heynes William yeoman 589073 589073 Heynes, William, of Mildenhale, Suff, yeoman 1
3911146 1994056 1994056 plaintiff Waltham John yeoman 589073 589073 Waltham, John, of Mildenhale, Suff, yeoman 0
3911147 1994056 1994056 plaintiff Heynes William yeoman 589073 589073 Heynes, William, of Mildenhale, Suff, yeoman 1
3911149 1994057 1994057 plaintiff Waltham John yeoman 589073 589073 Waltham, John, of Mildenhale, Suff, yeoman 0
3911150 1994057 1994057 plaintiff Heynes William yeoman 589073 589073 Heynes, William, of Mildenhale, Suff, yeoman 1
4652105 2246599 2246599 defendant Hethe Thomas esq 589073 589073 Hethe, Thomas, of Mildenhale, Suff, esq 1
4652122 2246602 2246602 defendant Hethe Thomas esq 589073 589073 Hethe, Thomas, of Mildenhale, Suff, esq 4
4660663 2249159 2249159 defendant Lambard Adam dyer 589073 589073 Lambard, Adam, of Mildenhale, Suff, dyer 2
4665200 2250601 2250601 defendant Mildenhale William glover 589073 589073 Mildenhale, William, of Mildenhale, Suff, glover 0
4692618 2263208 2263208 defendant Borle John husbandman 589073 589073 Borle, John, of Mildenhale, suff, husbandman 2
4700531 2265578 2265578 defendant Sly Thomas chapman 589073 589073 Sly, Thomas, of Mildenhale, Suff, chapman 6
4700540 2265579 2265579 defendant Sly Thomas chapman 589073 589073 Sly, Thomas, of Mildenhale, Suff, chapman 6
4745249 2279118 2279118 defendant Helgeye John thatcher 589073 589073 Helgeye, John, of Mildenhale, Suff, thatcher 0
4786337 2291770 2291770 defendant Helgeye John thatcher 589073 589073 Helgeye, John, of Mildenhale, Suff, thatcher 0
4845829 2310206 2310206 defendant Gappe William husbandman 589073 589073 Gappe, William, of Mildenhale, Suff, husbandman 2
4851161 2311815 2311815 defendant Jeppis William husbandman 589073 589073 Jeppis, William, of Mildenhale, Suff, husbandman 1
4886318 2322579 2322579 defendant Carpenter John yeoman 589073 589073 Carpenter, John, of Mildenhale, Suff, yeoman 3
4907589 2328936 2328936 defendant Ryngstede Thomas clerk 589073 589073 Ryngstede, Thomas, of Mildenhale, Suff, clerk 3
4925146 2334298 2334298 defendant Cote Edmund skinner 589073 589073 Cote, Edmund, of Mildenhale, Suff, skinner 0
4937354 2338050 2338050 defendant Roiston John maltman 589073 589073 Roiston, John, of Mildenhale, Suff, maltman 1
4941461 2339349 2339349 defendant Bernard John yeoman 589073 589073 Bernard, John, of Mildenhale, Suff, or of Swanton, Norf, yeoman 1
4958290 2344448 2344448 defendant Yonge Robert yeoman 589073 589073 Yonge, Robert, of Mildenhale, Suff, yeoman 0
4964295 2346232 2346232 defendant Cote Edmund skinner 589073 589073 Cote, Edmund, of Mildenhale, Suff, skinner 0
4985523 2352588 2352588 defendant Aston Thomas dyer 589073 589073 Aston, Thomas, of Mildenhale, Suff, dyer 0
4985529 2352589 2352589 defendant Aston Thomas dyer 589073 589073 Aston, Thomas, of Mildenhale, Suff, dyer 0
5002675 2357692 2357692 defendant Maret John butcher 589073 589073 Maret, John, of Mildenhale, Suff, butcher 0
5018109 2362182 2362182 defendant Osbarn William dyer 589073 589073 Osbarn, William, of Mildenhale, Suff, dyer 0
5056188 2373424 2373424 defendant Kestevene alias Glover Robert glover 589073 589073 Kestevene alias Glover, Robert, of Mildenhale, Suff, glover 0
5154028 2402338 2402338 defendant Hethe Geroge gent 589073 589073 Hethe, Geroge, of Mildenhale, Suff, gent 1
5154055 2402344 2402344 defendant Hehte George gent 589073 589073 Hehte, George, of Mildenhale, Suff, gent 2
5171271 2407319 2407319 defendant Hethe Geroge gent 589073 589073 Hethe, Geroge, of Mildenhale, Suff, gent 1
5178743 2409502 2409502 defendant Cote Edmund   589073 589073 Cote, Edmund, of Mildenhale, Suff, s_ 0
5189562 2412687 2412687 defendant Hethe George gent 589073 589073 Hethe, George, of Mildenhale, Suff, gent 1
5221430 2421964 2421964 defendant Sclye Simon fuller 589073 589073 Sclye, Simon, of Mildenhale, Suff, fuller 0
5222474 2422288 2422288 defendant Oldebury Thomas chaplain 589073 589073 Oldebury, Thomas, of Mildenhale, Suff, chaplain 0
5281135 2439554 2439554 defendant Goche Thomas tanner 589073 589073 Goche, Thomas, of Mildenhale, Suff, tanner 5
5313153 2448965 2448965 defendant Pope William gent 589073 589073 Pope, William, of Mildenhale, Suff, gent 1
5343612 2458186 2458186 defendant Spencer John yeoman 589073 589073 Spencer, John, of Mildenhale, Suff, yeoman 5
5350358 2460233 2460233 defendant Godard William, senior husbandman 589073 589073 Godard, William, senior, of Mildenhale, Suff, husbandman 1
5355804 2461891 2461891 defendant Cotys Thomas roper 589073 589073 Cotys, Thomas, of Mildenhale, Suff, roper 0
5355808 2461892 2461892 defendant Cotys Thomas roper 589073 589073 Cotys, Thomas, of Mildenhale, Suff, roper 0
5357802 2462511 2462511 defendant Wentworth Katherine   589073 589073 Wentworth, Katherine, of Mildenhale, Suff, widow of Wentworth, John 0
5359901 2463135 2463135 defendant Pelle or Polle Richard chapman 589073 589073 Pelle or Polle, Richard, of Mildenhale, Suff, chapman 4
5365806 2464960 2464960 defendant Poule Thomas chapman 589073 589073 Poule, Thomas, of Mildenhale, Suff, chapman 0
5369637 2466087 2466087 defendant Poule Thomas mercer 589073 589073 Poule, Thomas, of Mildenhale, Suff, mercer 0
5370376 2466321 2466321 defendant Smyth John chapman 589073 589073 Smyth, John, of Mildenhale, Suff, chapman 1
5377017 2468405 2468405 defendant Bryghtwell Robert chapman 589073 589073 Bryghtwell, Robert, of Mildenhale, Suff, chapman 2
5377023 2468406 2468406 defendant Bryghtwell Robert chapman 589073 589073 Bryghtwell, Robert, of Mildenhale, Suff, chapman 2
5380024 2469338 2469338 defendant Akente Robert husbandman 589073 589073 Akente, Robert, of Mildenhale, Suff, husbandman 2
5381099 2469650 2469650 defendant Poule Thomas mercer 589073 589073 Poule, Thomas, of Mildenhale, Suff, mercer 0
5381301 2469706 2469706 defendant Smyth John chapman 589073 589073 Smyth, John, of Mildenhale, Suff, chapman 0
5386547 2471220 2471220 defendant Powle Thomas mercer 589073 589073 Powle, Thomas, of Mildenhale, Suff, mercer 1
5386551 2471221 2471221 defendant Powle Tnomas mercer 589073 589073 Powle, Tnomas, of Mildenhale, Suff, mercer 0
5388236 2471687 2471687 defendant Smyth John chapman 589073 589073 Smyth, John, of Mildenhale, Suff, chapman 0
5388237 2471687 2471687 defendant Poule Thomas chapman 589073 589073 Poule, Thomas, of Mildenhale, Suff, chapman 1
5423678 2482047 2482047 defendant Godard William husbandman 589073 589073 Godard, William, of Mildenhale, Suff, husbandman 0
5436818 2485942 2485942 defendant Marreham Robert yeoman 589073 589073 Marreham, Robert, of Mildenhale, Suff, yeoman 0
5440165 2486957 2486957 defendant Smyth John chapman 589073 589073 Smyth, John, of Mildenhale, Suff, chapman 1
5474992 2497505 2497505 defendant Marreham Robert yeoman 589073 589073 Marreham, Robert, of Mildenhale, Suff, yeoman 0
5475339 2497615 2497615 defendant Smyth John chapman 589073 589073 Smyth, John, of Mildenhale, Suff, chapman 1
5482797 2499800 2499800 defendant Marham Robert yeoman 589073 589073 Marham, Robert, of Mildenhale, Suff, yeoman 6
5486923 2500985 2500985 defendant Poule Thomas innholder 589073 589073 Poule, Thomas, of Mildenhale, Suff, innholder 0
5492475 2502662 2502662 defendant Spencer Christine widow 589073 589073 Spencer, Christine, of Mildenhale, Suff, widow 3
5496050 2503709 2503709 defendant Kent Robert yeoman 589073 589073 Kent, Robert, of Mildenhale, Suff, yeoman 0
5499134 2504685 2504685 defendant Dousonne or Dobsonne Robert dyer 589073 589073 Dousonne or Dobsonne, Robert, of Mildenhale, Suff, dyer 0
5504079 2506192 2506192 defendant Copynger Richard husbandman 589073 589073 Copynger, Richard, of Mildenhale, Suff, husbandman 0
5550047 2520050 2520050 defendant Heynes John yeoman 589073 589073 Heynes, John, of Mildenhale, Suff, yeoman 0
5575983 2527560 2527560 defendant Smyth John yeoman 589073 589073 Smyth, John, of Mildenhale, Suff, yeoman 0
5588829 2531520 2531520 plaintiff Pope Henry gent 589073 589073 Pope, Henry, of Mildenhale, Suff, gent 0
5596374 2533777 2533777 defendant Maye Agnes widow 589073 589073 Maye, Agnes, of Mildenhale, Suff, widow 3
5608747 2537636 2537636 defendant Poule Thomas mercer 589073 589073 Poule, Thomas, of Mildenhale, Suff, mercer 0

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