names

116 rows where place_id = 676240

✎ 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
4014506 2029913 2029913 defendant Tayler William   676240 676240 Tayler, William, of Worstede, wool chapman 0
4021995 2032595 2032595 defendant Leverton Cuthbert gent 676240 676240 Leverton, Cuthbert, of Worstede, gent 0
4026490 2034122 2034122 plaintiff Bysshoppe John gent 676240 676240 Bysshoppe, John, of Worstede, gent 0
4054562 2044021 2044021 defendant Leverton Cuthbert gent 676240 676240 Leverton, Cuthbert, of Worstede, gent 0
4239829 2109566 2109566 defendant Glannfeld John yeoman 676240 676240 Glannfeld, John, of Worstede, yeoman 0
4439511 2181622 2181622 defendant Skamel Robert   676240 676240 Skamel, Robert, of Worstede 2
4454258 2186350 2186350 defendant Skete Robert   676240 676240 Skete, Robert, of Worstede 1
4454261 2186351 2186351 defendant Skott Robert   676240 676240 Skott, Robert, of Worstede 1
4480649 2194614 2194614 defendant Yenne Robert   676240 676240 Yenne, Robert, of Worstede 0
4483424 2195504 2195504 plaintiff Northgate Roger de   676240 676240 Northgate, Roger de, of Worstede 0
4485659 2196220 2196220 plaintiff Resham John   676240 676240 Resham, John, of Worstede 0
4485660 2196220 2196220 defendant Massyngham William   676240 676240 Massyngham, William, of Worstede 0
4485661 2196221 2196221 plaintiff Resham John   676240 676240 Resham, John, of Worstede 0
4485662 2196221 2196221 defendant Massyngham William   676240 676240 Massyngham, William, of Worstede 0
4485963 2196316 2196316 plaintiff Rofham John   676240 676240 Rofham, John, of Worstede 0
4485964 2196316 2196316 defendant Massynham William   676240 676240 Massynham, William, of Worstede 0
4488937 2197256 2197256 defendant Cole Roger   676240 676240 Cole, Roger, of Worstede 0
4517301 2205812 2205812 defendant Bryan Robert   676240 676240 Bryan, Robert, of Worstede 1
4536230 2211608 2211608 defendant Bena_ Alan -aster 676240 676240 Bena_, Alan, of Worstede, -aster 0
4569952 2222172 2222172 defendant Wacy John   676240 676240 Wacy, John, of Worstede 0
4575299 2223788 2223788 defendant Purk William   676240 676240 Purk, William, of Worstede 0
4576302 2224093 2224093 defendant Rynhale Peter   676240 676240 Rynhale, Peter, of Worstede 0
4582608 2225999 2225999 defendant Purkes William   676240 676240 Purkes, William, of Worstede 2
4587564 2227515 2227515 plaintiff Seyve Thomas   676240 676240 Seyve, Thomas, of Worstede 3
4621218 2237625 2237625 defendant Wacy John   676240 676240 Wacy, John, of Worstede 0
4636393 2242219 2242219 defendant Felde John   676240 676240 Felde, John, of Worstede 0
4647446 2245316 2245316 plaintiff Seyve Thomas   676240 676240 Seyve, Thomas, of Worstede 0
4647453 2245317 2245317 plaintiff Seyve Thomas   676240 676240 Seyve, Thomas, of Worstede 0
4658524 2248546 2248546 defendant Baron John shoemaker 676240 676240 Baron, John, of Worstede, shoemaker 4
4658953 2248671 2248671 defendant Refham Adam fuller 676240 676240 Refham, Adam, of Worstede, fuller 0
4658954 2248671 2248671 defendant Sperhauk William weaver 676240 676240 Sperhauk, William, of Worstede, weaver 1
4662905 2249860 2249860 defendant Skeet John gent 676240 676240 Skeet, John, of Worstede, gent 0
4662908 2249861 2249861 defendant Skeet John gent 676240 676240 Skeet, John, of Worstede, gent 0
4682620 2260181 2260181 defendant Rauce Roger yeoman 676240 676240 Rauce, Roger, of Worstede, yeoman 0
4682621 2260181 2260181 defendant Cuttyng John yeoman 676240 676240 Cuttyng, John, of Worstede, yeoman 1
4712143 2269108 2269108 defendant Felde John laborer 676240 676240 Felde, John, of Worstede, laborer 2
4713187 2269452 2269452 defendant Begge William husbandman 676240 676240 Begge, William, of Worstede, husbandman 1
4720689 2271805 2271805 defendant Den Richard yeoman 676240 676240 Den, Richard, of Worstede, yeoman 0
4739346 2277393 2277393 defendant Raute Robert husbandman 676240 676240 Raute, Robert, of Worstede, husbandman 0
4743794 2278714 2278714 defendant Spicer John yeoman 676240 676240 Spicer, John, of Worstede, yeoman 3
4745408 2279164 2279164 defendant Seyne John yeoman 676240 676240 Seyne, John, of Worstede, yeoman 0
4745601 2279227 2279227 defendant James Richard   676240 676240 James, Richard, of Worstede, worsted man 0
4760212 2283545 2283545 defendant Drake John yeoman 676240 676240 Drake, John, of Worstede, yeoman 3
4778030 2289115 2289115 defendant Crowegate Thomas yeoman 676240 676240 Crowegate, Thomas, of Worstede, yeoman 1
4782805 2290639 2290639 defendant Hemmyng John husbandman 676240 676240 Hemmyng, John, of Worstede, husbandman 0
4791923 2293578 2293578 defendant Sherman Ralph yeoman 676240 676240 Sherman, Ralph, of Worstede, yeoman 2
4791929 2293580 2293580 defendant Deye Nicholas chapman 676240 676240 Deye, Nicholas, of Worstede, chapman 2
4799992 2296181 2296181 plaintiff Wacy John   676240 676240 Wacy, John, of Worstede 0
4799994 2296181 2296181 defendant Cuttyng John clerk 676240 676240 Cuttyng, John, of Worstede, clerk 0
4799995 2296181 2296181 defendant Cuttyng John husbandman 676240 676240 Cuttyng, John, of Worstede, husbandman 1
4827890 2304779 2304779 defendant Bonde Thomas chaplain 676240 676240 Bonde, Thomas, of Worstede, chaplain 0
4858266 2313958 2313958 defendant Bolt Richard   676240 676240 Bolt, Richard, of Worstede, worsted weaver 0
4867091 2316670 2316670 defendant Childe William miller 676240 676240 Childe, William, of Worstede, miller 0
4874273 2318899 2318899 defendant Briggate Henry husbandman 676240 676240 Briggate, Henry, of Worstede, husbandman 0
4885053 2322218 2322218 defendant Brunsted John baker 676240 676240 Brunsted, John, of Worstede, baker 4
4885101 2322233 2322233 defendant Sprygy Thomas chapman 676240 676240 Sprygy, Thomas, of Worstede, chapman 0
4900096 2326660 2326660 defendant Dey Robert yeoman 676240 676240 Dey, Robert, of Worstede, yeoman 4
4937056 2337963 2337963 defendant Brygate Henry husbandman 676240 676240 Brygate, Henry, of Worstede, husbandman 6
4938129 2338305 2338305 defendant Bolt Richard yeoman 676240 676240 Bolt, Richard, of Worstede, yeoman 3
4964642 2346331 2346331 defendant Crowegate Thomas butcher 676240 676240 Crowegate, Thomas, of Worstede, butcher 0
4970691 2348174 2348174 defendant Fowler William butcher 676240 676240 Fowler, William, of Worstede, butcher 0
4970704 2348179 2348179 defendant Fowler William butcher 676240 676240 Fowler, William, of Worstede, butcher 0
4998001 2356263 2356263 defendant Cogman Richard husbandman 676240 676240 Cogman, Richard, of Worstede, husbandman 1
5002449 2357628 2357628 defendant Cogman Richard yeoman 676240 676240 Cogman, Richard, of Worstede, yeoman 0
5004189 2358115 2358115 defendant Beale Robert husbandman 676240 676240 Beale, Robert, of Worstede, husbandman 2
5004190 2358115 2358115 defendant Spryggy Thomas chapman 676240 676240 Spryggy, Thomas, of Worstede, chapman 3
5004191 2358115 2358115 defendant Burgh Nicholas chapman 676240 676240 Burgh, Nicholas, of Worstede, chapman 4
5017334 2361958 2361958 defendant Stannard Robert husbandman 676240 676240 Stannard, Robert, of Worstede, husbandman 0
5029158 2365405 2365405 defendant Cogman Richard yeoman 676240 676240 Cogman, Richard, of Worstede, yeoman 0
5029159 2365405 2365405 defendant Cogman Geoffrey smith 676240 676240 Cogman, Geoffrey, of Worstede, smith 1
5030278 2365724 2365724 defendant Miller John miller 676240 676240 Miller, John, of Worstede, miller 0
5052545 2372353 2372353 defendant Gynne Robert chapman 676240 676240 Gynne, Robert, of Worstede, chapman 2
5065390 2376183 2376183 defendant Dyn John husbandman 676240 676240 Dyn, John, of Worstede, husbandman 0
5065391 2376183 2376183 defendant Dyn Robert   676240 676240 Dyn, Robert, of Worstede, wright 1
5065393 2376184 2376184 defendant Dyn John husbandman 676240 676240 Dyn, John, of Worstede, husbandman 0
5065394 2376184 2376184 defendant Dyn Robert   676240 676240 Dyn, Robert, of Worstede, wright 1
5068186 2376988 2376988 defendant Kamund Nicholas yeoman 676240 676240 Kamund, Nicholas, of Worstede, yeoman 0
5072410 2378237 2378237 plaintiff Tante Henry chaplain 676240 676240 Tante, Henry, of Worstede, chaplain 0
5073054 2378426 2378426 defendant Sperhauk Robert yeoman 676240 676240 Sperhauk, Robert, of Worstede, yeoman 3
5077341 2379719 2379719 defendant Blome Robert husbandman 676240 676240 Blome, Robert, of Worstede, husbandman 4
5103562 2387468 2387468 defendant Cokeman Richard yeoman 676240 676240 Cokeman, Richard, of Worstede, yeoman 0
5103563 2387468 2387468 defendant Benselyn John   676240 676240 Benselyn, John, of Worstede, freemason 1
5103564 2387468 2387468 defendant Lawys Richard husbandman 676240 676240 Lawys, Richard, of Worstede, husbandman 2
5103568 2387470 2387470 defendant Yemmys John husbandman 676240 676240 Yemmys, John, of Worstede, husbandman 0
5109647 2389251 2389251 plaintiff Glaveyn Thomas (legal representative) 676240 676240 Glaveyn, Thomas, of Worstede, executors of 0
5109650 2389251 2389251 plaintiff Dykemans Thomas   676240 676240 Dykemans, Thomas, of Worstede 3
5109655 2389252 2389252 plaintiff Glaveyn Thomas (legal representative) 676240 676240 Glaveyn, Thomas, of Worstede, executors of 0
5109658 2389252 2389252 plaintiff Dykemans Thomas   676240 676240 Dykemans, Thomas, of Worstede 3
5120524 2392432 2392432 defendant Hemmyng William chaplain 676240 676240 Hemmyng, William, of Worstede, chaplain 0
5125881 2394056 2394056 defendant Symond Arnold baker 676240 676240 (Symond, Arnold, of Worstede, baker 2
5140045 2398192 2398192 defendant Hemmyng William clerk 676240 676240 Hemmyng, William, of Worstede, clerk 0
5144490 2399549 2399549 defendant Symondes Arnald   676240 676240 Symondes, Arnald, of Worstede, baker, Joan, his wife 2
5150022 2401140 2401140 defendant Scarburgh John   676240 676240 Scarburgh, John, of Worstede, worseted weaver 0
5150564 2401306 2401306 defendant Heigham Robert mercer 676240 676240 Heigham, Robert, of Worstede, mercer 2
5153181 2402077 2402077 defendant Raute William husbandman 676240 676240 Raute, William, of Worstede, husbandman 1
5165794 2405739 2405739 defendant Wattes William butcher 676240 676240 Wattes, William, of Worstede, butcher 1
5170133 2406995 2406995 defendant Knapton John husbandman 676240 676240 Knapton, John, of Worstede, husbandman 0
5180317 2409983 2409983 defendant Wattes William butcher 676240 676240 Wattes, William, of Worstede, butcher 1
5196672 2414778 2414778 defendant Scolehous Nicholas mercer 676240 676240 Scolehous, Nicholas, of Worstede, mercer 1
5209745 2418588 2418588 defendant Burgh Nicholas mercer 676240 676240 Burgh, Nicholas, of Worstede, mercer 0

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