names

51 rows where place_id = 596335

✎ 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
3624275 1875126 1875126 defendant Letlowere Randolph gent 596335 596335 Letlowere, Randolph, of Tathewell, gent 0
3624277 1875127 1875127 defendant Letlowere Randolph gent 596335 596335 Letlowere, Randolph, of Tathewell, gent 0
3727706 1934934 1934934 defendant Fallowes Richard clerk 596335 596335 Fallowes, Richard, of Tathewell, clerk 2
3748661 1941508 1941508 defendant Hotoft William husbandman 596335 596335 Hotoft, William, of Tathewell, husbandman 1
3760468 1945278 1945278 defendant Sherman John husbandman 596335 596335 Sherman, John, of Tathewell, husbandman 0
3826464 1966125 1966125 defendant Dewe John husbandman 596335 596335 Dewe, John, of Tathewell, husbandman 1
3826465 1966125 1966125 defendant Bery Robert husbandman 596335 596335 Bery, Robert, of Tathewell, husbandman 2
3836820 1969418 1969418 defendant Lyndsey Geoffrey gent 596335 596335 (Lyndsey, Geoffrey, of Tathewell, gent 1
3848602 1973147 1973147 defendant Lyndesey Godfrey gent 596335 596335 Lyndesey, Godfrey, of Tathewell, gent 1
3877673 1982774 1982774 defendant Huttoft Robert yeoman 596335 596335 Huttoft, Robert, of Tathewell, yeoman 0
3897625 1989420 1989420 defendant Billesby Thomas gent 596335 596335 Billesby, Thomas, of Tathewell, gent 0
4075724 2051623 2051623 defendant Haseley Andrew husbandman 596335 596335 Haseley, Andrew, of Tathewell, husbandman 1
4094258 2058281 2058281 defendant Hanson George clerk 596335 596335 Hanson, George, of Tathewell, clerk 0
4101148 2060720 2060720 defendant Johnson John husbandman 596335 596335 Johnson, John, of Tathewell, husbandman 0
4137388 2073721 2073721 defendant Wylson William yeoman 596335 596335 Wylson, William, of Tathewell, yeoman 0
4151928 2078784 2078784 defendant Hanson George clerk 596335 596335 Hanson, George, of Tathewell, clerk 1
4157492 2080694 2080694 defendant Hanson George clerk 596335 596335 Hanson, George, of Tathewell, clerk 1
4163285 2082687 2082687 defendant Wilson William yeoman 596335 596335 Wilson, William, of Tathewell, yeoman 0
4169688 2084888 2084888 defendant Hanson george clerk 596335 596335 Hanson, george, of Tathewell, clerk 2
4449880 2184916 2184916 defendant Wycroft Thomas   596335 596335 Wycroft, Thomas, of Tathewell 0
4560355 2219178 2219178 defendant Clerynge William   596335 596335 Clerynge, William, of Tathewell 0
4686768 2261474 2261474 defendant Smyth John husbandman 596335 596335 Smyth, John, of Tathewell, husbandman 0
4825873 2304124 2304124 defendant North Ralph husbandman 596335 596335 North, Ralph, of Tathewell, husbandman 0
4835274 2307032 2307032 plaintiff del See Robert (legal representative) 596335 596335 del See, Robert, of Tathewell, esq, executors of 0
4835275 2307032 2307032 plaintiff Sketell William   596335 596335 Sketell, William, of Tathewell 1
4862642 2315302 2315302 plaintiff del See Robert (legal representative) 596335 596335 del See, Robert, of Tathewell, esq, executors of 0
4862644 2315302 2315302 plaintiff Sketell William   596335 596335 Sketell, William, of Tathewell 2
4876790 2319713 2319713 defendant Ferthyngton John chaplain 596335 596335 Ferthyngton, John, of Tathewell, chaplain 0
4887806 2323015 2323015 defendant Gey or Geny Thomas (legal representative) 596335 596335 Gey or Geny, Thomas, of Tathewell, executors of 0
4983489 2351976 2351976 defendant Yerburgh William yeoman 596335 596335 Yerburgh, William, of Tathewell, yeoman 0
5026755 2364696 2364696 defendant Tathewell John gent 596335 596335 Tathewell, John, of Tathewell, gent 0
5265644 2435007 2435007 plaintiff Tathewell John esq 596335 596335 Tathewell, John, of Tathewell, esq 0
5320417 2451188 2451188 defendant North Thomas husbandman 596335 596335 North, Thomas, of Tathewell, husbandman 0
5320419 2451189 2451189 defendant North Thomas husbandman 596335 596335 North, Thomas, of Tathewell, husbandman 0
5330292 2454134 2454134 plaintiff Tathewell John   596335 596335 Tathewell, John, of Tathewell 1
5330295 2454135 2454135 plaintiff Tathewell John   596335 596335 Tathewell, John, of Tathewell 1
5344872 2458557 2458557 defendant Skedyll Thomas husbandman 596335 596335 Skedyll, Thomas, of Tathewell, husbandman 0
5344873 2458557 2458557 defendant Marchall William husbandman 596335 596335 Marchall, William, of Tathewell, husbandman 1
5400755 2475279 2475279 defendant Marshal William husbandman 596335 596335 Marshal, William, of Tathewell, husbandman 2
5400756 2475279 2475279 defendant Skytell Robert husbandman 596335 596335 Skytell, Robert, of Tathewell, husbandman 3
5413756 2479041 2479041 defendant Marshall William husbandman 596335 596335 with Marshall, William, of Tathewell, husbandman 2
5413757 2479041 2479041 defendant S_ Robert husbandman 596335 596335 S_, Robert, of Tathewell, husbandman 3
5443485 2487962 2487962 defendant Hotoft Thomas   596335 596335 Hotoft, Thomas, of Tathewell 1
5468008 2495374 2495374 defendant Hotoft Thomas yeoman 596335 596335 Hotoft, Thomas, of Tathewell, yeoman 3
5470486 2496092 2496092 defendant Marshall William husbandman 596335 596335 Marshall, William, of Tathewell, husbandman 2
5470487 2496092 2496092 defendant Skytell Robert husbandman 596335 596335 Skytell, Robert, of Tathewell, husbandman 3
5494754 2503321 2503321 defendant Marshall William husbandman 596335 596335 Marshall, William, of Tathewell, husbandman 1
5494755 2503321 2503321 defendant Skyttyll Robert husbandman 596335 596335 Skyttyll, Robert, of Tathewell, husbandman 2
5546257 2518897 2518897 defendant Sketyll Robert yeoman 596335 596335 Sketyll, Robert, of Tathewell, yeoman 0
5586696 2530878 2530878 plaintiff Lytlor Randolph yeoman 596335 596335 Lytlor, Randolph, of Tathewell, yeoman 0
5605258 2536523 2536523 defendant Dyan John   596335 596335 Dyan, John, of Tathewell 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);