names

88 rows where place_id = 643121

✎ 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
3871776 1980796 1980796 defendant Ellys Henry laborer 643121 643121 Ellys, Henry, of Woodbridge, laborer 4
3918992 1996675 1996675 defendant Smyth John draper 643121 643121 Smyth, John, of Woodbridge, draper 0
3940212 2003744 2003744 plaintiff Smythe Ralph alias William merchant 643121 643121 Smythe, Ralph alias William, of Woodbridge, merchant 0
3959671 2010475 2010475 defendant Warren John yeoman 643121 643121 Warren, John, of Woodbridge, yeoman 0
3972961 2015116 2015116 plaintiff Gooddyng William, senior yeoman 643121 643121 Gooddyng, William, senior, of Woodbridge, yeoman 0
3975320 2015936 2015936 defendant Pye Richard, senior draper 643121 643121 (Pye, Richard, senior, of Woodbridge, draper 1
3975321 2015936 2015936 defendant Pye Richard, junior grocer 643121 643121 Pye, Richard, junior, of Woodbridge, grocer 2
3976939 2016497 2016497 defendant Swinborne William clothworker 643121 643121 Swinborne, William, of Woodbridge, clothworker 0
3987163 2020155 2020155 defendant Holdyshe Miles gent 643121 643121 Holdyshe, Miles, of Woodbridge, gent 0
3987165 2020156 2020156 defendant Smyth Thomas   643121 643121 Smyth, Thomas, of Woodbridge, beer brewer, administrators of 0
3987166 2020156 2020156 defendant Holdyshe Miles gent 643121 643121 (Holdyshe, Miles, of Woodbridge, gent 1
4000226 2024851 2024851 plaintiff Goodinge George   643121 643121 Goodinge, George, of Woodbridge 0
4015321 2030175 2030175 plaintiff Smyth John (legal representative) 643121 643121 Smyth, John, of Woodbridge, draper, executor of 0
4018282 2031267 2031267 plaintiff Tyler Lionel (legal representative) 643121 643121 Tyler, Lionel, of Woodbridge, mercer, executors of 0
4019790 2031809 2031809 plaintiff Redgrave William   643121 643121 Redgrave, William, of Woodbridge 1
4019793 2031810 2031810 plaintiff Redgrave William   643121 643121 Redgrave, William, of Woodbridge 1
4029157 2035071 2035071 defendant Burman John yeoman 643121 643121 Burman, John, of Woodbridge, yeoman 0
4029669 2035250 2035250 defendant Pottye or Pootye John   643121 643121 Pottye or Pootye, John, of Woodbridge, woollen draper 1
4033021 2036459 2036459 plaintiff Godwyn George   643121 643121 Godwyn, George, of Woodbridge, woollen draper 0
4033146 2036503 2036503 plaintiff Goodyng or Guwyne George clothier 643121 643121 Goodyng or Guwyne, George, of Woodbridge, clothier 0
4057759 2045162 2045162 defendant Partrich Geoffrey butcher 643121 643121 Partrich, Geoffrey, of Woodbridge, butcher 1
4057760 2045162 2045162 defendant Webb Thomas yeoman 643121 643121 Webb, Thomas, of Woodbridge, yeoman 2
4059627 2045836 2045836 defendant Blancheflower Richard mariner 643121 643121 Blancheflower, Richard, of Woodbridge, mariner 0
4062774 2046987 2046987 defendant Smyth William merchant 643121 643121 Smyth, William, of Woodbridge, merchant 0
4064105 2047439 2047439 defendant Cleane or Cleave Edward yeoman 643121 643121 Cleane or Cleave, Edward, of Woodbridge, yeoman 1
4064106 2047439 2047439 defendant Maye William yeoman 643121 643121 Maye, William, of Woodbridge, yeoman 2
4106677 2062679 2062679 defendant Partryche Thomas   643121 643121 Partryche, Thomas, of Woodbridge, butcher, administrators of 0
4106679 2062679 2062679 defendant Steldinge John, junior merchant 643121 643121 Steldinge, John, junior, of Woodbridge, merchant 2
4147363 2077216 2077216 defendant Warren Thomas merchant 643121 643121 Warren, Thomas, of Woodbridge, merchant 0
4156247 2080258 2080258 defendant Hamond Mathew   643121 643121 Hamond, Mathew, of Woodbridge, linen draper 1
4156248 2080258 2080258 defendant Bayman William   643121 643121 Bayman, William, of Woodbridge, woollen draper 2
4164438 2083081 2083081 defendant Hamond Mathew mercer 643121 643121 Hamond, Mathew, of Woodbridge, mercer 0
4164683 2083157 2083157 defendant Warren Thomas merchant 643121 643121 Warren, Thomas, of Woodbridge, merchant 0
4205746 2097559 2097559 defendant Smythe John beer brewer 643121 643121 Smythe, John, of Woodbridge, beer brewer 2
4208693 2098591 2098591 defendant Goldes William yeoman 643121 643121 Goldes, William, of Woodbridge, yeoman 2
4237260 2108618 2108618 defendant Jordon Thomas blacksmith 643121 643121 Jordon, Thomas, of Woodbridge, or of Waldersweke, blacksmith 1
4261461 2116796 2116796 defendant Hubbarde Thomas   643121 643121 Hubbarde, Thomas, of Woodbridge, Shipwright, 1
4282744 2123868 2123868 defendant Hall Richard clothier 643121 643121 Hall, Richard, of Woodbridge, clothier 1
4282746 2123868 2123868 defendant Revet Thomas yeoman 643121 643121 Revet, Thomas, of Woodbridge, yeoman 3
4284880 2124640 2124640 defendant Bereman Jonah saddler 643121 643121 Bereman, Jonah, of Woodbridge, saddler 0
4284882 2124641 2124641 defendant Bereman Jonah saddler 643121 643121 Bereman, Jonah, of Woodbridge, saddler 0
4301524 2130648 2130648 defendant Tayte Robert mercer 643121 643121 Tayte, Robert, of Woodbridge, mercer 1
4303133 2131225 2131225 defendant Battayle Nicholas tanner 643121 643121 Battayle, Nicholas, of Woodbridge, tanner 2
4327800 2139622 2139622 defendant Browne William yeoman 643121 643121 Browne, William, of Woodbridge, yeoman 0
4329662 2140215 2140215 defendant Brunskyll Edward yeoman 643121 643121 Brunskyll, Edward, of Woodbridge, or of Trimley St Mary, yeoman 0
4331289 2140760 2140760 defendant Blanchflower George butcher 643121 643121 Blanchflower, George, of Woodbridge, butcher 0
4331290 2140760 2140760 defendant Chandler Edmund butcher 643121 643121 Chandler, Edmund, of Woodbridge, butcher 1
4333700 2141552 2141552 defendant Toft William yeoman 643121 643121 Toft, William, of Woodbridge, yeoman 0
4333701 2141552 2141552 defendant Aldaye Robert tailor 643121 643121 Aldaye, Robert, of Woodbridge, or of Melton, tailor 1
4333702 2141552 2141552 defendant Jorden Thomas blacksmith 643121 643121 Jorden, Thomas, of Woodbridge, blacksmith 2
4335695 2142216 2142216 defendant Mylles Henry blacksmith 643121 643121 Mylles, Henry, of Woodbridge, blacksmith 3
4338537 2143230 2143230 defendant Free William husbandman 643121 643121 Free, William, of Woodbridge, husbandman 3
4392856 2162226 2162226 defendant Hoxon Robert cutler 643121 643121 Hoxon, Robert, of Woodbridge, cutler 1
4399922 2164563 2164563 defendant Goodinge George   643121 643121 Goodinge, George, of Woodbridge, woollen draper 0
4402826 2165530 2165530 defendant Muryell John   643121 643121 Muryell, John, of Woodbridge, sailor 0
4404312 2166013 2166013 defendant Hall William yeoman 643121 643121 Hall, William, of Woodbridge, or of Fynborowe, yeoman 0
4404313 2166013 2166013 defendant Hall Richard clothier 643121 643121 Hall, Richard, of Woodbridge, clothier 1
4410616 2168140 2168140 defendant Smyth Edmund yeoman 643121 643121 Smyth, Edmund, of Woodbridge, yeoman 0
4638097 2242678 2242678 defendant Prestmere John   643121 643121 Prestmere, John, of Woodbridge 1
4646028 2244910 2244910 defendant Loof Richard   643121 643121 Loof, Richard, of Woodbridge 0
4695958 2264222 2264222 defendant Baldewyn Walter husbandman 643121 643121 Baldewyn, Walter, of Woodbridge, husbandman 0
4713443 2269527 2269527 plaintiff Stub John   643121 643121 Stub, John, of Woodbridge 0
4773008 2287531 2287531 defendant Essex William   643121 643121 Essex, William, of Woodbridge, glove maker 0
4773022 2287534 2287534 plaintiff Stuber John   643121 643121 Stuber, John, of Woodbridge 0
4773031 2287537 2287537 plaintiff Stuk John   643121 643121 Stuk, John, of Woodbridge 0
4831247 2305802 2305802 defendant Park John   643121 643121 Park, John, of Woodbridge, mason 0
4831717 2305949 2305949 defendant Culpho Thomas shoemaker 643121 643121 (Culpho, Thomas, of Woodbridge, shoemaker 1
4844180 2309689 2309689 defendant Wryght John laborer 643121 643121 Wryght, John, of Woodbridge, laborer 0
4989325 2353741 2353741 defendant Dool John caudeler 643121 643121 Dool, John, of Woodbridge, caudeler 0
5007297 2359028 2359028 plaintiff Spicer John   643121 643121 Spicer, John, of Woodbridge 0
5146433 2400088 2400088 defendant Alvard Benedict tailor 643121 643121 Alvard, Benedict, of Woodbridge, tailor 0
5157652 2403368 2403368 defendant Kempe John (legal representative) 643121 643121 Kempe, John, of Woodbridge, executors of 0
5157654 2403368 2403368 defendant Kempe Thomas merchant 643121 643121 Kempe, Thomas, of Woodbridge, merchant 2
5157655 2403368 2403368 defendant Alvard Thomas yeoman 643121 643121 Alvard, Thomas, of Woodbridge, yeoman 3
5179136 2409631 2409631 defendant Cogman John dyer 643121 643121 Cogman, John, of Woodbridge, dyer 2
5190370 2412926 2412926 plaintiff Loof John   643121 643121 Loof, John, of Woodbridge 0
5192210 2413454 2413454 defendant Grythe Margaret widow 643121 643121 Grythe, Margaret, of Woodbridge, widow 3
5196434 2414709 2414709 defendant Lee William   643121 643121 Lee, William, of Woodbridge, twill weaver 0
5199108 2415492 2415492 defendant Sekford George esq 643121 643121 Sekford, George, of Woodbridge, esq 0
5201413 2416170 2416170 defendant Alford Benedict tailor 643121 643121 Alford, Benedict, of Woodbridge, tailor 0
5201779 2416286 2416286 defendant Cogman John dyer 643121 643121 Cogman, John, of Woodbridge, dyer 2
5207674 2417983 2417983 defendant Grythe Margaret widow 643121 643121 Grythe, Margaret, of Woodbridge, widow 3
5211179 2418996 2418996 defendant Sekford George esq 643121 643121 Sekford, George, of Woodbridge, esq 0
5211609 2419133 2419133 defendant Cogman Richard dyer 643121 643121 Cogman, Richard, of Woodbridge, dyer 0
5302435 2445694 2445694 defendant Alvard Benedict husbandman 643121 643121 Alvard, Benedict, of Woodbridge, husbandman 0
5302621 2445756 2445756 defendant Brame Thomas dyer 643121 643121 Brame, Thomas, of Woodbridge, dyer 0
5448875 2489556 2489556 defendant Nicholas James beer brewer 643121 643121 Nicholas, James, of Woodbridge, beer brewer 0
5448876 2489556 2489556 defendant Lunt Robert merchant 643121 643121 Lunt, Robert, of Woodbridge, merchant 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);