names

75 rows where place_id = 618499

✎ 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
3724960 1934095 1934095 defendant Leman John husbandman 618499 618499 Leman, John, of Lynge, husbandman 0
3724961 1934095 1934095 defendant Leman Richard husbandman 618499 618499 Leman, Richard, of Lynge, husbandman 1
3792592 1955542 1955542 defendant Bevys Richard husbandman 618499 618499 Bevys, Richard, of Lynge, husbandman 0
3903440 1991377 1991377 defendant Poutrel Lawrence smith 618499 618499 Poutrel, Lawrence, of Lynge, smith 1
3908441 1993118 1993118 defendant Jaye Nicholas husbandman 618499 618499 Jaye, Nicholas, of Lynge, husbandman 1
4019090 2031568 2031568 plaintiff Warden John sherman 618499 618499 Warden, John, of Lynge, sherman 0
4032861 2036408 2036408 defendant Brome Thomas, junior   618499 618499 Brome, Thomas, junior, of Lynge, or of Laxfeld, Norf 0
4060494 2046156 2046156 defendant Newton Thomas husbandman 618499 618499 Newton, Thomas, of Lynge, husbandman 2
4091865 2057385 2057385 defendant Swynnard Robert husbandman 618499 618499 Swynnard, Robert, of Lynge, husbandman 0
4133672 2072377 2072377 defendant Maye William sherman 618499 618499 Maye, William, of Lynge, sherman 0
4135680 2073087 2073087 defendant Norton John husbandman 618499 618499 Norton, John, of Lynge, husbandman 3
4182845 2089480 2089480 defendant Norton John husbandman 618499 618499 Norton, John, of Lynge, husbandman 3
4182959 2089520 2089520 defendant Kyngesburye William butcher 618499 618499 Kyngesburye, William, of Lynge, butcher 1
4191715 2092657 2092657 defendant Clarke John tailor 618499 618499 Clarke, John, of Lynge, tailor 0
4228460 2105436 2105436 defendant Newbye Edmund miller 618499 618499 Newbye, Edmund, of Lynge, miller 0
4243336 2110763 2110763 defendant Curtis Henry tailor 618499 618499 Curtis, Henry, of Lynge, tailor 0
4243337 2110763 2110763 defendant Mollynge Wolfram husbandman 618499 618499 Mollynge, Wolfram, of Lynge, husbandman 1
4243338 2110763 2110763 defendant Burges John   618499 618499 Burges, John, of Lynge, "boller" or bowl maker 2
4243340 2110764 2110764 defendant Curtis Henry tailor 618499 618499 Curtis, Henry, of Lynge, tailor 0
4243341 2110764 2110764 defendant Mollynge Wolfram husbandman 618499 618499 Mollynge, Wolfram, of Lynge, husbandman 1
4243342 2110764 2110764 defendant Burges John   618499 618499 Burges, John, of Lynge, "boller" or bowl maker 2
4243745 2110891 2110891 defendant Maye William sherman 618499 618499 Maye, William, of Lynge, sherman 0
4243746 2110891 2110891 defendant Burges John   618499 618499 Burges, John, of Lynge, "boller" 1
4244950 2111296 2111296 defendant Curtys Henry yeoman 618499 618499 Curtys, Henry, of Lynge, yeoman 1
4244954 2111297 2111297 defendant Curtys Henry yeoman 618499 618499 Curtys, Henry, of Lynge, yeoman 1
4245891 2111606 2111606 defendant Lussher Richard tanner 618499 618499 Lussher, Richard, of Lynge, tanner 0
4245893 2111607 2111607 defendant Lussher Richard tanner 618499 618499 Lussher, Richard, of Lynge, tanner 0
4250301 2113081 2113081 defendant Curtys Henry tailor 618499 618499 Curtys, Henry, of Lynge, tailor 1
4257579 2115510 2115510 defendant Newby Edmund miller 618499 618499 Newby, Edmund, of Lynge, miller 0
4264259 2117693 2117693 defendant Leman John butcher 618499 618499 Leman John, of Lynge, butcher 1
4264266 2117694 2117694 defendant Mayes William miller 618499 618499 Mayes, William, of Lynge, miller 2
4275826 2121495 2121495 defendant Lackthorpe Richard butcher 618499 618499 Lackthorpe, Richard, of Lynge, butcher 1
4278614 2122454 2122454 defendant Russon Richard mercer 618499 618499 Russon, Richard, of Lynge, mercer 0
4278615 2122454 2122454 defendant Warden John sherman 618499 618499 Warden, John, of Lynge, sherman 1
4278616 2122454 2122454 defendant Burges Robert   618499 618499 Burges, Robert, of Lynge, "boller" or bowl maker 2
4284021 2124328 2124328 defendant Leman Richard yeoman 618499 618499 Leman, Richard, of Lynge, yeoman 0
4285886 2125004 2125004 defendant Horsman George gent 618499 618499 Horsman, George, of Lynge, gent 0
4287412 2125549 2125549 defendant Mayes William miller 618499 618499 Mayes, William, of Lynge, miller 1
4287759 2125672 2125672 defendant Paston John   618499 618499 Paston, John, of Lynge, linen weaver 0
4287760 2125672 2125672 defendant Allen William, junior husbandman 618499 618499 Allen, William, junior, of Lynge, husbandman 1
4288960 2126107 2126107 defendant Newby Edmund miller 618499 618499 Newby, Edmund, of Lynge, miller 0
4290906 2126806 2126806 defendant Grange Richard clerk 618499 618499 Grange, Richard, of Lynge, clerk 0
4290908 2126806 2126806 defendant Leaman Richard yeoman 618499 618499 Leaman, Richard, of Lynge, yeoman 2
4311417 2134136 2134136 defendant Burges Robert   618499 618499 Burges, Robert, of Lynge, "boller" 0
4311418 2134136 2134136 defendant Daynes William   618499 618499 Daynes, William, of Lynge, "boller" 1
4311817 2134270 2134270 defendant Norton John butcher 618499 618499 Norton, John, of Lynge, butcher 1
4324472 2138578 2138578 defendant Pulline William smith 618499 618499 Pulline, William, of Lynge, or of Langporte Estover, smith 0
4326987 2139358 2139358 defendant Graunge Richard clerk 618499 618499 Graunge, Richard, of Lynge, clerk 0
4326988 2139358 2139358 defendant Leman Richard yeoman 618499 618499 Leman, Richard, of Lynge, yeoman 1
4347884 2146511 2146511 defendant Leman Richard yeoman 618499 618499 Leman, Richard, of Lynge, yeoman 0
4370422 2154471 2154471 defendant Tucker John butcher 618499 618499 Tucker, John, of Lynge, butcher 0
4382856 2158972 2158972 defendant Howse William yeoman 618499 618499 Howse, William, of Lynge, yeoman 0
4385183 2159733 2159733 defendant Davye Thomas yeoman 618499 618499 Davye, Thomas, of Lynge, yeoman 0
4385475 2159831 2159831 defendant Butler Henry gent 618499 618499 Butler, Henry, of Lynge, gent 3
4386217 2160070 2160070 defendant Rookewood Robert gent 618499 618499 Rookewood, Robert, of Lynge, gent 0
4386223 2160071 2160071 defendant Rookwood Robert gent 618499 618499 Rookwood, Robert, of Lynge, gent 0
4386983 2160301 2160301 defendant Grange Richard clerk 618499 618499 Grange, Richard, of Lynge, clerk 3
4390659 2161491 2161491 defendant Kent Thomas husbandman 618499 618499 Kent, Thomas, of Lynge, husbandman 1
4394387 2162722 2162722 defendant Treman Roger yeoman 618499 618499 Treman, Roger, of Lynge, yeoman 3
4395820 2163183 2163183 defendant Swynyard Robert yeoman 618499 618499 Swynyard, Robert, of Lynge, yeoman 1
4400047 2164603 2164603 defendant Grange Richard clerk 618499 618499 Grange, Richard, of Lynge, clerk 0
4454257 2186350 2186350 defendant Herveys William   618499 618499 Herveys, William, of Lynge 0
4454260 2186351 2186351 defendant Herveys William   618499 618499 Herveys, William, of Lynge 0
4952279 2342649 2342649 defendant Note William yeoman 618499 618499 together with Note, William, of Lynge, yeoman 1
5008405 2359349 2359349 defendant Skynner John husbandman 618499 618499 Skynner, John, of Lynge, husbandman 1
5026972 2364761 2364761 defendant Palmer John cordwainer or tinker 618499 618499 Palmer, John, of Lynge, cordwainer or tinker 1
5054193 2372847 2372847 defendant Harneys or Harveys John husbandman 618499 618499 Harneys or Harveys, John, of Lynge, husbandman 4
5105427 2388028 2388028 defendant Gatysende Nicholas husbandman 618499 618499 Gatysende, Nicholas, of Lynge, husbandman 0
5165656 2405697 2405697 defendant Repe John husbandman 618499 618499 Repe, John, of Lynge, husbandman 0
5166904 2406049 2406049 defendant Chaundeler Peter husbandman 618499 618499 Chaundeler, Peter, of Lynge, husbandman 0
5273402 2437292 2437292 defendant Bradlee Thomas   618499 618499 Bradlee, Thomas, of Lynge, bell hanger 1
5322722 2451872 2451872 defendant Goy Robert husbandman 618499 618499 Goy, Robert, of Lynge, husbandman 2
5322725 2451873 2451873 defendant Redman Thomas husbandman 618499 618499 Redman, Thomas, of Lynge, husbandman 0
5324120 2452299 2452299 defendant Couper John husbandman 618499 618499 Couper, John, of Lynge, husbandman 3
5586815 2530916 2530916 defendant Small Thomas (legal representative) 618499 618499 Small, Thomas, of Lynge, yeoman or miller, executor of 2

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