names

119 rows where place_id = 589509

✎ 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
3597824 1866938 1866938 defendant Anyell Richard shoemaker 589509 589509 Anyell, Richard, of Aldeburgh, shoemaker 0
3635171 1905797 1905797 defendant Plume John husbandman 589509 589509 Plume, John, of Aldeburgh, husbandman 2
3644531 1908706 1908706 defendant Skote Clement husbandman 589509 589509 Skote, Clement, of Aldeburgh, husbandman 0
3777259 1950634 1950634 defendant Sutton John yeoman 589509 589509 Sutton, John, of Aldeburgh, yeoman 0
3777260 1950634 1950634 defendant Scroton Richard husbandman 589509 589509 Scroton, Richard, of Aldeburgh, husbandman 1
3794554 1956176 1956176 defendant Browne Robert chaplain 589509 589509 Browne, Robert, of Aldeburgh, chaplain 4
3814594 1962475 1962475 defendant Hokker John butcher 589509 589509 Hokker, John, of Aldeburgh, butcher 0
3895637 1988747 1988747 defendant Aldeburgh Ralph gent 589509 589509 Aldeburgh, Ralph, of Aldeburgh, gent 0
3909875 1993610 1993610 defendant Aldeburgh Ralph gent 589509 589509 Aldeburgh, Ralph, of Aldeburgh, gent 0
3913225 1994754 1994754 defendant Harward Clement gent 589509 589509 Harward, Clement, of Aldeburgh, gent 0
3913373 1994808 1994808 defendant Browne Thomas yeoman 589509 589509 Browne, Thomas, of Aldeburgh, yeoman 2
3916027 1995747 1995747 defendant Harward Robert esq 589509 589509 Harward, Robert, of Aldeburgh, esq 0
3916226 1995812 1995812 defendant Harward Robert esq 589509 589509 Harward, Robert, of Aldeburgh, esq 0
3918993 1996676 1996676 plaintiff Johnson Francis beer brewer 589509 589509 Johnson, Francis, of Aldeburgh, beer brewer 0
3918996 1996677 1996677 plaintiff Johnson Francis beer brewer 589509 589509 Johnson, Francis, of Aldeburgh, beer brewer 0
3936834 2002652 2002652 defendant Nottyngham Thomas merchant 589509 589509 Nottyngham, Thomas, of Aldeburgh, merchant 0
3937350 2002828 2002828 defendant Nottyngham Thomas merchant 589509 589509 Nottyngham, Thomas, of Aldeburgh, merchant 0
3937353 2002829 2002829 defendant Nottyngham Thomas merchant 589509 589509 Nottyngham, Thomas, of Aldeburgh, merchant 0
4027156 2034359 2034359 defendant Whighte John innkeeper 589509 589509 Whighte, John, of Aldeburgh, innkeeper 0
4067743 2048774 2048774 plaintiff Johnson Francis   589509 589509 Johnson, Francis, of Aldeburgh 0
4076967 2052045 2052045 defendant Manclerke Lionel tailor 589509 589509 Manclerke, Lionel, of Aldeburgh, tailor 2
4456514 2187055 2187055 defendant Normanby Robert de   589509 589509 Normanby, Robert de, of Aldeburgh 0
4480871 2194688 2194688 defendant Nauson William   589509 589509 Nauson, William, of Aldeburgh 0
4492746 2198431 2198431 defendant Harman William   589509 589509 Harman, William, of Aldeburgh 0
4496225 2199494 2199494 defendant Lyghtfot John   589509 589509 Lyghtfot, John, of Aldeburgh 0
4507911 2202939 2202939 defendant Sclater Thomas   589509 589509 Sclater, Thomas, of Aldeburgh 0
4507912 2202939 2202939 defendant Sclater William   589509 589509 Sclater, William, of Aldeburgh, son of Thomas 1
4507913 2202939 2202939 defendant Sclater John   589509 589509 Sclater, John, of Aldeburgh, son of Thomas 2
4516284 2205503 2205503 defendant Lyghtfot John   589509 589509 Lyghtfot, John, of Aldeburgh 0
4518807 2206251 2206251 defendant Wayte John   589509 589509 Wayte, John, of Aldeburgh, formerly parson 2
4518819 2206252 2206252 defendant Wayte John   589509 589509 Wayte, John, of Aldeburgh, parson 2
4523434 2207651 2207651 defendant Hastynges Ralph de   589509 589509 Hastynges, Ralph de, of Aldeburgh 1
4563109 2220028 2220028 defendant Craven Thomas   589509 589509 Craven, Thomas, of Aldeburgh 0
4572879 2223059 2223059 defendant Copper William   589509 589509 Copper, William, of Aldeburgh 1
4581610 2225697 2225697 defendant Normanby John   589509 589509 Normanby, John, of Aldeburgh 0
4609826 2234166 2234166 defendant Deyre John   589509 589509 Deyre, John, of Aldeburgh 0
4618558 2236812 2236812 defendant Craven Thomas   589509 589509 Craven, Thomas, of Aldeburgh 0
4629037 2240007 2240007 defendant Manfeld John   589509 589509 Manfeld, John, of Aldeburgh 0
4657925 2248363 2248363 defendant Fouler William husbandman 589509 589509 Fouler, William, of Aldeburgh, husbandman 0
4660288 2249048 2249048 defendant Herward Clement gent 589509 589509 Herward, Clement, of Aldeburgh, gent 3
4668851 2255962 2255962 plaintiff Herward Clement   589509 589509 Herward, Clement, of Aldeburgh 2
4690451 2262575 2262575 defendant Smyth Richard husbandman 589509 589509 Smyth, Richard, of Aldeburgh, husbandman 1
4693987 2263626 2263626 plaintiff Herward Clement   589509 589509 Herward, Clement, of Aldeburgh 2
4695908 2264206 2264206 plaintiff Burton William   589509 589509 Burton, William, of Aldeburgh 0
4695909 2264206 2264206 defendant Normanby John gent 589509 589509 Normanby, John, of Aldeburgh, gent 0
4698174 2264916 2264916 defendant Grane John husbandman 589509 589509 Grane, John, of Aldeburgh, husbandman 0
4698175 2264916 2264916 defendant Wright John husbandman 589509 589509 Wright, John, of Aldeburgh, husbandman 1
4698176 2264916 2264916 defendant Werleby Henry de husbandman 589509 589509 Werleby, Henry de, of Aldeburgh, husbandman 2
4698177 2264916 2264916 defendant Dumber Richard husbandman 589509 589509 Dumber, Richard, of Aldeburgh, husbandman 3
4698178 2264916 2264916 defendant Legyte Helen widow 589509 589509 Legyte, Helen, of Aldeburgh, widow 4
4716267 2270398 2270398 defendant Smyth Richard husbandman 589509 589509 Smyth, Richard, of Aldeburgh, husbandman 1
4716956 2270636 2270636 defendant Barfate John   589509 589509 Barfate, John, of Aldeburgh, single man 0
4729717 2274505 2274505 defendant Benselyn Walter husbandman 589509 589509 Benselyn, Walter, of Aldeburgh, husbandman 2
4729724 2274505 2274505 defendant Hebbys John husbandman 589509 589509 Hebbys, John, of Aldeburgh, husbandman 9
4729725 2274505 2274505 defendant Water John husbandman 589509 589509 Water, John, of Aldeburgh, husbandman 10
4729726 2274505 2274505 defendant Bayer Wiliam fisher 589509 589509 Bayer, Wiliam, of Aldeburgh, son of Wiliam, fisher 11
4732413 2275311 2275311 defendant Copper William yeoman 589509 589509 Copper, William, of Aldeburgh, yeoman 8
4743835 2278729 2278729 defendant Hume or Hunne Godfrey fisher 589509 589509 Hume or Hunne, Godfrey, of Aldeburgh, fisher 0
4743836 2278729 2278729 defendant Aldeth William fisher 589509 589509 Aldeth, William, of Aldeburgh, fisher 1
4743837 2278729 2278729 defendant Aldeth Semanus fisher 589509 589509 Aldeth, Semanus, of Aldeburgh, fisher 2
4743838 2278729 2278729 defendant Aldeth Robert fisher 589509 589509 Aldeth, Robert, of Aldeburgh, fisher 3
4743839 2278729 2278729 defendant Aldeth Richard fisher 589509 589509 Aldeth, Richard, of Aldeburgh, fisher 4
4743840 2278729 2278729 defendant Cros John fisher 589509 589509 Cros, John, of Aldeburgh, fisher 5
4743841 2278729 2278729 defendant Cros William fisher 589509 589509 Cros, William, of Aldeburgh, fisher 6
4743842 2278729 2278729 defendant Burgate John fisher 589509 589509 Burgate, John, of Aldeburgh, fisher 7
4743844 2278729 2278729 defendant Charner William fisher 589509 589509 Charner, William, of Aldeburgh, fisher 9
4743845 2278729 2278729 defendant Crakeman Nicholas fisher 589509 589509 Crakeman, Nicholas, of Aldeburgh, fisher 10
4746562 2279488 2279488 plaintiff Herward Margaret   589509 589509 Herward, Margaret, of Aldeburgh 0
4746569 2279489 2279489 plaintiff Herward Margaret   589509 589509 Herward, Margaret, of Aldeburgh 0
4747784 2279857 2279857 defendant Hardy Henry husbandman 589509 589509 Hardy, Henry, of Aldeburgh, husbandman 12
4770928 2286887 2286887 defendant Baron Adam husbandman 589509 589509 Baron, Adam, of Aldeburgh, husbandman 1
4784199 2291055 2291055 defendant Bayer William shipman 589509 589509 Bayer, William, of Aldeburgh, shipman 0
4787466 2292150 2292150 defendant Copper William yeoman 589509 589509 Copper, William, of Aldeburgh, yeoman 0
4788275 2292404 2292404 defendant Bayer William shipman 589509 589509 Bayer, William, of Aldeburgh, shipman 0
4788276 2292404 2292404 defendant del Chirch Thomas husbandman 589509 589509 del Chirch, Thomas, of Aldeburgh, husbandman 1
4789996 2292944 2292944 defendant Normanby John yeoman 589509 589509 Normanby, John, of Aldeburgh, yeoman 6
4804659 2297652 2297652 defendant Bayer William shipman 589509 589509 Bayer, William, of Aldeburgh, shipman 4
4815588 2300983 2300983 defendant Copper William husbandman 589509 589509 Copper, William, of Aldeburgh, husbandman 1
4820315 2302424 2302424 defendant Perkynson Thomas husbandman 589509 589509 Perkynson, Thomas, of Aldeburgh, husbandman 0
4840042 2308434 2308434 defendant Grane John husbandman 589509 589509 Grane, John, of Aldeburgh, husbandman 0
4840043 2308434 2308434 defendant Smyth Richard husbandman 589509 589509 Smyth, Richard, of Aldeburgh, husbandman 1
4843069 2309363 2309363 defendant Bayer William merchant 589509 589509 Bayer, William, of Aldeburgh, merchant 2
4853165 2312407 2312407 defendant Candeler Robert walker 589509 589509 Candeler, Robert, of Aldeburgh, walker 0
4862507 2315266 2315266 defendant Frere John husbandman 589509 589509 Frere, John, of Aldeburgh, husbandman 3
4862508 2315266 2315266 defendant Care Stephen husbandman 589509 589509 Care, Stephen, of Aldeburgh, husbandman 4
4866845 2316594 2316594 defendant Shepard Robert husbandman 589509 589509 Shepard, Robert, of Aldeburgh, husbandman 0
4896848 2325672 2325672 defendant Gosebak John yeoman 589509 589509 Gosebak, John, of Aldeburgh, yeoman 2
4899545 2326497 2326497 defendant Cros William shipman 589509 589509 Cros, William, of Aldeburgh, shipman 0
4923708 2333853 2333853 defendant Care Stephen husbandman 589509 589509 Care, Stephen, of Aldeburgh, husbandman 0
4926549 2334722 2334722 plaintiff Randes Robert gent 589509 589509 Randes, Robert, of Aldeburgh, gent 0
4926550 2334722 2334722 defendant Randes Robert gent 589509 589509 Randes, Robert, of Aldeburgh, gent 0
4926567 2334728 2334728 plaintiff Randys Robert gent 589509 589509 Randys, Robert, of Aldeburgh, gent 0
4928603 2335377 2335377 defendant Cros John husbandman 589509 589509 Cros, John, of Aldeburgh, husbandman 0
4928605 2335377 2335377 defendant Derham John yeoman 589509 589509 Derham, John, of Aldeburgh, yeoman 2
4937625 2338142 2338142 defendant Gosebak John yeoman 589509 589509 Gosebak, John, of Aldeburgh, yeoman 2
4951703 2342488 2342488 plaintiff Randes Robert esq 589509 589509 Randes, Robert, of Aldeburgh, esq 0
4985332 2352531 2352531 defendant Owysson Edmund clerk 589509 589509 Owysson, Edmund, of Aldeburgh, clerk 4
4989588 2353816 2353816 defendant Gosebak John husbandman 589509 589509 Gosebak, John, of Aldeburgh, husbandman 5
5062416 2375326 2375326 plaintiff Herward Robert gent 589509 589509 Herward, Robert, of Aldeburgh, gent 0
5093341 2384449 2384449 defendant Leverych Thomas clerk 589509 589509 Leverych, Thomas, of Aldeburgh, clerk 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);