names

91 rows where place_id = 592439

✎ 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
3607699 1870062 1870062 defendant Arcquyte William yeoman 592439 592439 Arcquyte, William, of Baldok, Herts, yeoman 0
3613556 1871888 1871888 defendant Sheldon Richard gent 592439 592439 (Sheldon, Richard, of Baldok, Herts, gent 1
3634716 1905651 1905651 defendant Wydney Thomas husbandman 592439 592439 Wydney, Thomas, of Baldok, Herts, husbandman 2
3717239 1931678 1931678 defendant Underwood Henry husbandman 592439 592439 Underwood, Henry, of Baldok, Herts, husbandman 3
3743991 1940010 1940010 defendant Hyllys Thomas smith or maltman 592439 592439 Hyllys, Thomas, of Baldok, Herts, smith or maltman 0
3791776 1955271 1955271 defendant Hyllys Thomas husbandman 592439 592439 Hyllys, Thomas, of Baldok, Herts, husbandman 0
3881287 1984009 1984009 defendant Symson William chapman 592439 592439 Symson, William, of Baldok, Herts, chapman 2
4519857 2206561 2206561 defendant Clyfton Richard   592439 592439 Clyfton, Richard, of Baldok, Herts 0
4590525 2228397 2228397 defendant Elys Richard   592439 592439 Elys, Richard, of Baldok, Herts 2
4590537 2228399 2228399 defendant Elys Richard   592439 592439 Elys, Richard, of Baldok, Herts 2
4637479 2242514 2242514 defendant Fache John   592439 592439 Fache, John, of Baldok, Herts 0
4654417 2247256 2247256 defendant Ropere John husbandman 592439 592439 Ropere, John, of Baldok, Herts, husbandman 0
4655956 2247740 2247740 defendant Cliston or Clifton Richard yeoman 592439 592439 Cliston or Clifton, Richard, of Baldok, Herts, yeoman 2
4683365 2260398 2260398 defendant Clifton Richard yeoman 592439 592439 Clifton, Richard, of Baldok, Herts, yeoman 5
4719587 2271468 2271468 defendant Clifton Walter   592439 592439 Clifton, Walter, of Baldok, Herts, horse dealer 0
4748674 2280100 2280100 defendant Rasshe John gent 592439 592439 Rasshe, John, of Baldok, Herts, gent 2
4748688 2280101 2280101 defendant Rasshe John gent 592439 592439 Rasshe, John, of Baldok, Herts, gent 2
4787683 2292217 2292217 defendant atte Hille Roger chandler 592439 592439 atte Hille, Roger, of Baldok, herts, chandler 3
4791991 2293601 2293601 defendant de Paule Peter gent 592439 592439 de Paule, Peter, of Baldok, Herts, gent 2
4791996 2293602 2293602 defendant de Paule Peter gent 592439 592439 de Paule, Peter, of Baldok, Herts, gent 2
4814187 2300542 2300542 defendant Poley John yeoman 592439 592439 Poley, John, of Baldok, Herts, yeoman 1
4823092 2303306 2303306 defendant Rede Thomas husbandman 592439 592439 Rede, Thomas, of Baldok, Herts, husbandman 0
4876511 2319619 2319619 defendant Achillewe Thomas husbandman 592439 592439 Achillewe, Thomas, of Baldok, Herts, husbandman 1
4953773 2343088 2343088 defendant Sandon Thomas husbandman 592439 592439 Sandon, Thomas, of Baldok, Herts, husbandman 1
4958017 2344366 2344366 plaintiff Wodeward Richard   592439 592439 Wodeward, Richard, of Baldok, Herts 1
4958020 2344367 2344367 plaintiff Wodeward Richard   592439 592439 Wodeward, Richard, of Baldok, Herts 1
4959850 2344909 2344909 defendant Kylbygge Thomas butcher 592439 592439 Kylbygge, Thomas, of Baldok, Herts, butcher 2
4985527 2352588 2352588 defendant Kyng John tanner 592439 592439 Kyng, John, of Baldok, Herts, tanner 4
4985533 2352589 2352589 defendant Kyng John tanner 592439 592439 Kyng, John, of Baldok, Herts, tanner 4
5033548 2366695 2366695 defendant Paule Peter gent 592439 592439 Paule, Peter, of Baldok, Herts, gent 1
5049382 2371449 2371449 defendant Paule Peter gent 592439 592439 Paule, Peter, of Baldok, Herts, gent 0
5106694 2388384 2388384 defendant Gerard Thomas husbandman 592439 592439 Gerard, Thomas, of Baldok, Herts, husbandman 1
5109321 2389154 2389154 defendant Markham Robert clerk 592439 592439 Markham, Robert, of Baldok, Herts, clerk 0
5123823 2393423 2393423 defendant Wydney Thomas husbandman 592439 592439 Wydney, Thomas, of Baldok, Herts, husbandman 0
5123826 2393424 2393424 defendant Wydney Thomas husbandman 592439 592439 Wydney, Thomas, of Baldok, Herts, husbandman 0
5142262 2398856 2398856 defendant Balam John chapman 592439 592439 Balam, John, of Baldok, Herts, chapman 1
5163495 2405054 2405054 defendant Balam John chapman 592439 592439 Balam, John, of Baldok, Herts, chapman 0
5177135 2409003 2409003 defendant Balam John chapman 592439 592439 Balam, John, of Baldok, Herts, chapman 0
5213864 2419784 2419784 defendant Turney John   592439 592439 Turney, John, of Baldok, Herts, clerk, parson of St Mary Magdalene, Cowden, Kent 1
5235314 2425907 2425907 defendant Knotte William butcher 592439 592439 Knotte, William, of Baldok, Herts, butcher 4
5240732 2427499 2427499 defendant Draper Robert clerk 592439 592439 Draper, Robert, of Baldok, Herts, clerk 0
5241593 2427743 2427743 defendant Collop Roger miller 592439 592439 Collop, Roger, of Baldok, Herts, miller 1
5248698 2429742 2429742 defendant Balam John weaver 592439 592439 Balam, John, of Baldok, Herts, weaver 0
5253742 2431283 2431283 defendant Warner John yeoman 592439 592439 Warner, John, of Baldok, Herts, yeoman 0
5258275 2432706 2432706 defendant Papworth Eustace husbandman 592439 592439 Papworth, Eustace, of Baldok, Herts, husbandman 0
5271981 2436888 2436888 defendant Goderyche Thomas chandler 592439 592439 Goderyche, Thomas, of Baldok, Herts, chandler 5
5278466 2438808 2438808 defendant Balam Thomas fisher 592439 592439 Balam, Thomas, of Baldok, Herts, fisher 1
5279612 2439116 2439116 defendant Balam Thomas husbandman 592439 592439 Balam, Thomas, of Baldok, Herts, husbandman 0
5279616 2439117 2439117 defendant Balam Thomas husbandman 592439 592439 Balam, Thomas, of Baldok, Herts, husbandman 0
5282740 2440011 2440011 defendant Baleham Thomas fisher 592439 592439 Baleham, Thomas, of Baldok, Herts, fisher 0
5282742 2440012 2440012 defendant Baleham Thomas fisher 592439 592439 Baleham, Thomas, of Baldok, Herts, fisher 0
5293915 2443192 2443192 defendant Bal- Thomas fisher 592439 592439 Bal-, Thomas, of Baldok, Herts, fisher 0
5293917 2443193 2443193 defendant Balam Thomas fisher 592439 592439 Balam, Thomas, of Baldok, Herts, fisher 0
5296251 2443892 2443892 defendant Balam Thomas fisher 592439 592439 Balam, Thomas, of Baldok, Herts, fisher 4
5301049 2445269 2445269 defendant Knotte William butcher 592439 592439 Knotte, William, of Baldok, Herts, butcher 1
5305198 2446560 2446560 defendant Bole William chaplain 592439 592439 Bole, William, of Baldok, Herts, chaplain 3
5314785 2449463 2449463 defendant Mylleyn Roger mercer 592439 592439 Mylleyn, Roger, of Baldok, Herts, mercer 0
5322541 2451820 2451820 defendant Balam Thomas fisher 592439 592439 Balam, Thomas, of Baldok, Herts, fisher 1
5330592 2454241 2454241 defendant Ballam Thomas yeoman 592439 592439 Ballam, Thomas, of Baldok, Herts, yeoman 0
5337863 2456406 2456406 defendant Mylen Roger chapman 592439 592439 Mylen, Roger, of Baldok, Herts, chapman 2
5338068 2456477 2456477 defendant Draper Robert clerk 592439 592439 Draper, Robert, of Baldok, Herts, clerk 1
5359645 2463053 2463053 defendant Myllen Roger chapman 592439 592439 Myllen, Roger, of Baldok, Herts, chapman 0
5366345 2465127 2465127 defendant Knot William butcher 592439 592439 Knot, William, of Baldok, Herts, butcher 1
5397037 2474233 2474233 defendant Knot William butcher 592439 592439 Knot, William, of Baldok, Herts, butcher 2
5397041 2474234 2474234 defendant Knot William butcher 592439 592439 Knot, William, of Baldok, herts, butcher 2
5402580 2475812 2475812 defendant Dalker Richard yeoman 592439 592439 Dalker, Richard, of Baldok, Herts, yeoman 0
5418758 2480534 2480534 defendant Oxbrygge Thomas esq 592439 592439 Oxbrygge, Thomas, of Baldok, Herts, esq 1
5420649 2481100 2481100 defendant Mylleyn Roger chapman 592439 592439 Mylleyn, Roger, of Baldok, Herts, chapman 3
5431804 2484480 2484480 defendant Dalker Richard yeoman 592439 592439 Dalker, Richard, of Baldok, Herts, yeoman 0
5431807 2484481 2484481 defendant Dalker William yeoman 592439 592439 Dalker, William, of Baldok, Herts, yeoman 0
5434764 2485337 2485337 plaintiff Paule Richard gent 592439 592439 Paule, Richard, of Baldok, Herts, gent 0
5434767 2485338 2485338 plaintiff Paule Richard gent 592439 592439 Paule, Richard, of Baldok, Herts, gent 0
5436776 2485928 2485928 defendant Oxbrygg Thomas esq 592439 592439 Oxbrygg, Thomas, of Baldok, Herts, esq 1
5439514 2486753 2486753 defendant Myleyn Roger chapman 592439 592439 Myleyn, Roger, of Baldok, Herts, chapman 3
5440597 2487092 2487092 defendant Knot William butcher 592439 592439 Knot, William, of Baldok, Herts, butcher 0
5483511 2500015 2500015 defendant Dawer of Dalker Richard yeoman 592439 592439 Dawer of Dalker, Richard, of Baldok, Herts, yeoman 1
5485793 2500647 2500647 defendant Wright Simon cooper 592439 592439 Wright, Simon, of Baldok, Herts, cooper 0
5499076 2504663 2504663 defendant Daker William mercer 592439 592439 Daker, William, of Baldok, Herts, mercer 0
5499573 2504819 2504819 defendant Paule Richard gent 592439 592439 Paule, Richard, of Baldok, Herts, gent 0
5513672 2509127 2509127 defendant Dalker William chapman 592439 592439 Dalker, William, of Baldok, Herts, chapman 0
5517508 2510317 2510317 defendant Dalker William husbandman 592439 592439 Dalker, William, of Baldok, Herts, husbandman 0
5519457 2510933 2510933 defendant Bate John yeoman 592439 592439 Bate, John, of Baldok, Herts, yeoman 0
5519466 2510934 2510934 defendant Bate John yeoman 592439 592439 Bate, John, of Baldok, Herts, yeoman 0
5519482 2510936 2510936 defendant Bate John yeoman 592439 592439 Bate, John, of Baldok, Herts, yeoman 0
5526006 2512727 2512727 defendant Okkyll Richard carpenter 592439 592439 Okkyll, Richard, of Baldok, Herts, carpenter 1
5529165 2513635 2513635 defendant Symson Ralph draper 592439 592439 Symson, Ralph, of Baldok, Herts, draper 0
5544356 2518342 2518342 defendant Harcuyt William yeoman 592439 592439 Harcuyt, William, of Baldok, Herts, yeoman 1
5562910 2523743 2523743 plaintiff Yonge John butcher 592439 592439 Yonge, John, of Baldok, Herts, butcher 0
5625151 2551804 2551804 defendant Kelsey William chandler 592439 592439 Kelsey, William, of Baldok, Herts, chandler 0
5630940 2553686 2553686 defendant Clyfton Richard courser 592439 592439 Clyfton, Richard, of Baldok, Herts, courser 0
5632908 2554299 2554299 defendant Clyfton Richard courser 592439 592439 Clyfton, Richard, of Baldok, Herts, courser 2

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