names

131 rows where place_id = 656624

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3941093 2004024 2004024 plaintiff Thacker John merchant 656624 656624 Thacker, John, of Kingston upon Hull, merchant 0
4420405 2171289 2171289 plaintiff Bryselay Roger de   656624 656624 Bryselay, Roger de, of Kingston upon Hull 0
4439654 2181670 2181670 defendant Walker Simon   656624 656624 Walker, Simon, of Kingston upon Hull 0
4447289 2184057 2184057 plaintiff Dymbleton Walter   656624 656624 Dymbleton, Walter, of Kingston upon Hull 0
4447292 2184058 2184058 plaintiff Dymelton Walter de   656624 656624 Dymelton, Walter de, of Kingston upon Hull 0
4450268 2185043 2185043 plaintiff Hanby Geoffrey de (legal representative) 656624 656624 Hanby, Geoffrey de, of Kingston upon Hull, executor of 0
4450671 2185170 2185170 plaintiff Hauby Hugh de (legal representative) 656624 656624 Hauby, Hugh de, of Kingston upon Hull, executors of 0
4450676 2185171 2185171 plaintiff Hauby Geoffrey de (legal representative) 656624 656624 Hauby, Geoffrey de, of Kingston upon Hull, executor of 0
4450709 2185182 2185182 plaintiff Hauly Geoffrey de (legal representative) 656624 656624 Hauly, Geoffrey de, of Kingston upon Hull, executor of 0
4454815 2186518 2186518 defendant Upalt Joan   656624 656624 Upalt, Joan, of Kingston upon Hull, formerly wife of William 0
4459426 2187998 2187998 defendant Su--- William de   656624 656624 Su---, William de, of Kingston upon Hull 0
4460909 2188479 2188479 plaintiff Snayton William de   656624 656624 Snayton, William de, of Kingston upon Hull 0
4460911 2188480 2188480 plaintiff Snayton William de   656624 656624 Snayton, William de, of Kingston upon Hull 0
4462252 2188893 2188893 plaintiff Swynflet Thomas de   656624 656624 Swynflet, Thomas de, of Kingston upon Hull 0
4462256 2188894 2188894 plaintiff Swynflete Thomas de   656624 656624 Swynflete, Thomas de, of Kingston upon Hull 0
4463401 2189244 2189244 defendant Gossybbe Joan   656624 656624 Gossybbe, Joan, of Kingston upon Hull 0
4464212 2189479 2189479 plaintiff Waltham Thomas   656624 656624 Waltham, Thomas, of Kingston upon Hull 0
4466244 2190103 2190103 defendant Waltham Thomas de   656624 656624 Waltham, Thomas de, of Kingston upon Hull, mayor 0
4467082 2190377 2190377 plaintiff atte Crosse Robert (legal representative) 656624 656624 atte Crosse, Robert, of Kingston upon Hull, executors of 0
4467093 2190378 2190378 plaintiff atte Crosse Robert (legal representative) 656624 656624 atte Crosse, Robert, of Kingston upon Hull, executors of 0
4467103 2190378 2190378 defendant Patiner Peter   656624 656624 Patiner, Peter, of Kingston upon Hull 5
4472629 2192108 2192108 plaintiff Colthorp John de (legal representative) 656624 656624 Colthorp, John de, of Kingston upon Hull, merchant, executors of 0
4476243 2193230 2193230 defendant bukwyth William   656624 656624 bukwyth, William, of Kingston upon Hull, burgess 2
4479071 2194110 2194110 defendant Percy Thomas   656624 656624 Percy, Thomas, of Kingston upon Hull 3
4479139 2194135 2194135 plaintiff Hoton John   656624 656624 Hoton, John, of Kingston upon Hull, on his own account 0
4491424 2198008 2198008 plaintiff Wilcok Alan   656624 656624 Wilcok, Alan, of Kingston upon Hull 0
4494037 2198821 2198821 plaintiff Bernardson Robert   656624 656624 Bernardson, Robert, of Kingston upon Hull 0
4495311 2199211 2199211 plaintiff Bynglay John   656624 656624 Bynglay, John, of Kingston upon Hull 0
4497662 2199917 2199917 plaintiff Dymelton John   656624 656624 Dymelton, John, of Kingston upon Hull 0
4497664 2199917 2199917 defendant Couper John   656624 656624 Couper, John, of Kingston upon Hull 1
4501622 2201110 2201110 plaintiff Garton Robert de customer or customs officer 656624 656624 Garton, Robert de, of Kingston upon Hull, customer or customs officer 1
4501623 2201110 2201110 defendant Tutbury John merchant 656624 656624 Tutbury, John, of Kingston upon Hull, merchant 0
4503505 2201667 2201667 plaintiff Peromal or Pertmal Stephen   656624 656624 Peromal or Pertmal, Stephen, of Kingston upon Hull 0
4505167 2202151 2202151 plaintiff Sleford Thomas   656624 656624 Sleford, Thomas, of Kingston upon Hull 0
4505168 2202151 2202151 defendant Wilcok Alan   656624 656624 Wilcok, Alan, of Kingston upon Hull 0
4505170 2202152 2202152 plaintiff Bodeley William   656624 656624 Bodeley, William, of Kingston upon Hull 1
4505171 2202152 2202152 defendant Wilcok Alan   656624 656624 Wilcok, Alan, of Kingston upon Hull 0
4511251 2203966 2203966 defendant Brig William de   656624 656624 Brig, William de, of Kingston upon Hull 1
4524351 2207953 2207953 plaintiff Hokenale Robert   656624 656624 Hokenale, Robert, of Kingston upon Hull 0
4527406 2208849 2208849 plaintiff Fitlyng John   656624 656624 Fitlyng, John, of Kingston upon Hull 1
4533878 2210867 2210867 defendant Here Richard   656624 656624 Here, Richard, of Kingston upon Hull 0
4534327 2211001 2211001 defendant Snaynton Joan de   656624 656624 Snaynton, Joan de, of Kingston upon Hull 0
4537681 2212058 2212058 defendant Berwald William   656624 656624 Berwald, William, of Kingston upon Hull 0
4538772 2212399 2212399 plaintiff Tuttebury John   656624 656624 Tuttebury, John, of Kingston upon Hull 0
4694192 2263686 2263686 defendant Gardyner Robert mercer 656624 656624 Gardyner, Robert, of Kingston upon Hull, mercer 0
4696614 2264418 2264418 defendant Ingram Robert chapman 656624 656624 Ingram, Robert, of Kingston upon Hull, chapman 2
4697986 2264862 2264862 defendant Walssh Richard mercer 656624 656624 Walssh, Richard, of Kingston upon Hull, mercer 2
4711215 2268859 2268859 defendant Gryme John esq 656624 656624 Gryme, John, of Kingston upon Hull, esq 3
4711216 2268859 2268859 defendant Grymesby Simon (legal representative) 656624 656624 Grymesby, Simon, of Kingston upon Hull, executors of 4
4743773 2278708 2278708 defendant Jonesson Emdonus shipman 656624 656624 Jonesson, Emdonus, of Kingston upon Hull, shipman 0
4743774 2278708 2278708 defendant Flemmyng John merchant 656624 656624 Flemmyng, John, of Kingston upon Hull, merchant 1
4743775 2278708 2278708 defendant Wilforth John   656624 656624 Wilforth, John, of Kingston upon Hull butcher 2
4764318 2284836 2284836 plaintiff Haynson Thomas (legal representative) 656624 656624 Haynson, Thomas, of Kingston upon Hull, executors of 0
4764319 2284836 2284836 plaintiff Kyrkeby Robert   656624 656624 (Kyrkeby, Robert, of Kingston upon Hull 1
4770042 2286602 2286602 plaintiff Pountfret Richard   656624 656624 Pountfret, Richard, of Kingston upon Hull, glove maker 0
4774211 2287915 2287915 plaintiff Tutbery John merchant 656624 656624 Tutbery, John, of Kingston upon Hull, merchant 0
4774214 2287916 2287916 plaintiff Tutbery John merchant 656624 656624 Tutbery, John, of Kingston upon Hull, merchant 0
4776021 2288499 2288499 plaintiff Wysdom Margaret (legal representative) 656624 656624 Wysdom, Margaret, of Kingston upon Hull, executors of 0
4803247 2297207 2297207 defendant Redmare Thomas chapman 656624 656624 Redmare, Thomas, of Kingston upon Hull, chapman 2
4811189 2299610 2299610 defendant Ellyngham Thomas merchant 656624 656624 Ellyngham, Thomas, of Kingston upon Hull, merchant 0
4817964 2301700 2301700 defendant Tutbery John merchant 656624 656624 Tutbery, John, of Kingston upon Hull, merchant 0
4818786 2301962 2301962 defendant de Tutbery Lawrence merchant 656624 656624 de Tutbery, Lawrence, of Kingston upon Hull, merchant 0
4820735 2302559 2302559 defendant Thwaytes John merchant 656624 656624 Thwaytes, John, of Kingston upon Hull, merchant 3
4820736 2302559 2302559 defendant Neuton Robert merchant 656624 656624 Neuton, Robert, of Kingston upon Hull, merchant 4
4822456 2303095 2303095 defendant Westmorland Robert chapman 656624 656624 Westmorland, Robert, of Kingston upon Hull, chapman 0
4822951 2303262 2303262 defendant Hynde Robert yeoman 656624 656624 Hynde, Robert, of Kingston upon Hull, yeoman 0
4822952 2303262 2303262 defendant Burre Henry clerk 656624 656624 Burre, Henry, of Kingston upon Hull, clerk 1
4826336 2304275 2304275 plaintiff Welburne John merchant 656624 656624 Welburne, John, of Kingston upon Hull, merchant 0
4826338 2304275 2304275 defendant Broune John skinner 656624 656624 Broune, John, of Kingston upon Hull, skinner 1
4828504 2304955 2304955 defendant Rotsee John   656624 656624 Rotsee, John, of Kingston upon Hull, burgess & merchant 2
4837557 2307681 2307681 defendant Marshall Nicholas walker 656624 656624 Marshall, Nicholas, of Kingston upon Hull, walker 1
4839034 2308137 2308137 defendant Kelsay William merchant 656624 656624 Kelsay, William, of Kingston upon Hull, merchant 1
4839951 2308408 2308408 defendant Fasset William merchant 656624 656624 Fasset, William, of Kingston upon Hull, merchant 1
4840608 2308602 2308602 defendant Facet William merchant 656624 656624 Facet, William, of Kingston upon Hull, merchant 0
4840610 2308602 2308602 defendant Halsthorp William merchant 656624 656624 Halsthorp, William, of Kingston upon Hull, merchant 2
4843460 2309473 2309473 defendant Rotse John merchant 656624 656624 Rotse, John, of Kingston upon Hull, merchant 0
4846645 2310460 2310460 defendant Marchall Thomas merchant 656624 656624 Marchall, Thomas, of Kingston upon Hull, merchant 0
4846653 2310463 2310463 defendant Dykonson Thomas merchant 656624 656624 Dykonson, Thomas, of Kingston upon Hull, merchant 0
4847194 2310621 2310621 plaintiff Riplyngham William merchant 656624 656624 Riplyngham, William, of Kingston upon Hull, merchant 0
4848240 2310923 2310923 plaintiff Seggefeld Thomas   656624 656624 Seggefeld, Thomas, of Kingston upon Hull 0
4851608 2311937 2311937 defendant Ferenley Thomas mariner 656624 656624 Ferenley, Thomas, of Kingston upon Hull, mariner 1
4909765 2329577 2329577 plaintiff Bedford John   656624 656624 Bedford, John, of Kingston upon Hull 0
4917714 2332053 2332053 defendant Pynchebek Richard merchant 656624 656624 Pynchebek, Richard, of Kingston upon Hull, merchant 1
4918013 2332149 2332149 defendant Cryse Richard tailor 656624 656624 Cryse, Richard, of Kingston upon Hull, tailor 0
4919626 2332642 2332642 defendant route William   656624 656624 route, William, of Kingston upon Hull, shipwright 1
4922453 2333432 2333432 defendant atte Hall Lawrence merchant 656624 656624 atte Hall, Lawrence, of Kingston upon Hull, merchant 0
4922454 2333432 2333432 defendant Wedyrby John merchant 656624 656624 Wedyrby, John, of Kingston upon Hull, merchant 1
4922535 2333464 2333464 defendant Astlot John mercer 656624 656624 Astlot, John, of Kingston upon Hull, mercer 0
4925181 2334310 2334310 plaintiff Paule William shipman 656624 656624 Paule, William, of Kingston upon Hull, shipman 0
4925182 2334310 2334310 plaintiff Bromond John shipman 656624 656624 Bromond, John, of Kingston upon Hull, shipman 1
4928183 2335243 2335243 defendant Hesyll Helen widow 656624 656624 Hesyll, Helen, of Kingston upon Hull, widow 0
4929243 2335564 2335564 defendant Botiller Walter shipman 656624 656624 Botiller, Walter, of Kingston upon Hull, shipman 0
4929665 2335694 2335694 defendant Barton Thomas chapman 656624 656624 Barton, Thomas, of Kingston upon Hull, chapman 0
4930367 2335897 2335897 defendant Garardson James beer brewer 656624 656624 Garardson, James, of Kingston upon Hull, beer brewer 2
4932705 2336620 2336620 plaintiff Worlaby John dyer 656624 656624 Worlaby, John, of Kingston upon Hull, dyer 0
4985555 2352593 2352593 defendant Goldyng Thomas mariner 656624 656624 Goldyng, Thomas, of Kingston upon Hull, mariner 1
4985557 2352593 2352593 defendant Everyngham Thomas esq 656624 656624 Everyngham, Thomas, of Kingston upon Hull, esq 3
4987187 2353116 2353116 defendant Stroder Robert merchant 656624 656624 Stroder, Robert, of Kingston upon Hull, merchant 0
4992507 2354643 2354643 defendant Hayls John shipman 656624 656624 Hayls, John, of Kingston upon Hull, shipman 0
4995975 2355646 2355646 defendant Redmer William tailor 656624 656624 Redmer, William, of Kingston upon Hull, tailor 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);