names

182 rows where place_id = 590844

✎ 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
3602486 1868439 1868439 defendant Caa Richard clerk 590844 590844 Caa, Richard, of Lyng, clerk 0
3603458 1868747 1868747 plaintiff Denys William   590844 590844 Denys, William, of Lyng 0
3606405 1869668 1869668 defendant Seynjohn alias Johnson John carpenter 590844 590844 Seynjohn alias Johnson, John, of Lyng, carpenter 3
3606872 1869814 1869814 defendant Cokkys Nicholas smith 590844 590844 Cokkys, Nicholas, of Lyng, smith 1
3611853 1871368 1871368 defendant Smyth Richard husbandman 590844 590844 Smyth, Richard, of Lyng, husbandman 1
3645798 1909089 1909089 plaintiff Harneyse Thomas (legal representative) 590844 590844 Harneyse, Thomas, of Lyng, executor of 0
3645800 1909089 1909089 defendant Alby Geoffrey yeoman 590844 590844 Alby, Geoffrey, of Lyng, yeoman 0
3647383 1909569 1909569 defendant Cokkys Nicholas smith 590844 590844 Cokkys, Nicholas, of Lyng, smith 1
3693714 1924227 1924227 defendant Sysely Robert butcher 590844 590844 Sysely, Robert, of Lyng, butcher 1
3706591 1928347 1928347 defendant Lowdesdale John tailor 590844 590844 Lowdesdale, John, of Lyng, tailor 0
3710429 1929580 1929580 defendant Lawes Thomas thatcher 590844 590844 Lawes, Thomas, of Lyng, thatcher 3
3809733 1960934 1960934 plaintiff Bevice Richard (legal representative) 590844 590844 Bevice, Richard, of Lyng, husbandman, executors of 0
3809737 1960935 1960935 plaintiff Bevyce Richard (legal representative) 590844 590844 Bevyce, Richard, of Lyng, husbandman, executors of 0
3824990 1965689 1965689 defendant Davys John raffman 590844 590844 Davys, John, of Lyng, raffman 0
3831998 1967906 1967906 defendant Hyx John husbandman 590844 590844 Hyx, John, of Lyng, husbandman 0
3848196 1973001 1973001 defendant Hickys John husbandman 590844 590844 Hickys, John, of Lyng, husbandman 2
3853583 1974747 1974747 defendant Pratt Geoffrey husbandman 590844 590844 Pratt, Geoffrey, of Lyng, husbandman 1
3862228 1977551 1977551 plaintiff Grome Richard   590844 590844 Grome, Richard, of Lyng 0
3871912 1980840 1980840 defendant Harvy John husbandman 590844 590844 Harvy, John, of Lyng, husbandman 1
3886229 1985646 1985646 defendant Shalowe Richard miller 590844 590844 Shalowe, Richard, of Lyng, miller 1
3906644 1992514 1992514 defendant Jay Nicholas husbandman 590844 590844 Jay, Nicholas, of Lyng, husbandman 4
3907268 1992722 1992722 defendant Aldred William husbandman 590844 590844 Aldred, William, of Lyng, husbandman 0
3909445 1993458 1993458 defendant Aldby Thomas husbandman 590844 590844 Aldby, Thomas, of Lyng, husbandman 0
3909446 1993458 1993458 defendant Aldby Geoffrey husbandman 590844 590844 Aldby, Geoffrey, of Lyng, husbandman 1
3924987 1998673 1998673 defendant Mason Richard husbandman 590844 590844 Mason, Richard, of Lyng, husbandman 0
3924988 1998673 1998673 defendant Mason Thomas clerk 590844 590844 Mason, Thomas, of Lyng, clerk 1
3924989 1998673 1998673 defendant Balle Thomas (legal representative) 590844 590844 Balle, Thomas, of Lyng, clerk, executrix of 2
3924990 1998673 1998673 defendant Balle Agnes widow 590844 590844 Balle, Agnes, of Lyng, widow 3
3929518 2000220 2000220 defendant Aldrede Roger yeoman 590844 590844 Aldrede, Roger, of Lyng, yeoman 0
3933686 2001557 2001557 defendant Alred Roger husbandman 590844 590844 Alred, Roger, of Lyng, husbandman 0
3944776 2005271 2005271 defendant Smyth William husbandman 590844 590844 Smyth, William, of Lyng, husbandman 3
3977129 2016573 2016573 plaintiff Lawes Richard   590844 590844 Lawes, Richard, of Lyng 1
4007697 2027541 2027541 plaintiff Mason Richard (legal representative) 590844 590844 Mason, Richard, of Lyng, or of Hockeringe, administrator of 0
4019086 2031566 2031566 plaintiff Warden John sherman 590844 590844 Warden, John, of Lyng, sherman 0
4019088 2031567 2031567 plaintiff Warden John sherman 590844 590844 Warden, John, of Lyng, sherman 0
4019089 2031567 2031567 defendant Alby Thomas yeoman 590844 590844 Alby, Thomas, of Lyng, yeoman 0
4019092 2031568 2031568 defendant Alby Thomas yeoman 590844 590844 Alby, Thomas, of Lyng, yeoman 1
4023801 2033217 2033217 defendant Brome Thomas clerk 590844 590844 Brome, Thomas, of Lyng, clerk 1
4028082 2034694 2034694 defendant Broune or Brome Thomas, junior clerk 590844 590844 Broune or Brome, Thomas, junior, of Lyng, clerk 1
4043341 2040085 2040085 defendant Ingeldewe James husbandman 590844 590844 Ingeldewe, James, of Lyng, husbandman 5
4055393 2044324 2044324 defendant Albye William husbandman 590844 590844 Albye, William, of Lyng, husbandman 0
4057320 2045002 2045002 plaintiff Burgis Robert   590844 590844 Burgis, Robert, of Lyng, "boller" 0
4061180 2046407 2046407 defendant Leman John husbandman 590844 590844 Leman, John, of Lyng, husbandman 2
4061185 2046408 2046408 defendant Leman John butcher 590844 590844 Leman, John, of Lyng, butcher 2
4071652 2050156 2050156 defendant Tynberye William gent 590844 590844 Tynberye, William, of Lyng, gent 0
4081599 2053723 2053723 defendant Leman Thomas butcher 590844 590844 Leman, Thomas, of Lyng, butcher 1
4096890 2059221 2059221 defendant Newton Thomas yeoman 590844 590844 Newton, Thomas, of Lyng, yeoman 2
4182167 2089241 2089241 defendant Mayes William sherman 590844 590844 Mayes, William, of Lyng, sherman 1
4192276 2092859 2092859 defendant Heynes John husbandman 590844 590844 Heynes, John, of Lyng, husbandman 0
4192277 2092859 2092859 defendant Mowse William   590844 590844 Mowse, William, of Lyng, wheelwright 1
4206474 2097808 2097808 defendant Norton John butcher 590844 590844 Norton, John, of Lyng, butcher 2
4214354 2100527 2100527 defendant Towneshend Christopher laborer 590844 590844 Towneshend, Christopher, of Lyng, laborer 2
4240830 2109916 2109916 defendant Towneshend Christopher laborer 590844 590844 Towneshend, Christopher, of Lyng, laborer 2
4254580 2114521 2114521 defendant Copland Nicholas carpenter 590844 590844 Copland, Nicholas, of Lyng, carpenter 1
4254582 2114521 2114521 defendant Chambers Philip miller 590844 590844 Chambers, Philip, of Lyng, miller 3
4291276 2126950 2126950 defendant Bromhyll or Bromewell Thomas   590844 590844 Bromhyll or Bromewell, Thomas, of Lyng, shepherd 0
4311816 2134270 2134270 defendant Leman John butcher 590844 590844 Leman, John, of Lyng, butcher 0
4313822 2134941 2134941 defendant Bromall Thomas yeoman 590844 590844 Bromall, Thomas, of Lyng, yeoman 0
4331950 2140980 2140980 defendant Grange Richard clerk 590844 590844 Grange, Richard, of Lyng, clerk 2
4331951 2140980 2140980 defendant Lemman Richard butcher 590844 590844 Lemman, Richard, of Lyng, butcher 3
4332269 2141083 2141083 defendant Hayward Robert husbandman 590844 590844 Hayward, Robert, of Lyng, husbandman 2
4389238 2161029 2161029 defendant Butler Henry gent 590844 590844 Butler, Henry, of Lyng, gent 0
4499748 2200554 2200554 defendant Bradlee Simon   590844 590844 Bradlee, Simon, of Lyng 0
4499753 2200554 2200554 defendant Virly John   590844 590844 Virly, John, of Lyng 5
4499754 2200554 2200554 defendant Levorton John   590844 590844 Levorton, John, of Lyng 6
4522237 2207299 2207299 defendant Tayllour Simon   590844 590844 Tayllour, Simon, of Lyng 2
4522238 2207299 2207299 defendant Bradle John   590844 590844 Bradle, John, of Lyng 3
4576836 2224261 2224261 plaintiff Burghwode Henry (legal representative) 590844 590844 Burghwode, Henry, of Lyng, parson, executor of 0
4576838 2224261 2224261 defendant Puddyng John   590844 590844 Puddyng, John, of Lyng 0
4589812 2228179 2228179 defendant Balyne William   590844 590844 Balyne, William, of Lyng 1
4608700 2233826 2233826 defendant Baxtere John   590844 590844 Baxtere, John, of Lyng 1
4621568 2237733 2237733 defendant Cory John   590844 590844 Cory, John, of Lyng, chaplain, son of Ralph 0
4637525 2242527 2242527 defendant Baxtere John   590844 590844 Baxtere, John, of Lyng 1
4646401 2245011 2245011 defendant Qwyte John plumber 590844 590844 Qwyte, John, of Lyng, plumber 0
4646402 2245011 2245011 defendant Coupere Peter   590844 590844 Coupere, Peter, of Lyng 1
4654914 2247418 2247418 defendant Plomer John plumber 590844 590844 Plomer, John, of Lyng, plumber 1
4662533 2249751 2249751 plaintiff Frany John   590844 590844 Frany, John, of Lyng 0
4671417 2256710 2256710 defendant Tyler Simon husbandman 590844 590844 Tyler, Simon, of Lyng, husbandman 0
4680841 2259629 2259629 defendant Strangrene Nicholas clerk 590844 590844 Strangrene, Nicholas, of Lyng, clerk 5
4693558 2263488 2263488 plaintiff Baxter Richard   590844 590844 Baxter, Richard, of Lyng 0
4701218 2265782 2265782 defendant atte Becke Simon husbandman 590844 590844 atte Becke, Simon, of Lyng, husbandman 0
4744165 2278821 2278821 defendant Harveys William   590844 590844 Harveys, William, of Lyng, brass worker 0
4751971 2281070 2281070 defendant Estan John laborer 590844 590844 Estan, John, of Lyng, laborer 0
4754326 2281731 2281731 defendant Harveys or Harneys William yeoman 590844 590844 Harveys or Harneys, William, of Lyng, yeoman 0
4754328 2281732 2281732 defendant Harveys William   590844 590844 Harveys, William, of Lyng, brass worker 0
4761278 2283875 2283875 defendant Harneys or Harveys William   590844 590844 Harneys or Harveys, William, of Lyng, brass worker 0
4774584 2288037 2288037 defendant Couper Peter yeoman 590844 590844 Couper, Peter, of Lyng, yeoman 3
4774585 2288037 2288037 defendant Nobbes Richard yeoman 590844 590844 Nobbes, Richard, of Lyng, yeoman 4
4775812 2288434 2288434 defendant Harneys William yeoman 590844 590844 Harneys, William, of Lyng, yeoman 0
4809500 2299144 2299144 defendant Jekkes alias Lyster Thomas yeoman 590844 590844 Jekkes alias Lyster, Thomas, of Lyng, yeoman 2
4925866 2334522 2334522 defendant Meller John miller 590844 590844 Meller, John, of Lyng, miller 1
4977431 2350214 2350214 defendant Aleyn Richard yeoman 590844 590844 Aleyn, Richard, of Lyng, yeoman 0
4977599 2350264 2350264 defendant Girlyng Roger husbandman 590844 590844 Girlyng, Roger, of Lyng, husbandman 1
4979622 2350863 2350863 defendant Moore William miller 590844 590844 Moore, William, of Lyng, miller 0
4979623 2350863 2350863 defendant Aylston Henry husbandman 590844 590844 Aylston, Henry, of Lyng, husbandman 1
4979624 2350863 2350863 defendant Smyth Nicholas   590844 590844 Smyth, Nicholas, of Lyng, servant 2
4995346 2355452 2355452 defendant Palmer John tinker 590844 590844 Palmer, John, of Lyng, tinker 3
5006740 2358867 2358867 defendant Bradle Thomas carpenter 590844 590844 Bradle, Thomas, of Lyng, carpenter 0
5023493 2363780 2363780 defendant Gateshend Nicholas husbandman 590844 590844 Gateshend, Nicholas, of Lyng, husbandman 0
5031387 2366036 2366036 defendant Ketill John husbandman 590844 590844 Ketill, John, of Lyng, husbandman 2

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