names

126 rows where place_id = 591864

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605827 1869490 1869490 plaintiff Levesey or Lenesey John   591864 591864 Levesey or Lenesey, John, of Hedon 0
3620359 1873951 1873951 plaintiff Levesey or Lenesey John   591864 591864 Levesey or Lenesey, John, of Hedon 0
3637798 1906641 1906641 defendant Smyth Henry tanner 591864 591864 Smyth, Henry, of Hedon, tanner 0
3637799 1906641 1906641 defendant Smyth John miller 591864 591864 Smyth, John, of Hedon, miller 1
3750683 1942138 1942138 defendant Whitehed Hugh husbandman 591864 591864 Whitehed, Hugh, of Hedon, husbandman 0
3827845 1966574 1966574 defendant Skydmore Gregory   591864 591864 Skydmore, Gregory, of Hedon, surgeon 0
3962270 2011383 2011383 defendant Wastnes Ralph gent 591864 591864 Wastnes, Ralph, of Hedon, gent 0
3962272 2011384 2011384 defendant Wastnes Ralph gent 591864 591864 Wastnes, Ralph, of Hedon, gent 0
4139236 2074402 2074402 defendant Horneclyffe William gent 591864 591864 Horneclyffe, William, of Hedon, gent 1
4172888 2085970 2085970 defendant Worlyngton John haberdasher 591864 591864 Worlyngton, John, of Hedon, haberdasher 2
4420222 2171225 2171225 defendant Karbole William de clerk 591864 591864 Karbole, William de, of Hedon, clerk 0
4420252 2171235 2171235 defendant Botteler John   591864 591864 together with Botteler, John, of Hedon 1
4420254 2171236 2171236 defendant Botiler John   591864 591864 Botiler, John, of Hedon 0
4431653 2174667 2174667 defendant Parkour Robert le   591864 591864 Parkour, Robert le, of Hedon 0
4450455 2185105 2185105 defendant Waste John   591864 591864 Waste, John, of Hedon 0
4452722 2185861 2185861 defendant Mohond Simon   591864 591864 Mohond, Simon, of Hedon 0
4464091 2189441 2189441 plaintiff Walkelyn Robert de   591864 591864 Walkelyn, Robert de, of Hedon 0
4470509 2191421 2191421 defendant Litster John   591864 591864 Litster, John, of Hedon 2
4470906 2191552 2191552 plaintiff Burton John   591864 591864 Burton, John, of Hedon 0
4486040 2196336 2196336 defendant Cotes William dyer 591864 591864 Cotes, William, of Hedon, dyer 0
4492503 2198343 2198343 defendant Flesshewer Richard   591864 591864 Flesshewer, Richard, of Hedon 0
4514185 2204855 2204855 plaintiff Burton John   591864 591864 Burton, John, of Hedon, burgess & barber 0
4520866 2206870 2206870 defendant Shirborn Robert   591864 591864 Shirborn, Robert, of Hedon 0
4530904 2209959 2209959 plaintiff Palmer Thomas   591864 591864 Palmer, Thomas, of Hedon 0
4530907 2209960 2209960 plaintiff Palmer Thomas   591864 591864 Palmer, Thomas, of Hedon 0
4531169 2210023 2210023 defendant Estmer John dyer 591864 591864 Estmer, John, of Hedon, dyer 0
4547222 2215063 2215063 plaintiff Burton John de tanner 591864 591864 Burton, John de, of Hedon, tanner 0
4547224 2215064 2215064 plaintiff Burton John de tanner 591864 591864 Burton, John de, of Hedon, tanner 0
4547235 2215068 2215068 plaintiff Burton John   591864 591864 Burton, John, of Hedon 0
4563795 2220244 2220244 defendant Dynbrok Simon butcher 591864 591864 Dynbrok, Simon, of Hedon, butcher 0
4564851 2220570 2220570 defendant Maresflet John   591864 591864 Maresflet, John, of Hedon 11
4567275 2221321 2221321 defendant Palmer Thomas   591864 591864 Palmer, Thomas, of Hedon 0
4580216 2225299 2225299 defendant Seycroft William miller 591864 591864 Seycroft, William, of Hedon, miller 2
4580218 2225299 2225299 defendant Wylde Robert chaplain 591864 591864 Wylde, Robert, of Hedon, chaplain 4
4591061 2228559 2228559 plaintiff Merflete William   591864 591864 Merflete, William, of Hedon 0
4615556 2235864 2235864 defendant Wardall William   591864 591864 Wardall, William, of Hedon 5
4621185 2237615 2237615 defendant Crees Thomas furbisher 591864 591864 Crees, Thomas, of Hedon, furbisher 2
4627761 2239612 2239612 defendant Seriaunt Alan   591864 591864 Seriaunt, Alan, of Hedon 0
4628579 2239863 2239863 defendant Hervy Peter   591864 591864 Hervy, Peter, of Hedon 1
4666573 2251024 2251024 defendant Clerk William husbandman 591864 591864 Clerk, William, of Hedon, husbandman 0
4680085 2259381 2259381 defendant Vyvyan Adam gent 591864 591864 Vyvyan, Adam, of Hedon, gent 1
4683823 2260551 2260551 plaintiff Pidse William   591864 591864 Pidse, William, of Hedon 0
4685524 2261066 2261066 defendant Saxton Roger de chaplain 591864 591864 Saxton, Roger de, of Hedon, chaplain 0
4697997 2264864 2264864 defendant Aleyn William shipman 591864 591864 Aleyn, William, of Hedon, shipman 1
4719134 2271332 2271332 defendant Elward Richard chaplain 591864 591864 Elward, Richard, of Hedon, chaplain 1
4724190 2272860 2272860 defendant Burton Peter shipman 591864 591864 Burton, Peter, of Hedon, shipman 0
4729397 2274411 2274411 defendant Vyvyan Adam gent 591864 591864 Vyvyan, Adam, of Hedon, gent 0
4735527 2276259 2276259 defendant Smyth William tanner 591864 591864 Smyth, William, of Hedon, tanner 0
4747075 2279650 2279650 defendant Milner Roger milner 591864 591864 Milner, Roger, of Hedon, milner 0
4750609 2280665 2280665 plaintiff Robson John   591864 591864 Robson, John, of Hedon, burgess 0
4756524 2282404 2282404 plaintiff Benyngton John   591864 591864 Benyngton, John, of Hedon 0
4756527 2282405 2282405 plaintiff Benyngton John   591864 591864 Benyngton, John, of Hedon 0
4758829 2283115 2283115 plaintiff Carter Thomas   591864 591864 Carter, Thomas, of Hedon 0
4764982 2285023 2285023 defendant Burton John chapman 591864 591864 Burton, John, of Hedon, chapman 0
4765116 2285068 2285068 defendant Wodecok John yeoman 591864 591864 Wodecok, John, of Hedon, yeoman 0
4765122 2285069 2285069 defendant Burton John chapman 591864 591864 Burton, John, of Hedon, chapman 2
4766116 2285393 2285393 plaintiff Lairehome Thomas   591864 591864 Lairehome, Thomas, of Hedon 0
4767745 2285890 2285890 defendant Mershe John   591864 591864 Mershe, John, of Hedon, wright 3
4769193 2286343 2286343 plaintiff Palmer Thomas (legal representative) 591864 591864 Palmer, Thomas, of Hedon, executors of 0
4770156 2286636 2286636 defendant Forster John butcher 591864 591864 Forster, John, of Hedon, butcher 0
4770157 2286636 2286636 defendant Lilburn William weaver 591864 591864 Lilburn, William, of Hedon, weaver 1
4770158 2286636 2286636 defendant Skillyng Stephen   591864 591864 Skillyng, Stephen, of Hedon, glove maker 2
4770160 2286637 2286637 defendant Kirkeby Nicholas walker 591864 591864 Kirkeby, Nicholas, of Hedon, walker 0
4779951 2289729 2289729 defendant Flesshewer Stephen butcher 591864 591864 Flesshewer, Stephen, of Hedon, butcher 0
4780858 2290012 2290012 defendant Wherell Alan laborer 591864 591864 Wherell, Alan, of Hedon, laborer 1
4783563 2290877 2290877 defendant Shawe John chapman 591864 591864 Shawe, John, of Hedon, chapman 0
4790521 2293129 2293129 defendant Hoppyng Joan spinster 591864 591864 Hoppyng, Joan, of Hedon, spinster 0
4792123 2293636 2293636 defendant Mershe John   591864 591864 Mershe, John, of Hedon, wright 3
4792284 2293675 2293675 plaintiff Merflete William   591864 591864 Merflete, William, of Hedon 0
4795298 2294681 2294681 defendant Alnewyk William barker 591864 591864 Alnewyk, William, of Hedon, barker 0
4796815 2295157 2295157 plaintiff Shawe William   591864 591864 Shawe, William, of Hedon 0
4797561 2295406 2295406 defendant Yonge Richard mercer 591864 591864 Yonge, Richard, of Hedon, mercer 0
4802040 2296823 2296823 defendant Burton John chapman 591864 591864 Burton, John, of Hedon, chapman 0
4815149 2300847 2300847 plaintiff Kyng Thomas   591864 591864 Kyng, Thomas, of Hedon 0
4818727 2301945 2301945 defendant Shawe William smith 591864 591864 Shawe, William, of Hedon, smith 0
4818728 2301945 2301945 defendant Mollescroft William tanner 591864 591864 Mollescroft, William, of Hedon, tanner 1
4818729 2301945 2301945 defendant Rokeby Walter tanner 591864 591864 Rokeby, Walter, of Hedon, tanner 2
4818782 2301962 2301962 plaintiff Bolton Richard   591864 591864 (Bolton, Richard, of Hedon 1
4818788 2301963 2301963 plaintiff Palmer Thomas (legal representative) 591864 591864 Palmer, Thomas, of Hedon, executors of 0
4822455 2303095 2303095 plaintiff Skynner Joan   591864 591864 Skynner, Joan, of Hedon, formerly wife of John Skinner 0
4828803 2305044 2305044 defendant Cattewyk William chandler 591864 591864 Cattewyk, William, of Hedon, chandler 4
4842262 2309114 2309114 defendant Tyce John merchant 591864 591864 Tyce, John, of Hedon, merchant 0
4842264 2309114 2309114 defendant Kirkeby Robert merchant 591864 591864 Kirkeby, Robert, of Hedon, merchant 2
4842398 2309157 2309157 defendant Flaynburgh John carrier 591864 591864 Flaynburgh, John, of Hedon, carrier 1
4846433 2310390 2310390 plaintiff Preston Margaret   591864 591864 Preston, Margaret, of Hedon 0
4846830 2310515 2310515 defendant Kirkeby Robert chapman 591864 591864 Kirkeby, Robert, of Hedon, chapman 0
4855548 2313098 2313098 defendant Cattewyk William chandler 591864 591864 Cattewyk, William, of Hedon, chandler 1
4875267 2319217 2319217 defendant Burton John yeoman 591864 591864 Burton, John, of Hedon, son of Burton, Seman, of Staynfery in Holdernes, yeoman 1
4876096 2319484 2319484 defendant Rasyn William weaver 591864 591864 Rasyn, William, of Hedon, weaver 1
4876815 2319720 2319720 defendant Sewardby William weaver 591864 591864 Sewardby, William, of Hedon, weaver 0
4896710 2325634 2325634 defendant White John shipman 591864 591864 White, John, of Hedon, shipman 1
4896711 2325634 2325634 defendant Nevell Robert tailor 591864 591864 Nevell, Robert, of Hedon, tailor 2
4902652 2327449 2327449 defendant Wastnes John esq 591864 591864 Wastnes, John, of Hedon, esq 0
4906715 2328686 2328686 defendant Pyerson John flesshewer or butcher 591864 591864 Pyerson, John, of Hedon, flesshewer or butcher 0
4910551 2329811 2329811 plaintiff Bolton Richard   591864 591864 Bolton, Richard, of Hedon 0
4914109 2330925 2330925 defendant Bysset Mathew tailor 591864 591864 Bysset, Mathew, of Hedon, tailor 1
4959512 2344811 2344811 defendant Skyllyng Robert chapman 591864 591864 Skyllyng, Robert, of Hedon, chapman 0
4978696 2350579 2350579 defendant Mouscroft William barker 591864 591864 Mouscroft, William, of Hedon, barker 3
4996145 2355704 2355704 defendant Burton John in Holdernesse, merchant 591864 591864 Burton John, of Hedon, in Holdernesse, merchant 0
5018684 2362352 2362352 defendant Hedon Richard husbandman 591864 591864 Hedon, Richard, of Hedon, 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);