names

53 rows where place_id = 596182

✎ 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
3623504 1874881 1874881 defendant Aylton Thomas husbandman 596182 596182 Aylton, Thomas, of Muston, husbandman 2
3679594 1919687 1919687 defendant Breten Edmund husbandman 596182 596182 Breten, Edmund, of Muston, husbandman 0
3778515 1950997 1950997 defendant Cragg Reginald laborer 596182 596182 Cragg, Reginald, of Muston, laborer 0
3778517 1950998 1950998 defendant Cragg Reginald laborer 596182 596182 Cragg, Reginald, of Muston, laborer 0
3785475 1953247 1953247 defendant Hyllys John husbandman 596182 596182 Hyllys, John, of Muston, husbandman 0
4033279 2036557 2036557 defendant Sonsam or Sousam William husbandman 596182 596182 Sonsam or Sousam, William, of Muston, husbandman 0
4216368 2101217 2101217 defendant Sawnsam William husbandman 596182 596182 Sawnsam, William, of Muston, husbandman 2
4216369 2101217 2101217 defendant Lynne John husbandman 596182 596182 Lynne, John, of Muston, husbandman 3
4218657 2102023 2102023 defendant Sanysham William husbandman 596182 596182 Sanysham, William, of Muston, husbandman 0
4218658 2102023 2102023 defendant Woodford Thomas gent 596182 596182 Woodford, Thomas, of Muston, gent 1
4218696 2102039 2102039 defendant Treve alias Longe John husbandman 596182 596182 Treve alias Longe, John, of Muston, husbandman 0
4223000 2103535 2103535 defendant Nicolls Richard husbandman 596182 596182 Nicolls, Richard, of Muston, husbandman 0
4231461 2106503 2106503 defendant Dynham George gent 596182 596182 Dynham, George, of Muston, or of Milkstidd , gent 0
4282714 2123858 2123858 defendant Hartoppe Thomas husbandman 596182 596182 Hartoppe, Thomas, of Muston, husbandman 2
4291897 2127179 2127179 defendant Nicholles Richard husbandman 596182 596182 Nicholles, Richard, of Muston, husbandman 0
4300620 2130319 2130319 defendant Nicholles Richard husbandman 596182 596182 Nicholles, Richard, of Muston, husbandman 0
4322588 2137969 2137969 defendant Norum William yeoman 596182 596182 Norum, William, of Muston, yeoman 0
4329380 2140137 2140137 defendant Woodforde Thomas gent 596182 596182 Woodforde, Thomas, of Muston, gent 0
4359336 2150498 2150498 defendant Sansom Richard husbandman 596182 596182 Sansom, Richard, of Muston, husbandman 1
4443765 2183020 2183020 plaintiff Charnells Norman   596182 596182 Charnells, Norman, of Muston, son of William 0
4499881 2200596 2200596 defendant Rygton Thomas de   596182 596182 Rygton, Thomas de, of Muston 0
4579202 2224977 2224977 defendant Messanger William   596182 596182 Messanger, William, of Muston 0
4739777 2277517 2277517 defendant Rigton Thomas husbandman 596182 596182 Rigton, Thomas, of Muston, husbandman 2
4749463 2280322 2280322 defendant Owethorp John clerk 596182 596182 Owethorp, John, of Muston, clerk 1
4782053 2290388 2290388 defendant Steynwath Roger husbandman 596182 596182 Steynwath, Roger, of Muston, husbandman 1
4877982 2320066 2320066 defendant Stevenson Nicholas husbandman 596182 596182 Stevenson, Nicholas, of Muston, husbandman 2
4895482 2325254 2325254 defendant Mangar or Maugar John miller 596182 596182 Mangar or Maugar, John, of Muston, miller 1
4936800 2337889 2337889 defendant Kylyng Richard husbandman 596182 596182 Kylyng, Richard, of Muston, husbandman 0
4999587 2356752 2356752 defendant Symson John miller 596182 596182 Symson, John, of Muston, miller 2
5073518 2378563 2378563 defendant Dalby William husbandman 596182 596182 Dalby, William, of Muston, husbandman 0
5094777 2384885 2384885 defendant Frandell William yeoman 596182 596182 Frandell, William, of Muston, yeoman 0
5094778 2384885 2384885 defendant Stevenson John yeoman 596182 596182 Stevenson, John, of Muston, yeoman 1
5094779 2384885 2384885 defendant Fletmanby Roger husbandman 596182 596182 Fletmanby, Roger, of Muston, husbandman 2
5094780 2384885 2384885 defendant Symson William husbandman 596182 596182 Symson, William, of Muston, husbandman 3
5094781 2384885 2384885 defendant Carre John husbandman 596182 596182 Carre, John, of Muston, husbandman 4
5094902 2384924 2384924 defendant Dalby William yeoman 596182 596182 Dalby, William, of Muston, yeoman 2
5112472 2390034 2390034 defendant Fayrechilde William chaplain 596182 596182 Fayrechilde, William, of Muston, chaplain 0
5126759 2394303 2394303 defendant Lowe Henry yeoman 596182 596182 Lowe, Henry, of Muston, yeoman 1
5127389 2394493 2394493 defendant Lowe Henry yeoman 596182 596182 Lowe, Henry, of Muston, yeoman 0
5138132 2397661 2397661 defendant Elston Henry husbandman 596182 596182 Elston, Henry, of Muston, husbandman 0
5145472 2399820 2399820 defendant Lowe Henry yeoman 596182 596182 Lowe, Henry, of Muston, yeoman 0
5223686 2422612 2422612 defendant Dalby Aunger husbandman 596182 596182 Dalby, Aunger, of Muston, husbandman 0
5223687 2422612 2422612 defendant Dalby William husbandman 596182 596182 Dalby, William, of Muston, husbandman 1
5248937 2429814 2429814 plaintiff Thomas William (legal representative) 596182 596182 Thomas, William, of Muston, gent, executors of 0
5286717 2441123 2441123 defendant Bekwith William esq 596182 596182 Bekwith, William, of Muston, esq 0
5297452 2444256 2444256 defendant Talbone Ralph gent 596182 596182 Talbone, Ralph, of Muston, gent 2
5304446 2446327 2446327 defendant Beckewyth William gent 596182 596182 Beckewyth, William, of Muston, gent 0
5335733 2455752 2455752 defendant House Richard husbandman 596182 596182 House, Richard, of Muston, husbandman 1
5338697 2456673 2456673 defendant Taillour John clerk 596182 596182 Taillour, John, of Muston, clerk 4
5490125 2501928 2501928 defendant Hasylwod William, junior husbandman 596182 596182 Hasylwod, William, junior, of Muston, husbandman 1
5542179 2517684 2517684 defendant Markham Jerome gent 596182 596182 Markham, Jerome, of Muston, gent 0
5542181 2517685 2517685 defendant Markham Jerome gent 596182 596182 Markham, Jerome, of Muston, gent 0
5622224 2550871 2550871 defendant Raygate William de   596182 596182 Raygate, William de, of Muston 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);