names

86 rows where place_id = 595806

✎ 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
3621994 1874421 1874421 defendant Wardyn Simon brewer 595806 595806 Wardyn, Simon, of Kyngesbury, brewer 2
3623957 1875024 1875024 defendant Smyth William husbandman 595806 595806 Smyth, William, of Kyngesbury, husbandman 0
3790059 1954707 1954707 defendant Lygh Thomas husbandman 595806 595806 Lygh, Thomas, of Kyngesbury, husbandman 1
3930926 2000682 2000682 defendant Stonard William husbandman 595806 595806 Stonard, William, of Kyngesbury, husbandman 0
3944047 2005028 2005028 defendant Chamber Robert husbandman 595806 595806 Chamber, Robert, of Kyngesbury, husbandman 0
3957359 2009638 2009638 defendant Roke Thomas husbandman 595806 595806 Roke, Thomas, of Kyngesbury, husbandman 0
4006325 2027041 2027041 defendant Harrys Thomas husbandman 595806 595806 Harrys, Thomas, of Kyngesbury, husbandman 0
4139367 2074443 2074443 defendant Whyte John yeoman 595806 595806 Whyte, John, of Kyngesbury, yeoman 0
4144726 2076316 2076316 defendant Smyth Nicholas joiner 595806 595806 Smyth, Nicholas, of Kyngesbury, joiner 0
4170281 2085098 2085098 defendant Stillard alias Clarke Thomas yeoman 595806 595806 Stillard alias Clarke, Thomas, of Kyngesbury, yeoman 1
4194675 2093696 2093696 defendant Sheparde Thomas (legal representative) 595806 595806 Sheparde, Thomas, of Kyngesbury, yeoman, executor of 0
4444038 2183104 2183104 defendant Smyth Willliam   595806 595806 Smyth, Willliam, of Kyngesbury 2
4454641 2186469 2186469 defendant Clerk John   595806 595806 Clerk, John, of Kyngesbury 0
4462277 2188898 2188898 plaintiff Sybely Robert   595806 595806 Sybely, Robert, of Kyngesbury 0
4462484 2188959 2188959 defendant Smyth William   595806 595806 Smyth, William, of Kyngesbury 2
4485929 2196305 2196305 defendant Smyth William   595806 595806 Smyth, William, of Kyngesbury 1
4552220 2216648 2216648 defendant Hamond John   595806 595806 Hamond, John, of Kyngesbury 0
4596172 2230056 2230056 defendant Brent Thomas butcher 595806 595806 Brent, Thomas, of Kyngesbury, butcher 0
4622550 2238030 2238030 defendant Brook John   595806 595806 Brook, John, of Kyngesbury 1
4623117 2238206 2238206 defendant Loone William   595806 595806 Loone, William, of Kyngesbury 1
4666177 2250891 2250891 defendant Brent Thomas butcher 595806 595806 Brent, Thomas, of Kyngesbury, butcher 2
4674509 2257640 2257640 defendant Russell Nicholas husbandman 595806 595806 Russell, Nicholas, of Kyngesbury, husbandman 0
4682202 2260055 2260055 defendant Nytere Thoams husabndman 595806 595806 Nytere, Thoams, of Kyngesbury, husabndman 1
4686096 2261243 2261243 defendant Lonyn or Lovyn John husbandman 595806 595806 Lonyn or Lovyn, John, of Kyngesbury, husbandman 0
4699645 2265340 2265340 defendant Russell Nicholas husbandman 595806 595806 Russell, Nicholas, of Kyngesbury, husbandman 0
4710310 2268579 2268579 defendant Lovyn John husbandman 595806 595806 Lovyn, John, of Kyngesbury, husbandman 2
4711679 2268974 2268974 defendant Gavelbrugge John gent 595806 595806 Gavelbrugge, John, of Kyngesbury, gent 1
4718354 2271080 2271080 defendant Brent William husbandman 595806 595806 Brent, William, of Kyngesbury, husbandman 1
4734320 2275906 2275906 defendant Gavelbrygge John gent 595806 595806 Gavelbrygge, John, of Kyngesbury, gent 1
4734333 2275908 2275908 defendant Denebaude William   595806 595806 (Denebaude, William, of Kyngesbury, franklin 1
4734381 2275923 2275923 defendant Gawelbrigge John husbandman 595806 595806 Gawelbrigge, John, of Kyngesbury, husbandman 0
4759130 2283202 2283202 defendant Pyn John husbandman 595806 595806 Pyn, John, of Kyngesbury, husbandman 3
4764010 2284730 2284730 plaintiff Hamond John   595806 595806 Hamond, John, of Kyngesbury 2
4764011 2284730 2284730 defendant Seykyn William husbandman 595806 595806 Seykyn, William, of Kyngesbury, husbandman 0
4766757 2285594 2285594 plaintiff Lone or Lore Thomas   595806 595806 Lone or Lore, Thomas, of Kyngesbury 0
4769493 2286438 2286438 defendant Bury William gent 595806 595806 Bury, William, of Kyngesbury, gent 0
4769513 2286444 2286444 defendant Brent William husbandman 595806 595806 Brent, William, of Kyngesbury, husbandman 3
4771902 2287186 2287186 defendant atte Lake John husbandman 595806 595806 atte Lake, John, of Kyngesbury, husbandman 5
4771911 2287187 2287187 defendant atte Lake John husbandman 595806 595806 atte Lake, John, of Kyngesbury, husbandman 5
4781222 2290139 2290139 defendant Pyn John husbandman 595806 595806 Pyn, John, of Kyngesbury, husbandman 3
4791194 2293347 2293347 plaintiff Love or Lone Thomas   595806 595806 Love or Lone, Thomas, of Kyngesbury 0
4793972 2294243 2294243 defendant Bury William, junior gent 595806 595806 Bury, William, junior, of Kyngesbury, gent 0
4793974 2294244 2294244 defendant Bury William, junior gent 595806 595806 Bury, William, junior, of Kyngesbury, gent 0
4812532 2300036 2300036 defendant Love William   595806 595806 Love, William, of Kyngesbury, parson 0
4825704 2304082 2304082 defendant Hamond Richard husbandman 595806 595806 Hamond, Richard, of Kyngesbury, husbandman 0
4825708 2304083 2304083 defendant Saykyn William husbandman 595806 595806 Saykyn, William, of Kyngesbury, husbandman 0
4829095 2305141 2305141 defendant Lovyn John husbandman 595806 595806 Lovyn, John, of Kyngesbury, husbandman 1
4845715 2310171 2310171 defendant Saykyn William husbandman 595806 595806 Saykyn, William, of Kyngesbury, husbandman 0
4845717 2310172 2310172 defendant Edward Henry husbandman 595806 595806 Edward, Henry, of Kyngesbury, husbandman 0
4848459 2310992 2310992 defendant Lovyn John husbandman 595806 595806 Lovyn, John, of Kyngesbury, husbandman 4
4861541 2314978 2314978 defendant Bygport Thomas husbandman 595806 595806 Bygport, Thomas, of Kyngesbury, husbandman 3
4861542 2314978 2314978 defendant Baker William husbandman 595806 595806 Baker, William, of Kyngesbury, husbandman 4
4884974 2322200 2322200 defendant Langebrouk Thomas butcher 595806 595806 Langebrouk, Thomas, of Kyngesbury, butcher 0
4908780 2329297 2329297 defendant Nyter Baldewinn gent 595806 595806 Nyter, Baldewinn, of Kyngesbury, gent 0
4911836 2330204 2330204 defendant Wrynche Geoffrey husbandman 595806 595806 Wrynche, Geoffrey, of Kyngesbury, husbandman 0
4911837 2330204 2330204 defendant Altot Richard husbandman 595806 595806 Altot, Richard, of Kyngesbury, husbandman 1
4938101 2338297 2338297 defendant atte Wode Richard husbandman 595806 595806 atte Wode, Richard, of Kyngesbury, husbandman 0
4938103 2338298 2338298 defendant atte Wode Richard husbandman 595806 595806 atte Wode, Richard, of Kyngesbury, husbandman 0
4945374 2340529 2340529 defendant Wode Richard husbandman 595806 595806 Wode, Richard, of Kyngesbury, husbandman 1
4947386 2341179 2341179 defendant atte Wode Richard husbandman 595806 595806 atte Wode, Richard, of Kyngesbury, husbandman 0
4979858 2350930 2350930 defendant Maior John carpenter 595806 595806 Maior, John, of Kyngesbury, carpenter 0
4980011 2350976 2350976 defendant Hede John husbandman 595806 595806 Hede, John, of Kyngesbury, husbandman 2
5101971 2386999 2386999 defendant Balche Walter fisher 595806 595806 Balche, Walter, of Kyngesbury, fisher 3
5184623 2411250 2411250 defendant Bythehede John husbandman 595806 595806 Bythehede, John, of Kyngesbury, husbandman 1
5184624 2411250 2411250 defendant Hedde John husbandman 595806 595806 Hedde, John, of Kyngesbury, husbandman 2
5184626 2411250 2411250 defendant Danyell John husbandman 595806 595806 Danyell, John, of Kyngesbury, husbandman 4
5187002 2411937 2411937 defendant Edmond John brewer 595806 595806 Edmond, John, of Kyngesbury, brewer 1
5187008 2411938 2411938 defendant Edmond John brewer 595806 595806 Edmond, John, of Kyngesbury, brewer 1
5195316 2414378 2414378 defendant Edward John husbandman 595806 595806 Edward, John, of Kyngesbury, husbandman 0
5271887 2436862 2436862 defendant Edward (illegible) collier 595806 595806 Edward, ----, of Kyngesbury, collier 3
5361412 2463590 2463590 defendant Chalkhill Ivo husbandman 595806 595806 Chalkhill, Ivo, of Kyngesbury, husbandman 0
5410323 2478040 2478040 defendant Edwardys Margaret widow 595806 595806 Edwardys, Margaret, of Kyngesbury, widow 0
5461520 2493396 2493396 defendant Edward William (legal representative) 595806 595806 Edward, William, of Kyngesbury, husbandman, executors of 0
5461521 2493396 2493396 defendant Edward John husbandman 595806 595806 (Edward, John, of Kyngesbury, husbandman 1
5467690 2495268 2495268 defendant Wrench John husbandman 595806 595806 Wrench, John, of Kyngesbury, husbandman 0
5493481 2502963 2502963 defendant Shepard John husbandman 595806 595806 Shepard, John, of Kyngesbury, husbandman 0
5493482 2502963 2502963 defendant Wrench John, senior husbandman 595806 595806 Wrench, John, senior, of Kyngesbury, husbandman 1
5499709 2504855 2504855 defendant Canon John husbandman 595806 595806 Canon, John, of Kyngesbury, husbandman 3
5544425 2518367 2518367 defendant Phelpes William butcher 595806 595806 Phelpes, William, of Kyngesbury, butcher 2
5545743 2518745 2518745 defendant Farthyng John husbandman 595806 595806 Farthyng, John, of Kyngesbury, husbandman 1
5573228 2526722 2526722 defendant Hurcumbe Thomas husbandman 595806 595806 Hurcumbe, Thomas, of Kyngesbury, husbandman 0
5573229 2526722 2526722 defendant Hurcumbe John, senior laborer 595806 595806 Hurcumbe, John, senior, of Kyngesbury, laborer 1
5573230 2526722 2526722 defendant Hurcumbe John, junior laborer 595806 595806 Hurcumbe, John, junior, of Kyngesbury, laborer 2
5626819 2552359 2552359 defendant Nyter Thomas gent 595806 595806 Nyter, Thomas, of Kyngesbury, gent 0
5636055 2555234 2555234 defendant Duke Henry husbandman 595806 595806 Duke, Henry, of Kyngesbury, husbandman 1
5636056 2555234 2555234 defendant Duke William husbandman 595806 595806 Duke, William, of Kyngesbury, husbandman 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);