names

31 rows where place_id = 596982

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626819 1903238 1903238 defendant Travener Thomas clerk 596982 596982 Travener, Thomas, of Whaddon, Cams, clerk 2
3630367 1904335 1904335 defendant Newman John husbandman 596982 596982 Newman, John, of Whaddon, Cams, husbandman 0
4187817 2091241 2091241 defendant Moreley John gent 596982 596982 Moreley, John, of Whaddon, Cams, gent 0
4233479 2107226 2107226 defendant Ward Robert husbandman 596982 596982 Ward, Robert, of Whaddon, Cams, husbandman 0
4343083 2144851 2144851 defendant Halfeheide Henry gent 596982 596982 Halfeheide, Henry, of Whaddon, Cams, gent 0
4355626 2149192 2149192 defendant Halsehead or Halfehead Henry gent 596982 596982 Halsehead or Halfehead, Henry, of Whaddon, Cams, gent 1
4856939 2313548 2313548 defendant Wangworth William, junior husbandman 596982 596982 Wangworth, William, junior, of Whaddon, Cams, husbandman 1
4866791 2316577 2316577 defendant Goodman Edmund yeoman 596982 596982 Goodman, Edmund, of Whaddon, Cams, yeoman 0
4905458 2328301 2328301 defendant Chaleres John esq 596982 596982 Chaleres, John, of Whaddon, Cams, esq 0
4947095 2341084 2341084 defendant Mold William husbandman 596982 596982 Mold, William, of Whaddon, Cams, husbandman 1
4980528 2351116 2351116 defendant Okys John husbandman 596982 596982 Okys, John, of Whaddon, Cams, husbandman 0
4985119 2352476 2352476 defendant Seynt Clowe Edmund gent 596982 596982 Seynt Clowe, Edmund, of Whaddon, Cams, gent 1
5023579 2363807 2363807 defendant Chalers John   596982 596982 Chalers, John, of Whaddon, Cams, knight 1
5024622 2364113 2364113 defendant Chalers John esq or knight 596982 596982 Chalers, John, of Whaddon, Cams, esq or knight 4
5052445 2372327 2372327 defendant Chalers John   596982 596982 (Chalers, John, of Whaddon, Cams, knight 5
5052452 2372328 2372328 defendant Chalers John   596982 596982 (Chalers, John, of Whaddon, Cams, knight 5
5091671 2383952 2383952 defendant Berford John husbandman 596982 596982 Berford, John, of Whaddon, Cams, husbandman 0
5214304 2419917 2419917 defendant Barford Thomas yeoman 596982 596982 Barford, Thomas, of Whaddon, Cams, yeoman 0
5220993 2421839 2421839 defendant Dynnok John husbandman 596982 596982 Dynnok, John, of Whaddon, Cams, husbandman 1
5239718 2427204 2427204 defendant Hokett William husbandman 596982 596982 Hokett, William, of Whaddon, Cams, husbandman 2
5240743 2427501 2427501 defendant Dynnok John husbandman 596982 596982 Dynnok, John, of Whaddon, Cams, husbandman 1
5262594 2434044 2434044 defendant Berforthe Thomas husbandman 596982 596982 Berforthe, Thomas, of Whaddon, Cams, husbandman 1
5294033 2443227 2443227 defendant Spycer William husbandman 596982 596982 Spycer, William, of Whaddon, Cams, husbandman 1
5294047 2443232 2443232 defendant Spycer William husbandman 596982 596982 Spycer, William, of Whaddon, Cams, husbandman 1
5361202 2463529 2463529 defendant Spycer William husbandman 596982 596982 Spycer, William, of Whaddon, Cams, husbandman 0
5498734 2504565 2504565 defendant Thomas William husbandman 596982 596982 Thomas, William, of Whaddon, Cams, husbandman 4
5602378 2535641 2535641 defendant Mede James husbandman 596982 596982 Mede, James, of Whaddon, Cams, husbandman 0
5602379 2535641 2535641 defendant Dycon Richard husbandman 596982 596982 Dycon, Richard, of Whaddon, Cams, husbandman 1
5602383 2535642 2535642 defendant Mede James husbandman 596982 596982 Mede, James, of Whaddon, Cams, husbandman 0
5602384 2535642 2535642 defendant Dycon Richard husbandman 596982 596982 Dycon, Richard, of Whaddon, Cams, husbandman 1
5623976 2551446 2551446 defendant Heyre Thomas husbandman 596982 596982 Heyre, Thomas, of Whaddon, Cams, 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);