names

62 rows where place_id = 594910

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3618082 1873279 1873279 defendant Genyn or Jenyns Thomas smith 594910 594910 Genyn or Jenyns, Thomas, of Harpeden, smith 3
3637132 1906412 1906412 defendant Sebrok Thomas (legal representative) 594910 594910 Sebrok, Thomas, of Harpeden, husbandman, executrix of 0
3637133 1906412 1906412 defendant Sebroke Agnes widow 594910 594910 Sebroke, Agnes, of Harpeden, widow 1
3742786 1939600 1939600 defendant Halsey Thomas yeoman 594910 594910 Halsey, Thomas, of Harpeden, yeoman 0
3742787 1939600 1939600 defendant Threder Adam husbandman 594910 594910 Threder, Adam, of Harpeden, husbandman 1
3742788 1939600 1939600 defendant Kylby Thomas husbandman 594910 594910 Kylby, Thomas, of Harpeden, husbandman 2
3742789 1939600 1939600 defendant More John husbandman 594910 594910 More, John, of Harpeden, husbandman 3
3753911 1943170 1943170 defendant Cutte John yeoman 594910 594910 Cutte, John, of Harpeden, yeoman 1
3754936 1943493 1943493 defendant Halsey Thomas yeoman 594910 594910 Halsey, Thomas, of Harpeden, yeoman 0
3754937 1943493 1943493 defendant Threder Adan husbandman 594910 594910 Threder, Adan, of Harpeden, husbandman 1
3754938 1943493 1943493 defendant Kylby Thomas husbandman 594910 594910 Kylby, Thomas, of Harpeden, husbandman 2
3754939 1943493 1943493 defendant More John husbandman 594910 594910 More, John, of Harpeden, husbandman 3
3771087 1948646 1948646 defendant Cutte John yeoman 594910 594910 Cutte, John, of Harpeden, yeoman 1
3830283 1967365 1967365 defendant Saunder Robert laborer 594910 594910 Saunder, Robert, of Harpeden, laborer 0
3830284 1967365 1967365 defendant Auncell John laborer 594910 594910 Auncell, John, of Harpeden, laborer 1
3830285 1967365 1967365 defendant Seybroke John, junior laborer 594910 594910 Seybroke, John, junior, of Harpeden, laborer 2
3830287 1967366 1967366 defendant Saunder Robert laborer 594910 594910 Saunder, Robert, of Harpeden, laborer 0
3830288 1967366 1967366 defendant Auncell John laborer 594910 594910 Auncell, John, of Harpeden, laborer 1
3830289 1967366 1967366 defendant Seybroke John, junior laborer 594910 594910 Seybroke, John, junior, of Harpeden, laborer 2
3900382 1990362 1990362 defendant Bardolf Edward gent 594910 594910 Bardolf, Edward, of Harpeden, gent 0
3942349 2004455 2004455 defendant Chamber John husbandman 594910 594910 Chamber, John, of Harpeden, husbandman 0
3942350 2004455 2004455 defendant Chamber William husbandman 594910 594910 Chamber, William, of Harpeden, husbandman 1
3945650 2005553 2005553 defendant Ellys Thomas husbandman 594910 594910 Ellys, Thomas, of Harpeden, husbandman 0
4360946 2151087 2151087 defendant Buckmaster Thomas yeoman 594910 594910 Buckmaster, Thomas, of Harpeden, yeoman 1
4364176 2152243 2152243 defendant Buckemaster Thomas yeoman 594910 594910 Buckemaster, Thomas, of Harpeden, yeoman 1
4364179 2152244 2152244 defendant Buckemaster Thomas yeoman 594910 594910 Buckemaster, Thomas, of Harpeden, yeoman 1
4376503 2156665 2156665 defendant Flower alias Bazill John husbandman 594910 594910 Flower alias Bazill, John, of Harpeden, husbandman 1
4536865 2211803 2211803 defendant Ballard Jhn smith 594910 594910 Ballard, Jhn, of Harpeden, smith 3
4669432 2256146 2256146 defendant Ballard John husbandman 594910 594910 Ballard, John, of Harpeden, husbandman 1
4931283 2336163 2336163 defendant Parker Thomas yeoman 594910 594910 Parker, Thomas, of Harpeden, yeoman 0
4931284 2336163 2336163 defendant Coke John yeoman 594910 594910 Coke, John, of Harpeden, yeoman 1
4931285 2336163 2336163 defendant atte Hill Nicholas yeoman 594910 594910 atte Hill, Nicholas, of Harpeden, yeoman 2
5027148 2364808 2364808 defendant Tourys John husbandman 594910 594910 Tourys, John, of Harpeden, husbandman 0
5106242 2388263 2388263 defendant Chapell Richard husbandman 594910 594910 Chapell, Richard, of Harpeden, husbandman 3
5106243 2388263 2388263 defendant Trappe William husbandman 594910 594910 Trappe, William,of Harpeden, husbandman 4
5106244 2388263 2388263 defendant Vyall Thomas weaver 594910 594910 Vyall, Thomas, of Harpeden, weaver 5
5106250 2388265 2388265 defendant Ballard William husbandman 594910 594910 Ballard, William, of Harpeden, husbandman 2
5106251 2388265 2388265 defendant Terry John husbandman 594910 594910 Terry, John, of Harpeden, husbandman 3
5107504 2388624 2388624 defendant Skot Ralph laborer 594910 594910 Skot, Ralph, of Harpeden, laborer 2
5107507 2388625 2388625 defendant Clerk John butcher 594910 594910 Clerk, John, of Harpeden, butcher 1
5107508 2388625 2388625 defendant Skot Ralph laborer 594910 594910 Skot, Ralph, of Harpeden, laborer 2
5240050 2427291 2427291 defendant Hunte Roger (legal representative) 594910 594910 Hunte, Roger, of Harpeden, executors of 0
5260846 2433514 2433514 defendant Saybroke Thomas husbandman 594910 594910 Saybroke, Thomas, of Harpeden, husbandman 1
5261279 2433639 2433639 defendant Catelyn Richard (legal representative) 594910 594910 Catelyn, Richard, of Harpeden, executors of 2
5261280 2433639 2433639 defendant Whityng Richard husbandman 594910 594910 (Whityng, Richard, of Harpeden, husbandman 3
5261284 2433640 2433640 defendant Catelyn Richard (legal representative) 594910 594910 Catelyn, Richard, of Harpeden, executors of 2
5277077 2438382 2438382 defendant Terry John husbandman 594910 594910 Terry, John, of Harpeden, husbandman 0
5326054 2452885 2452885 defendant Hill William miller 594910 594910 (Hill, William, of Harpeden, miller 1
5348512 2459674 2459674 defendant Ballard William husbandman 594910 594910 Ballard, William, of Harpeden, husbandman 1
5348517 2459675 2459675 defendant Ballard William husbandman 594910 594910 Ballard, William, of Harpeden, husbandman 1
5380675 2469521 2469521 defendant Hunt William husbandman 594910 594910 Hunt, William, of Harpeden, husbandman 0
5380676 2469521 2469521 defendant Hunt John carpenter 594910 594910 Hunt, John, of Harpeden, carpenter 1
5385620 2470959 2470959 defendant Hunt William husbandman 594910 594910 Hunt, William, of Harpeden, husbandman 0
5385621 2470959 2470959 defendant Hunt John carpenter 594910 594910 Hunt, John, of Harpeden, carpenter 1
5385622 2470959 2470959 defendant Hunt John laborer 594910 594910 Hunt, John, of Harpeden, laborer 2
5385623 2470959 2470959 defendant Cutte John husbandman 594910 594910 Cutte, John, of Harpeden, husbandman 3
5385624 2470959 2470959 defendant Hunt Roger husbandman 594910 594910 Hunt, Roger, of Harpeden, husbandman 4
5479437 2498866 2498866 defendant Spayne Thomas husbandman 594910 594910 Spayne, Thomas, of Harpeden, husbandman 0
5495688 2503606 2503606 defendant Whitlok alias Nele Nicholas husbandman 594910 594910 Whitlok alias Nele, Nicholas, of Harpeden, husbandman 2
5495689 2503606 2503606 defendant Byller Richard husbandman 594910 594910 Byller, Richard, of Harpeden, husbandman 3
5495694 2503607 2503607 defendant Whitlok alias Nele Nicholas husbandman 594910 594910 Whitlok alias Nele, Nicholas, of Harpeden, husbandman 2
5495695 2503607 2503607 defendant Byller Richard husbandman 594910 594910 Byller, Richard, of Harpeden, husbandman 3

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);