names

53 rows where place_id = 619172

✎ 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
3602751 1868527 1868527 plaintiff Cheyne Thomas   619172 619172 Cheyne, Thomas, of Dytton, knight 0
3728539 1935176 1935176 plaintiff Wyng Robert yeoman 619172 619172 Wyng, Robert, of Dytton, yeoman 0
3728541 1935177 1935177 plaintiff Wyng Robert yeoman 619172 619172 Wyng, Robert, of Dytton, yeoman 0
3744419 1940156 1940156 defendant Rouse William husbandman 619172 619172 Rouse, William, of Dytton, husbandman 1
3763816 1946327 1946327 defendant Fenne John beer brewer 619172 619172 Fenne, John, of Dytton, beer brewer 0
3786380 1953526 1953526 defendant Holland Lawrence gent 619172 619172 Holland, Lawrence, of Dytton, gent 0
3797631 1957156 1957156 defendant Mosse John husbandman 619172 619172 Mosse, John, of Dytton, husbandman 3
3820171 1964188 1964188 defendant Holland Lawrence gent 619172 619172 Holland, Lawrence, of Dytton, gent 0
3820173 1964188 1964188 defendant Shakeley John gent 619172 619172 Shakeley, John, of Dytton, gent 2
3856727 1975732 1975732 defendant Mylles Edmund husbandman 619172 619172 Mylles, Edmund, of Dytton, husbandman 0
3863288 1977917 1977917 defendant Taylour Andrew husbandman 619172 619172 Taylour, Andrew, of Dytton, husbandman 3
3877296 1982649 1982649 defendant Woldryche Joan   619172 619172 Woldryche, Joan, of Dytton, widow, formerly Reylond, Joan 1
3884898 1985221 1985221 defendant Nele John husbandman 619172 619172 Nele, John, of Dytton, husbandman 3
3884904 1985222 1985222 defendant Nele John husbandman 619172 619172 Nele, John, of Dytton, husbandman 3
3924754 1998597 1998597 defendant Affeld John yeoman 619172 619172 Affeld, John, of Dytton, yeoman 0
3929819 2000312 2000312 defendant Brewer Richard yeoman 619172 619172 Brewer, Richard, of Dytton, yeoman 0
3939709 2003584 2003584 defendant Bruer Richard yeoman 619172 619172 Bruer, Richard, of Dytton, yeoman 0
4203653 2096835 2096835 defendant Isasonn Henry, senior yeoman 619172 619172 Isasonn, Henry, senior, of Dytton, yeoman 0
4260287 2116407 2116407 defendant Johnson Anthony Master of Arts 619172 619172 Johnson, Anthony, of Dytton, Master of Arts 0
4270644 2119760 2119760 defendant Morden Thomas yeoman 619172 619172 Morden, Thomas, of Dytton, yeoman 0
4340207 2143837 2143837 defendant Nyccolles John, senior yeoman 619172 619172 Nyccolles, John, senior, of Dytton, yeoman 0
4340208 2143837 2143837 defendant Nycolls John, junior yeoman 619172 619172 Nycolls, John, junior, of Dytton, yeoman 1
4390052 2161294 2161294 defendant Nicoll John, senior yeoman 619172 619172 Nicoll, John, senior, of Dytton, yeoman 0
4390053 2161294 2161294 defendant Nicoll John, junior yeoman 619172 619172 Nicoll, John, junior, of Dytton, yeoman 1
4404168 2165964 2165964 defendant Thomas David husbandman 619172 619172 Thomas, David, of Dytton, husbandman 0
4404169 2165964 2165964 defendant David Richard husbandman 619172 619172 David, Richard, of Dytton, husbandman 1
4404261 2165996 2165996 defendant Thomas David husbandman 619172 619172 Thomas, David, of Dytton, husbandman 1
4404262 2165996 2165996 defendant David Richard husbandman 619172 619172 David, Richard, of Dytton, husbandman 2
4565399 2220747 2220747 plaintiff Smyth John   619172 619172 Smyth, John, of Dytton 0
4565401 2220748 2220748 plaintiff Smyth John   619172 619172 Smyth, John, of Dytton 0
4593786 2229328 2229328 defendant Rede William   619172 619172 Rede, William, of Dytton 0
4593787 2229328 2229328 defendant London Thomas   619172 619172 London, Thomas, of Dytton 1
4654334 2247230 2247230 defendant Leche John husbandman 619172 619172 Leche, John, of Dytton, husbandman 1
4690057 2262442 2262442 defendant Mannynges John husbandman 619172 619172 Mannynges, John, of Dytton, husbandman 0
4710598 2268670 2268670 defendant Everard Robert laborer 619172 619172 Everard, Robert, of Dytton, laborer 2
4780960 2290048 2290048 defendant Halle William gent 619172 619172 Halle, William, of Dytton, gent 1
4796060 2294920 2294920 defendant Rennewell Nicholas husbandman 619172 619172 Rennewell, Nicholas, of Dytton, husbandman 0
4811553 2299722 2299722 defendant Basymer John husbandman 619172 619172 Basymer, John, of Dytton, husbandman 0
4839296 2308217 2308217 defendant Colyn Walter husbandman 619172 619172 Colyn, Walter, of Dytton, husbandman 0
4839297 2308217 2308217 defendant Colyn John husbandman 619172 619172 Colyn, John, of Dytton, husbandman 1
4896978 2325704 2325704 defendant Knyght John husbandman 619172 619172 Knyght, John, of Dytton, husbandman 0
4924785 2334186 2334186 plaintiff Orney Thomas (legal representative) 619172 619172 Orney, Thomas, of Dytton, executors of 0
4937345 2338047 2338047 defendant Vause or Vanse Ralph   619172 619172 Vause or Vanse, Ralph, of Dytton, hurdle maker 0
4937346 2338047 2338047 defendant Dowe John husbandman 619172 619172 Dowe, John, of Dytton, husbandman 1
5288544 2441666 2441666 defendant Castell Robert pewterer 619172 619172 Castell, Robert, of Dytton, or of London, pewterer 0
5299663 2444870 2444870 defendant Dan John yeoman 619172 619172 together with Dan, John, of Dytton, yeoman 1
5342599 2457885 2457885 defendant Martyn Robert laborer 619172 619172 Martyn, Robert, of Dytton, laborer 2
5366243 2465103 2465103 defendant Harwall John husbandman 619172 619172 Harwall, John, of Dytton, husbandman 6
5375173 2467823 2467823 defendant Usbarn William husbandman 619172 619172 Usbarn, William, of Dytton, husbandman 1
5378495 2468859 2468859 defendant Atwodde Thomas butcher 619172 619172 Atwodde, Thomas, of Dytton, butcher 0
5445052 2488408 2488408 defendant Lovelet Thomas carpenter 619172 619172 Lovelet, Thomas, of Dytton, carpenter 0
5530357 2514005 2514005 defendant Moryell John husbandman 619172 619172 Moryell, John, of Dytton, husbandman 2
5574908 2527233 2527233 defendant Culter Clement husbandman 619172 619172 Culter, Clement, of Dytton, 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);