names

46 rows where place_id = 594961

✎ 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
3618276 1873343 1873343 defendant Petyte Thomas husbandman 594961 594961 Petyte, Thomas, of Tunstale, husbandman 0
3618278 1873344 1873344 defendant Petyte Thomas husbandman 594961 594961 Petyte, Thomas, of Tunstale, husbandman 0
3618280 1873345 1873345 defendant Petyte Thomas husbandman 594961 594961 Petyte, Thomas, of Tunstale, husbandman 0
3689138 1922765 1922765 defendant Lokes William husbandman 594961 594961 Lokes, William, of Tunstale, husbandman 0
4077188 2052127 2052127 defendant Smyth Ralph yeoman 594961 594961 Smyth, Ralph, of Tunstale, yeoman 0
4081863 2053818 2053818 defendant Smyth Ralph yeoman 594961 594961 Smyth, Ralph, of Tunstale, yeoman 0
4501936 2201206 2201206 plaintiff Marete John   594961 594961 Marete, John, of Tunstale 0
4512860 2204452 2204452 defendant Halle Robert   594961 594961 Halle, Robert, of Tunstale 0
4512861 2204452 2204452 defendant Berton William de   594961 594961 Berton, William de, of Tunstale 1
4526941 2208710 2208710 plaintiff Lee John   594961 594961 Lee, John, of Tunstale 0
4536024 2211546 2211546 defendant Halle Robert de   594961 594961 Halle, Robert de, of Tunstale 0
4552242 2216655 2216655 defendant Route Edmund   594961 594961 Route, Edmund, of Tunstale 1
4608036 2233629 2233629 defendant Brytreve John   594961 594961 Brytreve, John, of Tunstale 5
4654378 2247242 2247242 defendant Salkyn John laborer 594961 594961 Salkyn, John, of Tunstale, laborer 1
4666711 2255314 2255314 defendant Justyce William ploughman 594961 594961 Justyce, William, of Tunstale, ploughman 1
4681994 2259985 2259985 defendant Justyce William ploughman 594961 594961 Justyce, William, of Tunstale, ploughman 1
4683464 2260430 2260430 plaintiff Pechare William   594961 594961 Pechare, William, of Tunstale 0
4698503 2265007 2265007 defendant Brightyeby John husbandman 594961 594961 Brightyeby, John, of Tunstale, husbandman 0
4734511 2275960 2275960 defendant Berton Robert laborer 594961 594961 Berton, Robert, of Tunstale, laborer 0
4754274 2281715 2281715 defendant Carter Thomas yeoman 594961 594961 Carter, Thomas, of Tunstale, yeoman 0
4783023 2290708 2290708 defendant Yoman William husbandman 594961 594961 Yoman, William, of Tunstale, husbandman 0
4872443 2318345 2318345 defendant Maret John husbandman 594961 594961 together with Maret, John, of Tunstale, husbandman 4
4899037 2326340 2326340 defendant Tytloue or Tytlone Richard husbandman 594961 594961 Tytloue or Tytlone, Richard, of Tunstale, husbandman 0
4901167 2326979 2326979 defendant Tytelove Richard husbandman 594961 594961 Tytelove, Richard, of Tunstale, husbandman 11
4909949 2329636 2329636 defendant atte Gappe John yeoman 594961 594961 atte Gappe, John, of Tunstale, yeoman 1
4911707 2330163 2330163 defendant Sheryngham Thomas   594961 594961 Sheryngham, Thomas, of Tunstale, parson 0
4945989 2340733 2340733 defendant Tytlove John husbandman 594961 594961 Tytlove, John, of Tunstale, husbandman 0
4954618 2343337 2343337 defendant Fastolf John   594961 594961 Fastolf, John, of Tunstale, esq, son of Fastolf, Hugh, knight 0
5023692 2363836 2363836 defendant Fastolf Thomas gent 594961 594961 Fastolf, Thomas, of Tunstale, gent 3
5029190 2365415 2365415 defendant le Gap or le Gaper John husbandman 594961 594961 le Gap or le Gaper, John, of Tunstale, husbandman 2
5105306 2387995 2387995 defendant Edward John yeoman 594961 594961 Edward, John, of Tunstale, yeoman 3
5124099 2393505 2393505 defendant Blok Robert husbandman 594961 594961 Blok, Robert, of Tunstale, husbandman 0
5251239 2430490 2430490 defendant Russh William skinner 594961 594961 Russh, William, of Tunstale, skinner 0
5347316 2459325 2459325 defendant Kyrby Robert husbandman 594961 594961 Kyrby, Robert, of Tunstale, husbandman 0
5347317 2459325 2459325 defendant Tympe John husbandman 594961 594961 Tympe, John, of Tunstale, husbandman 1
5419802 2480837 2480837 defendant Spany Thomas husbandman 594961 594961 Spany, Thomas, of Tunstale, husbandman 1
5452381 2490584 2490584 defendant Spany Thomas husbandman 594961 594961 Spany, Thomas, of Tunstale, husbandman 0
5452385 2490585 2490585 defendant Spany Thomas husbandman 594961 594961 together with Spany, Thomas, of Tunstale, husbandman 1
5463407 2493964 2493964 defendant Spavy Thomas husbandman 594961 594961 Spavy, Thomas, of Tunstale, husbandman 0
5475832 2497773 2497773 defendant Spany Thomas husbandman 594961 594961 Spany, Thomas, of Tunstale, husbandman 0
5509300 2507761 2507761 defendant Venyour Robert husbandman 594961 594961 Venyour, Robert, of Tunstale, husbandman 0
5566762 2524873 2524873 defendant Wynter William husbandman 594961 594961 Wynter, William, of Tunstale, husbandman 2
5627995 2552727 2552727 plaintiff Pechare William, junior   594961 594961 Pechare, William, junior, of Tunstale 0
5627998 2552728 2552728 plaintiff Pechare William, junior   594961 594961 Pechare, William, junior, of Tunstale 0
5627999 2552728 2552728 defendant Hawe John husbandman 594961 594961 Hawe, John, of Tunstale, husbandman 0
5632381 2554162 2554162 defendant Olyver Robert husbandman 594961 594961 Olyver, Robert, of Tunstale, 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);