names

128 rows where place_id = 590408

✎ 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
3601123 1868014 1868014 defendant Shephard Henry yeoman 590408 590408 Shephard, Henry, of Shipden, yeoman 0
3608134 1870196 1870196 defendant Shepherd Henry yeoman 590408 590408 Shepherd, Henry, of Shipden, yeoman 0
3650439 1910506 1910506 plaintiff Savyle Robert gent 590408 590408 Savyle, Robert, of Shipden, gent 0
3790532 1954862 1954862 defendant Archer Robert tailor 590408 590408 Archer, Robert, of Shipden at Crowmer, tailor 0
4050371 2042564 2042564 plaintiff Waterhous John gent 590408 590408 Waterhous, John, of Shipden, gent 0
4123549 2068724 2068724 defendant Ymmes Richard carpenter 590408 590408 Ymmes, Richard, of Shipden alias Cromer, carpenter 1
4150758 2078404 2078404 defendant Sterne Thomas gent 590408 590408 Sterne, Thomas, of Shipden alias Cromer, gent 1
4166718 2083855 2083855 defendant Underwood Robert gent 590408 590408 Underwood, Robert, of Shipden alias Cromer, gent 3
4197302 2094608 2094608 defendant Gurney Miles shoemaker 590408 590408 Gurney, Miles, of Shipden alias Cromer, shoemaker 1
4210316 2099163 2099163 defendant Ferryman Margaret widow 590408 590408 Ferryman, Margaret, of Shipden alias Cromer, widow 1
4326444 2139205 2139205 defendant Swan Robert miller 590408 590408 Swan, Robert, of Shipden alias Cromer, miller 3
4330664 2140549 2140549 defendant Swanne Robert miller 590408 590408 Swanne, Robert, of Shipden alias Cromer, miller 0
4438213 2181250 2181250 plaintiff Anteney William   590408 590408 Anteney, William, of Shipden 0
4438215 2181251 2181251 plaintiff Anteney William   590408 590408 Anteney, William, of Shipden 0
4472098 2191939 2191939 plaintiff Clerk John   590408 590408 Clerk, John, of Shipden 0
4495421 2199249 2199249 plaintiff Candelman Andrew   590408 590408 Candelman, Andrew, of Shipden 0
4495422 2199249 2199249 defendant Bele Robert   590408 590408 Bele, Robert, of Shipden 0
4495426 2199250 2199250 plaintiff Candelman Andrew   590408 590408 Candelman, Andrew, of Shipden 0
4501875 2201187 2201187 defendant Melyour William   590408 590408 Melyour, William, of Shipden 2
4508279 2203076 2203076 defendant Prendere John   590408 590408 Prendere, John, of Shipden 0
4509430 2203419 2203419 defendant Rudde John   590408 590408 Rudde, John, of Shipden 1
4529066 2209362 2209362 defendant Bacon Adam   590408 590408 Bacon, Adam, of Shipden 0
4547300 2215089 2215089 defendant Belys Robert   590408 590408 Belys, Robert, of Shipden 0
4551168 2216307 2216307 defendant Harsuk Robert   590408 590408 Harsuk, Robert, of Shipden 0
4556849 2218077 2218077 plaintiff Karman John   590408 590408 Karman, John, of Shipden 0
4559255 2218849 2218849 defendant Molyner William   590408 590408 Molyner, William, of Shipden 2
4559275 2218852 2218852 defendant Molyner John   590408 590408 Molyner, John, of Shipden 6
4569365 2222009 2222009 plaintiff Welleman John (legal representative) 590408 590408 Welleman, John, of Shipden, executors of 0
4574686 2223610 2223610 defendant Tykke John   590408 590408 Tykke, John, of Shipden 0
4574692 2223612 2223612 defendant Tykke John   590408 590408 Tykke, John, of Shipden 0
4578347 2224718 2224718 plaintiff Clement John   590408 590408 Clement, John, of Shipden 0
4578348 2224718 2224718 defendant Shyngfeld William de   590408 590408 Shyngfeld, William de, of Shipden 0
4605904 2232961 2232961 plaintiff atte Hithe Geoffrey (legal representative) 590408 590408 atte Hithe, Geoffrey, of Shipden, executors of 0
4611952 2234798 2234798 defendant Waryn William   590408 590408 Waryn, William, of Shipden 0
4623158 2238217 2238217 plaintiff Mason Thomas   590408 590408 Mason, Thomas, of Shipden 0
4623160 2238217 2238217 defendant Symmes Thomas   590408 590408 Symmes, Thomas, of Shipden 1
4626234 2239162 2239162 defendant Eston Roger de mercer 590408 590408 Eston, Roger de, of Shipden, mercer 0
4627592 2239562 2239562 defendant Prymerose John   590408 590408 Prymerose, John, of Shipden 1
4627593 2239562 2239562 defendant Blok John   590408 590408 Blok, John, of Shipden 2
4638522 2242807 2242807 defendant Boston Thomas   590408 590408 Boston,Thomas, of Shipden 0
4673285 2257285 2257285 defendant Collewye William (legal representative) 590408 590408 Collewye, William, of Shipden Crowemer, executors of 1
4673287 2257285 2257285 defendant Wikot John husbandman 590408 590408 Wikot, John, of Shipden Crowemer, husbandman 3
4673291 2257286 2257286 defendant Bulwer Thomas mainer 590408 590408 (Bulwer, Thomas, of Shipden Crowemer, mainer 2
4678732 2258955 2258955 defendant Colyssone John yeoman 590408 590408 Colyssone, John, of Shipden, yeoman 0
4685477 2261053 2261053 defendant Williamye Thomas shipman 590408 590408 Williamye, Thomas, of Shipden, shipman 0
4701448 2265856 2265856 plaintiff Gees John   590408 590408 Gees, John, of Shipden 0
4750661 2280685 2280685 plaintiff Roo William   590408 590408 Roo, William, of Shipden, on his own account 0
4766229 2285429 2285429 plaintiff Langele John   590408 590408 Langele, John, of Shipden 0
4769990 2286585 2286585 plaintiff Postell John   590408 590408 Postell, John, of Shipden 0
4769991 2286585 2286585 defendant Fenge Simon mariner 590408 590408 Fenge, Simon, of Shipden, mariner 0
4769992 2286586 2286586 plaintiff Postell John   590408 590408 Postell, John, of Shipden 0
4834493 2306797 2306797 defendant Breuster John husbandman 590408 590408 Breuster, John, of Shipden, husbandman 0
4838849 2308081 2308081 defendant Potell Richard butcher 590408 590408 Potell, Richard, of Shipden, butcher 0
4840626 2308607 2308607 defendant Rudham Roger shipman 590408 590408 Rudham, Roger, of Shipden, shipman 0
4850381 2311575 2311575 defendant Clerk Clement husbandman 590408 590408 Clerk, Clement, of Shipden, husbandman 0
4850382 2311575 2311575 defendant Faweconer Gervase husbandman 590408 590408 Faweconer, Gervase, of Shipden, husbandman 1
4850383 2311575 2311575 defendant Stratton Adam   590408 590408 Stratton, Adam, of Shipden, ship man 2
4863516 2315558 2315558 defendant Rothemere Thomas yeoman 590408 590408 Rothemere, Thomas, of Shipden, yeoman 4
4867311 2316740 2316740 plaintiff Heyles alias Crowemer John   590408 590408 Heyles alias Crowemer, John, of Shipden 0
4867312 2316740 2316740 plaintiff Clement John, junior   590408 590408 Clement, John, junior, of Shipden 1
4867314 2316741 2316741 plaintiff Heyles alias Crowemer John   590408 590408 Heyles alias Crowemer, John, of Shipden 0
4867315 2316741 2316741 plaintiff Clement John   590408 590408 Clement, John, of Shipden, junior 1
4867877 2316925 2316925 defendant Rudham Roger shipman 590408 590408 Rudham, Roger, of Shipden, shipman 0
4897070 2325738 2325738 defendant Mayson alias Clerk Clement yeoman 590408 590408 Mayson alias Clerk, Clement, of Shipden, yeoman 0
4912874 2330522 2330522 plaintiff Chapman Robert   590408 590408 Chapman, Robert, of Shipden 0
4926569 2334728 2334728 defendant Maryot John merchant 590408 590408 Maryot, John, of Shipden, merchant 1
4928324 2335283 2335283 plaintiff Skotheowe Roger   590408 590408 Skotheowe, Roger, of Shipden alias Crowemer 0
4928326 2335284 2335284 plaintiff Skothowe Roger   590408 590408 Skothowe, Roger, of Shipden alias Crowemer 0
4928327 2335284 2335284 defendant Skothowe Roger   590408 590408 Skothowe, Roger, of Shipden alias Crowemer 0
4928977 2335489 2335489 defendant Elger John carpenter 590408 590408 Elger, John, of Shipden, carpenter 0
4938419 2338396 2338396 defendant Stacy John butcher 590408 590408 Stacy, John, of Shipden, butcher 0
4938421 2338396 2338396 defendant Postell Richard yeoman 590408 590408 Postell, Richard, of Shipden, yeoman 2
4951414 2342404 2342404 defendant Fauconer Gervase yeoman 590408 590408 Fauconer, Gervase, of Shipden, yeoman 2
4951415 2342404 2342404 defendant Elys Thomas husbandman 590408 590408 Elys, Thomas, of Shipden, husbandman 3
4951701 2342487 2342487 defendant Gylmyng William husbandman 590408 590408 Gylmyng, William, of Shipden or Crowemer, husbandman 0
4951702 2342487 2342487 defendant Elys Thomas   590408 590408 Elys, Thomas, of Shipden husbandman 1
5000997 2357170 2357170 defendant Rudde John shipman 590408 590408 Rudde, John, of Shipden, shipman 0
5001017 2357175 2357175 defendant Gylmyn William yeoman 590408 590408 Gylmyn, William, of Shipden, yeoman 0
5001021 2357176 2357176 defendant Gylmyn William yeoman 590408 590408 together with Gylmyn, William, of Shipden, yeoman 1
5031892 2366200 2366200 defendant Stacy John butcher 590408 590408 Stacy, John, of Shipden, butcher 1
5033702 2366735 2366735 defendant Roo William butcher 590408 590408 Roo, William, of Shipden or Crowemer, butcher 0
5041587 2369086 2369086 defendant Roo Matilda widow 590408 590408 (Roo, Matilda, of Shipden, widow 2
5043216 2369591 2369591 defendant Auncell John husbandman 590408 590408 Auncell, John, of Shipden, husbandman 0
5043442 2369661 2369661 defendant Postyll Richard butcher 590408 590408 Postyll, Richard, of Shipden, butcher 0
5048220 2371099 2371099 defendant Maryot John merchant 590408 590408 Maryot, John, of Shipden, merchant 0
5065833 2376301 2376301 defendant Lent John yeoman 590408 590408 Lent, John, of Shipden, yeoman 2
5066044 2376369 2376369 plaintiff Mayson William chandler 590408 590408 Mayson, William, of Shipden, chandler 0
5069445 2377359 2377359 defendant Knyght John husbandman 590408 590408 Knyght, John, of Shipden or Crowemer, husbandman 2
5069446 2377359 2377359 defendant Knyght William laborer 590408 590408 Knyght, William, of Shipden or Crowemer, laborer 3
5080059 2380518 2380518 plaintiff Child Richard   590408 590408 Child, Richard, of Shipden 0
5081191 2380881 2380881 plaintiff Coye William   590408 590408 Coye, William, of Shipden alias Crowemer 0
5081192 2380881 2380881 defendant Knyth or Knyght John husbandman 590408 590408 Knyth or Knyght, John, of Shipden, husbandman 0
5089985 2383447 2383447 defendant Warde William merchant 590408 590408 Warde, William, of Shipden or Crowemer, merchant 0
5100261 2386520 2386520 plaintiff Wyndham Richard   590408 590408 Wyndham, Richard, of Shipden, or of Crowemere 0
5110205 2389391 2389391 defendant Jasper William beer brewer 590408 590408 Jasper, William, of Shipden, beer brewer 1
5111199 2389664 2389664 plaintiff Hemmyng Richard   590408 590408 Hemmyng, Richard, of Shipden or Crowemer 0
5111207 2389666 2389666 plaintiff Hemyng Richard yeoman 590408 590408 Hemyng, Richard, of Shipden, yeoman 0
5250883 2430386 2430386 defendant Mason Thomas yeoman 590408 590408 Mason, Thomas, of Shipden, yeoman 1
5260575 2433441 2433441 plaintiff Leme or Lente John mariner 590408 590408 Leme or Lente, John, of Shipden, mariner 0
5263508 2434334 2434334 defendant Maryot John merchant 590408 590408 Maryot, John, of Shipden, merchant 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);