names

101 rows where place_id = 630865

✎ 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
3797101 1956975 1956975 defendant Alderton John yeoman 630865 630865 Alderton, John, of Hadleye, yeoman 4
4100113 2060373 2060373 defendant Sedgweke Thomas clothier 630865 630865 Sedgweke, Thomas, of Hadleye, clothier 1
4170380 2085134 2085134 defendant Deye John tanner 630865 630865 Deye, John, of Hadleye, tanner 0
4436077 2176024 2176024 defendant Waryn John   630865 630865 Waryn, John, of Hadleye 0
4453630 2186148 2186148 plaintiff Leteman Richard   630865 630865 Leteman, Richard, of Hadleye 0
4463687 2189336 2189336 defendant Dyer Robert   630865 630865 Dyer, Robert, of Hadleye 0
4463694 2189337 2189337 defendant Dyer Robert   630865 630865 Dyer, Robert, of Hadleye 0
4463701 2189338 2189338 defendant Eyer Robert   630865 630865 Eyer, Robert, of Hadleye 0
4467333 2190462 2190462 plaintiff Semere Richard   630865 630865 Semere, Richard, of Hadleye 1
4475921 2193142 2193142 defendant Botiston Peter taverner 630865 630865 Botiston, Peter, of Hadleye, taverner 0
4476492 2193316 2193316 plaintiff Fyshere Richard   630865 630865 Fyshere, Richard, of Hadleye 0
4476493 2193316 2193316 defendant Maykhous Thomas   630865 630865 Maykhous, Thomas, of Hadleye 0
4476494 2193316 2193316 defendant Alderton William   630865 630865 Alderton, William, of Hadleye 1
4476495 2193316 2193316 defendant Carnelo Robert   630865 630865 Carnelo, Robert, of Hadleye 2
4477961 2193775 2193775 plaintiff Hardheved Philip   630865 630865 Hardheved, Philip, of Hadleye 0
4494608 2199006 2199006 defendant Cok John   630865 630865 Cok, John, of Hadleye 0
4496067 2199446 2199446 plaintiff Clopton Walter   630865 630865 Clopton, Walter, of Hadleye, knight, on his own account 0
4496072 2199447 2199447 plaintiff Clopton Walter   630865 630865 Clopton, Walter, of Hadleye, knight, on his own account 0
4498004 2200021 2200021 plaintiff Everard William   630865 630865 Everard, William, of Hadleye 0
4503708 2201728 2201728 defendant Fot John   630865 630865 Fot, John, of Hadleye 0
4504840 2202056 2202056 plaintiff Semere Richard   630865 630865 Semere, Richard, of Hadleye, on his own account 0
4504841 2202056 2202056 defendant Kempstone John   630865 630865 Kempstone, John, of Hadleye 0
4504843 2202057 2202057 defendant Kempsptone John   630865 630865 Kempsptone, John, of Hadleye 0
4509960 2203600 2203600 plaintiff Bakere Henry   630865 630865 Bakere, Henry, of Hadleye 0
4512044 2204208 2204208 defendant Huntynfeld John   630865 630865 Huntynfeld, John, of Hadleye 0
4514257 2204876 2204876 defendant Bakere Henry   630865 630865 Bakere, Henry, of Hadleye 0
4522786 2207463 2207463 defendant Manser William   630865 630865 Manser, William, of Hadleye 2
4530077 2209694 2209694 defendant Kempston John   630865 630865 Kempston, John, of Hadleye 1
4534615 2211095 2211095 defendant Dextere Thomas   630865 630865 Dextere, Thomas, of Hadleye, pedlar 1
4534618 2211096 2211096 defendant Dextere Thomas   630865 630865 Dextere, Thomas, of Hadleye, pedlar 1
4542133 2213429 2213429 defendant Colman Richard   630865 630865 Colman, Richard, of Hadleye 0
4542181 2213446 2213446 defendant Colman Richard   630865 630865 Colman, Richard, of Hadleye 0
4544500 2214196 2214196 plaintiff Baudewene John   630865 630865 Baudewene, John, of Hadleye 0
4550778 2216181 2216181 defendant Cue Thomas   630865 630865 Cue, Thomas, of Hadleye 0
4559224 2218839 2218839 defendant Kempston John   630865 630865 Kempston, John, of Hadleye 1
4588045 2227661 2227661 defendant Bryggeslee Robert   630865 630865 Bryggeslee, Robert, of Hadleye 0
4588054 2227662 2227662 defendant Holt William   630865 630865 Holt, William, of Hadleye 3
4588259 2227721 2227721 plaintiff Keye Ralph (legal representative) 630865 630865 Keye, Ralph, of Hadleye, executors of 0
4618354 2236751 2236751 plaintiff Hardhed Philip   630865 630865 Hardhed, Philip, of Hadleye 0
4625507 2238942 2238942 defendant Smyth Stephen   630865 630865 Smyth, Stephen, of Hadleye 0
4640967 2243454 2243454 defendant Palmere Thomas   630865 630865 Palmere, Thomas, of Hadleye 0
4655228 2247519 2247519 plaintiff Brion John, senior   630865 630865 Brion, John, senior, of Hadleye 0
4655230 2247519 2247519 defendant Elyngham John mercer 630865 630865 Elyngham, John, of Hadleye, mercer 1
4655231 2247519 2247519 defendant Frost John draper 630865 630865 Frost, John, of Hadleye, draper 2
4670645 2256502 2256502 defendant Bakere William yeoman 630865 630865 Bakere, William, of Hadleye, yeoman 0
4688750 2262040 2262040 plaintiff Tiryngton Henry (legal representative) 630865 630865 Tiryngton, Henry, of Hadleye, chaplain, executors of 0
4688753 2262040 2262040 defendant Lyon John draper 630865 630865 Lyon, John, of Hadleye, draper 0
4695093 2263959 2263959 defendant Baudewen John yeoman 630865 630865 Baudewen, John, of Hadleye, yeoman 0
4695659 2264122 2264122 defendant Forde William yeoman 630865 630865 Forde, William, of Hadleye, yeoman 0
4695663 2264123 2264123 defendant Gowyn John yeoman 630865 630865 Gowyn, John, of Hadleye, yeoman 2
4722031 2272219 2272219 defendant Wade John husbandman 630865 630865 Wade, John, of Hadleye, husbandman 1
4723475 2272652 2272652 defendant Cranele William merchant 630865 630865 Cranele, William, of Hadleye, merchant 0
4764971 2285020 2285020 defendant Colman John butcher 630865 630865 Colman, John, of Hadleye, butcher 2
4771311 2287009 2287009 defendant Wynlove John dyer 630865 630865 Wynlove, John, of Hadleye, dyer 0
4773467 2287671 2287671 defendant Maghteld Richard husbandman 630865 630865 Maghteld, Richard, of Hadleye, husbandman 0
4776300 2288580 2288580 defendant Wynlove John dyer 630865 630865 Wynlove, John, of Hadleye, dyer 0
4777454 2288943 2288943 defendant Byrd Robert butcher 630865 630865 Byrd, Robert, of Hadleye, butcher 0
4788235 2292391 2292391 plaintiff Haypour William (legal representative) 630865 630865 Haypour, William, of Hadleye, executors of 0
4788236 2292391 2292391 plaintiff Hillary Robert   630865 630865 (Hillary, Robert, of Hadleye 1
4788237 2292391 2292391 plaintiff Thystylden Thomas chaplain 630865 630865 Thystylden, Thomas, of Hadleye, chaplain 2
4788240 2292391 2292391 defendant Bryan Thomas tailor 630865 630865 Bryan, Thomas, of Hadleye, tailor 2
4796269 2294979 2294979 defendant Wynlove John dyer 630865 630865 Wynlove, John, of Hadleye, dyer 0
4796555 2295075 2295075 defendant Balysden William scalder 630865 630865 Balysden, William, of Hadleye, scalder 0
4807860 2298644 2298644 defendant Man Thomas scalder 630865 630865 Man, Thomas, of Hadleye, scalder 0
4807863 2298644 2298644 defendant Crystemasse Roger scalder 630865 630865 Crystemasse, Roger, of Hadleye, scalder 3
4822459 2303096 2303096 defendant Duk John shoemaker 630865 630865 Duk, John, of Hadleye, shoemaker 0
4822461 2303096 2303096 defendant Frere Robert husbandman 630865 630865 Frere, Robert, of Hadleye, husbandman 2
4822462 2303096 2303096 defendant Valentyn John husbandman 630865 630865 Valentyn, John, of Hadleye, husbandman 3
4833575 2306507 2306507 defendant Markele Thomas smith 630865 630865 Markele, Thomas, of Hadleye, smith 0
4833576 2306507 2306507 defendant Hasbeche John tanner 630865 630865 Hasbeche, John, of Hadleye, tanner 1
4836367 2307348 2307348 defendant Talbot Roger draper 630865 630865 Talbot, Roger, of Hadleye, draper 0
4836368 2307348 2307348 defendant Cokerell Simon draper 630865 630865 Cokerell, Simon, of Hadleye, draper 1
4836369 2307348 2307348 defendant Lyoun John draper 630865 630865 Lyoun, John, of Hadleye, draper 2
4836371 2307349 2307349 defendant Talbot Roger draper 630865 630865 Talbot, Roger, of Hadleye, draper 0
4836372 2307349 2307349 defendant Cokerell Simon draper 630865 630865 Cokerell, Simon, of Hadleye, draper 1
4836373 2307349 2307349 defendant Lyoun John draper 630865 630865 Lyoun, John, of Hadleye, draper 2
4836377 2307351 2307351 defendant Talbot Roger draper 630865 630865 Talbot, Roger, of Hadleye, draper 0
4836378 2307351 2307351 defendant Cokerell Simon draper 630865 630865 Cokerell, Simon, of Hadleye, draper 1
4836379 2307351 2307351 defendant Lyoun John draper 630865 630865 Lyoun, John, of Hadleye, draper 2
4836381 2307352 2307352 defendant Talbot Roger draper 630865 630865 Talbot, Roger, of Hadleye, draper 0
4836382 2307352 2307352 defendant Cokerell Simon draper 630865 630865 Cokerell, Simon, of Hadleye, draper 1
4836383 2307352 2307352 defendant Lyoun John draper 630865 630865 Lyoun, John, of Hadleye, draper 2
4846489 2310411 2310411 plaintiff Prykke Robert   630865 630865 Prykke, Robert, of Hadleye 0
4846490 2310411 2310411 plaintiff Brounsmyth John   630865 630865 Brounsmyth, John, of Hadleye 1
4846988 2310564 2310564 defendant Smyth Walter butcher 630865 630865 Smyth, Walter, of Hadleye, butcher 2
4846990 2310564 2310564 defendant Yemme John dyer 630865 630865 Yemme, John, of Hadleye, dyer 4
4846991 2310564 2310564 defendant Illary John dyer 630865 630865 Illary, John, of Hadleye, dyer 5
4868736 2317191 2317191 defendant Talbot Roger draper 630865 630865 Talbot, Roger, of Hadleye, draper 0
4868737 2317191 2317191 defendant Cokerell Simon draper 630865 630865 Cokerell, Simon, of Hadleye, draper 1
4868738 2317191 2317191 defendant Lyonn John draper 630865 630865 Lyonn, John, of Hadleye, draper 2
4874671 2319021 2319021 defendant Smyth Walter butcher 630865 630865 Smyth, Walter, of Hadleye, butcher 2
4874672 2319021 2319021 defendant Illary John dyer 630865 630865 Illary, John, of Hadleye, dyer 3
4884075 2321931 2321931 defendant Roo William mercer 630865 630865 Roo, William, of Hadleye, mercer 0
4894987 2325097 2325097 plaintiff Cokerell Simon draper 630865 630865 Cokerell, Simon, of Hadleye, draper 0
4899489 2326481 2326481 defendant Roo William mercer 630865 630865 Roo, William, of Hadleye, mercer 2
4918685 2332359 2332359 defendant Aleyn Walter fuller 630865 630865 Aleyn, Walter, of Hadleye, fuller 4
4946277 2340822 2340822 defendant Gobeon John fishman 630865 630865 Gobeon, John, of Hadleye, fishman 2
4967645 2347263 2347263 defendant Wade John smith 630865 630865 Wade, John, of Hadleye, smith 3
5517402 2510285 2510285 plaintiff Wale Edmund   630865 630865 Wale, Edmund, of Hadleye 0
5608886 2537679 2537679 defendant Belcham Gregory fuller 630865 630865 Belcham, Gregory, of Hadleye, fuller 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);