names

104 rows where place_id = 595776

✎ 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
3621845 1874372 1874372 defendant Kyngysdowne William tailor 595776 595776 Kyngysdowne, William, of Holyngbourne, tailor 3
3762546 1945929 1945929 defendant Wode Lawrence husbandman 595776 595776 Wode, Lawrence, of Holyngbourne, husbandman 0
3774395 1949715 1949715 defendant Hyghsted William   595776 595776 Hyghsted, William, of Holyngbourne, collar maker 0
3774396 1949715 1949715 defendant Kyngesdowne Elizabeth widow 595776 595776 Kyngesdowne, Elizabeth, of Holyngbourne, widow 1
3774397 1949715 1949715 defendant Doo Stephen husbandman 595776 595776 Doo, Stephen, of Holyngbourne, husbandman 2
3774399 1949715 1949715 defendant at Wodde John husbandman 595776 595776 (at Wodde, John, of Holyngbourne, husbandman 4
3774400 1949715 1949715 defendant at Wode Robert husbandman 595776 595776 at Wode, Robert, of Holyngbourne, husbandman 5
3802574 1958700 1958700 defendant Rede William yeoman 595776 595776 Rede, William, of Holyngbourne, yeoman 1
3820032 1964145 1964145 defendant Rede William yeoman 595776 595776 Rede, William, of Holyngbourne, yeoman 1
3840709 1970660 1970660 plaintiff at Wode Lawrence singleman 595776 595776 at Wode, Lawrence, of Holyngbourne, singleman 0
4468165 2190717 2190717 defendant Broke William   595776 595776 Broke, William, of Holyngbourne 0
4493212 2198580 2198580 plaintiff atte Wode Thomas   595776 595776 atte Wode, Thomas, of Holyngbourne 0
4494388 2198940 2198940 plaintiff Boreford Robert (legal representative) 595776 595776 Boreford, Robert, of Holyngbourne, executrix of 0
4505468 2202240 2202240 defendant Packe John   595776 595776 Packe, John, of Holyngbourne 0
4508180 2203035 2203035 defendant Pecok John   595776 595776 Pecok, John, of Holyngbourne 0
4518502 2206159 2206159 defendant Ayot William   595776 595776 Ayot, William, of Holyngbourne 0
4525169 2208212 2208212 defendant Dygon John   595776 595776 Dygon, John, of Holyngbourne 1
4525172 2208213 2208213 defendant Dogon John   595776 595776 Dogon, John, of Holyngbourne 1
4591383 2228660 2228660 defendant Romyng Walter   595776 595776 Romyng, Walter, of Holyngbourne 0
4607043 2233314 2233314 defendant Eygon Richard   595776 595776 Eygon, Richard, of Holyngbourne 2
4639952 2243192 2243192 defendant Eyot William   595776 595776 Eyot, William, of Holyngbourne 0
4654755 2247367 2247367 defendant Clethe William clerk 595776 595776 Clethe, William, of Holyngbourne, clerk 0
4654756 2247367 2247367 defendant Vannere Thomas husbandman 595776 595776 Vannere, Thomas, of Holyngbourne, husbandman 1
4654759 2247368 2247368 defendant Clethe William clerk 595776 595776 Clethe, William, of Holyngbourne, clerk 0
4662792 2249821 2249821 defendant Port William laborer 595776 595776 Port, William, of Holyngbourne, laborer 0
4685329 2261008 2261008 defendant Meller Thomas husbandman 595776 595776 Meller, Thomas, of Holyngbourne, husbandman 0
4691720 2262943 2262943 defendant Marham John yeoman 595776 595776 Marham, John, of Holyngbourne, yeoman 0
4691721 2262943 2262943 defendant Taillour John laborer 595776 595776 Taillour, John, of Holyngbourne, laborer 1
4696350 2264338 2264338 defendant Somerfeld William farmer 595776 595776 Somerfeld, William, of Holyngbourne, farmer 0
4746589 2279493 2279493 defendant Cleve or Clene William   595776 595776 Cleve or Clene, William, of Holyngbourne, vicar 0
4758116 2282912 2282912 defendant Davy James, sen weaver 595776 595776 Davy, James, sen, of Holyngbourne, weaver 2
4760844 2283731 2283731 defendant Port William husbandman 595776 595776 Port, William, of Holyngbourne, husbandman 0
4770915 2286882 2286882 defendant Goune or Gonne John husbandman 595776 595776 Goune or Gonne, John, of Holyngbourne, husbandman 0
4770916 2286882 2286882 defendant Pypere (illegible) laborer 595776 595776 Pypere, _, of Holyngbourne, laborer 1
4787698 2292222 2292222 plaintiff Halle Richard   595776 595776 Halle, Richard, of Holyngbourne 0
4794639 2294464 2294464 defendant Charles John smith 595776 595776 Charles, John, of Holyngbourne, smith 3
4810858 2299520 2299520 defendant Dygon Richard husbandman 595776 595776 Dygon, Richard, of Holyngbourne, husbandman 1
4813242 2300255 2300255 defendant Dene John husbandman 595776 595776 Dene, John, of Holyngbourne, husbandman 0
4818148 2301751 2301751 defendant Ayot John yeoman 595776 595776 Ayot, John, of Holyngbourne, yeoman 0
4818150 2301751 2301751 defendant Sawecer Richard glover 595776 595776 Sawecer, Richard, of Holyngbourne, glover 2
4836468 2307385 2307385 defendant Walter John butcher 595776 595776 Walter, John, of Holyngbourne, butcher 0
4840328 2308522 2308522 defendant Saucer Richard   595776 595776 Saucer, Richard, of Holyngbourne, glove maker 0
4856231 2313321 2313321 defendant Page Peter laborer 595776 595776 Page, Peter, of Holyngbourne, laborer 0
4856232 2313321 2313321 defendant Lotte Thomas laborer 595776 595776 Lotte, Thomas, of Holyngbourne, laborer 1
4865060 2316048 2316048 defendant Breshyng Gilbert laborer 595776 595776 Breshyng, Gilbert, of Holyngbourne, laborer 2
4869052 2317291 2317291 defendant Mellere Thomas husbandman 595776 595776 Mellere, Thomas, of Holyngbourne, husbandman 0
4869053 2317291 2317291 defendant Sauter or Santer Richard glover 595776 595776 Sauter or Santer, Richard, of Holyngbourne, glover 1
4873980 2318800 2318800 defendant Brice Gilbert husbandman 595776 595776 Brice, Gilbert, of Holyngbourne, husbandman 2
4876124 2319493 2319493 defendant Maunde Richard laborer 595776 595776 Maunde, Richard, of Holyngbourne, laborer 0
4876126 2319493 2319493 defendant James Stephen laborer 595776 595776 James, Stephen, of Holyngbourne, laborer 2
4888907 2323314 2323314 defendant Breche William husbandman 595776 595776 Breche, William, of Holyngbourne, husbandman 1
4890914 2323905 2323905 defendant Coke Henry husbandman 595776 595776 Coke, Henry, of Holyngbourne, husbandman 0
4894463 2324942 2324942 defendant Romyng William laborer 595776 595776 Romyng, William, of Holyngbourne, laborer 0
4894464 2324942 2324942 defendant Halden Joan widow 595776 595776 Halden, Joan, of Holyngbourne, widow 1
4894466 2324942 2324942 defendant Esonde or Esoude Robert laborer 595776 595776 Esonde or Esoude, Robert, of Holyngbourne, laborer 3
4894467 2324942 2324942 defendant Cole Henry chapman 595776 595776 Cole, Henry, of Holyngbourne, chapman 4
4900332 2326739 2326739 defendant Dycon Richard yeoman 595776 595776 Dycon, Richard, of Holyngbourne, yeoman 1
4906862 2328731 2328731 defendant Dycon Richard husbandman 595776 595776 Dycon, Richard, of Holyngbourne, husbandman 1
4908531 2329225 2329225 defendant Hallesnoth Nicholas miller 595776 595776 Hallesnoth, Nicholas, of Holyngbourne, miller 0
4911132 2329994 2329994 defendant (illegible) Thomas carpenter 595776 595776 ----, Thomas, of Holyngbourne, carpenter 0
4943760 2340017 2340017 defendant Thomas Amery tailor 595776 595776 Thomas, Amery, of Holyngbourne, tailor 1
4953310 2342953 2342953 defendant Geryng Roger husbandman 595776 595776 Geryng, Roger, of Holyngbourne, husbandman 0
4955095 2343477 2343477 defendant Mellere Thomas husbandman 595776 595776 Mellere, Thomas, of Holyngbourne, husbandman 0
4964243 2346211 2346211 defendant Maundy Richard   595776 595776 Maundy, Richard, of Holyngbourne, mason 0
4964244 2346211 2346211 defendant Sauncer Richard glover 595776 595776 together with Sauncer, Richard, of Holyngbourne, glover 1
4973776 2349114 2349114 defendant Saucer or Sancer Richard glover 595776 595776 Saucer or Sancer, Richard, of Holyngbourne, glover 0
4999504 2356725 2356725 plaintiff Leef William   595776 595776 Leef, William, of Holyngbourne, parson 0
5027715 2364980 2364980 defendant Isode Robert laborer 595776 595776 Isode, Robert, of Holyngbourne, laborer 1
5048446 2371172 2371172 defendant Breche William draper 595776 595776 Breche, William, of Holyngbourne, draper 0
5058176 2374001 2374001 defendant Bernard John laborer 595776 595776 Bernard, John, of Holyngbourne, laborer 3
5061244 2374945 2374945 defendant Cook John husbandman 595776 595776 Cook, John, of Holyngbourne, husbandman 0
5061245 2374945 2374945 defendant Monke Nicholas laborer 595776 595776 Monke, Nicholas, of Holyngbourne, laborer 1
5061246 2374945 2374945 defendant Monke John, junior laborer 595776 595776 Monke, John, junior, of Holyngbourne, laborer 2
5064476 2375915 2375915 defendant Ely John fuller 595776 595776 Ely, John, of Holyngbourne, fuller 1
5066262 2376437 2376437 defendant Ayot Margaret widow 595776 595776 Ayot, Margaret, of Holyngbourne, widow 0
5066263 2376437 2376437 defendant Bresyng Gilbert laborer 595776 595776 Bresyng, Gilbert, of Holyngbourne, laborer 1
5066264 2376437 2376437 defendant Scot Walter laborer 595776 595776 Scot, Walter, of Holyngbourne, laborer 2
5066265 2376437 2376437 defendant Combe William laborer 595776 595776 Combe, William, of Holyngbourne, laborer 3
5066266 2376437 2376437 defendant atte Wode Thomas carpenter 595776 595776 atte Wode, Thomas, of Holyngbourne, carpenter 4
5080830 2380757 2380757 defendant Geryng William husbandman 595776 595776 Geryng, William, of Holyngbourne, husbandman 1
5084399 2381844 2381844 defendant Graunt John laborer 595776 595776 Graunt, John, of Holyngbourne, laborer 3
5086261 2382373 2382373 defendant Bresshyng Gilbert laborer 595776 595776 Bresshyng, Gilbert, of Holyngbourne, laborer 0
5088666 2383060 2383060 defendant Taillour John laborer 595776 595776 Taillour, John, of Holyngbourne, laborer 0
5107468 2388613 2388613 defendant Charlys John butcher 595776 595776 Charlys, John, of Holyngbourne, butcher 1
5107469 2388613 2388613 defendant atte Wode Thomas carpenter 595776 595776 together with atte Wode, Thomas, of Holyngbourne, carpenter 2
5136355 2397153 2397153 defendant Thomlyn Adomaris   595776 595776 Thomlyn, Adomaris, of Holyngbourne 4
5136356 2397153 2397153 defendant Bomle William   595776 595776 Bomle, William, of Holyngbourne 5
5136357 2397153 2397153 defendant Monke John   595776 595776 with Monke, John, of Holyngbourne 6
5136358 2397153 2397153 defendant Charles Thomas   595776 595776 Charles, Thomas, of Holyngbourne 7
5136360 2397153 2397153 defendant Morys John   595776 595776 Morys, John, of Holyngbourne 9
5141419 2398607 2398607 defendant Bresyng Gilbert laborer 595776 595776 Bresyng, Gilbert, of Holyngbourne, laborer 1
5144931 2399665 2399665 defendant Frodesham Robert clerk 595776 595776 Frodesham, Robert, of Holyngbourne, clerk 3
5147864 2400518 2400518 defendant Casewall John laborer 595776 595776 Casewall, John, of Holyngbourne, laborer 1
5147889 2400524 2400524 defendant Eytherst William laborer 595776 595776 Eytherst, William, of Holyngbourne, laborer 0
5167130 2406120 2406120 plaintiff Lovyngden George   595776 595776 Lovyngden, George, of Holyngbourne 2
5167377 2406194 2406194 defendant Casewell John laborer 595776 595776 Casewell, John, of Holyngbourne, laborer 1
5227257 2423602 2423602 defendant Gerynge William husbandman 595776 595776 Gerynge, William, of Holyngbourne, husbandman 0
5327401 2453266 2453266 defendant Geryng William husbandman 595776 595776 Geryng, William, of Holyngbourne, husbandman 2
5329973 2454044 2454044 defendant Geryng William husbandman 595776 595776 Geryng, William, of Holyngbourne, husbandman 0
5347040 2459230 2459230 defendant Pyx John husbandman 595776 595776 Pyx, John, of Holyngbourne, husbandman 4

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