names

166 rows where place_id = 606673

✎ 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
3657711 1912663 1912663 plaintiff de Gasket John (legal representative) 606673 606673 de Gasket, John, of Hull, merchant, executors of 0
3666109 1915345 1915345 defendant Ewerby Thomas yeoman 606673 606673 Ewerby, Thomas, of Hull, yeoman 0
3666110 1915345 1915345 defendant Arrot Thomas yeoman 606673 606673 Arrot, Thomas, of Hull, yeoman 1
3687084 1922132 1922132 defendant Busshell Rogert merchant of the staple 606673 606673 Busshell, Rogert, of Hull, merchant of the staple 1
3777300 1950644 1950644 defendant Marten Peter yeoman 606673 606673 Marten, Peter, of Hull, yeoman 0
3783675 1952656 1952656 defendant Coket John (legal representative) 606673 606673 Coket, John, of Hull, executors of 0
3809135 1960741 1960741 plaintiff Baron Peter   606673 606673 Baron, Peter, of Hull 0
3838247 1969881 1969881 defendant Haven John merchant of the staple 606673 606673 Haven, John, of Hull, merchant of the staple 0
3851142 1973947 1973947 plaintiff Oversall Hugh   606673 606673 Oversall, Hugh, of Hull 0
3853426 1974698 1974698 plaintiff Thurscros Geoffrey (legal representative) 606673 606673 Thurscros, Geoffrey, of Hull, merchant, executrix of 2
3868811 1979809 1979809 defendant Haven John merchant of the staple 606673 606673 Haven, John, of Hull, merchant of the staple 0
3870037 1980222 1980222 defendant Roye William chapman 606673 606673 Roye, William, of Hull, chapman 0
3870044 1980223 1980223 defendant Roye William chapman 606673 606673 Roye, William, of Hull, chapman 0
3936038 2002373 2002373 defendant Anderson Thomas merchant 606673 606673 Anderson, Thomas, of Hull, merchant 0
3941095 2004025 2004025 plaintiff Thakker John merchant 606673 606673 Thakker, John, of Hull, merchant 0
3953665 2008358 2008358 plaintiff Jobson Walter merchant 606673 606673 Jobson, Walter, of Hull, merchant 0
3953667 2008359 2008359 plaintiff Jobson Walter merchant 606673 606673 Jobson, Walter, of Hull, merchant 0
3953669 2008360 2008360 plaintiff Jobson Walter merchant 606673 606673 Jobson, Walter, of Hull, merchant 0
3961023 2010950 2010950 plaintiff Thompson William merchant 606673 606673 Thompson, William, of Hull, merchant 0
3980168 2017673 2017673 defendant Wilk Richard clerk 606673 606673 Wilk, Richard, of Hull, clerk 1
3980169 2017673 2017673 defendant Bennett Thomas laborer 606673 606673 Bennett, Thomas, of Hull, laborer 2
4000457 2024932 2024932 defendant James William yeoman 606673 606673 James, William, of Hull, yeoman 0
4000462 2024933 2024933 defendant James Isabel widow 606673 606673 James, Isabel, of Hull, widow 1
4015306 2030169 2030169 plaintiff Smyth John merchant 606673 606673 Smyth, John, of Hull, merchant 0
4029454 2035172 2035172 defendant Almonde William gent 606673 606673 Almonde, William, of Hull, gent 0
4042354 2039749 2039749 plaintiff Parker William (legal representative) 606673 606673 Parker, William, of Hull, merchant, executors of 0
4419742 2171073 2171073 defendant Santon John de   606673 606673 Santon, John de, of Hull 0
4442255 2182511 2182511 plaintiff Bron Alice   606673 606673 Bron, Alice, of Hull 0
4455812 2186832 2186832 defendant Selby Henry de   606673 606673 Selby, Henry de, of Hull 0
4455814 2186833 2186833 defendant Selby Henry de   606673 606673 Selby, Henry de, of Hull 0
4457509 2187360 2187360 plaintiff Tutbury Adam   606673 606673 Tutbury, Adam, of Hull 3
4462250 2188892 2188892 plaintiff Swynflet Thomas de   606673 606673 Swynflet, Thomas de, of Hull 0
4468360 2190770 2190770 plaintiff Bate William   606673 606673 Bate, William, of Hull, burgess, on his own account 0
4470908 2191553 2191553 plaintiff Burton John (legal representative) 606673 606673 Burton, John, of Hull, shipman, executor of 0
4470909 2191553 2191553 plaintiff Shawe John   606673 606673 Shawe, John, of Hull 1
4472635 2192108 2192108 defendant Barbour Thomas   606673 606673 Barbour, Thomas, of Hull 1
4472945 2192212 2192212 defendant Cotyngham John de thatcher 606673 606673 Cotyngham, John de, of Hull, thatcher 0
4474156 2192570 2192570 plaintiff Valmound Peter mariner 606673 606673 Valmound, Peter, of Hull, mariner 1
4478180 2193848 2193848 defendant Sergeant John   606673 606673 Sergeant, John, of hull 4
4487060 2196676 2196676 plaintiff Shawe John   606673 606673 Shawe, John, of Hull 0
4495675 2199325 2199325 plaintiff Cave Robert de   606673 606673 Cave, Robert de, of Hull, on his own account 0
4500623 2200817 2200817 plaintiff Kane Robert de   606673 606673 Kane, Robert de, of Hull 0
4505617 2202275 2202275 defendant Saltmerssh John   606673 606673 Saltmerssh, John, of Hull 0
4505641 2202278 2202278 defendant Saltmersshm John   606673 606673 Saltmersshm, John, of Hull 0
4506824 2202604 2202604 plaintiff Tuttebery John   606673 606673 Tuttebery, John, of Hull, on his own account 0
4507714 2202873 2202873 plaintiff Wilcok Alan   606673 606673 Wilcok, Alan, of Hull, burgess 0
4507721 2202874 2202874 plaintiff Wilcok Alan mariner 606673 606673 Wilcok, Alan, of Hull, mariner 0
4510747 2203817 2203817 defendant Brakyn Henry   606673 606673 Brakyn, Henry, of Hull 2
4512778 2204431 2204431 plaintiff Brakyne Henry   606673 606673 Brakyne, Henry, of Hull 0
4513569 2204667 2204667 plaintiff Broun John   606673 606673 Broun, John, of Hull 0
4514186 2204855 2204855 defendant Bate William   606673 606673 Bate, William, of Hull 0
4514187 2204855 2204855 defendant Dodyngton Robert   606673 606673 Dodyngton, Robert, of Hull 1
4515331 2205209 2205209 plaintiff Chery William   606673 606673 Chery, William, of Hull 0
4525216 2208225 2208225 plaintiff Ingram Robert   606673 606673 Ingram, Robert, of Hull 0
4525222 2208226 2208226 plaintiff Ingram Robert chapman 606673 606673 Ingram, Robert, of Hull, chapman 0
4525224 2208227 2208227 plaintiff Ingram Robert chapman 606673 606673 Ingram, Robert, of Hull, chapman 0
4526202 2208485 2208485 defendant Clerk John mariner 606673 606673 Clerk, John, of Hull, mariner 0
4529015 2209353 2209353 plaintiff Messyngham John   606673 606673 Messyngham, John, of Hull, bow maker 0
4540254 2212853 2212853 defendant Percy Thomas   606673 606673 Percy, Thomas, of Hull 0
4540955 2213078 2213078 plaintiff Wilcokes Alan   606673 606673 Wilcokes, Alan, of Hull, burgess 0
4541816 2213329 2213329 plaintiff Wylkok Alan   606673 606673 Wylkok, Alan, of Hull, burgess 0
4542047 2213404 2213404 plaintiff Wysdam John   606673 606673 Wysdam, John, of Hull 0
4545730 2214592 2214592 defendant Broun John   606673 606673 Broun, John, of Hull 2
4546122 2214734 2214734 plaintiff Brakyn Henry   606673 606673 Brakyn, Henry, of Hull 0
4546323 2214786 2214786 plaintiff Brende Henry   606673 606673 (Brende, Henry, of Hull 1
4549680 2215833 2215833 defendant Burn Robert   606673 606673 Burn, Robert, of Hull 1
4550209 2216011 2216011 defendant Litster Robert   606673 606673 Litster, Robert, of Hull 0
4551949 2216562 2216562 defendant Dr_m_yston Walter   606673 606673 Dr_m_yston, Walter, of Hull 1
4551950 2216562 2216562 defendant Rotse Thomas   606673 606673 Rotse, Thomas, of Hull 2
4554458 2217326 2217326 plaintiff Grymesby Simon de   606673 606673 Grymesby, Simon de, of Hull 0
4561475 2219522 2219522 defendant Rous Richard   606673 606673 Rous, Richard, of Hull 3
4563677 2220205 2220205 defendant Houden John dyer 606673 606673 Houden, John, of Hull, dyer 2
4564832 2220567 2220567 defendant Ratclyff John   606673 606673 Ratclyff, John, of Hull 3
4569264 2221974 2221974 defendant Percy Thomas   606673 606673 Percy, Thomas, of Hull 0
4570009 2222192 2222192 plaintiff Wilcok Alan   606673 606673 Wilcok, Alan, of Hull 0
4573400 2223211 2223211 plaintiff Barker John   606673 606673 Barker, John, of Hull 0
4574189 2223452 2223452 defendant Donyngton Robert   606673 606673 Donyngton, Robert, of Hull 2
4574316 2223497 2223497 defendant Hedon William   606673 606673 Hedon, William, of Hull 0
4574719 2223617 2223617 defendant Pricofeld John   606673 606673 Pricofeld, John, of Hull 15
4577753 2224549 2224549 defendant Buxstones John   606673 606673 Buxstones, John, of Hull 1
4577919 2224599 2224599 defendant Buxstones John   606673 606673 Buxstones, John, of Hull 1
4579292 2225006 2225006 defendant Wiklowe Thomas   606673 606673 Wiklowe, Thomas, of Hull 0
4579294 2225006 2225006 defendant Filipot Thomas   606673 606673 Filipot, Thomas, of Hull 2
4579812 2225173 2225173 defendant Ingram Robert shipman 606673 606673 Ingram, Robert, of Hull, shipman 0
4581937 2225799 2225799 defendant Cawode Robert   606673 606673 Cawode, Robert, of Hull 0
4586561 2227206 2227206 defendant Brygg William   606673 606673 Brygg, William, of Hull 1
4590303 2228334 2228334 defendant Taillour William   606673 606673 Taillour, William, of Hull, clerk, son of John 8
4591211 2228608 2228608 plaintiff Michel John   606673 606673 Michel, John, of Hull 0
4591678 2228753 2228753 defendant Milner John shipman 606673 606673 Milner, John, of Hull, shipman 0
4593213 2229173 2229173 defendant Bruet William butcher 606673 606673 Bruet, William, of Hull, butcher 0
4603219 2232214 2232214 defendant Arnald John   606673 606673 Arnald, John, of Hull 2
4604381 2232541 2232541 defendant Joynour William   606673 606673 Joynour, William, of Hull 0
4607765 2233540 2233540 defendant Terry Thomas   606673 606673 Terry, Thomas, of Hull 1
4607770 2233542 2233542 defendant Terry William   606673 606673 Terry, William, of Hull 0
4607771 2233542 2233542 defendant Terry Richard   606673 606673 Terry, Richard, of Hull 1
4612390 2234946 2234946 defendant Tenne Richard carter 606673 606673 Tenne, Richard, of Hull, carter 0
4612391 2234946 2234946 defendant Hill Thomas of the walker 606673 606673 Hill, Thomas of the, of Hull, walker 1
4612394 2234946 2234946 defendant Croun John shipman 606673 606673 Croun, John, of Hull, shipman 4
4615038 2235716 2235716 defendant Baxstere William   606673 606673 Baxstere, William, of Hull 0
4615555 2235864 2235864 defendant Braweby Thomas   606673 606673 Braweby, Thomas, of Hull 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);