names

72 rows where place_id = 593077

✎ 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
3610344 1870891 1870891 defendant Assheby William husbandman 593077 593077 Assheby, William, of Somerby, husbandman 0
3619324 1873643 1873643 defendant Topclyff Richard esq 593077 593077 Topclyff, Richard, of Somerby, esq 14
3619325 1873643 1873643 defendant Nayller John yeoman 593077 593077 Nayller, John, of Somerby, yeoman 15
3660771 1913632 1913632 defendant Grey Henry clerk 593077 593077 Grey, Henry, of Somerby, clerk 0
3668950 1916221 1916221 defendant Dale William husbandman 593077 593077 Dale, William, of Somerby, husbandman 0
3668953 1916222 1916222 defendant Sympson William husbandman 593077 593077 Sympson, William, of Somerby, husbandman 1
3680276 1919905 1919905 defendant Wengge John yeoman 593077 593077 Wengge, John, of Somerby, yeoman 0
3680277 1919905 1919905 defendant Sympson William yeoman 593077 593077 Sympson, William, of Somerby, yeoman 1
3696552 1925152 1925152 defendant Corner Cornelius smith 593077 593077 Corner, Cornelius, of Somerby, smith 1
3754716 1943436 1943436 plaintiff Trygge George   593077 593077 Trygge, George, of Somerby 0
3756074 1943855 1943855 defendant Watton John laborer 593077 593077 Watton, John, of Somerby, laborer 1
3789723 1954616 1954616 plaintiff Trygge George   593077 593077 Trygge, George, of Somerby 0
3842646 1971231 1971231 defendant Dansey William gent 593077 593077 Dansey, William, of Somerby, gent 0
3858930 1976476 1976476 defendant Dansey William gent 593077 593077 Dansey, William, of Somerby, gent 0
3860415 1976978 1976978 defendant Colynwood William miller 593077 593077 Colynwood, William, of Somerby, miller 1
3874690 1981752 1981752 defendant Colyngwood William miller 593077 593077 Colyngwood, William, of Somerby, miller 1
3906609 1992504 1992504 defendant Bawdes Joan widow 593077 593077 Bawdes, Joan, of Somerby, widow 1
3917801 1996314 1996314 defendant Boosome John yeoman 593077 593077 Boosome, John, of Somerby, yeoman 0
3968473 2013606 2013606 defendant Garnet George yeoman 593077 593077 Garnet, George, of Somerby, yeoman 0
4152546 2079005 2079005 defendant Roceter Richard esq 593077 593077 Roceter, Richard, of Somerby, esq 0
4282358 2123729 2123729 defendant Gedney John gent 593077 593077 Gedney, John, of Somerby, gent 0
4295287 2128399 2128399 defendant Gedney John gent 593077 593077 Gedney, John, of Somerby, gent 2
4363469 2152008 2152008 defendant Taylor Robert clerk 593077 593077 Taylor, Robert, of Somerby, clerk 0
4459187 2187917 2187917 defendant Saleby Meliora de daughter of Richard 593077 593077 Saleby, Meliora de, of Somerby, daughter of Richard 0
4497785 2199950 2199950 defendant Prysshe-prest John   593077 593077 Prysshe-prest, John, of Somerby 0
4533270 2210665 2210665 defendant Topcliff Walter   593077 593077 Topcliff, Walter, of Somerby 0
4535376 2211335 2211335 defendant Bluet John   593077 593077 Bluet, John, of Somerby 2
4567779 2221490 2221490 plaintiff Topcliff Walter   593077 593077 Topcliff, Walter, of Somerby 0
4574936 2223683 2223683 defendant Barton Henry de   593077 593077 Barton, Henry de, of Somerby 0
4576135 2224037 2224037 defendant Custe or Ouste John   593077 593077 Custe or Ouste, John, of Somerby 0
4593551 2229261 2229261 defendant Lounsby Roger   593077 593077 Lounsby, Roger, of Somerby 7
4641478 2243606 2243606 defendant Smyth Thomas   593077 593077 Smyth, Thomas, of Somerby 0
4657138 2248122 2248122 defendant de Brygg Richard   593077 593077 de Brygg, Richard, of Somerby 3
4665340 2250649 2250649 defendant atte Brigg Richard husbandman 593077 593077 atte Brigg, Richard, of Somerby, husbandman 3
4685352 2261014 2261014 defendant Bluet John   593077 593077 Bluet, John, of Somerby 0
4743470 2278618 2278618 defendant Fyssher William husbandman 593077 593077 Fyssher, William, of Somerby, husbandman 0
4743471 2278618 2278618 defendant skekryngton John husbandman 593077 593077 skekryngton, John, of Somerby, husbandman 1
4743694 2278685 2278685 defendant Fyssher William husbandman 593077 593077 Fyssher, William, of Somerby, husbandman 0
4743695 2278685 2278685 defendant Skeryngton John husbandman 593077 593077 Skeryngton, John, of Somerby, husbandman 1
4770938 2286890 2286890 defendant Colby John yeoman 593077 593077 Colby, John, of Somerby, yeoman 0
4836434 2307371 2307371 defendant Watson Robert shoemaker 593077 593077 Watson, Robert, of Somerby, shoemaker 2
4850956 2311749 2311749 defendant Sawemon Henry husbandman 593077 593077 Sawemon, Henry, of Somerby, husbandman 0
4876992 2319775 2319775 defendant Watson Robert shoemaker 593077 593077 Watson, Robert, of Somerby, shoemaker 3
4904337 2327974 2327974 defendant Topclyff Joan widow 593077 593077 (Topclyff, Joan, of Somerby, widow 1
4904338 2327974 2327974 defendant Forster Richard yeoman 593077 593077 Forster, Richard, of Somerby, yeoman 2
4923084 2333639 2333639 defendant Topclyf John (legal representative) 593077 593077 Topclyf, John, of Somerby, executors of 0
4940057 2338918 2338918 plaintiff Dansey John esq 593077 593077 Dansey, John, of Somerby, esq 0
4940059 2338918 2338918 defendant Anton John   593077 593077 Anton, John, of Somerby 1
5060221 2374628 2374628 plaintiff Forester Richard   593077 593077 Forester, Richard, of Somerby 0
5119789 2392226 2392226 plaintiff Smyth John   593077 593077 Smyth, John, of Somerby 0
5127185 2394428 2394428 defendant White Thomas   593077 593077 White, Thomas, of Somerby clerk 2
5146020 2399958 2399958 defendant Whyte Thomas clerk 593077 593077 Whyte, Thomas, of Somerby, clerk 2
5335306 2455628 2455628 defendant Halman Thomas clerk 593077 593077 Halman, Thomas, of Somerby, clerk 1
5344397 2458427 2458427 plaintiff Topclyffe John esq 593077 593077 Topclyffe, John, of Somerby, esq 0
5411610 2478428 2478428 defendant Bawedes John gent 593077 593077 Bawedes, John, of Somerby, gent 0
5412535 2478694 2478694 defendant Botton John yeoman 593077 593077 Botton, John, of Somerby, yeoman 4
5420664 2481105 2481105 defendant Bailly Robert   593077 593077 Bailly, Robert, of Somerby, 0
5425860 2482699 2482699 defendant Drye Hugh husbandman 593077 593077 Drye, Hugh, of Somerby, husbandman 1
5425861 2482699 2482699 defendant Pullok (illegible) husbandman 593077 593077 Pullok, _, of Somerby, husbandman 2
5425862 2482699 2482699 defendant Pullok Geoffrey husbandman 593077 593077 Pullok Geoffrey, of Somerby, husbandman 3
5427358 2483126 2483126 defendant Botton John yeoman 593077 593077 Botton, John, of Somerby, yeoman 4
5428985 2483588 2483588 defendant Hall Thomas husbandman 593077 593077 Hall, Thomas, of Somerby, husbandman 2
5432427 2484671 2484671 plaintiff Lynde John drover 593077 593077 Lynde, John, of Somerby, drover 0
5448544 2489463 2489463 plaintiff Lynde John drover 593077 593077 Lynde, John, of Somerby, drover 0
5490806 2502143 2502143 defendant Bailly Robert butcher 593077 593077 Bailly, Robert, of Somerby, butcher 0
5564107 2524118 2524118 defendant Mower William husbandman 593077 593077 Mower, William, of Somerby, husbandman 0
5570490 2525941 2525941 defendant Mower William yeoman 593077 593077 Mower, William, of Somerby, yeoman 1
5578017 2528194 2528194 defendant Gee Hugh husbandman 593077 593077 Gee, Hugh, of Somerby, husbandman 0
5578018 2528194 2528194 defendant Trafford Thomas merchant 593077 593077 Trafford, Thomas, of Somerby, merchant 1
5593750 2533032 2533032 defendant Horsepole John husbandman 593077 593077 Horsepole, John, of Somerby, husbandman 1
5606105 2536799 2536799 defendant Dale William husbandman 593077 593077 Dale, William, of Somerby, husbandman 0
5633886 2554592 2554592 plaintiff Topclyff John   593077 593077 Topclyff, John, of Somerby 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);