names

89 rows where place_id = 589991

✎ 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
3599491 1867482 1867482 defendant Wheler Henry gent 589991 589991 Wheler, Henry, of Aldenham, Herts, gent 1
3629986 1904230 1904230 defendant Symonde Richard laborer 589991 589991 Symonde, Richard, of Aldenham, Herts, laborer 0
3648816 1910017 1910017 defendant Tayllour Robert maltman 589991 589991 Tayllour, Robert, of Aldenham, Herts, maltman 0
3731572 1936101 1936101 defendant Rogers John maltman 589991 589991 Rogers, John, of Aldenham, Herts, maltman 0
3740376 1938852 1938852 defendant Archer Thomas husbandman 589991 589991 Archer, Thomas, of Aldenham, Herts, husbandman 4
3743803 1939946 1939946 defendant Turnour John yeoman 589991 589991 Turnour, John, of Aldenham, Herts, yeoman 0
3744216 1940088 1940088 defendant Turnor John yeoman 589991 589991 Turnor, John, of Aldenham, Herts, yeoman 0
3824459 1965520 1965520 defendant Turnour John maltman 589991 589991 Turnour, John, of Aldenham, Herts, maltman 0
3824812 1965637 1965637 defendant Turnour John yeoman 589991 589991 Turnour, John, of Aldenham, Herts, yeoman 0
3841587 1970953 1970953 defendant Wrenche Robert maltman 589991 589991 Wrenche, Robert, of Aldenham, Herts, maltman 0
3841591 1970954 1970954 defendant Wrenche Robert maltman 589991 589991 Wrenche, Robert, of Aldenham, Herts, maltman 0
3841600 1970957 1970957 defendant Wrenche Robert maltman 589991 589991 Wrenche, Robert, of Aldenham, Herts, maltman 0
3850515 1973750 1973750 plaintiff Mores James gent 589991 589991 Mores, James, of Aldenham, Herts, gent 0
3865360 1978630 1978630 plaintiff Morres James gent 589991 589991 Morres, James, of Aldenham, Herts, gent 0
3871438 1980693 1980693 defendant Morice James gent 589991 589991 Morice, James, of Aldenham, Herts, gent 2
3874383 1981656 1981656 defendant Hamond Thomas maltman 589991 589991 Hamond, Thomas, of Aldenham, Herts, maltman 0
3906796 1992564 1992564 defendant Goodyere Richard gent 589991 589991 Goodyere, Richard, of Aldenham, Herts, gent 0
3968702 2013688 2013688 defendant Tayler Richard maktman 589991 589991 Tayler, Richard, of Aldenham, Herts, maktman 3
3971232 2014497 2014497 defendant Whasshe Anthony maltman 589991 589991 Whasshe, Anthony, of Aldenham, Herts, maltman 0
3971528 2014603 2014603 defendant Wykes Humphrey mealman 589991 589991 Wykes, Humphrey, of Aldenham, Herts, mealman 0
3977189 2016590 2016590 defendant Colte Robert gent 589991 589991 Colte, Robert, of Aldenham, Herts, gent 0
4011992 2029019 2029019 defendant Whasshe Anthony maltman 589991 589991 Whasshe, Anthony, of Aldenham, Herts, maltman 0
4049182 2042154 2042154 defendant Bolde Philip gent 589991 589991 Bolde, Philip, of Aldenham, Herts, gent 0
4049184 2042155 2042155 defendant Bolde Philip gent 589991 589991 Bolde, Philip, of Aldenham, Herts, gent 0
4073877 2050948 2050948 defendant Fox William maltman 589991 589991 Fox, William, of Aldenham, Herts, maltman 0
4094701 2058440 2058440 defendant Stepneth Robert esq 589991 589991 Stepneth, Robert, of Aldenham, Herts, esq 0
4107514 2062974 2062974 defendant Birchmore Richard husbandman 589991 589991 Birchmore, Richard, of Aldenham, Herts, husbandman 0
4119639 2067310 2067310 defendant Stepney John esq 589991 589991 Stepney, John, of Aldenham, Herts, esq 2
4120285 2067534 2067534 defendant Wrenche Henry yeoman 589991 589991 Wrenche, Henry, of Aldenham, Herts, yeoman 0
4143306 2075825 2075825 defendant Wrenche Henry yeoman 589991 589991 Wrenche, Henry, of Aldenham, Herts, yeoman 0
4176303 2087191 2087191 defendant Bonde John yeoman 589991 589991 Bonde, John, of Aldenham, Herts, yeoman 0
4176306 2087192 2087192 defendant Bonde John yeoman 589991 589991 Bonde, John, of Aldenham, Herts, yeoman 0
4178995 2088130 2088130 defendant Jenckes Henry gent 589991 589991 Jenckes, Henry, of Aldenham, Herts, gent 3
4207423 2098149 2098149 defendant Stepneth Robert gent 589991 589991 Stepneth, Robert, of Aldenham, Herts, or of East Ham, Essex, gent 0
4207425 2098150 2098150 defendant Stepneth Robert gent 589991 589991 Stepneth, Robert, of Aldenham, Herts, or of East Ham, gent 0
4222403 2103327 2103327 defendant Guye John maltman 589991 589991 Guye, John, of Aldenham, Herts, maltman 0
4228751 2105541 2105541 defendant Cade William esq 589991 589991 Cade, William, of Aldenham, Herts, esq 0
4269882 2119517 2119517 defendant Cade William gent 589991 589991 Cade, William, of Aldenham, Herts, gent 3
4270247 2119633 2119633 defendant Cade William esq 589991 589991 Cade, William, of Aldenham, Herts, esq 0
4290153 2126546 2126546 defendant Baylye Robert yeoman 589991 589991 Baylye, Robert, of Aldenham, Herts, yeoman 1
4293498 2127737 2127737 defendant Peacocke Walter yeoman 589991 589991 Peacocke, Walter, of Aldenham, Herts, yeoman 0
4293501 2127738 2127738 defendant Peacocke Walter yeoman 589991 589991 Peacocke, Walter, of Aldenham, Herts, yeoman 0
4319403 2136892 2136892 defendant Heydon Thomas yeoman 589991 589991 Heydon, Thomas, of Aldenham, Herts, yeoman 0
4330605 2140530 2140530 defendant Cade William gent 589991 589991 Cade, William, of Aldenham, Herts, gent 0
4350752 2147516 2147516 defendant Glover Robert maltman 589991 589991 Glover, Robert, of Aldenham, Herts, maltman 0
4392733 2162188 2162188 defendant Winkefeyld Philip yeoman 589991 589991 Winkefeyld, Philip, of Aldenham, Herts, yeoman 0
4401038 2164937 2164937 defendant Wyckes Thomas gent 589991 589991 Wyckes, Thomas, of Aldenham, Herts, gent 2
4784707 2291223 2291223 defendant Eldryche William husbandman 589991 589991 Eldryche, William, of Aldenham, Herts, husbandman 1
4796853 2295172 2295172 defendant atte Water Richard husbandman 589991 589991 atte Water, Richard, of Aldenham, Herts, husbandman 1
4813265 2300263 2300263 defendant Sagard Nicholas husbandman 589991 589991 Sagard, Nicholas, of Aldenham, Herts, husbandman 1
4825670 2304069 2304069 plaintiff Vayle Edmund maltman 589991 589991 Vayle, Edmund, of Aldenham, Herts, maltman, on his own account 0
4825672 2304070 2304070 plaintiff Vayle Edmund maltman 589991 589991 Vayle, Edmund, of Aldenham, Herts, maltman, on his own account 0
4840093 2308450 2308450 defendant Brewer Thomas butcher 589991 589991 Brewer, Thomas, of Aldenham, Herts, butcher 2
4893431 2324646 2324646 defendant Forster John husbandman 589991 589991 Forster, John, of Aldenham, Herts, husbandman 3
5022188 2363380 2363380 defendant Bysshop John husbandman 589991 589991 Bysshop, John, of Aldenham, Herts, husbandman 0
5022190 2363381 2363381 defendant Bysshop John husbandman 589991 589991 Bysshop, John, of Aldenham, Herts, husbandman 0
5024511 2364084 2364084 defendant Ayleworth John maltman 589991 589991 Ayleworth, John, of Aldenham, Herts, maltman 0
5047616 2370906 2370906 defendant Courteys Richard laborer 589991 589991 Courteys, Richard, of Aldenham, Herts, laborer 0
5059344 2374361 2374361 defendant Wolaton John yeoman 589991 589991 Wolaton, John, of Aldenham, Herts, yeoman 3
5068151 2376977 2376977 defendant Cressall John baker 589991 589991 Cressall, John, of Aldenham, Herts, baker 1
5094147 2384692 2384692 defendant Halle Stephen husbandman 589991 589991 Halle, Stephen, of Aldenham, Herts, husbandman 0
5116857 2391359 2391359 defendant Bysshop John husbandman 589991 589991 Bysshop, John, of Aldenham, Herts, husbandman 3
5134165 2396487 2396487 defendant Halle John husbandman 589991 589991 Halle, John, of Aldenham, Herts, husbandman 4
5137093 2397362 2397362 defendant Coupere Hugh husbandman 589991 589991 Coupere, Hugh, of Aldenham, Herts, husbandman 4
5157701 2403381 2403381 defendant Coupere Hugh husbandman 589991 589991 Coupere, Hugh, of Aldenham, Herts, husbandman 4
5241062 2427585 2427585 defendant Castell Richard smith 589991 589991 Castell, Richard, of Aldenham, Herts, smith 2
5287921 2441482 2441482 defendant Castell Richard smith 589991 589991 Castell, Richard, of Aldenham, Herts, smith 2
5287929 2441484 2441484 defendant Castell Richard smith 589991 589991 Castell, Richard, of Aldenham, Herts, smith 0
5303028 2445895 2445895 defendant Draper Richard   589991 589991 Draper, Richard, of Aldenham, Herts, tile maker 1
5327717 2453357 2453357 defendant Graunt John yeoman 589991 589991 Graunt, John, of Aldenham, Herts, yeoman 0
5329878 2454005 2454005 defendant Pycoll William blacksmith 589991 589991 Pycoll, William, of Aldenham, Herts, blacksmith 1
5334754 2455462 2455462 plaintiff Forster John maltman 589991 589991 Forster, John, of Aldenham, Herts, maltman 0
5363903 2464361 2464361 defendant Brounkels John laborer 589991 589991 Brounkels, John, of Aldenham, Herts, laborer 1
5374599 2467661 2467661 defendant Penne Ralph gent 589991 589991 Penne, Ralph, of Aldenham, Herts, gent 0
5380862 2469582 2469582 defendant Grene Henry husbandman 589991 589991 Grene, Henry, of Aldenham, Herts, husbandman 3
5381376 2469733 2469733 plaintiff Hall John (legal representative) 589991 589991 Hall, John, of Aldenham, Herts, Lincoln diocese, maltman, executrix of 0
5383136 2470251 2470251 defendant Gardener Thomas   589991 589991 Gardener, Thomas, of Aldenham, Herts, ash burner 0
5384054 2470526 2470526 defendant Grene Henry husbandman 589991 589991 Grene, Henry, of Aldenham, Herts, husbandman 3
5395479 2473784 2473784 defendant Stubbyng Henry   589991 589991 Stubbyng, Henry, of Aldenham, Herts, black smith 0
5408777 2477583 2477583 defendant Stubbyng Henry blacksmith 589991 589991 Stubbyng, Henry, of Aldenham, Herts, blacksmith 0
5481950 2499534 2499534 defendant Draper Richard husbandman 589991 589991 Draper, Richard, of Aldenham, Herts, husbandman 2
5488864 2501542 2501542 defendant Plotte John, junior husbandman 589991 589991 Plotte, John, junior, of Aldenham, Herts, husbandman 1
5552880 2520894 2520894 defendant Hamond Thomas maltman 589991 589991 Hamond, Thomas, of Aldenham, Herts, maltman 1
5562788 2523707 2523707 defendant Roger William yeoman 589991 589991 Roger, William, of Aldenham, Herts, yeoman 0
5581831 2529397 2529397 defendant Plotte John husbandman 589991 589991 Plotte, John, of Aldenham, Herts, husbandman 0
5595853 2533615 2533615 defendant Tourner John yeoman 589991 589991 Tourner, John, of Aldenham, Herts, yeoman 0
5608658 2537609 2537609 defendant Grene H-- husbandman 589991 589991 Grene, H--, of Aldenham, Herts, husbandman 2
5609229 2537791 2537791 defendant Penne Ralph gent 589991 589991 Penne, Ralph, of Aldenham, Herts, gent 0
5609687 2537926 2537926 defendant Gardener Thomas   589991 589991 Gardener, Thomas, of Aldenham, Herts, ash burner 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);