names

109 rows where place_id = 621239

✎ 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
3740348 1938843 1938843 defendant Almondeson John husbandman 621239 621239 Almondeson, John, of Skyrbek, husbandman 1
3741949 1939349 1939349 defendant Leke Richard husbandman 621239 621239 Leke, Richard, of Skyrbek, husbandman 0
3741950 1939349 1939349 defendant Leke William husbandman 621239 621239 Leke, William, of Skyrbek, husbandman 1
3754293 1943294 1943294 defendant Huetson John husbandman 621239 621239 Huetson, John, of Skyrbek, husbandman 0
3847689 1972849 1972849 defendant Ranson or Rauson Thomas gent 621239 621239 Ranson or Rauson, Thomas, of Skyrbek, gent 0
3854800 1975145 1975145 defendant Spelle William husbandman 621239 621239 Spelle, William, of Skyrbek, husbandman 3
3854801 1975145 1975145 defendant Hogekynson Alice widow 621239 621239 Hogekynson, Alice, of Skyrbek, widow 4
3893871 1988173 1988173 defendant Brynkeley William merchant 621239 621239 Brynkeley, William, of Skyrbek, merchant 0
3905460 1992096 1992096 defendant Sherman John husbandman 621239 621239 Sherman, John, of Skyrbek, husbandman 0
3934653 2001884 2001884 plaintiff Hood Henry   621239 621239 Hood, Henry, of Skyrbek, Staple merchant 0
3997100 2023731 2023731 defendant Hood John clerk 621239 621239 Hood, John, of Skyrbek, clerk 0
3997106 2023734 2023734 defendant Head John clerk 621239 621239 Head, John, of Skyrbek, clerk 0
4021303 2032346 2032346 plaintiff Wylkynson alias Jackson Henry   621239 621239 Wylkynson alias Jackson, Henry, of Skyrbek, yeoman, executeix of 0
4421491 2171626 2171626 defendant Arneys John   621239 621239 Arneys, John, of Skyrbek 0
4476633 2193353 2193353 defendant Dykeson Robert   621239 621239 Dykeson, Robert, of Skyrbek, son of Simon Dykeson 0
4476634 2193353 2193353 defendant Murre John   621239 621239 Murre, John, of Skyrbek, son of Lawrence 1
4476635 2193353 2193353 defendant Pawelyn William   621239 621239 Pawelyn, William, of Skyrbek, son of John Pawelyn 2
4584397 2226536 2226536 defendant Thorp William   621239 621239 Thorp, William, of Skyrbek, plough man 0
4675802 2258039 2258039 defendant Marche John husbandman 621239 621239 Marche, John, of Skyrbek, husbandman 4
4716772 2270568 2270568 defendant Endyr Robert husbandman 621239 621239 Endyr, Robert, of Skyrbek, husbandman 1
4731345 2275005 2275005 plaintiff Morton Robert clerk & parson 621239 621239 Morton, Robert, of Skyrbek, clerk & parson 0
4753180 2281379 2281379 defendant Newelond Thomas   621239 621239 Newelond, Thomas, of Skyrbek, wright 0
4771397 2287035 2287035 defendant Busshe Athelard   621239 621239 (Busshe, Athelard, of Skyrbek, fish monger 3
4789319 2292722 2292722 defendant Overay John husbandman 621239 621239 Overay, John, of Skyrbek, husbandman 0
4803614 2297316 2297316 defendant March John, senior husbandman 621239 621239 March, John, senior, of Skyrbek, husbandman 4
4828020 2304808 2304808 defendant Golson Thomas husbandman 621239 621239 Golson, Thomas, of Skyrbek, husbandman 0
4838147 2307853 2307853 defendant Derby William   621239 621239 Derby, William, of Skyrbek, tile maker 3
4852082 2312082 2312082 defendant Derby William chapman 621239 621239 Derby, William, of Skyrbek, chapman 0
4859216 2314258 2314258 defendant Jakson John husbandman 621239 621239 Jakson, John, of Skyrbek, husbandman 1
4869184 2317339 2317339 defendant Warde Henry husbandman 621239 621239 Warde, Henry, of Skyrbek, husbandman 0
4869185 2317339 2317339 defendant Porter Randolph husbandman 621239 621239 Porter, Randolph, of Skyrbek, husbandman 1
4869186 2317339 2317339 defendant Murre Thomas husbandman 621239 621239 Murre, Thomas, of Skyrbek, husbandman 2
4884299 2321996 2321996 defendant Warde Henry husbandman 621239 621239 Warde, Henry, of Skyrbek, husbandman 1
4884301 2321996 2321996 defendant Forman John husbandman 621239 621239 Forman, John, of Skyrbek, husbandman 3
4900706 2326860 2326860 defendant Aynold Thomas carter 621239 621239 Aynold, Thomas, of Skyrbek, carter 0
4900707 2326860 2326860 defendant Overay Thomas husbandman 621239 621239 Overay, Thomas, of Skyrbek, husbandman 1
4901045 2326952 2326952 defendant Murre Thomas husbandman 621239 621239 Murre, Thomas, of Skyrbek, husbandman 1
4914385 2331015 2331015 defendant Harneys Robert husbandman 621239 621239 Harneys, Robert, of Skyrbek, husbandman 0
4940642 2339102 2339102 defendant Herveys Robert husbandman 621239 621239 Herveys, Robert, of Skyrbek, husbandman 0
4955099 2343479 2343479 defendant Harnys Robert husbandman 621239 621239 Harnys, Robert, of Skyrbek, husbandman 0
4958298 2344451 2344451 defendant Clerk Robert yeoman 621239 621239 Clerk, Robert, of Skyrbek, yeoman 0
4958632 2344549 2344549 defendant Cardon Richard husbandman 621239 621239 Cardon, Richard, of Skyrbek, husbandman 0
4989744 2353849 2353849 defendant Harnes Robert husbandman 621239 621239 Harnes, Robert, of Skyrbek, husbandman 0
4989745 2353849 2353849 defendant Michell John laborer 621239 621239 Michell, John, of Skyrbek, laborer 1
4993058 2354808 2354808 defendant Warde John husbandman 621239 621239 Warde, John, of Skyrbek, husbandman 3
4995026 2355369 2355369 plaintiff Roper Simon   621239 621239 Roper, Simon, of Skyrbek 3
5005866 2358615 2358615 defendant Broun Richard husbandman 621239 621239 Broun, Richard, of Skyrbek, husbandman 0
5018666 2362349 2362349 defendant Warwyk Richard husbandman 621239 621239 Warwyk, Richard, of Skyrbek, husbandman 0
5021196 2363099 2363099 defendant Overey Thomas husbandman 621239 621239 Overey, Thomas, of Skyrbek, husbandman 0
5038136 2368040 2368040 defendant Graund Elizabeth widow 621239 621239 Graund, Elizabeth, of Skyrbek, widow 0
5053329 2372599 2372599 defendant Coweper John husbandman 621239 621239 Coweper, John, of Skyrbek, husbandman 1
5053330 2372599 2372599 defendant Warde Thomas husbandman 621239 621239 Warde,Thomas, of Skyrbek, husbandman 2
5053331 2372599 2372599 defendant Overey Thomas husbandman 621239 621239 Overey, Thomas, of Skyrbek, husbandman 3
5057819 2373909 2373909 defendant Overay Thomas husbandman 621239 621239 Overay, Thomas, of Skyrbek, husbandman 1
5057820 2373909 2373909 defendant Carter John husbandman 621239 621239 Carter, John, of Skyrbek, husbandman 2
5067735 2376848 2376848 defendant Aynolde Thomas   621239 621239 Aynolde, Thomas, of Skyrbek, shepherd 2
5073255 2378488 2378488 defendant Gelson Thomas (legal representative) 621239 621239 Gelson, Thomas, of Skyrbek, executors of 3
5073256 2378488 2378488 defendant Ward John husbandman 621239 621239 (Ward, John, of Skyrbek, husbandman 4
5073261 2378489 2378489 defendant Ward John husbandman 621239 621239 Ward, John, of Skyrbek, husbandman 2
5073268 2378490 2378490 defendant Gybson Roger husbandman 621239 621239 Gybson, Roger, of Skyrbek, husbandman 0
5074138 2378752 2378752 defendant Maltby Agnes widow 621239 621239 Maltby, Agnes, of Skyrbek, widow 0
5096974 2385548 2385548 defendant Astyn Richard cooper 621239 621239 Astyn, Richard, of Skyrbek, cooper 0
5098769 2386070 2386070 plaintiff Warde John merchant 621239 621239 Warde, John, of Skyrbek, merchant 0
5098771 2386071 2386071 plaintiff Warde John merchant 621239 621239 Warde, John, of Skyrbek, merchant 0
5100611 2386607 2386607 defendant Busshe Athelard husbandman 621239 621239 Busshe, Athelard, of Skyrbek, husbandman 0
5100612 2386607 2386607 defendant Busshe John husbandman 621239 621239 Busshe, John, of Skyrbek, husbandman 1
5100984 2386698 2386698 defendant Tythe Thomas   621239 621239 Tythe, Thomas, of Skyrbek 1
5100985 2386698 2386698 defendant Ballok William husbandman 621239 621239 Ballok, William, of Skyrbek, husbandman 2
5101671 2386909 2386909 defendant Fryskenay William   621239 621239 Fryskenay, William, of Skyrbek, tile maker 9
5102788 2387233 2387233 defendant Kendale Thomas husbandman 621239 621239 Kendale, Thomas, of Skyrbek, husbandman 0
5109315 2389152 2389152 defendant Goldyng William weaver 621239 621239 Goldyng, William, of Skyrbek, weaver 0
5109316 2389152 2389152 defendant Denys Ellen widow 621239 621239 Denys, Ellen, of Skyrbek, widow 1
5119450 2392117 2392117 defendant Overey Richard laborer 621239 621239 Overey, Richard, of Skyrbek, laborer 0
5124877 2393750 2393750 defendant Overey John husbandman 621239 621239 Overey, John, of Skyrbek, husbandman 2
5128465 2394798 2394798 defendant Ward John yeoman 621239 621239 Ward, John, of Skyrbek, yeoman 0
5128466 2394798 2394798 defendant Ward Thomas husbandman 621239 621239 Ward, Thomas, of skyrbek, husbandman 1
5128471 2394798 2394798 defendant Busshe John husbandman 621239 621239 Busshe, John, of Skyrbek, husbandman 6
5138041 2397631 2397631 defendant Ballok William tiler 621239 621239 Ballok, William, of Skyrbek, tiler 2
5140601 2398360 2398360 defendant Warwyk Richard husbandman 621239 621239 Warwyk, Richard, of Skyrbek, husbandman 0
5140713 2398397 2398397 defendant Frysshney alias Ballok William   621239 621239 Frysshney alias Ballok, William, of Skyrbek, tile maker 0
5141330 2398588 2398588 defendant Payntour John laborer 621239 621239 Payntour, John, of Skyrbek, laborer 1
5147564 2400428 2400428 defendant Ward John yeoman 621239 621239 Ward, John, of Skyrbek, yeoman 0
5147565 2400428 2400428 defendant Ward Thomas husbandman 621239 621239 Ward, Thomas, of Skyrbek, husbandman 1
5147566 2400428 2400428 defendant March John, sen husbandman 621239 621239 March, John, sen, of Skyrbek, husbandman 2
5147570 2400428 2400428 defendant Busshe John husbandman 621239 621239 Busshe, John, of Skyrbek, husbandman 6
5161838 2404570 2404570 defendant Frysshney William   621239 621239 Frysshney, William, of Skyrbek, tile maker 0
5176111 2408701 2408701 defendant Frysshney William   621239 621239 Frysshney, William, of Skyrbek, tile maker 0
5176516 2408821 2408821 defendant Payntour John laborer 621239 621239 Payntour, John, of Skyrbek, laborer 1
5177262 2409042 2409042 defendant Wryght Richard husbandman 621239 621239 Wryght, Richard, of Skyrbek, husbandman 2
5198741 2415386 2415386 defendant Payntour John laborer 621239 621239 Payntour, John, of Skyrbek, laborer 1
5227376 2423634 2423634 defendant Ballok alias Fryskeney William   621239 621239 Ballok alias Fryskeney, William, of Skyrbek, tile maker 0
5284538 2440489 2440489 defendant Salman Richard husbandman 621239 621239 Salman, Richard, of Skyrbek, husbandman 1
5295544 2443686 2443686 defendant Salman John husbandman 621239 621239 Salman, John, of Skyrbek, husbandman 1
5310071 2448043 2448043 defendant Fayreclough Alexancer clerk 621239 621239 Fayreclough, Alexancer, of Skyrbek, clerk 0
5327305 2453238 2453238 defendant Fayreclough Alexander clerk 621239 621239 Fayreclough, Alexander, of Skyrbek, clerk 0
5327307 2453239 2453239 defendant Fayreclough Alexander clerk 621239 621239 Fayreclough, Alexander, of Skyrbek, clerk 0
5348725 2459729 2459729 defendant Piers Thomas husbandman 621239 621239 Piers, Thomas, of Skyrbek, husbandman 1
5367143 2465369 2465369 defendant Cardon Richard yeoman 621239 621239 Cardon, Richard, of Skyrbek, yeoman 1
5452364 2490579 2490579 defendant Enald Richard husbandman 621239 621239 Enald, Richard, of Skyrbek, husbandman 0
5503585 2506035 2506035 defendant Albyn John   621239 621239 Albyn, John, of Skyrbek, shipwright 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);