names

49 rows where place_id = 588104

✎ 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
3593379 1865562 1865562 defendant Nasshe Lawrence laborer 588104 588104 Nasshe, Lawrence, of Sturrey, laborer 0
3618857 1873510 1873510 defendant Milford Thomas husbandman 588104 588104 Milford, Thomas, of Sturrey, husbandman 1
3715056 1931005 1931005 defendant Benett John husbandman 588104 588104 Benett, John, of Sturrey, husbandman 2
3783838 1952716 1952716 defendant Ovend William husbandman 588104 588104 Ovend, William, of Sturrey, husbandman 0
3802327 1958626 1958626 defendant Mytchell Richard tanner 588104 588104 Mytchell, Richard, of Sturrey, tanner 0
3836404 1969295 1969295 defendant Idenden Thomas butcher 588104 588104 Idenden, Thomas, of Sturrey, butcher 0
3851021 1973912 1973912 defendant Wylkynson Thomas butcher 588104 588104 Wylkynson, Thomas, of Sturrey, butcher 0
3859845 1976793 1976793 defendant Savage James husbandman 588104 588104 Savage, James, of Sturrey, husbandman 0
3961302 2011051 2011051 defendant Frankleyn Michael gent 588104 588104 Frankleyn, Michael, of Sturrey, gent 0
3981958 2018309 2018309 defendant Alee John tailor 588104 588104 Alee, John, of Sturrey, tailor 4
4073310 2050743 2050743 defendant Dowle John husbandman 588104 588104 Dowle, John, of Sturrey, husbandman 0
4073312 2050743 2050743 defendant Grosse Baldwin tailor 588104 588104 Grosse, Baldwin, of Sturrey, tailor 2
4176734 2087333 2087333 defendant Phillippe John yeoman 588104 588104 Phillippe, John, of Sturrey, yeoman 0
4292367 2127336 2127336 defendant Thorne George yeoman 588104 588104 Thorne, George, of Sturrey, yeoman 0
4362045 2151471 2151471 defendant Scott Richard glover 588104 588104 Scott, Richard, of Sturrey, glover 0
4366047 2152898 2152898 defendant Deacon John glover 588104 588104 Deacon, John, of Sturrey, glover 0
4379764 2157857 2157857 defendant Carpenter Vincent laborer 588104 588104 Carpenter, Vincent, of Sturrey, laborer 0
4640319 2243283 2243283 defendant Knyght William baker 588104 588104 Knyght, William, of Sturrey, baker 2
4832413 2306172 2306172 defendant Estwelle William husbandman 588104 588104 Estwelle, William, of Sturrey, husbandman 0
4832414 2306172 2306172 defendant Caldecote Thomas husbandman 588104 588104 Caldecote, Thomas, of Sturrey, husbandman 1
4832415 2306172 2306172 defendant Stud (illegible) husbandman 588104 588104 Stud, _, of Sturrey, husbandman 2
4839055 2308144 2308144 defendant Bredlond John husbandman 588104 588104 Bredlond, John, of Sturrey, husbandman 2
4919598 2332634 2332634 defendant Breddelonde John husbandman 588104 588104 Breddelonde, John, of Sturrey, husbandman 0
4939138 2338627 2338627 defendant Forstall William husbandman 588104 588104 Forstall, William, of Sturrey, husbandman 1
4939139 2338627 2338627 defendant Benge John husbandman 588104 588104 Benge, John, of Sturrey, husbandman 2
4945308 2340508 2340508 defendant Stud Richard laborer 588104 588104 Stud, Richard, of Sturrey, laborer 1
4945309 2340508 2340508 defendant Bredlond John husbandman 588104 588104 Bredlond, John, of Sturrey, husbandman 2
4961754 2345478 2345478 defendant Brodlond John   588104 588104 Brodlond, John, of Sturrey 3
5044741 2370062 2370062 plaintiff Honymouth James yeoman 588104 588104 Honymouth, James, of Sturrey, yeoman 0
5076288 2379409 2379409 defendant Aleyn Nicholas yeoman 588104 588104 Aleyn, Nicholas, of Sturrey, yeoman 0
5099970 2386427 2386427 defendant Sandyr Richard husbandman 588104 588104 Sandyr, Richard, of Sturrey, husbandman 0
5170502 2407099 2407099 plaintiff Hope James (legal representative) 588104 588104 Hope, James, of Sturrey, executors of 0
5194975 2414282 2414282 defendant Maycot John farmer 588104 588104 Maycot, John, of Sturrey, farmer 2
5205607 2417384 2417384 plaintiff Hawe Robert   588104 588104 Hawe, Robert, of Sturrey 0
5205965 2417478 2417478 defendant Hamon John yeoman 588104 588104 Hamon, John, of Sturrey, yeoman 0
5249849 2430068 2430068 defendant Nedam William fuller 588104 588104 Nedam, William, of Sturrey, fuller 1
5249852 2430069 2430069 defendant Nedam William fuller 588104 588104 Nedam, William, of Sturrey, fuller 1
5260470 2433407 2433407 defendant atte Sole John husbandman 588104 588104 atte Sole, John, of Sturrey, or of Westbere, husbandman 0
5267907 2435725 2435725 defendant Lotte John   588104 588104 Lotte, John, of Sturrey 4
5275939 2438034 2438034 defendant Mecote John yeoman 588104 588104 Mecote, John, of Sturrey, yeoman 0
5275942 2438035 2438035 defendant Mecote John yeoman 588104 588104 Mecote, John, of Sturrey, yeoman 0
5295126 2443564 2443564 defendant Mecotte John yeoman 588104 588104 Mecotte, John, of Sturrey, yeoman 0
5379225 2469096 2469096 defendant Johnson Richard chaplain 588104 588104 Johnson, Richard, of Sturrey, chaplain 0
5508349 2507485 2507485 defendant Mecot John yeoman 588104 588104 Mecot, John, of Sturrey, yeoman 0
5510252 2508041 2508041 defendant Ovende or Onende Thomas husbandman 588104 588104 Ovende or Onende, Thomas, of Sturrey, husbandman 0
5573441 2526789 2526789 defendant Reynold William husbandman 588104 588104 Reynold, William, of Sturrey, husbandman 1
5632759 2554260 2554260 defendant Gore John husbandman 588104 588104 Gore, John, of Sturrey, husbandman 0
5632760 2554260 2554260 defendant Elmere John miller 588104 588104 Elmere, John, of Sturrey, miller 1
5632761 2554260 2554260 defendant Neym Henry fuller 588104 588104 Neym, Henry, of Sturrey, fuller 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);