names

140 rows where place_id = 595368

✎ 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
3620193 1873893 1873893 defendant Nayler Henry laborer 595368 595368 Nayler, Henry, of Halyfax, laborer 0
3620194 1873893 1873893 defendant Crosley Robert smith 595368 595368 Crosley, Robert, of Halyfax, smith 1
3639660 1907214 1907214 defendant Baldwenson Edward yeoman 595368 595368 Baldwenson, Edward, of Halyfax, yeoman 1
3650094 1910398 1910398 defendant Kay William gent 595368 595368 Kay, William, of Halyfax, gent 0
3654019 1911519 1911519 defendant Hadldisworthe Richard clothman 595368 595368 Hadldisworthe, Richard, of Halyfax, clothman 2
3656236 1912198 1912198 defendant Wottys William clothier 595368 595368 Wottys, William, of Halyfax, clothier 3
3656241 1912199 1912199 defendant Wottys William clothier 595368 595368 Wottys, William, of Halyfax, clothier 3
3705061 1927873 1927873 defendant Rawson James dyer 595368 595368 Rawson, James, of Halyfax, dyer 1
3709430 1929251 1929251 defendant Bacheler alias Bageler Henry dyer 595368 595368 Bacheler alias Bageler, Henry, of Halyfax, dyer 0
3709435 1929253 1929253 defendant Waterhouse Edward clothier 595368 595368 Waterhouse, Edward, of Halyfax, clothier 0
3709436 1929253 1929253 defendant Walker Nicholas dyer 595368 595368 Walker, Nicholas, of Halyfax, dyer 1
3712736 1930298 1930298 defendant Waterhowe John yeoman 595368 595368 Waterhowe, John, of Halyfax, yeoman 2
3719091 1932252 1932252 plaintiff Grenewode Richard sherman 595368 595368 Grenewode, Richard, of Halyfax, sherman 0
3727165 1934767 1934767 defendant Hall Richard yeoman 595368 595368 Hall, Richard, of Halyfax, yeoman 1
3727166 1934767 1934767 defendant Cliff Richard yeoman 595368 595368 Cliff, Richard, of Halyfax, yeoman 2
3738338 1938207 1938207 defendant Harryson John butcher 595368 595368 Harryson, John, of Halyfax, butcher 0
3738339 1938207 1938207 defendant Barestewe Richard butcher 595368 595368 Barestewe, Richard, of Halyfax, butcher 1
3747182 1941037 1941037 defendant Hanson Robert woolman 595368 595368 Hanson, Robert, of Halyfax, woolman 1
3751206 1942302 1942302 defendant Harryson John butcher 595368 595368 Harryson, John, of Halyfax, butcher 0
3779404 1951280 1951280 defendant Wedyngton Edward   595368 595368 Wedyngton, Edward, of Halyfax 0
3798004 1957274 1957274 defendant Farrour Henry yeoman 595368 595368 Farrour, Henry, of Halyfax, yeoman 0
3814842 1962556 1962556 defendant Walker Lawrence yeoman 595368 595368 Walker, Lawrence, of Halyfax, yeoman 1
3814844 1962557 1962557 defendant Waterhouse Robert yeoman 595368 595368 Waterhouse, Robert, of Halyfax, yeoman 0
3814845 1962557 1962557 defendant Walker Lawrence yeoman 595368 595368 Walker, Lawrence, of Halyfax, yeoman 1
3815354 1962717 1962717 defendant Farrour Henry yeoman 595368 595368 Farrour, Henry, of Halyfax, yeoman 0
3815933 1962888 1962888 defendant Halle John yeoman 595368 595368 Halle, John, of Halyfax, yeoman 0
3815936 1962889 1962889 defendant Ferrour John yeoman 595368 595368 Ferrour, John, of Halyfax, yeoman 0
3815938 1962890 1962890 defendant Halle John yeoman 595368 595368 Halle, John, of Halyfax, yeoman 0
3817299 1963322 1963322 defendant Ottys John   595368 595368 Ottys, John, of Halyfax, yeoman, son of Oytte, John, of Halyfax 0
3821434 1964597 1964597 defendant Cottys John yeoman 595368 595368 Cottys, John, of Halyfax, yeoman 2
3823053 1965119 1965119 defendant Walker Lawrence chapman 595368 595368 Walker, Lawrence, of Halyfax, chapman 0
3827586 1966488 1966488 defendant Bunny Richard butcher 595368 595368 Bunny, Richard, of Halyfax, butcher 2
3831514 1967742 1967742 defendant Brigge John miller 595368 595368 Brigge, John, of Halyfax, miller 0
3833765 1968494 1968494 defendant Bothis James husbandman 595368 595368 Bothis, James, of Halyfax, husbandman 0
3848904 1973247 1973247 defendant Mawde William tailor 595368 595368 (Mawde, William, of Halyfax, tailor 2
3869652 1980093 1980093 plaintiff Watterhowes John   595368 595368 Watterhowes, John, of Halyfax 0
3899434 1990025 1990025 defendant Wilkynson James yeoman 595368 595368 Wilkynson, James, of Halyfax, yeoman 0
3899445 1990028 1990028 defendant Bentley Arthur yeoman 595368 595368 Bentley, Arthur, of Halyfax, yeoman 0
3919344 1996801 1996801 plaintiff Lacy Thomas gent 595368 595368 Lacy, Thomas, of Halyfax, gent 0
3932191 2001071 2001071 defendant Ramysden William clothier 595368 595368 Ramysden, William, of Halyfax, clothier 0
3932192 2001071 2001071 defendant Appliard Nicholas clothier 595368 595368 Appliard, Nicholas, of Halyfax, clothier 1
3952522 2007950 2007950 defendant Nottyngham Margaret spinster 595368 595368 Nottyngham, Margaret, of Halyfax, spinster 0
3974037 2015490 2015490 defendant Baraclowghe Richard chapman 595368 595368 Baraclowghe, Richard, of Halyfax, chapman 1
4023147 2032992 2032992 plaintiff Baracloughe Edward mercer 595368 595368 Baracloughe, Edward, of Halyfax, mercer 0
4050372 2042564 2042564 plaintiff Otes Gilbert mercer 595368 595368 Otes, Gilbert, of Halyfax, mercer 1
4169892 2084965 2084965 defendant Nutta Thomas clothier 595368 595368 Nutta, Thomas, of Halyfax, clothier 2
4169893 2084965 2084965 defendant Saker Thomas clothier 595368 595368 Saker, Thomas, of Halyfax, clothier 3
4171973 2085659 2085659 defendant Horsfall Francis butcher 595368 595368 Horsfall, Francis, of Halyfax, butcher 1
4558016 2218443 2218443 defendant Mathew John   595368 595368 Mathew, John, of Halyfax 0
4564490 2220460 2220460 plaintiff Kyng John   595368 595368 (Kyng, John, of Halyfax, vicar 1
4596990 2230302 2230302 plaintiff Kyng John   595368 595368 (Kyng, John, of Halyfax, vicar 1
4819116 2302057 2302057 plaintiff Peck Richard   595368 595368 Peck, Richard, of Halyfax 0
4863574 2315578 2315578 defendant Chullore William schoolmaster 595368 595368 Chullore, William, of Halyfax, schoolmaster 0
4863577 2315579 2315579 defendant Litster Richard yeoman 595368 595368 Litster, Richard, of Halyfax, yeoman 0
4863578 2315579 2315579 defendant Ferrour or Smith Robert husbandman 595368 595368 Ferrour or Smith, Robert, of Halyfax, husbandman 1
4872481 2318352 2318352 defendant Ryssheworth John gent 595368 595368 Ryssheworth, John, of Halyfax, gent 1
4883066 2321627 2321627 defendant Littestere Richard yeoman 595368 595368 Littestere, Richard, of Halyfax, yeoman 1
4905476 2328307 2328307 defendant Lyttestere Richard yeoman 595368 595368 Lyttestere, Richard, of Halyfax, yeoman 1
4916752 2331741 2331741 defendant Jacson John, senior yeoman 595368 595368 Jacson, John, senior, of Halyfax, yeoman 4
4917194 2331884 2331884 plaintiff Fryth Richard   595368 595368 Fryth, Richard, of Halyfax 0
4931897 2336361 2336361 plaintiff Waterhous Richard   595368 595368 Waterhous, Richard, of Halyfax 0
4942783 2339714 2339714 plaintiff Fryth Richard draper 595368 595368 Fryth, Richard, of Halyfax, draper 0
4953072 2342886 2342886 defendant Gybson John chapman 595368 595368 Gybson, John, of Halyfax, chapman 1
4961921 2345517 2345517 defendant Fox John walker 595368 595368 Fox, John, of Halyfax, walker 1
5013905 2360919 2360919 defendant Thurgurland Richard yeoman 595368 595368 Thurgurland, Richard, of Halyfax, yeoman 0
5015855 2361529 2361529 plaintiff Brodele William draper 595368 595368 Brodele, William, of Halyfax, draper 0
5031245 2366004 2366004 defendant Fournesse Ralph yeoman 595368 595368 Fournesse, Ralph, of Halyfax, yeoman 19
5031246 2366004 2366004 defendant Fournesse John yeoman 595368 595368 Fournesse, John, of Halyfax, yeoman 20
5031275 2366005 2366005 defendant Fournesse Ralph yeoman 595368 595368 Fournesse, Ralph, of Halyfax, yeoman 19
5031276 2366005 2366005 defendant Fournesse John yeoman 595368 595368 Fournesse, John, of Halyfax, yeoman 20
5032612 2366421 2366421 defendant Lyster Richard yeoman 595368 595368 Lyster, Richard, of Halyfax, yeoman 0
5037442 2367822 2367822 defendant Haldeworth William yeoman 595368 595368 Haldeworth, William, of Halyfax, yeoman 2
5060288 2374650 2374650 plaintiff Fournes Ralph   595368 595368 Fournes, Ralph, of Halyfax 0
5085730 2382221 2382221 plaintiff Haleworth or Haldworthe William draper 595368 595368 Haleworth or Haldworthe, William, of Halyfax, draper 0
5119206 2392045 2392045 plaintiff Schagh or Shawe William (legal representative) 595368 595368 Schagh or Shawe, William, of Halyfax, draper, executors of 0
5119493 2392132 2392132 plaintiff Shawe Robert draper 595368 595368 Shawe, Robert, of Halyfax, draper 0
5237306 2426495 2426495 plaintiff Furnays Thomas   595368 595368 Furnays, Thomas, of Halyfax 0
5255594 2431868 2431868 defendant Stanley John gent 595368 595368 Stanley, John, of Halyfax, gent 0
5255597 2431869 2431869 defendant Stanley John gent 595368 595368 Stanley, John, of Halyfax, gent 0
5303546 2446056 2446056 plaintiff Gybson Richard   595368 595368 Gybson, Richard, of Halyfax 0
5315516 2449708 2449708 defendant Gybson Richard chaplain 595368 595368 Gybson, Richard, of Halyfax, chaplain 0
5328380 2453562 2453562 defendant Doughty William yeoman 595368 595368 Doughty, William, of Halyfax, yeoman 0
5328381 2453562 2453562 defendant Doughty John yeoman 595368 595368 Doughty, John, of Halyfax, yeoman 1
5328383 2453563 2453563 defendant Dughty William yeoman 595368 595368 Dughty, William, of Halyfax, yeoman 0
5328384 2453563 2453563 defendant Dughty John yeoman 595368 595368 Dughty, John, of Halyfax, yeoman 1
5340153 2457128 2457128 defendant Thorp Peter yeoman 595368 595368 Thorp, Peter, of Halyfax, yeoman 2
5340158 2457129 2457129 defendant Thorp Peter yeoman 595368 595368 Thorp, Peter, of Halyfax, yeoman 1
5366227 2465098 2465098 defendant Holgate William yeoman 595368 595368 Holgate, William, of Halyfax, yeoman 0
5373610 2467344 2467344 defendant More Richard husbandman 595368 595368 More, Richard, of Halyfax, husbandman 0
5386318 2471153 2471153 defendant Stanley John gent 595368 595368 Stanley, John, of Halyfax, gent 0
5390583 2472368 2472368 defendant Otes William yeoman 595368 595368 (Otes, William, of Halyfax, yeoman 5
5395832 2473892 2473892 defendant Otes William yeoman 595368 595368 Otes, William, of Halyfax, yeoman 0
5398544 2474644 2474644 defendant Stanley John gent 595368 595368 Stanley, John, of Halyfax, gent 0
5403404 2476047 2476047 defendant More Richard husbandman 595368 595368 More, Richard, of Halyfax, husbandman 0
5403405 2476047 2476047 defendant Bates Robert tailor 595368 595368 Bates, Robert, of Halyfax, tailor 1
5403406 2476047 2476047 defendant Bates Thomas (legal representative) 595368 595368 Bates, Thomas, of Halyfax, tailor, executor of 2
5407808 2477310 2477310 plaintiff Wilkynson Thomas (legal representative) 595368 595368 Wilkynson, Thomas, of Halyfax, vicar, executor of: 1
5407809 2477310 2477310 defendant Milner Thomas yeoman 595368 595368 Milner, Thomas, of Halyfax, yeoman 0
5408945 2477636 2477636 defendant Longbothum Richard gent 595368 595368 Longbothum, Richard, of Halyfax, gent 0
5409112 2477693 2477693 defendant Otes William yeoman 595368 595368 Otes, William, of Halyfax, yeoman 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);