names

337 rows where place_id = 590032

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599639 1867530 1867530 plaintiff Vaghan Richard yeoman 590032 590032 Vaghan, Richard, of Kent, yeoman 0
3654488 1911663 1911663 defendant Frognall Alexander esq 590032 590032 Frognall, Alexander, of Kent, esq 0
3654491 1911664 1911664 defendant Frognall Alexander esq 590032 590032 Frognall, Alexander, of Kent, esq 1
3657660 1912653 1912653 defendant Plumton John yeoman 590032 590032 Plumton, John, of Kent, yeoman 2
3664716 1914917 1914917 plaintiff Scotte William   590032 590032 Scotte, William, of Kent, knight, Sheriff 0
3664722 1914918 1914918 plaintiff Scotte William   590032 590032 Scotte, William, of Kent, knight, Sheriff 0
3750407 1942046 1942046 defendant Chytlowe Thomas   590032 590032 Chytlowe, Thomas, of Kent 0
3894510 1988373 1988373 plaintiff Rowe Thomas gent 590032 590032 Rowe, Thomas, of Kent, gent 1
3937720 2002949 2002949 defendant Martin John brewer 590032 590032 Martin, John, of Kent, brewer 0
3942724 2004570 2004570 plaintiff Wydyard William   590032 590032 Wydyard, William, of Kent, cloth man 0
3945932 2005656 2005656 defendant Lamberd Thomas gent 590032 590032 Lamberd, Thomas, of Kent, gent 0
3945933 2005656 2005656 defendant Barlowe William gent 590032 590032 Barlowe, William, of Kent, gent 1
3948742 2006628 2006628 plaintiff Dens or Dunce Alexander clothier 590032 590032 Dens or Dunce, Alexander, of Kent, clothier 0
3957835 2009802 2009802 plaintiff Aldryche John   590032 590032 (Aldryche, John, of Kent 1
3961407 2011085 2011085 defendant Ovyngton Thomas gent 590032 590032 Ovyngton, Thomas, of Kent, gent 3
4205543 2097491 2097491 plaintiff Osborn William   590032 590032 Osborn, William, of Kent, clothier, administrators of 0
4208131 2098399 2098399 defendant Warley George clothier 590032 590032 Warley, George, of Kent, clothier 3
4333651 2141535 2141535 defendant Alesen Robert gent 590032 590032 Alesen, Robert, of Kent, gent 3
4347323 2146318 2146318 defendant Wattes Richard chapman 590032 590032 Wattes, Richard, of Kent, chapman 2
4414783 2169528 2169528 plaintiff Esthalle John de   590032 590032 Esthalle, John de, of Kent 0
4414784 2169528 2169528 defendant Skathebury John   590032 590032 Skathebury, John, of Kent 0
4415763 2169817 2169817 plaintiff Insula John de   590032 590032 Insula, John de, of Kent 0
4419033 2170818 2170818 plaintiff atte Coumbe John   590032 590032 atte Coumbe, John, of Kent 0
4419839 2171100 2171100 defendant Walkelyn Reginald   590032 590032 Walkelyn, Reginald, of Kent 0
4424298 2172442 2172442 plaintiff Huberd Thomas   590032 590032 Huberd, Thomas, of Kent, son of Richard Huberd 0
4432123 2174831 2174831 defendant Morris Richard   590032 590032 Morris, Richard, of Kent 2
4440047 2181813 2181813 defendant Appuldrefeld Henry   590032 590032 Appuldrefeld, Henry, of Kent 0
4440067 2181820 2181820 defendant Apuldrefeld Henry   590032 590032 Apuldrefeld, Henry, of Kent 0
4445393 2183508 2183508 defendant Aldon Thomas   590032 590032 Aldon, Thomas, of Kent, knight 2
4453221 2186016 2186016 defendant Sayer Pondo   590032 590032 Sayer, Pondo, of Kent 0
4453222 2186016 2186016 defendant Maston John   590032 590032 Maston, John, of Kent 1
4453227 2186018 2186018 defendant Sayer Pond   590032 590032 Sayer, Pond, of Kent 0
4453229 2186018 2186018 defendant Masoun John   590032 590032 Masoun, John, of Kent 2
4453232 2186019 2186019 defendant Sayer Pondo   590032 590032 Sayer, Pondo, of Kent 0
4453234 2186019 2186019 defendant Masoun John   590032 590032 Masoun, John, of Kent 2
4456242 2186974 2186974 defendant Warison John   590032 590032 Warison, John, of Kent 0
4462108 2188849 2188849 defendant Sayer John   590032 590032 Sayer, John, of Kent 1
4462112 2188850 2188850 defendant Sayer John   590032 590032 Sayer, John, of Kent 1
4466962 2190340 2190340 defendant Norwode Roger   590032 590032 Norwode, Roger, of Kent, knight 0
4471174 2191645 2191645 defendant Bewelle William   590032 590032 Bewelle, William, of Kent 2
4478802 2194040 2194040 plaintiff Holand Thomas de   590032 590032 Holand, Thomas de, of Kent 0
4479566 2194270 2194270 defendant St Oweyn Partick   590032 590032 St Oweyn, Partick, of Kent, esquire 0
4481574 2194934 2194934 defendant Wallere John   590032 590032 Wallere, John, of Kent 3
4481580 2194935 2194935 defendant Wallere John   590032 590032 Wallere, John, of Kent 4
4482611 2195265 2195265 defendant Lambe Francis   590032 590032 Lambe, Francis, of Kent 0
4482613 2195266 2195266 defendant Lambe Francis   590032 590032 Lambe, Francis, of Kent 0
4482977 2195371 2195371 defendant Bourne James de   590032 590032 Bourne, James de, of Kent 0
4486335 2196436 2196436 plaintiff Rykby Nicholas   590032 590032 Rykby, Nicholas, of Kent 0
4490188 2197643 2197643 defendant Lytilman Thomas   590032 590032 Lytilman, Thomas, of Kent, formerly bailiff of Great Dele 20
4490420 2197704 2197704 defendant Colepepyr John esq 590032 590032 Colepepyr, John, of Kent, esq 0
4490429 2197705 2197705 defendant Assheden John   590032 590032 Assheden, John, of Kent 1
4491506 2198029 2198029 plaintiff William Robert   590032 590032 William, Robert, of Kent 0
4492280 2198263 2198263 defendant Husy Henry   590032 590032 Husy, Henry, of Kent 0
4492282 2198263 2198263 defendant Sewere Henry   590032 590032 Sewere, Henry, of Kent 2
4492285 2198263 2198263 defendant Scarburgh John   590032 590032 Scarburgh, John, of Kent 5
4492288 2198264 2198264 defendant Sewere Henry   590032 590032 Sewere, Henry, of Kent 1
4492291 2198264 2198264 defendant Scarburgh John   590032 590032 Scarburgh, John, of Kent 4
4492626 2198396 2198396 defendant Mannton John de   590032 590032 Mannton, John de, of Kent 2
4492799 2198451 2198451 defendant Court Thomas   590032 590032 Court, Thomas, of Kent 0
4492811 2198456 2198456 defendant Court Thomas   590032 590032 Court, Thomas, of Kent 0
4493223 2198584 2198584 defendant Denman John   590032 590032 Denman, John, of Kent 0
4493511 2198675 2198675 defendant Savage Arnald   590032 590032 Savage, Arnald, of Kent, knight 0
4498285 2200120 2200120 defendant Langton John   590032 590032 Langton, John, of Kent 1
4500389 2200742 2200742 defendant Benge John   590032 590032 Benge, John, of Kent 2
4502746 2201437 2201437 defendant Barbour William   590032 590032 Barbour, William, of Kent, formerly servant of Jone Deveraux 2
4502799 2201451 2201451 defendant Potyn Nicholas (legal representative) 590032 590032 Potyn, Nicholas, of Kent, executors of 0
4502804 2201452 2201452 defendant Potyn Nicholas (legal representative) 590032 590032 Potyn, Nicholas, of Kent, executors of 0
4504810 2202046 2202046 defendant Hach Robert   590032 590032 Hach, Robert, of Kent 0
4504998 2202100 2202100 defendant Chaumburleyn Thomas   590032 590032 Chaumburleyn, Thomas, of Kent 1
4505568 2202269 2202269 defendant Longe Richard   590032 590032 Longe, Richard, of Kent 1
4505601 2202273 2202273 defendant Longe Richard   590032 590032 Longe, Richard, of Kent 1
4507032 2202670 2202670 defendant Pesenden Stephen   590032 590032 Pesenden, Stephen, of Kent 0
4511308 2203983 2203983 defendant Cobeham William esq 590032 590032 Cobeham, William, of Kent, esq 0
4511659 2204096 2204096 defendant Cokham Ralph esq 590032 590032 (Cokham, Ralph, of Kent, esq 1
4514539 2204968 2204968 defendant Wylmyngton Bertram de   590032 590032 Wylmyngton, Bertram de, of Kent 0
4517578 2205893 2205893 defendant Mongeham William   590032 590032 Mongeham, William, of Kent 2
4517580 2205893 2205893 defendant Warinclyf Thomas   590032 590032 Warinclyf, Thomas, of Kent 4
4518449 2206142 2206142 defendant Crophill John esq 590032 590032 Crophill, John, of Kent, son of Thomas Crophill, esq 0
4518450 2206142 2206142 defendant Glasier William skinner 590032 590032 Glasier, William, of Kent, skinner 1
4518455 2206143 2206143 defendant Glasier William skinner 590032 590032 Glasier, William, of Kent, skinner 1
4518657 2206210 2206210 plaintiff Donet Andrew   590032 590032 Donet, Andrew, of Kent 0
4521497 2207067 2207067 defendant Sepvans William   590032 590032 Sepvans, William, of Kent, knight 0
4523980 2207832 2207832 defendant Holdenne Richard   590032 590032 Holdenne, Richard, of Kent 0
4525261 2208240 2208240 defendant Newale Robert   590032 590032 Newale, Robert, of Kent 0
4525263 2208241 2208241 defendant Newall Robert   590032 590032 Newall, Robert, of Kent 0
4525265 2208242 2208242 defendant Newall Robert   590032 590032 Newall, Robert, of Kent 0
4526932 2208705 2208705 defendant Hawe Robert   590032 590032 Hawe, Robert, of Kent 0
4528439 2209173 2209173 defendant Payntour John clerk 590032 590032 Payntour, John, of Kent, clerk 0
4529786 2209600 2209600 defendant Wotte William   590032 590032 Wotte, William, of Kent 1
4530074 2209693 2209693 defendant atte Capelle William   590032 590032 atte Capelle, William, of Kent 6
4530088 2209697 2209697 defendant Polsham Thomas   590032 590032 Polsham, Thomas, of Kent 0
4530090 2209698 2209698 defendant Polsham Thomas   590032 590032 Polsham, Thomas, of Kent 0
4534358 2211013 2211013 defendant Chartham William   590032 590032 Chartham, William, of Kent 0
4534573 2211082 2211082 defendant Borne James   590032 590032 Borne, James, of Kent 0
4534575 2211083 2211083 defendant Borne James   590032 590032 Borne, James, of Kent 0
4535520 2211380 2211380 plaintiff Smale John   590032 590032 Smale, John, of Kent 0
4535526 2211382 2211382 defendant Riche alias Harecourt John   590032 590032 Riche alias Harecourt, John, of Kent 0
4543949 2214014 2214014 defendant Chapel Thomas   590032 590032 Chapel, Thomas, of Kent 0
4545202 2214420 2214420 defendant Aghton Geoffrey de   590032 590032 Aghton, Geoffrey de, of Kent 3
4545793 2214613 2214613 defendant Stotte Richard   590032 590032 Stotte, Richard, of Kent 1

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