names

57 rows where place_id = 614167

✎ 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
3647082 1909479 1909479 defendant Hutton William gent 614167 614167 Hutton, William, of Hutton, Cumber, gent 4
3702281 1926969 1926969 plaintiff Cayleway Elizabeth widow 614167 614167 Cayleway, Elizabeth, of Hutton, widow 0
3715938 1931272 1931272 plaintiff Caylewey Elizbaeth   614167 614167 Caylewey, Elizbaeth, of Hutton 0
3747949 1941279 1941279 defendant Ayrey Edward chaplain 614167 614167 Ayrey, Edward, of Hutton, chaplain 0
3747950 1941279 1941279 defendant Harreson Robert husbandman 614167 614167 Harreson, Robert, of Hutton, husbandman 1
3747953 1941279 1941279 defendant Gawkethorpe Miles laborer 614167 614167 Gawkethorpe, Miles, of Hutton, laborer 4
3780485 1951629 1951629 defendant Whyght William   614167 614167 Whyght, William, of Hutton, gent, son of Whyght, Richard, of Hutton 0
3809500 1960853 1960853 plaintiff Beke Miles merchant 614167 614167 Beke, Miles, of Hutton, merchant 0
3809501 1960853 1960853 defendant Whithede Hugh merchant 614167 614167 Whithede, Hugh, of Hutton, merchant 0
3940299 2003776 2003776 defendant Curteys Thomas yeoman 614167 614167 Curteys, Thomas, of Hutton, yeoman 2
3940311 2003778 2003778 defendant Curtys Thomas   614167 614167 Curtys, Thomas, of Hutton 2
4018988 2031527 2031527 plaintiff Walter David husbandman 614167 614167 Walter, David, of Hutton, husbandman 0
4018990 2031528 2031528 plaintiff Walter David husbandman 614167 614167 Walter, David, of Hutton, husbandman 0
4043901 2040269 2040269 defendant Warde William husbandman 614167 614167 Warde, William, of Hutton, husbandman 0
4043903 2040270 2040270 defendant Warde William husbandman 614167 614167 Warde, William, of Hutton, husbandman 0
4067118 2048538 2048538 plaintiff Hutton Thomas gent 614167 614167 Hutton, Thomas, of Hutton John, Cumber, gent 0
4144947 2076393 2076393 defendant Symmons John husbandman 614167 614167 Symmons, John, of Hutton, husbandman 0
4155006 2079844 2079844 defendant Lother Gerard gent 614167 614167 Lother, Gerard, of Hutton John, gent 0
4171998 2085669 2085669 defendant Payne Christopher gent 614167 614167 Payne, Christopher, of Hutton, gent 0
4173026 2086020 2086020 defendant Lockyn William yeoman 614167 614167 Lockyn, William, of Hutton, yeoman 0
4173527 2086195 2086195 defendant Collyns alias Oldmyxon John husbandman 614167 614167 Collyns alias Oldmyxon, John, of Hutton, husbandman 0
4178018 2087782 2087782 defendant Symons John husbandman 614167 614167 Symons, John, of Hutton, husbandman 2
4196877 2094458 2094458 defendant Collyns alias Oldmyxon John husbandman 614167 614167 Collyns alias Oldmyxon, John, of Hutton, husbandman 0
4215366 2100872 2100872 defendant Slinger Thomas yeoman 614167 614167 Slinger, Thomas, of Hutton, yeoman 0
4215369 2100873 2100873 defendant Slinger Thomas yeoman 614167 614167 Slinger, Thomas, of Hutton, yeoman 0
4251112 2113351 2113351 defendant Phelpes Robert husbandman 614167 614167 Phelpes, Robert, of Hutton, husbandman 2
4276367 2121678 2121678 defendant White Reginald husbandman 614167 614167 White, Reginald, of Hutton, husbandman 0
4287363 2125534 2125534 defendant Clarke William husbandman 614167 614167 Clarke, William, of Hutton, husbandman 0
4307500 2132761 2132761 defendant Younge Robert yeoman 614167 614167 Younge Robert, of Hutton, yeoman 1
4309169 2133363 2133363 defendant Cassye or Caffye John gent 614167 614167 Cassye or Caffye, John, of Hutton, gent 0
4309182 2133367 2133367 defendant Simons John husbandman 614167 614167 Simons, John, of Hutton, husbandman 0
4350446 2147419 2147419 defendant Vittie or Uittie Thomas miller 614167 614167 Vittie or Uittie, Thomas, of Hutton, miller 1
4363296 2151944 2151944 defendant Clarke John husbandman 614167 614167 Clarke, John, of Hutton, husbandman 0
4364239 2152270 2152270 defendant Robynson Edmund yeoman 614167 614167 Robynson, Edmund, of Hutton, Cumber, yeoman 1
4383211 2159103 2159103 defendant Storr Thomas yeoman 614167 614167 Storr, Thomas, of Hutton, yeoman 0
4395026 2162921 2162921 defendant Ponde Richard tailor 614167 614167 Ponde, Richard, of Hutton, tailor 3
4401121 2164969 2164969 defendant Kenn Edmund gent 614167 614167 Kenn, Edmund, of Hutton, gent 0
4476140 2193206 2193206 defendant Taillour William   614167 614167 Taillour, William, of Hutton 2
4627390 2239504 2239504 defendant Thomson Nicholas   614167 614167 Thomson, Nicholas, of Hutton 2
4774587 2288038 2288038 defendant Neweman Robert husbandman 614167 614167 Neweman, Robert, of Hutton, husbandman 0
4809257 2299070 2299070 defendant Kepe Humphrey husbandman 614167 614167 Kepe, Humphrey, of Hutton, husbandman 2
4978962 2350665 2350665 defendant Sutton John husbandman 614167 614167 Sutton, John, of Hutton, husbandman 11
4984714 2352355 2352355 defendant Paule William gent 614167 614167 together with Paule, William, of Hutton, gent 5
4986038 2352744 2352744 defendant Pauly William husbandman 614167 614167 Pauly, William, of Hutton, husbandman 1
4986244 2352815 2352815 defendant Sher_ William husbandman 614167 614167 Sher_, William, of Hutton, husbandman 0
4986245 2352815 2352815 defendant Whytechyrch John   614167 614167 Whytechyrch, John, of Hutton, shepherd 1
5094159 2384696 2384696 defendant Payn John gent 614167 614167 Payn, John, of Hutton, gent 0
5139887 2398145 2398145 defendant Oldymexon John gent 614167 614167 Oldymexon, John, of Hutton, gent 0
5227130 2423584 2423584 defendant Hordewell Pagan husbandman 614167 614167 Hordewell, Pagan, of Hutton, husbandman 5
5227131 2423584 2423584 defendant Pole William husbandman 614167 614167 Pole, William, of Hutton, husbandman 6
5227132 2423584 2423584 defendant Gente Walter husbandman 614167 614167 Gente, Walter, of Hutton, husbandman 7
5431569 2484395 2484395 defendant Porter John husbandman 614167 614167 Porter, John, of Hutton, husbandman 0
5431570 2484395 2484395 defendant Kyghson John husbandman 614167 614167 Kyghson, John, of Hutton, husbandman 1
5447981 2489280 2489280 defendant Porter John husbandman 614167 614167 Porter, John, of Hutton, husbandman 0
5447982 2489280 2489280 defendant Kythson John husbandman 614167 614167 Kythson, John, of Hutton, husbandman 1
5483355 2499969 2499969 defendant Kythson John gent 614167 614167 Kythson, John, of Hutton, gent 3
5573298 2526747 2526747 defendant Payne John husbandman 614167 614167 Payne, John, of Hutton, husbandman 0

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);